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 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 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 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 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 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(); } }
// 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 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 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(); } }
// We do not allow new levels to be created. Only existing levels may be updated public static void UpdateLevel(int levelID, string description, string capability, string pdfName) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { Level level = db.Levels.Where(i => i.LevelID == levelID).SingleOrDefault(); if (level != null) { level.Description = description; level.Capability = capability; level.PdfName = pdfName; level.DateModified = DateTime.Now; db.SubmitChanges(); } } }
public static void AddUpdateEvaluationLevel(int evaluationID, int dimensionID, int levelID) { DeleteEvaluationLevel(evaluationID, dimensionID); using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { EvaluationLevel eLevel = new EvaluationLevel { EvaluationID = evaluationID, LevelID = levelID, DimensionID = dimensionID, DateCreated = DateTime.Now, DateModified = DateTime.Now }; db.EvaluationLevels.InsertOnSubmit(eLevel); db.SubmitChanges(); } }
public static void DeleteEvaluation(int evaluationID) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { // Delete evaluation levels EvaluationLevel.DeleteEvaluationLevels(evaluationID); // Delete responses Response.DeleteResponses(evaluationID); // Delete evaluation var rowsToDelete = from q in db.Evaluations where q.EvaluationID == evaluationID select q; db.Evaluations.DeleteAllOnSubmit(rowsToDelete); db.SubmitChanges(); } }
public static void UpdateEvaluation(Domain.Evaluation dto) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { Evaluation foundEvaluation = db.Evaluations.Where(i => i.EvaluationID == dto.ID).SingleOrDefault(); if (foundEvaluation != null) { foundEvaluation.Name = dto.Name; foundEvaluation.Description = dto.Description; foundEvaluation.StatusID = dto.StatusID; foundEvaluation.RoleID = dto.RoleID; foundEvaluation.DateModified = DateTime.Now; db.SubmitChanges(); } // Update evaluation responses } }
public static void UpdateEvaluationLastModified(int EvaluationID, DateTime LastModified) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { Evaluation foundEvaluation = db.Evaluations.Where(i => i.EvaluationID == EvaluationID).SingleOrDefault(); if (foundEvaluation != null) { foundEvaluation.DateModified = LastModified; db.SubmitChanges(); } } }
public static void UpdateUser(Domain.User dto) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { User foundUser = db.Users.Where(i => i.UserID == dto.ID).SingleOrDefault(); if (foundUser != null) { foundUser.Name = dto.Name; foundUser.EmailAddress = dto.EmailAddress; foundUser.Title = dto.Title; foundUser.Organization = dto.Organization; foundUser.RoleID = dto.RoleID; foundUser.TimeZoneID = dto.TimeZoneID; if (dto.Password != "") { foundUser.Password = dto.Password; } foundUser.DateModified = DateTime.Now; db.SubmitChanges(); } } }
public static void UpdateUserLastLogin(int userID, DateTime lastLoginDate) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { User foundUser = db.Users.Where(i => i.UserID == userID).SingleOrDefault(); if (foundUser != null) { foundUser.LastLoginDate = lastLoginDate; db.SubmitChanges(); } } }
public static void UpdateUserPassword(int userID, string password) { using (EvaluationDBDataContext db = new EvaluationDBDataContext()) { User foundUser = db.Users.Where(i => i.UserID == userID).SingleOrDefault(); if (foundUser != null) { foundUser.Password = password; foundUser.DateModified = DateTime.Now; db.SubmitChanges(); } } }