public CreateInstanceProcess ( long AtulProcessID, int CreatedBy, int OwnedBy, int AtulProcessStatusID, string SubjectIdentifier, string SubjectSummary ) : long | ||
AtulProcessID | long | The atul process ID. |
CreatedBy | int | The created by ID. |
OwnedBy | int | The owned by ID. |
AtulProcessStatusID | int | The atul process status ID. |
SubjectIdentifier | string | The identifier for the subject of the instance (e.g. server ID). |
SubjectSummary | string | The friendly name for the subject of the instance (e.g. host name). |
return | long |
public long CreateInstanceProcess(long AtulProcessID, int CreatedBy, int OwnedBy, int AtulProcessStatusID, string SubjectIdentifier, string SubjectSummary)
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_InstanceProcessInsert_sp @AtulProcessID, @CreatedBy, @OwnedBy, @AtulProcessStatusID, @SubjectIdentifier, @SubjectSummary", this._connection);
cmd.Parameters.Add(new SqlParameter("@AtulProcessID", AtulProcessID));
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("@SubjectIdentifier", SubjectIdentifier));
cmd.Parameters.Add(new SqlParameter("@SubjectSummary", SubjectSummary));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable();
da.Fill(returnTable);
DataRow r = returnTable.Rows[0];
long processInstanceId = Convert.ToInt64(r["AtulInstanceProcessID"]);
return processInstanceId;
}
/// <summary> /// Creates the instance process. /// </summary> /// <param name="AtulProcessID">The atul process ID.</param> /// <param name="CreatedBy">The created by ID.</param> /// <param name="OwnedBy">The owned by ID.</param> /// <param name="AtulProcessStatusID">The atul process status ID.</param> /// <returns></returns> public bool CreateInstanceProcess(string AtulProcessID, string CreatedBy, string OwnedBy, string AtulProcessStatusID) { bool success = false; Atul_v1Data adb = new Atul_v1Data(); success = adb.CreateInstanceProcess(Convert.ToInt32(AtulProcessID), Convert.ToInt32(CreatedBy), Convert.ToInt32(OwnedBy), Convert.ToInt32(AtulProcessStatusID)); return success; }