public async Task CreateOrUpdateAsync(PartnerContactModel partnerContact) { using (var context = _contextFactory.CreateDataContext()) { var existentPartnerContact = await context.PartnerContacts .FirstOrDefaultAsync(c => c.LocationId == partnerContact.LocationId); if (existentPartnerContact != null) { existentPartnerContact = _encryptionService.Decrypt(existentPartnerContact); existentPartnerContact.FirstName = partnerContact.FirstName; existentPartnerContact.LastName = partnerContact.LastName; existentPartnerContact.PhoneNumber = partnerContact.PhoneNumber; existentPartnerContact.Email = partnerContact.Email; existentPartnerContact = _encryptionService.Encrypt(existentPartnerContact); context.PartnerContacts.Update(existentPartnerContact); } else { var entity = PartnerContactEntity.Create(partnerContact); entity = _encryptionService.Encrypt(entity); context.PartnerContacts.Add(entity); } await context.SaveChangesAsync(); } }
public async Task <PartnerContactEntity> UpdateAsync(PartnerContactEntity request) { using (var cnx = _context.conexao()) { string _query = $@"Update partnersContact set contactName = '{request.ContactName}', description = '{request.Description}', contactType = '{request.ContactType}', phoneNumber1 = {request.PhoneNumber1}, phoneNumber2 = '{request.PhoneNumber2}' where id = '{request.Id}'"; var result = await cnx.QueryAsync <PartnerEntity>(_query); return(new PartnerContactEntity(request.Id, request.PartnerId, request.ContactName, request.Description, request.ContactType, request.PhoneNumber1, request.PhoneNumber2, request.Information)); } }
public async Task <DefaultDataResponse> UpdateAsync(PartnerContactPutRequest request) { //var validator = new PartnerPutRequestValidator(); //var validationResult = validator.Validate(request); //var existPartner = await partnerRepository.GetByDocument(request.Document); //if (existPartner != null && existPartner.PartnerId != request.PartnerId) // return ErrorResponse<MiniErpErrors>(MiniErpErrors.Partner_Put_400_Document_Cannot_Be_Duplicate.ToString()); //if (!validationResult.IsValid) // return ErrorResponse<MiniErpErrors>(validationResult.Errors.ToErrorCodeList()); var partner = new PartnerContactEntity(request); var result = await partnerContactRepository.CreateAsync(partner); return(SuccessResponse(result)); }
public async Task <PartnerContactEntity> CreateAsync(PartnerContactEntity request) { using (var cnx = _context.conexao()) { string _query = $@"insert into partnersContact(id, partnerId, contactName, description, contactType, phoneNumber1, phoneNumber2, information) values (@_Id, @_PartnerId, @_ContactName, @_Description, @_ContactType, @_PhoneNumber1, @_PhoneNumber2, @_Information)"; var result = await cnx.QueryAsync <PartnerContactEntity>(_query, new { _Id = request.Id, _PartnerId = request.PartnerId, _ContactName = request.ContactName, _Description = request.Description, _ContactType = request.ContactType, _PhoneNumber1 = request.PhoneNumber1, _PhoneNumber2 = request.PhoneNumber2, _Information = request.Information }); return(new PartnerContactEntity(request.Id, request.PartnerId, request.ContactName, request.Description, request.ContactType, request.PhoneNumber1, request.PhoneNumber2, request.Information)); } }
public async Task <PartnerContactErrorCodes> CreateIfNotExistAsync(PartnerContactModel partnerContact) { using (var context = _contextFactory.CreateDataContext()) { var existentPartnerContact = await context.PartnerContacts .FirstOrDefaultAsync(c => c.LocationId == partnerContact.LocationId); if (existentPartnerContact != null) { return(PartnerContactErrorCodes.PartnerContactAlreadyExists); } var entity = PartnerContactEntity.Create(partnerContact); entity = _encryptionService.Encrypt(entity); context.PartnerContacts.Add(entity); await context.SaveChangesAsync(); return(PartnerContactErrorCodes.None); } }