// Method which is used to take User data from the AdminCrud page and sends it through a method call to DAL to be inserted in the database.
// Returns a bool to be used to tell the Admin user if the product was created successfully.
#region CreateProduct
public bool CreateProduct(string pType, string pName, double price, string pDescription, string imagePath)
{
bool successfull = true;
Product p = null;
#region MessageToAdmin
if ((pType == null || pType.Trim().Length == 0) ||
(pName == null || pName.Trim().Length == 0) ||
(price == 99999) ||
(pDescription == null || pDescription.Trim().Length == 0))
{
successfull = false;
}
#endregion MessageToAdmin
// Only objects of the Food class has an imgPath.
if (imagePath != null && imagePath.Trim().Length > 0)
{
p = new Food(pType, pName, price, pDescription, imagePath);
}
else
{
p = new Drinks(pType, pName, price, pDescription);
}
successfull = DAL.CreateProduct(p);
return(successfull);
}
// Returns a list of Drinks/Beverages from the database to be displayed on the menu page (through the productmanager).
#region GetBeverages
public static List <Drinks> GetBeverages()
{
List <Drinks> allBeverages = new List <Drinks>();
using (SqlConnection connection = new SqlConnection(conn))
{
connection.Open();
SqlCommand cmd = new SqlCommand(@"DECLARE @return_value int
EXEC @return_value = [dbo].[SP_ProductGetBeverages]", connection);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
string pName = (string)rdr["PName"];
decimal price = (decimal)rdr["price"];
string pDescription = (string)rdr["PDescription"];
Drinks d = new Drinks(pName, Convert.ToDouble(price), pDescription);
allBeverages.Add(d);
}
}
return(allBeverages);
}
