public SalesTerritoryCollection GetAllSalesTerritorysDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); SalesTerritoryCollection cols = new SalesTerritoryCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritorysDynamic"); while (reader.Read()) { SalesTerritory ST = new SalesTerritory(); ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(ST); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesTerritorysDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public SalesTerritoryCollection GetAllSalesTerritorysCollection() { IDBManager dbm = new DBManager(); SalesTerritoryCollection cols = new SalesTerritoryCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritoryAll"); while (reader.Read()) { SalesTerritory ST = new SalesTerritory(); ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(ST); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesTerritorysCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }