public void CopyQuotation(Model.Quotation fromquotation, Model.Quotation toQuotation) { if (fromquotation == null) { return; } Connection.Execute("CopyQuotation", new { @FromQuotationCode = fromquotation.QuotationCode, @ToQuotationCode = toQuotation.QuotationCode }, commandType: CommandType.StoredProcedure, transaction: Transaction); }
public List <Model.QuotationDetail> Find(Model.Quotation quotation) { if (quotation == null) { return(null); } return(Connection.Query <Model.QuotationDetail, Model.Product, Model.Unit, Model.QuotationDetail>("GetAllProductByQuotation", (qd, p, u) => { qd.Product = p; p.Unit = u; return qd; } , param: new { @quotationCode = quotation.QuotationCode }, splitOn: "ProductCode,UnitName", commandType: CommandType.StoredProcedure, transaction: Transaction).ToList()); }
private async Task <double> UpdateAmount(double purchaseAmount, Model.Quotation quotation, Currencies currencyVal) { switch (currencyVal) { case Currencies.Dollar: { return(purchaseAmount / quotation.Compra); } case Currencies.Real: { return(purchaseAmount / quotation.Compra); } default: return(0); } }
//public delegate void delgBindCompany(int companyId); //public delgBindCompany BindCompany; private void gridView1_DoubleClick(object sender, EventArgs e) { IList <Model.QuotationDetail> lstProduct; Model.Quotation quotation = gridUtility.GetSelectedItem <Model.Quotation>() as Model.Quotation; if (quotation == null) { return; } using (IUnitOfWork uow = new UnitOfWork()) { lstProduct = uow.QuotationDetailRepository.Find(quotation); uow.Commit(); } if (GetAllProduct != null) { GetAllProduct(lstProduct, quotation); } Close(); }
public Model.QuotationDetail Find(Model.Quotation quotation, Model.Product product) { return(Connection.Query <Model.QuotationDetail>("select * from QuotationDetail where QuotationCode = @quotationCode and ProductId=@productId", param: new { quotationCode = quotation.QuotationCode, productId = product.ProductId }, transaction: Transaction).FirstOrDefault()); }
public List <Model.Product> GetAllProduct(Model.Quotation quotation) { return(Connection.Query <Model.Product>(@"select p.ProductId,ProductCode,Photo,pd.Quantity from Product p inner join QuotationDetail pd on p.ProductId = pd.ProductId where pd.QuotationCode = @quotationCode", new { quotationCode = quotation.QuotationCode }, transaction: Transaction).ToList()); }