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