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