public override List <ProductPurchase> GetProductPurchaseList()
{
List <ProductPurchase> list = new List <ProductPurchase>();
using (SqlConnection connection = this.GetSqlConnection())
{
int activityReportNum = CommerceSettings.Instance.ActivityReportNum;
SqlCommand command = new SqlCommand("select top " + activityReportNum + " * from SuCommerce_vw_Purchases order by PurchaseDateTime desc", connection)
{
CommandType = CommandType.Text
};
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
ProductPurchase purchase = null;
while (reader.Read())
{
purchase = new ProductPurchase();
CommerceDataProvider.PopulateProductPurchaseList(reader, purchase);
list.Add(purchase);
}
reader.Close();
connection.Close();
}
}
return(list);
}
public override List <ProductPurchase> GetUserPurchases(int userID)
{
List <ProductPurchase> list = new List <ProductPurchase>();
using (SqlConnection connection = this.GetSqlConnection())
{
SqlCommand command = new SqlCommand("select * from SuCommerce_vw_Purchases where userID = " + userID + " order by PurchaseDateTime desc", connection)
{
CommandType = CommandType.Text
};
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
ProductPurchase purchase = null;
while (reader.Read())
{
purchase = new ProductPurchase();
CommerceDataProvider.PopulateProductPurchaseList(reader, purchase);
list.Add(purchase);
}
reader.Close();
connection.Close();
}
}
return(list);
}
public override ProductPurchase GetProductPurchase(int purchaseID)
{
ProductPurchase purchase = new ProductPurchase();
using (SqlConnection connection = this.GetSqlConnection())
{
SqlCommand command = new SqlCommand("select * from SuCommerce_vw_Purchases where purchaseID = " + purchaseID, connection)
{
CommandType = CommandType.Text
};
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
CommerceDataProvider.PopulateProductPurchaseList(reader, purchase);
}
reader.Close();
connection.Close();
}
}
return(purchase);
}