private void Add_DoanVien_Click(object sender, RoutedEventArgs e)
{
Add = true;
Add_DoanVien.IsEnabled = false;
Mod_DoanVien.IsEnabled = false;
SQLiteConnection sqlite_conn = new SQLiteConnection("Data source = QuanLyDoanVien.db");
SQLiteCommand sqlite_com = new SQLiteCommand();
sqlite_conn.Open();
sqlite_com = sqlite_conn.CreateCommand();
sqlite_com.CommandText = "SELECT Max(ID) FROM DoanVien";
MaDoanVien.Text = (Convert.ToInt32(sqlite_com.ExecuteScalar()) + 1).ToString();
HoVaTen.IsEnabled = NgaySinh.IsEnabled = QueQuan.IsEnabled =
GioiTinh.IsEnabled = ChiDoan.IsEnabled = ChucVu.IsEnabled = ToDanPho.IsEnabled =
PhuongXa.IsEnabled = QuanHuyen.IsEnabled = TinhThanh.IsEnabled = NgayVaoDang.IsEnabled =
NgayVaoDoan.IsEnabled = TinhTrang.IsEnabled = CMND.IsEnabled = Email.IsEnabled =
DienThoai.IsEnabled = DanToc.IsEnabled = TonGiao.IsEnabled = HoanCanh.IsEnabled = TrinhDo.IsEnabled
= true;
HoVaTen.Clear();
NgaySinh.Clear(); QueQuan.Clear();
GioiTinh.Clear(); ChiDoan.Clear(); ChucVu.Clear(); ToDanPho.Clear();
PhuongXa.Clear(); QuanHuyen.Clear(); TinhThanh.Clear(); NgayVaoDang.Clear();
NgayVaoDoan.Clear(); TinhTrang.Clear(); CMND.Clear(); Email.Clear();
DienThoai.Clear(); DanToc.Clear(); TonGiao.Clear(); HoanCanh.Clear(); TrinhDo.Clear();
}
public bool AddHometown(QueViewModel model)
{
QueQuan queQuan = new QueQuan()
{
MaQue = model.MaQue,
TenQue = model.TenQue,
TrangThai = Convert.ToBoolean(model.TrangThai)
};
db.QueQuans.Add(queQuan);
db.SaveChanges();
return(true);
}
