public void FindItem3() { List <MenuItemPrice> MenuItemPrices = new List <MenuItemPrice>(); using (SqlConnection connection = new SqlConnection("Server=tcp:sqlweek1-elijah.database.windows.net,1433;Initial Catalog=pizzzaDatabase;Persist Security Info=False;User ID=sqladmin_elijah;Password=8Vdh17boc8@;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;")) using (SqlCommand cmd = new SqlCommand("SELECT * from MenuItemPrice", connection)) { connection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { // Check is the reader has any rows at all before starting to read. if (reader.HasRows) { // Read advances to the next row. while (reader.Read()) { MenuItemPrice MIP = new MenuItemPrice(); // To avoid unexpected bugs access columns by name. MIP.Id = reader.GetInt32(reader.GetOrdinal("ID")); MIP.MenuId = reader.GetInt32(reader.GetOrdinal("MenuID")); MIP.SizeId = reader.GetInt32(reader.GetOrdinal("SizeID")); // int middleNameIndex = reader.GetOrdinal("MiddleName"); // If a column is nullable always check for DBNull... MenuItemPrices.Add(MIP); } foreach (var item in MenuItemPrices) { Console.WriteLine(item); } } } } }
public void AddPrice(string tag) { var pr = new MenuItemPrice { PriceTag = tag }; Model.Prices.Add(pr); AdditionalPrices.Add(new MenuItemPriceViewModel(pr)); }
public IHttpActionResult PostMenuItemPrice(MenuItemPrice menuItemPrice) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.MenuItemPrices.Add(menuItemPrice); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = menuItemPrice.ID }, menuItemPrice)); }
public IHttpActionResult PutMenuItemPrice(int id, MenuItemPrice menuItemPrice) { if (!Global.CheckUserIDAndPasswordWithSiteID(db, menuItemPrice.UILoginUserID, menuItemPrice.UILoginPassword, menuItemPrice.SiteID, "PutMenuItemPrice")) { return(BadRequest()); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != menuItemPrice.ID) { return(BadRequest()); } MenuItemPrice mip = db.MenuItemPrices.AsNoTracking().SingleOrDefault(p => p.ID == id); if (mip == null) { return(NotFound()); } if (mip.SiteID != menuItemPrice.SiteID) { return(BadRequest()); } User user = db.Users.Find(menuItemPrice.UILoginUserID); if (!user.IsRootUser && !user.IsSiteAdmin && mip.EntryByUserID != user.ID) { return(BadRequest()); } db.Entry(menuItemPrice).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!MenuItemPriceExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult DeleteMenuItemPrice(int id) { MenuItemPrice menuItemPrice = db.MenuItemPrices.Find(id); if (menuItemPrice == null) { return(NotFound()); } db.MenuItemPrices.Remove(menuItemPrice); db.SaveChanges(); return(Ok(menuItemPrice)); }
public void Post([FromBody] Item newMenuItem) { try { MenuItemPrice addMenuItem = new MenuItemPrice { MenuId = _context.MenuItem.Single(z => z.Item == newMenuItem.ItemName).MenuId, SizeId = _context.ItemSize.FirstOrDefault(z => z.Size == newMenuItem.ItemSize).SizeId, Price = newMenuItem.ItemPrice }; _context.MenuItemPrice.Add(addMenuItem); _context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public MenuItemPriceViewModel(MenuItemPrice model) { Model = model; }