public List <FoodItemCost> GetItem()
{
try
{
Query = "SELECT * FROM FoodItemCost";
Command.CommandText = Query;
Command.Connection = Connection;
Connection.Open();
Reader = Command.ExecuteReader();
List <FoodItemCost> itemCosts = new List <FoodItemCost>();
if (Reader.HasRows)
{
while (Reader.Read())
{
FoodItemCost item = new FoodItemCost();
item.Id = Convert.ToInt32(Reader["Id"].ToString());
item.Name = Reader["Name"].ToString();
itemCosts.Add(item);
}
Reader.Close();
}
return(itemCosts);
}
catch (Exception exception)
{
return(null);
}
finally
{
Connection.Close();
}
}
public List <FoodItemCost> ShowAllFoodItemCost()
{
try
{
Query = "SELECT*FROM FoodItemCost";
Command.CommandText = Query;
Command.Connection = Connection;
Connection.Open();
Reader = Command.ExecuteReader();
List <FoodItemCost> foodItemCosts = new List <FoodItemCost>();
if (Reader.HasRows)
{
while (Reader.Read())
{
FoodItemCost foodItemCost = new FoodItemCost();
foodItemCost.Id = Convert.ToInt32(Reader["Id"].ToString());
foodItemCost.Name = Reader["Name"].ToString();
foodItemCost.Cost = Convert.ToDecimal(Reader["Cost"].ToString());
foodItemCost.ItemDescription = Reader["ItemDescription"].ToString();
foodItemCosts.Add(foodItemCost);
}
Reader.Close();
}
return(foodItemCosts);
}
catch (Exception exception)
{
return(null);
}
finally
{
Connection.Close();
}
}
public int Save(FoodItemCost foodItemCost)
{
try
{
Query = "INSERT INTO FoodItemCost(Name,Cost,ItemDescription) VALUES(@Name,@Cost,@ItemDescription)";
Command.CommandText = Query;
Command.Connection = Connection;
Command.Parameters.Clear();
Command.Parameters.Add("Name", SqlDbType.VarChar);
Command.Parameters["Name"].Value = foodItemCost.Name;
Command.Parameters.Add("Cost", SqlDbType.Decimal);
Command.Parameters["Cost"].Value = foodItemCost.Cost;
Command.Parameters.Add("ItemDescription", SqlDbType.VarChar);
Command.Parameters["ItemDescription"].Value = foodItemCost.ItemDescription;
Connection.Open();
int rowsAffected = Command.ExecuteNonQuery();
return(rowsAffected);
}
catch (Exception exception)
{
return(0);
}
finally
{
Connection.Close();
}
}
public bool Save(FoodItemCost foodItemCost)
{
if (IsFoodExists(foodItemCost.Name))
{
throw new Exception("Sorry!!!Food Item already Exists");
}
return(foodItemCostGateway.Save(foodItemCost) > 0);
}
public ActionResult Save(FoodItemCost foodItemCost)
{
try
{
ViewBag.Message = foodItemCostManager.Save(foodItemCost) ? "Food Item Saved Successfully" : "Food Item Saved Failed";
}
catch (Exception exception)
{
ViewBag.Message = exception.Message;
}
ViewBag.FoodItemCost = foodItemCostManager.ShowAllFoodItemCost();
return(View());
}
