void SendInfoAsJson(UniversityResponse response)
{
string strJson = JsonConvert.SerializeObject(response);
Response.ContentType = "application/json; charset=utf-8";
Response.Write(strJson);
Response.End();
}
public List <UniversityResponse> GetAllUniversities()
{
List <UniversityResponse> response = new List <UniversityResponse>();
string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "GetAllUniversities";
command.Connection = connection;
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
UniversityResponse u = new UniversityResponse()
{
Id = reader.GetInt32(0),
City = reader.GetString(1),
Description = reader.GetString(2),
Name = reader.GetString(3),
NumberOfStudents = reader.GetInt32(4),
PrimaryAddress = reader.GetString(5),
SecondaryAddress = reader.IsDBNull(6) ? "" : reader.GetString(6),
State = reader.GetString(7),
Zip = reader.GetString(8)
};
response.Add(u);
}
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
}
return(response);
}
public List <UniversityResponse> GetUniversity()
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand = connection.CreateCommand("[dbo].[GetUniversitiesUnit]", CommandType.StoredProcedure);
SqlDataReader sqlDr = sqlCommand.ExecuteReader();
var resultList = new List <UniversityResponse>();
while (sqlDr.Read())
{
var result = new UniversityResponse();
result.Id = (int)sqlDr["Id"];
result.Title = (string)sqlDr["Title"];
resultList.Add(result);
}
sqlCommand.Dispose();
return(resultList);
}
protected void Page_Load(object sender, EventArgs e)
{
UniversityRequest request;
UniversityResponse response = new UniversityResponse();
response.error = String.Empty;
// Need passed in store id and number of requested results.
// 1. Deserialize the incoming Json.
try
{
request = GetRequestInfo();
if (request.name == null || request.location == null || request.description == null || request.numStudents == null || request.admin == null)
{
response.error = "University not created";
SendInfoAsJson(response);
return;
}
}
catch (Exception ex)
{
response.error = ex.Message.ToString();
// Return the results as Json.
SendInfoAsJson(response);
return;
}
// Do stuff here.
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
try
{
connection.Open();
string sql = String.Format("SELECT * FROM University WHERE name=@un");
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.Add(new SqlParameter("@un", request.name));
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
response.error = "1";
}
if (response.error != "")
{
SendInfoAsJson(response);
return;
}
}
catch (Exception ex)
{
response.error = ex.Message.ToString();
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
try
{
connection.Open();
string sql = String.Format("INSERT into University (name,location,description,numStudents, superAdmin) VALUES ('{0}','{1}','{2}', '{3}', '{4}')", request.name, request.location, request.description, request.numStudents, request.admin);
SqlCommand command2 = new SqlCommand(sql, connection);
command2.ExecuteNonQuery();
response.message = "Succesfully added university!";
}
catch (Exception ex)
{
response.error = ex.Message.ToString();
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
SendInfoAsJson(response);
}
