public Core.Business.Department GetDepartByName(string Name)
{
string SqlSelectDepartmentByName = "SELECT [Id], [DepartCode],[DepartName] FROM [Department] WHERE [DepartName]=@DepartName";
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@DepartName", SqlDbType.NVarChar, Name);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectDepartment);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Department department = new Core.Business.Department();
if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1);
if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2);
reader.Close();
department.MarkOld();
return department;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<Core.Business.Department> GetAllDepartment()
{
IList<Core.Business.Department> departmentlist = new List<Core.Business.Department>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllDepartment);
if (reader != null)
{
while (reader.Read())
{
Core.Business.Department department = new Core.Business.Department();
if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1);
if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2);
department.MarkOld();
departmentlist.Add(department);
}
reader.Close();
}
return departmentlist;
}
public Core.Business.Department GetDepartmentByCode(string dcode)
{
Core.Business.Department department = new Core.Business.Department();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@DepartCode", SqlDbType.NVarChar, dcode);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetDepartmentByCode);
if (reader != null)
{
while (reader.Read())
{
if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1);
if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2);
department.MarkOld();
}
reader.Close();
}
return department;
}
public Core.Business.Department Select(string DepartCode)
{
if (String.IsNullOrEmpty(DepartCode))
{
return null;
}
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@DepartCode", SqlDbType.NVarChar, DepartCode, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectDepartmentByCode);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Department department = new Core.Business.Department();
if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1);
if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2);
reader.Close();
department.MarkOld();
return department;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public Core.Business.Department Select(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectDepartment);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Department department = new Core.Business.Department();
if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1);
if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2);
reader.Close();
return department;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
