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);
}
}