/// <summary> /// Get list of address from database /// </summary> /// <param name="whereString">sql string contain 'where' params. Ex: "name LIKE '%name%'"</param> /// <returns>List of Address objects</returns> public List <IAdress> GetAddress(string whereString = "") { List <IAdress> list = new List <IAdress>(); DBAdapter adapter = new DBAdapter(); MySqlDataReader products; try { adapter.OpenConnection(); if (whereString == "") { products = adapter.GetSelectReader("oc_address", columns: "oc_customer.firstname,oc_customer.lastname,company,address_1,address_2,city,postcode,oc_country.name as country,oc_zone.name as zone ", join: String.Concat( GetJoinedTableString("oc_customer", "LEFT", "customer_id"), GetJoinedTableString("oc_country", "LEFT", "country_id"), GetJoinedTableString("oc_zone", "LEFT", "zone_id") ) ); } else { products = adapter.GetSelectReader("oc_address", columns: "oc_customer.firstname,oc_customer.lastname,company,address_1,address_2,city,postcode,oc_country.name as country,oc_zone.name as zone ", where : whereString, join: String.Concat( GetJoinedTableString("oc_customer", "LEFT", "customer_id"), GetJoinedTableString("oc_country", "LEFT", "country_id"), GetJoinedTableString("oc_zone", "LEFT", "zone_id") ) ); } while (products.Read()) { list.Add(Adress.Get() .SetFirstName(products["firstname"].ToString()) .SetLastName(products["lastname"].ToString()) .SetAddress1(products["address_1"].ToString()) .SetCity(products["city"].ToString()) .SetPostCode(products["postcode"].ToString()) .SetCountry(products["country"].ToString()) .SetRegion(products["zone"].ToString()) .SetAddress2(products["address_2"].ToString()) .SetCompany(products["company"].ToString()) .Build() ); } } catch { throw new Exception(); } finally { adapter.CloseConnection(); } return(list); }
/// <summary> /// Get list of users from database /// </summary> /// <param name="whereString">sql string contain 'where' params. Ex: "name LIKE '%name%'"</param> /// <returns>List of User objects</returns> public List <IUser> GetUsers(string whereString = "") { List <IUser> list = new List <IUser>(); DBAdapter adapter = new DBAdapter(); MySqlDataReader products; try { adapter.OpenConnection(); if (whereString == "") { products = adapter.GetSelectReader("oc_customer"); } else { products = adapter.GetSelectReader("oc_customer", where : whereString); } while (products.Read()) { list.Add(User.Get() .SetUsername(products["email"].ToString()) .SetPassword(products["password"].ToString()) .SetSault(products["salt"].ToString()) .SetID(Int32.Parse(products["customer_id"].ToString())) .SetEmail(products["email"].ToString()) .SetFirstName(products["firstname"].ToString()) .SetLastName(products["lastname"].ToString()) .SetSubscribe(Boolean.Parse(products["newsletter"].ToString())) .SetTelephone(products["telephone"].ToString()) .Build() ); } } catch { throw new Exception(); } finally { adapter.CloseConnection(); } return(list); }
/// <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); }