public static List <Model.Student> GetAll(Predicate <Model.Student> filter = null) { List <Model.Student> list = new List <Model.Student>(); if (Connect()) { string sql = "SELECT * FROM student"; SqlCommand cmd = new SqlCommand(sql, sqlConnection); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dataTable = new DataTable(); adapter.Fill(dataTable); foreach (DataRow dataRow in dataTable.Rows) { Model.Student model = new Model.Student(); model.LastName = dataRow["lastname"].ToString(); model.FirstName = dataRow["firstname"].ToString(); model.Id_section = int.Parse(dataRow["id_section"].ToString()); model.Section = (Model.Section)SectionRepository.GetOne(int.Parse(dataRow["id_section"].ToString())); list.Add(model); } } Close(); if (filter != null) { list = list.FindAll(filter); } return(list); }
public static Model.Student GetOne(int id) { Model.Student model = null; if (Connect()) { string sql = "SELECT * FROM student WHERE id=@id"; SqlCommand cmd = new SqlCommand(sql, sqlConnection); cmd.Parameters.AddWithValue("@id", id); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dataTable = new DataTable(); adapter.Fill(dataTable); foreach (DataRow dataRow in dataTable.Rows) { model = new Model.Student(); model.LastName = dataRow["lastname"].ToString(); model.FirstName = dataRow["firstname"].ToString(); model.Section = (Model.Section)SectionRepository.GetOne(int.Parse(dataRow["id_section"].ToString())); } } Close(); return(model); }