public ActionResult AdminFeed() { string queryString = @"SELECT FeedName, FeedDate, FeedTime, Food from Feed"; List <Feedings> feedings = new List <Feedings>(); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { var feeding = new Feedings(); feeding.FeedName = reader["FeedName"].ToString(); feeding.FeedDate = Convert.ToDateTime(reader["FeedDate"]); feeding.FeedTime = reader["FeedTime"].ToString(); feeding.Food = reader["Food"].ToString(); feedings.Add(feeding); } } return(View("AdminFeed")); }
public ActionResult Create([Bind(Include = "AnimalGroupId,EmployeeId,FoodProductsId,TimeForFeeding,FeedingDate,Quantity")] Feedings feedings) { ViewBag.Exception = null; string msg = null; FeedingReminderAccess feedingReminderAccess = new FeedingReminderAccess(); if (ModelState.IsValid) { db.Feedings.Add(feedings); try { FoodProducts foodProducts = db.FoodProducts.Single(c => c.FoodProductsId == feedings.FoodProductsId); foodProducts.Quantity = foodProducts.Quantity - feedings.Quantity ?? default(int); feedingReminderAccess.Create(new FeedingReminder(feedings.FeedingId, feedings.FeedingDate.ToString(), 0)); db.SaveChanges(); } catch (Exception e) { msg = "Unable to create such feeding, we have no more such food products"; ViewBag.Exception = msg; ViewBag.AnimalGroupId = new SelectList(db.AnimalGroups, "AnimalGroupId", "Name"); ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "FirstName"); ViewBag.FoodProductsId = new SelectList(db.FoodProducts, "FoodProductsId", "Name"); return(View(feedings)); } return(RedirectToAction("Index")); } ViewBag.AnimalGroupId = new SelectList(db.AnimalGroups, "AnimalGroupId", "Name", feedings.AnimalGroupId); ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "FirstName", feedings.EmployeeId); ViewBag.FoodProductsId = new SelectList(db.FoodProducts, "FoodProductsId", "Name", feedings.FoodProductsId); return(View(feedings)); }
public async Task ExecuteLoadFeedingsCommand() { if (IsBusy) { return; } IsBusy = true; try { Feedings.Clear(); var feedings = await _database.GetFeedingsAsync(Item.ID); Feedings.ReplaceRange(feedings); } catch (Exception ex) { Debug.WriteLine(ex); MessagingCenter.Send(new MessagingCenterAlert { Title = "Error", Message = "Unable to load feedings.", Cancel = "OK" }, "message"); } finally { IsBusy = false; } }
public ActionResult DeleteConfirmed(int id) { Feedings feedings = db.Feedings.Find(id); db.Feedings.Remove(feedings); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <ActionResult <Feedings> > PostFeedings(Feedings feedings) { // Indicate to the database context we want to add this new record _context.Feeding.Add(feedings); await _context.SaveChangesAsync(); // Return a response that indicates the object was created (status code `201`) and some additional // headers with details of the newly created object. return(CreatedAtAction("GetFeedings", new { id = feedings.Id }, feedings)); }
// GET: Feedings/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Feedings feedings = db.Feedings.Find(id); if (feedings == null) { return(HttpNotFound()); } return(View(feedings)); }
public ActionResult Edit([Bind(Include = "FeedingId,AnimalGroupId,EmployeeId,FoodProductsId,TimeForFeeding,FeedingDate,RowVersion")] Feedings feedings) { ViewBag.Exception = null; string msg = null; if (ModelState.IsValid) { var entity = db.Feedings.Single(p => p.FeedingId == feedings.FeedingId); if (entity.RowVersion != feedings.RowVersion) { TempData["Exception"] = "Entity was modified by another user. Check values and perform edit action again"; return(RedirectToAction("Edit")); } entity.RowVersion++; entity.AnimalGroupId = feedings.AnimalGroupId; entity.EmployeeId = feedings.EmployeeId; entity.FoodProducts = feedings.FoodProducts; entity.TimeForFeeding = feedings.TimeForFeeding; entity.FeedingDate = feedings.FeedingDate; db.Entry(entity).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception e) { if (e.InnerException == null) { msg = e.Message; } else { msg = e.InnerException.InnerException.Message; } ViewBag.Exception = msg; return(View(feedings)); } return(RedirectToAction("Index")); } ViewBag.AnimalGroupId = new SelectList(db.AnimalGroups, "AnimalGroupId", "Name", feedings.AnimalGroupId); ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "FirstName", feedings.EmployeeId); ViewBag.FoodProductsId = new SelectList(db.FoodProducts, "FoodProductsId", "Name", feedings.FoodProductsId); return(View(feedings)); }
// GET: Feedings/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Feedings feedings = db.Feedings.Find(id); if (feedings == null) { return(HttpNotFound()); } ViewBag.AnimalGroupId = new SelectList(db.AnimalGroups, "AnimalGroupId", "Name", feedings.AnimalGroupId); ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "FirstName", feedings.EmployeeId); ViewBag.FoodProductsId = new SelectList(db.FoodProducts, "FoodProductsId", "Name", feedings.FoodProductsId); return(View(feedings)); }
public async Task <IActionResult> PutFeedings(int id, Feedings feedings) { // If the ID in the URL does not match the ID in the supplied request body, return a bad request if (id != feedings.Id) { return(BadRequest()); } // Tell the database to consider everything in feedings to be _updated_ values. When // the save happens the database will _replace_ the values in the database with the ones from feedings _context.Entry(feedings).State = EntityState.Modified; try { // Try to save these changes. await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { // Ooops, looks like there was an error, so check to see if the record we were // updating no longer exists. if (!FeedingsExists(id)) { // If the record we tried to update was already deleted by someone else, // return a `404` not found return(NotFound()); } else { // Otherwise throw the error back, which will cause the request to fail // and generate an error to the client. throw; } } // return NoContent to indicate the update was done. Alternatively you can use the // following to send back a copy of the updated data. // // return Ok(feedings) // return(NoContent()); }
public async Task <ActionResult <Feedings> > Feed(int id, Feedings feeding) { var pet = await _context.Pets.FindAsync(id); if (pet == null) { return(NotFound()); } pet.HappinessLevel += 3; pet.HungerLevel -= 5; if (pet.HungerLevel < 0) { pet.HungerLevel = 0; } feeding.When = DateTime.Now; feeding.PetId = pet.Id; _context.Feedings.Add(feeding); await _context.SaveChangesAsync(); return(Ok(feeding)); }