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