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);
}
