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