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