public List <VE_Product> GetProduct() { BE_Product bE_Product = new BE_Product(); _database = new MySQLDatabase(connectionString); return(GetProductGeneral(bE_Product, "")); }
public BE_Product UpdateProduct(BE_Product bE_Product) { _database = new MySQLDatabase(connectionString); var list = GetProduct(); foreach (var i in list) { if (i.code == bE_Product.code && i.productId != bE_Product.productId) { return(null); } } var updatedProduct = new DA_Product(_database).UpdateProduct(bE_Product); if (updatedProduct.detail != null) { DeleteProductDetailByProductId(updatedProduct.productId); foreach (var detail in updatedProduct.detail) { detail.productId = updatedProduct.productId; CreateProductDetail(detail); } } return(updatedProduct); }
public BE_Json UpdateProduct([FromBody] BE_Product bE_Product) { BE_Json objJson = null; var objListaAux = string.Empty; try { BL_Product bL_Product = new BL_Product(); bL_Product.connectionString = AppConfig.DbConnection; objListaAux = JsonConvert.SerializeObject(bL_Product.UpdateProduct(bE_Product)); objJson = new BE_Json(); objJson.data = (objListaAux == "null") ? "No se pudo editar el producto: El código ya existe" : objListaAux; objJson.status = (objListaAux == "null") ? CManager.RESULTADO_WCF.ERROR : CManager.RESULTADO_WCF.OK; } catch (Exception ex) { objJson = new BE_Json(); objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString(); objJson.status = CManager.RESULTADO_WCF.ERROR; objJson.status = CManager.RESULTADO_WCF.ERROR; } finally { objListaAux = null; } return(objJson); }
public BE_Json CreateProduct([FromBody] BE_Product bE_Product) { logger.Debug("Ingresando CreateProduct step 1 : " + JsonConvert.SerializeObject(bE_Product)); BE_Json objJson = null; var objListaAux = string.Empty; try { BL_Product bL_Product = new BL_Product(); bL_Product.connectionString = AppConfig.DbConnection; logger.Debug("CreateProduct step 2"); objListaAux = JsonConvert.SerializeObject(bL_Product.CreateProduct(bE_Product)); logger.Debug("CreateProduct step 3"); objJson = new BE_Json(); objJson.data = (objListaAux == "null") ? "No de pudo crear el producto: El código ya existe" : objListaAux; objJson.status = (objListaAux == "null")?CManager.RESULTADO_WCF.ERROR:CManager.RESULTADO_WCF.OK; logger.Debug("CreateProduct step 4"); } catch (Exception ex) { logger.Fatal(ex, "CreateProduct " + ex.Message); objJson = new BE_Json(); objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString(); objJson.status = CManager.RESULTADO_WCF.ERROR; } finally { objListaAux = null; } logger.Debug("CreateProduct step 5"); return(objJson); }
public BE_Product UpdateProduct(BE_Product bE_Product) { int filasAfectadas = 0; string strError_Mensaje = string.Empty; bool boResultado = false; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_productId", (bE_Product.productId == 0) ? DBNull.Value : (object)bE_Product.productId); parameters.Add("_code", bE_Product.code); parameters.Add("_name", bE_Product.name); parameters.Add("_productTypeId", bE_Product.productTypeId); parameters.Add("_productCategoryId", (bE_Product.productCategoryId == 0) ? DBNull.Value : (object)bE_Product.productCategoryId); parameters.Add("_cost", bE_Product.cost); parameters.Add("_salePrice", bE_Product.salePrice); parameters.Add("_quantity", (bE_Product.quantity == 0) ? DBNull.Value : (object)bE_Product.quantity); parameters.Add("_measuredUnitId", (bE_Product.measuredUnitId == 0) ? DBNull.Value : (object)bE_Product.measuredUnitId); parameters.Add("_dietId", (bE_Product.dietId == 0) ? DBNull.Value : (object)bE_Product.dietId); parameters.Add("_headquartersId", (bE_Product.headquartersId == 0) ? DBNull.Value : (object)bE_Product.headquartersId); parameters.Add("_kcalTotal", (bE_Product.kcalTotal == 0) ? DBNull.Value : (object)bE_Product.kcalTotal); parameters.Add("_waste", bE_Product.waste); parameters.Add("_costbyRecipeMeasureUnit", bE_Product.costbyRecipeMeasureUnit); parameters.Add("_RecipeMeasureUnitId", (bE_Product.RecipeMeasureUnitId == 0) ? DBNull.Value : (object)bE_Product.RecipeMeasureUnitId); filasAfectadas = _database.ExecuteSP("sp_updateProduct", parameters); boResultado = (filasAfectadas > 0); if (boResultado) { return(bE_Product); } return(null); }
public List <VE_Product> GetProductByTypeId(string productTypeIdList) { BE_Product bE_Product = new BE_Product(); _database = new MySQLDatabase(connectionString); return(GetProductGeneral(bE_Product, productTypeIdList)); }
public List <VE_Product> GetProductByCategoryId(int productCategoryId) { BE_Product bE_Product = new BE_Product(); bE_Product.productCategoryId = productCategoryId; _database = new MySQLDatabase(connectionString); return(GetProductGeneral(bE_Product, "")); }
public List <VE_Product> GetProductByCode(string code) { BE_Product bE_Product = new BE_Product(); bE_Product.code = code; _database = new MySQLDatabase(connectionString); return(GetProductGeneral(bE_Product, "")); }
public List <VE_Product> GetProductByDietId(int dietId) { BE_Product bE_Product = new BE_Product(); bE_Product.dietId = dietId; _database = new MySQLDatabase(connectionString); return(GetProductGeneral(bE_Product, "")); }
public List <VE_Product> GetProductByHeadquartersId(int headquartersId) { BE_Product bE_Product = new BE_Product(); bE_Product.headquartersId = headquartersId; _database = new MySQLDatabase(connectionString); return(GetProductGeneral(bE_Product, "")); }
public List <VE_Product> GetProductByTypeIdAndDietId(int dietId, string productTypeIdList) { BE_Product bE_Product = new BE_Product(); bE_Product.dietId = dietId; _database = new MySQLDatabase(connectionString); return(GetProductGeneral(bE_Product, productTypeIdList)); }
public List <VE_Product> GetProductByName(string name) { BE_Product bE_Product = new BE_Product(); bE_Product.name = name; _database = new MySQLDatabase(connectionString); return(GetProductGeneral(bE_Product, "")); }
public BL_ProductTest() { List <VE_Product> lista = BL_ProductTest.get(); BE_Product obj = lista.Count == 0 ? new BE_Product() { } : (BE_Product)lista[0]; obj.code = obj.code + "777"; //obj = BL_ProductTest.create((BE_Product)obj); BL_ProductTest.Update(obj); BL_ProductTest.Delete(obj); }
public static void Update(BE_Product BE_Product) { try { BL_Product BL_Product = new BL_Product(); BL_Product.connectionString = ConfigurationManager.ConnectionStrings["pagosapp"].ConnectionString;; BE_Product result = BL_Product.UpdateProduct(BE_Product); } catch (Exception ex) { throw; } }
private static void Delete(BE_Product BE_Product) { try { BL_Product BL_Product = new BL_Product(); BL_Product.connectionString = ConfigurationManager.ConnectionStrings["pagosapp"].ConnectionString;; int result = BL_Product.DeleteProduct(BE_Product.productId); } catch (Exception ex) { throw ex; } }
public BE_Product CreateProduct(BE_Product bE_Product) { bool bOk = true; _database = new MySQLDatabase(connectionString); BL_Invoice bL_Invoice = new BL_Invoice(); bL_Invoice.connectionString = connectionString; int filas = GetProductByCode(bE_Product.code).Count; if (filas > 0) { return(null); } if (filas != 0) { bOk = false; } if (bOk) { BE_InvoiceItem BE_InvoiceItem = bL_Invoice.AddInvoiceItem(new BE_InvoiceItem() { companyCode = bE_Product.CompanyCode , igvAffected = true , IsEnabled = true , invoiceItemType = "P" , name = bE_Product.code + "-" + bE_Product.name }); bE_Product.invoiceItemId = BE_InvoiceItem.invoiceItemId; } var newProduct = new DA_Product(_database).CreateProduct(bE_Product); if (bOk && newProduct.detail != null) { foreach (var detail in newProduct.detail) { detail.productId = newProduct.productId; CreateProductDetail(detail); } } return(newProduct); }
public static BE_Product create(BE_Product view) { try { BL_Product BL_Product = new BL_Product(); //view..UserAudit = "carlosaban"; BL_Product.connectionString = ConfigurationManager.ConnectionStrings["pagosapp"].ConnectionString;; BE_Product result = BL_Product.CreateProduct(view); return(result); } catch (Exception ex) { throw ex; } }
public List <VE_Product> GetProductGeneral(BE_Product bE_Product, string productTypeIdList) { VE_Product _bE_Product = null; List <VE_Product> _lstProduct = new List <VE_Product>(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_productId", (bE_Product.productId == 0)?DBNull.Value: (object)bE_Product.productId); parameters.Add("_code", bE_Product.code); parameters.Add("_name", bE_Product.name); parameters.Add("_productTypeIdList", productTypeIdList); parameters.Add("_productCategoryId", (bE_Product.productCategoryId == 0) ? DBNull.Value : (object)bE_Product.productCategoryId); parameters.Add("_dietId", (bE_Product.dietId == 0) ? DBNull.Value : (object)bE_Product.dietId); parameters.Add("_headquartersId", (bE_Product.headquartersId == 0) ? DBNull.Value : (object)bE_Product.headquartersId); var rows = _database.QuerySP("sp_getProductGeneral", parameters); foreach (var row in rows) { _bE_Product = new VE_Product(); _bE_Product.productId = string.IsNullOrEmpty(row["productId"]) ? 0 : int.Parse(row["productId"]); _bE_Product.code = row["code"]; _bE_Product.name = row["name"]; _bE_Product.productTypeId = string.IsNullOrEmpty(row["productTypeId"]) ? 0 : int.Parse(row["productTypeId"]); _bE_Product.productTypeName = row["productTypeName"]; _bE_Product.productCategoryId = string.IsNullOrEmpty(row["productCategoryId"]) ? 0 : int.Parse(row["productCategoryId"]); _bE_Product.productCategoryName = row["productCategoryName"]; _bE_Product.cost = string.IsNullOrEmpty(row["cost"]) ? 0 : decimal.Parse(row["cost"]); _bE_Product.salePrice = string.IsNullOrEmpty(row["salePrice"]) ? 0 : decimal.Parse(row["salePrice"]); _bE_Product.isEnabled = string.IsNullOrEmpty(row["isEnabled"]) ? false : row["isEnabled"].Equals("1") ? true : false; _bE_Product.quantity = string.IsNullOrEmpty(row["quantity"]) ? 0 : decimal.Parse(row["quantity"]); _bE_Product.measuredUnitId = string.IsNullOrEmpty(row["measuredUnitId"]) ? 0 : int.Parse(row["measuredUnitId"]); _bE_Product.measuredUnitName = row["measuredUnitName"]; _bE_Product.dietId = string.IsNullOrEmpty(row["dietId"]) ? 0 : int.Parse(row["dietId"]); _bE_Product.dietName = row["dietName"]; _bE_Product.headquartersId = string.IsNullOrEmpty(row["headquartersId"]) ? 0 : int.Parse(row["headquartersId"]); _bE_Product.headquartersName = row["headquartersName"]; _bE_Product.kcalTotal = string.IsNullOrEmpty(row["kcalTotal"]) ? 0 : int.Parse(row["kcalTotal"]); _bE_Product.waste = string.IsNullOrEmpty(row["waste"]) ? 0 : decimal.Parse(row["waste"]); _bE_Product.costbyRecipeMeasureUnit = string.IsNullOrEmpty(row["costbyRecipeMeasureUnit"]) ? 0 : decimal.Parse(row["costbyRecipeMeasureUnit"]); _bE_Product.RecipeMeasureUnitId = string.IsNullOrEmpty(row["RecipeMeasureUnitId"]) ? 0 : int.Parse(row["RecipeMeasureUnitId"]); _lstProduct.Add(_bE_Product); } return(_lstProduct); }
public BE_Product CreateProduct(BE_Product bE_Product) { string strError_Mensaje = string.Empty; bool boResultado = false; try { logger.Debug("In CreateProduct(bE_Product) "); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_code", bE_Product.code); parameters.Add("_name", bE_Product.name); parameters.Add("_productTypeId", bE_Product.productTypeId); parameters.Add("_productCategoryId", (bE_Product.productCategoryId == 0) ? DBNull.Value : (object)bE_Product.productCategoryId); parameters.Add("_cost", bE_Product.cost); parameters.Add("_salePrice", bE_Product.salePrice); parameters.Add("_quantity", (bE_Product.quantity == 0) ? DBNull.Value : (object)bE_Product.quantity); parameters.Add("_measuredUnitId", (bE_Product.measuredUnitId == 0) ? DBNull.Value : (object)bE_Product.measuredUnitId); parameters.Add("_dietId", (bE_Product.dietId == 0) ? DBNull.Value : (object)bE_Product.dietId); parameters.Add("_headquartersId", (bE_Product.headquartersId == 0) ? DBNull.Value : (object)bE_Product.headquartersId); parameters.Add("_kcalTotal", (bE_Product.kcalTotal == 0) ? DBNull.Value : (object)bE_Product.kcalTotal); parameters.Add("_waste", bE_Product.waste); parameters.Add("_costbyRecipeMeasureUnit", bE_Product.costbyRecipeMeasureUnit); parameters.Add("_RecipeMeasureUnitId", (bE_Product.RecipeMeasureUnitId == 0) ? DBNull.Value : (object)bE_Product.RecipeMeasureUnitId); var productId = _database.ExecuteSPGetId("sp_createProduct", parameters); boResultado = (productId != null); if (boResultado) { bE_Product.productId = int.Parse(productId.ToString()); return(bE_Product); } return(null); } catch (Exception ex) { logger.Fatal(ex, "CreateProduct(bE_Product) Exception: " + ex.Message); throw ex; } }
private List <VE_Product> GetProductGeneral(BE_Product bE_Product, string productTypeIdList) { _database = new MySQLDatabase(connectionString); return(new DA_Product(_database).GetProductGeneral(bE_Product, productTypeIdList)); }