/// <summary>
/// Get list of products from database
/// </summary>
/// <param name="whereString">sql string contain 'where' params. Ex: "name LIKE '%Apple%'"</param>
/// <returns>List of Product objects</returns>
public List <IProduct> GetProducts(string whereString = "")
{
List <IProduct> list = new List <IProduct>();
DBAdapter adapter = new DBAdapter();
MySqlDataReader products;
try
{
adapter.OpenConnection();
if (whereString == "")
{
products = adapter.GetSelectReader("oc_product", join: adapter.GetJoinedTableString("oc_product_description", "LEFT", "product_id"));
}
else
{
products = adapter.GetSelectReader("oc_product", where : whereString, join: adapter.GetJoinedTableString("oc_product_description", "LEFT", "product_id"));
}
while (products.Read())
{
list.Add(Product.Get()
.SetName(products["name"].ToString())
.SetDescription(products["description"].ToString())
.SetID(Int32.Parse(products["product_id"].ToString()))
.SetImage(products["image"].ToString())
.SetPrice(Convert.ToDouble(products["price"].ToString()))
.SetQuantity(Int32.Parse(products["quantity"].ToString()))
.Build()
);
}
}
catch
{
throw new Exception();
}
finally
{
adapter.CloseConnection();
}
return(list);
}
/// <summary>
/// Get list of products review from database
/// </summary>
/// <param name="whereString">sql string contain 'where' params. Ex: "name LIKE '%name%'"</param>
/// <returns>List of ProductReview objects</returns>
public List <IProductReview> GetProductsReview(string whereString = "")
{
List <IProductReview> list = new List <IProductReview>();
DBAdapter adapter = new DBAdapter();
MySqlDataReader products;
try
{
adapter.OpenConnection();
if (whereString == "")
{
products = adapter.GetSelectReader("oc_review", join: adapter.GetJoinedTableString("oc_product_description", "LEFT", "product_id"));
}
else
{
products = adapter.GetSelectReader("oc_review", where : whereString, join: adapter.GetJoinedTableString("oc_product_description", "LEFT", "product_id"));
}
while (products.Read())
{
list.Add(ProductReview.Get()
.SetProductName(products["name"].ToString())
.SetReviewerName(products["author"].ToString())
.SetReviewText(products["text"].ToString())
.SetRating((Int32.Parse(products["raiting"].ToString())).ToRating())
.SetDate(products["date_added"].ToString())
.Build());
}
}
catch
{
throw new Exception();
}
finally
{
adapter.CloseConnection();
}
return(list);
}
/// <summary>
/// Get list of currency from database
/// </summary>
/// <param name="whereString">sql string contain 'where' params. Ex: "name LIKE '%name%'"</param>
/// <returns>List of Currency objects</returns>
public List <ICurrency> GetCurrency(string whereString = "")
{
List <ICurrency> list = new List <ICurrency>();
DBAdapter adapter = new DBAdapter();
MySqlDataReader products;
try
{
adapter.OpenConnection();
if (whereString == "")
{
products = adapter.GetSelectReader("oc_currency");
}
else
{
products = adapter.GetSelectReader("oc_currency", where : whereString);
}
while (products.Read())
{
list.Add(Currency.Get()
.SetValue(Double.Parse(products["value"].ToString()))
.SetID(Int32.Parse(products["currency_id"].ToString()))
.SetTitle(products["title"].ToString())
.SetCode(products["code"].ToString())
.Build()
);
}
}
catch
{
throw new Exception();
}
finally
{
adapter.CloseConnection();
}
return(list);
}
/// <summary>
/// Get list of cart from database
/// </summary>
/// <param name="whereString">sql string contain 'where' params. Ex: "name LIKE '%name%'"</param>
/// <returns>List of Cart objects</returns>
public List <ICart> GetCart(string whereString = "")
{
List <ICart> list = new List <ICart>();
DBAdapter adapter = new DBAdapter();
MySqlDataReader products;
try
{
adapter.OpenConnection();
if (whereString == "")
{
products = adapter.GetSelectReader("oc_cart");
}
else
{
products = adapter.GetSelectReader("oc_cart", where : whereString);
}
while (products.Read())
{
list.Add(Cart.Get()
.SetID(Int32.Parse(products["cart_id"].ToString()))
.SetCustomerID(Int32.Parse(products["customer_id"].ToString()))
.SetDate(products["date_added"].ToString())
.SetProductID(Int32.Parse(products["product_id"].ToString()))
.Build()
);
}
}
catch
{
throw new Exception();
}
finally
{
adapter.CloseConnection();
}
return(list);
}
/// <summary>
/// Get list of category from database
/// </summary>
/// <param name="whereString">sql string contain 'where' params. Ex: "name LIKE '%name%'"</param>
/// <returns>List of Category objects</returns>
public List <ICategory> GetCategories(string whereString = "")
{
List <ICategory> list = new List <ICategory>();
DBAdapter adapter = new DBAdapter();
MySqlDataReader products;
try
{
adapter.OpenConnection();
if (whereString == "")
{
products = adapter.GetSelectReader("oc_category", join: adapter.GetJoinedTableString("oc_category_description", "LEFT", "category_id"));
}
else
{
products = adapter.GetSelectReader("oc_category", where : whereString, join: adapter.GetJoinedTableString("oc_category_description", "LEFT", "category_id"));
}
while (products.Read())
{
list.Add(Category.Get()
.SetName(products["name"].ToString())
.SetDescription(products["description"].ToString())
.SetID(Int32.Parse(products["category_id"].ToString()))
.SetParent(Int32.Parse(products["parent_id"].ToString()))
.Build()
);
}
}
catch
{
throw new Exception();
}
finally
{
adapter.CloseConnection();
}
return(list);
}