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)); }