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 HoSoThiDua_DAL(Database_DAL database_DAL)
{
DbAccess = database_DAL;
LocalTable = new DataTable("DS_HoSoThiDua");
DataColumn id = new DataColumn("id", typeof(long));
DataColumn idCaNhan = new DataColumn("idCaNhan", typeof(long));
DataColumn idDonVi = new DataColumn("idDonVi", typeof(long));
DataColumn nam = new DataColumn("nam", typeof(long));
DataColumn danhHieuDangKy = new DataColumn("danhHieuDangKy", typeof(byte));
DataColumn danhHieuDatDuoc = new DataColumn("danhHieuDatDuoc", typeof(byte));
LocalTable.Columns.Add(id);
LocalTable.Columns.Add(idCaNhan);
LocalTable.Columns.Add(idDonVi);
LocalTable.Columns.Add(nam);
LocalTable.Columns.Add(danhHieuDangKy);
LocalTable.Columns.Add(danhHieuDatDuoc);
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);
}
public GioiTinh_DAL(Database_DAL database_DAL)
{
DbAccess = database_DAL;
LocalTable = new DataTable("DM_GioiTinh");
LocalTable.Columns.Add(new DataColumn("id", typeof(byte)));
LocalTable.Columns.Add(new DataColumn("gioiTinh", typeof(string)));
LocalTable.Columns.Add(new DataColumn("trangThai", typeof(bool)));
DbAccess.Database.Tables.Add(LocalTable);
}
public LoaiDonVi_DAL(Database_DAL database_DAL)
{
DbAccess = database_DAL;
LocalTable = new DataTable("DM_LoaiDonVi");
LocalTable.Columns.Add(new DataColumn("id", typeof(byte)));
LocalTable.Columns.Add(new DataColumn("tenLoai", typeof(string)));
LocalTable.Columns.Add(new DataColumn("trangThai", typeof(bool)));
DbAccess.Database.Tables.Add(LocalTable);
}
public DanhHieu_DAL(Database_DAL database_DAL)
{
DbAccess = database_DAL;
LocalTable = new DataTable();
LocalTable.Columns.Add(new DataColumn("id", typeof(long)));
LocalTable.Columns.Add(new DataColumn("nam", typeof(long)));
LocalTable.Columns.Add(new DataColumn("danhHieu", typeof(string)));
LocalTable.Columns.Add(new DataColumn("trangThai", typeof(bool)));
}
public ChucVu_DAL(Database_DAL database_DAL)
{
DbAccess = database_DAL;
LocalTable = new DataTable("DM_ChucVu");
LocalTable.Columns.Add(new DataColumn("id", typeof(byte)));
LocalTable.Columns.Add(new DataColumn("chucVu", typeof(string)));
LocalTable.Columns.Add(new DataColumn("trangThai", typeof(bool)));
if (DbAccess.Database.Tables.Contains(LocalTable.TableName))
{
DbAccess.Database.Tables.Remove(LocalTable.TableName);
}
DbAccess.Database.Tables.Add(LocalTable);
}
public TieuChi_DAL(Database_DAL database_DAL)
{
DbAccess = database_DAL;
LocalTable = new DataTable("DM_TieuChi");
DataColumn id = new DataColumn("id", typeof(long));
DataColumn nam = new DataColumn("nam", typeof(long));
DataColumn ten = new DataColumn("ten", typeof(string));
DataColumn moTa = new DataColumn("moTa", typeof(string));
DataColumn ghiChu = new DataColumn("ghiChu", typeof(string));
LocalTable.Columns.Add(id);
LocalTable.Columns.Add(nam);
LocalTable.Columns.Add(ten);
LocalTable.Columns.Add(moTa);
LocalTable.Columns.Add(ghiChu);
DbAccess.Database.Tables.Add(LocalTable);
}
