private void UpdateInterview() { using (ModelContext db = new ModelContext()) { int interviewId; if (!Int32.TryParse(TextBox_Intvw_ID.Text, out interviewId)) { throw new ArgumentException($"Value '{TextBox_Intvw_ID.Text}' in Interview ID TextBox could not be parsed."); } var interviewDb = db.Interviews.FirstOrDefault(c => c.Id == interviewId); if (interviewDb == null) { throw new ArgumentException($"No Interview found with ID #{interviewId}."); } Dictionary <string, string> newInterviewFields = LoadInterviewFieldValues(); FieldValidator.CheckInterviewFields(newInterviewFields); interviewDb.Type = newInterviewFields["Type"]; interviewDb.Method = newInterviewFields["Method"]; interviewDb.Interviewer = newInterviewFields["Interviewer"]; interviewDb.DateScheduled = DateTime.Parse(newInterviewFields["Date"]); interviewDb.SkillsRequired = newInterviewFields["Skills"]; interviewDb.Status = newInterviewFields["Status"]; interviewDb.Feedback = newInterviewFields["Feedback"]; interviewDb.Remarks = newInterviewFields["Remarks"]; db.SaveChanges(); LoggingUtility.LogMessage($"Interview #{interviewDb.Id} successfully updated."); } }
protected void Button_Add_Interview_Click(object sender, EventArgs e) { try { using (ModelContext db = new ModelContext()) { int submissionSlno, consultantID; DateTime date; submissionSlno = Convert.ToInt32(HiddenField_Submission_SLNO.Value); consultantID = db.Consultants.FirstOrDefault(c => c.LastName.Equals(TextBox_Intvw_Constultant.Text)).Id; Dictionary <string, string> interviewValues = LoadInterviewFieldValues(); FieldValidator.CheckInterviewFields(interviewValues); date = DateTime.Parse(interviewValues["Date"]); var newInterview = new Models.Interviews { SubmissionSlno = submissionSlno, ConsultantId = consultantID, Type = interviewValues["Type"], Method = interviewValues["Method"], Interviewer = interviewValues["Interviewer"], SkillsRequired = interviewValues["Skills"], Status = interviewValues["Status"], Feedback = interviewValues["Feedback"], Remarks = interviewValues["Remarks"], DateScheduled = date }; db.Interviews.Add(newInterview); db.SaveChanges(); LoggingUtility.LogMessage($"New Interview #{newInterview.Id} successfully added."); } } catch (Exception ex) { handleException(ex, sender.ToString()); } Response.Redirect($"~/Pages/ViewAllSubmissions.aspx?Id={ConsultantId.Value}"); }