mekasu0124

Untitled

Mar 2nd, 2024
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 2.26 KB | None | 0 0
  1. internal UserModel GetDefaultUser()
  2. {
  3.     using SQLiteConnection conn = new(_dbFile);
  4.     using SQLiteCommand cmd = conn.CreateCommand();
  5.     using SQLiteCommand cmd2 = conn.CreateCommand();
  6.     using SQLiteCommand cmd3 = conn.CreateCommand();
  7.  
  8.     SQLiteDataReader reader;
  9.     SQLiteDataReader reader2;
  10.     SQLiteDataReader reader3;
  11.  
  12.     conn.Open();
  13.  
  14.     cmd.CommandText = @"SELECT * FROM users WHERE Username=$un";
  15.     cmd.Parameters.AddWithValue("$un", "defaultUser");
  16.  
  17.     cmd2.CommandText = @"SELECT * FROM user_settings WHERE Username=$un";
  18.     cmd2.Parameters.AddWithValue("$un", "defaultUser");
  19.  
  20.     cmd3.CommandText = @"SELECT * FROM user_styles WHERE Username=$un";
  21.     cmd3.Parameters.AddWithValue("$un", "defaultUser");
  22.  
  23.     try
  24.     {
  25.         reader = cmd.ExecuteReader();
  26.         reader2 = cmd2.ExecuteReader();
  27.         reader3 = cmd3.ExecuteReader();
  28.  
  29.         UserModel defaultUser = new();
  30.         UserSettingsModel defaulUserSettings = defaultUser.CustomSettings.UserSettings;
  31.         UserStylesModel defaultUserStyles = defaultUser.CustomSettings.UserStyles;
  32.  
  33.         while (reader.Read())
  34.         {
  35.             defaultUser.FirstName = reader["FirstName"].ToString();
  36.             defaultUser.LastName = reader["LastName"].ToString();
  37.             defaultUser.Email = reader["Email"].ToString();
  38.             defaultUser.Username = reader["Username"].ToString();
  39.             defaultUser.Password = reader["Password"].ToString();
  40.             defaultUser.TosAgree = Convert.ToInt32(reader["TosAgree"].ToString());
  41.         }
  42.  
  43.         while (reader2.Read())
  44.         {
  45.             defaulUserSettings.UseOnlineStorage = Convert.ToInt32(reader["UseOnlineStorage"].ToString());
  46.         }
  47.  
  48.         while (reader3.Read())
  49.         {
  50.             defaultUserStyles.FontSize = reader["FontSize"].ToString();
  51.             defaultUserStyles.FontStyle = reader["FontStyle"].ToString();
  52.             defaultUserStyles.FontColor = reader["FontColor"].ToString();
  53.             defaultUserStyles.BackgroundColor = reader["BackgroundColor"].ToString();
  54.             defaultUserStyles.BorderColor = reader["BorderColor"].ToString();
  55.         }
  56.  
  57.         return defaultUser;
  58.     }
  59.     catch (SQLiteException ex)
  60.     {
  61.         throw new SQLiteException(ex.Message);
  62.     }
  63. }
Add Comment
Please, Sign In to add comment