public IActionResult GetStudents(string orderBy)
{
//List<Student> list = new List<Student>();
//using (var client = new SqlConnection(connection))
//{
// using (var command = new SqlCommand())
// {
// command.Connection = client;
// command.CommandText = "SELECT firstname , lastname , birthdate , name , semester " +
// " FROM Enrollment e, Student s, Studies ss" +
// " WHERE s.IdEnrollment = e.IdEnrollment AND e.IdStudy = ss.IdStudy;";
// client.Open();
// var dr = command.ExecuteReader();
// while (dr.Read())
// {
// var st = new Student();
// st.FirstName = dr["FirstName"].ToString();
// st.LastName = dr["LastName"].ToString();
// st.BirthDate = (DateTime)dr["BirthDate"];
// st.Studies = dr["Name"].ToString();
// st.Semester = int.Parse(dr["SEMESTER"].ToString());
// list.Add(st);
// }
// }
//}
////return Ok(_dbservice.GetStudents());
//SELECT * FROM student;
var db = new s18964Context();
var res = db.Student.ToList();
return(Ok(res));
}
public IActionResult DeleteStudent(string id)
{
var db = new s18964Context();
var d = new Student
{
IndexNumber = id
};
db.Attach(d);
db.Remove(d);
db.SaveChanges();
return(Ok("Usuwanie ukonczone"));
}
public IActionResult UpdateStudent(string id)
{
var db = new s18964Context();
var d1 = new Student
{
IndexNumber = id,
LastName = "ZmienioneNazwisko"
};
db.Attach(d1);
db.Entry(d1).Property("LastName").IsModified = true;
db.SaveChanges();
var res = db.Student.Where(student => student.IndexNumber == id).Select(student => new
{
Numer = student.IndexNumber,
Nazwisko = student.LastName
});
return(Ok(res));
}
public IActionResult GetStudent(string idstudent)
{
//string semester;
//using (var client = new SqlConnection(connection))
//{
// using (var command = new SqlCommand())
// {
// command.Connection = client;
// command.CommandText = "SELECT indexnumber, firstname, lastname, semester " +
// " FROM Enrollment e, Student s, Studies ss" +
// " WHERE s.IdEnrollment = e.IdEnrollment AND e.IdStudy = ss.IdStudy AND IndexNumber = @idstudent;";
// command.Parameters.AddWithValue("idstudent", idstudent);
// client.Open();
// var dr = command.ExecuteReader();
// dr.Read();
// semester = dr["indexnumber"].ToString();
// }
//}
//return Ok(semester);
//if (id == 1)
//{
// return Ok("Kowalski");
//} else if (id == 2)
//{
// return Ok("Malewski");
//}
//return NotFound("Nie znaleziono studenta");
var db = new s18964Context();
var res = db.Student.Where(student => student.IndexNumber == idstudent).Select(student => new
{
Numer = student.IndexNumber,
Imie = student.FirstName,
Nazwisko = student.LastName
});
return(Ok(res));
}
