public SpecialOfferCollection GetAllSpecialOffersCollection()
{
IDBManager dbm = new DBManager();
SpecialOfferCollection cols = new SpecialOfferCollection();
try
{
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSpecialOfferAll");
while (reader.Read())
{
SpecialOffer SO = new SpecialOffer();
SO.SpecialOfferID = Int32.Parse(reader["SpecialOfferID"].ToString());
SO.Description = reader["Description"].ToString();
SO.Category = reader["Category"].ToString();
SO.DiscountPct = decimal.Parse(reader["DiscountPct"].ToString());
SO.EndDate = DateTime.Parse(reader["EndDate"].ToString());
SO.MaxQty = Int32.Parse(reader["MaxQty"].ToString());
SO.MinQty = Int32.Parse(reader["MinQty"].ToString());
SO.StartDate = DateTime.Parse(reader["StartDate"].ToString());
SO.Type = reader["Type"].ToString();
SO.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(SO);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSpecialOffersCollection");
throw (ex);;
}
finally
{
dbm.Dispose();
}
return(cols);
}
public SpecialOfferCollection GetAllSpecialOffersDynamicCollection(string whereExpression, string orderBy)
{
IDBManager dbm = new DBManager();
SpecialOfferCollection cols = new SpecialOfferCollection();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", whereExpression);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSpecialOffersDynamic");
while (reader.Read())
{
SpecialOffer SO = new SpecialOffer();
SO.SpecialOfferID = Int32.Parse(reader["SpecialOfferID"].ToString());
SO.Description = reader["Description"].ToString();
SO.Category = reader["Category"].ToString();
SO.DiscountPct = decimal.Parse(reader["DiscountPct"].ToString());
SO.EndDate = DateTime.Parse(reader["EndDate"].ToString());
SO.MaxQty = Int32.Parse(reader["MaxQty"].ToString());
SO.MinQty = Int32.Parse(reader["MinQty"].ToString());
SO.StartDate = DateTime.Parse(reader["StartDate"].ToString());
SO.Type = reader["Type"].ToString();
SO.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(SO);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSpecialOffersDynamicCollection");
throw (ex);;
}
finally
{
dbm.Dispose();
}
return(cols);
}