public void DeleteCampaignScraperData(string query) { try { DataBaseHandler.DeleteQuery(query, "tb_CampaignScraper"); } catch { } }
public void InsertUrl(string query) { try { DataBaseHandler.InsertQuery(query, "tb_CampaignScraperURL"); } catch { } }
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"); }
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) { } }
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) { } }
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); } }
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); } }