public JsonResult GetAll() { try { var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault(); var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); int pageSize = length != null?Convert.ToInt32(length) : 0; string search = Request.Form.GetValues("search[value]")[0]; DataTablesParm parm = new DataTablesParm(); int pageNo = Convert.ToInt32(draw); int totalCount = 0; if (Convert.ToInt32(start) >= Convert.ToInt32(length)) { pageNo = (Convert.ToInt32(start) / Convert.ToInt32(length)) + 1; } int CompanyId = Convert.ToInt32(Session["CompanyId"]); var result = webServices.Post(new LPOInvoiceViewModel(), "Bill/All"); if (result.StatusCode == System.Net.HttpStatusCode.Accepted) { if (result.Data != "[]") { lPOInvoiceViewModels = (new JavaScriptSerializer()).Deserialize <List <LPOInvoiceViewModel> >(result.Data.ToString()); HttpContext.Cache["AWFuelBillData"] = lPOInvoiceViewModels; if (parm.sSearch != null) { totalCount = lPOInvoiceViewModels.Where(x => x.Name.ToLower().Contains(parm.sSearch.ToLower()) || x.GrandTotal.ToString().Contains(parm.sSearch) || x.UserName.ToLower().Contains(parm.sSearch.ToLower()) || x.PONumber.ToString().Contains(parm.sSearch)).Count(); lPOInvoiceViewModels = lPOInvoiceViewModels.ToList() .Where(x => x.Name.ToLower().Contains(parm.sSearch.ToLower()) || x.GrandTotal.ToString().Contains(parm.sSearch) || x.UserName.ToLower().Contains(parm.sSearch.ToLower()) || x.PONumber.ToString().Contains(parm.sSearch)) .Skip((pageNo - 1) * Convert.ToInt32(length)) .Take(Convert.ToInt32(length)) .Select(x => new LPOInvoiceViewModel { Id = x.Id, Product = x.Product, UnitName = x.UnitName, TotalQuantity = x.TotalQuantity, Name = x.Name, Total = x.Total, VAT = x.VAT, GrandTotal = x.GrandTotal, UserName = x.UserName, PONumber = x.PONumber, FDate = x.FDate, DDate = x.DDate, IsUpdated = x.IsUpdated, RefrenceNumber = x.RefrenceNumber }).ToList(); } else { totalCount = lPOInvoiceViewModels.Count(); lPOInvoiceViewModels = lPOInvoiceViewModels .Skip((pageNo - 1) * Convert.ToInt32(length)) .Take(Convert.ToInt32(length)) .Select(x => new LPOInvoiceViewModel { Id = x.Id, Product = x.Product, UnitName = x.UnitName, TotalQuantity = x.TotalQuantity, Name = x.Name, Total = x.Total, VAT = x.VAT, GrandTotal = x.GrandTotal, UserName = x.UserName, PONumber = x.PONumber, FDate = x.FDate, DDate = x.DDate, IsUpdated = x.IsUpdated, RefrenceNumber = x.RefrenceNumber }).ToList(); } return(Json( new { aaData = lPOInvoiceViewModels, parm.sEcho, iTotalDisplayRecords = totalCount, data = lPOInvoiceViewModels, iTotalRecords = totalCount, }, JsonRequestBehavior.AllowGet)); } else { return(Json( new { aaData = lPOInvoiceViewModels, parm.sEcho, iTotalDisplayRecords = 0, data = lPOInvoiceViewModels, iTotalRecords = 0, }, JsonRequestBehavior.AllowGet)); } } else { return(Json( new { aaData = lPOInvoiceViewModels, parm.sEcho, iTotalDisplayRecords = 0, data = lPOInvoiceViewModels, iTotalRecords = 0, }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { throw ex; } }
public JsonResult GetAll() { DataTablesParm parm = new DataTablesParm(); try { int pageNo = 1; int totalCount = 0; parm.iDisplayStart = 0; parm.iDisplayLength = 20; if (parm.iDisplayStart >= parm.iDisplayLength) { pageNo = (parm.iDisplayStart / parm.iDisplayLength) + 1; } int CompanyId = Convert.ToInt32(Session["CompanyId"]); if (HttpContext.Cache["AWFuelBillData"] != null) { lPOInvoiceViewModels = HttpContext.Cache["AWFuelBillData"] as List <LPOInvoiceViewModel>; } else { var result = webServices.Post(new LPOInvoiceViewModel(), "Bill/All"); lPOInvoiceViewModels = (new JavaScriptSerializer()).Deserialize <List <LPOInvoiceViewModel> >(result.Data.ToString()); HttpContext.Cache["AWFuelBillData"] = lPOInvoiceViewModels; } if (parm.sSearch != null) { totalCount = lPOInvoiceViewModels.Where(x => x.Name.ToLower().Contains(parm.sSearch.ToLower()) || x.GrandTotal.ToString().Contains(parm.sSearch) || x.UserName.ToLower().Contains(parm.sSearch.ToLower()) || x.PONumber.ToString().Contains(parm.sSearch)).Count(); lPOInvoiceViewModels = lPOInvoiceViewModels.ToList() .Where(x => x.Name.ToLower().Contains(parm.sSearch.ToLower()) || x.GrandTotal.ToString().Contains(parm.sSearch) || x.UserName.ToLower().Contains(parm.sSearch.ToLower()) || x.PONumber.ToString().Contains(parm.sSearch)) .Skip((pageNo - 1) * parm.iDisplayLength) .Take(parm.iDisplayLength) .Select(x => new LPOInvoiceViewModel { Id = x.Id, Name = x.Name, Total = x.Total, VAT = x.VAT, GrandTotal = x.GrandTotal, UserName = x.UserName, PONumber = x.PONumber, FDate = x.FDate, DDate = x.DDate, IsUpdated = x.IsUpdated, RefrenceNumber = x.RefrenceNumber }).ToList(); } else { totalCount = lPOInvoiceViewModels.Count(); lPOInvoiceViewModels = lPOInvoiceViewModels .Skip((pageNo - 1) * parm.iDisplayLength) .Take(parm.iDisplayLength) .Select(x => new LPOInvoiceViewModel { Id = x.Id, Name = x.Name, Total = x.Total, VAT = x.VAT, GrandTotal = x.GrandTotal, UserName = x.UserName, PONumber = x.PONumber, FDate = x.FDate, DDate = x.DDate, IsUpdated = x.IsUpdated, RefrenceNumber = x.RefrenceNumber }).ToList(); } return(Json( new { aaData = lPOInvoiceViewModels, sEcho = parm.sEcho, iTotalDisplayRecords = totalCount, data = lPOInvoiceViewModels, iTotalRecords = totalCount, }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
public JsonResult GetAll() { try { DataTablesParm parm = new DataTablesParm(); int pageNo = 1; int totalCount = 0; parm.iDisplayLength = 20; parm.iDisplayStart = 0; if (parm.iDisplayStart >= parm.iDisplayLength) { pageNo = (parm.iDisplayStart / parm.iDisplayLength) + 1; } //int CompanyId = Convert.ToInt32(Session["CompanyId"]); //if (HttpContext.Cache["LPOData"] != null) //{ // lPOInvoiceViewModels = HttpContext.Cache["LPOData"] as List<LPOInvoiceViewModel>; //} //else //{ var result = webServices.Post(new VehicleViewModel(), "LPO/All"); if (result.StatusCode == System.Net.HttpStatusCode.Accepted) { if (result.Data != "[]") { lPOInvoiceViewModels = (new JavaScriptSerializer()).Deserialize <List <LPOInvoiceViewModel> >(result.Data.ToString()); } HttpContext.Cache["LPOData"] = lPOInvoiceViewModels; // } if (parm.sSearch != null) { totalCount = lPOInvoiceViewModels.Where(x => x.Name.ToLower().Contains(parm.sSearch.ToLower()) || x.GrandTotal.ToString().Contains(parm.sSearch) || x.UserName.ToLower().Contains(parm.sSearch.ToLower()) || x.PONumber.ToString().Contains(parm.sSearch)).Count(); lPOInvoiceViewModels = lPOInvoiceViewModels.ToList() .Where(x => x.Name.ToLower().Contains(parm.sSearch.ToLower()) || x.GrandTotal.ToString().Contains(parm.sSearch) || x.UserName.ToLower().Contains(parm.sSearch.ToLower()) || x.PONumber.ToString().Contains(parm.sSearch)) .Skip((pageNo - 1) * parm.iDisplayLength) .Take(parm.iDisplayLength) .Select(x => new LPOInvoiceViewModel { Id = x.Id, Product = x.Product, UnitName = x.UnitName, TotalQuantity = x.TotalQuantity, Name = x.Name, Total = x.Total, VAT = x.VAT, GrandTotal = x.GrandTotal, UserName = x.UserName, PONumber = x.PONumber, FDate = x.FDate, DDate = x.DDate, IsUpdated = x.IsUpdated }).ToList(); } else { totalCount = lPOInvoiceViewModels.Count(); lPOInvoiceViewModels = lPOInvoiceViewModels .Skip((pageNo - 1) * parm.iDisplayLength) .Take(parm.iDisplayLength) .Select(x => new LPOInvoiceViewModel { Id = x.Id, Product = x.Product, UnitName = x.UnitName, TotalQuantity = x.TotalQuantity, Name = x.Name, Total = x.Total, VAT = x.VAT, GrandTotal = x.GrandTotal, UserName = x.UserName, PONumber = x.PONumber, FDate = x.FDate, DDate = x.DDate, IsUpdated = x.IsUpdated }).ToList(); } return(Json( new { aaData = lPOInvoiceViewModels, parm.sEcho, iTotalDisplayRecords = totalCount, data = lPOInvoiceViewModels, iTotalRecords = totalCount, }, JsonRequestBehavior.AllowGet)); } else { return(Json( new { aaData = lPOInvoiceViewModels, parm.sEcho, iTotalDisplayRecords = 0, data = lPOInvoiceViewModels, iTotalRecords = 0, }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { throw ex; } }