private void Save()
{
var paymentAgencyInsert = new PaymentAgency();
paymentAgencyInsert.Id = PaymentAgencyId;
paymentAgencyInsert.CompanyId = CompanyId;
paymentAgencyInsert.Code = txtPaymentAgencyCode.Text;
paymentAgencyInsert.ConsigneeCode = txtConsigneeCode.Text;
paymentAgencyInsert.Name = txtPaymentAgencyName.Text.Trim();
paymentAgencyInsert.Kana = txtPaymentAgencyKana.Text;
paymentAgencyInsert.BankCode = txtBankCode.Text;
paymentAgencyInsert.BankName = txtBankName.Text.Trim();
paymentAgencyInsert.BranchCode = txtBranchCode.Text;
paymentAgencyInsert.BranchName = txtBranchName.Text.Trim();
paymentAgencyInsert.AccountTypeId = Convert.ToInt32(cmbAccountType.SelectedItem.SubItems[1].Value);
paymentAgencyInsert.AccountNumber = txtAccountNumber.Text;
paymentAgencyInsert.ShareTransferFee = cmbShareTransferFee.SelectedIndex;
paymentAgencyInsert.UseFeeLearning = cbxUseFeeLearning.Checked ? 1 : 0;
paymentAgencyInsert.UseFeeTolerance = cbxUseFeeTolerance.Checked ? 1 : 0;
paymentAgencyInsert.UseKanaLearning = cbxUseKanaLearning.Checked ? 1 : 0;
paymentAgencyInsert.ConsiderUncollected = cbxConsiderUncollected.Checked ? 1 : 0;
paymentAgencyInsert.DueDateOffset = Convert.ToInt32(nmbDueDateOffset.Value);
paymentAgencyInsert.FileFormatId = Convert.ToInt32(cmbFileFormat.SelectedItem.SubItems[1].Value);
paymentAgencyInsert.ContractCode = txtContractCode.Text.Trim();
if (cbxConsiderUncollected.Checked)
{
paymentAgencyInsert.CollectCategoryId = Convert.ToInt32(cmbConsiderUncollected.SelectedItem.SubItems[1].Value);
}
paymentAgencyInsert.OutputFileName = txtOutputFileName.Text;
paymentAgencyInsert.AppendDate = cbxAppendDate.Checked ? 1 : 0;
paymentAgencyInsert.CreateBy = Login.UserId;
paymentAgencyInsert.UpdateBy = Login.UserId;
paymentAgencyInsert.UpdateAt = UpdateAt;
PaymentAgencyResult result = null;
var task = ServiceProxyFactory.LifeTime(async factory =>
{
var service = factory.Create <PaymentAgencyMasterClient>();
result = await service.SaveAsync(SessionKey, paymentAgencyInsert);
});
ProgressDialog.Start(ParentForm, task, false, SessionKey);
if (result.PaymentAgency != null)
{
Clear();
DispStatusMessage(MsgInfSaveSuccess);
if (PaymentAgencyCode != null)
{
ParentForm.DialogResult = DialogResult.OK;
}
}
else
{
ShowWarningDialog(MsgErrSaveError);
}
}
public async Task <PaymentAgencyResult> SaveAsync(string SessionKey, PaymentAgency PaymentAgency)
{
return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token =>
{
var result = await paymentAgencyProcessor.SaveAsync(PaymentAgency, token);
return new PaymentAgencyResult
{
ProcessResult = new ProcessResult {
Result = true
},
PaymentAgency = result,
};
}, logger));
}
private async Task <PaymentAgency> GetPaymentAgencyDataByCode()
{
PaymentAgency paymentAgencyByCode = null;
await ServiceProxyFactory.LifeTime(async factory =>
{
var paymentAgencyCode = new string[] { txtPaymentAgencyCode.Text };
var service = factory.Create <PaymentAgencyMasterClient>();
var result = await service.GetByCodeAsync(SessionKey, CompanyId, paymentAgencyCode);
if (result.ProcessResult.Result)
{
paymentAgencyByCode = result.PaymentAgencies.FirstOrDefault();
}
});
return(paymentAgencyByCode);
}
public async Task <PaymentAgency> SaveAsync(PaymentAgency paymentAgency, CancellationToken token = default(CancellationToken)) => await addPaymentAgencyQueryProcessor.SaveAsync(paymentAgency, token);
private void FillData(PaymentAgency paymentAgency)
{
PaymentAgencyId = paymentAgency.Id;
UpdateAt = paymentAgency.UpdateAt;
txtPaymentAgencyCode.Text = paymentAgency.Code;
txtConsigneeCode.Text = paymentAgency.ConsigneeCode;
txtPaymentAgencyName.Text = paymentAgency.Name;
txtPaymentAgencyKana.Text = paymentAgency.Kana;
txtBankCode.Text = paymentAgency.BankCode;
txtBankName.Text = paymentAgency.BankName;
txtBranchCode.Text = paymentAgency.BranchCode;
txtBranchName.Text = paymentAgency.BranchName;
if (paymentAgency.AccountTypeId == 1)
{
cmbAccountType.SelectedIndex = 0;
}
else if (paymentAgency.AccountTypeId == 2)
{
cmbAccountType.SelectedIndex = 1;
}
else if (paymentAgency.AccountTypeId == 3)
{
cmbAccountType.SelectedIndex = 2;
}
else if (paymentAgency.AccountTypeId == 9)
{
cmbAccountType.SelectedIndex = 3;
}
else
{
cmbAccountType.SelectedIndex = -1;
}
txtAccountNumber.Text = paymentAgency.AccountNumber;
cmbShareTransferFee.SelectedIndex = paymentAgency.ShareTransferFee;
cbxUseFeeTolerance.Checked = (paymentAgency.UseFeeTolerance == 1);
cbxUseFeeLearning.Checked = (paymentAgency.UseFeeLearning == 1);
cbxUseKanaLearning.Checked = (paymentAgency.UseKanaLearning == 1);
cbxConsiderUncollected.Checked = (paymentAgency.ConsiderUncollected == 1);
txtOutputFileName.Text = paymentAgency.OutputFileName;
cbxAppendDate.Checked = (paymentAgency.AppendDate == 1);
nmbDueDateOffset.Text = paymentAgency.DueDateOffset.ToString();
var selectId = PaymentFileFormatList.Where(x => x.Id == (paymentAgency.FileFormatId));
cmbFileFormat.SelectedValue = selectId.Select(s => s.Name).First();
txtContractCode.Text = paymentAgency.ContractCode;
if (paymentAgency.ConsiderUncollected == 1)
{
var cateogrySelectId = CollectCategoryList.Where(x => x.Id == (paymentAgency.CollectCategoryId));
if (cateogrySelectId != null)
{
cmbConsiderUncollected.SelectedValue = cateogrySelectId.Select(s => s.Name).First();
}
}
if (PaymentAgencyCode == null)
{
BaseContext.SetFunction03Enabled(true);
}
if (cmbShareTransferFee.Text == "自社")
{
BaseContext.SetFunction08Enabled(true);
}
}
public async Task <ActionResult <int> > Delete(PaymentAgency agency, CancellationToken token) => await paymentAgencyProcessor.DeleteAsync(agency.Id, token);
public async Task <ActionResult <PaymentAgency> > Save(PaymentAgency agency, CancellationToken token) => await paymentAgencyProcessor.SaveAsync(agency, token);
public Task <PaymentAgency> SaveAsync(PaymentAgency paymentAgency, CancellationToken token = default(CancellationToken))
{
var query = @"
MERGE INTO PaymentAgency AS Pa
USING (
SELECT
@CompanyId AS CompanyId,
@Code as Code
) AS Target
ON (
Pa.CompanyId = @CompanyId
AND Pa.Code = @Code
)
WHEN MATCHED THEN
UPDATE SET
ConsigneeCode = @ConsigneeCode
, Name = @Name
, Kana = @Kana
, BankCode = @BankCode
, BankName = @BankName
, BranchCode = @BranchCode
, BranchName = @BranchName
, AccountTypeId = @AccountTypeId
, AccountNumber = @AccountNumber
, ShareTransferFee = @ShareTransferFee
, UseFeeTolerance = @UseFeeTolerance
, UseFeeLearning = @UseFeeLearning
, UseKanaLearning = @UseKanaLearning
, DueDateOffset = @DueDateOffset
, FileFormatId = @FileFormatId
, ConsiderUncollected = @ConsiderUncollected
, CollectCategoryId = @CollectCategoryId
, UpdateBy = @UpdateBy
, UpdateAt = GETDATE()
, OutputFileName = @OutputFileName
, AppendDate = @AppendDate
, ContractCode = @ContractCode
WHEN NOT MATCHED THEN
INSERT (CompanyId
, Code
, ConsigneeCode
, Name
, Kana
, BankCode
, BankName
, BranchCode
, BranchName
, AccountTypeId
, AccountNumber
, ShareTransferFee
, UseFeeTolerance
, UseFeeLearning
, UseKanaLearning
, DueDateOffset
, FileFormatId
, ConsiderUncollected
, CollectCategoryId
, CreateBy
, CreateAt
, UpdateBy
, UpdateAt
, OutputFileName
, AppendDate
, ContractCode
)
VALUES (@CompanyId
, @Code
, @ConsigneeCode
, @Name
, @Kana
, @BankCode
, @BankName
, @BranchCode
, @BranchName
, @AccountTypeId
, @AccountNumber
, @ShareTransferFee
, @UseFeeTolerance
, @UseFeeLearning
, @UseKanaLearning
, @DueDateOffset
, @FileFormatId
, @ConsiderUncollected
, @CollectCategoryId
, @CreateBy
, GETDATE()
, @UpdateBy
, GETDATE()
, @OutputFileName
, @AppendDate
, @ContractCode
)
OUTPUT inserted.*;";
return(dbHelper.ExecuteAsync <PaymentAgency>(query, paymentAgency, token));
}
