public async Task <int> UpdateSummaryStatusAsync(int loginUserId, ReminderSummary[] ReminderSummary, CancellationToken token = default(CancellationToken)) { using (var scope = transactionScopeBuilder.Create()) { var count = 0; foreach (var r in ReminderSummary) { var result = await updateReminderQueryProcessor.UpdateSummaryStatusAsync(r, token); var history = new ReminderSummaryHistory() { ReminderSummaryId = r.Id, Memo = result.Memo, InputType = (int)ReminderSummaryHistory.ReminderSummaryHistoryInputType.StatusChange, ReminderAmount = r.ReminderAmount, CreateBy = loginUserId, }; var historyResult = await addReminderHistoryQueryProcessor.AddSummaryAsync(history, token); if (historyResult == null) { return(-1); } else { count++; } } scope.Complete(); return(count); } }
public Task <ReminderSummaryHistory> UpdateReminderSummaryHistoryAsync(ReminderSummaryHistory reminderSummaryHistory, CancellationToken token = default(CancellationToken)) { var query = @" UPDATE ReminderSummaryHistory SET Memo = @Memo OUTPUT inserted.* WHERE Id = @Id "; return(dbHelper.ExecuteAsync <ReminderSummaryHistory>(query, reminderSummaryHistory, token)); }
public void InitializeUserComponent(int precision, ReminderSummaryHistory reminderSummaryHistory) { FormWidth = 490; FormHeight = 400 - (reminderSummaryHistory != null ? 0 : pnlReminder.Height) - pnlStatus.Height; pnlStatus.Visible = false; ReminderSummaryHistory = reminderSummaryHistory; nmbReminderAmount.Fields.DecimalPart.MaxDigits = precision; nmbReminderAmount.Fields.DecimalPart.MinDigits = precision; SetFunctionKeys(); }
public async Task <CountResult> DeleteSummaryHistoryAsync(string SessionKey, ReminderSummaryHistory reminderSummaryHistory) { return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token => { var result = await reminderHistoryProcessor.DeleteSummaryHistoryAsync(reminderSummaryHistory, token); return new CountResult { ProcessResult = new ProcessResult { Result = true }, Count = result, }; }, logger)); }
public async Task <ReminderSummaryHistory> UpdateReminderSummaryHistoryAsync(ReminderSummaryHistory reminderSummaryHistory, CancellationToken token = default(CancellationToken)) { using (var scope = transactionScopeBuilder.Create()) { var result = await updateReminderHistoryQueryProcessor.UpdateReminderSummaryHistoryAsync(reminderSummaryHistory, token); if (reminderSummaryHistory.IsUpdateSummaryMemo) { var rs = new ReminderSummary() { Id = reminderSummaryHistory.ReminderSummaryId, Memo = reminderSummaryHistory.Memo, }; var reminderSummaryResult = await updateReminderQueryProcessor.UpdateSummaryStatusAsync(rs, token); } scope.Complete(); return(result); } }
public async Task <int> UpdateReminderSummaryOutputedAsync(int loginUserId, ReminderOutputed[] reminderOutputed, ReminderSummary[] reminderSummary, CancellationToken token = default(CancellationToken)) { using (var scope = transactionScopeBuilder.Create()) { var count = await AddReminderOutputedAsync(reminderOutputed, token); if (count <= 0) { return(count); } foreach (var rh in reminderSummary) { var history = new ReminderSummaryHistory() { ReminderSummaryId = rh.Id, Memo = "", InputType = (int)ReminderSummaryHistory.ReminderSummaryHistoryInputType.Output, ReminderAmount = rh.ReminderAmount, CreateBy = loginUserId, }; var result = await addReminderHistoryQueryProcessor.AddSummaryAsync(history, token); if (result == null) { return(-1); } else { count++; } } scope.Complete(); return(count); } }
public async Task <int> DeleteSummaryHistoryAsync(ReminderSummaryHistory reminderSummaryHistory, CancellationToken token = default(CancellationToken)) { using (var scope = transactionScopeBuilder.Create()) { var result = await deleteReminderSummaryHistoryQueryProcessor.DeleteAsync(reminderSummaryHistory.Id, token); if (reminderSummaryHistory.IsUpdateSummaryMemo) { var rsh = (await reminderHistoryQueryProcessor.GetSummaryItemsByReminderSummaryIdAsync(reminderSummaryHistory.ReminderSummaryId, token)).FirstOrDefault(); var rs = new ReminderSummary() { Id = reminderSummaryHistory.ReminderSummaryId, Memo = rsh?.Memo ?? string.Empty, }; var reminderSummaryResult = await updateReminderQueryProcessor.UpdateSummaryStatusAsync(rs, token); } scope.Complete(); return(result); } }
public Task <ReminderSummaryHistory> AddSummaryAsync(ReminderSummaryHistory ReminderSummaryHistory, CancellationToken token = default(CancellationToken)) { var query = @" INSERT INTO ReminderSummaryHistory ( ReminderSummaryId , Memo , InputType , ReminderAmount , CreateBy , CreateAt ) OUTPUT inserted.* VALUES ( @ReminderSummaryId , @Memo , @InputType , @ReminderAmount , @CreateBy , GETDATE() ) "; return(dbHelper.ExecuteAsync <ReminderSummaryHistory>(query, ReminderSummaryHistory, token)); }