public Users getUserByID(Guid userID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.Users.Where(u => u.ID == userID).FirstOrDefault()); } }
private Guid handleTenantID(Guid?tenantID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { if (tenantID == null) { if (DefaultTenantID == null) { Tenant tenant = uow.Context.Tenant.Where(t => t.TenantName == "DefaultTenant").FirstOrDefault(); if (tenant != null) { DefaultTenantID = tenant.ID; } else { throw new Exception("Can't locate default tenant"); } } return(DefaultTenantID.Value); } else { return(tenantID.Value); } } }
public IEnumerable <Meetings> getMeetingsForOwner(Guid ownerUserID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.Meetings.Include("MeetingCategoryMap").Where(mc => mc.MeetingOwner == ownerUserID).ToList()); } }
public IEnumerable <MeetingAttendies> getMeetingAttendees(Guid meetingID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.MeetingAttendies.Where(t => t.MeetingID == meetingID).ToList()); } }
public bool relationExists(Guid managerID, Guid teamMemberID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.ManagerTeamMemberRelations.Where(t => t.ManagerID == managerID && t.TeamMemberID == teamMemberID).Count() > 0); } }
public IEnumerable <TaskStatus> getTaskStatusList() { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.TaskStatus.ToList()); } }
public IEnumerable <Tasks> getTasksByIDs(List <Guid> taskIDs) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.Tasks.Include("MeetingTasks").Include("MeetingTasks.Meetings").Where(t => taskIDs.Contains(t.ID)).ToList()); } }
public Meetings getMeetingByName(string meetingName) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.Meetings.Where(a => a.MeetingName == meetingName).First()); } }
public List <Alerts> getAlertForTask(Guid taskID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.Alerts.Where(s => s.taskID == taskID).ToList()); } }
public MeetingTasks getMeetingTaskByID(Guid taskID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.MeetingTasks.Where(a => a.TaskID == taskID).FirstOrDefault()); } }
public MeetingCategoryMap getMeetingCategoryMapByID(Guid meetingID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.MeetingCategoryMap.Where(a => a.MeetingID == meetingID).FirstOrDefault()); } }
public Tasks getTaskByID(Guid taskID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.Tasks.Where(task => task.ID == taskID).FirstOrDefault()); } }
public IEnumerable <Tasks> getTasksForUser(bool includeFinishedTasks, bool includeCancelledTasks, Guid userID) { try { using (PrioritizerUnitOfWork uow = UnitOfWork) { if (includeFinishedTasks && includeCancelledTasks)//include all { return(uow.Context.Tasks.Include("MeetingTasks").Include("MeetingTasks.Meetings").Where(t => t.userID == userID).ToList()); } else if (includeFinishedTasks && !includeCancelledTasks)//include only finished { return(uow.Context.Tasks.Include("MeetingTasks").Include("MeetingTasks.Meetings").Where(t => t.userID == userID && (t.taskStatusID <= 4 || t.taskStatusID == null)).ToList()); } else if (!includeFinishedTasks && includeCancelledTasks)//include only cancelled { return(uow.Context.Tasks.Include("MeetingTasks").Include("MeetingTasks.Meetings").Where(t => t.userID == userID && (t.taskStatusID <= 3 || t.taskStatusID == 5 || t.taskStatusID == null)).ToList()); } else if (!includeFinishedTasks && !includeCancelledTasks) //only pending/onhold/inprogress { return(uow.Context.Tasks.Include("MeetingTasks").Include("MeetingTasks.Meetings").Where(t => t.userID == userID && (t.taskStatusID <= 3 || t.taskStatusID == null)).ToList()); } return(null); } } catch (Exception ex) { throw ex; } }
public void moveAllTasksPriorityForUser(int numOfSteps, Guid userID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { moveAllTasksPriorityForUserInternal(numOfSteps, userID, uow, true); } }
public IEnumerable <Users> getMeetingAttendeesUserList(Guid meetingID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { return(uow.Context.Users.Where(u => u.MeetingAttendies.Any(a => a.MeetingID == meetingID)).ToList()); } }
public void deleteMeetingCategoryMap(MeetingCategoryMap mcm) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.MeetingCategoryMap.DeleteObject(mcm); uow.Commit(); } }
public void deleteManagerTeamMemberRelations(ManagerTeamMemberRelations mtr) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.ManagerTeamMemberRelations.DeleteObject(mtr); uow.Commit(); } }
public IEnumerable <ManagerTeamMemberRelations> getManagerTeamMemberRelationsList(Guid?tenantID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { tenantID = handleTenantID(tenantID); return(uow.Context.ManagerTeamMemberRelations.Include("Tenant").Where(u => u.TenantID == tenantID.Value).ToList()); } }
public void applyChangesAttachments(attachments a) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.attachments.ApplyChanges(a); uow.Commit(); } }
public void deleteAttachment(attachments a) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.attachments.DeleteObject(a); uow.Commit(); } }
public void applyChangesMeetingAttendies(MeetingAttendies ma) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.MeetingAttendies.ApplyChanges(ma); uow.Commit(); } }
public void applyChangesManagerTeamMemberRelations(ManagerTeamMemberRelations mtr) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.ManagerTeamMemberRelations.ApplyChanges(mtr); uow.Commit(); } }
public void deleteProjects(projects p) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.projects.DeleteObject(p); uow.Commit(); } }
public void deleteUsers(Users u) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.Users.DeleteObject(u); uow.Commit(); } }
public List <Alerts> getAlertsForUser(Guid userID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { var alertList = uow.Context.Alerts.Include("Tasks").Where(a => a.Tasks.userID == userID && a.active.Value && a.Tasks.taskStatusID <= 3).ToList(); return(alertList); } }
public void applyChangesMeetingCategoryMap(MeetingCategoryMap mcm) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.MeetingCategoryMap.ApplyChanges(mcm); uow.Commit(); } }
public void deleteMeetingTasks(MeetingTasks mt) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.MeetingTasks.DeleteObject(mt); uow.Commit(); } }
public IEnumerable <Users> getUserByDomainName(string domainName, Guid?tenantID) { using (PrioritizerUnitOfWork uow = UnitOfWork) { tenantID = handleTenantID(tenantID); return(uow.Context.Users.Include("Tenant").Where(u => u.domainUserName == domainName && u.TenantID == tenantID.Value).ToList()); } }
public void deleteAlert(Alerts a) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.Alerts.DeleteObject(a); uow.Commit(); } }
public void applyChangesMeetingTasks(MeetingTasks mt) { using (PrioritizerUnitOfWork uow = UnitOfWork) { uow.Context.MeetingTasks.ApplyChanges(mt); uow.Commit(); } }