public IQueryable <CustomerTask> GetTasks()
{
var dataContext = new TaskModelDataContext();
var tasks = (from m in dataContext.CustomerTasks
select m);
return(tasks);
}
public void addTask(CustomerTask task)
{
var dataContext = new TaskModelDataContext();
dataContext.CustomerTasks.InsertOnSubmit(task);
dataContext.SubmitChanges();
using (System.IO.StreamWriter file =
new System.IO.StreamWriter(@"C:\Users\Public\homecarelog.txt", true))
{
file.WriteLine(DateTime.Now + " new task with id " + task.Id + " created");
}
}
public void deleteTaskById(int?id)
{
var dataContext = new TaskModelDataContext();
var query = (from m in dataContext.CustomerTasks
where m.Id == id
select m);
dataContext.CustomerTasks.DeleteOnSubmit(query.First());
dataContext.SubmitChanges();
using (System.IO.StreamWriter file =
new System.IO.StreamWriter(@"C:\Users\Public\homecarelog.txt", true))
{
file.WriteLine(DateTime.Now + " task with id " + id + " deleted");
}
}
public CustomerTask getTaskById(int?id)
{
var dataContext = new TaskModelDataContext();
var query = (from m in dataContext.CustomerTasks
where m.Id == id
select m);
var task = query.First();
if (task != null)
{
return(task);
}
else
{
return(null);
}
}
public void updateTask(CustomerTask task)
{
var dataContext = new TaskModelDataContext();
var query = (from m in dataContext.CustomerTasks
where m.Id == task.Id
select m);
query.First().title = task.title;
query.First().duration = task.duration;
query.First().description = task.description;
dataContext.SubmitChanges();
using (System.IO.StreamWriter file =
new System.IO.StreamWriter(@"C:\Users\Public\homecarelog.txt", true))
{
file.WriteLine(DateTime.Now + " task with id " + task.Id + " updated");
}
}
