public static bool AddUpdateExemption(Exemption exemption) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.Find(exemption.ID); //Add Exemption if(e == null) return AddExemption(exemption); e.AssignedUsers.Clear(); context.SaveChanges(); } using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.Find(exemption.ID); e.AssignedUsers = exemption.AssignedUsers; context.SaveChanges(); return true; } } catch (Exception ex) { return false; } }
public static bool AddExemption(Exemption exemption) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { foreach (var user in exemption.AssignedUsers) context.Users.Attach(user); context.Exemptions.Add(exemption); context.SaveChanges(); return true; } } catch (Exception ex) { return false; } }
public static bool DeleteExemption(Exemption exemption) { try { using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.Find(exemption.ID); e.AssignedUsers.Clear(); context.SaveChanges(); } using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.Find(exemption.ID); context.Exemptions.Attach(e); context.Exemptions.Remove(e); context.SaveChanges(); } return true; } catch (Exception ex) { return false; } }
public static bool AssignExemption(Exemption exemption) { using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.Find(exemption.ID); //Add Exemption if (e == null) return AddExemption(exemption); } using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.Include(ex=>ex.AssignedUsers).FirstOrDefault(ex=>ex.ID == exemption.ID); e.AssignedUsers.Clear(); context.Exemptions.Attach(e); // context.Entry(e).Property(x => x.AssignedUsers).IsModified = true; context.SaveChanges(); } using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.Include(ex => ex.AssignedUsers).FirstOrDefault(ex => ex.ID == exemption.ID); foreach (var user in exemption.AssignedUsers) { context.Users.Attach(user); e.AssignedUsers.Add(user); } context.Exemptions.Attach(e); // context.Entry(e).Property(x => x.AssignedUsers).IsModified = true; context.SaveChanges(); } return true; }