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"; }
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); } }
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); } } }
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; } } }
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); } } }
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(); } } } } }
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); }
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); }
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); } } }
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")); }
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()); } } } }
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(); }
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); }
public void TestInit() { DbManagerFactory.SetSqlFactory(new ConnectionCredentials().ConnectionString); EidssUserContext.Init(); }
public void MyTestInitialize() { DbManagerFactory.SetSqlFactory(Config.GetSetting("TestConnectionString")); }
public static void Initialize(TestContext testContext) { DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString", "")); }
public void TestInit() { EidssUserContext.Init(); DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString", "")); }
public static void Init(TestContext testContext) { DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString")); DataHelper.GetQueryFieldsCount(49539640000000); }
private IDbManager CreateTestDbManager(DbEngine dbEngine) { return(DbManagerFactory.Create(dbEngine, _loggerFactory)); }
public virtual void GetDataAdapter() { Adapter = DbManagerFactory.GetDataAdapter(_providerType); }
public virtual void GetCommand() { Command = DbManagerFactory.GetCommand(_providerType); }
public virtual void GetConnection() { Connection = DbManagerFactory.GetConnection(_providerType); }
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); }
public virtual void GetTransaction() { Transaction = DbManagerFactory.GetTransaction((IDbConnection)Connection); }
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); } }
public override void MyTestInitialize() { DbManagerFactory.SetSqlFactory(new ConnectionCredentials().ConnectionString); DbManagerFactory.SetSqlFactory(new ConnectionCredentials(null, "Archive").ConnectionString, DatabaseType.Archive); }
public virtual void GetParameter() { Parameter = DbManagerFactory.GetParameter(_providerType); }
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")); }
public void MyTestInitialize() { EIDSS_LookupCacheHelper.Init(); DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString")); m_PresenterTransaction = PresenterFactory.BeginSharedPresenterTransaction(StructureMapContainerInit(), new BaseForm()); }