public IList <SpecialtyBusiness> GetAllSpecialtyBusiness() { IList <SpecialtyBusiness> listSpecialty = new List <SpecialtyBusiness>(); string sql = "SELECT Specialty.*, Department.DepartmentFullName, Department.DepartmentShortName FROM Specialty INNER JOIN Department ON Specialty.DepartmentId = Department.DepartmentId"; using (SqlDataReader reader = DBHelper.ExecuteReader(sql)) { while (reader.Read()) { SpecialtyBusiness specialty = new SpecialtyBusiness(); specialty.SpecialtyId = Convert.ToInt32(reader["SpecialtyId"].ToString()); specialty.DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString()); specialty.SpecialtyFullName = reader["SpecialtyFullName"].ToString(); specialty.SpecialtyShortName = reader["SpecialtyShortName"].ToString(); specialty.SpecialtyDescription = reader["SpecialtyDescription"].ToString(); specialty.DepartmentFullName = reader["DepartmentFullName"].ToString(); specialty.DepartmentShortName = reader["DepartmentShortName"].ToString(); listSpecialty.Add(specialty); } } return(listSpecialty); }
public IList <SpecialtyBusiness> GetSpecialtyByDepartmentId(int departmentId) { IList <SpecialtyBusiness> listSpecialty = new List <SpecialtyBusiness>(); string sql = "SELECT Specialty.*, Department.DepartmentFullName, Department.DepartmentShortName FROM Specialty INNER JOIN Department ON Specialty.DepartmentId = Department.DepartmentId where Department.DepartmentId = @DepartmentId"; SqlParameter parameter = new SqlParameter("@DepartmentId", SqlDbType.Int); parameter.Value = departmentId; using (SqlDataReader reader = DBHelper.ExecuteReader(sql, parameter)) { while (reader.Read()) { SpecialtyBusiness specialty = new SpecialtyBusiness(); specialty.SpecialtyId = Convert.ToInt32(reader["SpecialtyId"].ToString()); specialty.DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString()); specialty.SpecialtyFullName = reader["SpecialtyFullName"].ToString(); specialty.SpecialtyShortName = reader["SpecialtyShortName"].ToString(); specialty.SpecialtyDescription = reader["SpecialtyDescription"].ToString(); specialty.DepartmentFullName = reader["DepartmentFullName"].ToString(); specialty.DepartmentShortName = reader["DepartmentShortName"].ToString(); listSpecialty.Add(specialty); } } return(listSpecialty); }