public dynamic GetDefaultInfo() { WorkingDay model = new WorkingDay(); try { model = _workingDayService.GetQueryable().FirstOrDefault(); } catch (Exception ex) { LOG.Error("GetInfo", ex); Dictionary <string, string> Errors = new Dictionary <string, string>(); Errors.Add("Generic", "Error " + ex); return(Json(new { Errors }, JsonRequestBehavior.AllowGet)); } return(Json(new { model.Id, model.Code, model.Name, model.IsEnabled, model.MinCheckIn, model.CheckIn, model.MaxCheckIn, model.BreakOut, model.BreakIn, model.MinCheckOut, model.CheckOut, model.MaxCheckOut, model.CheckInTolerance, model.CheckOutTolerance, model.WorkInterval, model.BreakInterval//, // model.Errors }, JsonRequestBehavior.AllowGet)); }
public dynamic GetListWorkingDay(string _search, long nd, int rows, int?page, string sidx, string sord, int id, string filters = "") { // Construct where statement string strWhere = GeneralFunction.ConstructWhere(filters); string filter = null; GeneralFunction.ConstructWhereInLinq(strWhere, out filter); if (filter == "") { filter = "true"; } // Get Data var q = _workingDayService.GetQueryable().Include("WorkingTime").Where(x => x.WorkingTimeId == id); var query = (from model in q select new { model.Id, model.Code, model.Name, model.IsEnabled, model.MinCheckIn, model.CheckIn, model.MaxCheckIn, model.BreakOut, model.BreakIn, model.MinCheckOut, model.CheckOut, model.MaxCheckOut, model.CheckInTolerance, model.CheckOutTolerance, model.WorkInterval, model.BreakInterval, model.CreatedAt, model.UpdatedAt, }).Where(filter).OrderBy(sidx + " " + sord); //.ToList(); var list = query.AsEnumerable(); var pageIndex = Convert.ToInt32(page) - 1; var pageSize = rows; var totalRecords = query.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize); // default last page if (totalPages > 0) { if (!page.HasValue) { pageIndex = totalPages - 1; page = totalPages; } } list = list.Skip(pageIndex * pageSize).Take(pageSize); return(Json(new { total = totalPages, page = page, records = totalRecords, rows = ( from model in list select new { id = model.Id, cell = new object[] { model.Id, model.Code, model.Name, model.IsEnabled, model.MinCheckIn, model.CheckIn, model.MaxCheckIn, model.BreakOut, model.BreakIn, model.MinCheckOut, model.CheckOut, model.MaxCheckOut, model.CheckInTolerance, model.CheckOutTolerance, model.WorkInterval, model.BreakInterval, model.CreatedAt, model.UpdatedAt, } }).ToArray() }, JsonRequestBehavior.AllowGet)); }