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