public CreateProcessSchedule ( long ProcessID, string scheduleVersion, System.DateTime nextScheduled, string repeatSchedule, string instantiatedUsers ) : long | ||
ProcessID | long | |
scheduleVersion | string | |
nextScheduled | System.DateTime | |
repeatSchedule | string | |
instantiatedUsers | string | |
return | long |
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;
}
public Schedule CreateProcessSchedule(long ProcessID, string scheduleVersion, DateTime nextScheduled, string repeatSchedule, string instantiatedUsers) { long ScheduleID = 0; Atul_v1Data adb = new Atul_v1Data(); Schedule s; ScheduleID = adb.CreateProcessSchedule(ProcessID, scheduleVersion, nextScheduled, repeatSchedule, instantiatedUsers); s = adb.GetProcessScheduleByID(ScheduleID); this.PushNextScheduleToAdminQueue(s, s.NextScheduledDate); return s; }