public ObservableCollection <CombinedControlEntity> GetCombinedControls()
{
using (var context = new CombinedControlContext())
{
return(new ObservableCollection <CombinedControlEntity>(context.CombinedControls));
}
}
public async Task Init()
{
using (var context = new CombinedControlContext())
{
await context.Database.EnsureCreatedAsync();
}
}
public async Task RemoveCombindControl(CombinedControlEntity combinedControl)
{
using (var context = new CombinedControlContext())
{
context.Remove(combinedControl);
await context.SaveChangesAsync();
}
}
/// <summary>
/// Add or Update Combined Control setting item
/// </summary>
/// <param name="combinedControl">Combined Control item newly created or retrieved from DB and updated.</param>
/// <returns></returns>
public async Task AddUpdateCombinedControl(CombinedControlEntity combinedControl)
{
using (var context = new CombinedControlContext())
{
var match = from item in context.CombinedControls
where item.ID == combinedControl.ID
select item;
if (match.Any())
{
context.Update(combinedControl);
}
else
{
context.Add(combinedControl);
}
await context.SaveChangesAsync();
}
}
