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