public FrmChiTietNhanKhau(CongDan cd)
{
InitializeComponent();
congDan = cd;
if (congDan != null)
{
SetSuaState();
disableSua();
rbKhong.Select();
}
else
{
congDan = new CongDan();
congDan.NgaySinh = DateTime.Now;
SetThemState();
}
setData(congDan);
setCmndCccd();
btnLuuSua.Click += BtnLuu_Click;
btnLuuThem.Click += BtnLuuThem_Click;
btnQuayLai.Click += BtnQuayLai_Click;
btnHoKhau.Click += BtnHoKhau_Click;
rbCo.Click += RbCo_Click;
rbKhong.Click += RbKhong_Click;
btnXemCccd.Click += BtnXemCccd_Click;
btnXemCmnd.Click += BtnXemCmnd_Click;
btnTaoCccd.Click += BtnTaoCccd_Click;
}
public bool edit(CongDan enitity)
{
try
{
string sqlString = " UPDATE CongDans " +
" SET MaCD = '" + enitity.MaCD + "'" +
",HoLot = N'" + enitity.HoLot + "'" +
",Ten = N'" + enitity.Ten + "'" +
",GioiTinh = '" + enitity.GioiTinh.ToString() + "'" +
",NgaySinh = '" + enitity.NgaySinh.ToShortDateString() + "'" +
",QuocTich = N'" + enitity.QuocTich + "'" +
",DanToc = '" + enitity.DanToc + "'" +
",TonGiao = N'" + enitity.TonGiao + "'" +
",QueQuan = N'" + enitity.QueQuan + "'" +
",soCMND = '" + enitity.soCMND + "'" +
",MaHK = '" + enitity.MaHK + "'" +
",SDT = '" + enitity.SDT + "'" +
",DiaChiThuongTru = N'" + enitity.DiaChiThuongTru + "'" +
",DiaChiTamTru = N'" + enitity.DiaChiTamTru + "'" +
",NgheNghiep = N'" + enitity.NgheNghiep + "'" +
",MaGDKKetHon = '" + enitity.MaGDKKetHon + "'" +
",ConSong = '" + enitity.ConSong.ToString() + "'" +
",HinhAnh = '" + enitity.HinhAnh + "' " +
"WHERE MaCD = '" + enitity.MaCD + "'";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text));
}
catch (Exception e)
{
MessageBox.Show("Lỗi Edit CongDan!!! + " + e.Message);
return(false);
}
}
public bool Delete(CongDan cd)
{
string query = string.Empty;
query += "DELETE FROM [CONG_DAN] WHERE [Ma] = @Ma";
using (SqlConnection _cnn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _cnn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Ma", cd.Ma);
try
{
_cnn.Open();
cmd.ExecuteNonQuery();
_cnn.Close();
_cnn.Dispose();
}
catch (Exception ex)
{
_cnn.Close();
return(false);
}
}
}
return(true);
}
private void btnTraCuu_Click(object sender, EventArgs e)
{
string cmnd = txtCMNDThanhVien.Text;
tempCongDan = hoKhauController.timThanhVien(cmnd);
if (tempCongDan != null)
{
lbHoTen.Text = tempCongDan.HoLot + " " + tempCongDan.Ten;
lbNgaySinh.Text = tempCongDan.NgaySinh.ToShortDateString();
if (tempCongDan.GioiTinh)
{
lbGioiTinh.Text = "Nam";
}
else
{
lbGioiTinh.Text = "Nữ";
}
lbCMND.Text = tempCongDan.soCMND;
lbQuocTich.Text = tempCongDan.QuocTich;
lbDanToc.Text = tempCongDan.DanToc;
lbTonGiao.Text = tempCongDan.TonGiao;
}
else
{
MessageBox.Show("Không tìm thấy công dân");
}
}
private CongDan GetFromReader(SqlDataReader reader)
{
CongDan cd = new CongDan();
cd.Ma = int.Parse(reader["Ma"].ToString());
cd.SoCmnd = reader["SoCmnd"].ToString();
cd.SoCccd = reader["SoCccd"].ToString();
cd.MaHoKhau = reader["MaHoKhau"].ToString();
cd.HoTen = reader["HoTen"].ToString();
cd.GioiTinh = reader["GioiTinh"].ToString();
cd.QueQuan = reader["QueQuan"].ToString();
cd.QuocTich = reader["QuocTich"].ToString();
cd.DiaChiHoKhau = reader["DiaChiHoKhau"].ToString();
cd.DanToc = reader["DanToc"].ToString();
cd.TonGiao = reader["TonGiao"].ToString();
cd.DacDiemNhanDang = reader["DacDiemNhanDang"].ToString();
string NgaySinh;
NgaySinh = reader["NgaySinh"].ToString();
if (!string.IsNullOrEmpty(NgaySinh.Trim()))
{
cd.NgaySinh = DateTime.Parse(NgaySinh);
}
return(cd);
}
public CongDan TimCMND(string CMND)
{
string sqlString = "select * from CongDans where soCMND = '" + CMND + "'";
DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
//CongDan cd = new CongDan()
//{
// MaCD = (string)ds.Tables[0].Rows[0].ItemArray[0],
// HoLot = (string)ds.Tables[0].Rows[0].ItemArray[1],
// Ten = (string)ds.Tables[0].Rows[0].ItemArray[2],
// GioiTinh = (bool)ds.Tables[0].Rows[0].ItemArray[3],
// NgaySinh = (DateTime)ds.Tables[0].Rows[0].ItemArray[4],
// QuocTich = (string)ds.Tables[0].Rows[0].ItemArray[5],
// DanToc = (string)ds.Tables[0].Rows[0].ItemArray[6],
// TonGiao = (string)ds.Tables[0].Rows[0].ItemArray[7],
// QueQuan = (string)ds.Tables[0].Rows[0].ItemArray[8],
// soCMND = (string)ds.Tables[0].Rows[0].ItemArray[9],
// //thêm CMND
// MaHK = (string)ds.Tables[0].Rows[0].ItemArray[10],
// //Thêm Hộ khẩu
// SDT = (string)ds.Tables[0].Rows[0].ItemArray[11],
// DiaChiThuongTru = (string)ds.Tables[0].Rows[0].ItemArray[12],
// DiaChiTamTru = (string)ds.Tables[0].Rows[0].ItemArray[13],
// NgheNghiep = (string)ds.Tables[0].Rows[0].ItemArray[14],
// MaGDKKetHon = (string)ds.Tables[0].Rows[0].ItemArray[15],
// //thêm giấy kết hôn
// ConSong = (bool)ds.Tables[0].Rows[0].ItemArray[16],
// HinhAnh = (string)ds.Tables[0].Rows[0].ItemArray[17],
//};
CongDan cd = findById((string)ds.Tables[0].Rows[0].ItemArray[0]);
return(cd);
}
public bool taoChungTu(GiayChungTu giayChungTu)
{
if (chungTuDAO.create(giayChungTu))
{
MessageBox.Show("Tạo chứng tử thành công");
CongDan nguoiTu = congDanController.layCongDanBangMaCD(giayChungTu.MaCD);
nguoiTu.ConSong = false;
if (congDanController.chinhSuaCongDan(nguoiTu))
{
MessageBox.Show("Chứng tử thành công");
return(true);
}
else
{
MessageBox.Show("Chứng tử thất bại");
if (xoaChungTu(giayChungTu))
{
MessageBox.Show("Xóa chứng tử thành công");
MessageBox.Show("Tạo chứng tử thất bại");
return(false);
}
else
{
MessageBox.Show("Lỗi Lỗi Lỗi !!! Xóa database");
return(false);
}
}
}
return(false);
}
public bool Add(CongDan cd)
{
string query = string.Empty;
query += @"
INSERT INTO [CONG_DAN] (
[SoCmnd],
[SoCccd],
[MaHoKhau],
[HoTen],
[NgaySinh],
[GioiTinh],
[QueQuan],
[QuocTich],
[DanToc],
[TonGiao],
[DacDiemNhanDang],
[DiaChiHoKhau]
)";
query += @"VALUES (
@SoCmnd,
@SoCccd,
@MaHoKhau,
@HoTen,
@NgaySinh,
@GioiTinh,
@QueQuan,
@QuocTich,
@DanToc,
@TonGiao,
@DacDiemNhanDang,
@DiaChiHoKhau
)";
using (SqlConnection _cnn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _cnn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
SetParam(cd, cmd);
try
{
_cnn.Open();
cmd.ExecuteNonQuery();
_cnn.Close();
_cnn.Dispose();
}
catch (Exception ex)
{
_cnn.Close();
return(false);
}
}
}
return(true);
}
public List <CongDan> ReadAllByKeyWord(string key)
{
string query = string.Empty;
query += @"select * from [CONG_DAN]
where
SoCmnd like @Param or
SoCccd like @Param or
MaHoKhau like @Param or
HoTen like @Param or
GioiTinh like @Param or
QuocTich like @Param or
DanToc like @Param or
TonGiao like @Param
";
List <CongDan> congDans = new List <CongDan>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Param", '%' + key + '%');
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
CongDan cd = new CongDan();
cd = GetFromReader(reader);
congDans.Add(cd);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(congDans);
}
private void btnTimCMND_Click(object sender, EventArgs e)
{
//Hủy đăng ký thường trú
if (comBoBoxChucNang.SelectedIndex == 1)
{
string imfor = null;
//Tìm hiện thông tin Công dân
QuanLyCongDan QLCD = new QuanLyCongDan();
CongDan CD = QLCD.TimCD_CMND(txtCMND_Search.Text.Trim(), ref imfor);
txtMaCD.Text = CD.MaCD;
txtHoVaTen.Text = CD.HoLot + " " + CD.Ten;
txtNgaySinh.Text = CD.NgaySinh.ToShortDateString();
txtTonGiao.Text = CD.TonGiao;
txtNoiSong.Text = CD.DiaChiThuongTru;
txtCMND.Text = CD.soCMND;
txtDanToc.Text = CD.DanToc;
txtQuocTich.Text = CD.QuocTich;
//Tìm Hiện thông tin thường trú
QuanLyThuongTru QLTT = new QuanLyThuongTru();
ThuongTru TT = QLTT.TimThuongTru_CMND(CD.MaCD, ref imfor);
datePick_NgayDK.Value = TT.NgayDK;
datePick_NgayDen.Value = TT.NgayDen;
if (TT.SoDK <= 9)
{
txtSoQL.Text = "0" + TT.SoDK.ToString();
}
else
{
txtSoQL.Text = TT.SoDK.ToString();
}
txtSoQuyen.Text = TT.SoQuyen;
DevExpress.XtraEditors.XtraMessageBox.Show(imfor);
}
else
{
//Thêm đăng ký thường trú
string imfor = null;
QuanLyCongDan QLCD = new QuanLyCongDan();
CongDan CD = new CongDan();
CD = QLCD.TimCD_CMND(txtCMND_Search.Text.Trim(), ref imfor);
txtMaCD.Text = CD.MaCD;
txtHoVaTen.Text = CD.HoLot + " " + CD.Ten;
txtNgaySinh.Text = CD.NgaySinh.ToShortDateString();
txtTonGiao.Text = CD.TonGiao;
txtNoiSong.Text = CD.DiaChiThuongTru;
txtCMND.Text = CD.soCMND;
txtDanToc.Text = CD.DanToc;
txtQuocTich.Text = CD.QuocTich;
DevExpress.XtraEditors.XtraMessageBox.Show(imfor);
}
}
private void btnTimCMND_Click(object sender, EventArgs e)
{
if ((txtCMND_Cha_Search.Text != "") || (txtCMND_Me_Search.Text != ""))
{
if (txtCMND_Cha_Search.Text != "")
{
string cmnd_Cha = txtCMND_Cha_Search.Text;
cha = nhanConNuoiController.timCongDan(cmnd_Cha);
if (cha == null)
{
MessageBox.Show("Không tìm thấy công dân này");
}
else
{
txtHoTenCha.Text = cha.HoLot + " " + cha.Ten;
txtDanTocCha.Text = cha.DanToc;
txtCMNDCha.Text = cha.soCMND;
txtNoiCapCMNDCha.Text = cha.CMND.NoiCap;
txtNgaySinhCha.Text = cha.NgaySinh.ToShortDateString();
txtQuocTichCha.Text = cha.QuocTich;
txtNgayCapCMNDCha.Text = cha.CMND.NgayCap.ToShortDateString();
txtNoiSongCha.Text = cha.DiaChiThuongTru;
txtCMND_Cha_Search.ResetText();
}
}
if (txtCMND_Me_Search.Text != "")
{
string cmnd_Me = txtCMND_Me_Search.Text;
me = nhanConNuoiController.timCongDan(cmnd_Me);
if (me == null)
{
MessageBox.Show("Không tìm thấy công dân này");
}
else
{
txtHoTenMe.Text = me.HoLot + " " + me.Ten;
txtDanTocMe.Text = me.DanToc;
txtCMNDMe.Text = me.soCMND;
txtNoiCapCMNDMe.Text = me.CMND.NoiCap;
txtNgaySinhMe.Text = me.NgaySinh.ToShortDateString();
txtQuocTichMe.Text = me.QuocTich;
txtNgayCapCMNDMe.Text = me.CMND.NgayCap.ToShortDateString();
txtNoiSongMe.Text = me.DiaChiThuongTru;
txtCMND_Me_Search.ResetText();
}
}
}
else
{
MessageBox.Show("Nhập tìm CMND cha hoặc mẹ");
return;
}
}
public bool xacNhanTinhTrangHonNhan(string CMND)
{
CongDan congDan = congDanDAO.findByCMND(CMND);
if (congDan.MaGDKKetHon == null)
{
return(true);
}
return(false);
}
public bool chinhSuaCongDan(CongDan congDan)
{
if (congDanDAO.edit(congDan))
{
MessageBox.Show("Chỉnh sửa công dân thành công");
return(true);
}
MessageBox.Show("Chỉnh sửa công dân thất bại");
return(false);
}
private void Frm_AddCongDanEvent(object sender, CongDan cd)
{
listCongDan.Add(congDanThem);
dgvCongDan.DataSource = listCongDan;
CurrencyManager myCurrencyManager = (CurrencyManager)this.BindingContext[dgvCongDan.DataSource];
myCurrencyManager.Refresh();
dgvCongDan.Invalidate();
}
public Form10()
{
InitializeComponent();
dt = new DataTable();
hoKhauQuanHes = new List <HoKhau_QuanHe>();
CongDans = new List <CongDan>();
hoKhauController = new QuanLyHoKhau();
tempHoKhauQuanHe = null;
tempCongDan = null;
quanHeDAO = new KetNoiQuanHe();
}
public string layMaCongDan()
{
CongDan last = congDanDAO.getLast();
if (last != null)
{
return("CD-" + ((int.Parse(last.MaCD.Substring(3, 3)) + 1) < 10 ? "00" + (int.Parse(last.MaCD.Substring(3, 3)) + 1) : ((int.Parse(last.MaCD.Substring(3, 3)) + 1) < 100 ? "0" + (int.Parse(last.MaCD.Substring(3, 3)) + 1) : "" + (int.Parse(last.MaCD.Substring(3, 3)) + 1))));
}
else
{
return(null);
}
}
public CongDan create(string hoLot, string ten, bool gioiTinh, DateTime ngaySinh, string diaChiThuongTru, string quocTich, string danToc, string queQuan)
{
string maCD = layMaCongDan();
MessageBox.Show(maCD);
CongDan congDan = new CongDan(maCD, hoLot, ten, gioiTinh, ngaySinh, diaChiThuongTru, quocTich, danToc, queQuan);
if (congDanDAO.create(congDan))
{
return(congDan);
}
return(null);
}
public bool create(CongDan entity)
{
try
{
string sqlString = "INSERT INTO CongDans VALUES ('" + entity.MaCD + "',N'" + entity.HoLot + "',N'" + entity.Ten + "','" + entity.GioiTinh.ToString() + "','" + entity.NgaySinh.ToShortDateString() + "',N'" + entity.QuocTich + "',N'" + entity.DanToc + "',NULL,N'" + entity.QueQuan + "',NULL,NULL,NULL,N'" + entity.DiaChiThuongTru + "',NULL,NULL,NULL,'True',NULL)";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text));
}
catch (Exception e)
{
MessageBox.Show("Lỗi create CongDan + " + e.Message);
return(false);
}
}
private void btnTimCMND_Click(object sender, EventArgs e)
{
if (comBoBoxChucNang.SelectedIndex == 0)
{
//Thêm đăng ký tạm vắng
string imfor = null;
QuanLyCongDan QLCD = new QuanLyCongDan();
CongDan CD = new CongDan();
CD = QLCD.TimCD_CMND(txtCMND_Search.Text.Trim(), ref imfor);
txtMaCD.Text = CD.MaCD;
txtHoVaTen.Text = CD.HoLot + " " + CD.Ten;
txtNgaySinh.Text = CD.NgaySinh.ToShortDateString();
txtTonGiao.Text = CD.TonGiao;
txtNoiSong.Text = CD.DiaChiThuongTru;
txtCMND.Text = CD.soCMND;
txtDanToc.Text = CD.DanToc;
txtQuocTich.Text = CD.QuocTich;
DevExpress.XtraEditors.XtraMessageBox.Show(imfor);
}
if (comBoBoxChucNang.SelectedIndex == 1)
{
string imfor = null;
QuanLyCongDan QLCD = new QuanLyCongDan();
CongDan CD = new CongDan();
CD = QLCD.TimCD_CMND(txtCMND_Search.Text.Trim(), ref imfor);
txtMaCD.Text = CD.MaCD;
txtHoVaTen.Text = CD.HoLot + " " + CD.Ten;
txtNgaySinh.Text = CD.NgaySinh.ToShortDateString();
txtTonGiao.Text = CD.TonGiao;
txtNoiSong.Text = CD.DiaChiThuongTru;
txtCMND.Text = CD.soCMND;
txtDanToc.Text = CD.DanToc;
txtQuocTich.Text = CD.QuocTich;
QuanLyTamVang QLTV = new QuanLyTamVang();
TamVang TV = QLTV.TimTamTru_MaCD(CD.MaCD, ref imfor);
txtLyDoTamVang.Text = TV.LyDoTamVang;
txtSoQL.Text = TV.SoDK.ToString();
txtSoQuyen.Text = TV.SoQuyen;
datePick_NgayDK.Value = TV.NgayDK;
}
}
private void DgvNhanKhau_CellClick(object sender, DataGridViewCellEventArgs e)
{
int numrow;
numrow = e.RowIndex;
if (numrow == -1)
{
disableSelect();
}
else
{
enableSelect();
congDanSelected = listCongDan[numrow];
}
}
public bool create(string so, string soQuyen, CongDan cha, CongDan me, CongDan nguoiKhai, string hoLot, string ten, bool gioiTinh, DateTime ngaySinh, string diaChiThuongTru, string noiSinh, string danToc, string quocTich, string queQuan, string quanHe, DateTime ngayDK)
{
CongDan congDan = congDanController.create(hoLot, ten, gioiTinh, ngaySinh, diaChiThuongTru, quocTich, danToc, queQuan);
if (congDan != null)
{
GiayKhaiSinh gks = new GiayKhaiSinh(so, soQuyen, congDan, noiSinh, cha, me, nguoiKhai, quanHe, ngayDK);
if (khaiSinhDAO.create(gks))
{
return(true);
}
}
MessageBox.Show("Lỗi create GiayKhaiSinh");
return(false);
}
public List <CongDan> ReadAllBySoHoKhau(string ma)
{
string query = string.Empty;
query += "SELECT * ";
query += "FROM [CONG_DAN] WHERE [MaHoKhau]=@Ma";
List <CongDan> congDans = new List <CongDan>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Ma", ma);
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
CongDan cd = new CongDan();
cd = GetFromReader(reader);
congDans.Add(cd);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(congDans);
}
public void CaiChinhDiaChiTamTru(string MaCD, string diachi, ref string imfor)
{
try
{
KetNoiCongDan Connect = new KetNoiCongDan();
CongDan CD = Connect.TimMaCD(MaCD);
Connect.CapNhatDiaChiTamTru(CD, diachi);
imfor = "Cập nhật địa chỉ tạm trú thành công!!!";
}
catch
{
imfor = "Cập nhật địa chỉ tạm trú không thành công!!!";
}
}
private void setData(CongDan result)
{
tbHoTen.Text = result.HoTen;
tbGioiTinh.Text = result.GioiTinh;
tbSoCmnd.Text = result.SoCmnd;
tbSoCccd.Text = result.SoCccd;
tbSoHoKhau.Text = result.MaHoKhau;
dtpNgaySinh.Value = result.NgaySinh;
tbQueQuan.Text = result.QueQuan;
tbQuocTich.Text = result.QuocTich;
tbDiaChi.Text = result.DiaChiHoKhau;
tbTonGiao.Text = result.TonGiao;
tbDanToc.Text = result.DanToc;
tbDacDiemNhanDang.Text = result.DacDiemNhanDang;
}
private void Frm_ValueEvent(CongDan congDan)
{
hoKhau.Update(congDan);
if (listCongDanRemove.Contains(congDan))
{
listCongDanRemove.Remove(congDan);
}
if (!listCongDan.Contains(congDan))
{
listCongDan.Add(congDan);
}
loadData_Vao_GridView();
}
private void btnTraCuu_Click(object sender, EventArgs e)
{
string cmnd_ChuHo = txtCMNDThanhVien.Text;
if (cmnd_ChuHo.Equals(""))
{
MessageBox.Show("Chưa nhập CMND chủ hộ");
return;
}
chuHo = hoKhauController.timThanhVien(cmnd_ChuHo);
DanhSach = hoKhauQuanHeController.layTatCaQuanHeBangMaHK(chuHo.MaHK);
if (DanhSach == null)
{
MessageBox.Show("Lỗi - Không tìm thấy thành viên nào");
}
loadThanhVien();
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (r2 == -1)
{
MessageBox.Show("Chưa chọn thành viên ");
return;
}
if (!chonQuanHe)
{
MessageBox.Show("Chưa chọn quan hệ với chủ hộ");
return;
}
tempCongDan = DanhSachThanhVienMoi[r2].CongDan;
if (DanhSachThanhVienMoi[r2].idQuanHe != 1)
{
DanhSachThanhVienMoi.Remove(DanhSachThanhVienMoi[r2]);
QuanHe temp = (QuanHe)cmbQuanHe.SelectedItem;
tempHoKhauQuanHe = new HoKhau_QuanHe(tempCongDan, temp);
foreach (HoKhau_QuanHe qh in DanhSach)
{
if (qh.QuanHe.id == 1)
{
flag++;
}
}
if (flag > 0 && tempHoKhauQuanHe.QuanHe.id == 1)
{
MessageBox.Show("Đã có chủ hộ rồi rồi");
return;
}
DanhSach.Add(tempHoKhauQuanHe);
loadThanhVienMoi();
loadThanhVien();
reset();
}
else
{
MessageBox.Show("Không được chuyển chủ hộ");
tempCongDan = null;
r2 = -1;
return;
}
}
public bool Update(CongDan cd)
{
string query = string.Empty;
query += "UPDATE [CONG_DAN] SET ";
query += "[SoCmnd] = @SoCmnd, ";
query += "[SoCccd] = @SoCccd, ";
query += "[MaHoKhau] = @MaHoKhau, ";
query += "[HoTen] = @HoTen, ";
query += "[NgaySinh] = @NgaySinh, ";
query += "[GioiTinh] = @GioiTinh, ";
query += "[QueQuan] = @QueQuan, ";
query += "[QuocTich] = @QuocTich, ";
query += "[DanToc] = @DanToc, ";
query += "[TonGiao] = @TonGiao, ";
query += "[DacDiemNhanDang] = @DacDiemNhanDang, ";
query += "[DiaChiHoKhau] = @DiaChiHoKhau ";
query += "WHERE [Ma] = @Ma";
using (SqlConnection _cnn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _cnn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Ma", cd.Ma);
SetParam(cd, cmd);
try
{
_cnn.Open();
cmd.ExecuteNonQuery();
_cnn.Close();
_cnn.Dispose();
}
catch (Exception ex)
{
_cnn.Close();
return(false);
}
}
}
return(true);
}
public bool Update(CongDan cd)
{
bool result = CongDanDAL.GetInstance().Update(cd);
if (result)
{
HoKhau hk = HoKhauDAL.GetInstance().ReadByMaChuHo(cd.Ma);
if (hk != null)
{
cd.SetChuHo(hk);
HoKhauDAL.GetInstance().Update(hk);
}
}
return(result);
}
public CongDan findById(string id)
{
try
{
string sqlString = "select * from CongDans where MaCD = '" + id + "'";
DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
CongDan cd = new CongDan()
{
MaCD = (string)ds.Tables[0].Rows[0].ItemArray[0],
HoLot = (string)ds.Tables[0].Rows[0].ItemArray[1],
Ten = (string)ds.Tables[0].Rows[0].ItemArray[2],
GioiTinh = (bool)ds.Tables[0].Rows[0].ItemArray[3],
NgaySinh = (DateTime)ds.Tables[0].Rows[0].ItemArray[4],
QuocTich = (string)ds.Tables[0].Rows[0].ItemArray[5],
DanToc = (string)ds.Tables[0].Rows[0].ItemArray[6],
TonGiao = (string)ds.Tables[0].Rows[0].ItemArray[7],
QueQuan = (string)ds.Tables[0].Rows[0].ItemArray[8],
soCMND = (string)ds.Tables[0].Rows[0].ItemArray[9],
//CMND = ketNoiCMND.findById((string)ds.Tables[0].Rows[0].ItemArray[9]),
//MaHK = (string)ds.Tables[0].Rows[0].ItemArray[10],
MaHK = (ds.Tables[0].Rows[0].ItemArray[10] == DBNull.Value) ? null : (string)ds.Tables[0].Rows[0].ItemArray[10],
//HoKhau = ketNoiHoKhau.findById((string)ds.Tables[0].Rows[0].ItemArray[10]),
//SDT = (string)ds.Tables[0].Rows[0].ItemArray[11],
SDT = (ds.Tables[0].Rows[0].ItemArray[11] == DBNull.Value) ? null : (string)ds.Tables[0].Rows[0].ItemArray[11],
DiaChiThuongTru = (string)ds.Tables[0].Rows[0].ItemArray[12],
//DiaChiTamTru = (string)ds.Tables[0].Rows[0].ItemArray[13],
DiaChiTamTru = (ds.Tables[0].Rows[0].ItemArray[13] == DBNull.Value) ? null : (string)ds.Tables[0].Rows[0].ItemArray[13],
//NgheNghiep = (string)ds.Tables[0].Rows[0].ItemArray[14],
NgheNghiep = (ds.Tables[0].Rows[0].ItemArray[14] == DBNull.Value) ? null : (string)ds.Tables[0].Rows[0].ItemArray[14],
//MaGDKKetHon = (string)ds.Tables[0].Rows[0].ItemArray[15],
MaGDKKetHon = (ds.Tables[0].Rows[0].ItemArray[15] == DBNull.Value) ? null : (string)ds.Tables[0].Rows[0].ItemArray[15],
//GiayDangKiKetHon = ketNoiKetHon.findById((string)ds.Tables[0].Rows[0].ItemArray[15]),
ConSong = (bool)ds.Tables[0].Rows[0].ItemArray[16],
//HinhAnh = (string)ds.Tables[0].Rows[0].ItemArray[17],
HinhAnh = (ds.Tables[0].Rows[0].ItemArray[17] == DBNull.Value) ? null : (string)ds.Tables[0].Rows[0].ItemArray[17],
};
return(cd);
}
catch (Exception e)
{
MessageBox.Show("Lỗi findById CongDan + " + e.Message);
return(null);
}
}
