public DirectToDbApplier(QueryExecuter queryExecuter, IDatabaseSchemaVersionManager schemaVersionManager, QueryStatementSplitter splitter, IDbmsSyntax dbmsSyntax, string changeLogTableName, TextWriter infoTextWriter)
        {
            if (queryExecuter == null)
                throw new ArgumentNullException("queryExecuter");

            if (schemaVersionManager == null)
                throw new ArgumentNullException("schemaVersionManager");

            if (splitter == null)
                throw new ArgumentNullException("splitter");

            if (infoTextWriter == null)
                throw new ArgumentNullException("infoTextWriter");

            this.queryExecuter = queryExecuter;
            this.schemaVersionManager = schemaVersionManager;
            this.splitter = splitter;
            this.dbmsSyntax = dbmsSyntax;
            this.changeLogTableName = changeLogTableName;
            this.infoTextWriter = infoTextWriter;
        }
Пример #2
0
        public void Go()
        {
            this.Validate();

            this.InfoWriter.WriteLine(this.GenerateWelcomeString());

            var factory = new DbmsFactory(this.Dbms, this.ConnectionString);

            var dbmsSyntax = factory.CreateDbmsSyntax();

            QueryExecuter queryExecuter = new QueryExecuter(factory);

            var databaseSchemaVersionManager =
                new DatabaseSchemaVersionManager(queryExecuter, dbmsSyntax, this.ChangeLogTableName);

            var scanner = new DirectoryScanner(this.InfoWriter, this.Encoding);

            var changeScriptRepository =
                new ChangeScriptRepository(scanner.GetChangeScriptsForDirectory(this.ScriptDirectory));

            IChangeScriptApplier doScriptApplier;
            TextWriter           doWriter = null;

            if (this.OutputFile != null)
            {
                doWriter = new StreamWriter(this.OutputFile.OpenWrite(), this.Encoding);

                doScriptApplier = new TemplateBasedApplier(
                    doWriter,
                    this.Dbms,
                    this.ChangeLogTableName,
                    this.Delimiter,
                    this.DelimiterType,
                    this.TemplateDir);
            }
            else
            {
                QueryStatementSplitter splitter = new QueryStatementSplitter
                {
                    Delimiter     = this.Delimiter,
                    DelimiterType = this.DelimiterType,
                    LineEnding    = this.LineEnding,
                };

                doScriptApplier = new DirectToDbApplier(
                    queryExecuter,
                    databaseSchemaVersionManager,
                    splitter,
                    this.InfoWriter);
            }

            IChangeScriptApplier undoScriptApplier = null;
            TextWriter           undoWriter        = null;

            if (this.UndoOutputFile != null)
            {
                undoWriter = new StreamWriter(this.UndoOutputFile.OpenWrite(), this.Encoding);

                undoScriptApplier = new UndoTemplateBasedApplier(
                    undoWriter,
                    this.Dbms,
                    this.ChangeLogTableName,
                    this.Delimiter,
                    this.DelimiterType,
                    this.TemplateDir);
            }

            try
            {
                Controller controller = new Controller(
                    changeScriptRepository,
                    databaseSchemaVersionManager,
                    doScriptApplier,
                    undoScriptApplier,
                    this.InfoWriter);

                controller.ProcessChangeScripts(this.LastChangeToApply);

                queryExecuter.Close();
            }
            finally
            {
                if (doWriter != null)
                {
                    doWriter.Dispose();
                }

                if (undoWriter != null)
                {
                    undoWriter.Dispose();
                }
            }
        }
Пример #3
0
 public UserRepository(QueryExecuter queryExecuter)
 {
     this.queryExecuter = queryExecuter;
 }
Пример #4
0
        private void manageModeloFlujo(CentroCostos centroCostos, Empresa empresa, DateTime fechaactual)
        {
            StopWatch swGral = new StopWatch($"manageModeloFlujo cc={centroCostos.desc_id} emp={empresa.desc_id} fec={fechaactual}");

            swGral.start();
            int            numInserts = 0;
            Int64          modeloId   = centroCostos.modelo_negocio_flujo_id;
            Modelo_Negocio mn         = new ModeloNegocioDataAccessLayer().GetModelo(modeloId.ToString());

            if (!mn.activo)
            {
                return;
            }

            List <Rubros>                      rubrosDeModelo         = GetRubrosFromModeloId(modeloId);
            Int64                              numRegistrosExistentes = getNumMontosOfTipoCaptura(TipoCapturaFlujo);
            ConcurrentQueue <Rubros>           rubrosSinMontos        = new ConcurrentQueue <Rubros>();
            ConcurrentDictionary <Int32, byte> aniosDefault           = new ConcurrentDictionary <Int32, byte>();

            Parallel.ForEach(rubrosDeModelo, (rubro) =>
            {
                StopWatch sw = new StopWatch(
                    $"consulta_flujo cc.id='{centroCostos.id}',empr.id='{centroCostos.empresa_id}',proy.id='{centroCostos.proyecto_id}',modelo.id='{centroCostos.modelo_negocio_flujo_id}',rubro.id='{rubro.id}'");
                sw.start("getQuerySemanalSums");
                GeneraQry qry   = new GeneraQry("semanal", "itm::text", 2);
                String consulta = qry.getQuerySemanalSums(rubro, centroCostos, empresa, numRegistrosExistentes);
                logger.Debug(
                    "consulta_flujo cc.id='{0}',empr.id='{1}',proy.id='{2}',modelo.id='{3}',rubro.id='{4}', ===>> '{5}'",
                    centroCostos.id, centroCostos.empresa_id, centroCostos.proyecto_id,
                    centroCostos.modelo_negocio_flujo_id, rubro.id, consulta);
                DataTable sumaMontos = new QueryExecuter().ExecuteQuery(consulta);
                sw.stop();
                sw.start("BuildMontosFujo");

                if (sumaMontos.Rows.Count > 0)
                {
                    BuildMontosFujo(sumaMontos, centroCostos, modeloId, rubro.id, fechaactual,
                                    aniosDefault);
                }
                else
                {
                    rubrosSinMontos.Enqueue(rubro);
                }
                sw.stop();
                logger.Info(sw.prettyPrint());
            });

            foreach (var rubro in rubrosSinMontos)
            {
                foreach (var anio in aniosDefault.Keys)
                {
                    MontosConsolidados montos = new MontosConsolidados();
                    montos.anio              = anio;
                    montos.activo            = true;
                    montos.fecha             = fechaactual;
                    montos.mes               = fechaactual.Month;
                    montos.centro_costo_id   = centroCostos.id;
                    montos.empresa_id        = centroCostos.empresa_id;
                    montos.modelo_negocio_id = modeloId;
                    montos.proyecto_id       = centroCostos.proyecto_id;
                    montos.rubro_id          = rubro.id;
                    montos.tipo_captura_id   = TipoCapturaFlujo;
                    insertarMontos(montos);
                }
            }
            swGral.stop();
            logger.Info(swGral.prettyPrint());
        }
Пример #5
0
 public ReportTaskRepository(QueryExecuter queryExecuter)
 {
     this.queryExecuter = queryExecuter;
 }
Пример #6
0
        private void manageModeloContable(CentroCostos centroCostos, Empresa empresa, DateTime fechaactual)
        {
            StopWatch swGral = new StopWatch($"manageModeloContable cc={centroCostos.desc_id} emp={empresa.desc_id} fec={fechaactual}");

            swGral.start();
            int   numInserts = 0;
            Int64 modeloId   = centroCostos.modelo_negocio_id;

            Modelo_Negocio mn = new ModeloNegocioDataAccessLayer().GetModelo(modeloId.ToString());

            if (!mn.activo)
            {
                return;
            }

            List <Rubros> rubrosDeModelo         = GetRubrosFromModeloId(modeloId);
            Int64         numRegistrosExistentes = getNumMontosOfTipoCaptura(TipoCapturaContable);
            GeneraQry     qry = new GeneraQry("balanza", "cuenta_unificada", 12);
            ConcurrentDictionary <Int32, byte> aniosDefecto    = new ConcurrentDictionary <Int32, byte>();
            ConcurrentQueue <Rubros>           rubrosSinMontos = new ConcurrentQueue <Rubros>();

            Parallel.ForEach(rubrosDeModelo, (rubro) =>
            {
                StopWatch sw = new StopWatch(
                    $"consulta_contables cc.id='{centroCostos.id}',empr.id='{centroCostos.empresa_id}',proy.id='{centroCostos.proyecto_id}',modelo.id='{centroCostos.modelo_negocio_flujo_id}',rubro.id='{rubro.id}'");
                sw.start("getQuerySums");
                String consulta = qry.getQuerySums(rubro, centroCostos, empresa, numRegistrosExistentes);

                logger.Debug(
                    "consulta_contables cc.id='{0}',empr.id='{1}',proy.id='{2}',modelo.id='{3}',rubro.id='{4}', ===>> '{5}'",
                    centroCostos.id, centroCostos.empresa_id, centroCostos.proyecto_id, centroCostos.modelo_negocio_id,
                    rubro.id, consulta);

                DataTable sumaMontosDt = new QueryExecuter().ExecuteQuery(consulta);
                sw.stop();
                sw.start("BuildMontosConsolContable");

                if (sumaMontosDt.Rows.Count > 0)
                {
                    foreach (DataRow rubroMontosRow in sumaMontosDt.Rows)
                    {
                        BuildMontosConsolContable(rubroMontosRow, centroCostos, modeloId, rubro.id,
                                                  fechaactual);
                        aniosDefecto.TryAdd(ToInt32(rubroMontosRow["year"]), 1);
                    }
                }
                else
                {
                    rubrosSinMontos.Enqueue(rubro);
                }
                sw.stop();
                logger.Info(sw.prettyPrint());
            });

            foreach (var rubro in rubrosSinMontos)
            {
                foreach (var anio in aniosDefecto.Keys)
                {
                    BuildMontosConsolContable(centroCostos, modeloId, rubro.id,
                                              fechaactual, anio);
                }
            }
            swGral.stop();
            logger.Info(swGral.prettyPrint());
        }
 public QueryExecuterBenchmarkBase(int cacheSize)
 {
     _schema        = SchemaFactory.Create();
     _queryExecuter = new QueryExecuter(_schema, cacheSize);
 }
        public void  AccounLoad()
        {
            try
            {
                string accountUser   = string.Empty;
                string accountPass   = string.Empty;
                string niches        = string.Empty;
                string proxyAddress  = string.Empty;
                string proxyPort     = string.Empty;
                string proxyUserName = string.Empty;
                string proxyPassword = string.Empty;
                //string Useragent = string.Empty;
                string        BoardsName  = string.Empty;
                string        ScreenName  = string.Empty;
                string        LoginStatus = string.Empty;
                string        Followers   = string.Empty;
                string        Following   = string.Empty;
                QueryExecuter QME         = new QueryExecuter();
                DataSet       ds          = QME.getAccount();
                this.Dispatcher.Invoke(new Action(delegate
                {
                    AccountViewModel._listOfAccount.Clear();
                }));
                if (ds.Tables[0].Rows.Count != 0)
                {
                    PDGlobals.listAccounts.Clear();
                    for (int noRow = 0; noRow < ds.Tables[0].Rows.Count; noRow++)
                    {
                        string account = ds.Tables[0].Rows[noRow].ItemArray[0].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[1].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[2].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[3].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[4].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[5].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[6].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[7].ToString();
                        PDGlobals.listAccounts.Add(account);
                        //  dv.AllowNew = false;
                        accountUser   = ds.Tables[0].Rows[noRow].ItemArray[0].ToString();
                        accountPass   = ds.Tables[0].Rows[noRow].ItemArray[1].ToString();
                        niches        = ds.Tables[0].Rows[noRow].ItemArray[2].ToString();
                        proxyAddress  = ds.Tables[0].Rows[noRow].ItemArray[3].ToString();
                        proxyPort     = ds.Tables[0].Rows[noRow].ItemArray[4].ToString();
                        proxyUserName = ds.Tables[0].Rows[noRow].ItemArray[5].ToString();
                        proxyPassword = ds.Tables[0].Rows[noRow].ItemArray[6].ToString();
                        ScreenName    = ds.Tables[0].Rows[noRow].ItemArray[9].ToString();
                        Followers     = ds.Tables[0].Rows[noRow].ItemArray[7].ToString();
                        Following     = ds.Tables[0].Rows[noRow].ItemArray[8].ToString();
                        LoginStatus   = ds.Tables[0].Rows[noRow].ItemArray[10].ToString();

                        // Accounts objPinInterestUser = new Accounts();
                        PinInterestUser objPinInterestUser = new PinInterestUser("", "", "", "");
                        objPinInterestUser.Username      = accountUser;
                        objPinInterestUser.Password      = accountPass;
                        objPinInterestUser.Niches        = niches;
                        objPinInterestUser.ProxyAddress  = proxyAddress;
                        objPinInterestUser.ProxyPort     = proxyPort;
                        objPinInterestUser.ProxyUsername = proxyUserName;
                        objPinInterestUser.ProxyPassword = proxyPassword;
                        // objPinInterestUser.LoginStatus = LoginStatus;
                        try
                        {
                            AccountNotifyPropertyChanged objAccountNotifyPropertyChanged = new AccountNotifyPropertyChanged();

                            objAccountNotifyPropertyChanged.Username       = accountUser;
                            objAccountNotifyPropertyChanged.Password       = accountPass;
                            objAccountNotifyPropertyChanged.Niche          = niches;
                            objAccountNotifyPropertyChanged.ScreenName     = ScreenName;
                            objAccountNotifyPropertyChanged.FollowerCount  = Followers;
                            objAccountNotifyPropertyChanged.FollowingCount = Following;
                            objAccountNotifyPropertyChanged.ProxyAddress   = proxyAddress;
                            objAccountNotifyPropertyChanged.ProxyPassword  = proxyPassword;
                            objAccountNotifyPropertyChanged.ProxyPort      = proxyPort;
                            objAccountNotifyPropertyChanged.ProxyUserName  = proxyUserName;
                            if (LoginStatus.Contains("Success"))
                            {
                                objAccountNotifyPropertyChanged.LoginStatus     = "Success";
                                objAccountNotifyPropertyChanged.BackgroundColor = "Green";
                                this.Dispatcher.Invoke(new Action(delegate
                                {
                                    AccountViewModel._listOfAccount.Add(objAccountNotifyPropertyChanged);
                                }));
                            }
                            else if (LoginStatus.Contains("Fail"))
                            {
                                objAccountNotifyPropertyChanged.LoginStatus     = "Fail";
                                objAccountNotifyPropertyChanged.BackgroundColor = "Red";
                                this.Dispatcher.Invoke(new Action(delegate
                                {
                                    AccountViewModel._listOfAccount.Add(objAccountNotifyPropertyChanged);
                                }));
                            }
                            else if (LoginStatus.Contains("Not"))
                            {
                                objAccountNotifyPropertyChanged.LoginStatus     = "Not Checked";
                                objAccountNotifyPropertyChanged.BackgroundColor = "";
                                this.Dispatcher.Invoke(new Action(delegate
                                {
                                    AccountViewModel._listOfAccount.Add(objAccountNotifyPropertyChanged);
                                }));
                            }
                        }
                        catch (Exception ex)
                        {
                            GlobusLogHelper.log.Error(" Error :" + ex.StackTrace);
                        }


                        try
                        {
                            PDGlobals.loadedAccountsDictionary.Add(objPinInterestUser.Username, objPinInterestUser);
                            try
                            {
                                this.Dispatcher.Invoke(new Action(delegate
                                {
                                    // dgvAccounts.ItemsSource = ds.Tables[0].DefaultView;
                                    dgvAccounts.ItemsSource = AccountViewModel._listOfAccount;
                                    // AccountViewModel._listOfAccount.Clear();
                                }));
                            }
                            catch (Exception ex)
                            { };
                        }
                        catch (Exception ex)
                        { };
                    }
                    try
                    {
                        this.Dispatcher.Invoke(new Action(delegate
                        {
                            // dgvAccounts.ItemsSource = ds.Tables[0].DefaultView;
                            dgvAccounts.ItemsSource = AccountViewModel._listOfAccount;
                            //AccountViewModel._listOfAccount.Clear();
                        }));
                    }
                    catch { };
                    GlobusLogHelper.log.Info(" => [ " + PDGlobals.listAccounts.Count + " Accounts Loaded ]");
                }
                else
                {
                    this.Dispatcher.Invoke(new Action(delegate
                    {
                        //dgvAccounts.ItemsSource = ds.Tables[0].DefaultView;
                        dgvAccounts.ItemsSource = AccountViewModel._listOfAccount;
                        // AccountViewModel._listOfAccount.Clear();
                    }));
                    GlobusLogHelper.log.Info(" [  No Accounts Loaded ]");
                }
            }
            catch (Exception ex)
            {
                GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
            }
        }
Пример #9
0
        /// <summary>
        /// Executes the a database deployment with the specified config.
        /// </summary>
        /// <param name="config">The config.</param>
        /// <param name="infoWriter">The info writer.</param>
        /// <exception cref="System.InvalidOperationException">SQLCMD mode can only be applied against an mssql database.</exception>
        public void Execute(DbDeployConfig config, TextWriter infoWriter)
        {
            this.Validate(config, infoWriter);

            infoWriter.WriteLine();
            infoWriter.WriteLine("==========================================================");
            infoWriter.WriteLine(this.GenerateWelcomeString());

            var factory = new DbmsFactory(config.Dbms, config.ConnectionString, config.DllPathConnector);

            var dbmsSyntax = factory.CreateDbmsSyntax();

            var queryExecuter = new QueryExecuter(factory);
            var databaseSchemaVersionManager = new DatabaseSchemaVersionManager(queryExecuter, dbmsSyntax, config.ChangeLogTableName);

            IChangeScriptApplier doScriptApplier;
            TextWriter doWriter = null;
            QueryExecuter applierExecutor = null;

            if (config.OutputFile != null)
            {
                doWriter = new StreamWriter(config.OutputFile.OpenWrite(), config.Encoding);

                doScriptApplier = new TemplateBasedApplier(
                    doWriter,
                    dbmsSyntax,
                    config.ChangeLogTableName,
                    config.Delimiter,
                    config.DelimiterType,
                    config.TemplateDirectory);
            }
            else if (config.UseSqlCmd)
            {
                // Verify database is MSSQL.
                if (!string.Equals(config.Dbms, SupportedDbms.MSSQL, StringComparison.InvariantCultureIgnoreCase))
                {
                    throw new InvalidOperationException("SQLCMD mode can only be applied against an mssql database.");
                }

                doScriptApplier = new SqlCmdApplier(
                    config.ConnectionString,
                    databaseSchemaVersionManager,
                    dbmsSyntax,
                    config.ChangeLogTableName,
                    infoWriter);
            }
            else
            {
                var splitter = new QueryStatementSplitter
                {
                    Delimiter = config.Delimiter,
                    DelimiterType = config.DelimiterType,
                    LineEnding = config.LineEnding,
                };

                // Do not share query executor between schema manager and applier, since a failure in one will effect the other.
                applierExecutor = new QueryExecuter(factory);
                doScriptApplier = new DirectToDbApplier(
                    applierExecutor,
                    databaseSchemaVersionManager,
                    splitter,
                    dbmsSyntax,
                    config.ChangeLogTableName,
                    infoWriter);
            }

            IChangeScriptApplier undoScriptApplier = null;
            TextWriter undoWriter = null;

            if (config.UndoOutputFile != null)
            {
                undoWriter = new StreamWriter(config.UndoOutputFile.OpenWrite(), config.Encoding);

                undoScriptApplier = new UndoTemplateBasedApplier(
                    undoWriter,
                    dbmsSyntax,
                    config.ChangeLogTableName,
                    config.Delimiter,
                    config.DelimiterType,
                    config.TemplateDirectory);
            }

            try
            {
                var changeScriptRepositoryFactory = new ChangeScriptRepositoryFactory(config, infoWriter);
                var changeScriptRepository = changeScriptRepositoryFactory.Obter();
                var repositorioScripts = new RepositorioScripts(databaseSchemaVersionManager, changeScriptRepository);

                var controller = new Controller(
                                        repositorioScripts,
                                        databaseSchemaVersionManager,
                                        doScriptApplier,
                                        undoScriptApplier,
                                        config.AutoCreateChangeLogTable,
                                        infoWriter);

                controller.ProcessChangeScripts(config.LastChangeToApply, config.ForceUpdate);

                queryExecuter.Close();

                if (applierExecutor != null)
                {
                    applierExecutor.Close();
                }
            }
            finally
            {
                if (doWriter != null)
                {
                    doWriter.Dispose();
                }

                if (undoWriter != null)
                {
                    undoWriter.Dispose();
                }
            }
        }
Пример #10
0
        public string Follow(string UserName, ref InstagramAccountManager accountManager)
        {
            NameValueCollection nameval = new NameValueCollection();

            //ChilkatHttpHelpr chilaktHttpHelper = new ChilkatHttpHelpr();
            if (!UserName.Contains("http://websta.me/n/"))
            {
                UserName = "******" + UserName + "/";
            }
            string UserPageContent = string.Empty;


            if (!string.IsNullOrEmpty(accountManager.proxyAddress) && !string.IsNullOrEmpty(accountManager.proxyPort))
            {
                try
                {
                    UserPageContent = accountManager.httpHelper.getHtmlfromUrlProxy(new Uri(UserName), accountManager.proxyAddress, Convert.ToInt32(accountManager.proxyPort), accountManager.proxyUsername, accountManager.proxyPassword);
                }
                catch (Exception ex)
                {
                }
                if (string.IsNullOrEmpty(UserPageContent))
                {
                    Thread.Sleep(1000);
                    try
                    {
                        UserPageContent = accountManager.httpHelper.getHtmlfromUrlProxy(new Uri(UserName), accountManager.proxyAddress, Convert.ToInt32(accountManager.proxyPort), accountManager.proxyUsername, accountManager.proxyPassword);
                    }
                    catch (Exception ex)
                    {
                    }
                }
            }
            else
            {
                try
                {
                    UserPageContent = accountManager.httpHelper.getHtmlfromUrlProxy(new Uri(UserName), "", 80, "", "");
                }
                catch { };

                if (string.IsNullOrEmpty(UserPageContent))
                {
                    Thread.Sleep(1000);
                    try
                    {
                        UserPageContent = accountManager.httpHelper.getHtmlfromUrlProxy(new Uri(UserName), "", 80, "", "");
                    }
                    catch { };
                }
            }


            try
            {
                //if (UserPageContent.Contains("This user is private."))
                //{
                //    return "private";
                //}
                string PK = string.Empty;
                if (UserPageContent.Contains(""))
                {
                    PK = getBetween(UserPageContent, "id=\"follow_btn_wrapper\"", ">").Replace("data-target=", "").Replace("\"", "").Trim();
                }

                if (string.IsNullOrEmpty(PK))
                {
                    PK = getBetween(UserPageContent, "id=\"message_user_id", ">").Replace(">", "").Replace("value=", string.Empty).Replace("\"", string.Empty).Trim();//.Replace("\"", "").Trim();
                }

                string PostData           = "action=follow";//"&pk=" + PK + "&t=9208";
                string FollowedPageSource = string.Empty;

                if (!string.IsNullOrEmpty(PK))
                {
                    try
                    {
                        FollowedPageSource = accountManager.httpHelper.postFormData(new Uri("http://websta.me/api/relationships/" + PK), PostData, UserName, "http://websta.me");
                    }
                    catch { }
                }
                if (string.IsNullOrEmpty(FollowedPageSource))
                {
                }
                nameval.Add("Origin", "http://web.stagram.com");
                nameval.Add("X-Requested-With", "XMLHttpRequest");


                if (FollowedPageSource.Contains("OK"))
                {
                    //return "Followed";
                    string status = string.Empty;
                    try
                    {
                        status = QueryExecuter.getFollowStatus(accountManager.Username, UserName);
                    }
                    catch { }
                    switch (status)
                    {
                    case "Followed": status = "Already Followed";
                        break;

                    case "Unfollowed": status = "Unfollowed";
                        QueryExecuter.updateFollowStatus(accountManager.Username, UserName, "Followed");
                        break;

                    default: status = "Followed";
                        try
                        {
                            QueryExecuter.insertFollowInfo(accountManager.Username, UserName, "Followed");
                        }
                        catch { }
                        break;
                    }
                    return(status);
                }
                else
                {
                    return("UnFollowed");
                }
            }
            catch (Exception)
            {
                return("Follow option is not available In page...!!");
            }
        }
 protected virtual String GetCellSetDescription(String query)
 {
     System.Diagnostics.Trace.TraceInformation("Ranet.Olap.Core.Providers.OlapProvider execute MDX query: {0} \r\n", query);
     return(QueryExecuter.GetCellSetDescription(query));
 }
Пример #12
0
        public void loaddatafmdb()
        {
            try
            {
                DataTable NewDt2 = CreateUrltable();
                QueryExecuter Qm = new QueryExecuter();
                DataSet ds = Qm.getAccount();

                DataTable dt = ds.Tables[0];
                List<string> BunchList = new List<string>();
                int itemCounter = 0;

                foreach (DataRow item in dt.Rows)
                {
                    try
                    {
                        DataRow newdr = NewDt2.NewRow();
                        string Username = item["Username"].ToString();
                        string Password = item["Password"].ToString();
                        string proxyAddress = item["IPAddress"].ToString();
                        string proxyPort = item["IPPort"].ToString();
                        string proxyUsername = item["IPUsername"].ToString();
                        string proxyPassword = item["IPPassword"].ToString();
                        string Path = item["Path"].ToString();

                        newdr["Username"] = Username;
                        newdr["Password"] = Password;
                        newdr["IPAddress"] = proxyAddress;
                        newdr["IPPort"] = proxyPort;
                        newdr["IPUsername"] = proxyUsername;
                        newdr["IPPassword"] = proxyPassword;
                        newdr["Path"] = Path;

                        ClGlobul.lstUrls.Add(Username);
                        ClGlobul.lstUrls.Add(Password);
                        ClGlobul.lstUrls.Add(proxyAddress);
                        ClGlobul.lstUrls.Add(proxyPort);
                        ClGlobul.lstUrls.Add(proxyUsername);
                        ClGlobul.lstUrls.Add(proxyPassword);
                        ClGlobul.lstUrls.Add(Path);

                        NewDt2.Rows.Add(newdr);
                    }
                    catch { };
                }

                if (this.InvokeRequired)
                {
                    this.Invoke(new MethodInvoker(delegate
                    {
                        dgvAccount.DataSource = NewDt2;
                    }));
                }
                else
                {
                    dgvAccount.DataSource = NewDt2;
                }

            }
            catch { };
        }
Пример #13
0
        public void loadAccount()
        {
            string path = string.Empty;
            try
            {
                QueryExecuter qm1 = new QueryExecuter();
                DataSet ds = qm1.getAccount();
                if (ds.Tables[0].Rows.Count != 0)
                {
                    try
                    {
                        path = ds.Tables[0].Rows[0].ItemArray[6].ToString();
                        if (!string.IsNullOrEmpty(path))
                        {
                            try
                            {
                                txtAddAccounts1.Text = path;
                            }
                            catch { };
                        }
                    }
                    catch { }

                    for (int noRow = 0; noRow < ds.Tables[0].Rows.Count; noRow++)
                    {
                        string account = ds.Tables[0].Rows[noRow].ItemArray[0].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[1].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[2].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[3].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[4].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[5].ToString();
                        ClGlobul.accountList.Add(account);
                    }
                    AddToLogger("[ " + DateTime.Now + " ] => [ " + ClGlobul.accountList.Count + " Accounts Loaded ]");
                }
                else
                {
                    AddToLogger("[ " + DateTime.Now + " ] => [  No Accounts Loaded ]");
                }
            }

            catch (Exception ex)
            {
                AddToLogger("[ " + DateTime.Now + " ] => [  No Accounts Loaded ]");
            }

            DataTable dt = new DataTable();
            dt.Columns.Add("Username");
            dt.Columns.Add("Password");
            dt.Columns.Add("proxyAddress");
            dt.Columns.Add("proxyPort");
            dt.Columns.Add("proxyUsername");
            dt.Columns.Add("proxyPassword");
            dt.Columns.Add("Path");
        }
Пример #14
0
 public TeamRepository(QueryExecuter queryExecuter)
 {
     this.queryExecuter = queryExecuter;
 }
Пример #15
0
 public DBManagerTest()
 {
     exe       = new QueryExecuter(DB_INFO[0], DB_INFO[1], DB_INFO[2], DB_INFO[3], DB_INFO[4]);
     dbManager = new DBManager(exe);
 }
Пример #16
0
        /// <summary>
        /// Executes the a database deployment with the specified config.
        /// </summary>
        /// <param name="config">The config.</param>
        /// <param name="infoWriter">The info writer.</param>
        /// <exception cref="System.InvalidOperationException">SQLCMD mode can only be applied against an mssql database.</exception>
        public void Execute(DbDeployConfig config, TextWriter infoWriter)
        {
            this.Validate(config, infoWriter);

            infoWriter.WriteLine();
            infoWriter.WriteLine("==========================================================");
            infoWriter.WriteLine(this.GenerateWelcomeString());

            var factory = new DbmsFactory(config.Dbms, config.ConnectionString);

            var dbmsSyntax = factory.CreateDbmsSyntax();

            var queryExecuter = new QueryExecuter(factory);

            var databaseSchemaVersionManager = new DatabaseSchemaVersionManager(queryExecuter, dbmsSyntax, config.ChangeLogTableName, config.AutoCreateChangeLogTable);

            var scanner = new DirectoryScanner(infoWriter, config.Encoding);

            var changeScriptRepository = new ChangeScriptRepository(scanner.GetChangeScriptsForDirectory(config.ScriptDirectory));

            IChangeScriptApplier doScriptApplier;
            TextWriter           doWriter        = null;
            QueryExecuter        applierExecutor = null;

            if (config.OutputFile != null)
            {
                doWriter = new StreamWriter(config.OutputFile.OpenWrite(), config.Encoding);

                doScriptApplier = new TemplateBasedApplier(
                    doWriter,
                    config.Dbms,
                    config.ChangeLogTableName,
                    config.Delimiter,
                    config.DelimiterType,
                    config.TemplateDirectory);
            }
            else if (config.UseSqlCmd)
            {
                // Verify database is MSSQL.
                if (!string.Equals(config.Dbms, "mssql", StringComparison.InvariantCultureIgnoreCase))
                {
                    throw new InvalidOperationException("SQLCMD mode can only be applied against an mssql database.");
                }

                doScriptApplier = new SqlCmdApplier(config.ConnectionString, databaseSchemaVersionManager, infoWriter);
            }
            else
            {
                var splitter = new QueryStatementSplitter
                {
                    Delimiter     = config.Delimiter,
                    DelimiterType = config.DelimiterType,
                    LineEnding    = config.LineEnding,
                };

                // Do not share query executor between schema manager and applier, since a failure in one will effect the other.
                applierExecutor = new QueryExecuter(factory);
                doScriptApplier = new DirectToDbApplier(
                    applierExecutor,
                    databaseSchemaVersionManager,
                    splitter,
                    infoWriter);
            }

            IChangeScriptApplier undoScriptApplier = null;
            TextWriter           undoWriter        = null;

            if (config.UndoOutputFile != null)
            {
                undoWriter = new StreamWriter(config.UndoOutputFile.OpenWrite(), config.Encoding);

                undoScriptApplier = new UndoTemplateBasedApplier(
                    undoWriter,
                    config.Dbms,
                    config.ChangeLogTableName,
                    config.Delimiter,
                    config.DelimiterType,
                    config.TemplateDirectory);
            }

            try
            {
                var controller = new Controller(
                    changeScriptRepository,
                    databaseSchemaVersionManager,
                    doScriptApplier,
                    undoScriptApplier,
                    infoWriter);

                controller.ProcessChangeScripts(config.LastChangeToApply, config.ForceUpdate);

                queryExecuter.Close();

                if (applierExecutor != null)
                {
                    applierExecutor.Close();
                }
            }
            finally
            {
                if (doWriter != null)
                {
                    doWriter.Dispose();
                }

                if (undoWriter != null)
                {
                    undoWriter.Dispose();
                }
            }
        }
Пример #17
0
        void RunPhase1()
        {
            MainIndex = new PositionalIndex();

            IndexEnglishFiles();
            //IndexPersianFiles();

            var tokenRepeats = MainIndex.GetAllTokensRepeats()
                               .OrderByDescending(x => x.repeatCount)
                               .ToList();

            Console.WriteLine(string.Join(",", tokenRepeats));
            Console.WriteLine("Unique Token count is: " + tokenRepeats.Count);


            WriteInFile(MainIndex, "MainIndex");
            GenerateBiword();

            while (true)
            {
                Console.WriteLine("Enter your command: [query|proximity(windowSize)|and|compress|decompress|info(word)]");
                var command      = Console.ReadLine();
                var commandWords = command.Split(' ');

                if (command == "and" || command == "a" || command == "q" || command == "query" || commandWords.First() == "p" || commandWords.First() == "proximity")
                {
                    Console.WriteLine("Enter your query: ");
                    var query = Console.ReadLine();

                    if (string.IsNullOrEmpty(query))
                    {
                        Console.WriteLine("Your query is empty.");
                        continue;
                    }

                    var queryExecuter = new QueryExecuter(query, MainIndex);

                    List <SearchResult> result = null;
                    if (command == "and" || command == "a")
                    {
                        result = queryExecuter.ExecuteAndSearch();
                    }
                    else
                    {
                        if (commandWords.First() == "p" || commandWords.First() == "proximity")
                        {
                            result = queryExecuter.ExecuteTfIdfSearch(Convert.ToInt32(commandWords[1]));
                        }
                        else
                        {
                            result = queryExecuter.ExecuteTfIdfSearch();
                        }
                    }



                    Console.WriteLine("Query after preprocess: " + JsonConvert.SerializeObject(queryExecuter.Query));
                    Console.WriteLine(string.Join(Environment.NewLine, result));
                    Console.WriteLine("---------------------------------" + Environment.NewLine);

                    Console.WriteLine("Enter classification filter: [1|2|3|4|no filter(Enter)]");
                    var  classFilterLine = Console.ReadLine();
                    byte classFilter     = Convert.ToByte(classFilterLine);

                    queryExecuter = new QueryExecuter(query, MainIndex);
                    result        = queryExecuter.ExecuteTfIdfSearch(null, classFilter);
                    Console.WriteLine(string.Join(Environment.NewLine, result));
                    Console.WriteLine("---------------------------------" + Environment.NewLine);
                }
                else if (command.StartsWith("info"))
                {
                    var word = command.Split(' ')[1];

                    Console.WriteLine(MainIndex.GetWordInfo(word));
                }
                else if (command.Contains("compress"))
                {
                    Console.WriteLine("Enter compress mode: [gamma|varbyte]");
                    var modeStr = Console.ReadLine();
                    CompressUtility.Mode = (CompressMode)Enum.Parse(typeof(CompressMode), modeStr);

                    if (command.StartsWith("de"))
                    {
                        Decompress();
                    }
                    else
                    {
                        Compress();
                    }
                }
            }
        }