Beispiel #1
0
 public void DeleteCampaignScraperData(string query)
 {
     try
     {
         DataBaseHandler.DeleteQuery(query, "tb_CampaignScraper");
     }
     catch
     { }
 }
Beispiel #2
0
 public void InsertUrl(string query)
 {
     try
     {
         DataBaseHandler.InsertQuery(query, "tb_CampaignScraperURL");
     }
     catch
     { }
 }
Beispiel #3
0
 public void InsertCampaignScraperData(string query, string table)
 {
     try
     {
         DataBaseHandler.InsertQuery(query, table);
     }
     catch
     { }
 }
 public static void deleteQuery()
 {
     try
     {
         string DeleteQuery = "Delete from tb_emails";
         DataBaseHandler.DeleteQuery(DeleteQuery, "tb_emails");
     }
     catch (Exception ex)
     { }
 }
 public static void insertCommentedPinDetails(string Username, string pin, string DateTime)
 {
     try
     {
         string query = "insert into tb_CommentedPinDetails(AccUsename,PinId,DateTime) values('" + Username + "','" + pin + "','" + DateTime + "')";
         DataBaseHandler.InsertQuery(query, "tb_CommentedPinDetails");
     }
     catch (Exception ex)
     { };
 }
        public void AddAccountInDataBase(string accountUser, string accountPass, string proxyAddress, string proxyPort, string proxyUserName, string proxyPassword)
        {
            string strProfileStatus = string.Empty;
            // string strQuery = "INSERT INTO tb_FBAccount (accountUser, accountPass, ProxyAddress, ProxyPort, ProxyUserName, ProxyPassword, ) VALUES ('" + accountUser + "','" + accountPass + "', '" + "" + "', '' , '" + proxyAddress + "','" + proxyPort + "','" + proxyUserName + "','" + proxyPassword + "','" + "" + "' , '" + "" + "' ,'" + "" + "', '0')";
            //  DataBaseHandler.InsertQuery(strQuery, "tb_FBAccount");

            string Query = "Insert into tb_LinkedInAccount values('" + accountUser + "','" + accountPass + "','" + proxyAddress + "','" + proxyPort + "','" + proxyUserName + "','" + proxyPassword + "')";

            DataBaseHandler.InsertQuery(Query, "tb_LinkedInAccount");
        }
Beispiel #7
0
 public void UpdateCampaignScraperUrl(string Url)
 {
     try
     {
         string UpdateQuery = "UPDATE tb_CampaignScraperURL SET Status = 'Scraped'" + " WHERE Url='" + Url + "'";
         DataBaseHandler.UpdateQuery(UpdateQuery, "tb_CampaignScraperURL");
     }
     catch
     { }
 }
 public static void updatetb_emails(string follower, string followingCount, string BOARDS, string BoardsName, string screen_Name, string Username, string LoginStatus)
 {
     try
     {
         string UpdateQuery = "Update tb_emails set Follower = '" + follower + "',Following = '" + followingCount + "',BOARDS= '" + BOARDS + "',BOARDSNAME='" + BoardsName + "',ScreenName='" + screen_Name + "',LoginStatus='" + LoginStatus + "' where UserName = '******'";
         DataBaseHandler.UpdateQuery(UpdateQuery, "tb_emails");
     }
     catch (Exception ex)
     { };
 }
 public void DeleteFollowDUsernameIDFromTb_User_Followr_Details(string UserInfo)
 {
     try
     {
         string strQuery = "DELETE FROM tb_user_follower_details WHERE followerName='" + UserInfo + "'";
         DataBaseHandler.DeleteQuery(strQuery, "tb_user_follower_details");
     }
     catch (Exception)
     {
     }
 }
 public void DeleteFollowDUsernameID_List(string useremail, string userid)
 {
     try
     {
         string strQuery = "DELETE FROM tb_Follow WHERE username='******' and following_username = '******'";
         DataBaseHandler.DeleteQuery(strQuery, "tb_Follow");
     }
     catch (Exception)
     {
     }
 }
 public void DeleteAccountReport(string module)
 {
     try
     {
         string deleteQuery = "Delete from tb_AccountReport where ModuleName='" + module + "'";
         DataBaseHandler.DeleteQuery(deleteQuery, "tb_AccountReport");
     }
     catch (Exception ex)
     {
     }
 }
 public void DeleteScrapeSettings()
 {
     try
     {
         string strQuery = "DELETE From tb_ScrapeData";
         DataBaseHandler.InsertQuery(strQuery, "tb_ScrapeData");
     }
     catch (Exception ex)
     {
     }
 }
 public void DeletePublicProxyData()
 {
     try
     {
         string strQuery = "DELETE From tb_Proxies WHERE IsPublic = 0";
         DataBaseHandler.DeleteQuery(strQuery, "tb_Proxies");
     }
     catch (Exception ex)
     {
     }
 }
 public static void DeleteAccounts(string username)
 {
     try
     {
         string deleteQuery = "Delete from tb_emails where Username='******'";
         DataBaseHandler.DeleteQuery(deleteQuery, "tb_emails");
     }
     catch (Exception ex)
     {
     }
 }
 public static void deleteFollower(string screen_Name, string unfollower)
 {
     try
     {
         string query = "DELETE FROM  tb_FollowerName where UserName='******' and FollwerName='" + unfollower + "'";
         DataBaseHandler.DeleteQuery(query, "tb_FollowerName");
     }
     catch (Exception ex)
     {
     }
 }
 public void DeleteSelectedRowFromTBScheduler(string id)
 {
     try
     {
         string strQuery = "Delete FROM tb_Scheduler_Module where Id='" + id + "'";
         DataBaseHandler.DeleteQuery(strQuery, "tb_Scheduler_Module");
     }
     catch (Exception)
     {
     }
 }
Beispiel #17
0
 public void InsertUserNameId(string Username, string UserId)
 {
     try
     {
         string strQuery = "INSERT INTO tb_UsernameDetails VALUES ('" + Username + "','" + UserId + "') ";
         DataBaseHandler.InsertQuery(strQuery, "tb_UsernameDetails");
     }
     catch (Exception)
     {
     }
 }
 public static void insertFollowerName(string screen_Name, string follName_item)
 {
     try
     {
         string query = "INSERT INTO  tb_FollowerName (UserName,FollwerName) VALUES ('" + screen_Name + "' ,'" + follName_item + "') ";
         DataBaseHandler.InsertQuery(query, "tb_FollowerName");
     }
     catch (Exception ex)
     {
     }
 }
 public void DeletePrivateIPData()
 {
     try
     {
         string strQuery = "DELETE From tb_IP WHERE IsPublic = 1";
         DataBaseHandler.DeleteQuery(strQuery, "tb_IP");
     }
     catch (Exception ex)
     {
     }
 }
 public void UpdatingPinRecord(string Pin)
 {
     try
     {
         string strQuery = "UPDATE tb_PinRecords SET Use = 'Used' WHERE Pin = '" + Pin + "' ";
         DataBaseHandler.UpdateQuery(strQuery, "tb_PinRecords");
     }
     catch (Exception)
     {
     }
 }
 public void DeleteAccomplishedFromTBScheduler()
 {
     try
     {
         string strQuery = "Delete FROM tb_Scheduler_Module where IsAccomplished='" + "1" + "'";
         DataBaseHandler.DeleteQuery(strQuery, "tb_Scheduler_Module");
     }
     catch (Exception)
     {
     }
 }
 public void InsertPinDesc(string PinID, string Desc, string Username)
 {
     try
     {
         string strQuery = "INSERT INTO tb_EditDescription (PinID , Desc , Username ) VALUES ('" + PinID + "','" + Desc + "','" + Username + "') ";
         DataBaseHandler.InsertQuery(strQuery, "tb_EditDescription");
     }
     catch (Exception)
     {
     }
 }
Beispiel #23
0
 public void InsertSerachWithInviteRecord(string Username, string KeyWord, string InviteSentTo, string InvitationUrl, string InvitationUserId)
 {
     try
     {
         String strQuery = "INSERT INTO  tb_SearchWithInvite(UserName,SearchKeyword, InvitationSendTo, InvitationUrl,InvitationId,InviteDate)"
                           + " VALUES ('" + Username + "','" + KeyWord + "','" + InviteSentTo + "','" + InvitationUrl + "','" + InvitationUserId + "','" + DateTime.Today.ToString() + "')";
         DataBaseHandler.InsertQuery(strQuery, "tb_SearchWithInvite");
     }
     catch (Exception)
     {
     }
 }
 public void InsertOrUpdateFollow(string Username, string FollowedUsername, string keyword)
 {
     try
     {
         string strQuery = "INSERT INTO tb_Follow (Username , FollowedUsername , DateTime , Keyword ) VALUES ('" + Username + "','" + FollowedUsername + "','" + DateTime.Today.ToString() + "' , '" + keyword + "') ";
         DataBaseHandler.InsertQuery(strQuery, "tb_FollowRecord");
     }
     catch (Exception)
     {
         UpdateSettingData(Upmodule, Upfiletype, Upfilepath);
     }
 }
        public void AddingKeywordUrl(string Niches, string Keyword, string BoardId, string BoardName)
        {
            try
            {
                string strQuery = "INSERT INTO tb_KeywordPin (Niches, Keyword, BoardId, PinnedOnBoard) VALUES ('" + Niches + "','" + Keyword + "' , '" + BoardId + "' , '" + BoardName + "')";

                DataBaseHandler.SelectQuery(strQuery, "tb_KeywordPin");
            }
            catch (Exception)
            {
            }
        }
        public void AddingBoardUrl(string BoardUrl, string PinnedonBoard, string BoardId)
        {
            try
            {
                string strQuery = "INSERT INTO tb_BoardUrlRecord (BoardUrl , PinnedOnBoard , BoardId) VALUES ('" + BoardUrl + "','" + PinnedonBoard + "' , '" + BoardId + "')";

                DataBaseHandler.SelectQuery(strQuery, "tb_BoardUrlRecord");
            }
            catch (Exception)
            {
            }
        }
        public void insertRePinRecord(string Username, string Niche, string Repin)
        {
            try
            {
                string strQuery = "INSERT INTO tb_RepinRecord (Username , Niche ,  Repin , DateTime ) VALUES ('" + Username + "','" + Niche + "' , '" + Repin + "' , '" + DateTime.Today.ToString() + "')";

                DataBaseHandler.InsertQuery(strQuery, "tb_RepinRecord");
            }
            catch (Exception)
            {
            }
        }
        public void insertMessageDate(string username, string following_username, string Pin, string Keyword, string Message)
        {
            try
            {
                string strQuery = "INSERT INTO tb_Message (Username , User , Pin , Message ,  DateTime , keyword ) VALUES ('" + username + "','" + following_username.Replace("http://pinterest.com/", "").Replace("/", "") + "' , '" + Pin + "' , '" + Message + "' , '" + DateTime.Today.ToString() + "' ,'" + Keyword + "') ";

                DataBaseHandler.InsertQuery(strQuery, "tb_Message");
            }
            catch (Exception)
            {
            }
        }
        public void insertFollowDate(string username, string following_username, string Keyword)
        {
            try
            {
                string strQuery = "INSERT INTO tb_Follow (Username , Following_Username , Date , Keyword )VALUES ('" + username + "','" + following_username.Replace("http://pinterest.com/", "").Replace("/", "") + "' , '" + DateTime.Today.ToString() + "' ,'" + Keyword + "') ";

                DataBaseHandler.InsertQuery(strQuery, "tb_Follow");
            }
            catch (Exception)
            {
            }
        }
 public void UpdatePasswordForAccount(string userName, string newPassword)
 {
     try
     {
         string UpdateQuery = "update tb_FBAccount set  Password='******' WHERE UserName='******';";
         DataBaseHandler.UpdateQuery(UpdateQuery, "tb_FBAccount");
     }
     catch (Exception ex)
     {
         GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
     }
 }
Beispiel #31
0
        public void ThreadPoolCheckProxies(object parameters)
        {
            try
            {
                Array paramsArray = new object[2];

                paramsArray = (Array)parameters;

                DataRow dr = (DataRow)paramsArray.GetValue(0);

                clsDBQueryManager db = new clsDBQueryManager();

                string proxyAddress = dr[0].ToString();
                string proxyPort = dr[1].ToString();
                string proxyUsername = string.Empty;
                string proxyPassword = string.Empty;
                int IsPublic = 0;
                int Working = 0;

                ProxyChecker pc = new ProxyChecker(proxyAddress, proxyPort, proxyUsername, proxyPassword, 0);
                bool RunningProxy = pc.CheckProxy();

                if (!RunningProxy)
                {
                    DataBaseHandler Db = new DataBaseHandler();
                    DataBaseHandler.DeleteQuery("DELETE FROM tb_Proxies WHERE ProxyAddress ='" + proxyAddress + "' AND ProxyPort ='" + proxyPort + "'", "tb_Proxies");
                }
            }
            catch (Exception ex)
            {
                GlobusFileHelper.AppendStringToTextfileNewLine(DateTime.Now + " --> Error --> ThreadPoolCheckProxies()  --> " + ex.Message, Globals.Path_ProxySettingErroLog);
                GlobusFileHelper.AppendStringToTextfileNewLine("Error --> ThreadPoolCheckProxies() --> " + ex.Message, Globals.Path_TwtErrorLogs);
            }
        }