ATUL_v1.Atul_v1Data.CreateSubProcess C# (CSharp) Method

CreateSubProcess() public method

Creates the sub process.
public CreateSubProcess ( string SubProcessDescription, string SubProcessSummary, int CreatedBy, int OwnedBy ) : long
SubProcessDescription string The sub process description.
SubProcessSummary string The sub process summary.
CreatedBy int The created by.
OwnedBy int The owned by.
return long
        public long CreateSubProcess(string SubProcessDescription, string SubProcessSummary, int CreatedBy, int OwnedBy)
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_SubProcessInsert_sp @SubProcessDescription, @SubProcessSummary, @CreatedBy, @OwnedBy", this._connection);
            cmd.Parameters.Add(new SqlParameter("@SubProcessDescription", SubProcessDescription));
            cmd.Parameters.Add(new SqlParameter("@SubProcessSummary", SubProcessSummary));
            cmd.Parameters.Add(new SqlParameter("@CreatedBy", CreatedBy));
            cmd.Parameters.Add(new SqlParameter("@OwnedBy", OwnedBy));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable();
            da.Fill(returnTable);
            DataRow r = returnTable.Rows[0];
            long subProcessId = Convert.ToInt64(r["AtulSubProcessID"]);
            return subProcessId;
        }

Usage Example

Beispiel #1
0
 public long CreateSubProcess(long AtulProcessID, string summary, string description, int sortOrder, string NotificationIdentifier, int ResponsibilityOf, int DeadlineOffset, int CreatedBy, int OwnedBy)
 {
     long subProcessId = 0;
     Atul_v1Data adb = new Atul_v1Data();
     subProcessId = adb.CreateSubProcess(description, summary, CreatedBy, OwnedBy);
     adb.AttachProcessSubProcess(AtulProcessID, subProcessId, sortOrder, NotificationIdentifier, ResponsibilityOf, DeadlineOffset, CreatedBy);
     return subProcessId;
 }
Atul_v1Data