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