public void InsertUpdateFBAccount(string Username, string password, string proxiaddress, string proxyport, string proxyName, string proxypassword, string friendcount, string profilename) { try { this.strUsernaem = Username; this.strPassword = password; this.strProxiaddress = proxiaddress; this.strProxyport = proxyport; this.strProxyName = proxyName; this.strProxypassword = proxypassword; this.strProfileStatus = ""; string strQuery = "INSERT INTO tb_LinkedInAccount VALUES ('" + Username + "','" + password + "','" + proxiaddress + "','" + proxyport + "','" + proxyName + "','" + proxypassword + "','" + friendcount + "','" + profilename + "','" + strProfileStatus + "') "; DataBaseHandler.InsertQuery(strQuery, "tb_LinkedInAccount"); } catch (Exception) { try { UpdateFBAccount(strUsernaem, strPassword, strProxiaddress, strProxyport, strProxyName, strProxypassword); } catch { } } }
public static bool InsertIntoDB(string Username, string FriendID, string MessageType) { bool Result = false; DataBaseHandler.InsertQuery("Insert into WallPosterUnique(Username,FriendID,MessageType,Status) Values('" + Username + "','" + FriendID + "','" + MessageType + "','Posted')", "WallPosterUnique"); return(Result); }
public void AddAccountInDataBase(string accountUser, string accountPass, string proxyAddress, string proxyPort, string proxyUserName, string proxyPassword, string Path) { string strProfileStatus = string.Empty; string strQuery = "INSERT INTO AccountInfo (Username, Password, ProxyAddress, ProxyPort, ProxyUsername, ProxyPassword, Path, LogInStatus, Posts , Followers, Followings , Authorized, Status) VALUES ('" + accountUser + "','" + accountPass + "','" + proxyAddress + "','" + proxyPort + "', '" + proxyUserName + "','" + proxyPassword + "','" + Path + "','" + "" + "' , '" + "" + "' ,'" + "" + "','" + "" + "' ,'" + "" + "','" + "" + "')"; DataBaseHandler.InsertQuery(strQuery, "AccountInfo"); }
/// <summary> /// Inserts Settings in DataBase /// Updates if Settings already present /// </summary> /// <param name="module"></param> /// <param name="filetype"></param> /// <param name="filepath"></param> /// #region Comment //public void InsertOrUpdateSetting(string module, string filetype, string filepath) //{ // try // { // this.Upmodule = module; // this.Upfiletype = filetype; // this.Upfilepath = filepath; // string Upmodule = module; // string UPfiletype = filetype; // string strQuery = "INSERT INTO tb_Setting VALUES ('" + module + "','" + filetype + "','" + filepath + "') "; // DataBaseHandler.InsertQuery(strQuery, "tb_Setting"); // } // catch (Exception) // { // UpdateSettingData(Upmodule, Upfiletype, Upfilepath); // } //} #endregion public void AddAccountInDataBase(string accountUser, string accountPass, string niches, string proxyAddress, string proxyPort, string proxyUserName, string proxyPassword, string ScreenName, string LoginStatus) { string strProfileStatus = string.Empty; string strQuery = "INSERT INTO tb_emails (Username, Password, Niches, proxyAddress, proxyPort, proxyUsername, proxyPassword, UserAgent, Follower, Following , BOARDS, BoardsName, ScreenName, LoginStatus) VALUES ('" + accountUser + "','" + accountPass + "', '" + niches + "' ,'" + proxyAddress + "','" + proxyPort + "', '" + proxyUserName + "','" + proxyPassword + "','" + " " + "','" + " " + "','" + " " + "','" + " ," + "','" + "," + "," + " " + "','" + ScreenName + "','" + LoginStatus + "' )"; //"Insert into tb_emails values('" + accountUser + "','" + accountPass.Replace("\0", "") + "', '" + niches + "', '" + proxyAddress + "','" + proxyPort + "','" + proxyUserName + "','" + proxyPassword + "','" + Useragent + "','" + " " + "','" + " " + "','" + " ," + "','" + "," + "," + BoardNames + "','" + ScreenName + "')", "tb_emails"); DataBaseHandler.InsertQuery(strQuery, "tb_emails"); }
//public void DeleteDecaptcherData(string strDecaptcher) //{ // try // { // string strTable = "tb_Setting"; // string strQuery = "DELETE FROM tb_Setting WHERE FileType=" + strDecaptcher; // DataBaseHandler.DeleteQuery(strQuery, strTable); // } // catch (Exception) // { // } //} public static void InsertQueryForEndorsement(string query) { try { DataBaseHandler.InsertQuery(query, "tb_endorsement"); } 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 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 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 DeleteScrapeSettings() { try { string strQuery = "DELETE From tb_ScrapeData"; DataBaseHandler.InsertQuery(strQuery, "tb_ScrapeData"); } catch (Exception ex) { } }
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 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 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 insertBoard_AddBoardName(string accUser, string module, string BoardName, string status) { try { string insertBoard = "Insert into tb_AccountReport (AccountName, ModuleName, BoardName, Status) values ( '" + accUser + "', '" + module + "', '" + BoardName + "', '" + status + "')"; DataBaseHandler.InsertQuery(insertBoard, "tb_AccountReport"); } catch (Exception ex) { GlobusLogHelper.log.Error(" Error :" + ex.StackTrace); } }
public void InsertOrUpdateScrapeSetting(string userId, string username, string TweetId) { try { string strQuery = "INSERT INTO tb_ScrapeData (Userid , Username , TweetId) VALUES ('" + userId + "' , '" + username + "' , '" + TweetId + "')"; DataBaseHandler.InsertQuery(strQuery, "tb_ScrapeData"); } catch (Exception ex) { Globussoft.GlobusFileHelper.AppendStringToTextfileNewLine("Error --> InsertUpdateSetting --> ScrapeData --> clsDBQueryManager --> " + ex.Message, Globals.Path_TwtErrorLogs); } }
public void DeleteScrapeSettings() { try { string strQuery = "DELETE From tb_ScrapeData"; DataBaseHandler.InsertQuery(strQuery, "tb_ScrapeData"); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
public void InsertDataRetweet(string Username, string RetweetUsername, string Tweet) { try { Tweet = StringEncoderDecoder.Encode(Tweet); string strQuery = "INSERT INTO tb_RetweetData (Username , RetweetUsername , Tweet , DateTime) VALUES ('" + Username + "' , '" + RetweetUsername + "' , '" + Tweet + "' ,'" + DateTime.Now.ToString() + "')"; DataBaseHandler.InsertQuery(strQuery, "tb_RetweetData"); } catch (Exception ex) { } }
public void insertAccRePort(string AccountName, string Module, string Pin, string BoardName, string Username, string Msg, string Keyword, string ImageUrl, string status, string NewEmail, string NewPasssword, DateTime DateTime) { try { string insertQuery = "Insert into tb_AccountReport (AccountName, ModuleName, PinNo, BoardName, UserName, Message, Keyword, ImageUrl, Status, NewEmail, NewPassword, DateAndTime) values ( '" + AccountName + "', '" + Module + "', '" + Pin + "', '" + BoardName + "', '" + Username + "', '" + Msg + "', '" + Keyword + "', '" + ImageUrl + "', '" + status + "', '" + NewEmail + "', '" + NewPasssword + "', '" + DateTime + "')"; DataBaseHandler.InsertQuery(insertQuery, "tb_AccountReport"); } catch (Exception ex) { GlobusLogHelper.log.Error(" Error :" + ex.StackTrace); } }
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 InsertCamapaignData(string query, string table) { try { //string strQuery = "INSERT INTO tb_MessageRecord (Username , Type , OtherUsername , Message , DateTime ) VALUES ('" + Username + "' , '" + Type + "' , '" + OtherUsername + "' , '" + Message + "' , '" + DateTime.Today.ToString() + "') "; DataBaseHandler.InsertQuery(query, table); } 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 InsertAccountsDetailsSetting(string Usename, string ProfileId, string Date, int DailyCount) { try { string strQuery = "INSERT INTO tb_AccountsDetails (Usename , ProfileId , Date,DailyCount) VALUES ('" + Usename + "' , '" + ProfileId + "' , '" + Date + "' , '" + DailyCount + "')"; DataBaseHandler.InsertQuery(strQuery, "tb_AccountsDetails"); } catch (Exception ex) { //BaseLib.GlobusFileHelper.AppendStringToTextfileNewLine("Error --> InsertUpdateSetting --> ScrapeData --> clsDBQueryManager --> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_TwtErrorLogs); } }
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 InsertMessageData(string Username, string Type, string OtherUsername, string Message) { try { string strQuery = "INSERT INTO tb_MessageRecord (Username , Type , OtherUsername , Message , DateTime ) VALUES ('" + Username + "' , '" + Type + "' , '" + OtherUsername + "' , '" + Message + "' , '" + DateTime.Today.ToString() + "') "; DataBaseHandler.InsertQuery(strQuery, "tb_MessageRecord"); } 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 insertAccReportScrapeUser(string Module, string UserName, string status, DateTime DateAndTime) { try { string insertQuery = "Insert into tb_AccReportScrapeUser (ModuleName, UserName, Status, DateTime) values ('" + Module + "', '" + UserName + "','" + status + "', '" + DateAndTime + "')"; DataBaseHandler.InsertQuery(insertQuery, "tb_AccountReport"); } catch (Exception ex) { GlobusLogHelper.log.Error(" Error :" + ex.StackTrace); } }
public void InsertDBCData(string username, string DeathByCaptcha, string password) { try { string strQuery = "INSERT INTO tb_Setting VALUES ('" + username + "','" + DeathByCaptcha + "','" + password + "') "; DataBaseHandler.InsertQuery(strQuery, "tb_Setting"); } catch (Exception) { UpdateSettingData(Upmodule, Upfiletype, Upfilepath); } }
public void InsertUpdateTBSchedulerSetting(string ModuleName, string filePath, string count, string DescriptionFile, string SchedulerStartTime, string SchedulerEndTime, int mindelay, int maxdelay) { try { string InsertQuery = "Insert into tb_Schedule_Setting (ModuleType, FileName, Count , DescriptionFile , SchedulerStartTime ,SchedulerEndTime , MinDelay , MaxDelay ) VALUES ('" + ModuleName + "','" + filePath + "', '" + count + "' , '" + DescriptionFile + "' ,'" + SchedulerStartTime + "' , '" + SchedulerEndTime + "' , '" + mindelay + "' , '" + maxdelay + "')"; DataBaseHandler.InsertQuery(InsertQuery, "tb_Schedule_Setting"); } catch (Exception) { string UpdateQuery = "UPDATE tb_Schedule_Setting SET FileName='" + filePath + "' , Count = '" + count + "' , DescriptionFile = '" + DescriptionFile + "' ,SchedulerStartTime = '" + SchedulerStartTime + "' , SchedulerEndTime = '" + SchedulerEndTime + "' , MinDelay = '" + mindelay + "' , MaxDelay = '" + maxdelay + "' WHERE ModuleType ='" + ModuleName + "'"; DataBaseHandler.UpdateQuery(UpdateQuery, "tb_Schedule_Setting"); } }
public void InsertDecaptcherData(string server, string port, string username, string password, string Decaptcher) { try { string strQuery = "INSERT INTO tb_Setting VALUES ('" + server + "<:>" + port + "','" + Decaptcher + "','" + username + "<:>" + password + "') "; DataBaseHandler.InsertQuery(strQuery, "tb_Setting"); } catch (Exception) { UpdateSettingData(Upmodule, Upfiletype, Upfilepath); } }