ATUL_v1.Atul_v1Data.GetCurrentInstanceSubProcess C# (CSharp) Method

GetCurrentInstanceSubProcess() public method

Gets the current instance's sub process.
public GetCurrentInstanceSubProcess ( System.Int64 AtulInstanceProcessID ) : DataTable
AtulInstanceProcessID System.Int64 The atul instance process ID.
return System.Data.DataTable
        public DataTable GetCurrentInstanceSubProcess(Int64 AtulInstanceProcessID)
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_GetCurrentInstanceSubProcess_sp @AtulInstanceProcessID", this._connection);
            cmd.Parameters.Add(new SqlParameter("@AtulInstanceProcessID", AtulInstanceProcessID));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); returnTable.TableName = "atulinstanceSubProcess";
            da.Fill(returnTable);
            return returnTable;
        }

Usage Example

Example #1
0
 /// <summary>
 /// Gets the current instance sub process.
 /// </summary>
 /// <param name="AtulInstanceProcessID">The atul instance process ID.</param>
 /// <returns></returns>
 public string GetCurrentInstanceSubProcess(Int64 AtulInstanceProcessID)
 {
     DataTable returnTable = new DataTable();
     Atul_v1Data adb = new Atul_v1Data();
     returnTable = adb.GetCurrentInstanceSubProcess(AtulInstanceProcessID);
     this.ProcessCurrentSubProcessActor(AtulInstanceProcessID);
     return JsonMethods.GetJSONString(returnTable);
 }
Atul_v1Data