// Database methods // Get all Collective agreements from database private List <CollectiveAgreement> GetCollectiveAgreementsAsync() { using (var ctx = new SW3Projekt.DatabaseDir.Database()) { List <CollectiveAgreement> colAgreeList = new List <CollectiveAgreement>(); colAgreeList = ctx.CollectiveAgreements.Include(x => x.Rates).ToList(); colAgreeList = SortAgreements(colAgreeList); return(colAgreeList); } }
public void SetCollectiveAgreementArchived(CollectiveAgreement colAgr) { using (var ctx = new SW3Projekt.DatabaseDir.Database()) { CollectiveAgreement col = ctx.CollectiveAgreements.FirstOrDefault(x => x.Id == colAgr.Id); col.IsArchived = true; ctx.CollectiveAgreements.Attach(col); ctx.Entry(col).State = EntityState.Modified; ctx.SaveChanges(); } }
public void SetCollectiveAgreementActive(CollectiveAgreement colAgr) { using (var ctx = new SW3Projekt.DatabaseDir.Database()) { foreach (CollectiveAgreement item in ctx.CollectiveAgreements.ToList()) { item.IsActive = false; } CollectiveAgreement col = ctx.CollectiveAgreements.FirstOrDefault(x => x.Id == colAgr.Id); col.IsActive = true; ctx.CollectiveAgreements.Attach(col); ctx.Entry(col).State = EntityState.Modified; ctx.SaveChanges(); } }