public void GetAllUserTypesTest() { Mock <DbSet <SQLDatabase.EF.UserType> > moq_UserTypes = new Mock <DbSet <UserType> >(); moq_UserTypes.SetupData(new List <SQLDatabase.EF.UserType>()); Array.ForEach(db.UserTypes.ToArray(), a => { var nUser = new SQLDatabase.EF.UserType(); nUser.TypeId = a.TypeId; nUser.TypeName = a.TypeName; moq_UserTypes.Object.Add(nUser); }); nuContext.Setup(c => c.UserTypes).Returns(moq_UserTypes.Object); NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(nuContext.Object); // verify only three types exist Assert.AreEqual(3, nh.GetAllUserTypes().Count); // verify type ids Assert.AreEqual(1, nh.GetAllUserTypes().Where(w => w.TypeName == "Clinician").Select(s => s.TypeId).Single()); Assert.AreEqual(2, nh.GetAllUserTypes().Where(w => w.TypeName == "Patient").Select(s => s.TypeId).Single()); Assert.AreEqual(3, nh.GetAllUserTypes().Where(w => w.TypeName == "Admin").Select(s => s.TypeId).Single()); // verify types names Assert.IsTrue(nh.GetAllUserTypes().Any(a => a.TypeName == "Clinician")); Assert.IsTrue(nh.GetAllUserTypes().Any(a => a.TypeName == "Patient")); Assert.IsTrue(nh.GetAllUserTypes().Any(a => a.TypeName == "Admin")); }
public void GetInstitutionIdTest() { Mock <DbSet <SQLDatabase.EF.Institution> > moq_Inst = new Mock <DbSet <Institution> >(); moq_Inst.SetupData(new List <SQLDatabase.EF.Institution>()); var nInst = new Institution { City = "Portland", ContactEmail = "*****@*****.**", ContactFirstname = "John", ContactLastname = "Doe", Country = "US", LegacySiteId = 12345, Name = "Some Institution", State = "Oregon", Street = "123 Street", Zip = "12345", InstitutionId = Guid.NewGuid(), UserId = Guid.NewGuid(), LastUpdatedByUser = Guid.NewGuid() }; moq_Inst.Object.Add(nInst); nuContext.Setup(c => c.Institutions).Returns(moq_Inst.Object); NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(nuContext.Object); //Verify institution Id is returned Assert.AreEqual(nInst.InstitutionId, nh.GetInstitutionId(nInst.LegacySiteId)); // verify empty GUID is returned for site id's not found Assert.IsTrue(nh.GetInstitutionId(99999).Equals(Guid.Empty)); }
public void GetInsuranceCompanyIdTest() { MemoryMappings.AddCompnay("12345", "Acme Insurance"); Mock <DbSet <SQLDatabase.EF.InsuranceProvider> > moq_Ins = new Mock <DbSet <InsuranceProvider> >(); moq_Ins.SetupData(new List <SQLDatabase.EF.InsuranceProvider>()); var nIns = new InsuranceProvider { Name = "Acme Insurance", IsActive = true, CompanyId = 12345 }; moq_Ins.Object.Add(nIns); nuContext.Setup(c => c.InsuranceProviders).Returns(moq_Ins.Object); NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(nuContext.Object); // verify insurance id is returned Assert.AreEqual(nIns.CompanyId, nh.GetInsuranceCompanyId(nIns.CompanyId.ToString())); // verify 0 is returned for insurance providers not found Assert.IsTrue(nh.GetInsuranceCompanyId("99999").Equals(0)); }
public void GetAllCheckStatusTypesTest() { Mock <DbSet <SQLDatabase.EF.CheckStatu> > moq_Chk = new Mock <DbSet <CheckStatu> >(); moq_Chk.SetupData(new List <SQLDatabase.EF.CheckStatu>()); Array.ForEach(db.CheckStatus.ToArray(), a => { var nChk = new SQLDatabase.EF.CheckStatu(); nChk.StatusId = a.StatusId; nChk.Status = a.Status; moq_Chk.Object.Add(nChk); }); nuContext.Setup(c => c.CheckStatus).Returns(moq_Chk.Object); NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(nuContext.Object); // verify only three types exist Assert.AreEqual(4, nh.GetAllCheckStatusTypes().Count); // verify type ids Assert.AreEqual(1, nh.GetAllCheckStatusTypes().Where(w => w.Status == "Completed").Select(s => s.StatusId).Single()); Assert.AreEqual(2, nh.GetAllCheckStatusTypes().Where(w => w.Status == "Canceled").Select(s => s.StatusId).Single()); Assert.AreEqual(3, nh.GetAllCheckStatusTypes().Where(w => w.Status == "Pending").Select(s => s.StatusId).Single()); Assert.AreEqual(4, nh.GetAllCheckStatusTypes().Where(w => w.Status == "RejectedByBank").Select(s => s.StatusId).Single()); // verify types names Assert.IsTrue(nh.GetAllCheckStatusTypes().Any(a => a.Status == "Completed")); Assert.IsTrue(nh.GetAllCheckStatusTypes().Any(a => a.Status == "Canceled")); Assert.IsTrue(nh.GetAllCheckStatusTypes().Any(a => a.Status == "Pending")); Assert.IsTrue(nh.GetAllCheckStatusTypes().Any(a => a.Status == "RejectedByBank")); }
public void GetApplicationIdTest() { Mock <DbSet <SQLDatabase.EF.Application> > moq_App = new Mock <DbSet <Application> >(); moq_App.SetupData(new List <SQLDatabase.EF.Application>()); Array.ForEach(db.Applications.ToArray(), a => { var nApp = new SQLDatabase.EF.Application(); nApp.ApplicationId = a.ApplicationId; nApp.ApplicationName = a.ApplicationName; nApp.BannerEnable = a.BannerEnable; nApp.BannerMessage = a.BannerMessage; nApp.Description = a.Description; moq_App.Object.Add(nApp); }); nuContext.Setup(c => c.Applications).Returns(moq_App.Object); NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(nuContext.Object); Guid expId = Guid.Parse("DFE4EB52-401E-42DA-B7A0-D801749446A0"); Guid actual = nh.GetApplicationId("Administration"); // verify Id is returned Assert.AreEqual(expId, actual); // verify empty GUID is returned for applications not found Assert.IsTrue(nh.GetApplicationId("FakeApplication").Equals(Guid.Empty)); }
public void GetAllPaymentMethodsTest() { Mock <DbSet <SQLDatabase.EF.PaymentMethod> > moq_PayMeth = new Mock <DbSet <PaymentMethod> >(); moq_PayMeth.SetupData(new List <SQLDatabase.EF.PaymentMethod>()); Array.ForEach(db.PaymentMethods.ToArray(), a => { var nPay = new SQLDatabase.EF.PaymentMethod(); nPay.MethodId = a.MethodId; nPay.MethodName = a.MethodName; moq_PayMeth.Object.Add(nPay); }); nuContext.Setup(c => c.PaymentMethods).Returns(moq_PayMeth.Object); NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(nuContext.Object); // verify only three types exist Assert.AreEqual(4, nh.GetAllPaymentMethods().Count); // verify type ids Assert.AreEqual(1, nh.GetAllPaymentMethods().Where(w => w.MethodName == "PayPal").Select(s => s.MethodId).Single()); Assert.AreEqual(2, nh.GetAllPaymentMethods().Where(w => w.MethodName == "Check").Select(s => s.MethodId).Single()); Assert.AreEqual(3, nh.GetAllPaymentMethods().Where(w => w.MethodName == "Invoice").Select(s => s.MethodId).Single()); Assert.AreEqual(4, nh.GetAllPaymentMethods().Where(w => w.MethodName == "Adjustment").Select(s => s.MethodId).Single()); // verify types names Assert.IsTrue(nh.GetAllPaymentMethods().Any(a => a.MethodName == "PayPal")); Assert.IsTrue(nh.GetAllPaymentMethods().Any(a => a.MethodName == "Check")); Assert.IsTrue(nh.GetAllPaymentMethods().Any(a => a.MethodName == "Invoice")); Assert.IsTrue(nh.GetAllPaymentMethods().Any(a => a.MethodName == "Adjustment")); }
public void GetAllTherapyTypesTest() { Mock <DbSet <SQLDatabase.EF.TherapyType> > moq_TherapyTypes = new Mock <DbSet <TherapyType> >(); moq_TherapyTypes.SetupData(new List <SQLDatabase.EF.TherapyType>()); Array.ForEach(db.TherapyTypes.ToArray(), a => { var nTher = new SQLDatabase.EF.TherapyType(); nTher.TypeId = a.TypeId; nTher.TypeName = a.TypeName; moq_TherapyTypes.Object.Add(nTher); }); nuContext.Setup(c => c.TherapyTypes).Returns(moq_TherapyTypes.Object); NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(nuContext.Object); // verify only three types exist Assert.AreEqual(2, nh.GetAllTherapyTypes().Count); // verify type ids Assert.AreEqual(1, nh.GetAllTherapyTypes().Where(w => w.TypeName == "Scheduled").Select(s => s.TypeId).Single()); Assert.AreEqual(2, nh.GetAllTherapyTypes().Where(w => w.TypeName == "OnDemand").Select(s => s.TypeId).Single()); // verify types names Assert.IsTrue(nh.GetAllTherapyTypes().Any(a => a.TypeName == "Scheduled")); Assert.IsTrue(nh.GetAllTherapyTypes().Any(a => a.TypeName == "OnDemand")); }
public void GetAllReadingEventTypesTest() { Mock <DbSet <SQLDatabase.EF.ReadingEventType> > moq_REType = new Mock <DbSet <ReadingEventType> >(); moq_REType.SetupData(new List <SQLDatabase.EF.ReadingEventType>()); Array.ForEach(db.ReadingEventTypes.ToArray(), a => { var nRET = new SQLDatabase.EF.ReadingEventType(); nRET.EventId = a.EventId; nRET.EventName = a.EventName; moq_REType.Object.Add(nRET); }); nuContext.Setup(c => c.ReadingEventTypes).Returns(moq_REType.Object); NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(nuContext.Object); // verify only three types exist Assert.AreEqual(8, nh.GetAllReadingEventTypes().Count); // verify type ids Assert.AreEqual(1, nh.GetAllReadingEventTypes().Where(w => w.EventName == "Alarm").Select(s => s.EventId).Single()); Assert.AreEqual(2, nh.GetAllReadingEventTypes().Where(w => w.EventName == "DateChange").Select(s => s.EventId).Single()); Assert.AreEqual(3, nh.GetAllReadingEventTypes().Where(w => w.EventName == "RemoteHazard").Select(s => s.EventId).Single()); Assert.AreEqual(4, nh.GetAllReadingEventTypes().Where(w => w.EventName == "Activate").Select(s => s.EventId).Single()); Assert.AreEqual(5, nh.GetAllReadingEventTypes().Where(w => w.EventName == "Deactivate").Select(s => s.EventId).Single()); Assert.AreEqual(6, nh.GetAllReadingEventTypes().Where(w => w.EventName == "Suspend").Select(s => s.EventId).Single()); Assert.AreEqual(7, nh.GetAllReadingEventTypes().Where(w => w.EventName == "Resume").Select(s => s.EventId).Single()); Assert.AreEqual(8, nh.GetAllReadingEventTypes().Where(w => w.EventName == "TimeChange").Select(s => s.EventId).Single()); // verify types names Assert.IsTrue(nh.GetAllReadingEventTypes().Any(a => a.EventName == "Alarm")); Assert.IsTrue(nh.GetAllReadingEventTypes().Any(a => a.EventName == "DateChange")); Assert.IsTrue(nh.GetAllReadingEventTypes().Any(a => a.EventName == "RemoteHazard")); Assert.IsTrue(nh.GetAllReadingEventTypes().Any(a => a.EventName == "Activate")); Assert.IsTrue(nh.GetAllReadingEventTypes().Any(a => a.EventName == "Deactivate")); Assert.IsTrue(nh.GetAllReadingEventTypes().Any(a => a.EventName == "Suspend")); Assert.IsTrue(nh.GetAllReadingEventTypes().Any(a => a.EventName == "Resume")); Assert.IsTrue(nh.GetAllReadingEventTypes().Any(a => a.EventName == "TimeChange")); }
public void GetAllInsulinTypesTest() { Mock <DbSet <SQLDatabase.EF.InsulinType> > moq_Insulin = new Mock <DbSet <SQLDatabase.EF.InsulinType> >(); moq_Insulin.SetupData(new List <SQLDatabase.EF.InsulinType>()); Array.ForEach(db.InsulinTypes.ToArray(), a => { var nIns = new SQLDatabase.EF.InsulinType(); nIns.InsulinTypeId = a.InsulinTypeId; nIns.Type = a.Type; moq_Insulin.Object.Add(nIns); }); nuContext.Setup(c => c.InsulinTypes).Returns(moq_Insulin.Object); NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(nuContext.Object); // verify only three types exist Assert.AreEqual(5, nh.GetAllInsulinTypes().Count); // verify type ids Assert.AreEqual(1, nh.GetAllInsulinTypes().Where(w => w.Type == "Rapid Acting").Select(s => s.InsulinTypeId).Single()); Assert.AreEqual(2, nh.GetAllInsulinTypes().Where(w => w.Type == "Short Acting").Select(s => s.InsulinTypeId).Single()); Assert.AreEqual(3, nh.GetAllInsulinTypes().Where(w => w.Type == "Intermediate Acting").Select(s => s.InsulinTypeId).Single()); Assert.AreEqual(4, nh.GetAllInsulinTypes().Where(w => w.Type == "Long Acting").Select(s => s.InsulinTypeId).Single()); Assert.AreEqual(5, nh.GetAllInsulinTypes().Where(w => w.Type == "PreMixed").Select(s => s.InsulinTypeId).Single()); // verify types names Assert.IsTrue(nh.GetAllInsulinTypes().Any(a => a.Type == "Rapid Acting")); Assert.IsTrue(nh.GetAllInsulinTypes().Any(a => a.Type == "Short Acting")); Assert.IsTrue(nh.GetAllInsulinTypes().Any(a => a.Type == "Intermediate Acting")); Assert.IsTrue(nh.GetAllInsulinTypes().Any(a => a.Type == "Long Acting")); Assert.IsTrue(nh.GetAllInsulinTypes().Any(a => a.Type == "PreMixed")); }
private void BTrans_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { DispatchLabel("Creating statistics."); var rList = new List <dynamic>(); var initRC = JsonConvert.DeserializeObject <List <TableRowCount> >(initRowCount); NumedicsGlobalHelpers ngh = new NumedicsGlobalHelpers(); SqlPurge sp = new SqlPurge(); sp.Purge(); DispatchLabel("Logging Transaction."); MigrationHistoryHelpers mig = new MigrationHistoryHelpers(); mig.LogMigration(); TransactionManager.ExecuteTransaction(); foreach (var table in ngh.GetTableRowCount()) { var preRowCnt = initRC.Where(f => f.TableName == table.TableName).Select(s => s.RowCnt).FirstOrDefault(); var ms = MappingStatistics.SqlTableStatistics.FirstOrDefault(w => w.Tablename == table.TableName); var diff = (ms == null) ? 0 : ms.Difference; var n = new { TableName = table.TableName, PreMigrationRows = preRowCnt, PostMigratioRows = table.RowCnt, RowsAdded = table.RowCnt - preRowCnt, MappedRowsCommitted = (ms == null) ? 0 : ms.PreSaveCount, MappedRowsSaved = (ms == null) ? 0 : ms.PostSaveCount, MappedRowsDifference = diff, Result = ((table.RowCnt - preRowCnt) == 0) ? "NO CHANGE" : (diff == 0) ? "SUCCESS" : "FAIL" }; rList.Add(n); } dgMigResults.ItemsSource = rList.OrderBy(o => o.TableName); //MappingStatistics.SqlTableStatistics.OrderBy(o => o.Tablename); ((DataGridTextColumn)dgMigResults.Columns[0]).Binding = new Binding("TableName"); ((DataGridTextColumn)dgMigResults.Columns[1]).Binding = new Binding("PreMigrationRows"); ((DataGridTextColumn)dgMigResults.Columns[2]).Binding = new Binding("PostMigratioRows"); ((DataGridTextColumn)dgMigResults.Columns[3]).Binding = new Binding("RowsAdded"); ((DataGridTextColumn)dgMigResults.Columns[4]).Binding = new Binding("MappedRowsCommitted"); ((DataGridTextColumn)dgMigResults.Columns[5]).Binding = new Binding("MappedRowsSaved"); ((DataGridTextColumn)dgMigResults.Columns[6]).Binding = new Binding("MappedRowsDifference"); ((DataGridTextColumn)dgMigResults.Columns[7]).Binding = new Binding("Result"); var successCnt = rList.Count(w => w.Result == "SUCCESS"); var failCnt = rList.Count(w => w.Result == "FAIL"); var ncCnt = rList.Count(w => w.Result == "NO CHANGE"); stkLoading.Visibility = Visibility.Hidden; lblTblsUpCnt.Content = rList.Count.ToString(); lblFailUpCnt.Content = failCnt.ToString(); lblNoChgUpCnt.Content = ncCnt.ToString(); lblSuccUpCnt.Content = successCnt.ToString(); lblLogLoc.Content = MigrationVariables.LogFileLocation; spMigrationResults.Visibility = Visibility.Visible; DispatchLabel("Transaction Complete."); }
private void Init() { NumedicsGlobalHelpers nh = new NumedicsGlobalHelpers(); DefaultSubscriptionTypes.Add(new SubscriptionType { ApplicationId = nh.GetApplicationId("diabetes partner"), SubscriptionLengthDays = 30, Label = "30 dsys", Description = "30 Day Subscription", Price = 6.50M }); DefaultSubscriptionTypes.Add(new SubscriptionType { ApplicationId = nh.GetApplicationId("diabetes partner"), SubscriptionLengthDays = 90, Label = "3 months", Description = "3 Month Subscription", Price = 5.50M }); DefaultSubscriptionTypes.Add(new SubscriptionType { ApplicationId = nh.GetApplicationId("diabetes partner"), SubscriptionLengthDays = 180, Label = "6 months", Description = "6 Month Subscription", Price = 4.00M }); DefaultSubscriptionTypes.Add(new SubscriptionType { ApplicationId = nh.GetApplicationId("diabetes partner"), SubscriptionLengthDays = 365, Label = "1 year", Description = "1 Year Subscription", Price = 3.00M }); DefaultSubscriptionTypes.Add(new SubscriptionType { ApplicationId = nh.GetApplicationId("clinipro-web"), SubscriptionLengthDays = 30, Label = "30 dsys", Description = "30 Day Subscription Plus", Price = 999.99M }); DefaultSubscriptionTypes.Add(new SubscriptionType { ApplicationId = nh.GetApplicationId("clinipro-web"), SubscriptionLengthDays = 30, Label = "30 dsys", Description = "30 Day Subscription", Price = 45.95M }); DefaultSubscriptionTypes.Add(new SubscriptionType { ApplicationId = nh.GetApplicationId("administration"), SubscriptionLengthDays = 0, Label = "Adjustment", Description = "Adjustment", Price = 0M }); DefaultSubscriptionTypes.Add(new SubscriptionType { ApplicationId = nh.GetApplicationId("administration"), SubscriptionLengthDays = 0, Label = "Free", Description = "Free Download", Price = 0M }); }