public void Add(InternetShopFilter filter) { DatabaseProvider.CreateConnectionAndCommand(); // string cmd = "INSERT INTO Names (id, Name, Category, Price) VALUES "; cmd = cmd + "("; List <string> valueComponents = new List <string>(); if (filter.Id.HasValue) { valueComponents.Add(filter.Id.ToString()); } if (!string.IsNullOrEmpty(filter.Name)) { valueComponents.Add(string.Format("'{0}'", filter.Name)); } if (!string.IsNullOrEmpty(filter.Category)) { valueComponents.Add(string.Format("'{0}'", filter.Category)); } if (!string.IsNullOrEmpty(filter.Price)) { valueComponents.Add(string.Format("'{0}'", filter.Price)); } string join = string.Join(", ", valueComponents); cmd = cmd + join; cmd = cmd + ");"; DatabaseProvider.ExecuteCommand(cmd); DatabaseProvider.CloseConnection(); }
public void Update(InternetShopFilter filter) { DatabaseProvider.CreateConnectionAndCommand(); string cmd = "UPDATE Names SET "; List <string> columnsToUpdate = new List <string>(); if (!string.IsNullOrEmpty(filter.Name)) { columnsToUpdate.Add(string.Format("Name = '{0}'", filter.Name)); } if (!string.IsNullOrEmpty(filter.Category)) { columnsToUpdate.Add(string.Format("Category = '{0}'", filter.Category)); } if (!string.IsNullOrEmpty(filter.Price)) { columnsToUpdate.Add(string.Format("Price = '{0}'", filter.Price)); } string where = string.Format(" WHERE id = {0};", filter.Id); cmd = cmd + string.Join(", ", columnsToUpdate.ToArray()) + where; DatabaseProvider.ExecuteCommand(cmd); DatabaseProvider.CloseConnection(); }
public void Delete(InternetShopFilter filter) { DatabaseProvider.CreateConnectionAndCommand(); string cmd = string.Format("DELETE FROM Names WHERE Id = {0}", filter.Id); DatabaseProvider.ExecuteCommand(cmd); DatabaseProvider.CloseConnection(); }
public List <InternetShop> Get(InternetShopFilter filter) { List <InternetShop> ResultInternetShop = new List <InternetShop>(); DatabaseProvider.CreateConnectionAndCommand(); // string cmd = "SELECT * FROM Names"; List <string> conditions = new List <string>(); // if (filter.Id.HasValue) { conditions.Add("Id = " + filter.Id.ToString()); } if (!string.IsNullOrEmpty(filter.Name)) { conditions.Add(string.Format("Name = '{0}'", filter.Name)); } if (!string.IsNullOrEmpty(filter.Category)) { conditions.Add(string.Format("Category = '{0}'", filter.Category)); } if (!string.IsNullOrEmpty(filter.Price)) { conditions.Add(string.Format("Price = '{0}'", filter.Price)); } if (conditions.Count() > 0) { cmd += " WHERE " + string.Join(" AND ", conditions.ToArray()); } DatabaseProvider.ExecuteCommand(cmd); // DatabaseProvider.BeginReader(); while (DatabaseProvider.Reader.Read()) { int id = (int)DatabaseProvider.Reader["id"]; string name = (string)DatabaseProvider.Reader["name"]; string category = (string)DatabaseProvider.Reader["category"]; string price = (string)DatabaseProvider.Reader["Price"]; InternetShop collection = new InternetShop(id, name, category, price); ResultInternetShop.Add(collection); } DatabaseProvider.FinishReader(); // DatabaseProvider.CloseConnection(); return(ResultInternetShop); }