Advertisement
Guest User

Untitled

a guest
May 4th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.66 KB | None | 0 0
  1. public void dumpAllAgents()
  2.         {
  3.             this.Enabled = false;
  4.             SqlConnection conn = new SqlConnection(connectionString);
  5.             conn.Open();
  6.             StreamWriter logWriter = new StreamWriter(divisionBox.SelectedItem.ToString() + " User List" + ".txt");
  7.             String query = "Select FirstName, LastName, Email, Password, UserID, DivisionName from vwusers where DivisionName like '%" + divisionBox.SelectedItem.ToString() + "%' and IsActiveUser = 1 Order by FirstName" ;
  8.             SqlDataAdapter userTable = new SqlDataAdapter(query, conn);
  9.             DataSet userDataSet = new DataSet();
  10.             userTable.Fill(userDataSet);
  11.             foreach (DataTable table in userDataSet.Tables)
  12.             {
  13.                 foreach (DataRow row in table.Rows)
  14.                 {
  15.                     logWriter.WriteLine(row["FirstName"] + " " + row["LastName"]);
  16.                     logWriter.WriteLine("   Username: " + row["UserID"]);
  17.                     try
  18.                     {
  19.                         logWriter.WriteLine("   Password: " + CryptoProvider.Decrypt(row["Password"].ToString()).ToString());
  20.                     }
  21.                     catch(Exception die2)
  22.                     {
  23.                         logWriter.WriteLine("   Password: " + row["Password"]);
  24.                     }
  25.  
  26.                     logWriter.WriteLine("   Email Address: " + row["Email"]);
  27.                     logWriter.WriteLine("   Division Name: " + row["DivisionName"]);
  28.                     logWriter.WriteLine("");
  29.                 }
  30.             }
  31.             conn.Close();
  32.             logWriter.Close();
  33.             this.Enabled = true;
  34.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement