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); }