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