Пример #1
0
        public void TestInitialize()
        {
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
            ConnectionManager.DefaultInstance.SetCredentials(Config.GetSetting("EidssConnectionString"));
            EidssUserContext.Init();
            context    = ModelUserContext.Instance as EidssUserContext;
            m_Security = new EidssSecurityManager();
            int result = m_Security.LogIn(Organizaton, Admin, AdminPassword);

            Assert.AreEqual(0, result);
            EIDSS_LookupCacheHelper.Init();
            //while(!LookupCache.Filled)
            //    Thread.Sleep(500);
            ModelUserContext.CurrentLanguage = "en";
        }
Пример #2
0
 public void GetInnerExceptionDescriptionTest()
 {
     try
     {
         DbManagerFactory.SetSqlFactory("Persist Security Info=true;Initial Catalog=xxx;Data Source=xxx;");
         using (DbManagerProxy manager = DbManagerFactory.Factory.Create())
         {
             manager.SetCommand("select 1;");
             manager.ExecuteNonQuery();
         }
     }
     catch (Exception ex)
     {
         string description = SqlExceptionHandler.GetExceptionDescription(ex);
         Assert.AreNotEqual(string.Empty, description);
     }
 }
Пример #3
0
        public void AsSessionSample()
        {
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
            using (var context = ModelUserContext.Instance as EidssUserContext)
            {
                using (var manager = DbManagerFactory.Factory.Create(context))
                {
                    var acc = AsSession.Accessor.Instance(null);

                    var session = (AsSession)acc.CreateNew(manager);
                    //mandatory field
                    session.Region = session.RegionLookup.FirstOrDefault();

                    var rootFarm = FarmRootPanel.Accessor.Instance(null).CreateNewT(manager);
                }
            }
        }
Пример #4
0
        public void FarmPanelCollection()
        {
            EidssUserContext.Init();
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
            using (var context = ModelUserContext.Instance as EidssUserContext)
            {
                var target = new EidssSecurityManager();

                int result = target.LogIn(Organizaton, Admin, AdminPassword);
                Assert.AreEqual(0, result);

                using (var manager = DbManagerFactory.Factory.Create(context))
                {
                    var acc     = VetCase.Accessor.Instance(null);
                    var vetcase = (VetCase)acc.CreateNew(manager, null, (int)HACode.Livestock);

                    var panel = vetcase.Farm;

                    var         herdaccessor = VetFarmTree.Accessor.Instance(null);
                    VetFarmTree farm         = panel.FarmTree[0];
                    VetFarmTree herd         = herdaccessor.CreateHerd(manager, panel, farm);
                    VetFarmTree spec         = herdaccessor.CreateSpecies(manager, panel, herd);
                    spec.SpeciesType = spec.SpeciesTypeLookup.FirstOrDefault(c => c.idfsBaseReference == 837790000000);
                    //spec.idfsSpeciesTypeReference = 837790000000;
                    panel.FarmTree.Add(herd);
                    panel.FarmTree.Add(spec);

                    panel.Address.Region     = panel.Address.RegionLookup.FirstOrDefault();
                    panel.Address.Rayon      = panel.Address.RayonLookup.FirstOrDefault();
                    panel.Address.Settlement = panel.Address.SettlementLookup.FirstOrDefault();

                    var animal = (AnimalListItem)AnimalListItem.Accessor.Instance(null).CreateNew(manager, vetcase, (int)HACode.Livestock);
                    animal.idfSpecies = spec.idfParty;
                    animal.idfHerd    = herd.idfParty;
                    animal.idfCase    = vetcase.idfCase;

                    vetcase.AnimalList.Add(animal);
                    //vetcase.Validation += new ValidationEvent(panel_Validation);


                    //acc.Post(manager, vetcase);
                    //vetcase.Validation -= panel_Validation;
                }
            }
        }
Пример #5
0
        public void RootFarmCollection()
        {
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
            using (var context = ModelUserContext.Instance as EidssUserContext)
            {
                using (var manager = DbManagerFactory.Factory.Create(context))
                {
                    var acc = FarmRootPanel.Accessor.Instance(null);

                    var panel = acc.Create(manager, null, HACode: null);

                    var          herdaccessor = RootFarmTree.Accessor.Instance(null);
                    RootFarmTree farm         = panel.FarmLivestockTree[0];
                    RootFarmTree herd         = herdaccessor.CreateHerd(manager, panel, farm);
                    RootFarmTree spec         = herdaccessor.CreateSpecies(manager, panel, herd);
                    spec.SpeciesType = spec.SpeciesTypeLookup.FirstOrDefault(c => c.idfsBaseReference == 837790000000);
                    //spec.idfsSpeciesTypeReference = 837790000000;
                    panel.FarmLivestockTree.Add(herd);
                    panel.FarmLivestockTree.Add(spec);

                    panel.Address.Region     = panel.Address.RegionLookup.FirstOrDefault();
                    panel.Address.Rayon      = panel.Address.RayonLookup.FirstOrDefault();
                    panel.Address.Settlement = panel.Address.SettlementLookup.FirstOrDefault();
                    //panel.Location.CopyAddressValues(panel.Address);

                    //panel.Validation += new ValidationEvent(panel_Validation);
                    //panel.blnIsLivestock = true;
                    //acc.Post(manager, panel);

                    //panel.Validation -= panel_Validation;

                    //var savedpanel = acc.SelectByKey(manager, panel.idfFarm);

                    //Assert.AreEqual(panel.FarmLivestockTree.Count, savedpanel.FarmLivestockTree.Count);
                    //Assert.AreNotEqual(savedpanel.FarmLivestockTree.Count, savedpanel.FarmAvianTree.Count);
                    //Assert.AreEqual(panel.FarmAvianTree.Count, 1);
                    //Assert.AreEqual(farm._HACode, (int)HACode.Livestock);
                    //Assert.AreEqual(herd._HACode, (int)HACode.Livestock);
                    //Assert.AreEqual(spec._HACode, (int)HACode.Livestock);
                    //Assert.AreNotEqual(spec.SpeciesTypeLookup.Count, 1);
                }
            }
        }
Пример #6
0
 private void InitConnection()
 {
     if (TabControlMain.TabPages.IndexOf(TabPageSQL) > 0)
     {
         m_ConnectionCredentials.SetCredentials(BaseSettings.ConnectionString, txtSQLServer.Text, txtSQLDatabase.Text, txtSQLUser.Text, txtSQLPassword.Text);
         ConnectionManager.DefaultInstance.SetCredentials(BaseSettings.ConnectionString, txtSQLServer.Text, txtSQLDatabase.Text, txtSQLUser.Text, txtSQLPassword.Text);
         DbManagerFactory.SetSqlFactory(m_ConnectionCredentials.ConnectionString);
         if (m_ConnectionCredentials.IsCorrect)
         {
             using (var manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance))
             {
                 if (manager.TestConnection())
                 {
                     m_ConnectionCredentials.Save();
                 }
             }
         }
     }
 }
Пример #7
0
        public void MyTestInitialize()
        {
            //DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString", ""));
            //ClassLoader.Init("eidss*.dll", Environment.MachineName.Equals("LEONOV") ? @"c:\Projects\EIDSS4\eidss.main\bin\Debug\" : null);
            ClassLoader.Init("eidss*.dll", null);
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString", ""));
            EidssUserContext.Init();
            var target = new EidssSecurityManager();

            const string organizaton = "NCDC&PH";
            const string admin       = "test_admin";
            //const string User = "******";
            const string adminPassword = "******";
            //const string UserPassword = "******";

            int result = target.LogIn(organizaton, admin, adminPassword);

            Assert.AreEqual(0, result);
        }
Пример #8
0
        public ActionResult Add()
        {
            MyLogger.GetInstance().Info("Creating Project");

            DbManagerFactory dbm = new DbManagerFactory(ProjectBaseClass.dbType());

            IProject Dbm = dbm.GetDbManager();

            WrapperViewNewProject nvp = Dbm.GetViewForNewProject();


            if (nvp == null)
            {
                msg = "Error - getting views for new project";

                MyLogger.GetInstance().Error(msg);

                return(RedirectToAction("ErrorView", "Project", new { message = msg }));
            }

            return(View(nvp));
        }
        public void TestInit(DbEngine dbEngine, bool integratedSecurity, string userName, string password)
        {
            IDbManager                   dbManager   = DbManagerFactory.Create(dbEngine, _loggerFactory);
            Tuple <string, string>       hostAndName = _hostAndDatabaseOptions[dbEngine];
            IDictionary <string, string> options     = new Dictionary <string, string>()
            {
                { DbParametersKeys.HostKey, hostAndName.Item1 },
                { DbParametersKeys.DatabaseKey, hostAndName.Item2 },
                { DbParametersKeys.UseIntegratedSecurityKey, integratedSecurity.ToString() },
                { DbParametersKeys.LoginKey, userName },
                { DbParametersKeys.PasswordKey, password }
            };

            string connectionString = ConnectionStringBuilder.Build(dbEngine, options);
            bool   result           = dbManager.CreateDatabase(connectionString, true);

            Assert.True(result);
            result = dbManager.Init(connectionString, _scripts);
            Assert.True(result);
            result = dbManager.DropDatabase(connectionString);
            Assert.True(result);
        }
Пример #10
0
            public string CreateTicket(long userId)
            {
                var dbType = DatabaseType.Main;
                var connectionCredentials = new ConnectionCredentials(null, "Avr");

                if (connectionCredentials.IsCorrect)
                {
                    DbManagerFactory.SetSqlFactory(connectionCredentials.ConnectionString, DatabaseType.AvrTicket);
                    using (var avrManager = DbManagerFactory.Factory[DatabaseType.AvrTicket].Create())
                    {
                        if (avrManager.TestConnection())
                        {
                            dbType = DatabaseType.AvrTicket;
                        }
                    }
                }
                using (DbManagerProxy manager = DbManagerFactory.Factory[dbType].Create(ModelUserContext.Instance))
                {
                    try
                    {
                        manager.SetSpCommand("dbo.spLoginCreateTicket",
                                             manager.Parameter("@idfUserID", userId),
                                             manager.Parameter(ParameterDirection.Output, "@strTicket", ""),
                                             manager.Parameter(ParameterDirection.Output, "@Result", 0)
                                             ).ExecuteNonQuery();
                        int res = Convert.ToInt32(manager.Parameter("@Result").Value);
                        if (res == 0)
                        {
                            return(Utils.Str(manager.Parameter("@strTicket").Value));
                        }
                        return(null);
                    }
                    catch (DataException e)
                    {
                        throw DbModelException.Create(null, e);
                    }
                }
            }
Пример #11
0
        public static void MyClassInitialize(TestContext testContext)
        {
            m_Container = StructureMapContainerInit();
            m_Trace     = new TraceHelper(TraceHelper.AVRCategory);

            SetFreePortToAvrAndReport();

            DbManagerFactory.SetSqlFactory(new ConnectionCredentials(null, "AvrService").ConnectionString, DatabaseType.Avr);
            DbManagerFactory.SetSqlFactory(new ConnectionCredentials(null, "Archive").ConnectionString, DatabaseType.Archive);
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
            m_HumanFieldCount = DataHelper.GetQueryFieldsCount(49539640000000);
            m_VetFieldCount   = DataHelper.GetQueryFieldsCount(49542020000000);

            m_HostKeeper = new AvrHostKeeper(m_Container);

            m_HostKeeper.Open();

            Assembly asm         = Assembly.GetExecutingAssembly();
            string   exeLocation = Path.GetDirectoryName(Utils.ConvertFileName(asm.Location)) ?? string.Empty;

            if (!Directory.Exists(exeLocation))
            {
                int index = exeLocation.IndexOf("EIDSSTrunk", StringComparison.OrdinalIgnoreCase);
                if (index > 0)
                {
                    Directory.CreateDirectory(exeLocation);
                    string realPath = exeLocation.Substring(0, index) +
                                      @"EIDSSTrunk\EIDSS\eidss.main\bin\Debug\eidss.avr.export.x86.exe";
                    File.Copy(realPath, exeLocation + @"\eidss.avr.export.x86.exe");
                }
            }

            m_ExportUtilFilePath = Utils.GetFilePathNearAssembly(asm, @"eidss.avr.export.x86.exe");

            DbManagerFactory.SetSqlFactory(new ConnectionCredentials(null, "AvrService").ConnectionString, DatabaseType.Avr);
            DbManagerFactory.SetSqlFactory(new ConnectionCredentials(null, "Archive").ConnectionString, DatabaseType.Archive);
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
        }
Пример #12
0
        public void TestCompareSQLtoCS()
        {
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
            ConnectionManager.DefaultInstance.SetCredentials(Config.GetSetting("EidssConnectionString"));

            EidssUserContext.Init();
            using (var manager = DbManagerFactory.Factory.Create())
            {
                for (int year = 1900; year <= 2050; year++)
                {
                    for (int day = 24; day <= 31; day++)
                    {
                        DateTime dt = new DateTime(year, 12, day);
                        Assert.AreEqual(DatePeriodHelper.GetWeekOfYear(dt), manager.SetCommand("SET DATEFIRST 1; select dbo.fnWeekDatepart('" + dt.ToString("yyyyMMdd") + "')").ExecuteScalar());
                    }
                    for (int day = 1; day <= 7; day++)
                    {
                        DateTime dt = new DateTime(year, 1, day);
                        Assert.AreEqual(DatePeriodHelper.GetWeekOfYear(dt), manager.SetCommand("SET DATEFIRST 1; select dbo.fnWeekDatepart('" + dt.ToString("yyyyMMdd") + "')").ExecuteScalar());
                    }
                }
            }
        }
Пример #13
0
        public void ImportFromMdbFileTest()
        {
            string path      = PathToTestFolder.Get(TestFolders.Db) + "Data\\";
            long   start     = 1009508;
            long   chunkSize = 10000;

            EidssUserContext.Init();
            DbManagerFactory.SetSqlFactory(bv.common.Configuration.Config.GetSetting("EidssConnectionString"));
            for (long i = start; i < 1009509; i += chunkSize)
            {
                var timer = new PerformanceTimer("mdb records loading", 0);
                using (var _manager = DbManagerFactory.Factory.Create(EidssUserContext.Instance))
                {
                    var _accessor = Upload506Master.Accessor.Instance(null);
                    var _master   = _accessor.CreateNewT(_manager, null);
                    var result    = _master.GetItems(path + "Cddata.mdb", i, chunkSize);
                    timer.Stop();
                    Debug.WriteLine("records from {0} to {1} loading time:{2}", i, i + chunkSize, timer.Time());
                    timer = new PerformanceTimer("set item resolution", 0);
                    foreach (var item in _master.Items)
                    {
                        item.Resolution = (int)Upload506Resolution.Created;
                    }
                    timer.Stop();
                    Debug.WriteLine("set item resolution time:{0}", timer.Time());

                    Assert.AreEqual(Upload506FileError.Success, result);
                    Assert.AreEqual(chunkSize, _master.Items.Count);
                    Assert.AreEqual(Upload506MasterState.ReadyForValidation, _master.GetState());
                    timer = new PerformanceTimer("post", 0);
                    Assert.IsTrue(_accessor.Post(_manager, _master));
                    timer.Stop();
                    Debug.WriteLine("records from {0} to {1} posting time:{2}", i, i + chunkSize, timer.Time());
                }
            }
            EidssUserContext.Clear();
        }
Пример #14
0
 public ForcedReplicationClient(ConnectionCredentials credentials = null, string clientID = null)
 {
     m_DelayedReplicationTimer = new Timer(StartReplication, null,
                                           Timeout.Infinite,
                                           Timeout.Infinite);
     //initialize EIDSS shared variables here because they are called from other thread
     //where EidssUserContext and EidssSiteContext are not initialized
     m_UserID = EidssUserContext.User.ID;
     m_SiteID = EidssSiteContext.Instance.RealSiteID;
     if (Utils.IsEmpty(clientID))
     {
         m_ClientID = ModelUserContext.ClientID;
     }
     else
     {
         m_ClientID = clientID;
     }
     if (credentials != null)
     {
         DbManagerFactory.SetSqlFactory(credentials.ConnectionString);
     }
     SubscribeToEvent((long)EventType.ForcedReplicationConfirmed);
     SubscribeToEvent((long)EventType.ForcedReplicationExpired);
 }
Пример #15
0
 public void TestInit()
 {
     DbManagerFactory.SetSqlFactory(new ConnectionCredentials().ConnectionString);
     EidssUserContext.Init();
 }
Пример #16
0
 public void MyTestInitialize()
 {
     DbManagerFactory.SetSqlFactory(Config.GetSetting("TestConnectionString"));
 }
Пример #17
0
 public static void Initialize(TestContext testContext)
 {
     DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString", ""));
 }
Пример #18
0
 public void TestInit()
 {
     EidssUserContext.Init();
     DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString", ""));
 }
Пример #19
0
 public static void Init(TestContext testContext)
 {
     DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
     DataHelper.GetQueryFieldsCount(49539640000000);
 }
Пример #20
0
 private IDbManager CreateTestDbManager(DbEngine dbEngine)
 {
     return(DbManagerFactory.Create(dbEngine, _loggerFactory));
 }
Пример #21
0
 public virtual void GetDataAdapter()
 {
     Adapter = DbManagerFactory.GetDataAdapter(_providerType);
 }
Пример #22
0
 public virtual void GetCommand()
 {
     Command = DbManagerFactory.GetCommand(_providerType);
 }
Пример #23
0
 public virtual void GetConnection()
 {
     Connection = DbManagerFactory.GetConnection(_providerType);
 }
Пример #24
0
        public static VsSession GetTestSession()
        {
            VsSession session;

            //EidssUserContext.Init(); должен быть обёрнут извне
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
            using (var context = ModelUserContext.Instance as EidssUserContext)
            {
                using (var manager = DbManagerFactory.Factory.Create(context))
                {
                    var acc = VsSession.Accessor.Instance(null);

                    #region создание сессии

                    session = acc.CreateNewT(manager, null);

                    session.strSessionID      = NeedNewValue;
                    session.strFieldSessionID = "testFieldSessionID";
                    session.VsStatus          =
                        session.VsStatusLookup.Where(l => l.idfsBaseReference == (long)VsStatusEnum.InProgress).
                        SingleOrDefault();
                    session.datStartDate = DateTime.Now;

                    session.strDescription   = "created from unit test";
                    session.Location.Country =
                        session.Location.CountryLookup.Where(c => c.strCountryName == "Georgia").SingleOrDefault();
                    session.Location.Region =
                        session.Location.RegionLookup.Where(c => c.strRegionName == "Abkhazia").SingleOrDefault();
                    session.Location.Rayon =
                        session.Location.RayonLookup.Where(c => c.strRayonName == "Gagra").SingleOrDefault();

                    #endregion

                    #region создаём векторы

                    var accVector = Vector.Accessor.Instance(null);

                    //
                    var vector1 = AddVector(accVector, manager, session);

                    //
                    var vector2 = AddVector(accVector, manager, session);

                    //проверка hostvector
                    vector2.HostVector = vector1;

                    #endregion

                    #region в вектор создаём sample

                    var accSample = VectorSample.Accessor.Instance(null);

                    //подвешиваем семплы к 1 и 3 векторам
                    AddSample(accSample, manager, vector1);
                    AddSample(accSample, manager, vector1);
                    AddSample(accSample, manager, vector2);

                    #endregion

                    #region работа с полевыми тестами Field Tests

                    //sample1.isJustCreated = !sample1.isJustCreated; //??? TODO не всегда срабатывает

                    //в первом тесте меняем что-либо, чтобы строка реально сохранилась в БД
                    if (session.FieldTests.Count > 0)
                    {
                        foreach (var fieldTest in session.FieldTests)
                        {
                            var idTest = fieldTest.idfsPensideTestName;

                            //определим результат, который подходит для данного типа теста
                            var results =
                                fieldTest.TestResultLookup.Where(
                                    c => c.idfsPensideTestName == idTest);

                            /*
                             * if (fieldTest.TypeFieldTestToResultMatrix.Count > 0)
                             * {
                             *  if (results.Count() > 0)
                             *  {
                             *      fieldTest.PensideTestResult =
                             *          fieldTest.PensideTestResultLookup.Where(
                             *              c => c.idfsBaseReference == results.ToList()[0].idfsPensideTestResult).
                             *              ToList()[0];
                             *  }
                             *  else
                             *  {
                             *      fieldTest.PensideTestResult = fieldTest.PensideTestResultLookup[0];
                             *  }
                             * }
                             * */
                        }
                    }

                    #endregion
                }
            }
            //EidssUserContext.Clear();

            return(session);
        }
Пример #25
0
 public virtual void GetTransaction()
 {
     Transaction = DbManagerFactory.GetTransaction((IDbConnection)Connection);
 }
Пример #26
0
        public void StatisticImportTest()
        {
            DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString", ""));
            EidssUserContext.Init();
            using (var context = EidssUserContext.Instance)
            {
                StatisticHelper helper = new StatisticHelper();
                int             result = helper.Import(PathToTestFolder.Get(TestFolders.Db) + "Data\\StatisticData_Errors.csv", false);
                Assert.AreEqual(0, result);
                //Assert.AreEqual(4, helper.RowsAffected);
                Assert.AreEqual(10, helper.Errors.Count);
                Assert.AreEqual("errMissingField", helper.Errors[0].MessageID);
                Assert.AreEqual(0, helper.Errors[0].LineNumber);
                Assert.AreEqual("errInvalidStatisticType", helper.Errors[1].MessageID);
                Assert.AreEqual(1, helper.Errors[1].LineNumber);
                Assert.AreEqual("errInvalidStatisticValue", helper.Errors[2].MessageID);
                Assert.AreEqual(2, helper.Errors[2].LineNumber);
                Assert.AreEqual("errInvalidDateFormat", helper.Errors[3].MessageID);
                Assert.AreEqual(3, helper.Errors[3].LineNumber);
                Assert.AreEqual("errInvalidYearStartDate", helper.Errors[4].MessageID);
                Assert.AreEqual(4, helper.Errors[4].LineNumber);
                Assert.AreEqual("errInvalidCountry", helper.Errors[5].MessageID);
                Assert.AreEqual(5, helper.Errors[5].LineNumber);
                Assert.AreEqual("errInvalidRegion", helper.Errors[6].MessageID);
                Assert.AreEqual(6, helper.Errors[6].LineNumber);
                Assert.AreEqual("errInvalidRayon", helper.Errors[7].MessageID);
                Assert.AreEqual(7, helper.Errors[7].LineNumber);
                Assert.AreEqual("errInvalidParameter", helper.Errors[8].MessageID);
                Assert.AreEqual(8, helper.Errors[8].LineNumber);
                Assert.AreEqual("errMalFormedCvs", helper.Errors[9].MessageID);
                Assert.AreEqual(9, helper.Errors[9].LineNumber);
                Assert.IsTrue(helper.RowsAffected <= 3);

                result = helper.Import(PathToTestFolder.Get(TestFolders.Db) + "Data\\StatisticData_BadHeader.csv", false);
                Assert.AreEqual(-1, result);
                Assert.AreEqual(1, helper.Errors.Count);
                Assert.AreEqual("errStatisticImportFieldsQty", helper.Errors[0].MessageID);
                Assert.AreEqual(-1, helper.Errors[0].LineNumber);

                result = helper.Import(PathToTestFolder.Get(TestFolders.Db) + "Data\\StatisticData_BadHeader1.csv", false);
                Assert.AreEqual(-1, result);
                Assert.AreEqual(1, helper.Errors.Count);
                Assert.AreEqual("errStatisticImportFieldsQty", helper.Errors[0].MessageID);
                Assert.AreEqual(-1, helper.Errors[0].LineNumber);

                result = helper.Import(PathToTestFolder.Get(TestFolders.Db) + "Data\\StatisticData_Good.csv", false);
                Assert.AreEqual(0, result);
                Assert.AreEqual(9, helper.Errors.Count);
                Assert.AreEqual("errMissingField", helper.Errors[0].MessageID);
                Assert.AreEqual(0, helper.Errors[0].LineNumber);
                Assert.AreEqual("errInvalidStatisticType", helper.Errors[1].MessageID);
                Assert.AreEqual(1, helper.Errors[1].LineNumber);
                Assert.AreEqual("errInvalidStatisticValue", helper.Errors[2].MessageID);
                Assert.AreEqual(2, helper.Errors[2].LineNumber);
                Assert.AreEqual("errInvalidDateFormat", helper.Errors[3].MessageID);
                Assert.AreEqual(3, helper.Errors[3].LineNumber);
                Assert.AreEqual("errInvalidYearStartDate", helper.Errors[4].MessageID);
                Assert.AreEqual(4, helper.Errors[4].LineNumber);
                Assert.AreEqual("errInvalidCountry", helper.Errors[5].MessageID);
                Assert.AreEqual(5, helper.Errors[5].LineNumber);
                Assert.AreEqual("errInvalidRegion", helper.Errors[6].MessageID);
                Assert.AreEqual(6, helper.Errors[6].LineNumber);
                Assert.AreEqual("errInvalidRayon", helper.Errors[7].MessageID);
                Assert.AreEqual(7, helper.Errors[7].LineNumber);
                Assert.AreEqual("errInvalidParameter", helper.Errors[8].MessageID);
                Assert.AreEqual(8, helper.Errors[8].LineNumber);
                Assert.IsTrue(helper.RowsAffected <= 3);
            }
        }
Пример #27
0
 public override void MyTestInitialize()
 {
     DbManagerFactory.SetSqlFactory(new ConnectionCredentials().ConnectionString);
     DbManagerFactory.SetSqlFactory(new ConnectionCredentials(null, "Archive").ConnectionString, DatabaseType.Archive);
 }
Пример #28
0
 public virtual void GetParameter()
 {
     Parameter = DbManagerFactory.GetParameter(_providerType);
 }
Пример #29
0
 public void MyTestInitialize()
 {
     DbManagerFactory.SetSqlFactory(new ConnectionCredentials(null, "AvrService").ConnectionString, DatabaseType.Avr);
     DbManagerFactory.SetSqlFactory(new ConnectionCredentials(null, "Archive").ConnectionString, DatabaseType.Archive);
     DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
 }
Пример #30
0
 public void MyTestInitialize()
 {
     EIDSS_LookupCacheHelper.Init();
     DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
     m_PresenterTransaction = PresenterFactory.BeginSharedPresenterTransaction(StructureMapContainerInit(), new BaseForm());
 }