public ActionResult AddUniversity(UniversityModel model)
{
UniversityConnection connection = new UniversityConnection();
SaveUniversityRequest request = new SaveUniversityRequest()
{
City = model.City,
Description = model.Description,
Name = model.Name,
NumberOfStudents = model.NumberOfStudents,
PrimaryAddress = model.PrimaryAddress,
SecondaryAddress = model.SecondaryAddress,
State = model.State,
Zip = model.Zip
};
connection.AddUniversity(request);
return(View());
}
public void AddUniversity(SaveUniversityRequest request)
{
ConnectionHelper conn = new ConnectionHelper();
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@Name", request.Name),
new SqlParameter("@PrimaryAddress", request.PrimaryAddress),
new SqlParameter("@SecondaryAddress", request.SecondaryAddress),
new SqlParameter("@City", request.City),
new SqlParameter("@State", request.State),
new SqlParameter("@Zip", request.Zip),
new SqlParameter("@NumberOfStudents", request.NumberOfStudents),
new SqlParameter("@Description", request.Description)
};
conn.ExecuteNonQuery("AddUniversity", sqlParams);
}
