public CaNhan_DAL(Database_DAL _databaseAccess = null, HoSoThiDua_DAL hoSoThiDua_DAL = null)
        {
            DbAccess   = _databaseAccess;
            HoSoThiDua = hoSoThiDua_DAL;
            LocalTable = new DataTable("DS_CaNhan");
            DataColumn id       = new DataColumn("id", typeof(long));
            DataColumn idDonVi  = new DataColumn("idDonVi", typeof(long));
            DataColumn hoTen    = new DataColumn("hoTen", typeof(string));
            DataColumn gioiTinh = new DataColumn("gioiTinh", typeof(string));
            DataColumn ngaySinh = new DataColumn("ngaySinh", typeof(DateTime));
            DataColumn chucDanh = new DataColumn("chucDanh", typeof(string));
            DataColumn chucVu   = new DataColumn("chucVu", typeof(string));
            DataColumn email    = new DataColumn("email", typeof(string));
            DataColumn phone    = new DataColumn("phone", typeof(string));

            LocalTable.Columns.Add(id);
            LocalTable.Columns.Add(idDonVi);
            LocalTable.Columns.Add(hoTen);
            LocalTable.Columns.Add(gioiTinh);
            LocalTable.Columns.Add(ngaySinh);
            LocalTable.Columns.Add(chucDanh);
            LocalTable.Columns.Add(chucVu);
            LocalTable.Columns.Add(email);
            LocalTable.Columns.Add(phone);

            LocalTable.RowDeleted += LocalTable_RowDeleted;

            if (DbAccess.Database.Tables.Contains(LocalTable.TableName))
            {
                DbAccess.Database.Tables.Remove(LocalTable.TableName);
            }
            DbAccess.Database.Tables.Add(LocalTable);
        }
        //just add comment

        public DonVi_DAL(Database_DAL database_DAL, CaNhan_DAL caNhan_DAL = null, HoSoThiDua_DAL hoSoThiDua_DAL = null)
        {
            DbAccess   = database_DAL;
            CaNhan     = caNhan_DAL;
            HoSoThiDua = hoSoThiDua_DAL;

            LocalTable = new DataTable("DS_DonVi");

            DataColumn id        = new DataColumn("id", typeof(long));
            DataColumn loai      = new DataColumn("loai", typeof(string));
            DataColumn tenDonVi  = new DataColumn("tenDonVi", typeof(string));
            DataColumn diaDiem   = new DataColumn("diaDiem", typeof(string));
            DataColumn email     = new DataColumn("email", typeof(string));
            DataColumn phone     = new DataColumn("phone", typeof(string));
            DataColumn trangThai = new DataColumn("trangThai", typeof(bool));

            LocalTable.Columns.Add(id);
            LocalTable.Columns.Add(loai);
            LocalTable.Columns.Add(tenDonVi);
            LocalTable.Columns.Add(diaDiem);
            LocalTable.Columns.Add(email);
            LocalTable.Columns.Add(phone);
            LocalTable.Columns.Add(trangThai);

            LocalTable.RowDeleting += LocalTable_RowDeleted;

            if (DbAccess.Database.Tables.Contains(LocalTable.TableName))
            {
                DbAccess.Database.Tables.Remove(LocalTable.TableName);
            }
            DbAccess.Database.Tables.Add(LocalTable);
        }