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