public BoInventoryItem Dao_getInventoryItemById(int pIdInventoryItem)
{
SqlConnection lConex = new SqlConnection();
using (lConex = Dao_SqlConnection(lConex))
{
try
{
var lCommand = new SqlCommand
{
CommandText = "spr_GetInventoryItem",
CommandTimeout = 30,
CommandType = CommandType.StoredProcedure,
Connection = lConex
};
lCommand.Parameters.Add(new SqlParameter("IdInventoryItem", pIdInventoryItem));
var lReader = lCommand.ExecuteReader();
var oInventoryItem = new BoInventoryItem();
if (lReader.HasRows)
{
while (lReader.Read())
{
oInventoryItem.LStatus = new BoStatus();
oInventoryItem.LObject = new BoObject();
oInventoryItem.LProduct = new BoProduct();
oInventoryItem.LInventory = new BoInventory();
oInventoryItem.LIdInventoryItem = Convert.ToInt32(lReader["IdInventoryItem"].ToString());
oInventoryItem.LInventory.LIdInventory = Convert.ToInt32(lReader["IdInventory"].ToString());
oInventoryItem.LInventory.LNameInventory = lReader["NameInventory"].ToString();
oInventoryItem.LProduct.LIdProduct = Convert.ToInt32(lReader["IdProduct"].ToString());
oInventoryItem.LProduct.LNameProduct = lReader["NameProduct"].ToString();
oInventoryItem.LCreationDate = Convert.ToDateTime(lReader["CreationDate"].ToString());
oInventoryItem.LStatus.LIdStatus = lReader["IdStatus"].ToString();
oInventoryItem.LQtySellable = Convert.ToDecimal(lReader["QtySellable"].ToString());
oInventoryItem.LQtyNonSellable = Convert.ToDecimal(lReader["QtyNonSellable"].ToString());
oInventoryItem.LObject.LIdObject = Convert.ToInt32(lReader["IdObject"].ToString());
}
}
Dao_CloseSqlconnection(lConex);
return(oInventoryItem);
}
catch (Exception e)
{
var lInventoryItem = new BoInventoryItem
{
LException = e.Message,
LMessageDao = BoErrors.MsgErrorGetSql
};
if (e.InnerException != null)
{
lInventoryItem.LInnerException = e.InnerException.ToString();
}
Dao_CloseSqlconnection(lConex);
return(lInventoryItem);
}
}
}
public string bll_DeleteInventoryItem(int pIdInventoryItem)
{
var oInventoryItem = new BoInventoryItem {
LIdInventoryItem = pIdInventoryItem
};
return(this.LiDaoInventoryItem.Dao_DeleteInventoryItem(oInventoryItem));
}
public string Dao_SubstractInventoryItem(BoInventoryItem pInventoryItem)
{
this.LListParam = new List <SqlParameter>();
dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInventory", pInventoryItem.LInventory.LIdInventory.ToString());
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@CdProduct", pInventoryItem.LProduct.LCdProduct);
dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@QtySellable", pInventoryItem.LQtySellable.ToString(CultureInfo.CurrentCulture));
return(Dao_executeSqlScalarWithProcedement(this.LListParam, "LTranSubstractInventoryItem", "spr_substractinventory"));
}
public string Dao_InsertInventoryItem(BoInventoryItem pInventoryItem)
{
this.LListParam = new List <SqlParameter>();
dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdProduct", pInventoryItem.LProduct.LIdProduct.ToString());
dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInventory", pInventoryItem.LInventory.LIdInventory.ToString());
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pInventoryItem.LStatus.LIdStatus);
dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdObject", pInventoryItem.LObject.LIdObject.ToString());
dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@QtySellable", pInventoryItem.LQtySellable.ToString(CultureInfo.CurrentCulture));
dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@QtyNonSellable", pInventoryItem.LQtyNonSellable.ToString(CultureInfo.CurrentCulture));
return(Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranInsertInventoryItem", "spr_CreateInventoryItem"));
}
public string bll_SubstractInventoryItem(BoOrderItem pOrderItem, int lIdInventory)
{
var lInventoryItem = new BoInventoryItem
{
LProduct = new BoProduct {
LCdProduct = pOrderItem.LProduct.LCdProduct
},
LInventory = new BoInventory {
LIdInventory = lIdInventory
},
LQtySellable = pOrderItem.LQty
};
var lResult = this.LiDaoInventoryItem.Dao_SubstractInventoryItem(lInventoryItem);
return(lResult == EBooleans.Trues.GetHashCode().ToString() ? null : BoErrors.MsgEmptyProductWithcode.Replace(BoErrors.ReplaceInString1, pOrderItem.LProduct.LCdProduct));
}
public string bll_InsertInventoryItem(int pIdInventory, int pIdProduct, int pIdObject, string pIdStatus, decimal pQtySellable, decimal pQtyNonSellable)
{
var oInventoryItem = new BoInventoryItem
{
LObject = new BoObject {
LIdObject = pIdObject
},
LStatus = new BoStatus {
LIdStatus = pIdStatus
},
LProduct = new BoProduct {
LIdProduct = pIdProduct
},
LInventory = new BoInventory {
LIdInventory = pIdInventory
},
LQtyNonSellable = pQtyNonSellable,
LQtySellable = pQtySellable
};
return(this.LiDaoInventoryItem.Dao_InsertInventoryItem(oInventoryItem));
}
public static MInventoryItem MInventoryItemById(this BoInventoryItem pInventoryItem)
{
var oMInventoryItem = new MInventoryItem
{
LStatus = new MStatus
{
LIdStatus = pInventoryItem.LStatus.LIdStatus,
LDsEstado = pInventoryItem.LStatus.LDsEstado
},
LListStatus = new List <SelectListItem>(),
LListProduct = new List <SelectListItem>(),
LProduct = new MProduct
{
LIdProduct = pInventoryItem.LProduct.LIdProduct,
LNameProduct = pInventoryItem.LProduct.LNameProduct
},
LIdInventoryItem = pInventoryItem.LIdInventoryItem,
LInventory = new MInventory
{
LIdInventory = pInventoryItem.LInventory.LIdInventory,
LNameInventory = pInventoryItem.LInventory.LNameInventory
},
LQtySellable = pInventoryItem.LQtySellable,
LQtyNonSellable = pInventoryItem.LQtyNonSellable,
LCreationDate = pInventoryItem.LCreationDate,
LObject = new MObject
{
LIdObject = pInventoryItem.LObject.LIdObject,
LNameObject = pInventoryItem.LObject.LNameObject
}
};
oMInventoryItem.LListStatus = LiStatus.Bll_getListStatusByIdObject(oMInventoryItem.LObject.LIdObject).MListAllStatus();
oMInventoryItem.LListProduct = LiProduct.bll_GetAllProduct().MListAllProduct(true);
return(oMInventoryItem);
}
public string Dao_DeleteInventoryItem(BoInventoryItem pInventoryItem)
{
this.LListParam = new List <SqlParameter>();
dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInventoryItem", pInventoryItem.LIdInventoryItem.ToString());
return(Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranDeleteInventoryItem", "spr_DeleteInventoryItem"));
}
// GET: InventoryItem/Details/5
public ActionResult Details(int id)
{
BoInventoryItem lOInventoryItem = this.LInventoryItem.bll_GetInventoryItemById(id);
return(this.View(lOInventoryItem.MInventoryItemById()));
}
public List <BoInventoryItem> Dao_getInventoryReport()
{
SqlConnection lConex = new SqlConnection();
using (lConex = Dao_SqlConnection(lConex))
{
var lListReport = new List <BoInventoryItem>();
try
{
var lCommand = new SqlCommand
{
CommandText = "spr_ReportInventory",
CommandTimeout = 30,
CommandType = CommandType.StoredProcedure,
Connection = lConex
};
var lReader = lCommand.ExecuteReader();
if (lReader.HasRows)
{
while (lReader.Read())
{
var lReport = new BoInventoryItem
{
LInventory = new BoInventory
{
LIdInventory = Convert.ToInt32(lReader["IdInventory"].ToString()),
LNameInventory = lReader["NameInventory"].ToString()
},
LProduct = new BoProduct
{
LIdProduct = Convert.ToInt32(lReader["IdProduct"].ToString()),
LCdProduct = lReader["CdProduct"].ToString(),
LNameProduct = lReader["NameProduct"].ToString()
},
LQtySellable = Convert.ToDecimal(lReader["QtySellable"].ToString()),
LQtyNonSellable = Convert.ToDecimal(lReader["QtyNonSellable"].ToString()),
};
lListReport.Add(lReport);
}
}
Dao_CloseSqlconnection(lConex);
return(lListReport);
}
catch (Exception e)
{
lListReport = new List <BoInventoryItem>();
var lReport = new BoInventoryItem
{
LException = e.Message,
LMessageDao = BoErrors.MsgErrorGetSql
};
if (e.InnerException != null)
{
lReport.LInnerException = e.InnerException.ToString();
}
Dao_CloseSqlconnection(lConex);
lListReport.Add(lReport);
return(lListReport);
}
}
}
