public SpecialOfferProductCollection GetAllSpecialOfferProductsCollection()
{
IDBManager dbm = new DBManager();
SpecialOfferProductCollection cols = new SpecialOfferProductCollection();
try
{
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSpecialOfferProductAll");
while (reader.Read())
{
SpecialOfferProduct SOP = new SpecialOfferProduct();
SOP.SpecialOfferID = Int32.Parse(reader["SpecialOfferID"].ToString());
SOP.ProductID = Int32.Parse(reader["ProductID"].ToString());
SOP.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(SOP);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSpecialOfferProductsCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
public SpecialOfferProductCollection GetAllSpecialOfferProductsDynamicCollection(string whereExpression, string orderBy)
{
IDBManager dbm = new DBManager();
SpecialOfferProductCollection cols = new SpecialOfferProductCollection();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", whereExpression);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSpecialOfferProductsDynamic");
while (reader.Read())
{
SpecialOfferProduct SOP = new SpecialOfferProduct();
SOP.SpecialOfferID = Int32.Parse(reader["SpecialOfferID"].ToString());
SOP.ProductID = Int32.Parse(reader["ProductID"].ToString());
SOP.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(SOP);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSpecialOfferProductsDynamicCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
public void ExportSpecialOffers()
{
SqlCompactConnection conn = new SqlCompactConnection();
SpecialOffer so = new SpecialOffer();
SpecialOfferCollection soCol = new SpecialOfferCollection();
SpecialOfferProduct sop = new SpecialOfferProduct();
SpecialOfferProductCollection sopCol = new SpecialOfferProductCollection();
string where = "startdate <= getdate() and enddate >= getdate()";
string orderby = "specialofferid";
try
{
//ds = q.GetDataSet(false, sql);
soCol = so.GetSpecialOffersCollection(where, orderby);
conn.SynchForm = this;
conn.DropSepcialOfferTable();
conn.CreateSpecialOfferTable();
conn.AddSpecialOffer(soCol);
where = "specialofferid in (select specialofferid from specialoffer where startdate <= getdate() and enddate >= getdate())";
orderby = "specialofferid";
sopCol = sop.GetSpecialOfferProductsCollection(where, orderby);
conn.DropSepcialOfferProductTable();
conn.CreateSpecialOfferProductTable();
conn.AddSpecialOfferProduct(sopCol);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.CloseDatabase();
conn = null;
so = null;
soCol = null;
sop = null;
sopCol = null;
//ds.Dispose();
// q = null;
}
}