public long CreateProcessSchedule(long ProcessID, string scheduleVersion, DateTime nextScheduled, string repeatSchedule, string instantiatedUsers)
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_ProcessScheduleInsert_sp @AtulProcessID, @RepeatSchedule, @NextScheduledDate, @ScheduleVersion, @InstantiatedUserList", this._connection);
cmd.Parameters.Add(new SqlParameter("@AtulProcessID", ProcessID));
cmd.Parameters.Add(new SqlParameter("@RepeatSchedule", repeatSchedule));
cmd.Parameters.Add(new SqlParameter("@NextScheduledDate", nextScheduled));
cmd.Parameters.Add(new SqlParameter("@ScheduleVersion", scheduleVersion));
cmd.Parameters.Add(new SqlParameter("@InstantiatedUserList", instantiatedUsers));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable();
da.Fill(returnTable);
DataRow r = returnTable.Rows[0];
long ScheduleID = Convert.ToInt64(r["AtulProcessScheduleID"]);
return ScheduleID;
}