public Task <bool> Update(SubcontractProfile.WebApi.Services.Model.SubcontractProfileCompany subcontractProfileCompany)
{
_logger.LogInformation($"Start CompanyController::Update", subcontractProfileCompany);
if (subcontractProfileCompany == null)
{
_logger.LogWarning($"Start CompanyController::Update", subcontractProfileCompany);
}
var result = _service.Update(subcontractProfileCompany);
if (result == null)
{
_logger.LogWarning($"CompanyController::", "Update NOT FOUND", subcontractProfileCompany);
}
return(result);
}
/// <summary>
/// Insert
/// </summary>
public async Task <bool> Insert(SubcontractProfile.WebApi.Services.Model.SubcontractProfileCompany subcontractProfileCompany)
{
var p = new DynamicParameters();
p.Add("@company_id", subcontractProfileCompany.CompanyId);
p.Add("@company_code", subcontractProfileCompany.CompanyCode);
p.Add("@company_name", subcontractProfileCompany.CompanyName);
p.Add("@company_name_th", subcontractProfileCompany.CompanyNameTh);
p.Add("@company_name_en", subcontractProfileCompany.CompanyNameEn);
p.Add("@company_alias", subcontractProfileCompany.CompanyAlias);
p.Add("@distribution_channel", subcontractProfileCompany.DistributionChannel);
p.Add("@channel_sale_group", subcontractProfileCompany.ChannelSaleGroup);
p.Add("@vendor_code", subcontractProfileCompany.VendorCode);
p.Add("@customer_code", subcontractProfileCompany.CustomerCode);
p.Add("@area_id", subcontractProfileCompany.AreaId);
p.Add("@tax_id", subcontractProfileCompany.TaxId);
p.Add("@wt_name", subcontractProfileCompany.WtName);
p.Add("@vat_type", subcontractProfileCompany.VatType);
p.Add("@company_certified_file", subcontractProfileCompany.CompanyCertifiedFile);
p.Add("@commercial_registration_file", subcontractProfileCompany.CommercialRegistrationFile);
p.Add("@vat_registration_certificate_file", subcontractProfileCompany.VatRegistrationCertificateFile);
p.Add("@contract_agreement_file", subcontractProfileCompany.ContractAgreementFile);
p.Add("@deposit_authorization_level", subcontractProfileCompany.DepositAuthorizationLevel);
p.Add("@deposit_payment_type", subcontractProfileCompany.DepositPaymentType);
p.Add("@contract_start_date", subcontractProfileCompany.ContractStartDate);
p.Add("@contract_end_date", subcontractProfileCompany.ContractEndDate);
p.Add("@over_draft_deposit", subcontractProfileCompany.OverDraftDeposit);
p.Add("@balance_deposit", subcontractProfileCompany.BalanceDeposit);
p.Add("@company_status", subcontractProfileCompany.CompanyStatus);
p.Add("@company_address", subcontractProfileCompany.CompanyAddress);
p.Add("@vat_address", subcontractProfileCompany.VatAddress);
p.Add("@create_by", subcontractProfileCompany.CreateBy);
p.Add("@create_date", subcontractProfileCompany.CreateDate);
p.Add("@update_by", subcontractProfileCompany.UpdateBy);
p.Add("@update_date", subcontractProfileCompany.UpdateDate);
p.Add("@company_email", subcontractProfileCompany.CompanyEmail);
p.Add("@contract_name", subcontractProfileCompany.ContractName);
p.Add("@contract_phone", subcontractProfileCompany.ContractPhone);
p.Add("@contract_email", subcontractProfileCompany.ContractEmail);
p.Add("@bank_code", subcontractProfileCompany.BankCode);
p.Add("@bank_name", subcontractProfileCompany.BankName);
p.Add("@account_number", subcontractProfileCompany.AccountNumber);
p.Add("@account_name", subcontractProfileCompany.AccountName);
p.Add("@attach_file", subcontractProfileCompany.AttachFile);
p.Add("@branch_code", subcontractProfileCompany.BranchCode);
p.Add("@branch_name", subcontractProfileCompany.BranchName);
p.Add("@dept_of_install_name", subcontractProfileCompany.DeptOfInstallName);
p.Add("@dept_of_mainten_name", subcontractProfileCompany.DeptOfMaintenName);
p.Add("@dept_of_account_name", subcontractProfileCompany.DeptOfAccountName);
p.Add("@dept_of_install_phone", subcontractProfileCompany.DeptOfInstallPhone);
p.Add("@dept_of_mainten_phone", subcontractProfileCompany.DeptOfMaintenPhone);
p.Add("@dept_of_account_phone", subcontractProfileCompany.DeptOfAccountPhone);
p.Add("@dept_of_install_email", subcontractProfileCompany.DeptOfInstallEmail);
p.Add("@dept_of_mainten_email", subcontractProfileCompany.DeptOfMaintenEmail);
p.Add("@dept_of_account_email", subcontractProfileCompany.DeptOfAccountEmail);
p.Add("@location_code", subcontractProfileCompany.LocationCode);
p.Add("@location_name_th", subcontractProfileCompany.LocationNameTh);
p.Add("@location_name_en", subcontractProfileCompany.LocationNameEn);
p.Add("@bank_account_type_id", subcontractProfileCompany.BankAccountTypeId);
p.Add("@subcontract_profile_type", subcontractProfileCompany.SubcontractProfileType);
p.Add("@company_title_th_id", subcontractProfileCompany.CompanyTitleThId);
p.Add("@company_title_en_id", subcontractProfileCompany.CompanyTitleEnId);
p.Add("@status", subcontractProfileCompany.Status);
p.Add("@activate_date", subcontractProfileCompany.ActivateDate);
var ok = await _dbContext.Connection.ExecuteAsync
("uspSubcontractProfileCompany_Insert", p, commandType : CommandType.StoredProcedure, transaction : _dbContext.Transaction);
return(true);
}
