public IEnumerable <PurchaseSalesReportOfMEModel> GetPurchaseSalesReportOfME(PurchaseSalesReportOfMEModel model) { var Data = entity.Air_GetPurchseSalesOfMEs(model.MEsNameID, model.FromDate, model.ToDate, model.CurrencyID); List <PurchaseSalesReportOfMEModel> collection = new List <PurchaseSalesReportOfMEModel>(); double PurchaseTotal = 0; double SalesTotal = 0; double RecieptTotal = 0; foreach (var item in Data) { PurchaseSalesReportOfMEModel single = new PurchaseSalesReportOfMEModel() { AgentName = item.AgentName, Purchase = item.Pruchase, Sales = item.Sales, Receipt = item.Receipt }; collection.Add(single); PurchaseTotal += item.Pruchase ?? 0; SalesTotal += item.Sales ?? 0; RecieptTotal += item.Receipt; } PurchaseSalesReportOfMEModel add = new PurchaseSalesReportOfMEModel(); add.Purchase = PurchaseTotal; add.Sales = SalesTotal; add.Receipt = RecieptTotal; collection.Add(add); return(collection); }
public ActionResult Index(ExportModel Expmodel, FormCollection frm, PurchaseSalesReportOfMEModel model) { model.PurchaseSalesReportOfMElist = PurchaseSalesReportOfMERepository.GetPurchaseSalesReportOfME(model); ctrlBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } var count = 1; var exportData = model.PurchaseSalesReportOfMElist.Select(m => new { SNo = count++, Agent_Name = m.AgentName, Purchase = m.Purchase, Sales = m.Sales, Receipt = m.Receipt }); App_Class.AppCollection.Export(Expmodel, exportData, "Purchase Sales Report Of ME's"); } catch (Exception ex) { TempData["ActionResponse"] = ex.Message; } } model.MENameList = PurchaseSalesReportOfMERepository.GetMEName(); model.CurrencyList = PurchaseSalesReportOfMERepository.GetCurrency(); return(View(model)); }
public ActionResult Index() { TravelSession obj = (TravelSession)Session["TravelPortalSessionInfo"]; PurchaseSalesReportOfMEModel model = new PurchaseSalesReportOfMEModel(); model.AppUserId = obj.AppUserId; model.UserTypeId = obj.UserTypeId; if (obj.UserTypeId == 4) { model.MENameList = PurchaseSalesReportOfMERepository.GetMENameOnly(model.AppUserId, model.UserTypeId); } else { model.MENameList = PurchaseSalesReportOfMERepository.GetMEName(); } model.CurrencyList = PurchaseSalesReportOfMERepository.GetCurrency(); return(View(model)); }