public List <TNotice> Select()
{
DataTable dtNotice = _objConnectionFactory.ExecuteStoredProcedureQuery("spSelectNotice");
TNotice objNotice = null;
List <TNotice> lstNotice = new List <TNotice>();
foreach (DataRow row in dtNotice.Rows)
{
objNotice = new TNotice(row);
_objConnectionFactory.AddParameter("@pIdNotice", objNotice.IdNotice);
DataTable dtDepartmentNotice = _objConnectionFactory.ExecuteStoredProcedureQuery("spSelectDepartmentNoticeForNotice");
TDepartment objDepartment = null;
foreach (DataRow item in dtDepartmentNotice.Rows)
{
objDepartment = new TDepartment(item);
objNotice.Departments.Add(objDepartment);
objDepartment = null;
}
lstNotice.Add(objNotice);
objNotice = null;
}
return(lstNotice);
}
public TNotice Select(int id)
{
_objConnectionFactory.AddParameter("@pIdNotice", id);
DataTable dtNotice = _objConnectionFactory.ExecuteStoredProcedureQuery("spSelectNoticeById");
TNotice objNotice = null;
if (dtNotice.Rows.Count > 0)
{
objNotice = new TNotice(dtNotice.Rows[0]);
_objConnectionFactory.AddParameter("@pIdNotice", objNotice.IdNotice);
DataTable dtDepartmentNotice = _objConnectionFactory.ExecuteStoredProcedureQuery("spSelectDepartmentNoticeForNotice");
TDepartment objDepartment = null;
foreach (DataRow item in dtDepartmentNotice.Rows)
{
objDepartment = new TDepartment(item);
objNotice.Departments.Add(objDepartment);
objDepartment = null;
}
}
return(objNotice);
}
