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 UpdatingPinRecord(string Pin) { try { string strQuery = "UPDATE tb_PinRecords SET Use = 'Used' WHERE Pin = '" + Pin + "' "; DataBaseHandler.UpdateQuery(strQuery, "tb_PinRecords"); } catch (Exception) { } }
public void InsertAccountGroupName(string Username, string GroupName) { try { string strQuery = "UPDATE tb_FBAccount SET GroupName = '" + GroupName + "' WHERE UserName = '******'"; DataBaseHandler.UpdateQuery(strQuery, "tb_FBAccount"); } catch (Exception ex) { Globussoft.GlobusFileHelper.AppendStringToTextfileNewLine("Error --> InsertAccountGroupName --> clsDBQueryManager --> " + ex.Message, Globals.Path_TwtErrorLogs); } }
public void UpdateUserDetailsForDirectMessaging(string Screen_name, string FollowerCount, string FollowingCount, string username, string Password) { try { string strQuery = "UPDATE tb_AccountSendDirectMessage SET Screen_name = '" + Screen_name + "' , FollowerCount = '" + FollowerCount + "', FollowingCount = '" + FollowingCount + "' WHERE UserName = '******'"; DataBaseHandler.UpdateQuery(strQuery, "tb_AccountSendDirectMessage"); } catch (Exception ex) { Console.Write(ex.Message); } }
public void InsertScreenNameFollower(string Screen_name, string FollowerCount, string FollowingCount, string username, string FullProfileName) { try { string strQuery = "UPDATE tb_FBAccount SET Screen_name = '" + Screen_name + "' , FollowerCount = '" + FollowerCount + "', FollowingCount = '" + FollowingCount + "',ProfileName = '" + FullProfileName + "' WHERE UserName = '******'"; DataBaseHandler.UpdateQuery(strQuery, "tb_FBAccount"); } catch (Exception ex) { Globussoft.GlobusFileHelper.AppendStringToTextfileNewLine("Error --> InsertScreenNameFollower --> clsDBQueryManager --> " + ex.Message, Globals.Path_TwtErrorLogs); } }
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 UpdateSuspendedAcc(string username) { try { string strQuery = "UPDATE tb_FBAccount SET Status = 'Suspended' WHERE UserName = '******'"; DataBaseHandler.UpdateQuery(strQuery, "tb_FBAccount"); } catch (Exception ex) { Globussoft.GlobusFileHelper.AppendStringToTextfileNewLine("Error --> InsertScreenNameFollower --> clsDBQueryManager --> " + ex.Message, Globals.Path_TwtErrorLogs); } }
public void InsertUpdateTBScheduler(string username, string module, string strDateTime, string IsScheduledDaily) { try { string InsertQuery = "Insert into tb_Scheduler_Module (Module, ScheduledDateTime, IsAccomplished ,IsScheduledDaily ) VALUES ('" + module + "','" + strDateTime + "', '0' , '" + IsScheduledDaily + "')"; DataBaseHandler.InsertQuery(InsertQuery, "tb_Scheduler_Module"); } catch (Exception) { string UpdateQuery = "UPDATE tb_Scheduler_Module SET ScheduledDateTime='" + strDateTime + "', IsScheduledDaily='" + IsScheduledDaily + "', IsAccomplished='" + "0" + "' WHERE Module='" + module + "'"; DataBaseHandler.UpdateQuery(UpdateQuery, "tb_Scheduler_Module"); } }
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) { Console.WriteLine(ex.StackTrace); //AlibabaScaper.GlobusFileHelper.AppendStringToTextfileNewLine("InsertQuery error" +ex+ ex.StackTrace, MainFrm.Error); } }
public void UpdateGroupName() { try { string strTable = "tb_FBAccount"; string strQuery = "UPDATE tb_FBAccount SET GroupName='" + "" + "' "; DataBaseHandler.UpdateQuery(strQuery, strTable); } catch (Exception) { } }
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 UpdateSettingData(string module, string filetype, string filepath) { try { string strTable = "tb_Setting"; string strQuery = "UPDATE tb_Setting SET Module='" + module + "', FilePath='" + filepath + "' WHERE FileType='" + filetype + "'"; DataBaseHandler.UpdateQuery(strQuery, strTable); } catch (Exception) { } }
public void UpdateSettingData(string module, string filetype, string filepath) { try { string strTable = "tb_Setting"; string strQuery = "UPDATE tb_Setting SET Module='" + module + "', FilePath='" + filepath + "' WHERE FileType='" + filetype + "'"; DataBaseHandler.UpdateQuery(strQuery, strTable); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
public void InsertUpdateFollowTable(string useremail, string following_id, string following_username) { try { string strDateTime = DateTime.Now.ToString(); string strQuery = "INSERT INTO tb_Follow (username, following_id, following_username, DateFollowed) VALUES ('" + useremail + "' , '" + following_id + "' , '" + following_username + "' , '" + strDateTime + "')"; DataBaseHandler.InsertQuery(strQuery, "tb_Follow"); } catch (Exception) { string strQuery = "UPDATE tb_Follow SET username='******', following_id='" + following_id + "', following_username='******' WHERE username='******'"; DataBaseHandler.UpdateQuery(strQuery, "tb_Follow"); } }
public void UpdateFBAccount(string Usernaem, string password, string proxiaddress, string proxyport, string proxyName, string proxypassword) { try { string strTable = "tb_LinkedInAccount"; string strQuery = "UPDATE tb_LinkedInAccount SET Password='******', IPAddress='" + proxiaddress + "', IPPort='" + proxyport + "', IPUserName='******', IPPassword='******' WHERE UserName='******'"; DataBaseHandler.UpdateQuery(strQuery, strTable); } catch (Exception) { throw; } }
private void InsertUpdateDatabase(string status) { try { ///Insert DataBaseHandler.InsertQuery("Insert into tb_FBAccount values('" + Username + "','" + Password + "','" + "" + "','" + "" + "','" + "" + "','" + "" + "','" + "" + "','" + "" + "','" + AccountStatus.Status(ProfileStatus.AccountCreated) + "')", "tb_FBAccount"); } catch (Exception) //If already there, Update { ///Update records in Database string updateQuery = "Update tb_FBAccount SET ProfileStatus='" + status + "' WHERE UserName='******'"; DataBaseHandler.UpdateQuery(updateQuery, "tb_FBAccount"); } }
public void UpdateGroupName() { try { string strTable = "tb_FBAccount"; string strQuery = "UPDATE tb_FBAccount SET GroupName='" + "" + "' "; DataBaseHandler.UpdateQuery(strQuery, strTable); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
public void UpdateSettingData(string module, string filetype, string filepath) { try { string strTable = "tb_Setting"; string strQuery = "INSERT into tb_Setting ( Module, FileType, FilePath) VALUES ('" + module + "' , '" + filetype + "' , '" + filepath + "') "; DataBaseHandler.InsertQuery(strQuery, strTable); } catch (Exception ex) { string strTable = "tb_Setting"; string strQuery = "UPDATE tb_Setting SET Module='" + module + "', FilePath='" + filepath + "' WHERE FileType='" + filetype + "'"; DataBaseHandler.UpdateQuery(strQuery, strTable); } }
public void InsertOrUpdateDailyLimitSetting(int countDailyLimit) { try { DataSet ds = SelectcheckDailyLimit(); if (ds.Tables[0].Rows.Count == 1) { string strQuery = "update tb_checkDailyLimit Set DaillyLimit=('" + countDailyLimit + "')"; DataBaseHandler.UpdateQuery(strQuery, "tb_checkDailyLimit"); } else { string strQuery = "INSERT INTO tb_checkDailyLimit (DaillyLimit) VALUES ('" + countDailyLimit + "')"; DataBaseHandler.InsertQuery(strQuery, "tb_checkDailyLimit"); } } catch (Exception ex) { //BaseLib.GlobusFileHelper.AppendStringToTextfileNewLine("Error --> InsertUpdateSetting --> ScrapeData --> clsDBQueryManager --> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_TwtErrorLogs); } }
public void UpdateTBScheduler(string module) { try { string strTable = "tb_Setting"; string strQuery = "UPDATE tb_Scheduler_Module SET IsAccomplished='" + "1" + "' WHERE Module='" + module + "'"; DataBaseHandler.UpdateQuery(strQuery, strTable); //Increase 1 day if IsScheduledDaily { string selectQuery = "SELECT * FROM tb_Scheduler_Module where Module='" + module + "' and IsAccomplished='1'"; DataSet ds = DataBaseHandler.SelectQuery(selectQuery, strTable); DataTable dt = ds.Tables["tb_Setting"]; foreach (DataRow dRow in dt.Rows) { string strIsScheduledDaily = dRow["IsScheduledDaily"].ToString(); if (strIsScheduledDaily == "1") { string scheduledTime = dRow["ScheduledDateTime"].ToString(); DateTime dt_scheduledTime = DateTime.Parse(scheduledTime); DateTime dt_nextscheduledTime = dt_scheduledTime.AddDays(1); string nextscheduledTime = dt_nextscheduledTime.ToString(); string nextUpdateQuery = "UPDATE tb_Scheduler_Module SET ScheduledDateTime='" + nextscheduledTime + "', IsAccomplished='0" + "' WHERE Module='" + module + "'"; DataBaseHandler.UpdateQuery(nextUpdateQuery, "tb_Setting"); } } } } catch (Exception) { } }
/// <summary> /// Assigns "accountsPerIP" number of proxies to accounts in Database, only picks up only those accounts where IPAddress is Null or Empty /// </summary> public void AssignProxiesToAccounts(List <string> lstProxies, int noOfAccountsPerIP) { try { DataSet ds = new DataSet(); if (noOfAccountsPerIP > 0) { accountsPerIP = noOfAccountsPerIP; } else { MessageBox.Show("You entered invalid Accounts per IP... Default value \"10\" Set"); } using (SQLiteConnection con = new SQLiteConnection(DataBaseHandler.CONstr)) { foreach (string item in lstProxies) { ds.Clear(); string account = item; string IPAddress = string.Empty; string IPPort = string.Empty; string IPUsername = string.Empty; string IPpassword = string.Empty; int DataCount = account.Split(':').Length; if (DataCount == 2) { IPAddress = account.Split(':')[0]; IPPort = account.Split(':')[1]; } else if (DataCount > 2) { IPAddress = account.Split(':')[0]; IPPort = account.Split(':')[1]; IPUsername = account.Split(':')[2]; IPpassword = account.Split(':')[3]; } //using (SQLiteDataAdapter ad = new SQLiteDataAdapter("SELECT * FROM tb_FBAccount WHERE IPAddress = '" + IPAddress + "'", con)) using (SQLiteDataAdapter ad = new SQLiteDataAdapter("SELECT * FROM tb_FBAccount WHERE IPAddress = '" + IPAddress + "' and IPPort = '" + IPPort + "'", con)) { ad.Fill(ds); if (ds.Tables[0].Rows.Count == 0) { ds.Clear(); using (SQLiteDataAdapter ad1 = new SQLiteDataAdapter("SELECT * FROM tb_FBAccount WHERE IPAddress = '" + "" + "' OR IPAddress = '" + null + "'", con)) { ad1.Fill(ds); int count = accountsPerIP; //Set count = accountsPerIP so that it sets max this number of accounts to each IP if (ds.Tables[0].Rows.Count < count) { count = ds.Tables[0].Rows.Count; } for (int i = 0; i < count; i++) { string UpdateQuery = "Update tb_FBAccount Set IPAddress='" + IPAddress + "', IPPort='" + IPPort + "', IPUsername='******', IPpassword='******' WHERE UserName='******'"; DataBaseHandler.UpdateQuery(UpdateQuery, "tb_FBAccount"); } } } } } } } catch (Exception ex) { Globussoft.GlobusFileHelper.AppendStringToTextfileNewLine(DateTime.Now + " --> Error --> IPUtillitesFromDB -- AssignProxiesToAccounts() --> " + ex.Message, Globals.Path_IPSettingErroLog); Globussoft.GlobusFileHelper.AppendStringToTextfileNewLine("Error --> IPUtillitesFromDB -- AssignProxiesToAccounts() --> " + ex.Message, Globals.Path_TwtErrorLogs); } }
public void UpdateTBScheduler(string module) { try { string strTable = "tb_Setting"; string strQuery = "UPDATE tb_Scheduler_Module SET IsAccomplished='" + "1" + "' WHERE Module='" + module + "'"; DataBaseHandler.UpdateQuery(strQuery, strTable); //Increase 1 day if IsScheduledDaily { string selectQuery = "SELECT * FROM tb_Scheduler_Module where Module='" + module + "' and IsAccomplished='1'"; DataSet ds = DataBaseHandler.SelectQuery(selectQuery, strTable); DataTable dt = ds.Tables["tb_Setting"]; foreach (DataRow dRow in dt.Rows) { try { string strIsScheduledDaily = dRow["IsScheduledDaily"].ToString(); if (strIsScheduledDaily == "1") { string scheduledTime = dRow["ScheduledDateTime"].ToString(); DateTime dt_scheduledTime = DateTime.Parse(scheduledTime); DateTime dt_nextscheduledTime = dt_scheduledTime.AddDays(1); string nextscheduledTime = dt_nextscheduledTime.ToString(); string nextUpdateQuery = "UPDATE tb_Scheduler_Module SET ScheduledDateTime='" + nextscheduledTime + "', IsAccomplished='0" + "' WHERE Module='" + module + "'"; DataBaseHandler.UpdateQuery(nextUpdateQuery, "tb_Setting"); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } } #region MyRegion //Reschedule //{ // string selectQuery = "SELECT * FROM tb_Scheduler_Module where IsAccomplished='" + "1" + "'"; // DataSet ds = DataBaseHandler.SelectQuery(selectQuery, strTable); // DataTable dt = ds.Tables["tb_Setting"]; // foreach (DataRow dRow in dt.Rows) // { // string strIsScheduledDaily = dRow["IsScheduledDaily"].ToString(); // if (strIsScheduledDaily == "1") // { // string scheduledTime = dRow["ScheduledDateTime"].ToString(); // DateTime dt_scheduledTime = DateTime.Parse(scheduledTime); // DateTime dt_Now = DateTime.Now; // //if (dt_Now.Day - dt_scheduledTime.Day) // //{ // //} // DateTime dt_nextscheduledTime = dt_scheduledTime.AddDays(1); // string nextscheduledTime = dt_nextscheduledTime.ToString(); // string nextUpdateQuery = "UPDATE tb_Scheduler_Module SET ScheduledDateTime='" + nextscheduledTime + "' WHERE Module='" + module + "'"; // DataBaseHandler.UpdateQuery(nextUpdateQuery, "tb_Setting"); // } // } //} #endregion } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }