ATUL_v1.Atul_v1Data.GetProcessScheduleByID C# (CSharp) Method

        public Schedule GetProcessScheduleByID(long ScheduleID)
        {
            Schedule s = new Schedule();
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ProcessScheduleGetByID_sp @AtulProcessScheduleID", this._connection);
            cmd.Parameters.Add(new SqlParameter("@AtulProcessScheduleID", ScheduleID));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); //returnTable.TableName = "schedule";
            da.Fill(returnTable);
            DataRow r = returnTable.Rows[0];
            s.AtulProcessID = Convert.ToInt64(r["AtulProcessScheduleID"]);
            s.AtulProcessScheduleID = Convert.ToInt64(r["AtulProcessScheduleID"]);
            s.InstantiatedUserList = r["InstantiatedUserList"].ToString();
            if (r["LastInstantiated"] != DBNull.Value)
            {
                s.LastInstantiated = Convert.ToDateTime(r["LastInstantiated"]);
            }
            s.NextScheduledDate = Convert.ToDateTime(r["NextScheduledDate"]);
            s.RepeatSchedule = r["RepeatSchedule"].ToString();
            s.ScheduleVersion = r["ScheduleVersion"].ToString();
            return s;
        }

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