public IActionResult GetStudents(string indexNumber)
{
ListaStudentow l1 = new ListaStudentow();
using (var client = new SqlConnection("Data Source=db-mssql;Initial Catalog=s18836;Integrated Security=True"))
using (var com = new SqlCommand())
{
com.Connection = client;
com.CommandText = "USE [2019SBD]; SELECT * FROM STUDENT where STUDENT.IndexNumber = @index";
com.Parameters.AddWithValue("index", indexNumber);
client.Open();
var dr = com.ExecuteReader();
while (dr.Read())
{
{
var st = new Student();
st.FirstName = (dr["FirstName"].ToString());
st.LastName = (dr["LastName"].ToString());
st.IndexNumber = (dr["IndexNumber"].ToString());
st.BirthDate = ((DateTime)dr["BirthDate"]);
st.IdEnrollment = (dr["IdEnrollment"].ToString());
l1.dodaj(st);
}
}
}
return(Ok(l1.getlist()));
}
private void StudentsDataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
StudentsDbService sd = (StudentsDbService)StudentsDataGrid.SelectedItem;
var edyt = new Edycja(sd);
edyt.ShowDialog();
if (!edyt.IsActive)
{
ListaStudentow.Add(sd);
ListaStudentow.Remove(sd);
}
}
public StudentsViewModel()
{
this.model = new ListaStudentow();
this.studenci = this.model.Studenci;
this.rok = this.model.Rok;
}
