public ChartOfAccs GetsByString(string sString) { ChartOfAccs oChartOfAccs = new ChartOfAccs(); try { SqlCommand cmd = new SqlCommand("SP_ChartOfAcc_GetsByString", _conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Coa_id", SqlDbType.VarChar)).Value = sString; if (_conn.State == ConnectionState.Open) { } else { cmd.Connection.Open(); } IDataReader reader = cmd.ExecuteReader(); oChartOfAccs = CreateObjects(reader); reader.Close(); cmd.Dispose(); cmd.Connection.Close(); } catch (Exception e) { throw new ServiceException(e.Message, e); } return(oChartOfAccs); }
public ChartOfAccs Gets() { ChartOfAccs oChartOfAccs = new ChartOfAccs(); try { SqlCommand cmd = new SqlCommand("SP_ChartOfAcc_Gets", _conn); cmd.CommandType = CommandType.StoredProcedure; if (_conn.State == ConnectionState.Open) { } else { cmd.Connection.Open(); } IDataReader reader = cmd.ExecuteReader(); oChartOfAccs = CreateObjects(reader); reader.Close(); cmd.Dispose(); cmd.Connection.Close(); } catch (Exception e) { throw new ServiceException(e.Message, e); } return(oChartOfAccs); }
private ChartOfAccs CreateObjects(IDataReader oReader) { ChartOfAccs oChartOfAccs = new ChartOfAccs(); NullHandler oHandler = new NullHandler(oReader); while (oReader.Read()) { ChartOfAcc oItem = CreateObject(oHandler); oChartOfAccs.Add(oItem); } return(oChartOfAccs); }