public void DeleteDBCDecaptcherData(string strDeathByCaptcha) { try { string strTable = "tb_Setting"; string strQuery = "DELETE FROM tb_Setting WHERE FileType='" + strDeathByCaptcha + "'"; DataBaseHandler.DeleteQuery(strQuery, strTable); } catch (Exception) { } }
public void UpdatePasswordForAccount(string userName, string newPassword) { try { string UpdateQuery = "update tb_LinkedInAccount set Password='******' WHERE UserName='******';"; DataBaseHandler.UpdateQuery(UpdateQuery, "tb_LinkedInAccount"); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); //AlibabaScaper.GlobusFileHelper.AppendStringToTextfileNewLine("InsertQuery error" +ex+ ex.StackTrace, MainFrm.Error); } }
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 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 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); } }
public void UpdateFBAccount(string Usernaem, string password, string proxiaddress, string proxyport, string proxyName, string proxypassword) { try { string strTable = "tb_FBAccount"; string strQuery = "UPDATE tb_FBAccount SET Password='******', ProxyAddress='" + proxiaddress + "', ProxyPort='" + proxyport + "', ProxyUserName='******', ProxyPassword='******' WHERE UserName='******'"; DataBaseHandler.UpdateQuery(strQuery, strTable); } catch (Exception) { throw; } }
public DataTable SelectSettingData() { try { string strQuery = "SELECT * FROM tb_Setting"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_Setting"); DataTable dt = ds.Tables["tb_Setting"]; return(dt); } catch (Exception) { return(new DataTable()); } }
public DataTable SelectAccoutsForGridView() { try { List <string> lstAccount = new List <string>(); string strQuery = "SELECT * FROM tb_LinkedInAccount"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_LinkedInAccount"); DataTable dt = ds.Tables["tb_LinkedInAccount"]; return(dt); } catch (Exception) { return(new DataTable()); } }
/// <summary> /// Inserts Settings in DataBase /// Updates if Settings already present /// </summary> /// <param name="module"></param> /// <param name="filetype"></param> /// <param name="filepath"></param> 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); } }