private void txtKana_Validated(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtKana.Text))
{
ClearStatusMessage();
return;
}
var kana = EbDataHelper.ConvertToHankakuKatakana(txtKana.Text);
kana = EbDataHelper.RemoveProhibitCharacter(kana);
kana = EbDataHelper.ConvertProhibitCharacter(kana);
txtKana.Text = kana;
var target = JuridicalPersonalityList.FirstOrDefault(k => k.Kana == kana);
if (target != null)
{
SetJuridility(target);
ClearStatusMessage();
}
else
{
target = new JuridicalPersonality();
target.Kana = kana;
SetJuridility(target);
}
}
public async Task <JuridicalPersonality> SaveAsync(JuridicalPersonality personality, CancellationToken token = default(CancellationToken))
{
// confirm string.Empty validation was required.
//if (string.IsNullOrWhiteSpace(personality.Kana))
// throw new ArgumentNullException(nameof(personality.Kana), "カナが未入力です");
return(await addQueryProcessor.SaveAsync(personality, token));
}
public async Task <JuridicalPersonalityResult> SaveAsync(string SessionKey, JuridicalPersonality JuridicalPersonality)
{
return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token =>
{
var result = await juridicalPersonalityProcessor.SaveAsync(JuridicalPersonality, token);
return new JuridicalPersonalityResult
{
ProcessResult = new ProcessResult {
Result = true
},
JuridicalPersonality = result,
};
}, logger));
}
public Task <IEnumerable <JuridicalPersonality> > GetAsync(JuridicalPersonality personality, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT jp.*
FROM JuridicalPersonality jp
WHERE jp.CompanyId = @CompanyId";
if (!string.IsNullOrWhiteSpace(personality.Kana))
{
query += @"
AND jp.Kana = @Kana";
}
query += @"
ORDER BY jp.CompanyId ASC
, jp.Kana ASC";
return(dbHelper.GetItemsAsync <JuridicalPersonality>(query, personality, token));
}
private async Task <bool> SaveKana()
{
List <JuridicalPersonality> newList = null;
var succeeded = true;
await ServiceProxyFactory.LifeTime(async factory =>
{
var service = factory.Create <JuridicalPersonalityMasterClient>();
var juridical = new JuridicalPersonality();
juridical.CompanyId = CompanyId;
juridical.UpdateBy = Login.UserId;
juridical.CreateBy = Login.UserId;
juridical.Kana = txtKana.Text.Trim();
JuridicalPersonalityResult result = await service.SaveAsync(SessionKey, juridical);
if (!result.ProcessResult.Result)
{
succeeded = false;
return;
}
else if (result.JuridicalPersonality != null)
{
newList = await LoadJuridicalPersonalityAsync();
txtKana.Clear();
}
else
{
newList = await LoadJuridicalPersonalityAsync();
succeeded = false;
}
});
if (newList != null)
{
grdRemoveJuridicalPersonality.Rows.Clear();
JuridicalPersonalityList.AddRange(newList);
grdRemoveJuridicalPersonality.DataSource = new BindingSource(JuridicalPersonalityList, null);
}
return(succeeded);
}
public Task <JuridicalPersonality> SaveAsync(JuridicalPersonality personality, CancellationToken token = default(CancellationToken))
{
var query = @"
MERGE INTO JuridicalPersonality AS target
USING (
SELECT @CompanyId AS CompanyId
, @Kana AS Kana
) AS source ON (
target.CompanyId = source.CompanyId
AND target.Kana = source.Kana
)
WHEN MATCHED THEN
UPDATE SET
UpdateBy = @UpdateBy
,UpdateAt = GETDATE()
WHEN NOT MATCHED THEN
INSERT ( CompanyId, Kana, CreateBy, CreateAt, UpdateBy, UpdateAt)
VALUES (@CompanyId, @Kana, @CreateBy, GETDATE(), @UpdateBy, GETDATE())
OUTPUT inserted.*;";
return(dbHelper.ExecuteAsync <JuridicalPersonality>(query, personality, token));
}
public async Task <IEnumerable <JuridicalPersonality> > GetItems(JuridicalPersonality personality, CancellationToken token) => (await juridicalPersonalityProcessor.GetAsync(personality, token)).ToArray();
public async Task <JuridicalPersonality> Save(JuridicalPersonality personality, CancellationToken token) => await juridicalPersonalityProcessor.SaveAsync(personality, token);
public async Task <int> Delete(JuridicalPersonality personality, CancellationToken token) => await juridicalPersonalityProcessor.DeleteAsync(personality.CompanyId, personality.Kana, token);
public async Task <IEnumerable <JuridicalPersonality> > GetAsync(JuridicalPersonality personality, CancellationToken token = default(CancellationToken)) => await queryProcessor.GetAsync(personality, token);
private void SetJuridility(JuridicalPersonality judirical = null)
{
CurrentEntry = judirical ?? new JuridicalPersonality();
txtKana.Text = CurrentEntry.Kana;
}
