ATUL_v1.Atul_v1Data.CreateActivity C# (CSharp) Method

        public long CreateActivity(long AtulProcessID, long AtulSubProcessID, string ActivityDescription, string ActivitySummary, string ActivityProcedure, bool deadlineResultsInMissed, int AtulActivitySortOrder, int CreatedBy, int OwnedBy, int deadline, int deadlineTypeID)
        {
            long activityId = 0;
            int? blankID = null;
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ActivityInsert_sp @AtulSubProcessID, @ActivityDescription, @ActivitySummary, @ActivityProcedure, @AtulActivitySortOrder, @CreatedBy, @OwnedBy, @AtulProcessID, @ProcessActivitySortOrder, @AutomationServiceProviderID, @AutomationTriggerActivityGroupID, @AutomationIdentifier, @AutomationExpectedDuration, @PrerequisiteActivityGroupID, @AtulDeadlineTypeID, @DeadlineActivityGroupID, @DeadlineResultsInMissed, @DeadlineOffset", this._connection);
            cmd.Parameters.Add(new SqlParameter("@AtulSubProcessID", AtulSubProcessID));
            cmd.Parameters.Add(new SqlParameter("@ActivityDescription", ActivityDescription));
            cmd.Parameters.Add(new SqlParameter("@ActivitySummary", ActivitySummary));
            cmd.Parameters.Add(new SqlParameter("@ActivityProcedure", ActivityProcedure));
            cmd.Parameters.Add(new SqlParameter("@AtulActivitySortOrder", AtulActivitySortOrder));
            cmd.Parameters.Add(new SqlParameter("@CreatedBy", CreatedBy));
            cmd.Parameters.Add(new SqlParameter("@OwnedBy", OwnedBy));
            cmd.Parameters.Add(new SqlParameter("@AtulProcessID", AtulProcessID));
            cmd.Parameters.Add(new SqlParameter("@ProcessActivitySortOrder", AtulActivitySortOrder));
            cmd.Parameters.Add(new SqlParameter("@AutomationServiceProviderID", blankID));
            cmd.Parameters.Add(new SqlParameter("@AutomationTriggerActivityGroupID", blankID));
            cmd.Parameters.Add(new SqlParameter("@AutomationIdentifier", string.Empty));
            cmd.Parameters.Add(new SqlParameter("@AutomationExpectedDuration", blankID));
            cmd.Parameters.Add(new SqlParameter("@PrerequisiteActivityGroupID", blankID));
            cmd.Parameters.Add(new SqlParameter("@AtulDeadlineTypeID", deadlineTypeID));
            cmd.Parameters.Add(new SqlParameter("@DeadlineActivityGroupID", blankID));
            cmd.Parameters.Add(new SqlParameter("@DeadlineResultsInMissed", deadlineResultsInMissed));
            cmd.Parameters.Add(new SqlParameter("@DeadlineOffset", deadline));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable();
            da.Fill(returnTable);
            DataRow r = returnTable.Rows[0];
            activityId = Convert.ToInt64(r["AtulActivityID"]);
            return activityId;
        }

 /// <summary>
 /// Creates the activity.
 /// </summary>
 /// <param name="AtulSubProcessID">The atul sub process ID.</param>
 /// <param name="ActivityDescription">The activity description.</param>
 /// <param name="ActivitySummary">The activity summary.</param>
 /// <param name="ActivityProcedure">The activity procedure.</param>
 /// <param name="AtulActivitySortOrder">The atul activity sort order.</param>
 /// <param name="CreatedBy">The created by ID.</param>
 /// <param name="OwnedBy">The owned by ID.</param>
 /// <returns></returns>
 public long CreateActivity(string processID, string subProcessID, string ActivityDescription, string ActivitySummary, string ActivityProcedure, bool deadlineResultsInMissed, int AtulActivitySortOrder, int CreatedBy, int OwnedBy, int deadline, int deadlineTypeID)
 {
     long activityId = 0;
     long AtulProcessID = Convert.ToInt64(processID);
     long AtulSubProcessID = Convert.ToInt64(subProcessID);
     Atul_v1Data adb = new Atul_v1Data();
     activityId = adb.CreateActivity(AtulProcessID, AtulSubProcessID, ActivityDescription, ActivitySummary, ActivityProcedure,
         deadlineResultsInMissed, AtulActivitySortOrder, CreatedBy, OwnedBy, deadline, deadlineTypeID);
     return activityId;
 }