public static Task AddTaskAbout(CMSDataContext db, int familyId, int assignTo, string description) { var f = db.Families.Single(ff => ff.People.Any(mm => mm.FamilyId == familyId)); var primaryorchild = new[] { PositionInFamily.PrimaryAdult, PositionInFamily.Child }; var fmembers = (from p in db.People where p.FamilyId == familyId where primaryorchild.Contains(p.PositionInFamilyId) select p.Name).ToList(); var hh = db.LoadPersonById(f.HeadOfHouseholdId ?? 0); var t = new Task { OwnerId = assignTo, Description = description, Notes = "Family: " + string.Join(", ", fmembers), ForceCompleteWContact = true, ListId = Task.GetRequiredTaskList(db, "InBox", assignTo).Id, StatusId = TaskStatusCode.Active, }; hh.TasksAboutPerson.Add(t); if (db.Host.HasValue()) { var gcm = new GCMHelper(db.Host, db); gcm.sendRefresh(assignTo, GCMHelper.ACTION_REFRESH); } return(t); }
public void CreateTask(int ministerId, int aboutId, string description, string notes = null) { using (var db2 = NewDataContext()) { var about = db2.LoadPersonById(aboutId); var minister = db2.LoadPersonById(ministerId); var t = new Task { OwnerId = ministerId, Description = description, Notes = notes, ForceCompleteWContact = true, ListId = Task.GetRequiredTaskList(db2, "InBox", ministerId).Id, StatusId = TaskStatusCode.Active, WhoId = aboutId, }; db2.Tasks.InsertOnSubmit(t); db2.SubmitChanges(); var taskLink = Task.TaskLink(db2, description, t.Id); db2.Email( db2.Setting("AdminMail", "*****@*****.**"), // from email minister, // to person "TASK: " + description, // subject $@"{taskLink}<br/>\n{about.Name}\n<p>{notes}</p>"); // body db2.SubmitChanges(); } }
public static void AddNewPerson(CMSDataContext Db, int newpersonid) { var NewPeopleManagerId = Db.NewPeopleManagerId; var task = new Task { ListId = Task.GetRequiredTaskList(Db, "InBox", NewPeopleManagerId).Id, OwnerId = NewPeopleManagerId, Description = "New Person Data Entry", WhoId = newpersonid, StatusId = TaskStatusCode.Active, }; if (Util.UserPeopleId.HasValue && Util.UserPeopleId.Value != NewPeopleManagerId) { task.CoOwnerId = Util.UserPeopleId.Value; task.CoListId = Task.GetRequiredTaskList(Db, "InBox", Util.UserPeopleId.Value).Id; } Db.Tasks.InsertOnSubmit(task); Db.SubmitChanges(); }
public static int AddTasks(CMSDataContext Db, Guid qid) { var q = Db.PeopleQuery(qid); int qCount = q.Count(); if (qCount > 100) { return(qCount); } foreach (var p in q) { var t = new Task { ListId = Task.GetRequiredTaskList(Db, "InBox", Util.UserPeopleId.Value).Id, OwnerId = Util.UserPeopleId.Value, Description = "Please Contact", ForceCompleteWContact = true, StatusId = TaskStatusCode.Active, }; p.TasksAboutPerson.Add(t); } DbUtil.Db.SubmitChanges(); return(qCount); }