public Task GetTaskbyId(int id) { using (TaskManagerDataContext db = new TaskManagerDataContext()) { return(db.Tasks.SingleOrDefault(k => k.TaskId == id)); } }
public List <Task> GetTask() { using (TaskManagerDataContext db = new TaskManagerDataContext()) { return(db.Tasks.ToList()); } }
public void AddTask(Task item) { using (TaskManagerDataContext db = new TaskManagerDataContext()) { db.Tasks.Add(item); db.SaveChanges(); } }
public void DeleteTask(int Id) { using (TaskManagerDataContext db = new TaskManagerDataContext()) { Task ts = db.Tasks.Where(d => d.TaskId == Id).First(); db.Tasks.Remove(ts); db.SaveChanges(); } }
public void Endtask(int id) { using (TaskManagerDataContext db = new TaskManagerDataContext()) { Task ts = db.Tasks.SingleOrDefault(x => x.TaskId == id); ts.flag = true; ts.EDate = DateTime.Now; db.SaveChanges(); } }
public void UpdateTask(Task task) { using (TaskManagerDataContext db = new TaskManagerDataContext()) { Task taskupdate = db.Tasks.SingleOrDefault(x => x.TaskId == task.TaskId); taskupdate.ParentName = task.ParentName; taskupdate.TaskName = task.TaskName; taskupdate.Priority = task.Priority; taskupdate.SDate = task.SDate; taskupdate.EDate = task.EDate; db.SaveChanges(); } }