Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void dumpAllAgents()
- {
- this.Enabled = false;
- SqlConnection conn = new SqlConnection(connectionString);
- conn.Open();
- StreamWriter logWriter = new StreamWriter(divisionBox.SelectedItem.ToString() + " User List" + ".txt");
- String query = "Select FirstName, LastName, Email, Password, UserID, DivisionName from vwusers where DivisionName like '%" + divisionBox.SelectedItem.ToString() + "%' and IsActiveUser = 1 Order by FirstName" ;
- SqlDataAdapter userTable = new SqlDataAdapter(query, conn);
- DataSet userDataSet = new DataSet();
- userTable.Fill(userDataSet);
- foreach (DataTable table in userDataSet.Tables)
- {
- foreach (DataRow row in table.Rows)
- {
- logWriter.WriteLine(row["FirstName"] + " " + row["LastName"]);
- logWriter.WriteLine(" Username: " + row["UserID"]);
- try
- {
- logWriter.WriteLine(" Password: " + CryptoProvider.Decrypt(row["Password"].ToString()).ToString());
- }
- catch(Exception die2)
- {
- logWriter.WriteLine(" Password: " + row["Password"]);
- }
- logWriter.WriteLine(" Email Address: " + row["Email"]);
- logWriter.WriteLine(" Division Name: " + row["DivisionName"]);
- logWriter.WriteLine("");
- }
- }
- conn.Close();
- logWriter.Close();
- this.Enabled = true;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement