public void UpdateGroceryItemQuery(GroceryItem Request) { // Create and Open Database Connection var connectionString = GetConnectionString(); NpgsqlConnection conn = new NpgsqlConnection(connectionString); conn.Open(); // Define Query string sql = "UPDATE " + "GroceryItems SET quantity = (quantity + :quantity) " + "WHERE name = :name;"; NpgsqlCommand cmd = new NpgsqlCommand(sql, conn); cmd.Parameters.Add(new NpgsqlParameter("name", NpgsqlTypes.NpgsqlDbType.Text)); cmd.Parameters[0].Value = Request.name.ToUpper(); cmd.Parameters.Add(new NpgsqlParameter("quantity", NpgsqlTypes.NpgsqlDbType.Integer)); cmd.Parameters[1].Value = Request.quantity; // Execute Query cmd.ExecuteNonQuery(); // Close Database Connection conn.Close(); }
public async Task <IActionResult> PutGroceryItem(long id, GroceryItem groceryItem) { if (id != groceryItem.Id) { return(BadRequest()); } _context.Entry(groceryItem).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!GroceryItemExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public EditGroceryItemViewModel(GroceryItem item) : base() { // Use Cheese object to initialize the ViewModel properties GroceryId = item.ID; Name = item.Name; GroceryNote = item.GroceryNote; }
public async Task <ActionResult <GroceryItem> > PostGroceryItem(GroceryItem groceryItem) { _context.GroceryItem.Add(groceryItem); await _context.SaveChangesAsync(); return(CreatedAtAction("GetGroceryItem", new { id = groceryItem.Id }, groceryItem)); }
private void meatButton_Click(object sender, EventArgs e) { GroceryItem steak = new GroceryItem("Steak"); GroceryItem chicken = new GroceryItem("Chicken"); GroceryItem pork = new GroceryItem("Pork"); GroceryItem lamb = new GroceryItem("Lamb"); GroceryItem veal = new GroceryItem("Veal"); List <GroceryItem> itemList = new List <GroceryItem>(); itemList.Add(steak); itemList.Add(chicken); itemList.Add(pork); itemList.Add(lamb); itemList.Add(veal); Category meat = new Category("Meat", itemList); Form1 f = new Form1(meat); f.Show(); this.Hide(); }
public List <GroceryItem> GetGroceryItemsMapper(NpgsqlDataReader dataReader) { List <GroceryItem> groceryList = new List <GroceryItem>(); try { while (dataReader.Read()) { GroceryItem groceryItem = new GroceryItem { name = dataReader["Name"].ToString(), quantity = (int)dataReader["Quantity"] }; groceryList.Add(groceryItem); } } catch (NpgsqlException e) { Console.WriteLine(e); throw; } return(groceryList); }
//item stocked is true and foundAisle is true and first check is false and inventory is empty public NodeVal checkItemFirst() { foreach (Aisle a in closeAisles) { for (int i = 0; i < a.itemsOnShelf.Length; i++) { //set item you are checking GroceryItem checkingItem = a.itemsOnShelf[i]; Stock itemShelf = checkingItem.Shelf; if (itemShelf.currentStock < _minShelfStockAccepted) { //found an item that needs to be stocked //AislesChecked = 0; itemStocked = false; targetGrocery = checkingItem; targetStock = targetGrocery.Supply; movingToStockRoom = true; return(NodeVal.Success); } } } //both aisles are minimally stocked, check next one CheckedPoints += 1; foundAisle = false; return(NodeVal.Success); }
public async Task <IActionResult> RemoveFromGrocery(int[] groceryIds) { // used checkboxes, looping through list of cheeseIds foreach (int groceryId in groceryIds) { // accessing the existing cheese object GroceryItem theItem = Context.GroceryItems.Single(c => c.ID == groceryId); // checking if the user is allowed to delete items from the pantry var isAuthorized = await AuthorizationService.AuthorizeAsync( User, theItem, FoodOperations.Delete); if (!isAuthorized.Succeeded) { return(Forbid()); } // removing each cheese in the list from the database Context.GroceryItems.Remove(theItem); } // saving changes to the database Context.SaveChanges(); // redirecting back to the index to show grocery list return(Redirect("/Grocery")); }
//item stocked is true and aisle found false is true and first check is true public NodeVal checkItemSecond() { foreach (Aisle a in closeAisles) { for (int i = 0; i < a.itemsOnShelf.Length; i++) { //set item you are checking GroceryItem checkingItem = a.itemsOnShelf[i]; Stock itemShelf = checkingItem.Shelf; if (itemShelf.currentStock < itemShelf.stockMaxSize) //this is the difference between check first and check second { //found an item that needs to be stocked //AislesChecked = 0; itemStocked = false; targetGrocery = checkingItem; targetStock = targetGrocery.Supply; movingToStockRoom = true; return(NodeVal.Success); } } } //both aisles are max stocked, check next one CheckedPoints += 1; foundAisle = false; return(NodeVal.Success); }
public async Task <IActionResult> EditGroceryItem(EditGroceryItemViewModel vm) { GroceryItem editedGroceryItem = Context.GroceryItems.Single(c => c.ID == vm.GroceryId); var isAuthorized = await AuthorizationService.AuthorizeAsync( User, editedGroceryItem, FoodOperations.Update); var currentUserId = UserManager.GetUserId(User); if (!isAuthorized.Succeeded) { return(Forbid()); } if (ModelState.IsValid) { editedGroceryItem.Name = vm.Name; editedGroceryItem.GroceryNote = vm.GroceryNote; Context.SaveChanges(); return(Redirect("/Grocery")); } EditGroceryItemViewModel newEditViewModel = new EditGroceryItemViewModel(editedGroceryItem); newEditViewModel.GroceryList = Context.GroceryItems.Where(g => g.IsInPantry == false).Where(g => g.UserID == currentUserId).ToList(); return(View(newEditViewModel)); }
private void deliButton_Click(object sender, EventArgs e) { GroceryItem sandwich = new GroceryItem("Sandwich"); GroceryItem salad = new GroceryItem("Salad"); GroceryItem wrap = new GroceryItem("Wrap"); GroceryItem slicedmeat = new GroceryItem("Sliced Meat"); GroceryItem slicedcheese = new GroceryItem("Sliced Cheese"); List <GroceryItem> itemList = new List <GroceryItem>(); itemList.Add(sandwich); itemList.Add(salad); itemList.Add(wrap); itemList.Add(slicedmeat); itemList.Add(slicedcheese); Category deli = new Category("Deli", itemList); Form1 f = new Form1(deli); f.Show(); this.Hide(); }
private void seafoodButton_Click(object sender, EventArgs e) { GroceryItem salmon = new GroceryItem("Salmon"); GroceryItem trout = new GroceryItem("Trout"); GroceryItem shrimp = new GroceryItem("Shrimp"); GroceryItem crab = new GroceryItem("Crab"); GroceryItem lobster = new GroceryItem("Lobster"); List <GroceryItem> itemList = new List <GroceryItem>(); itemList.Add(salmon); itemList.Add(trout); itemList.Add(shrimp); itemList.Add(crab); itemList.Add(lobster); Category seafood = new Category("Seafood", itemList); Form1 f = new Form1(seafood); f.Show(); this.Hide(); }
public async Task <IActionResult> AddGrocery([FromBody] GroceryItem grocery, [FromRoute] int shopId) { var newGroceryItem = await _grocceryItemService.AddItemToList(shopId, grocery); if (newGroceryItem == null) { return(BadRequest(new BaseResponse <string>() { Succes = false, Error = "no shop found with this shopId" })); } var signalrRoom = await _grocceryItemService.GetSignalrRoom(shopId); if (signalrRoom == null) { return(BadRequest(new BaseResponse <string>() { Succes = false, Error = "No signalr group found for this grocery list" })); } var shopResponse = await _shopService.GetShopByShopId(shopId); await _groceryItemHub.Clients.Group(signalrRoom).SendAsync(nameof(IGroceryItemHub.NewGroceryAdded), newGroceryItem); await _shopHub.Clients.Group("Test-5").SendAsync(nameof(IShopHub.UpdateShop), shopResponse); return(Created("https://shoppinglist.dallau.com", newGroceryItem)); }
private void dairyButton_Click(object sender, EventArgs e) { GroceryItem milk = new GroceryItem("Milk"); GroceryItem butter = new GroceryItem("Butter"); GroceryItem eggs = new GroceryItem("Eggs"); GroceryItem cream = new GroceryItem("Cream"); GroceryItem yogurt = new GroceryItem("Yogurt"); List <GroceryItem> itemList = new List <GroceryItem>(); itemList.Add(milk); itemList.Add(butter); itemList.Add(eggs); itemList.Add(cream); itemList.Add(yogurt); Category dairy = new Category("Dairy", itemList); Form1 f = new Form1(dairy); f.Show(); this.Hide(); }
protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); this.SetContentView(Resource.Layout.GroceryEdit); //Pull out all of the "extras" that were passed in the intent _groceryItem = new GroceryItem() { ObjectId = Intent.GetStringExtra("objectId"), Title = Intent.GetStringExtra("title"), Description = Intent.GetStringExtra("description"), Quantity = Intent.GetIntExtra("quantity", 0) }; //Grab each of the text views, which display the details about the grocery item, and assign them values txtTitle = FindViewById <EditText> (Resource.Id.editText1); txtTitle.Text = _groceryItem.Title; txtDescription = FindViewById <EditText> (Resource.Id.editText2); txtDescription.Text = _groceryItem.Description; //Grab the spinner control, and bind it to the resource array Spinner spinner = FindViewById <Spinner> (Resource.Id.spinner1); spinner.ItemSelected += new EventHandler <AdapterView.ItemSelectedEventArgs> (spinner_ItemSelected); var adapter = ArrayAdapter.CreateFromResource(this, Resource.Array.quantity_array, Android.Resource.Layout.SimpleSpinnerItem); adapter.SetDropDownViewResource(Android.Resource.Layout.SimpleSpinnerDropDownItem); spinner.Adapter = adapter; //Set the selected item - this is easy because we have a 0-based array, which matchs the quantity spinner.SetSelection(_groceryItem.Quantity); //Finally, wire up the "Save" button Button btnEdit = FindViewById <Button> (Resource.Id.btnEdit); btnEdit.Click += (object sender, EventArgs e) => { //Persist these changes somewhere, and then navigate back to the "Grocery Detail" view Toast.MakeText(this, "Saving...", ToastLength.Long).Show(); _groceryItem.Title = txtTitle.Text; _groceryItem.Description = txtDescription.Text; Task.Factory.StartNew(() => { if (!string.IsNullOrEmpty(_groceryItem.ObjectId)) { GroceryService.UpdateGroceryItem(_groceryItem); } else { GroceryService.CreateGroceryItem(_groceryItem); } }).ContinueWith((prevTask) => { Intent i = new Intent(this, typeof(GroceryList)); StartActivity(i); }, TaskScheduler.FromCurrentSynchronizationContext()); }; }
private void produceButton_Click(object sender, EventArgs e) { GroceryItem apple = new GroceryItem("Appple"); GroceryItem brocoli = new GroceryItem("Brocoli"); GroceryItem potato = new GroceryItem("Potato"); GroceryItem pear = new GroceryItem("Pear"); GroceryItem corn = new GroceryItem("Corn"); List <GroceryItem> itemList = new List <GroceryItem>(); itemList.Add(apple); itemList.Add(brocoli); itemList.Add(potato); itemList.Add(pear); itemList.Add(corn); Category produce = new Category("Produce", itemList); Form1 f = new Form1(produce); f.Show(); this.Hide(); }
public IHttpActionResult PutGroceryItem(int id, GroceryItem groceryItem) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} if (id != groceryItem.ID) { return(BadRequest()); } db.Entry(groceryItem).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!GroceryItemExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private void packagedButton_Click(object sender, EventArgs e) { GroceryItem cereal = new GroceryItem("Cereal"); GroceryItem chips = new GroceryItem("Chips"); GroceryItem crackers = new GroceryItem("Crackers"); GroceryItem popcorn = new GroceryItem("Popcorn"); GroceryItem fruitsnacks = new GroceryItem("Fruit Snacks"); List <GroceryItem> itemList = new List <GroceryItem>(); itemList.Add(cereal); itemList.Add(chips); itemList.Add(crackers); itemList.Add(popcorn); itemList.Add(fruitsnacks); Category packaged = new Category("Packaged", itemList); Form1 f = new Form1(packaged); f.Show(); this.Hide(); }
// PUT api/GroceryItem/5 public IHttpActionResult PutGroceryItem(GroceryItem groceryitem) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } //if (id != groceryitem.GroceryItemId) //{ // return BadRequest(); //} groceryitem.UpdatedDate = DateTime.Now; db.Entry(groceryitem).State = System.Data.Entity.EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!GroceryItemExists(groceryitem.GroceryItemId)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public static async Task UpdateItem(GroceryItem groceryItem) { var firebase = Authenticate(); await firebase .Child("GroceryList") .Child(groceryItem.Name) .PutAsync(groceryItem); }
private void RemoveItem(GroceryItem item) { ItemRemovedEvent e = new ItemRemovedEvent(); e.Id = item.Id; _eventAggregator.Publish(e); }
public EditPantryItemViewModel(GroceryItem item, IEnumerable <GroceryItemLocation> locations) : base(locations) { // Use Cheese object to initialize the ViewModel properties PantryId = item.ID; Name = item.Name; GroceryNote = item.GroceryNote; GroceryItemLocationID = item.LocationID; }
public IActionResult Create(GroceryItem groceryItem) { groceryItem.OwnerEmail = this.User.Identity.Name; var newGroceryItem = _groceryItem.CreateGroceryItem(groceryItem); newGroceryItem.OwnerEmail = this.User.Identity.Name; return Json(new { newGroceryItem.Id }); }
private static void Main() { var gi = new GroceryItem("Carrot"); gi.Foo(); Console.WriteLine(gi.Description); }
/// <summary> /// SCREEN: add a character /// </summary> static void DisplayAddCharacter() { FlintstoneCharacter character = new FlintstoneCharacter(); DisplayScreenHeader("Add a New Character"); Console.Write("First Name:"); character.FirstName = Console.ReadLine(); Console.Write("Last Name:"); character.LastName = Console.ReadLine(); GetInteger("Age:", 1, 200, out int age); character.Age = age; Console.Write("Gender:"); Enum.TryParse(Console.ReadLine(), out FlintstoneCharacter.GenderType gender); character.Gender = gender; Console.Write("Image File:"); character.ImageFileName = Console.ReadLine(); GetInteger("Gross Salary:", 1, 1000000, out int grossSalary); character.Age = grossSalary; Console.Write("Description:"); character.Description = Console.ReadLine(); character.GroceryList = new List <GroceryItem>(); GetInteger("Number of Grocery Items:", 1, 20, out int numberOfGroceryItems); for (int i = 0; i < numberOfGroceryItems; i++) { GroceryItem groceryItem = new GroceryItem(); Console.Write("Grocery Item Name:"); groceryItem.Name = Console.ReadLine(); GetInteger("Grocery Item Quantity:", 1, 200, out int quantity); groceryItem.Quantity = quantity; character.GroceryList.Add(groceryItem); } _fcBusiness.AddFlintstoneCharacter(character); if (_fcBusiness.FileIoStatus == FileIoMessage.Complete) { Console.WriteLine(); Console.WriteLine($"{character.FirstName} {character.LastName} added successfully"); } else { // process file IO error message } DisplayMainMenuPrompt(); }
public IActionResult Create(GroceryItem groceryItem) { if (ModelState.IsValid == true) { _databaseContext.AddGroceryItem(groceryItem); return(RedirectToAction("Index")); } return(View(groceryItem)); }
public void AddItem(GroceryItem item) { if (Items == null) { throw new InvalidOperationException("Cannot add item to null list"); } Items.Add(item); }
public async Task <ActionResult <GroceryItem> > PostGroceryItem(GroceryItem groceryItem) { groceryItem.Updated = DateTime.UtcNow; groceryItem.AlreadyPicked = false; _context.groceryItems.Add(groceryItem); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(GetGroceryItem), new { id = groceryItem.Id }, groceryItem)); }
private void ChangeItemIsInCart(GroceryItem item) { ItemIsInCartChangedEvent e = new ItemIsInCartChangedEvent(); e.Id = item.Id; e.IsInCart = !item.IsInCart; _eventAggregator.Publish(e); }
public void InsertGroceryItem([FromBody] GroceryItem ApiRequest) { // Null or Empty checks ApiRequest = ApiRequest ?? throw new NullReferenceException("Item object is null"); // Creates an item or updates an existing item's quantity _groceryService.InsertGroceryItem(ApiRequest.name); _groceryService.UpdateGroceryItem(ApiRequest); }
/// <summary> /// Constructor /// </summary> /// <param name="groceryItem">The <see cref="GroceryItem"/> for which the promotion isvalid</param> /// <param name="quantity">The quantity of item which qualifies for the promotion</param> /// <param name="rate">The percentage of the item price to be computed</param> public RelativePricePromotion(GroceryItem groceryItem, int quantity, decimal rate) { Quantity = quantity; _rate = rate; Item = groceryItem; }