public void GetQuote(string quote)
{
ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
Error = "";
try
{
using (var context = new MONITOREntitiesQuoteLogIntegrationQuoteTransfer())
{
var collection = context.usp_QL_QuoteTransfer_GetQuote(quote, tranDT, result);
foreach (var item in collection)
{
QuoteNumber = item.QuoteNumber;
QtDate = item.Date.ToString("yyyy-MM-dd");
Customer = item.Customer;
EmpirePartNumber = item.EmpirePartNumber;
CustomerPartNumber = item.CustomerPartNumber;
Program = item.Program;
Application = item.Application;
FinancialEau = (item.FinancialEau.HasValue) ? item.FinancialEau.Value.ToString("N0") : "";
CapactiyEau = (item.CapacityEau.HasValue) ? item.CapacityEau.Value.ToString("N0") : "";
Salesman = item.Salesman;
QuoteEngineer = item.QuoteEngineer;
ProgramManager = item.ProgramManager;
SalePrice = (item.SalesPrice.HasValue) ? item.SalesPrice.Value.ToString("C2") : "";
LtaYear1 = (item.LtaYear1 != 0) ? item.LtaYear1.Value.ToString("C2") : "";
LtaYear2 = (item.LtaYear2 != 0) ? item.LtaYear2.Value.ToString("C2") : "";
LtaYear3 = (item.LtaYear3 != 0) ? item.LtaYear3.Value.ToString("C2") : "";
LtaYear4 = (item.LtaYear4 != 0) ? item.LtaYear4.Value.ToString("C2") : "";
PrototypePrice = (item.PrototypePrice.HasValue) ? item.PrototypePrice.Value.ToString("N2") : "";
MinimumOrderQuantity = (item.MinimumOrderQuantity.HasValue) ? item.MinimumOrderQuantity.ToString() : "";
Material = (item.Material.HasValue) ? item.Material.Value.ToString("C2") : "";
Labor = (item.Labor.HasValue) ? item.Labor.Value.ToString("C2") : "";
Tooling = (item.Tooling.HasValue) ? item.Tooling.Value.ToString("C2") : "";
Sop = (item.SOP.HasValue) ? item.SOP.Value.ToString("yyyy-MM-dd") : "";
Eop = (item.EOP.HasValue) ? item.EOP.Value.ToString("yyyy-MM-dd") : "";
QuoteTransferComplete = item.QuoteTransferComplete;
}
}
}
catch (Exception ex)
{
Error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
}
}
