public string GetCandidateName(LOT_Candidate_Exam objUI) { if (objUI.LOT_Exam.ExamType == 2) return dbContext.GetEmployeeFullName(objUI.EmployeeID, 1); if (objUI.LOT_Exam.ExamType == 1) return dbContext.GetCandidateFullName(objUI.CandidateID, 1); return string.Empty; }
/// <summary> /// Update Programming mark & comment to db /// </summary> /// <param name="objDB"></param> /// <param name="objUI"></param> /// <returns></returns> private Message UpdateProgramingMark(LOT_Candidate_Exam objDB, LOT_Candidate_Exam objUI) { Message msg = null; objDB.UpdateDate = DateTime.Now; objDB.UpdatedBy = objUI.UpdatedBy; double totalProgramingMaxMark = candidateAnswerDAO.GetMaxWritingMark(objUI.ID, Constants.LOT_PROGRAMMING_SKILL_ID); // Round writing mark //if (objUI.ProgramingMark != null) //{ // objUI.ProgramingMark = Math.Round(objUI.ProgramingMark.Value); //} //if (objUI.ProgramingMark < 0) //{ // msg = new Message(MessageConstants.E0028, MessageType.Error, "Programming mark", "0"); //} //else if (objUI.ProgramingMark > totalProgramingMaxMark) //{ // msg = new Message(MessageConstants.E0029, MessageType.Error, "Programming mark", "Programming max mark (" + totalProgramingMaxMark + ")"); //} //else //{ // objDB.ProgramingMark = objUI.ProgramingMark; // objDB.ProgramingComment = objUI.ProgramingComment; dbContext.SubmitChanges(); string displayName = ""; if (objDB.LOT_Exam.ExamType == Constants.LOT_CANDIDATE_EXAM_ID) { if (string.IsNullOrEmpty(objDB.Candidate.MiddleName)) { displayName = objDB.Candidate.FirstName + " " + objDB.Candidate.LastName; } else { displayName = objDB.Candidate.FirstName + " " + objDB.Candidate.MiddleName + " " + objDB.Candidate.LastName; } } else { if (string.IsNullOrEmpty(objDB.Employee.MiddleName)) { displayName = objDB.Employee.FirstName + " " + objDB.Employee.LastName; } else { displayName = objDB.Employee.FirstName + " " + objDB.Employee.MiddleName + " " + objDB.Employee.LastName; } } msg = new Message(MessageConstants.I0001, MessageType.Info, "Programming skill information of candidate '" + displayName + "'", "updated"); //} return msg; }
/// <summary> /// Update login date and IP of table candidate exam follow by objUI /// </summary> /// <param name="objUI">LOT_Candidate_Exam object that have been passed from view</param> /// <returns>Message</returns> public Message UpdateCandidateExam(LOT_Candidate_Exam objUI) { Message msg = null; try { LOT_Candidate_Exam candidate = this.GetItemByCandidatePin(objUI.CandidatePin); if (candidate != null) { candidate.LoginDate = DateTime.Now; candidate.IP = HttpContext.Current.Request.UserHostAddress; dbContext.SubmitChanges(); // Show success message msg = new Message(MessageConstants.I0001, MessageType.Info, "CandidateExam", "updated"); } } catch (Exception ex) { msg = new Message(MessageConstants.E0007, MessageType.Error); throw ex; } return msg; }
/// <summary> /// Check update date whether is valid /// </summary> /// <param name="objUI"></param> /// <param name="objDb"></param> /// <param name="msg"></param> /// <returns></returns> private bool IsValidUpdateDate(LOT_Candidate_Exam objUI, LOT_Candidate_Exam objDb, out Message msg) { bool isValid = false; msg = null; if (objUI != null && objDb != null) { if (objDb.UpdateDate.ToString().Equals(objUI.UpdateDate.ToString())) { isValid = true; } else { string displayName = ""; if (objDb.Candidate.MiddleName == null) { displayName = objDb.Candidate.FirstName + " " + objDb.Candidate.LastName; } else { displayName = objDb.Candidate.FirstName + " " + objDb.Candidate.MiddleName + " " + objDb.Candidate.LastName; } msg = new Message(MessageConstants.E0025, MessageType.Error, "Writing information of candidate '" + displayName + "'"); } } return isValid; }
public Message UpdateVerbalMark(LOT_Candidate_Exam candidateExam) { Message msg = null; try { if (candidateExam != null) { LOT_Candidate_Exam objDB = GetCandidateExamById(candidateExam.ID); //check valid update date if (IsValidUpdateDate(candidateExam, objDB, out msg)) { //objDB.VerbalMark = candidateExam.VerbalMark; //objDB.VerbalMarkType = candidateExam.VerbalMarkType; //objDB.VerbalComment = candidateExam.VerbalComment; //objDB.VerbalTestedBy = candidateExam.VerbalTestedBy; objDB.UpdateDate = DateTime.Now; objDB.UpdatedBy = HttpContext.Current.User.Identity.Name; dbContext.SubmitChanges(); msg = new Message(MessageConstants.I0001, MessageType.Info, "Verbal mark", "updated"); } } } catch (Exception) { msg = new Message(MessageConstants.E0007, MessageType.Error); } return msg; }
/// <summary> /// Update Programming mark & comment /// </summary> /// <param name="objUI"></param> /// <returns></returns> public Message UpdateProgramingMark(LOT_Candidate_Exam objUI) { Message msg = null; try { if (objUI != null) { LOT_Candidate_Exam objDB = GetCandidateExamById(objUI.ID); objUI.ExamID = objDB.ExamID; //check valid update date if (IsValidUpdateDate(objUI, objDB, out msg)) { msg = UpdateProgramingMark(objDB, objUI); } } } catch (Exception) { msg = new Message(MessageConstants.E0007, MessageType.Error); } return msg; }
/// <summary> /// Update writing mark or Tc and bug mark and comment for cadidate exam /// </summary> /// <param name="objUI"></param> /// <returns></returns> public Message Update(LOT_Candidate_Exam objUI, int sectionID) { Message msg = null; try { if (objUI != null) { List<LOT_CandidateAnswer> candidateAnswers = dbContext.LOT_CandidateAnswers.ToList<LOT_CandidateAnswer>(); LOT_Candidate_Exam objDB = GetCandidateExamById(objUI.ID); objUI.ExamID = objDB.ExamID; if (IsValidUpdateDate(objUI, objDB, out msg)) { msg = UpdateNotValidate(objUI, objDB, sectionID); } } } catch (Exception) { msg = new Message(MessageConstants.E0007, MessageType.Error); } return msg; }
public Message InsertCandidateForExam(LOT_Candidate_Exam objUI) { Message msg = null; try { LOT_Candidate_Exam objDb = dbContext.LOT_Candidate_Exams.Where(q=>q.EmployeeID==objUI.EmployeeID && q.ExamID==objUI.ExamID).FirstOrDefault(); if (objDb == null) { if (objUI != null) { // Set more info dbContext.LOT_Candidate_Exams.InsertOnSubmit(objUI); dbContext.SubmitChanges(); msg = new Message(MessageConstants.I0001, MessageType.Info, "Exam '" + objUI.EmployeeID + "'", "added"); } } else { //objDb.WritingComment = objUI.WritingComment; //objDb.WritingMark = objUI.WritingMark; //objDb.VerbalComment = objUI.VerbalComment; //objDb.VerbalMark = objUI.VerbalMark; //objDb.VerbalMarkType = objUI.VerbalMarkType; //objDb.VerbalTestedBy = objUI.VerbalTestedBy; dbContext.SubmitChanges(); msg = new Message(MessageConstants.I0001, MessageType.Info, "Exam '" + objUI.EmployeeID + "'", "added"); } } catch (Exception) { // Show system error msg = new Message(MessageConstants.E0007, MessageType.Error); } return msg; }