private void nextpage_Click(object sender, RoutedEventArgs e)
{
Patient newPatient = new Patient();
if (firstName.Text == "" || lastName.Text == "" || userName.Text == "" || pass.Text == "" || dateOfBirth.Text == "" || email.Text == "" || phoneNumber.Text == "")
{
MessageBox.Show("Please Fill Out All Fields Before Continuing", "Message", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (pass.Text != confirmPassword.Text)
{
MessageBox.Show("Passwords do not match", "Message", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
else
{
newPatient.setDateOfBirth(dateOfBirth.Text);
newPatient.setFirstName(firstName.Text);
newPatient.setLastName(lastName.Text);
EncryptPassword password = new EncryptPassword(pass.Text);
string encryptedPass = password.encrypt();
newPatient.setPassword(password.ToString());
newPatient.setEmail(email.Text);
newPatient.setPhoneNumber(phoneNumber.Text);
}
}
/// <summary>
/// Inserts the user.
/// </summary>
/// <param name="user">The user.</param>
/// <returns></returns>
public int insertUser(USERS user)
{
//mã hóa pass
EncryptPassword encryptPass = new EncryptPassword();
string newPass = encryptPass.encrypt(user.password);
//insert
return dal.insertUser(user.email,
user.firstName,
user.lastName,
newPass,
user.type,
user.status);
}
/// <summary>
/// Kiểm tra thông tin đăng nhập.
/// </summary>
/// <param name="loai">Loại user.</param>
/// <param name="email">The email.</param>
/// <param name="password">The password.</param>
/// <returns></returns>
public int checkLogin(out string loai,string email, string password)
{
//Encrypt password
EncryptPassword encryptPass = new EncryptPassword();
string newPass = encryptPass.encrypt(password);
//Lấy user để check
USERS usr = dal.getUsersByEmail(email);
if (usr != null && (newPass == usr.password))
{
loai = usr.type;
return 1;
}
loai = string.Empty;
return 0;
}
private void login_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(username.Text))
{
MessageBox.Show("Please enter your username.", "Message", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (string.IsNullOrEmpty(pass.Password))
{
MessageBox.Show("Please enter your password.", "Message", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
EncryptPassword password = new EncryptPassword(pass.Password);
string encryptedPass = password.encrypt();
NavigationStore nav = new NavigationStore();
CreateAccountViewModel cV = new CreateAccountViewModel(nav);
}
SQLite.Net.SQLiteConnection conn; //data connection
/// <summary>
/// Creates the database.
/// </summary>
public int createDatabase()
{
//create database local file name "HD_db.sqlite.sqlite"
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "HD_db.sqlite");
if (!File.Exists(path))
{
//create database
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
//Thêm bảng
conn.CreateTable<Model_CHI_TIET_VAY_CHOVAY>();
conn.CreateTable<Model_GHI_CHEP>();
conn.CreateTable<Model_GUI_TIET_KIEM>();
conn.CreateTable<Model_HANG_MUC_CHI>();
conn.CreateTable<Model_HANG_MUC_CHI_CHA>();
conn.CreateTable<Model_HANG_MUC_THU>();
conn.CreateTable<Model_HANG_MUC_THU_CHA>();
conn.CreateTable<Model_LOAI_TAI_KHOAN>();
conn.CreateTable<Model_LOAI_TIEN>();
conn.CreateTable<Model_TAI_KHOAN>();
conn.CreateTable<Model_THIET_LAP>();
conn.CreateTable<Model_USERS>();
conn.CreateTable<Model_VAY_NGAN_HANG>();
//Thêm record
try
{
EncryptPassword pass = new EncryptPassword();
conn.Insert(new Model_USERS()
{
Email = "*****@*****.**",
FirstName = "Heo Đất",
LastName = "Admin",
Password = pass.encrypt("admin"),
Type = "Admin",
Status = true
});
Debug.WriteLine("[QLTC] đã thêm admin");
}
catch (Exception ex)
{
Debug.WriteLine("[QLTC] " + ex.Message);
}
try
{
var listHangMucChiCha = new List<Model_HANG_MUC_CHI_CHA>()
{
new Model_HANG_MUC_CHI_CHA() {TenHangMucChiCha= "Trang phục"},
new Model_HANG_MUC_CHI_CHA() {TenHangMucChiCha="Ăn uống" }
};
foreach (var item in listHangMucChiCha)
{
conn.Insert(item);
}
var listHangMucChi = new List<Model_HANG_MUC_CHI>()
{
new Model_HANG_MUC_CHI() {IdHangMucChi=0, IdHangMucChiCha=1,TenHangMucChi="Quần áo",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Mua sắm quần áo" },
new Model_HANG_MUC_CHI() {IdHangMucChi=1, IdHangMucChiCha=1,TenHangMucChi="Giầy dép",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Mua sắm giầy dép" },
new Model_HANG_MUC_CHI() {IdHangMucChi=2, IdHangMucChiCha=1,TenHangMucChi="Khác",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Mua sắm" },
new Model_HANG_MUC_CHI() {IdHangMucChi=3, IdHangMucChiCha=2,TenHangMucChi="Đi chợ/Siêu thị",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Đi chợ, siêu thị" },
new Model_HANG_MUC_CHI() {IdHangMucChi=4, IdHangMucChiCha=2,TenHangMucChi="Ăn tiệm",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Ăn tiệm" }
};
foreach (var item in listHangMucChi)
{
conn.Insert(item);
}
}
catch (Exception ex)
{
Debug.WriteLine("[QLTC] " + ex.Message);
}
}
else // if file exist
{
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
}
return 1;
}
