//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 }