private static string GetDecryptedPassword(string user = "") { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { var output = cnn.Query <UserModel>("SELECT * FROM User WHERE Username = '******'", new DynamicParameters()); List <UserModel> listUser = output.ToList(); UserModel userModel; string Password = ""; if (listUser.Count > 0) { userModel = listUser[0]; LoginForm.userModel = userModel; Password = EncryptPassword.Decrypt(userModel.Password, "zxc123"); } return(Password); } }
void initUserTable() { ut = new DataTable(); ut.Columns.Add("no", typeof(int)); ut.Columns.Add("user", typeof(string)); ut.Columns.Add("pass", typeof(string)); ut.Columns.Add("nama", typeof(string)); ut.Columns.Add("jabatan", typeof(string)); ut.Columns.Add("instalasi", typeof(string)); ut.Columns.Add("role", typeof(int)); int count = 0; AppForm.listUser = SqliteDataAccess.loadUser(); foreach (UserModel user in AppForm.listUser) { count++; ut.Rows.Add(count, user.Username, EncryptPassword.Decrypt(user.Password, "zxc123"), user.Nama, user.Jabatan, user.Instalasi, user.Role); } dataGridView1.DataSource = ut; }