ATUL_v1.Atul_v1Data.CreateProcessSchedule C# (CSharp) Method

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