public ActionResult NewscastListGridData(GridSettings gridSettings, long scheduleId) { var dataTable = CRCDataAccess.GetScheduleNewscasts(scheduleId, 'Y'); int row = 0; foreach (DataColumn c in dataTable.Columns) { c.ReadOnly = false; } foreach (DataRow rw in dataTable.Rows) { dataTable.Rows[row][5] = ReportsController.multiDayMerge(dataTable.Rows[row][5].ToString()); row++; } using (dataTable) { InfJqGridDataResult infjqgrid = InfJqGridData(dataTable, gridSettings); return(infjqgrid); } }
public JsonResult NewscastSchedule(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 scheduleNewscastsDt = CRCDataAccess.GetScheduleNewscasts(scheduleId, 'N'); IEnumerable <object> rows = (from DataRow row in scheduleNewscastsDt.Rows select new { // FullCalendar standard event object fields id = row["ScheduleNewscastId"].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 scheduleNewscastId = row["ScheduleNewscastId"], 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"), hourlyInd = row["HourlyInd"], durationMinutes = row["DurationMinutes"], dayOfWeekText = row["DayOfWeek"].ToString(), // className = getProgramType(row["ProgramName"].ToString()), daysOfWeek = getDaysOfWeek(row), }); var jsonData = new { rows = rows }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }