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