public async Task <ReturnResponse <CustomerMeta> > UpdateAsync(CustomerMeta customerMeta, string customerCode)
{
var customerFilter = await GetByCustomerCodeAsync(customerCode);
if (customerFilter is null)
{
return(new ReturnResponse <CustomerMeta>
{
Successful = false,
Error = $"Could find customer with CustomerCode={customerCode}"
});
}
var query = "Update Customers SET IndustryId=@IndustryId, CustomerName=@CustomerName, Address=@Address, ContactInfo=@ContactInfo,Note=@Note WHERE CustomerCode=@CustomerCode";
var dynamicParameters = new DynamicParameters();
dynamicParameters.Add("@IndustryId", customerMeta.IndustryId, DbType.Int32);
dynamicParameters.Add("@CustomerCode", customerCode, DbType.String);
dynamicParameters.Add("@CustomerName", customerMeta.CustomerName, DbType.String);
dynamicParameters.Add("@Address", customerMeta.Address, DbType.String);
dynamicParameters.Add("@ContactInfo", customerMeta.ContactInfo, DbType.String);
dynamicParameters.Add("@Note", customerMeta.Note, DbType.String);
var result = await this.UpdateAsync(query, dynamicParameters);
var returnResponse = new ReturnResponse <CustomerMeta>();
if (result > 0)
{
returnResponse.Item = customerMeta;
returnResponse.Successful = true;
}
return(returnResponse);
}
public async Task <IActionResult> Update(string id, [FromBody] CustomerMeta customerMeta)
{
var result = await _customerService.Update(CurrentUser.TenantId, id, customerMeta);
//var result = await _CustomerService.Update("1", id, CustomerMeta);
if (result.Code < 0)
{
return(BadRequest(result));
}
return(Ok(result));
}
public async Task <IActionResult> Insert([FromBody] CustomerMeta customerMeta)
{
var result = await _customerService.Insert(CurrentUser.TenantId, customerMeta);
//var result = await _CustomerService.Insert("1", CustomerMeta);
if (result.Code < 0)
{
return(BadRequest(result));
}
return(Ok(result));
}
public async Task <IActionResult> UpdateCustomer([FromBody] CustomerMeta customerMeta, string customerCode)
{
var result = await _customerService.UpdateAsync(customerMeta, customerCode);
return(Ok(result));
}
public static void MyClassInitialize(TestContext testContext)
{
metaObj = new CustomerMeta();
metaColumn = metaObj.CompanyName;
}
public async Task <ReturnResponse <CustomerMeta> > UpdateAsync(CustomerMeta customerMeta, string customerCode)
{
return(await _customerRepository.UpdateAsync(customerMeta, customerCode));
}
public async Task <ActionResultResponse> Update(string tenantId, string id, CustomerMeta customerMeta)
{
var customer = await _customerRepository.GetInfo(id);
if (customer == null)
{
return(new ActionResultResponse(-1, _customerResourceService.GetString("Customer does not exists.")));
}
if (customer.ConcurrencyStamp != customerMeta.ConcurrencyStamp)
{
return(new ActionResultResponse(-2,
_customerResourceService.GetString("The Customer already updated by other people. You can not update this Customer.")));
}
if (customer.TenantId != tenantId)
{
return(new ActionResultResponse(-3,
_sharedResourceService.GetString(ErrorMessage.NotHavePermission)));
}
var oldProvinceId = customer.ProvinceId;
var oldDistrictId = customer.DistrictId;
var oldNationalId = customer.NationalId;
var oldReligionId = customer.ReligionId;
var oldEthnicId = customer.EthnicId;
if (oldProvinceId != customerMeta.ProvinceId)
{
if (customerMeta.ProvinceId.HasValue)
{
var provinceInfo = await GetProvinceInfo(customerMeta.ProvinceId.Value);
if (provinceInfo == null)
{
return(new ActionResultResponse(-4,
_sharedResourceService.GetString("Province does not exists. Please try again.")));
}
customer.ProvinceId = provinceInfo.Id;
customer.ProvinceName = provinceInfo.Name;
}
else
{
customer.ProvinceId = null;
customer.ProvinceName = null;
}
}
if (oldDistrictId != customerMeta.DistrictId)
{
if (customerMeta.DistrictId.HasValue)
{
var districtInfo = await GetDistrictInfo(customerMeta.DistrictId.Value);
if (districtInfo == null)
{
return(new ActionResultResponse(-5,
_sharedResourceService.GetString("District does not exists. Please try again.")));
}
customer.DistrictId = districtInfo.Id;
customer.DistrictName = districtInfo.Name;
}
else
{
customer.DistrictId = null;
customer.DistrictName = null;
}
}
if (oldNationalId != customerMeta.NationalId)
{
if (customerMeta.NationalId.HasValue)
{
var nationalInfo = await GetNationalInfo(customerMeta.NationalId.Value);
if (nationalInfo == null)
{
return(new ActionResultResponse(-6,
_sharedResourceService.GetString("Nation does not exists. Please try again.")));
}
customer.NationalId = nationalInfo.Id;
customer.NationalName = nationalInfo.Name;
}
else
{
customer.NationalId = null;
customer.NationalName = null;
}
}
if (oldReligionId != customerMeta.ReligionId)
{
if (customerMeta.ReligionId.HasValue)
{
var religionInfo = await GetReligionInfo(customerMeta.ReligionId.Value);
if (religionInfo == null)
{
return(new ActionResultResponse(-7,
_sharedResourceService.GetString("Religion does not exists. Please try again.")));
}
customer.ReligionId = religionInfo.Id;
customer.ReligionName = religionInfo.Name;
}
else
{
customer.ReligionId = null;
customer.ReligionName = null;
}
}
if (oldEthnicId != customerMeta.EthnicId)
{
if (customerMeta.EthnicId.HasValue)
{
var ethnicInfo = await GetEthnicInfo(customerMeta.EthnicId.Value);
if (ethnicInfo == null)
{
return(new ActionResultResponse(-8, _sharedResourceService.GetString("Ethnic does not exists.")));
}
customer.EthnicId = ethnicInfo.Id;
customer.EthnicName = ethnicInfo.Name;
}
else
{
customer.EthnicId = null;
customer.EthnicName = null;
}
}
customer.ConcurrencyStamp = Guid.NewGuid().ToString();
customer.FullName = customerMeta.FullName;
customer.UnsignName = customerMeta.FullName.StripVietnameseChars().ToUpper();
customer.Birthday = customerMeta.Birthday;
customer.Gender = customerMeta.Gender;
customer.CustomerResourceId = customerMeta.CustomerResourceId;
customer.IdCardNumber = customerMeta.IdCardNumber;
customer.JobId = customerMeta.JobId;
customer.Address = customerMeta.Address;
await _customerRepository.Update(customer);
await UpdateContacts();
await UpdateRelativesContacts();
return(new ActionResultResponse(1, _customerResourceService.GetString("Update Customer successful.")));
async Task UpdateContacts()
{
// Delete all existing contacts.
await _customerContactRepository.DeleteByCustomerId(customer.Id);
// Add new contacts.
await AddCustomerContacts(customer.Id, customerMeta.CustomerContacts);
}
async Task UpdateRelativesContacts()
{
// Delete all relatives contacts.
await _contactCustomerRepository.DeleteByCustomerId(customer.Id);
// Add new relatives contacts.
await AddRelativesContacts(customer.Id, customerMeta.CustomerRelativesContacts);
}
}
public async Task <ActionResultResponse> Insert(string tenantId, CustomerMeta customerMeta)
{
var customerId = Guid.NewGuid().ToString();
Domain.Models.Customer customer = new Domain.Models.Customer
{
Id = customerId,
TenantId = tenantId,
FullName = customerMeta.FullName,
UnsignName = customerMeta.FullName.Trim().StripVietnameseChars().ToUpper(),
Birthday = customerMeta.Birthday,
Gender = customerMeta.Gender,
CustomerResourceId = customerMeta.CustomerResourceId,
IdCardNumber = customerMeta.IdCardNumber,
JobId = customerMeta.JobId,
NationalId = customerMeta.NationalId,
NationalName = string.Empty,
EthnicId = customerMeta.EthnicId,
EthnicName = string.Empty,
ReligionId = customerMeta.ReligionId,
ReligionName = string.Empty,
ProvinceId = customerMeta.ProvinceId,
DistrictId = customerMeta.DistrictId,
DistrictName = string.Empty,
Address = customerMeta.Address
};
if (customerMeta.NationalId.HasValue)
{
var nationalInfo = await GetNationalInfo(customerMeta.NationalId.Value);
if (nationalInfo == null)
{
return(new ActionResultResponse(-1,
_sharedResourceService.GetString("National does not exists.")));
}
customer.NationalName = nationalInfo.Name;
}
if (customerMeta.ProvinceId.HasValue)
{
var provinceInfo = await GetProvinceInfo(customerMeta.ProvinceId.Value);
if (provinceInfo == null)
{
return(new ActionResultResponse(-2,
_sharedResourceService.GetString("Province does not exists. Please try again.")));
}
customer.ProvinceName = provinceInfo.Name;
}
if (customerMeta.DistrictId.HasValue)
{
var districtInfo = await GetDistrictInfo(customerMeta.DistrictId.Value);
if (districtInfo == null)
{
return(new ActionResultResponse(-3,
_sharedResourceService.GetString("Province does not exists. Please try again.")));
}
customer.DistrictName = districtInfo.Name;
}
if (customerMeta.EthnicId.HasValue)
{
var ethnicInfo = await GetEthnicInfo(customerMeta.EthnicId.Value);
if (ethnicInfo == null)
{
return(new ActionResultResponse(-4,
_sharedResourceService.GetString("District doest not exists. Please try again.")));
}
customer.EthnicName = ethnicInfo.Name;
}
if (customerMeta.ReligionId.HasValue)
{
var religionInfo = await GetReligionInfo(customerMeta.ReligionId.Value);
if (religionInfo == null)
{
return(new ActionResultResponse(-5,
_sharedResourceService.GetString("Religion doest not exists. Please try again.")));
}
customer.ReligionName = religionInfo.Name;
}
var resultInsert = await _customerRepository.Insert(customer);
if (resultInsert <= 0)
{
return(new ActionResultResponse(resultInsert,
_sharedResourceService.GetString("Something went wrong. Please contact with administrator.")));
}
var resutlAddContacts = await AddCustomerContacts(customerId, customerMeta.CustomerContacts);
if (resutlAddContacts.Code < 0)
{
return(resutlAddContacts);
}
var resultAddRelativesContacts = await AddRelativesContacts(customerId, customerMeta.CustomerRelativesContacts);
if (resultAddRelativesContacts.Code < 0)
{
return(resultAddRelativesContacts);
}
return(new ActionResultResponse(resultInsert, _customerResourceService.GetString("Add new Customer successful.")));
}
