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