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