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