public static int AddUser(Domain.User dto) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { DateTime CurrentTime = DateTime.Now; User User = new User { Name = dto.Name, EmailAddress = dto.EmailAddress, Password = dto.Password, Title = dto.Title, Organization = dto.Organization, RoleID = dto.RoleID, TimeZoneID = dto.TimeZoneID, DateCreated = CurrentTime, DateModified = CurrentTime }; db.Users.InsertOnSubmit(User); db.SubmitChanges(); dto.ID = User.UserID; UpdateUserLastLogin(dto.ID, CurrentTime); UserLoginHistory.AddUserLoginHistory(new Domain.UserLoginHistory(dto.ID, CurrentTime)); return dto.ID; } }
public static List<Domain.Evaluation> GetEvaluations(int userID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { return db.Evaluations.Where(i => i.UserID == userID).Select(i => i.GetDomainObject(false, false)).ToList(); } }
public static List<Domain.Response> GetResponses(int evaluationID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { return db.Responses.Where(i => i.EvaluationID == evaluationID && i.DimensionID > (int)DimensionEnum.ScopeEvaluation).Select(i => i.GetDomainObject()).ToList(); } }
public static int AddEvaluation(Domain.Evaluation dto) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { Evaluation Evaluation = new Evaluation { Name = dto.Name, Description = dto.Description, StatusID = dto.StatusID, UserID = dto.UserID, RoleID = dto.RoleID, DateCreated = DateTime.Now, DateModified = DateTime.Now }; // Update evaluation levels // Update responses db.Evaluations.InsertOnSubmit(Evaluation); db.SubmitChanges(); dto.ID = Evaluation.EvaluationID; return dto.ID; } }
public static List<Domain.Dimension> GetDimensions() { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { return db.Dimensions.Select(i => i.GetDomainObject(false)).ToList(); } }
public static List<Domain.Question> GetQuestions() { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { return db.Questions.Select(i => i.GetDomainObject(true)).ToList(); } }
public static void AddEvaluationLevel(Domain.Evaluation dto) { DeleteEvaluationLevels(dto.ID); using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { foreach (Domain.Level level in dto.CurrentLevels) { if (level.LevelNumber != 0) { EvaluationLevel eLevel = new EvaluationLevel { EvaluationID = dto.ID, LevelID = level.ID, DimensionID = level.DimensionID, DateCreated = DateTime.Now, DateModified = DateTime.Now }; db.EvaluationLevels.InsertOnSubmit(eLevel); db.SubmitChanges(); } } } }
public static List<Domain.UserLoginHistory> GetLoginHistory(int userID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { return db.UserLoginHistories.Where(i => i.UserID == userID).Select(i => i.GetDomainObject()).ToList(); } }
public static List<Domain.User> GetUsers() { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { return db.Users.Select(i => i.GetDomainObject(false, false)).ToList(); } }
public static void AddResponses(List<Domain.Response> responses, int evaluationID, int dimensionID) { // Clear existing values first //DeleteResponses(evaluationID, dimensionID); using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { foreach (Domain.Response dto in responses) { Response response = new Response { QuestionID = dto.QuestionID, EvaluationID = evaluationID, DimensionID = dimensionID, Name = "", SelectedValue = (int)dto.SelectedValue, DateCreated = DateTime.Now, DateModified = DateTime.Now }; db.Responses.InsertOnSubmit(response); db.SubmitChanges(); } } Evaluation.UpdateEvaluationLastModified(evaluationID, DateTime.Now); }
public static Domain.Dimension GetDimension(int dimensionID, bool getChildrenObject) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { Domain.Dimension dimension = db.Dimensions.Where(i => i.DimensionID == dimensionID).Select(i => i.GetDomainObject(getChildrenObject)).FirstOrDefault(); return dimension; } }
public static List<Domain.Level> GetLevels() { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { List<Domain.Level> levels = db.Levels.Where(i => i.DimensionID > (int)DimensionEnum.Implementation).OrderBy(i => i.DimensionID).Select(i => i.GetDomainObject(0, false, true)).ToList(); return levels; } }
public static List<Domain.Level> GetLevels(int dimensionID, bool getChildrenObject, bool getParentObject) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { List<Domain.Level> levels = db.Levels.OrderBy(i => i.LevelNumber).Where(i => i.DimensionID == dimensionID).Select(i => i.GetDomainObject(dimensionID, getChildrenObject, getParentObject)).ToList(); return levels; } }
public static List<Domain.EvaluationResult> GetEvaluationResults() { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { List<Domain.EvaluationResult> EvaluationResults = db.EvaluationResults.Select(q => q.GetDomainObject()).ToList(); return EvaluationResults; } }
public static List<Domain.TimeZone> GetTimeZones() { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { List<Domain.TimeZone> timeZones = db.TimeZones.Select(q => q.GetDomainObject()).ToList(); return timeZones; } }
public static List<Domain.User> GetUsers(bool getChildrenObject, bool getParentObject) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { List<Domain.User> Users = db.Users.OrderBy(i => i.Name).Select(i => i.GetDomainObject(getChildrenObject, getParentObject)).ToList(); return Users; } }
public static List<Domain.Role> GetRoles(bool getChildrenObject) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { List<Domain.Role> roles = db.Roles.Select(q => q.GetDomainObject(getChildrenObject)).ToList(); return roles; } }
public static Domain.Evaluation GetEvaluation(int evaluationID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { var q = (from Evaluations in db.Evaluations where Evaluations.EvaluationID == evaluationID select Evaluations).FirstOrDefault(); return q.GetDomainObject(true, true); } }
public static Domain.User GetUser(int userID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { var q = (from Users in db.Users where Users.UserID == userID select Users).FirstOrDefault(); return q.GetDomainObject(true, true); } }
public static List<Domain.Question> GetLevelQuestions(int levelID, int congestionID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { var q = (from questions in db.Questions join levelQuestions in db.LevelQuestions on questions.QuestionID equals levelQuestions.QuestionID where levelQuestions.LevelID == levelID && levelQuestions.CongestionID == congestionID select questions).Distinct(); return q.Select(i => i.GetDomainObject()).ToList(); } }
public static void DeleteResponses(int evaluationID, int dimensionID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { var rowsToDelete = from q in db.Responses where q.EvaluationID == evaluationID && q.DimensionID == dimensionID select q; db.Responses.DeleteAllOnSubmit(rowsToDelete); db.SubmitChanges(); } }
public static Domain.Level GetQuestionLevel(int questionID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { var q = (from levels in db.Levels join levelQuestions in db.LevelQuestions on levels.LevelID equals levelQuestions.LevelID where levelQuestions.QuestionID == questionID select levels).FirstOrDefault(); return q.GetDomainObject(0, false, true); } }
public static List<Domain.Level> GetLevels(int evaluationID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { var q = (from eLevels in db.EvaluationLevels join levels in db.Levels on eLevels.LevelID equals levels.LevelID where eLevels.EvaluationID == evaluationID select levels); return q.Select(i => i.GetDomainObject(0, false, false)).ToList().OrderBy(i => i.Name).ToList(); } }
public static void DeleteEvaluationLevels(int evaluationID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { var rowsToDelete = from q in db.EvaluationLevels where q.EvaluationID == evaluationID select q; db.EvaluationLevels.DeleteAllOnSubmit(rowsToDelete); db.SubmitChanges(); } }
public static int GetUserIDByEmail(string emailAddress) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { User foundUser = db.Users.Where(i => i.EmailAddress == emailAddress).SingleOrDefault(); if (foundUser != null) { return foundUser.UserID; } return 0; } }
public static bool IsExistingUser(string emailAddress) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { User foundUser = db.Users.Where(i => i.EmailAddress == emailAddress).SingleOrDefault(); if (foundUser != null) { return true; } return false; } }
public static void UpdateEvaluationResult(int EvaluationResultID, string resultText) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { EvaluationResult EvaluationResult = db.EvaluationResults.Where(i => i.EvaluationResultID == EvaluationResultID).SingleOrDefault(); if (EvaluationResult != null) { EvaluationResult.Description = resultText; EvaluationResult.DateModified = DateTime.Now; db.SubmitChanges(); } } }
public static List<Domain.Question> GetDimensionQuestions(int dimensionID, bool getParent) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { var q = (from questions in db.Questions join levelQuestions in db.LevelQuestions on questions.QuestionID equals levelQuestions.QuestionID join level in db.Levels on levelQuestions.LevelID equals level.LevelID join dimensions in db.Dimensions on level.DimensionID equals dimensions.DimensionID where dimensions.DimensionID == dimensionID select questions).Distinct(); return q.Select(i => i.GetDomainObject(getParent)).ToList(); } }
// We do not allow new questions to be created. Only existing questions may be updated public static void UpdateQuestionText(int questionID, string questionText) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { Question question = db.Questions.Where(i => i.QuestionID == questionID).SingleOrDefault(); if (question != null) { question.Description = questionText; question.DateModified = DateTime.Now; db.SubmitChanges(); } } }
public static void AddUserLoginHistory(Domain.UserLoginHistory dto) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { UserLoginHistory history = new UserLoginHistory { UserID = dto.UserID, LoginDate = dto.LoginDate }; db.UserLoginHistories.InsertOnSubmit(history); db.SubmitChanges(); } }