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)));
}
