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