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