private static void UpdatePhones(BranchDTO branchDTO, Branch branch, RampUpProjectEntities dbContext) { if (branch.Phones != null) { foreach (Phone phone in branch.Phones) { if (phone.Phone_Id != 0) { dbContext.Entry(phone).State = System.Data.Entity.EntityState.Modified; } else { dbContext.Entry(phone).State = System.Data.Entity.EntityState.Added; } } List <int> phones = branch.Phones.Select(y => y.Phone_Id).ToList(); List <Phone> toBeDeletedPhones = dbContext.Phones.Where(x => !phones.Contains(x.Phone_Id) && x.Branch_Id == branchDTO.Branch_Id).ToList(); foreach (Phone phone in toBeDeletedPhones) { dbContext.Entry(phone).State = System.Data.Entity.EntityState.Deleted; } } }
private static void UpdateFields(BranchDTO branchDTO, Branch branch, RampUpProjectEntities dbContext) { if (branch.Fields != null) { foreach (Field field in branch.Fields) { if (field.Field_Id != 0) { dbContext.Entry(field).State = System.Data.Entity.EntityState.Modified; } else { dbContext.Entry(field).State = System.Data.Entity.EntityState.Added; } } List <int> fields = branch.Fields.Select(y => y.Field_Id).ToList(); List <Field> toBeDeletedFields = dbContext.Fields.Where(x => !fields.Contains(x.Field_Id) && x.Branch_Id == branchDTO.Branch_Id).ToList(); foreach (Field field in toBeDeletedFields) { dbContext.Entry(field).State = System.Data.Entity.EntityState.Deleted; } } }
public void UpdateUser(UserDTO userDTO) { try { User user = ConvertUserDTOToUser(userDTO); user.Password = Encryption.Encrypt(user.Password, encryptionKey); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { if (user.Phones != null) { foreach (Phone phone in user.Phones) { if (phone.Phone_Id != 0) { dbContext.Entry(phone).State = System.Data.Entity.EntityState.Modified; } else { dbContext.Entry(phone).State = System.Data.Entity.EntityState.Added; } } List <int> phones = user.Phones.Select(y => y.Phone_Id).ToList(); List <Phone> toBeDeletedPhones = dbContext.Phones.Where(x => !phones.Contains(x.Phone_Id) && x.User_Id == userDTO.User_Id).ToList(); foreach (Phone phone in toBeDeletedPhones) { dbContext.Entry(phone).State = System.Data.Entity.EntityState.Deleted; } } if (user.Address != null) { dbContext.Entry(user.Address).State = System.Data.Entity.EntityState.Modified; } dbContext.Users.Attach(user); dbContext.Entry(user).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public void UpdateField(FieldDTO fieldDTO) { try { Field field = ConvertFieldDTOToField(fieldDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Fields.Attach(field); dbContext.Entry(field).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public void UpdateBranch(BranchDTO branchDTO) { try { Branch branch = ConvertBranchDTOToBranch(branchDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { UpdatePhones(branchDTO, branch, dbContext); UpdateFields(branchDTO, branch, dbContext); if (branch.Address != null) { dbContext.Entry(branch.Address).State = System.Data.Entity.EntityState.Modified; } dbContext.Branches.Attach(branch); dbContext.Entry(branch).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public void UpdateBusiness(BusinessDTO businessDTO) { try { Business business = ConvertBusinessDTOToBusiness(businessDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Businesses.Attach(business); dbContext.Entry(business).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } catch (Exception) { throw; } }