public IActionResult AddAcademics(Academics acad) { var usrmgr = GetUserManager(); IActionResult result = GetAuthenticatedView("NewAcademics", acad); acad.ProfileId = _db.GetProfile(usrmgr.User.Id, true).Id; if (ModelState.IsValid) { try { _db.UpdateAcademics(acad); result = RedirectToAction("ProfileEdit"); } catch (Exception) { try { _db.AddAcademics(acad); result = RedirectToAction("ProfileEdit"); } catch { } } } return(result); }
public void UpdateAcademics(Academics academics) { using (SqlConnection conn = new SqlConnection(_connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("UPDATE Academics SET " + "Degree = @Degree, " + "Institution = @Institution, " + "StartDate = @StartDate, " + "EndDate = @EndDate, " + "Graduated = @Graduated, " + "Major = @Major " + "WHERE Id = @Id", conn); cmd.Parameters.AddWithValue("@Degree", academics.Degree); cmd.Parameters.AddWithValue("@Institution", academics.Institution); cmd.Parameters.AddWithValue("@StartDate", academics.StartDate); cmd.Parameters.AddWithValue("@EndDate", academics.EndDate); cmd.Parameters.AddWithValue("@Graduated", academics.Graduated); cmd.Parameters.AddWithValue("@Major", academics.Major); cmd.Parameters.AddWithValue("@Id", academics.Id); int rows = cmd.ExecuteNonQuery(); if (rows == 0) { throw new Exception("No rows affected"); } } }
public IActionResult AddAcademics() { var usrMgr = GetUserManager(); ViewData["currentUser"] = usrMgr.User; Academics acad = new Academics(); acad.ProfileId = _db.GetProfile(usrMgr.User.Id).Id; return(GetAuthenticatedView("NewAcademics", acad)); }
public Academics GetAcademic(int id) { Academics academic = new Academics(); using (SqlConnection conn = new SqlConnection(_connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("Select * FROM Academics WHERE Id = @Id;", conn); cmd.Parameters.AddWithValue("@Id", id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { academic = MapRowToAcademics(reader); } } return(academic); }
public int AddAcademics(Academics academics) { int id = 0; using (SqlConnection conn = new SqlConnection(_connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO Academics (ProfileId, Degree, Institution, StartDate, EndDate, Graduated, Major)" + "VALUES (@ProfileId, @Degree, @Institution, @StartDate, @EndDate, @Graduated, @Major);" + SCOPE_IDENTITY_SQL, conn); cmd.Parameters.AddWithValue("@ProfileId", academics.ProfileId); cmd.Parameters.AddWithValue("@Degree", academics.Degree); cmd.Parameters.AddWithValue("@Institution", academics.Institution); cmd.Parameters.AddWithValue("@StartDate", academics.StartDate); cmd.Parameters.AddWithValue("@EndDate", academics.EndDate); cmd.Parameters.AddWithValue("@Graduated", academics.Graduated); cmd.Parameters.AddWithValue("@Major", academics.Major); id = (int)cmd.ExecuteScalar(); } return(id); }