Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- internal UserModel GetDefaultUser()
- {
- using SQLiteConnection conn = new(_dbFile);
- using SQLiteCommand cmd = conn.CreateCommand();
- using SQLiteCommand cmd2 = conn.CreateCommand();
- using SQLiteCommand cmd3 = conn.CreateCommand();
- SQLiteDataReader reader;
- SQLiteDataReader reader2;
- SQLiteDataReader reader3;
- conn.Open();
- cmd.CommandText = @"SELECT * FROM users WHERE Username=$un";
- cmd.Parameters.AddWithValue("$un", "defaultUser");
- cmd2.CommandText = @"SELECT * FROM user_settings WHERE Username=$un";
- cmd2.Parameters.AddWithValue("$un", "defaultUser");
- cmd3.CommandText = @"SELECT * FROM user_styles WHERE Username=$un";
- cmd3.Parameters.AddWithValue("$un", "defaultUser");
- try
- {
- reader = cmd.ExecuteReader();
- reader2 = cmd2.ExecuteReader();
- reader3 = cmd3.ExecuteReader();
- UserModel defaultUser = new();
- UserSettingsModel defaulUserSettings = defaultUser.CustomSettings.UserSettings;
- UserStylesModel defaultUserStyles = defaultUser.CustomSettings.UserStyles;
- while (reader.Read())
- {
- defaultUser.FirstName = reader["FirstName"].ToString();
- defaultUser.LastName = reader["LastName"].ToString();
- defaultUser.Email = reader["Email"].ToString();
- defaultUser.Username = reader["Username"].ToString();
- defaultUser.Password = reader["Password"].ToString();
- defaultUser.TosAgree = Convert.ToInt32(reader["TosAgree"].ToString());
- }
- while (reader2.Read())
- {
- defaulUserSettings.UseOnlineStorage = Convert.ToInt32(reader["UseOnlineStorage"].ToString());
- }
- while (reader3.Read())
- {
- defaultUserStyles.FontSize = reader["FontSize"].ToString();
- defaultUserStyles.FontStyle = reader["FontStyle"].ToString();
- defaultUserStyles.FontColor = reader["FontColor"].ToString();
- defaultUserStyles.BackgroundColor = reader["BackgroundColor"].ToString();
- defaultUserStyles.BorderColor = reader["BorderColor"].ToString();
- }
- return defaultUser;
- }
- catch (SQLiteException ex)
- {
- throw new SQLiteException(ex.Message);
- }
- }
Add Comment
Please, Sign In to add comment