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