public SalesEnquiryModel GetTransfterOUT() { SalesEnquiryModel salesModel = new SalesEnquiryModel(); try { List <pxSelectSalesEnquiry_Result> lstPhysicalInventoryViewModel = new List <pxSelectSalesEnquiry_Result>(); List <pxSelectTransfterOUT_Result> lstPhysicalInventory = Context.SelectTransfterOUT(); foreach (pxSelectTransfterOUT_Result physicalinventory in lstPhysicalInventory) { pxSelectSalesEnquiry_Result PORecieveViewModel = new pxSelectSalesEnquiry_Result(); PORecieveViewModel.DocumentID = physicalinventory.DocumentID; PORecieveViewModel.Amount = Convert.ToDecimal(physicalinventory.Amount); PORecieveViewModel.LocationDesc = physicalinventory.LocationDesc; PORecieveViewModel.Name1 = ""; PORecieveViewModel.PostingDate = physicalinventory.DocumentDate; PORecieveViewModel.UserID = physicalinventory.UserID; lstPhysicalInventoryViewModel.Add(PORecieveViewModel); PORecieveViewModel = null; } salesModel.SalesEnquiries = lstPhysicalInventoryViewModel; salesModel.Categories = Context.Category.Get().ToList(); return(salesModel); } catch (Exception ex) { return(null); } }
public ActionResult EnquiryEOD(SalesEnquiryModel salesEnquiry, string FilterName) { try { salesModel = salesBL.GetEODEnquiries(); ViewBag.Page = "EOD"; ViewBag.Categories = salesModel.Categories.Select(c => new SelectListItem() { Text = c.CategoryDesc, Value = c.CategoryID, }).ToList(); LocationBL.EmailID = User.Identity.Name; ViewBag.Locations = LocationBL.GetAll().Select(l => new SelectListItem() { Text = l.LocationDesc, Value = l.LocationID, }).ToList(); return(View("~/Views/Sales/EODEnquiry.cshtml", salesModel)); } catch (Exception ex) { return(null); } }
public List <pxSelectFilterEodEnquiry_Result> FilerEod(SalesEnquiryModel sales, string filterName) { string[] amount = new string[2]; try { if (sales.Amount != null) { amount = sales.Amount.Split('-'); } else { amount[0] = "0"; amount[1] = "100000"; } List <pxSelectFilterEodEnquiry_Result> lstFilterEnquiry = Context.selectFilterEOd(sales.FromDate, sales.ToDate, sales.Terminal, sales.Material, sales.EAN, sales.SelectedCategory, sales.SelectedSubCategory, sales.User, amount[0].Trim(), amount[1].Trim(), sales.Location); SalesEnquiryModel SalesEnquiryModel = new SalesEnquiryModel(); SalesEnquiryModel.EODEnquiries = lstFilterEnquiry; return(SalesEnquiryModel.EODEnquiries); } catch (Exception ex) { throw ex; } }
public SalesEnquiryModel GetSalesWithInvoice() { SalesEnquiryModel salesModel = new SalesEnquiryModel(); try { List <pxSelectSalesEnquiry_Result> lstSalesEnquiry = new List <pxSelectSalesEnquiry_Result>(); List <pxSelectReturnSalesWithInvoice_Result> lstSalesWithInvoice = Context.ReturnSalesWithInvoice(); foreach (pxSelectReturnSalesWithInvoice_Result filter in lstSalesWithInvoice) { pxSelectSalesEnquiry_Result salesEnquiry = new pxSelectSalesEnquiry_Result(); salesEnquiry.DocumentID = filter.DocumentID; salesEnquiry.Amount = filter.Amount; salesEnquiry.LocationDesc = filter.LocationDesc; salesEnquiry.Name1 = filter.Name1; salesEnquiry.PostingDate = filter.PostingDate; salesEnquiry.UserID = filter.UserID; lstSalesEnquiry.Add(salesEnquiry); } salesModel.SalesEnquiries = lstSalesEnquiry; salesModel.Categories = Context.Category.Get().ToList(); return(salesModel); } catch (Exception ex) { return(null); } }
public List <pxSelectSalesEnquiry_Result> Filter(SalesEnquiryModel sales) { try { List <pxSelectSalesEnquiry_Result> lstSalesEnquiry = new List <pxSelectSalesEnquiry_Result>(); string[] amount = sales.Amount.Split('-'); List <pxSelectFilterSalesEnquiry_Result> lstFilterSalesEnquiry = Context.FilterSalesEnquiry(sales.FromDate, sales.ToDate, sales.Terminal, sales.Material, sales.EAN, sales.SelectedCategory, sales.SelectedSubCategory, sales.User, amount[0].Trim(), amount[1].Trim(), sales.Location.Trim()); foreach (pxSelectFilterSalesEnquiry_Result filter in lstFilterSalesEnquiry) { pxSelectSalesEnquiry_Result salesEnquiry = new pxSelectSalesEnquiry_Result(); salesEnquiry.DocumentID = filter.DocumentID; salesEnquiry.Amount = filter.Amount; salesEnquiry.LocationDesc = filter.LocationDesc; salesEnquiry.Name1 = filter.Name1; salesEnquiry.PostingDate = filter.PostingDate; salesEnquiry.UserID = filter.UserID; lstSalesEnquiry.Add(salesEnquiry); } return(lstSalesEnquiry); } catch (Exception ex) { throw; } }
public SalesEnquiryModel GetTransfterToDisplay() { SalesEnquiryModel salesModel = new SalesEnquiryModel(); try { List <pxSelectSalesEnquiry_Result> lstTranfterToDisplayViewModel = new List <pxSelectSalesEnquiry_Result>(); List <pxSelectTransferDocument_Result> lstTransfterToDisplay = Context.GetTransferDocument(); foreach (pxSelectTransferDocument_Result transfterToDisplay in lstTransfterToDisplay) { pxSelectSalesEnquiry_Result PORecieveViewModel = new pxSelectSalesEnquiry_Result(); PORecieveViewModel.DocumentID = transfterToDisplay.DocumentID; PORecieveViewModel.Amount = Convert.ToDecimal(transfterToDisplay.Amount); PORecieveViewModel.LocationDesc = transfterToDisplay.LocationDesc; PORecieveViewModel.Name1 = ""; PORecieveViewModel.PostingDate = transfterToDisplay.PostingDate; PORecieveViewModel.UserID = transfterToDisplay.UserID; lstTranfterToDisplayViewModel.Add(PORecieveViewModel); PORecieveViewModel = null; } salesModel.SalesEnquiries = lstTranfterToDisplayViewModel; salesModel.Categories = Context.Category.Get().ToList(); return(salesModel); } catch (Exception ex) { return(null); } }
public SalesEnquiryModel GetReturnToSupplier() { SalesEnquiryModel salesModel = new SalesEnquiryModel(); try { List <pxSelectSalesEnquiry_Result> lstReturnToSupplierViewModel = new List <pxSelectSalesEnquiry_Result>(); List <pxSelectReturnToSupplier_Result> lstReturnToSupplier = Context.GetReturnToSupplier(); foreach (pxSelectReturnToSupplier_Result ReturnToSupplier in lstReturnToSupplier) { pxSelectSalesEnquiry_Result PORecieveViewModel = new pxSelectSalesEnquiry_Result(); PORecieveViewModel.DocumentID = ReturnToSupplier.DocumentID; PORecieveViewModel.Amount = Convert.ToDecimal(ReturnToSupplier.Amount); PORecieveViewModel.LocationDesc = ReturnToSupplier.LocationDesc; PORecieveViewModel.Name1 = ReturnToSupplier.Name1; PORecieveViewModel.PostingDate = ReturnToSupplier.DocumentDate; PORecieveViewModel.UserID = ReturnToSupplier.UserID; lstReturnToSupplierViewModel.Add(PORecieveViewModel); PORecieveViewModel = null; } salesModel.SalesEnquiries = lstReturnToSupplierViewModel; salesModel.Categories = Context.Category.Get().ToList(); return(salesModel); } catch (Exception ex) { return(null); } }
public SalesEnquiryModel GetAllSalesUnhold() { SalesEnquiryModel salesModel = new SalesEnquiryModel(); try { List <pxSelectSalesEnquiry_Result> lstSalesEnquiry = new List <pxSelectSalesEnquiry_Result>(); List <pxSelectSalesUnHoldEnquiry_Result> lstSalesUnhold = Context.GetAllSalesUnhold(); foreach (pxSelectSalesUnHoldEnquiry_Result unhold in lstSalesUnhold) { pxSelectSalesEnquiry_Result salesEnquiry = new pxSelectSalesEnquiry_Result(); salesEnquiry.DocumentID = unhold.DocumentID; salesEnquiry.Amount = Convert.ToDecimal(unhold.Amount); salesEnquiry.LocationDesc = unhold.LocationDesc; salesEnquiry.Name1 = unhold.Name1; salesEnquiry.PostingDate = unhold.DocDate; salesEnquiry.UserID = unhold.UserID; lstSalesEnquiry.Add(salesEnquiry); salesEnquiry = null; } salesModel.SalesEnquiries = lstSalesEnquiry; salesModel.Categories = Context.Category.Get().ToList(); return(salesModel); } catch (Exception ex) { return(null); } }
public SalesEnquiryModel GetAllSalesDelete() { SalesEnquiryModel salesModel = new SalesEnquiryModel(); try { List <pxSelectSalesEnquiry_Result> lstSalesEnquiry = new List <pxSelectSalesEnquiry_Result>(); List <pxSelectSalesDelete_Result> lstSalesWithoutInvoice = Context.GetAllSalesDelete(); foreach (pxSelectSalesDelete_Result delete in lstSalesWithoutInvoice) { pxSelectSalesEnquiry_Result salesEnquiry = new pxSelectSalesEnquiry_Result(); salesEnquiry.DocumentID = delete.DocumentID; salesEnquiry.Amount = delete.Amount; salesEnquiry.LocationDesc = delete.LocationDesc; salesEnquiry.Name1 = delete.Name1; salesEnquiry.PostingDate = delete.AddDate; salesEnquiry.UserID = delete.UserID; lstSalesEnquiry.Add(salesEnquiry); salesEnquiry = null; } salesModel.SalesEnquiries = lstSalesEnquiry; salesModel.Categories = Context.Category.Get().ToList(); return(salesModel); } catch (Exception ex) { return(null); } }
private async Task CreateSalesEnquiry() { List <KeyValuePair <string, string> > values = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("Name", Title), new KeyValuePair <string, string>("Phone", Phone), new KeyValuePair <string, string>("RelatedTo", RelatedTo), new KeyValuePair <string, string>("EnquiryDate", EnquiryDate.ToString()), new KeyValuePair <string, string>("FollowUpDate", FollowUpDate.ToString()), }; if (FieldValidation.ValidateFields(values)) { CanSaveEnquiry = false; try { SalesEnquiryModel salesEnquiryData = new SalesEnquiryModel() { Name = Title, Phone = Phone, RelatedTo = RelatedTo, EnquiryDate = EnquiryDate, FollowUpDate = FollowUpDate, }; HttpResponseMessage result = null; if (isUpdate) { salesEnquiryData.ID = ID; salesEnquiryData.CreatedBy = SelectedEnquiry.CreatedBy; salesEnquiryData.ModifiedOn = DateTime.Now; salesEnquiryData.ModifiedBy = ParentLayout.LoggedInUser.Name; result = await apiHelper.PutSalesEnquiry(ParentLayout.LoggedInUser.Token, salesEnquiryData).ConfigureAwait(false); } else { salesEnquiryData.CreatedBy = ParentLayout.LoggedInUser.Name; result = await apiHelper.PostSalesEnquiry(ParentLayout.LoggedInUser.Token, salesEnquiryData).ConfigureAwait(false); } if (result.IsSuccessStatusCode) { MessageBox.Show($"Sales Enquiry Saved Successfully", "Success", MessageBoxButton.OK, MessageBoxImage.Information); await GetEnquiries(); ClearFields(); } else { MessageBox.Show("Error in saving Sales Enquiry", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } CanSaveEnquiry = true; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); CanSaveEnquiry = true; } } }
public PartialViewResult Filter(SalesEnquiryModel salesEnquiry) { salesEnquiry.SelectedCategory = Request.Form["fltrCategory"]; string subcategory = Request.Form["fltrSubCategory"]; //salesEnquiry.Location= Request.Form["fltrLocation"].Trim(); salesEnquiry.SelectedSubCategory = subcategory != null ? subcategory : string.Empty; return(PartialView("~/Views/Sales/Partial/_SalesGridPartial.cshtml", salesBL.Filter(salesEnquiry))); }
public PartialViewResult FilterDeleteLineItems(SalesEnquiryModel salesEnquiry, string FilterName) { try { ViewBag.Page = FilterName; return(PartialView("~/Views/Sales/Partial/_SalesGridPartial.cshtml", salesBL.FilterDeleteLineItems(salesEnquiry))); } catch (Exception ex) { return(null); } }
public PartialViewResult FilterReturnTransfterPhysical(SalesEnquiryModel salesEnquiry, string FilterName) { try { ViewBag.Page = FilterName; return(PartialView("~/Views/Sales/Partial/_SalesGridPartial.cshtml", salesBL.FilterReturnTrafterPhysical(salesEnquiry, FilterName))); } catch (Exception ex) { return(null); } }
public PartialViewResult FilterEod(SalesEnquiryModel salesEnquiry, string FilterName) { try { ViewBag.Page = FilterName; return(PartialView("~/Views/Sales/Partial/EodEnquiryDetails.cshtml", salesBL.FilerEod(salesEnquiry, FilterName))); } catch (Exception ex) { return(null); } }
public SalesEnquiryModel GetEnquiries() { SalesEnquiryModel salesModel = new SalesEnquiryModel(); try { salesModel.Categories = Context.Category.Get().ToList(); salesModel.SalesEnquiries = Context.GetAllSalesEnquiry(); return(salesModel); } catch (Exception ex) { return(salesModel); } }
public ActionResult GetUnHoldEnquiry() { salesModel = salesBL.GetAllSalesUnhold(); ViewBag.Page = "Sales Hold Invoice"; ViewBag.Categories = salesModel.Categories.Select(c => new SelectListItem() { Text = c.CategoryDesc, Value = c.CategoryID, }).ToList(); LocationBL.EmailID = User.Identity.Name; ViewBag.Locations = LocationBL.GetAll().Select(l => new SelectListItem() { Text = l.LocationDesc, Value = l.LocationID, }).ToList(); return(View("~/Views/Sales/Enquiry.cshtml", salesModel)); }
public ActionResult TransfterToDisplay() { salesModel = salesBL.GetTransfterToDisplay(); ViewBag.Page = "Transfter To Display"; ViewBag.Categories = salesModel.Categories.Select(c => new SelectListItem() { Text = c.CategoryDesc, Value = c.CategoryID, }).ToList(); LocationBL.EmailID = User.Identity.Name; ViewBag.Locations = LocationBL.GetAll().Select(l => new SelectListItem() { Text = l.LocationDesc, Value = l.LocationID, }).ToList(); return View("~/Views/Sales/Enquiry.cshtml", salesModel); }
public SalesEnquiryModel GetEODEnquiries() { SalesEnquiryModel salesModel = new SalesEnquiryModel(); try { List <pxSelectFilterEodEnquiry_Result> lstSalesEnquiry = new List <pxSelectFilterEodEnquiry_Result>(); List <Proc_SelectEODEnquiry_Result> lstSalesUnhold = Context.Proc_SelectEODEnquiry(); foreach (Proc_SelectEODEnquiry_Result unhold in lstSalesUnhold) { pxSelectFilterEodEnquiry_Result salesEnquiry = new pxSelectFilterEodEnquiry_Result(); salesEnquiry.EODID = unhold.EODID; salesEnquiry.LocationDesc = unhold.LocationDesc; salesEnquiry.DocDate = unhold.DocDate; salesEnquiry.C_1 = unhold.C_1; salesEnquiry.C_5 = unhold.C_5; salesEnquiry.C_10 = unhold.C_10; salesEnquiry.C_20 = unhold.C_20; salesEnquiry.C_50 = unhold.C_50; salesEnquiry.C_100 = unhold.C_100; salesEnquiry.C_200 = unhold.C_200; salesEnquiry.C_500 = unhold.C_500; salesEnquiry.Loan = unhold.Loan; salesEnquiry.SystemCash = unhold.SystemCash; salesEnquiry.ActualCash = unhold.ActualCash; salesEnquiry.CreditAmt = unhold.CreditAmt; salesEnquiry.DebitAmt = unhold.DebitAmt; salesEnquiry.OnAccAmt = unhold.OnAccAmt; salesEnquiry.Amount = Convert.ToDecimal(unhold.Amount); lstSalesEnquiry.Add(salesEnquiry); salesEnquiry = null; } salesModel.EODEnquiries = lstSalesEnquiry; salesModel.Categories = Context.Category.Get().ToList(); return(salesModel); } catch (Exception ex) { return(null); } }
public List <pxSelectSalesEnquiry_Result> FilterReturnTrafterPhysical(SalesEnquiryModel sales, string filterName) { string[] amount = new string[2]; try { List <pxSelectSalesEnquiry_Result> lstSalesEnquiry = new List <pxSelectSalesEnquiry_Result>(); if (sales.Amount != null) { amount = sales.Amount.Split('-'); } else { amount[0] = "0"; amount[1] = "100000"; } List <Proc_FilterReturnORTransferORPhysicalORTransInORTransOUT_Result> lstFilterEnquiry = Context.Proc_FilterReturnORTransferORPhysical(filterName, sales.FromDate, sales.ToDate, sales.Terminal, sales.Material, sales.EAN, sales.SelectedCategory, sales.SelectedSubCategory, sales.User, amount[0].Trim(), amount[1].Trim(), sales.Location); foreach (Proc_FilterReturnORTransferORPhysicalORTransInORTransOUT_Result filter in lstFilterEnquiry) { pxSelectSalesEnquiry_Result salesEnquiry = new pxSelectSalesEnquiry_Result(); salesEnquiry.DocumentID = filter.DocumentID; salesEnquiry.Amount = filter.Amount; salesEnquiry.LocationDesc = filter.LocationDesc; salesEnquiry.Name1 = "Doc"; salesEnquiry.PostingDate = filter.PostingDate; salesEnquiry.UserID = filter.UserID; lstSalesEnquiry.Add(salesEnquiry); } lstFilterEnquiry = null; return(lstSalesEnquiry); } catch (Exception ex) { throw ex; } }
public PartialViewResult FilterReturnWithInvoice(SalesEnquiryModel salesEnquiry) { return(PartialView("~/Views/Sales/Partial/_SalesGridPartial.cshtml", salesBL.FilterReturnWithInvoice(salesEnquiry))); }