public static CDepartment SearchInDepartmentList(List <CDepartment> Departments, string ID) { CDepartment department = new CDepartment("", "", "", ""); foreach (CDepartment D in Departments) { if (D.ID == ID) { return(D); } } return(department); }
public List <CDepartment> GetDepartments() { List <CDepartment> Departments = new List <CDepartment>(); SqlDataReader reader = mCmd.ExecuteReader(); while (reader.Read()) { CDepartment Department = new CDepartment(reader["ID"].ToString() ?? "", reader["ParentDepartmentID"].ToString() ?? "", reader["Code"].ToString() ?? "", reader["Name"].ToString() ?? ""); Departments.Add(Department); } reader.Dispose(); return(Departments); }