internal static void AddTxSummary(AccountTxSummary s)
{
var context = new AccountTxSummaryDataContext();
context.AccountTxSummaries.InsertOnSubmit(entity: s);
context.SubmitChanges();
}
internal static List <AccountTxSummary> GetTxSummary(string account, int days, long chatId)
{
var context = new AccountTxSummaryDataContext();
DateTime startDate = DateTime.Today.AddDays(value: -days);
return(context.AccountTxSummaries
.Where(predicate: e => e.MonitoredAccount == account)
.Where(predicate: e => e.OwnedByUser == chatId)
.Where(predicate: e => e.DateOfInput > startDate.Date)
.ToList());
}
internal static void DeleteTxSummaryForUser(string account, long chatId)
{
var context = new AccountTxSummaryDataContext();
var summaries = GetTxSummary(account: account, days: 1000, chatId: chatId);
foreach (var sum in summaries)
{
context.AccountTxSummaries.Attach(entity: sum);
context.AccountTxSummaries.DeleteOnSubmit(entity: sum);
}
context.SubmitChanges();
}
