public static void AddCompany(Company company) { using (var context = new ClientBaseContext()) { context.Companies.Add(company); context.SaveChanges(); } }
public static void AddUser(User user) { using (var context = new ClientBaseContext()) { context.Users.Add(user); context.SaveChanges(); } }
public static void UpdateCompany(Company company) { using (var context = new ClientBaseContext()) { var companyEntity = context.Companies.Find(company.Id); context.Entry(companyEntity).CurrentValues.SetValues(company); context.SaveChanges(); } }
public static void UpdateUser(User user) { using (var context = new ClientBaseContext()) { var userEntity = context.Users.Find(user.Id); context.Entry(userEntity).CurrentValues.SetValues(user); context.SaveChanges(); } }
public static void DeleteUser(User user) { using (var context = new ClientBaseContext()) { var userEntity = context.Users.First(u => u.Id == user.Id); context.Users.Remove(userEntity); context.SaveChanges(); } }
public static void DeleteCompany(Company company) { using (var context = new ClientBaseContext()) { var companyEntity = context.Companies.First(c => c.Id == company.Id); context.Users.RemoveRange(companyEntity.Users); context.Companies.Remove(companyEntity); context.SaveChanges(); } }