private AddBranchs CreateObjects(IDataReader oReader)
{
AddBranchs oAddBranchs = new AddBranchs();
NullHandler oHandler = new NullHandler(oReader);
while (oReader.Read())
{
AddBranch oItem = CreateObject(oHandler);
oAddBranchs.Add(oItem);
}
return(oAddBranchs);
}
public AddBranchs Gets(int nID)
{
AddBranchs oAddBranchs = null;
try
{
string QueryString = "SELECT * FROM tbl_Branchs WHERE brn_id IN (SELECT brn_id FROM tbl_TeacherAsign WHERE tch_id=" + nID + ")";
IDataReader reader = ExecuteQueryFunctions.ExeReader(_conn, QueryString);
oAddBranchs = CreateObjects(reader);
reader.Close();
_conn.Close();
}
catch (Exception e)
{
throw new ServiceException("Failed to Get AddBranchs", e);
}
return(oAddBranchs);
}
public AddBranchs GetsByType(int nbrn_type)
{
AddBranchs oAddBranchs = null;
try
{
string QueryString = "SELECT * FROM tbl_Branchs WHERE brn_type=" + nbrn_type;
IDataReader reader = ExecuteQueryFunctions.ExeReader(_conn, QueryString);
oAddBranchs = CreateObjects(reader);
reader.Close();
_conn.Close();
}
catch (Exception e)
{
throw new ServiceException("Failed to Get AddBranchs", e);
}
return(oAddBranchs);
}
