public void DeActivateShopItem(ShopSearchParameters lsp) { if (lsp.Id.HasValue) { lsp.Active = false; Update(lsp); } }
public void ActivateShopItem(ShopSearchParameters sp) { if (sp.Id.HasValue) { sp.Active = true; Update(sp); } }
private void Update(ShopSearchParameters i) { SqlItemList sqlItems = GetUpdateParams(i); SetUpdateSql(SynnDataProvider.TableNames.ShoppingItems, sqlItems, new SqlItemList { new SqlItem { FieldName = "Id", FieldValue = i.Id.Value } }); ExecuteSql(); }
public SqlItemList GetUpdateParams(ShopSearchParameters i) { SqlItemList sqlItems = new SqlItemList(); if (i.Active.HasValue) { sqlItems.Add(new SqlItem("Active", i.Active.Value)); } if (i.LastBought.HasValue) { sqlItems.Add(new SqlItem("LastBought", i.LastBought)); } return(sqlItems); }
public List <ShopItem> Get(ShopSearchParameters lsp) { SetSqlFormat("select * from {0}", SynnDataProvider.TableNames.ShoppingItems); ClearParameters(); if (!string.IsNullOrEmpty(lsp.ItemName)) { AddSqlWhereField("Name", lsp.ItemName); } if (lsp.Active.HasValue) { AddSqlWhereField("Active", lsp.Active); } var lst = new List <ShopItem>(); FillList(lst, typeof(ShopItem)); return(lst); }