public int[] GetAllTabIds()
{
using (var context = new ScheduleDbContext())
{
return(context.Tabs.Select(t => t.Id).ToArray());
}
}
public TabDto[] GetAll()
{
using (var context = new ScheduleDbContext())
{
return(context.Tabs.ToArray());
}
}
public void Save(TabDto tab)
{
using (var context = new ScheduleDbContext())
{
context.Tabs.Add(tab);
context.SaveChanges();
}
}
public void Delete(int tabId)
{
using (var context = new ScheduleDbContext())
{
TabDto tab = context.Tabs.Find(tabId);
context.Tabs.Remove(tab);
context.SaveChanges();
}
}
public void Update(TabDto tab)
{
using (var context = new ScheduleDbContext())
{
TabDto targetTab = context.Tabs.Find(tab.Id);
if (targetTab == null)
{
throw new InvalidOperationException($"Tab {tab.Id} does not exist");
}
context.Entry(targetTab).CurrentValues.SetValues(tab);
context.SaveChanges();
}
}
public void Save(ResultDto result, AlgorithmSummaryDto[] summaries)
{
using (var context = new ScheduleDbContext())
{
context.Results.Add(result);
context.SaveChanges();
foreach (var summary in summaries)
{
summary.ResultId = result.Id;
context.AlgorithmSummaries.Add(summary);
}
context.SaveChanges();
}
}
public (ResultDto Result, AlgorithmSummaryDto[] Summaries) GetByTab(int tabId)
{
using (var context = new ScheduleDbContext())
{
ResultDto result = context.Results
.Where(r => r.TabId == tabId)
.FirstOrDefault();
if (result == null)
{
throw new InvalidOperationException("No result for tab available");
}
AlgorithmSummaryDto[] summaries = context.AlgorithmSummaries
.Where(a => a.ResultId == result.Id)
.ToArray();
return(Result : result, Summaries : summaries);
}
}