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