public void UpdateItem(int id, string newDescription, string newStatus, DateTime newDueDate) { ToDoItem oldItem = context.ToDoItems.Where(Item => Item.Id == id).FirstOrDefault(); oldItem.Description = newDescription; oldItem.Status = newStatus; // oldItem.DueDate = newDueDate; context.Update(oldItem); context.SaveChanges(); }
public void MarkAsDone(int Item) { ToDoItem Existing = db.Items.Find(Item); Existing.IsDone = true; db.Update(Existing); db.SaveChanges(); }
public void UpdateItem(int id, string newDescription, string newStatus) { ToDoItem findItem = context.ToDoItems.Where(item => item.Id == id).FirstOrDefault(); findItem.Desc = newDescription; findItem.Status = newStatus; context.Update(findItem); context.SaveChanges(); }
public void MarkDoneItem(int id) { ToDoItem markingItem = itemContext.ToDoItem.Where(x => x.Id == id).FirstOrDefault(); markingItem.Pending = markingItem.Pending == true ? false : true; itemContext.Update(markingItem); itemContext.SaveChanges(); }
public void UpdateItem(int id, string newDescription, string newStatus) { ToDoItem findItem = context.ToDoItems.Where(item => item.Id == id).FirstOrDefault();//method syntax //ToDoItem findItem2 = (from item in context.ToDoItems // where item.Id == id // select item).FirstOrDefault(); //query syntax findItem.Description = newDescription; findItem.Status = newStatus; //findItem.dueDate = newDueDate; context.Update(findItem); context.SaveChanges(); //have to update and 'push' changes to the Database }
public void UpdateItem(int id, string newDescription, string newStatus, string newDueDate) { ToDoItem oldItem = context.toDoItems.Where(x => x.id == id).FirstOrDefault(); //ToDoItem oldItem1 = (from item in context.toDoItems // where item.id == id // select item).FirstOrDefault(); oldItem.Description = newDescription; oldItem.Status = newStatus; oldItem.DueDate = newDueDate; context.Update(oldItem); context.SaveChanges(); }
public void ChangeItem(int id) //Mark an item as done { ToDoItem updateItem = itemContext.ToDoItems.Where(x => x.Id == id).FirstOrDefault(); if (updateItem.Pending == true) { updateItem.Pending = false; } else { updateItem.Pending = true; } itemContext.Update(updateItem); itemContext.SaveChanges(); }
/// <summary> /// Uses IDPrompt return to get the ID of the task to be updated. /// Changes status from pending to done, or done to pending /// </summary> public static void DoneTask() { ToDoItem DoneTask = context.ToDoList.Where(x => x.ID == IDPrompt()).FirstOrDefault(); if (DoneTask != null) { DoneTask.Status = DoneTask.Status == "PENDING" ? "DONE" : "PENDING"; context.Update(DoneTask); context.SaveChanges(); DoneReply(); } else { FailReply(); } }
public void UpdateItem(int itemID, string description, string status) { //LINQ to find ID given from user ToDoItem UpdatedToDoItem = context.ToDoList.Where(x => x.ID == itemID).FirstOrDefault(); //if the string given is NOT empty then update the description if (description != "") { UpdatedToDoItem.Description = description; } //if string given is NOT empty then update status if (status != "") { UpdatedToDoItem.Status = status; } //update the dataset and save changes made context.Update(UpdatedToDoItem); context.SaveChanges(); }
public static string ChangeStatus(int item) //change status { string result; ToDoItem statusItem = context.ToDoItems.Where(x => x.Id == item).FirstOrDefault(); //find selected item by id if (statusItem != null) //if found { statusItem.Status = statusItem.Status == "Pending" ? "Finished" : "Pending"; //change status if pending then finished or finished then pending context.Update(statusItem); //change status context.SaveChanges(); // commit changes result = "Item Status Changed!"; //message } else { result = "Item not found!"; //message } return(result); //return message }
public void UpdateItem(int itemID, string description, string status) { //LINQ locates the ID entered by user ToDoItem UpdatedToDoItem = context.ToDoList.Where(x => x.ID == itemID).FirstOrDefault(); //Description is updated if string entered is NOT empty if (description != "") { UpdatedToDoItem.Description = description; } //Status is updated if string entered is NOT empty if (status != "") { UpdatedToDoItem.Status = status; } //Updates dataset and saves changes context.Update(UpdatedToDoItem); context.SaveChanges(); }