//CRUD FOR INVENTORY ENTITY
public DataSet Get_ListInventory(inventoryModel currentInventory)
{//~~~~~~~~~ READ INVENTORY
DbCommand get_Inventory = db.GetStoredProcCommand("sp_readInventory");
db.AddInParameter(get_Inventory, "@itemID", DbType.Int32, currentInventory.inventoryID);
DataSet ds = db.ExecuteDataSet(get_Inventory);
return(ds);//RETURNS DATASET TO READ
}
public Boolean Delete_ListInventory(inventoryModel currentEvent)
{//~~~~~~~~~ DELETE INVENTORY
Boolean success = false;
DbCommand Delete_Inventory = db.GetStoredProcCommand("sp_DeleteInventoryItem");
db.AddInParameter(Delete_Inventory, "@inventoryID", DbType.Int32, currentEvent.inventoryID);
DataSet ds = db.ExecuteDataSet(Delete_Inventory);
//RETURNS IF OPERATION WAS A SUCCESS
success = Convert.ToBoolean(Delete_Inventory.ExecuteNonQuery());
return(success);
}
public Boolean Update_ListInventory(inventoryModel currentInventory)
{////~~~~~~~~~ UPDATE INVENTORY
Boolean success = false;
DbCommand Update_Inventory = db.GetStoredProcCommand("sp_UpdateInventoryItem");
db.AddInParameter(Update_Inventory, "@donationIDFK", DbType.Int32, currentInventory.donationIDFK);
db.AddInParameter(Update_Inventory, "@categoryIDFK", DbType.String, currentInventory.categoryIDFK);
db.AddInParameter(Update_Inventory, "@inventoryQuantity", DbType.Int32, currentInventory.inventoryQuantity);
db.AddInParameter(Update_Inventory, "@inventoryDescription", DbType.String, currentInventory.inventoryDescription);
success = Convert.ToBoolean(Update_Inventory.ExecuteNonQuery());
return(success);//RETURNS IF OPERATION WAS A SUCCESS
}