public HttpResponseMessage GetbyID(int id)
{
DbManagement db_data = new DbManagement();
StudentData student = db_data.GetStudentsDatabyID(id);
if (student != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, student));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student not found"));
}
}
public HttpResponseMessage Post([FromBody] StudentData student)
{
DbManagement db_data = new DbManagement();
int rows_affected = db_data.AddNewStudent(student);
if (rows_affected != -2)
{
return(Request.CreateResponse(HttpStatusCode.OK, rows_affected.ToString() + " row(s) affected"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "Error Adding student student"));
}
}
public int AddNewStudent(StudentData student)
{
try
{
using (SqlConnection connection = new SqlConnection(connectionString.ToString()))
{
connection.Open();
String sql_query = "Insert into student Values (" + (student.ID).ToString() + ",'" + student.FirstName + "', '" + student.LastName + "', " + student.GPA + ")";
using (SqlCommand command = new SqlCommand(sql_query, connection))
{
int rows_affected = command.ExecuteNonQuery();
return(rows_affected);
}
}
}
catch (SqlException sqle)
{
return(-2);
}
}
