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;
}
