public static void Main(string[] args)
{
CreateHostBuilder(args).Build().Run();
var db = new s17245Context();
var result = db.Student.ToList();
}
public IActionResult DeleteStudent(string id)
{
var db = new s17245Context();
var stud = db.Student.
Where(stud => stud.IndexNumber == id).
First();
db.Student.Remove(stud);
db.SaveChanges();
return(Ok("student usunięty"));
}
public IActionResult GetStudent()
{
var db = new s17245Context();
var res = db.Student
.OrderBy(d => d.LastName)
.Select(stud => new
{
stud.IndexNumber
, stud.LastName
, stud.FirstName
});
return(Ok(res));
}
public IActionResult UpdateStudent(Student student, string id)
{
var db = new s17245Context();
var stud1 = new Student
{
IndexNumber = id
, FirstName = student.FirstName
, LastName = student.LastName
, BirthDate = student.BirthDate
, IdEnrollment = student.IdEnrollment
};
db.Attach(stud1);
db.Entry(stud1).Property("FirstName").IsModified = true;
db.SaveChanges();
return(Ok(stud1));
}
