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