public static TaskList GetTaskById(int?id, TaskTrackerDataContext db) { TaskList tasklist = (from t in db.TaskLists where t.TaskID == id select t).FirstOrDefault(); return(tasklist); }
//[DisplayFormat(DataFormatString = "{0:MM/dd/yyyy}")] //public DateTime? FormattedDate //{ // get // { // return Convert.ToDateTime(this.DueDate); // } // set // { // this.DueDate = value; // } //} public static IEnumerable <TaskList> GetTasksByUser(string usrName, TaskTrackerDataContext db) { var usrTask = from tskUsr in db.TaskOwners join tsk in db.TaskLists on tskUsr.TaskId equals tsk.TaskID where tskUsr.UserName == usrName select tsk; return(usrTask); }
public static void EditTask(TaskList tasklist, TaskTrackerDataContext db) { var orgTaskList = (from t in db.TaskLists where t.TaskID == tasklist.TaskID select t).FirstOrDefault(); orgTaskList.TaskName = tasklist.TaskName; orgTaskList.DueDate = tasklist.DueDate; orgTaskList.TaskText = tasklist.TaskText; orgTaskList.TaskComplete = tasklist.TaskComplete; }
public static void DeleteById(int?id, TaskTrackerDataContext db) { var tasksUsersWithSameId = from tu in db.TaskOwners where tu.TaskId == id select tu; db.TaskOwners.DeleteAllOnSubmit(tasksUsersWithSameId); db.SubmitChanges(); TaskList tas = (from t in db.TaskLists where t.TaskID == id select t).FirstOrDefault(); db.TaskLists.DeleteOnSubmit(tas); db.SubmitChanges(); }
public static void CreateTask(TaskList tasklist, string usrName, TaskTrackerDataContext db) { db.TaskLists.InsertOnSubmit(tasklist); db.SubmitChanges(); var id = (from t in db.TaskLists where t.TaskName == tasklist.TaskName select t.TaskID).FirstOrDefault(); TaskOwner tskUsr = new Models.TaskOwner(); tskUsr.UserName = usrName; tskUsr.TaskId = id; db.TaskOwners.InsertOnSubmit(tskUsr); db.SubmitChanges(); }