public vmQuotation GetQuotationMasterById(int?QuotationId, int CompanyID)
{
vmQuotation lstQuotation = null;
GFactory_GF_Quotation = new vmQuotation_GF();
string spQuery = string.Empty;
try
{
Hashtable ht = new Hashtable();
ht.Add("QuotationID", QuotationId);
ht.Add("CompanyId", CompanyID);
spQuery = "[dbo].[Get_PurchaseQuotationMaster]";
lstQuotation = GFactory_GF_Quotation.ExecuteCommandSingle(spQuery, ht);
}
catch (Exception e)
{
e.ToString();
}
return(lstQuotation);;
//try
//{
// using (_ctxCmn = new ERP_Entities())
// {
// lstQuotation = (from qcm in _ctxCmn.PurchaseQuotationMasters.Where(s => s.IsDeleted == false && s.QuotationID == QuotationId && s.CompanyID == CompanyID)
// join re in _ctxCmn.InvRequisitionMasters on qcm.RequisitionID equals re.RequisitionID
// join org in _ctxCmn.CmnUsers on qcm.PartyID equals org.UserID
// join cm in _ctxCmn.CmnComboes on qcm.QuotationTypeID equals cm.ComboID
// join curr in _ctxCmn.AccCurrencyInfoes on qcm.CurrencyID equals curr.Id
// select new vmQuotation
// {
// RequisitionNo = re.RequisitionNo,
// RequisitionID = re.RequisitionID,
// QuotationID = qcm.QuotationID,
// QuotationNo = qcm.QuotationNo,
// QuotationDate = qcm.QuotationDate,
// SPRDate = re.RequisitionDate,
// DeliveryDate = qcm.DeliveryDate,
// UserID = org.UserID,
// UserFullName = org.UserFullName,
// ComboID = cm.ComboID,
// ComboName = cm.ComboName,
// CurrencyID = qcm.CurrencyID,
// Currency = curr.CurrencyName,
// Remarks = qcm.Remarks
// });
// }
//}
//catch (Exception ex)
//{
// ex.ToString();
//}
}
public vmQuotation GetQuotationMasterById(int?QuotationId, int CompanyID)
{
vmQuotation Quotationlist = null;
try
{
Quotationlist = objQuotationService.GetQuotationMasterById(QuotationId, CompanyID);
}
catch (Exception e)
{
e.ToString();
}
return(Quotationlist);
}
