public string bll_DeleteInvoiceItem(int pIdInvoiceItem) { var lInvoiceItem = new BoInvoiceItem { LIdInvoiceItem = pIdInvoiceItem }; return(this.LiDaoInvoiceItem.Dao_DeleteInvoiceItem(lInvoiceItem)); }
public string Dao_UpdateInvoiceIem(BoInvoiceItem pInvoiceItem) { this.LListParam = new List <SqlParameter>(); dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInvoiceItem", pInvoiceItem.LIdInvoiceItem.ToString()); dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdProduct", pInvoiceItem.LProduct.LIdProduct.ToString()); dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pInvoiceItem.LStatus.LIdStatus); return(Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranUpdateInvoiceItem", "spr_UpdateInvoiceItem")); }
public string Dao_InsertInvoiceItem(BoInvoiceItem pInvoiceItem) { this.LListParam = new List <SqlParameter>(); dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInvoice", pInvoiceItem.LIdInvoice.ToString()); dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdProduct", pInvoiceItem.LProduct.LIdProduct.ToString()); dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@Qty", pInvoiceItem.LQuantity.ToString(CultureInfo.CurrentCulture)); dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@ValueProduct", pInvoiceItem.LValueProd.ToString(CultureInfo.CurrentCulture)); dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@ValueDesc", pInvoiceItem.LValueDesc.ToString(CultureInfo.CurrentCulture)); dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@ValueSupplier", pInvoiceItem.LValueSupplier.ToString(CultureInfo.CurrentCulture)); dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@ValueTaxes", pInvoiceItem.LValueTaxes.ToString(CultureInfo.CurrentCulture)); dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@ValueTotal", pInvoiceItem.LValueTotal.ToString(CultureInfo.CurrentCulture)); dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pInvoiceItem.LStatus.LIdStatus); dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdObject", pInvoiceItem.LObject.LIdObject.ToString()); return(Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranInsertInvoiceItem", "spr_CreateInvoiceItem")); }
public string bll_UpdateInvoiceTem(int pIdInvoice, int pQuantity, int pIdProduct, int pIdObject, string pIdStatus) { var lInvoiceItem = new BoInvoiceItem { LObject = new BoObject { LIdObject = pIdObject }, LStatus = new BoStatus { LIdStatus = pIdStatus }, LProduct = new BoProduct { LIdProduct = pIdProduct }, LIdInvoice = pIdInvoice, LQuantity = pQuantity }; return(this.LiDaoInvoiceItem.Dao_UpdateInvoiceIem(lInvoiceItem)); }
public List <BoInvoiceItem> bll_ChangeOrderItemToInvoiceItem(List <BoOrderItem> lListOrderItem, BoObject lObjectInvoice) { var lListInvoiceItem = new List <BoInvoiceItem>(); lListOrderItem?.ForEach(x => { var lInvoiceItem = new BoInvoiceItem { LProduct = new BoProduct(), LQuantity = x.LQty, LValueProd = x.LValueProduct, LValueDesc = x.LValueDesc, LValueSupplier = x.LValueSupplier, LValueTaxes = x.LValueTaxes, LObject = lObjectInvoice }; lInvoiceItem.LProduct = this.LiProduct.bll_GetProductByCode(x.LProduct.LCdProduct); lListInvoiceItem.Add(lInvoiceItem); }); return(lListInvoiceItem); }
public string bll_InsertInvoiceItem(int pIdInvoice, decimal pQuantity, decimal pValueProduct, decimal pValueSupplier, decimal pValueTaxes, decimal pValueDesc, int pIdProduct, int pIdObject, string pIdStatus) { var lInvoiceItem = new BoInvoiceItem { LObject = new BoObject { LIdObject = pIdObject }, LStatus = new BoStatus { LIdStatus = pIdStatus }, LProduct = new BoProduct { LIdProduct = pIdProduct }, LIdInvoice = pIdInvoice, LQuantity = pQuantity, LValueDesc = pValueDesc, LValueProd = pValueProduct, LValueSupplier = pValueSupplier, LValueTaxes = pValueTaxes }; return(this.LiDaoInvoiceItem.Dao_InsertInvoiceItem(lInvoiceItem)); }
public List <BoInvoiceItem> Dao_getInvoiceItemByIdInvoice(int pIdInvoice) { SqlConnection lConex = new SqlConnection(); using (lConex = Dao_SqlConnection(lConex)) { var lListInvoiceItem = new List <BoInvoiceItem>(); try { var lCommand = new SqlCommand { CommandText = "spr_GetListInvoiceItem", CommandTimeout = 30, CommandType = CommandType.StoredProcedure, Connection = lConex }; lCommand.Parameters.Add(new SqlParameter("IdInvoice", pIdInvoice)); var lReader = lCommand.ExecuteReader(); if (lReader.HasRows) { while (lReader.Read()) { var lInvoiceItem = new BoInvoiceItem { LStatus = new BoStatus { LIdStatus = lReader["IdStatus"].ToString() }, LObject = new BoObject { LIdObject = Convert.ToInt32(lReader["IdObject"].ToString()) }, LProduct = new BoProduct { LIdProduct = Convert.ToInt32(lReader["IdProduct"].ToString()), LNameProduct = lReader["NameProduct"].ToString(), LCdProduct = lReader["CdProduct"].ToString() }, LIdInvoiceItem = Convert.ToInt32(lReader["IdInvoiceItem"].ToString()), LIdInvoice = Convert.ToInt32(lReader["IdInvoice"].ToString()), LQuantity = Convert.ToDecimal(lReader["Qty"].ToString()), LValueProd = Convert.ToDecimal(lReader["ValueProduct"].ToString()), LCreationDate = Convert.ToDateTime(lReader["CreationDate"].ToString()) }; lListInvoiceItem.Add(lInvoiceItem); } } Dao_CloseSqlconnection(lConex); return(lListInvoiceItem); } catch (Exception e) { lListInvoiceItem = new List <BoInvoiceItem>(); var lInvoiceItem = new BoInvoiceItem { LException = e.Message, LMessageDao = BoErrors.MsgErrorGetSql }; if (e.InnerException != null) { lInvoiceItem.LInnerException = e.InnerException.ToString(); } Dao_CloseSqlconnection(lConex); lListInvoiceItem.Add(lInvoiceItem); return(lListInvoiceItem); } } }
public string Dao_DeleteInvoiceItem(BoInvoiceItem pInvoiceItem) { this.LListParam = new List <SqlParameter>(); dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInvoiceItem", pInvoiceItem.LIdInvoiceItem.ToString()); return(Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranDeleteInvoiceItem", "spr_DeleteInvoiceItem")); }