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