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