public Department[] GetDepartments()
{
DataSet returnDataSet = null;
Department[] departments = null;
using (SqlCommand command = NewCommand())
{
List<Department> DepartmentList = new List<Department>();
Department department = null;
command.CommandText = "[dbo].[GetDepartments]";
returnDataSet = ExecuteQuery(command);
if (returnDataSet != null && returnDataSet.Tables != null && returnDataSet.Tables.Count > 0 && returnDataSet.Tables[0].Rows != null && returnDataSet.Tables[0].Rows.Count > 0)
{
department = new Department();
DataRow UserRow = returnDataSet.Tables[0].Rows[0];
if (UserRow["DepartmentId"] != DBNull.Value)
department.DepartmentId = Convert.ToInt32(UserRow["DepartmentId"].ToString(), CultureInfo.InvariantCulture);
if (UserRow["Name"] != DBNull.Value)
department.Name = UserRow["Name"].ToString();
if (UserRow["GroupName"] != DBNull.Value)
department.GroupName = UserRow["GroupName"].ToString();
if (UserRow["ModifiedDate"] != DBNull.Value)
department.ModifiedDate = Convert.ToDateTime(UserRow["ModifiedDate"].ToString(), CultureInfo.InvariantCulture);
}
if (DepartmentList.Count > 0)
departments = DepartmentList.ToArray();
}
return departments;
}
public Developer(int id, string firstName, string lastName, decimal salary, Department department)
: base(id, firstName, lastName, salary, department)
{
}