public void DeleteSingleAccount() { try { QueryExecuter QME = new QueryExecuter(); DataSet ds = QME.getAccount(); int i = dgvAccounts.SelectedIndex; if (i < 0) { GlobusLogHelper.log.Info("Please Select Account For Deletion !"); var ResultMessageBox = ModernDialog.ShowMessage("Please Select Account For Deletion !", " Delete Account ", MessageBoxButton.OKCancel); return; } if (ModernDialog.ShowMessage("Are You Want To Delete This Accounts Permanently?", " Delete Account ", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { foreach (AccountNotifyPropertyChanged objAccountNotifyPropertyChanged in dgvAccounts.SelectedItems) { try { // AccountViewModel._listOfAccount //DataRowView row = (DataRowView)selection; string Username = objAccountNotifyPropertyChanged.Username.ToString(); string Password = objAccountNotifyPropertyChanged.Password.ToString(); QueryManager.DeleteAccounts(Username); } catch (Exception ex) { GlobusLogHelper.log.Error("Error :" + ex.Message); } } AccounLoad(); } } catch (Exception ex) { GlobusLogHelper.log.Error(" Error :" + ex.StackTrace); } }
public void loaddatafmdb() { try { DataTable NewDt2 = CreateUrltable(); QueryExecuter Qm = new QueryExecuter(); DataSet ds = Qm.getAccount(); DataTable dt = ds.Tables[0]; List<string> BunchList = new List<string>(); int itemCounter = 0; foreach (DataRow item in dt.Rows) { try { DataRow newdr = NewDt2.NewRow(); string Username = item["Username"].ToString(); string Password = item["Password"].ToString(); string proxyAddress = item["IPAddress"].ToString(); string proxyPort = item["IPPort"].ToString(); string proxyUsername = item["IPUsername"].ToString(); string proxyPassword = item["IPPassword"].ToString(); string Path = item["Path"].ToString(); newdr["Username"] = Username; newdr["Password"] = Password; newdr["IPAddress"] = proxyAddress; newdr["IPPort"] = proxyPort; newdr["IPUsername"] = proxyUsername; newdr["IPPassword"] = proxyPassword; newdr["Path"] = Path; ClGlobul.lstUrls.Add(Username); ClGlobul.lstUrls.Add(Password); ClGlobul.lstUrls.Add(proxyAddress); ClGlobul.lstUrls.Add(proxyPort); ClGlobul.lstUrls.Add(proxyUsername); ClGlobul.lstUrls.Add(proxyPassword); ClGlobul.lstUrls.Add(Path); NewDt2.Rows.Add(newdr); } catch { }; } if (this.InvokeRequired) { this.Invoke(new MethodInvoker(delegate { dgvAccount.DataSource = NewDt2; })); } else { dgvAccount.DataSource = NewDt2; } } catch { }; }
public void loadAccount() { string path = string.Empty; try { QueryExecuter qm1 = new QueryExecuter(); DataSet ds = qm1.getAccount(); if (ds.Tables[0].Rows.Count != 0) { try { path = ds.Tables[0].Rows[0].ItemArray[6].ToString(); if (!string.IsNullOrEmpty(path)) { try { txtAddAccounts1.Text = path; } catch { }; } } catch { } for (int noRow = 0; noRow < ds.Tables[0].Rows.Count; noRow++) { string account = ds.Tables[0].Rows[noRow].ItemArray[0].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[1].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[2].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[3].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[4].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[5].ToString(); ClGlobul.accountList.Add(account); } AddToLogger("[ " + DateTime.Now + " ] => [ " + ClGlobul.accountList.Count + " Accounts Loaded ]"); } else { AddToLogger("[ " + DateTime.Now + " ] => [ No Accounts Loaded ]"); } } catch (Exception ex) { AddToLogger("[ " + DateTime.Now + " ] => [ No Accounts Loaded ]"); } DataTable dt = new DataTable(); dt.Columns.Add("Username"); dt.Columns.Add("Password"); dt.Columns.Add("proxyAddress"); dt.Columns.Add("proxyPort"); dt.Columns.Add("proxyUsername"); dt.Columns.Add("proxyPassword"); dt.Columns.Add("Path"); }
public void AccounLoad() { try { string accountUser = string.Empty; string accountPass = string.Empty; string niches = string.Empty; string proxyAddress = string.Empty; string proxyPort = string.Empty; string proxyUserName = string.Empty; string proxyPassword = string.Empty; //string Useragent = string.Empty; string BoardsName = string.Empty; string ScreenName = string.Empty; string LoginStatus = string.Empty; string Followers = string.Empty; string Following = string.Empty; QueryExecuter QME = new QueryExecuter(); DataSet ds = QME.getAccount(); this.Dispatcher.Invoke(new Action(delegate { AccountViewModel._listOfAccount.Clear(); })); if (ds.Tables[0].Rows.Count != 0) { PDGlobals.listAccounts.Clear(); for (int noRow = 0; noRow < ds.Tables[0].Rows.Count; noRow++) { string account = ds.Tables[0].Rows[noRow].ItemArray[0].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[1].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[2].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[3].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[4].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[5].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[6].ToString() + ":" + ds.Tables[0].Rows[noRow].ItemArray[7].ToString(); PDGlobals.listAccounts.Add(account); // dv.AllowNew = false; accountUser = ds.Tables[0].Rows[noRow].ItemArray[0].ToString(); accountPass = ds.Tables[0].Rows[noRow].ItemArray[1].ToString(); niches = ds.Tables[0].Rows[noRow].ItemArray[2].ToString(); proxyAddress = ds.Tables[0].Rows[noRow].ItemArray[3].ToString(); proxyPort = ds.Tables[0].Rows[noRow].ItemArray[4].ToString(); proxyUserName = ds.Tables[0].Rows[noRow].ItemArray[5].ToString(); proxyPassword = ds.Tables[0].Rows[noRow].ItemArray[6].ToString(); ScreenName = ds.Tables[0].Rows[noRow].ItemArray[9].ToString(); Followers = ds.Tables[0].Rows[noRow].ItemArray[7].ToString(); Following = ds.Tables[0].Rows[noRow].ItemArray[8].ToString(); LoginStatus = ds.Tables[0].Rows[noRow].ItemArray[10].ToString(); // Accounts objPinInterestUser = new Accounts(); PinInterestUser objPinInterestUser = new PinInterestUser("", "", "", ""); objPinInterestUser.Username = accountUser; objPinInterestUser.Password = accountPass; objPinInterestUser.Niches = niches; objPinInterestUser.ProxyAddress = proxyAddress; objPinInterestUser.ProxyPort = proxyPort; objPinInterestUser.ProxyUsername = proxyUserName; objPinInterestUser.ProxyPassword = proxyPassword; // objPinInterestUser.LoginStatus = LoginStatus; try { AccountNotifyPropertyChanged objAccountNotifyPropertyChanged = new AccountNotifyPropertyChanged(); objAccountNotifyPropertyChanged.Username = accountUser; objAccountNotifyPropertyChanged.Password = accountPass; objAccountNotifyPropertyChanged.Niche = niches; objAccountNotifyPropertyChanged.ScreenName = ScreenName; objAccountNotifyPropertyChanged.FollowerCount = Followers; objAccountNotifyPropertyChanged.FollowingCount = Following; objAccountNotifyPropertyChanged.ProxyAddress = proxyAddress; objAccountNotifyPropertyChanged.ProxyPassword = proxyPassword; objAccountNotifyPropertyChanged.ProxyPort = proxyPort; objAccountNotifyPropertyChanged.ProxyUserName = proxyUserName; if (LoginStatus.Contains("Success")) { objAccountNotifyPropertyChanged.LoginStatus = "Success"; objAccountNotifyPropertyChanged.BackgroundColor = "Green"; this.Dispatcher.Invoke(new Action(delegate { AccountViewModel._listOfAccount.Add(objAccountNotifyPropertyChanged); })); } else if (LoginStatus.Contains("Fail")) { objAccountNotifyPropertyChanged.LoginStatus = "Fail"; objAccountNotifyPropertyChanged.BackgroundColor = "Red"; this.Dispatcher.Invoke(new Action(delegate { AccountViewModel._listOfAccount.Add(objAccountNotifyPropertyChanged); })); } else if (LoginStatus.Contains("Not")) { objAccountNotifyPropertyChanged.LoginStatus = "Not Checked"; objAccountNotifyPropertyChanged.BackgroundColor = ""; this.Dispatcher.Invoke(new Action(delegate { AccountViewModel._listOfAccount.Add(objAccountNotifyPropertyChanged); })); } } catch (Exception ex) { GlobusLogHelper.log.Error(" Error :" + ex.StackTrace); } try { PDGlobals.loadedAccountsDictionary.Add(objPinInterestUser.Username, objPinInterestUser); try { this.Dispatcher.Invoke(new Action(delegate { // dgvAccounts.ItemsSource = ds.Tables[0].DefaultView; dgvAccounts.ItemsSource = AccountViewModel._listOfAccount; // AccountViewModel._listOfAccount.Clear(); })); } catch (Exception ex) { }; } catch (Exception ex) { }; } try { this.Dispatcher.Invoke(new Action(delegate { // dgvAccounts.ItemsSource = ds.Tables[0].DefaultView; dgvAccounts.ItemsSource = AccountViewModel._listOfAccount; //AccountViewModel._listOfAccount.Clear(); })); } catch { }; GlobusLogHelper.log.Info(" => [ " + PDGlobals.listAccounts.Count + " Accounts Loaded ]"); } else { this.Dispatcher.Invoke(new Action(delegate { //dgvAccounts.ItemsSource = ds.Tables[0].DefaultView; dgvAccounts.ItemsSource = AccountViewModel._listOfAccount; // AccountViewModel._listOfAccount.Clear(); })); GlobusLogHelper.log.Info(" [ No Accounts Loaded ]"); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }