Exemplo n.º 1
0
        public BE_ProductDetail CreateProductDetail(BE_ProductDetail bE_ProductDetail)
        {
            string strError_Mensaje = string.Empty;
            bool   boResultado      = false;

            Dictionary <string, object> parameters = new Dictionary <string, object>();

            parameters.Add("_quantity", bE_ProductDetail.quantity);
            parameters.Add("_kcal", bE_ProductDetail.kcal);
            parameters.Add("_cost", bE_ProductDetail.cost);
            parameters.Add("_productId", (bE_ProductDetail.productId == 0) ? DBNull.Value : (object)bE_ProductDetail.productId);
            parameters.Add("_productItemId", (bE_ProductDetail.productItemId == 0) ? DBNull.Value : (object)bE_ProductDetail.productItemId);
            parameters.Add("_measuredUnitId", (bE_ProductDetail.measuredUnitId == 0) ? DBNull.Value : (object)bE_ProductDetail.measuredUnitId);

            var productDetailId = _database.ExecuteSPGetId("sp_createProductDetail", parameters);

            boResultado = (productDetailId != null);
            if (boResultado)
            {
                bE_ProductDetail.productDetailId = int.Parse(productDetailId.ToString());
                return(bE_ProductDetail);
            }
            return(null);
        }
Exemplo n.º 2
0
 private BE_ProductDetail CreateProductDetail(BE_ProductDetail bE_ProductDetail)
 {
     _database = new MySQLDatabase(connectionString);
     return(new DA_Product(_database).CreateProductDetail(bE_ProductDetail));
 }