public ShipMethodCollection GetAllShipMethodsDynamicCollection(string whereExpression, string orderBy)
{
IDBManager dbm = new DBManager();
ShipMethodCollection cols = new ShipMethodCollection();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", whereExpression);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectShipMethodsDynamic");
while (reader.Read())
{
ShipMethod SM = new ShipMethod();
SM.ShipMethodID = Int32.Parse(reader["ShipMethodID"].ToString());
SM.Name = reader["Name"].ToString();
SM.ShipBase = decimal.Parse(reader["ShipBase"].ToString());
SM.ShipRate = decimal.Parse(reader["ShipRate"].ToString());
SM.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(SM);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllShipMethodsDynamicCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
public ShipMethodCollection GetAllShipMethodsCollection()
{
IDBManager dbm = new DBManager();
ShipMethodCollection cols = new ShipMethodCollection();
try
{
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectShipMethodAll");
while (reader.Read())
{
ShipMethod SM = new ShipMethod();
SM.ShipMethodID = Int32.Parse(reader["ShipMethodID"].ToString());
SM.Name = reader["Name"].ToString();
SM.ShipBase = decimal.Parse(reader["ShipBase"].ToString());
SM.ShipRate = decimal.Parse(reader["ShipRate"].ToString());
SM.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(SM);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllShipMethodsCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}