public TradeAreaModels GetById(int id) { string sqlString = "select * from m_tradeArea where t_tradeAreaId = " + id; System.Data.SqlClient.SqlDataReader reader = SqlSeverProvider.ExecuteReader(sqlString); TradeAreaModels trade = null; if (reader.Read()) { trade = TradeAreaManager.GetTradeAreaByReader(reader); } return(trade); }
//Methods of IProvider public List <TradeAreaModels> GetAll() { string sqlString = "select * from m_tradeArea"; List <TradeAreaModels> trades = new List <TradeAreaModels>(); DataTable tbl = SqlSeverProvider.ExecuteQuery(sqlString); if (tbl == null) { return(null); } foreach (DataRow row in tbl.Rows) { trades.Add(TradeAreaManager.GetTradeAreaByRow(row)); } return(trades); }