public ServiceResult <List <SizeGrid> > GetSearchData(SizeGridSearch sizeGridSearch)
{
ServiceResult <List <SizeGrid> > model = new ServiceResult <List <SizeGrid> >();
var source = db.SizeGrids.Where(x => x.IsActive == true);
var pageSize = 10;
if (sizeGridSearch != null)
{
if (!string.IsNullOrEmpty(sizeGridSearch.GridNumber))
{
source = source.Where(m => m.GridNumber == sizeGridSearch.GridNumber);
}
}
int count = source.Count();
var items = source.OrderByDescending(x => x.Id).Skip(((sizeGridSearch.Page ?? 1) - 1) * pageSize).Take(pageSize).ToList();
model.data = items.Select(x => new SizeGrid
{
Id = x.Id,
GridNumber = x.GridNumber,
Z01 = x.Z01,
Z02 = x.Z02,
Z03 = x.Z03,
Z04 = x.Z04,
Z05 = x.Z05,
Z06 = x.Z06,
Z07 = x.Z07,
Z08 = x.Z08,
Z09 = x.Z09,
Z10 = x.Z10,
Z11 = x.Z11,
Z12 = x.Z12,
Z13 = x.Z13,
Z14 = x.Z14,
Z15 = x.Z15,
Z16 = x.Z16,
Z17 = x.Z17,
Z18 = x.Z18,
Z19 = x.Z19,
Z20 = x.Z20,
Z21 = x.Z21,
Z22 = x.Z22,
Z23 = x.Z23,
Z24 = x.Z24,
Z25 = x.Z25,
Z26 = x.Z26,
Z27 = x.Z27,
Z28 = x.Z28,
Z29 = x.Z29,
Z30 = x.Z30,
IsActive = x.IsActive
}).ToList();
model.TotalCount = count;
return(model);;
}
public ActionResult _Index1(SizeGridSearch sizeGridSearch, int?page)
{
int TotalCount = 0;
var pageSize = 10;
var pageNumber = page ?? 1;
int CurrentPage = pageNumber;
var endPage = CurrentPage + 4;
int PagesToShow = 10;
var mainDict = new Dictionary <string, Dictionary <string, string> >();
ViewBag.PageSize = pageSize;
var SizeGridModelList = Services.SizeGridService.GetPaging(page, out TotalCount);
foreach (var item in SizeGridModelList)
{
var dict = new Dictionary <string, string>();
var keyval = Utility.getKeyVaue(item).Where(x => x.Key.Contains("Z")).ToList();
foreach (var item2 in keyval)
{
if (!string.IsNullOrEmpty(item2.Value))
{
if (item2.Value.Contains(".0"))
{
//item2[item2.Key] = item2.Value.Replace(".0", "");
dict.Add(item2.Key, item2.Value.Replace(".0", ""));
}
else
{
dict.Add(item2.Key, item2.Value);
}
}
}
mainDict.Add(item.Id + "#" + item.GridNumber, dict);
}
ViewBag.TotalCount = TotalCount;
ViewBag.TotalCount = TotalCount;
var result = CommonFunction.GetPages(TotalCount, pageSize, CurrentPage, PagesToShow);
int totalPages = (TotalCount / pageSize) + (TotalCount % pageSize == 0 ? 0 : 1);
ViewBag.result = result;
ViewBag.totalPages = totalPages;
ViewBag.CurrentPage = CurrentPage;
var pageCount = result.Count();
ViewBag.pageCount = pageCount;
ViewBag.endPage = endPage;
return(View(mainDict));
}
public List <SizeGridModel> GetSearchData(SizeGridSearch sizeGridSearch, int?page, out int TotalCount)
{
// int pageSize = 4;
int pageNumber = (page ?? 1);
var body = JsonConvert.SerializeObject(sizeGridSearch);
var result = ServerResponse.Invoke <ServiceResult <List <SizeGridModel> > >("api/sizeGrid/getSearchData", body, "Post");
TotalCount = result.TotalCount;
if (result.data != null)
{
var model = result.data.ToList();
return(model);
}
else
{
}
return(result.data.ToList());
}
