public JsonResult GetAllPOSummaryByBranchRegion(string daterange) { var reg = User.Identity.GetUserName().Substring(6, 3); var id = User.Identity.GetUserName().Substring(0, 6); char[] delimiterChars = { '-' }; string[] drdate = daterange.Split(delimiterChars); var sdate = Convert.ToDateTime(drdate[0]); var edate = Convert.ToDateTime(drdate[1]); var summary = new xCSVPerformance(); var requestQQ = summary.generateSummaryBranch(summary.generateSummaryBranchRangeDate(summary.getSupplierDataByBranch(id, reg, Server.MapPath("~/SPData/sadata.csv"), Server.MapPath("~/SPData/region.csv")), sdate, edate)); return(Json(requestQQ, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllPOSummary(string daterange) { var reg = User.Identity.GetUserName().Substring(6, 3); var id = User.Identity.GetUserName().Substring(0, 6); char[] delimiterChars = { '-' }; string[] drdate = daterange.Split(delimiterChars); var sdate = Convert.ToDateTime(drdate[0]); var edate = Convert.ToDateTime(drdate[1]); var ilist = new List <SupplierPerformance>(); var summary = new xCSVPerformance(); var requestQQ = summary.generateSummary(summary.generateSummaryRangeDate(summary.getSupplierData(id, reg, Server.MapPath("~/SPData/sadata.csv"), Server.MapPath("~/SPData/region.csv")), sdate, edate)); foreach (var item in requestQQ) { ilist.Add(new xFormula(item, reg).performace()); } return(Json(ilist, JsonRequestBehavior.AllowGet)); }