public Beneficiary Update(Guid id, Beneficiary beneficiary) { if (beneficiary != null) { _db.Update(beneficiary); _db.SaveChanges(); } return(beneficiary); }
public BeneficiaryTelephone Update(Guid id, BeneficiaryTelephone telephones) { if (telephones != null) { _db.Update(telephones); _db.SaveChanges(); } return(telephones); }
public Address Update(Guid id, Address address) { if (address != null) { _db.Update(address); _db.SaveChanges(); } return(address); }
public Telephone Update(Guid id, Telephone telephone) { if (telephone != null) { _db.Update(telephone); _db.SaveChanges(); } return(telephone); }
public Individual Update(Guid id, Individual individual) { if (individual != null) { _db.Update(individual); _db.SaveChanges(); } return(individual); }
public ContractViewModel Update(Guid id, ContractViewModel contractViewModel) { using (var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { var contractId = _db.SignedContracts.Where(sc => sc.SignedContractId == id).Select(sc => sc.ContractId).FirstOrDefault(); if (contractViewModel != null) { // Contract var contractToUpdate = _db.Contracts.Where(con => con.ContractId == contractId).FirstOrDefault(); var updatedContract = Factories.ContractFactory.Create(contractViewModel); contractToUpdate.ContractCategory = updatedContract.ContractCategory; contractToUpdate.ContractExpiryDate = updatedContract.ContractExpiryDate; contractToUpdate.ContractType = updatedContract.ContractType; _db.Update(contractToUpdate); // Signed Contract var signedContractToUpdate = _db.SignedContracts.Where(sc => sc.SignedContractId == id).FirstOrDefault(); signedContractToUpdate.ContractIndividualIsActive = contractViewModel.IsActive; if (_db.Individuals.Select(ind => ind.BeneficiaryId).Contains(contractViewModel.ContractHolderId)) { signedContractToUpdate.IndividualId = contractViewModel.ContractHolderId; } else { scope.Complete(); return(null); } // Contract Beneficiaries _db.Contract_Beneficiary.RemoveRange( _db.Contract_Beneficiary.Where(cb => cb.SignedContractId == id)); if (AddContractBeneficiaries(contractViewModel, signedContractToUpdate)) { scope.Complete(); _db.SaveChanges(); return(contractViewModel); } } scope.Complete(); return(null); } }
public Contract Update(Guid id, Contract contract) { if (contract != null) { var contractToUpdate = contract; if (contract.ContractId != id) { contractToUpdate = Find(id); contractToUpdate.ContractCategory = contract.ContractCategory; contractToUpdate.ContractDeleted = contract.ContractDeleted; contractToUpdate.ContractExpiryDate = contract.ContractExpiryDate; contractToUpdate.ContractType = contract.ContractType; } _db.Update(contractToUpdate); _db.SaveChanges(); } return(contract); }
/// <summary> /// Update/Delete de Contract Holder /// </summary> /// <param name="id"></param> /// <param name="vm"></param> /// <returns></returns> public ContractHolderViewModel Update(Guid id, ContractHolderViewModel vm) { using (var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { var individual = _db.Individuals.Where(ind => ind.BeneficiaryId == id).FirstOrDefault(); if (individual == null) { return(null); } var beneficary_addresses = _db.Beneficiary_Address.Where(benAd => benAd.BeneficiaryId == individual.BeneficiaryId).ToList(); var individual_telephones = _db.Individual_Telephone.Where(indTel => indTel.BeneficiaryId == individual.BeneficiaryId).ToList(); //Soft Delete if (vm.isDeleted) { if (_db.SignedContracts.Where(sigCon => (sigCon.ContractIndividualIsActive == true) && (sigCon.IndividualId == id)).Any()) { return(null); } individual.IsDeleted = vm.isDeleted; _db.Update(individual); } //Update else { if (Factories.IndividualFactory.Create(vm) == null || Factories.AddressFactory.CreateList(vm.individualAddresses).Count() != vm.individualAddresses.Count() || Factories.TelephoneFactory.CreateList(vm.individualTelephones).Count() != vm.individualTelephones.Count()) { return(null); } else if (individual.IndividualCPF != vm.individualCPF) { return(null); } individual.IndividualBirthdate = vm.individualBirthdate; individual.IndividualCPF = vm.individualCPF; individual.IndividualEmail = vm.individualEmail; individual.IndividualName = vm.individualName; individual.IndividualRG = vm.individualRG; _db.Update(individual); if (beneficary_addresses.Count() > 0) { _db.RemoveRange(beneficary_addresses); } if (individual_telephones.Count() > 0) { _db.RemoveRange(individual_telephones); } _db.AddRange(vm.individualAddresses); _db.AddRange(vm.individualTelephones); foreach (var benAdd in vm.individualAddresses) { _db.Add(new BeneficiaryAddress { BeneficiaryAddressId = Guid.NewGuid(), BeneficiaryId = individual.BeneficiaryId, AddressId = benAdd.AddressId }); } foreach (var indTel in vm.individualTelephones) { _db.Add(new BeneficiaryTelephone { BeneficiaryTelephoneId = Guid.NewGuid(), BeneficiaryId = individual.BeneficiaryId, TelephoneId = indTel.TelephoneId }); } } _db.SaveChanges(); scope.Complete(); return(vm); } }