public StudentList GetStudentsById(Guid Id) { Database database = new Database("DB_109645_projectfinal"); DataTable dt = new DataTable(); database.Command.CommandType = CommandType.StoredProcedure; database.Command.CommandText = "tblStudentGetById"; database.Command.Parameters.Add("@Id", SqlDbType.UniqueIdentifier).Value = Id; dt = database.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { Student student = new Student(); student.Initialize(dr); student.InitializeBusinessData(dr); _List.Add(student); } return(this); }
public StudentList Search() { StudentDB database = new StudentDB("Student"); database.Command.Parameters.Clear(); database.Command.CommandType = System.Data.CommandType.Text; _Criteria.TableName = "tblStudent"; database.Command.CommandText = SQLHelper.Builder.Build(_Criteria); DataTable dt = database.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { Student student = new Student(); student.Initialize(dr); student.InitializeBusinessData(dr); student.isNew = false; student.isDirty = false; _List.Add(student); } return(this); }
public StudentList GetAll() { Database database = new Database("DB_109645_projectfinal"); database.Command.Parameters.Clear(); database.Command.CommandType = CommandType.StoredProcedure; database.Command.CommandText = "tblStudentGetAll"; DataTable dt = database.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { Student student = new Student(); student.Initialize(dr); student.InitializeBusinessData(dr); student.IsNew = false; student.IsDirty = false; student.Savable += Student_Savable; _List.Add(student); } return(this); }