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