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;
}