//Complete CRUD for inventoryItem Model
public DataSet Get_ListInventoryItem(inventoryItemModel currentInventoryItem)
{//~~~~~~~~~~~ READ INVENTORY ITEM
DbCommand get_InventoryItem = db.GetStoredProcCommand("sp_readInventoryItem");
db.AddInParameter(get_InventoryItem, "@itemID", DbType.Int32, currentInventoryItem.itemID);
DataSet ds = db.ExecuteDataSet(get_InventoryItem);
return(ds); //RETURNS DATASET TO READ
}
public Boolean Delete_ListInventoryItem(inventoryItemModel currentEvent)
{//~~~~~~~~~ DELETE INVENTORY ITEM
Boolean success = false;
DbCommand Delete_InventoryItem = db.GetStoredProcCommand("sp_DeleteInventoryItem");
db.AddInParameter(Delete_InventoryItem, "@itemID", DbType.Int32, currentEvent.itemID);
DataSet ds = db.ExecuteDataSet(Delete_InventoryItem);
success = Convert.ToBoolean(Delete_InventoryItem.ExecuteNonQuery());
return(success);//RETURNS IF COMPLETED CORRECTLY
}
public Boolean Update_ListInventoryItem(inventoryItemModel currentInventoryItem)
{//~~~~~~~~~ UPDATE INVENTORY ITEM
Boolean success = false;
DbCommand Update_InventoryItem = db.GetStoredProcCommand("sp_UpdateInventoryItem");
db.AddInParameter(Update_InventoryItem, "@inventoryIDFK", DbType.Int32, currentInventoryItem.inventoryIDFK);
db.AddInParameter(Update_InventoryItem, "@categoryIDFK", DbType.Int32, currentInventoryItem.categoryIDFK);
db.AddInParameter(Update_InventoryItem, "@itemName", DbType.String, currentInventoryItem.itemName);
db.AddInParameter(Update_InventoryItem, "@itemPrice", DbType.Int32, currentInventoryItem.itemPrice);
db.AddInParameter(Update_InventoryItem, "@itemDescription", DbType.String, currentInventoryItem.itemDescription);
db.AddInParameter(Update_InventoryItem, "@itemUPC", DbType.Int32, currentInventoryItem.itemUPC);
success = Convert.ToBoolean(Update_InventoryItem.ExecuteNonQuery());
return(success);//RETURNS IF COMPLETED CORRECTLY
}
