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