public JsonResult GetFilteredData(Serarch searchModel) { try { var customerData = Integration.GetTableData(17057); if (customerData.Status) { var cust = customerData.Result .Where(d => (d.PaymentMethod == searchModel.Payment || searchModel.Payment == 0) && (d.Country == searchModel.Country || searchModel.Country == 0) && !string.IsNullOrEmpty(d.Name)) .ToList(); var summryData = cust.GroupBy(g => new { g.Name }) .Select(s => new DropdownValues { Code = s.Count(), Name = s.Key.Name }) .ToList(); var dd = new List <DropdownValues>(); for (int d = 0; d < summryData.Count; d++) { dd.Add(new DropdownValues { Code = summryData[d].Code, Name = summryData[d].Name }); } return(Json(new { status = true, Data = dd })); } return(Json(new { status = true, Data = customerData.Message })); } catch (Exception ex) { throw; } }
public JsonResult GetFilteredData_Old(Serarch searchModel) { try { //Charts = Integration.GetTableData(17057).Result; if (searchModel.Country == null) { var dates = Charts.Where(d => (d.DateCreated >= searchModel.FromDate && d.DateCreated <= searchModel.ToDate) || searchModel.FromDate == null); if (searchModel.Count.Contains("-")) { var cn = searchModel.Count.Split('-'); int st = Convert.ToInt32(cn[0]) - 1; int lst = Convert.ToInt32(cn[1]) - 1; if (lst == 0) { lst = Charts.Count; st = lst - st; } dates = dates.Skip(st).Take(lst) .GroupBy(g => new { g.ObjectText2 }) .Select(s => new ChartObject { ObjectValue1 = s.Sum(d => d.ObjectValue1), ObjectText2 = s.Key.ObjectText2 }); } else { int st = Convert.ToInt32(searchModel.Count); if (st == 0) { st = Charts.Count; } dates = dates.Take(st) .GroupBy(g => new { g.ObjectText2 }) .Select(s => new ChartObject { ObjectValue1 = s.Sum(d => d.ObjectValue1), ObjectText2 = s.Key.ObjectText2 }); } return(Json(new { status = true, Data = dates })); } else { var dates = Charts.ToList(); var dd = new List <ChartObject>(); for (int d = 0; d < dates.Count(); d++) { dd.Add(new ChartObject { ObjectValue1 = dates[d].ObjectValue1, ObjectText2 = dates[d].DateCreated.ToString("dd/MM/yyyy") }); } return(Json(new { status = true, Data = dd })); } } catch (Exception ex) { throw; } }