public Studentout GetStudent(int id)
{
var student = new Studentout();
using (var client = new SqlConnection("Data Source = db-mssql.pjwstk.edu.pl; Initial Catalog = s16796; Integrated Security = True"))
{
using (var command = new SqlCommand())
{
command.Connection = client;
//indexy od 12 do 20, podawane jako np localhost:44312/api/students/13 da studenta s13
command.CommandText = "SELECT * FROM Student st JOIN ENROLLMENT enr ON st.IdEnrollment = enr.IdEnrollment JOIN Studies sts on enr.IdStudy = sts.IdStudy WHERE IndexNumber LIKE '%' + CAST(@id AS varchar)";
command.Parameters.AddWithValue("id", id);
client.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
student.firstName = reader["FirstName"].ToString();
student.lastName = reader["LastName"].ToString();
student.BirthDate = Convert.ToDateTime(reader["BirthDate"].ToString());
student.indexNumber = reader["IndexNumber"].ToString();
student.Study = reader["Name"].ToString();
student.Semester = Convert.ToInt32(reader["Semester"].ToString());
}
}
}
return(student);
}
public IEnumerable <Studentout> GetStudents()
{
var listofstudents = new List <Studentout>();
using (var client = new SqlConnection("Data Source = db-mssql.pjwstk.edu.pl; Initial Catalog = s16796; Integrated Security = True"))
{
using (var command = new SqlCommand())
{
command.Connection = client;
command.CommandText = "SELECT * FROM Student st JOIN ENROLLMENT enr ON st.IdEnrollment = enr.IdEnrollment JOIN Studies sts on enr.IdStudy = sts.IdStudy";
client.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
var st = new Studentout();
st.firstName = reader["FirstName"].ToString();
st.lastName = reader["LastName"].ToString();
st.BirthDate = Convert.ToDateTime(reader["BirthDate"].ToString());
st.indexNumber = reader["IndexNumber"].ToString();
st.Study = reader["Name"].ToString();
st.Semester = Convert.ToInt32(reader["Semester"].ToString());
listofstudents.Add(st);
}
}
}
return(listofstudents);
}
public IActionResult PutStudent(int id, Studentout student)
{
return(Ok("Aktualizacja studenta nr " + id + " dokończona."));
}
public IActionResult CreateStudent(Studentout student)
{
student.indexNumber = $"s{new Random().Next(1, 99999)}";
return(Ok(student));
}
