public void Cleanup() { using (var context = new ExpiredReminderDataContext()) { context.Database.ExecuteSqlCommand("Delete from ExpiredPolicies"); } }
public void CaseReminderCollectionTest() { using (var context = new ExpiredReminderDataContext()) { context.ExpiredPolicies.Add(new ExpiredPolicy { MinDay = 90, MaxDay = 180, Name = "First remind days." }); context.ExpiredPolicies.Add( new ExpiredPolicy { MinDay = 180, MaxDay = 270, Name = "Second remind days." }); context.ExpiredPolicies.Add( new ExpiredPolicy { MinDay = 270, MaxDay = 360, Name = "Second remind days." }); context.ExpiredPolicies.Add( new ExpiredPolicy { MinDay = 360, MaxDay = 999, Name = "Second remind days." }); context.SaveChanges(); } var collection = new CaseReminderCollection(_cases, DateTime.Now); collection.Calculate(); AssertReminderCollection(collection, 90, 2); AssertReminderCollection(collection, 180, 2); AssertReminderCollection(collection, 270, 3); AssertReminderCollection(collection, 360, 2); }
public static ObservableCollection <DataItem> GetDataItems() { var items = new ObservableCollection <DataItem>(); //todo customize the icons items.Add(new DataItem( "案件录入", "录入案件信息,以便统计案件的金额和提醒案件过期时间", "Assets/LightGray.png", "录入案件信息,以便统计案件的金额和提醒案件过期时间", new CaseEditView(), true, "信息录入")); items.Add(new DataItem( "律师管理", "律师信息录入", "Assets/DarkGray.png", "录入律师信息,以便统计律师分成等", new LawyerEditView())); items.Add(new DataItem( "过期策略", "设置过期提醒策略", "Assets/MediumGray.png", "设置过期提醒策略,以此来进行提醒。(例如: 过期时间为大于90天, 小于180 天, 名称为: 三个月提醒)", new ExpiredPolicyEditView())); int i = 0; using (var context = new ExpiredReminderDataContext()) { CaseReminderCollection collection = new CaseReminderCollection(context.Cases.ToList(), DateTime.Now); collection.Calculate(); foreach (var expiredCase in collection.ExpiredCaseses) { var item = new DataItem( expiredCase.Policy.Name, $"过期时间{expiredCase.Policy.MinDay}, 案件数量{expiredCase.Cases.Count}", "", $"时间区间 大于等于{expiredCase.Policy.MinDay} 小于 {expiredCase.Policy.MaxDay}", new ExpiredCaseView(expiredCase.Cases), expiredCase.Policy.Color.ToString()); if (i == 0) { item.IsFlowBreak = true; item.GroupHeader = "过期案件"; } items.Add(item); i++; } } return(items); }