public IActionResult Get()
{
BoProduct bo = new BoProduct();
IList <Product> list = bo.GetAllProduct();
return(Ok(list));
}
public string bll_UpdateProduct(int pIdProduct, string pNameProduct, string pCdProduct, decimal pPrice, decimal pPriceSupplier, int pIdUnit, int pIdSupplier, int pIdObject, string pIdStatus)
{
var lProduct = new BoProduct
{
LObject = new BoObject {
LIdObject = pIdObject
},
LStatus = new BoStatus {
LIdStatus = pIdStatus
},
LSupplier = new BoSupplier {
LIdSupplier = pIdSupplier
},
LUnit = new BoUnit {
LIdUnit = pIdUnit
},
LIdProduct = pIdProduct,
LNameProduct = pNameProduct,
LCdProduct = pCdProduct,
LValue = pPrice,
LValueSupplier = pPriceSupplier
};
return(this.LiDaoProduct.Dao_UpdateProduct(lProduct));
}
public string bll_DeleteProduct(int pIdProduct)
{
var lProduct = new BoProduct {
LIdProduct = pIdProduct
};
return(this.LiDaoProduct.Dao_DeleteProduct(lProduct));
}
public string Dao_InsertProduct(BoProduct pProduct)
{
this.LListParam = new List <SqlParameter>();
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@NameProduct", pProduct.LNameProduct);
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@CdProduct", pProduct.LCdProduct);
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdUnit", pProduct.LUnit.LIdUnit.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@Price", pProduct.LValue.ToString(CultureInfo.CurrentCulture));
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdSupplier", pProduct.LSupplier.LIdSupplier.ToString());
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@PriceSupplier", pProduct.LValueSupplier.ToString(CultureInfo.CurrentCulture));
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pProduct.LStatus.LIdStatus);
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdObject", pProduct.LObject.LIdObject.ToString());
return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranInsertProduct", "spr_CreateProduct"));
}
public static MProduct MProductById(this BoProduct pBoProduct)
{
var lMProduct = new MProduct
{
LObject = new MObject
{
LIdObject = pBoProduct.LObject.LIdObject,
LNameObject = pBoProduct.LObject.LNameObject
},
LStatus = new MStatus
{
LDsEstado = pBoProduct.LStatus.LDsEstado,
LIdStatus = pBoProduct.LStatus.LIdStatus
},
LUnit = new MUnit
{
LIdUnit = pBoProduct.LUnit.LIdUnit,
LNameUnit = pBoProduct.LUnit.LNameUnit,
LCdUnit = pBoProduct.LUnit.LCdUnit,
LFlActive = pBoProduct.LUnit.LFlActive
},
LListStatus = new List <SelectListItem>(),
LSupplier = new MSupplier
{
LIdSupplier = pBoProduct.LSupplier.LIdSupplier,
LNameSupplier = pBoProduct.LSupplier.LNameSupplier
},
LListSupplier = new List <SelectListItem>(),
LListTaxe = new List <MTaxe>(),
LListUnit = new List <SelectListItem>(),
LNameProduct = pBoProduct.LNameProduct,
LCdProduct = pBoProduct.LCdProduct,
LIdProduct = pBoProduct.LIdProduct,
LCreationDate = pBoProduct.LCreationDate,
LValue = pBoProduct.LValue,
LValueSupplier = pBoProduct.LValueSupplier
};
lMProduct.LListSupplier = LiSupplier.bll_GetAllSupplier().MListAllSupplier();
lMProduct.LListStatus = LiStatus.Bll_getListStatusByIdObject(pBoProduct.LObject.LIdObject).MListAllStatus();
lMProduct.LListUnit = LiUtilsLib.bll_GetAllUnit().MListAllUnitWithSelect();
lMProduct.LListTaxe = LiTaxe.bll_GetListallTaxesXProduct(pBoProduct.LIdProduct).MListAllTaxesXProduct(null);
return(lMProduct);
}
public JsonResult GetOrderItem(string cdProduct)
{
try
{
var lProduct = this.LiProduct.bll_GetProductByCode(cdProduct);
if (!lProduct.LStatus.LIdStatus.ValidateStatus())
{
lProduct = new BoProduct();
}
if (lProduct.LException != null)
{
return(this.Json(new { Success = false, Message = CodesError.LMsgErroDao + lProduct.LMessageDao + EMessages.LSpace + lProduct.LException }));
}
return(lProduct.LCdProduct != null?this.Json(new { Success = true, Content = lProduct.MProductById() }) : this.Json(new { Success = false, Message = CodesError.LMsgProductDontExists }));
}catch (Exception e)
{
return(this.Json(new { Success = false, Message = CodesError.LMsgError + e.Message }));
}
}
public static MProduct MProductEmpty(this BoProduct pBoProduct)
{
var lObject = LiUtilsLib.bll_GetObjectByName(MGlobalVariables.LNameObjectProduct);
var lMProduct = new MProduct
{
LObject = new MObject
{
LIdObject = lObject.LIdObject,
LNameObject = lObject.LNameObject
},
LStatus = new MStatus
{
LDsEstado = null,
LIdStatus = null
},
LUnit = new MUnit(),
LTaxe = new MTaxe(),
LListUnit = new List <SelectListItem>(),
LListStatus = new List <SelectListItem>(),
LListSupplier = new List <SelectListItem>(),
LListSelectTaxe = new List <SelectListItem>(),
LListTaxe = new List <MTaxe>(),
LNameProduct = null,
LCdProduct = null,
LValue = 0,
LListIdsTaxe = null,
LValueSupplier = 0,
LCreationDate = new DateTime()
};
lMProduct.LListStatus = LiStatus.Bll_getListStatusByIdObject(lMProduct.LObject.LIdObject).MListStatusWithSelect();
lMProduct.LListSupplier = LiSupplier.bll_GetAllSupplier().MListAllSupplierWithSelect(true);
lMProduct.LListUnit = LiUtilsLib.bll_GetAllUnit().MListAllUnitWithSelect();
lMProduct.LListSelectTaxe = LiTaxe.bll_GetListTaxes().MListTaxesWithSelect(true);
return(lMProduct);
}
// GET: Product/Create
public ActionResult Create()
{
var lBProduct = new BoProduct();
return(this.View(lBProduct.MProductEmpty()));
}
public BoProduct Dao_getProductByCode(string pCdProduct)
{
SqlConnection lConex = new SqlConnection();
using (lConex = DaoUtilsLib.Dao_SqlConnection(lConex))
{
var lProduct = new BoProduct();
try
{
var lCommand = new SqlCommand
{
CommandText = "spr_GetProductByCode",
CommandTimeout = 30,
CommandType = CommandType.StoredProcedure,
Connection = lConex
};
lCommand.Parameters.Add(new SqlParameter("CdProduct", pCdProduct));
var lReader = lCommand.ExecuteReader();
if (lReader.HasRows)
{
while (lReader.Read())
{
lProduct.LIdProduct = Convert.ToInt32(lReader["IdProduct"].ToString());
lProduct.LNameProduct = lReader["NameProduct"].ToString();
lProduct.LCdProduct = lReader["CdProduct"].ToString();
lProduct.LCreationDate = Convert.ToDateTime(lReader["CreationDate"].ToString());
lProduct.LUnit = new BoUnit {
LIdUnit = Convert.ToInt32(lReader["IdUnit"].ToString())
};
lProduct.LValue = Convert.ToDecimal(lReader["Price"].ToString());
lProduct.LSupplier = new BoSupplier
{
LIdSupplier = Convert.ToInt32(lReader["IdSupplier"].ToString())
};
lProduct.LValueSupplier = Convert.ToDecimal(lReader["PriceSupplier"].ToString());
lProduct.LStatus = new BoStatus
{
LIdStatus = lReader["IdStatus"].ToString(),
LDsEstado = lReader["DsEstado"].ToString()
};
lProduct.LObject = new BoObject
{
LIdObject = Convert.ToInt32(lReader["IdObject"].ToString()),
LNameObject = lReader["NameObject"].ToString()
};
}
}
DaoUtilsLib.Dao_CloseSqlconnection(lConex);
return(lProduct);
}
catch (Exception e)
{
lProduct = new BoProduct {
LException = e.Message, LMessageDao = BoErrors.MsgErrorGetSql
};
if (e.InnerException != null)
{
lProduct.LInnerException = e.InnerException.ToString();
}
DaoUtilsLib.Dao_CloseSqlconnection(lConex);
return(lProduct);
}
}
}
public string Dao_DeleteProduct(BoProduct pProduct)
{
this.LListParam = new List <SqlParameter>();
DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdProduct", pProduct.LIdProduct.ToString());
return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranDeleteProduct", "spr_DeleteProduct"));
}
