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