public UpdateInstanceProcessActivity ( int AtulInstanceProcessActivityID, int AtulInstanceProcessID, int AtulProcessActivityID, int ProcessActivityCompleted, int ProcessActivityDidNotApply, int ProcessActivityDeadlineMissed, int InstanceProcessActivityCompletedBy, int ModifiedBy ) : |
||
AtulInstanceProcessActivityID | int | The atul instance process activity ID. |
AtulInstanceProcessID | int | The atul instance process ID. |
AtulProcessActivityID | int | The atul process activity ID. |
ProcessActivityCompleted | int | The process activity completed. |
ProcessActivityDidNotApply | int | The process activity did not apply. |
ProcessActivityDeadlineMissed | int | The process activity deadline missed. |
InstanceProcessActivityCompletedBy | int | The instance process activity completed by. |
ModifiedBy | int | The modified by. |
return |
public DataTable UpdateInstanceProcessActivity(int AtulInstanceProcessActivityID, int AtulInstanceProcessID, int AtulProcessActivityID, int ProcessActivityCompleted, int ProcessActivityDidNotApply, int ProcessActivityDeadlineMissed, int InstanceProcessActivityCompletedBy, int ModifiedBy)
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_InstanceProcessActivityUpdate_sp @AtulInstanceProcessActivityID, @AtulInstanceProcessID, @AtulProcessActivityID, @ProcessActivityCompleted, @ProcessActivityDidNotApply, @ProcessActivityDeadlineMissed, @InstanceProcessActivityCompletedBy, @ModifiedBy", this._connection);
cmd.Parameters.Add(new SqlParameter("@AtulInstanceProcessActivityID", AtulInstanceProcessActivityID));
cmd.Parameters.Add(new SqlParameter("@AtulInstanceProcessID", AtulInstanceProcessID));
cmd.Parameters.Add(new SqlParameter("@AtulProcessActivityID", AtulProcessActivityID));
cmd.Parameters.Add(new SqlParameter("@ProcessActivityCompleted", ProcessActivityCompleted));
cmd.Parameters.Add(new SqlParameter("@ProcessActivityDidNotApply", ProcessActivityDidNotApply));
cmd.Parameters.Add(new SqlParameter("@ProcessActivityDeadlineMissed", ProcessActivityDeadlineMissed));
cmd.Parameters.Add(new SqlParameter("@InstanceProcessActivityCompletedBy", InstanceProcessActivityCompletedBy));
cmd.Parameters.Add(new SqlParameter("@ModifiedBy", ModifiedBy));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable(); returnTable.TableName = "atultbl";
da.Fill(returnTable);
return returnTable;
}
/// <summary> /// Updates the instance process activity. /// </summary> /// <param name="AtulInstanceProcessActivityID">The atul instance process activity ID.</param> /// <param name="AtulInstanceProcessID">The atul instance process ID.</param> /// <param name="AtulProcessActivityID">The atul process activity ID.</param> /// <param name="ProcessActivityCompleted">The process activity completed.</param> /// <param name="ProcessActivityDidNotApply">The process activity did not apply.</param> /// <param name="ProcessActivityDeadlineMissed">The process activity deadline missed.</param> /// <param name="InstanceProcessActivityCompletedBy">The instance process activity completed by.</param> /// <param name="ModifiedBy">The modified by.</param> /// <returns></returns> public string UpdateInstanceProcessActivity(string AtulInstanceProcessActivityID, string AtulInstanceProcessID, string AtulProcessActivityID, string ProcessActivityCompleted, string ProcessActivityDidNotApply, string ProcessActivityDeadlineMissed, string InstanceProcessActivityCompletedBy, string ModifiedBy) { DataTable returnTable = new DataTable(); Atul_v1Data adb = new Atul_v1Data(); returnTable = adb.UpdateInstanceProcessActivity(Convert.ToInt32(AtulInstanceProcessActivityID), Convert.ToInt32(AtulInstanceProcessID), Convert.ToInt32(AtulProcessActivityID), Convert.ToInt32(ProcessActivityCompleted), Convert.ToInt32(ProcessActivityDidNotApply), Convert.ToInt32(ProcessActivityDeadlineMissed), Convert.ToInt32(InstanceProcessActivityCompletedBy), Convert.ToInt32(ModifiedBy)); return JsonMethods.GetJSONString(returnTable); }