public EmployeeList GetAll() { Database database = new Database("Employer"); database.Command.Parameters.Clear(); database.Command.CommandType = System.Data.CommandType.StoredProcedure; database.Command.CommandText = "tblEmployeeGetAll"; DataTable dt = database.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { Employee e = new Employee(); e.Initialize(dr); e.InitializeBusinessData(dr); e.IsNew = false; e.IsDirty = false; e.Savable += Employee_Savable; e.Phones.Savable += Phones_Savable; e.Emails.Savable += Emails_Savable; e.Subordinates.Savable += Subordinates_Savable; e.Family.Savable += Family_Savable; _List.Add(e); } return(this); }
public EmployeeList GetByDepartmentId(Guid departmentId) { Database database = new Database("Employer"); database.Command.Parameters.Clear(); database.Command.CommandType = System.Data.CommandType.StoredProcedure; database.Command.CommandText = "tblEmployeeGetByDepartmentId"; database.Command.Parameters.Add("@DepartmentId", SqlDbType.UniqueIdentifier).Value = departmentId; DataTable dt = database.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { Employee e = new Employee(); e.Initialize(dr); e.InitializeBusinessData(dr); e.IsNew = false; e.IsDirty = false; e.Savable += Employee_Savable; e.Phones.Savable += Phones_Savable; e.Emails.Savable += Emails_Savable; e.Subordinates.Savable += Subordinates_Savable; _List.Add(e); } return(this); }