public FileContentResult SubscriptionExportToExcel(int?customerId, int?custtype, DateTime?effectivedate, string cTypetext = "", string statustext = "", string Location = "", int status = 1, int pageNo = 1, int pageSize = 0) { MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel(); var suscriberList = suscription.getSuscriberList(customerId, custtype, effectivedate, pageNo, pageSize, Location, status); var subscriptionExcelList = suscriberList.Select(x => new ExcelViewModel.SubscriptionExcelViewModel() { custno = x.CustNo, SubsNo = x.SubsNo, CustomerName = x.CustomerName, LocationName = x.LocationName, EffectiveDate = x.EffectiveDate, LedgerName = x.LedgerName, MonthlyAmount = x.MonthlyAmount, Status = x.Status }).ToList(); if (cTypetext == "--Select Event--") { cTypetext = ""; } string[] columns = { "Customer No", "Subscription No.", "Customer Name", "LocationName", "Effective Date", "Ledger Name", "Monthly Amount", "Status" }; string[] parameterSearch = { "Location.:" + Location, "Effective Date:" + effectivedate, "Customer Type:" + cTypetext, "Status:" + statustext }; byte[] fileContent = ExcelExportHelper.ExportExcel(subscriptionExcelList, parameterSearch, null, "Subscription Report", columns); return(File(fileContent, ExcelExportHelper.ExcelContentType, "Subscription Report.xlsx")); }
public ActionResult CustomerInfoList(int[] listBox, string mode, string custType, int pageNo = 1, int pageSize = 5) { if (mode == "SubscriptionReport") { MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel(); var suscriberList = customerService.SubscriberInfoList("", "", "", "", 1, 10); customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, 1, 10, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount); //foreach (var item in customerList) //{ // customerViewModel.customerViewModelList.Add(item); //} return(PartialView("~/Views/Suscription/_SubscriptionPopup.cshtml", customerViewModel)); } else { MainViewModel.CustomerViewModel custInfoModel = new MainViewModel.CustomerViewModel(); var custtomerList = customerService.CustomerInfoList("", "", "", custType, pageNo, pageSize); custInfoModel.customerPagedList = new StaticPagedList <MainViewModel.CustomerViewModel>(custtomerList, pageNo, pageSize, (custtomerList.Count == 0) ? 0 : custtomerList.FirstOrDefault().TotalCount); return(PartialView(custInfoModel)); } }
public ActionResult Create(MainViewModel.SubscriptionViewModel suscriptions) { try { returnMessage = suscription.Save(suscriptions); return(Json(returnMessage, JsonRequestBehavior.AllowGet)); } catch (DbEntityValidationException ex) { //returnMessage.Msg = "Not Saved" + ex.Message; //return returnMessage; foreach (var eve in ex.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw ex; } }
public ActionResult _MultipleBarcodeList(string name, string address, string printed, int pageNo = 1, int pageSize = 200) { MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel(); var suscriberList = suscription.getSuscriberListForQRCode(name, address, printed, pageNo, pageSize); customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount); return(PartialView(customerViewModel)); }
public MainViewModel.SubscriptionViewModel GetSelectedSubscription(int susid, string custType) { MainViewModel.SubscriptionViewModel customerInfoList = new MainViewModel.SubscriptionViewModel(); customerInfoList = uow.Repository <MainViewModel.SubscriptionViewModel>().SqlQuery(@"select * from[dbo].[fgetSubscriptionList]() where subsid={0} ", susid).SingleOrDefault(); return(customerInfoList); }
public ActionResult MultipleQRCodeIndex(string name, string address, string printed, int pageNo = 1, int pageSize = 200) { MainViewModel.SubscriptionViewModel barcode = new MainViewModel.SubscriptionViewModel(); var suscriberList = suscription.getSuscriberListForQRCode(name, address, printed, pageNo, pageSize); barcode.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount); return(View(barcode)); }
public ActionResult Create(int?sNo, int?customerid, string custname = "") { MainViewModel.SubscriptionViewModel suscriptionModel = new MainViewModel.SubscriptionViewModel(); if (sNo == null) { suscriptionModel.CustId = customerid; suscriptionModel.CustomerName = custname; } else { suscriptionModel = suscription.getSingleSuscriptonList(sNo); ViewBag.EffectiveDate = suscriptionModel.EffectiveDate.Value.Month.ToString() + "-" + suscriptionModel.EffectiveDate.Value.Day.ToString() + "-" + suscriptionModel.EffectiveDate.Value.Year.ToString(); var customerName = customerService.GetSelectedMultipleCustomer(Convert.ToInt32(suscriptionModel.CustId)); suscriptionModel.CustomerName = customerName.CustomerName; } return(PartialView(suscriptionModel)); }
public ActionResult _CustomerInfoList(string searchParam, string searchOption, string mode, string custType, int pageNo = 1, int pageSize = 5) { if (mode == "SubscriptionReport") { MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel(); var suscriberList = customerService.SubscriberInfoList(searchParam, searchOption, mode, custType, pageNo, pageSize); //if (searchOption != null && searchOption == "Customer Name") //{ // suscriberList = suscriberList.Where(x => x.CustomerName.ToLower().Contains(searchParam.ToLower())).ToList(); //} //if (searchOption != null && searchOption == "Subscription No") //{ // suscriberList = suscriberList.Where(x => x.SubsNo == Convert.ToInt32(searchParam)).ToList(); //} customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount); //foreach (var item in customerList) //{ // customerViewModel.customerViewModelList.Add(item); //} return(PartialView("~/Views/Suscription/_SubscriptionPopupPartial.cshtml", customerViewModel)); } else { MainViewModel.CustomerViewModel custInfoModel = new MainViewModel.CustomerViewModel(); List <MainViewModel.CustomerViewModel> custList = new List <MainViewModel.CustomerViewModel>(); var custtomerList = customerService.CustomerInfoList(searchParam, searchOption, mode, custType, pageNo, pageSize); custInfoModel.customerPagedList = new StaticPagedList <MainViewModel.CustomerViewModel>(custtomerList, pageNo, pageSize, (custtomerList.Count == 0) ? 0 : custtomerList.FirstOrDefault().TotalCount); //if (listBox != null) //{ // foreach (var item in listBox) // { // MainViewModel.CustomerViewModel selectCustInfoModel = new MainViewModel.CustomerViewModel(); // selectCustInfoModel.CID = item; // custList.Add(selectCustInfoModel); // } //} //custInfoModel.SelectedCustInfoList = custList; return(PartialView("_CustomerInfoList", custInfoModel)); } }
public MainViewModel.SubscriptionViewModel getSingleSuscriptonList(int?sno) { var subsList = uow.Repository <Subscription>().FindBy(x => x.Subsid == sno); MainViewModel.SubscriptionViewModel subsSingleList = subsList.Select(x => new MainViewModel.SubscriptionViewModel { Subsid = x.Subsid, CustId = x.CustId, LedgerId = x.LedgerId, MonthlyAmount = x.MonthlyAmount, LocationID = x.LocationID, DharautiAmt = x.DharautiAmt, RegistrationFee = x.RegistrationFee, EffectiveDate = x.EffectiveDate, Remarks = x.Remarks }).SingleOrDefault(); return(subsSingleList); }
public ActionResult _List(int?customerId, int pageNo = 1, int pageSize = 10) { try { MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel(); var suscriberList = suscription.getSuscriberList(customerId, null, null, 1, 10, "", 1); customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount); //foreach (var item in customerList) //{ // customerViewModel.customerViewModelList.Add(item); //} return(PartialView(customerViewModel)); } catch (Exception ex) { throw ex; } }
public ActionResult _SuscriptionReportList(int?customerId, int?custtype, DateTime?effectivedate, string Location = "", int status = 1, int pageNo = 1, int pageSize = 10) { try { MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel(); var suscriberList = suscription.getSuscriberList(customerId, custtype, effectivedate, pageNo, pageSize, Location, status); customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount); //foreach (var item in customerList) //{ // customerViewModel.customerViewModelList.Add(item); //} return(PartialView(customerViewModel)); } catch (Exception ex) { throw ex; } }
public ReturnBaseMessageModel Save(MainViewModel.SubscriptionViewModel suscription) { try { var subsid = suscription.Subsid.GetType(); var CustId = suscription.CustId.GetType(); uow.ExecWithStoreProcedure("[dbo].[PcreateSubscription] @Subsid,@CustId,@EffectiveDate,@LedgerId,@MonthlyAmount,@LocationId,@Remarks,@PostedBy,@DharautiAmt,@RegistrationFee", new SqlParameter("@Subsid", suscription.Subsid), new SqlParameter("@CustId", suscription.CustId), new SqlParameter("@EffectiveDate", suscription.EffectiveDate), new SqlParameter("@LedgerId", suscription.LedgerId), new SqlParameter("@MonthlyAmount", suscription.MonthlyAmount), new SqlParameter("@LocationId", suscription.LocationID), new SqlParameter("@Remarks", suscription.Remarks), new SqlParameter("@PostedBy", Global.UserId), new SqlParameter("@DharautiAmt", suscription.DharautiAmt), new SqlParameter("@RegistrationFee", suscription.RegistrationFee) ); if (suscription.Subsid == 0) { returnMessage.Msg = "Suscription Added Sucessfully"; } else { returnMessage.Msg = "Suscription Edited Sucessfully"; } returnMessage.Success = true; return(returnMessage); } catch (Exception ex) { returnMessage.Msg = "Suscription Not Saved"; returnMessage.Success = false; return(returnMessage); throw ex; } }
public ActionResult SubscriberStatement() { try { MainViewModel.SubscriptionViewModel subscriptionViewModel = new MainViewModel.SubscriptionViewModel(); //var suscriberList = reportService.getSubscriberStatementList(subsid, FromDate, ToDate, 1, 10); //subscriptionViewModel.subscriptionPagedList = new StaticPagedList<MainViewModel.SubscriptionReport>(suscriberList, 1, 10, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount); //foreach (var item in customerList) //{ // customerViewModel.customerViewModelList.Add(item); //} subscriptionViewModel.ModelFrom = "SubscriptionReport"; return(PartialView(subscriptionViewModel)); } catch (Exception ex) { throw ex; } }
public ActionResult Index() { MainViewModel.SubscriptionViewModel collection = new MainViewModel.SubscriptionViewModel(); collection.ModelFrom = "Collection"; return(PartialView(collection)); }
// GET: Suscription public ActionResult Index() { MainViewModel.SubscriptionViewModel suscriptionModel = new MainViewModel.SubscriptionViewModel(); suscriptionModel.ModelFrom = "Suscription"; return(PartialView(suscriptionModel)); }