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()); }