public ActionResult SvcDaysGridData(string sidx, string sord, int page, int rows)
{
string fromDate = Request.QueryString["fromDate"];
string todate = Request.QueryString["toDate"];
uls_dbDataContext ulsdb_dc = new uls_dbDataContext();
var svc_days = ulsdb_dc.GetGridSvcDays(sidx, sord, fromDate, todate);
var dataJson = new
{
total =
page = 1,
records = 10000,
rows = (from s in svc_days
select new
{
id = String.Format("{0:MMddyyyy}", s.svc_sched_dt),
cell = new string[] {
String.Format("{0:MM/dd/yyyy}", s.svc_sched_dt),
String.Format("{0:dddd}", s.svc_sched_dt),
Convert.ToString(s.tot_crews),
Convert.ToString(s.cur_svcs_sched),
Convert.ToString(s.available)
}
}).ToArray()
};
return(Json(dataJson, JsonRequestBehavior.AllowGet));
}