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