public CreateProcess ( string ProcessDescription, string ProcessSummary, int CreatedBy, int OwnedBy, int AtulProcessStatusID, int DeadLineOffset ) : long | ||
ProcessDescription | string | The process description. |
ProcessSummary | string | The process summary. |
CreatedBy | int | The created by. |
OwnedBy | int | The owned by. |
AtulProcessStatusID | int | The atul process status ID. |
DeadLineOffset | int | The dead line offset. |
return | long |
public long CreateProcess(string ProcessDescription, string ProcessSummary, int CreatedBy, int OwnedBy, int AtulProcessStatusID, int DeadLineOffset)
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_ProcessInsert_sp @ProcessDescription, @ProcessSummary, @CreatedBy, @OwnedBy, @AtulProcessStatusID, @DeadLineOffset", this._connection);
cmd.Parameters.Add(new SqlParameter("@ProcessDescription", ProcessDescription));
cmd.Parameters.Add(new SqlParameter("@ProcessSummary", ProcessSummary));
cmd.Parameters.Add(new SqlParameter("@CreatedBy", CreatedBy));
cmd.Parameters.Add(new SqlParameter("@OwnedBy", OwnedBy));
cmd.Parameters.Add(new SqlParameter("@AtulProcessStatusID", AtulProcessStatusID));
cmd.Parameters.Add(new SqlParameter("@DeadLineOffset", DeadLineOffset));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable();
da.Fill(returnTable);
DataRow r = returnTable.Rows[0];
long processId = Convert.ToInt64(r["AtulProcessID"]);
return processId;
}
/// <summary> /// Creates the process. /// </summary> /// <param name="ProcessDescription">The process description.</param> /// <param name="ProcessSummary">The process summary.</param> /// <param name="CreatedBy">The created by.</param> /// <param name="OwnedBy">The owned by.</param> /// <param name="AtulProcessStatusID">The atul process status ID.</param> /// <param name="AtulUserDefinedAttributeID">The atul user defined attribute ID.</param> /// <param name="DeadLineOffset">The dead line offset.</param> /// <returns></returns> public long CreateProcess(string ProcessDescription, string ProcessSummary, string CreatedBy, string OwnedBy, string AtulProcessStatusID, string DeadLineOffset) { long success = 0; Atul_v1Data adb = new Atul_v1Data(); success = adb.CreateProcess(ProcessDescription, ProcessSummary, Convert.ToInt32(CreatedBy), Convert.ToInt32(OwnedBy), Convert.ToInt32(AtulProcessStatusID), Convert.ToInt32(DeadLineOffset)); return success; }