public ActionResult ProgramListGridData(GridSettings gridSettings, long scheduleId) { // Retrieve Schedule Programs list data var dataTable = CRCDataAccess.GetSchedulePrograms(scheduleId, 'Y'); int row = 0; foreach (DataColumn c in dataTable.Columns) { c.ReadOnly = false; } foreach (DataRow rw in dataTable.Rows) { dataTable.Rows[row][6] = ReportsController.multiDayMerge(dataTable.Rows[row][6].ToString()); row++; } using (dataTable) { return(InfJqGridData(dataTable, gridSettings)); } }
public JsonResult ProgramSchedule(long scheduleId, string start, string end) { var paramStartTimeStamp = Convert.ToInt64(start); var paramStartDate = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Local).AddSeconds(paramStartTimeStamp).Date; var paramEndTimeStamp = Convert.ToInt64(end); var paramEndDate = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Local).AddSeconds(paramEndTimeStamp).Date; DataTable scheduleProgramsDt = CRCDataAccess.GetSchedulePrograms(scheduleId, 'N'); IEnumerable <object> rows = (from DataRow row in scheduleProgramsDt.Rows select new { // FullCalendar standard event object fields id = row["ScheduleProgramId"].ToString(), title = row["ProgramName"], start = calcDateTime(row["DayOfWeek"].ToString(), (TimeSpan)row["StartTime"], paramStartDate, paramEndDate), end = calcDateTime(row["DayOfWeek"].ToString(), (TimeSpan)row["EndTime"], paramStartDate, paramEndDate), allDay = false, // custom fields scheduleProgramId = row["ScheduleProgramId"], programId = row["ProgramId"], programName = row["ProgramName"], year = row["Year"], month = row["Month"], startTime = calcDateTime(row["DayOfWeek"].ToString(), (TimeSpan)row["StartTime"], paramStartDate, paramEndDate).ToString("h:mm tt"), endTime = calcDateTime(row["DayOfWeek"].ToString(), (TimeSpan)row["EndTime"], paramStartDate, paramEndDate).ToString("h:mm tt"), quarterHours = row["QuarterHours"], dayOfWeekText = row["DayOfWeek"].ToString(), className = getProgramType(row["ProgramName"].ToString()), daysOfWeek = getDaysOfWeek(row), }); var jsonData = new { rows = rows }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }