public ActionResult Sua(int id_SHK) { Session["chuyenTab"] = 7; HoKhau hokhau = db.HoKhaus.Find(id_SHK); return(View(hokhau)); }
public bool Delete(HoKhau cd) { string query = string.Empty; query += "DELETE FROM [HO_KHAU] 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); }
public bool tachHoKhau(string soHK, string diaChi, string soHKCu, string diachiCu, List <CongDan> congDans, ICollection <HoKhau_QuanHe> quanHes) { HoKhau hk = new HoKhau(soHK, diaChi); if (hoKhauDAO.create(hk)) { foreach (CongDan cd in congDans) { cd.DiaChiThuongTru = diaChi; cd.MaHK = soHK; if (!congDanController.chinhSuaCongDan(cd)) { foreach (CongDan c in congDans) { c.DiaChiThuongTru = diachiCu; c.MaHK = soHKCu; congDanController.chinhSuaCongDan(c); } xoaHoKhau(hk); return(false); } } foreach (HoKhau_QuanHe qh in quanHes) { if (hoKhauQuanHeController.timBangTatCa(qh.CongDan.MaCD, soHKCu)) { if (!hoKhauQuanHeController.xoaQuanHe(qh.CongDan.MaCD, soHKCu)) { MessageBox.Show("Lỗi rồi !!! xem lại "); return(false); } } if (!hoKhauQuanHeController.taoQuanHe(soHK, qh.CongDan.MaCD, qh.QuanHe.id)) { foreach (CongDan c in congDans) { c.DiaChiThuongTru = diachiCu; c.MaHK = soHKCu; congDanController.chinhSuaCongDan(c); } hoKhauQuanHeController.xoaTatCaQuanHe(soHK); xoaHoKhau(hk); return(false); } } //foreach (HoKhau_QuanHe qh in quanHes) //{ // if (hoKhauQuanHeController.timBangTatCa(qh.CongDan.MaCD,soHKCu)) // { // if(!hoKhauQuanHeController.xoaQuanHe(qh.CongDan.MaCD, soHKCu)) // { // MessageBox.Show("Lỗi rồi !!! xem lại "); // return false; // } // } //} return(true); } return(false); }
private void ChonHoKhauEvent(HoKhau hoKhau) { phieuChuyenKhau = chuyenKhauBUS.ChuyenKhau(congDan, hkMoi: hoKhau); hoKhau.Update(congDan); setData(congDan); }
public bool Validate(HoKhau cd, ref string error) { if (DKSoSoTrong(cd, ref error)) { return(false); } return(true); }
private bool DKSoSoTrong(HoKhau cd, ref string error) { if (string.IsNullOrEmpty(cd.SoHoKhau)) { error = "Số sổ hộ khẩu trống"; return(true); } return(false); }
private void setData(HoKhau result) { tbSoSo.Text = result.SoHoKhau; tbChuSo.Text = result.TenChuHo; tbLoaiSo.Text = result.LoaiSo; dtpNgayLap.Value = result.NgayCap; tbLyDoLap.Text = result.LyDoCap; tbNguoiLap.Text = result.NguoiCap; tbDiaChi.Text = result.DiaChi; }
public bool xoaHoKhau(HoKhau hoKhau) { if (hoKhauDAO.delete(hoKhau.SoHK)) { MessageBox.Show("Xóa hộ khẩu thành công"); return(true); } MessageBox.Show("Xóa hộ khẩu thất bại"); return(false); }
public ActionResult Sua(HoKhau sohokhau) { if (ModelState.IsValid) { db.Entry(sohokhau).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); Session["chuyenTab"] = 7; return(RedirectToAction("DetailChung/" + sohokhau.id_hs, "HocSinh")); } return(View()); }
private void btnTimMaCD_Click(object sender, EventArgs e) { string imfor = null; QuanLyHoKhau qlhk = new QuanLyHoKhau(); HoKhau HK = qlhk.Tim_MaHK(txtSoHK_DK.Text.Trim(), ref imfor); txtNoiDangKyThuongTru.Text = HK.DiaChi; DevExpress.XtraEditors.XtraMessageBox.Show(imfor); }
public HoKhau TimHK(string MaHK) { string sqlString = "select * from HoKhaus where SoHK = " + MaHK + ""; DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text); HoKhau hk = new HoKhau() { SoHK = (string)ds.Tables[0].Rows[0].ItemArray[0], DiaChi = (string)ds.Tables[0].Rows[0].ItemArray[1], }; return(hk); }
public bool Delete(HoKhau cd) { List <CongDan> congDans = CongDanDAL.GetInstance().ReadAllBySoHoKhau(cd.SoHoKhau); foreach (CongDan congDan in congDans) { congDan.EmptyHoKhau(); CongDanDAL.GetInstance().Update(congDan); } return(HoKhauDAL.GetInstance().Delete(cd)); }
private static void SetParam(HoKhau cd, SqlCommand cmd) { cmd.Parameters.AddWithValue("@SoSo", cd.SoHoKhau); cmd.Parameters.AddWithValue("@MaChuHo", cd.MaChuHo); cmd.Parameters.AddWithValue("@TenChuHo", cd.TenChuHo); cmd.Parameters.AddWithValue("@DiaChi", cd.DiaChi); cmd.Parameters.AddWithValue("@LoaiSo", cd.LoaiSo); cmd.Parameters.AddWithValue("@LyDoCap", cd.LyDoCap); cmd.Parameters.AddWithValue("@NgayCap", cd.NgayCap); cmd.Parameters.AddWithValue("@NoiCap", cd.NoiCap); cmd.Parameters.AddWithValue("@NguoiCap", cd.NguoiCap); }
public bool Add(HoKhau cd) { string query = string.Empty; query += @" INSERT INTO [HO_KHAU] ( [SoSo], [MaChuHo], [TenChuHo], [DiaChi], [LoaiSo], [LyDoCap], [NgayCap], [NoiCap], [NguoiCap] )"; query += @"VALUES ( @SoSo, @MaChuHo, @TenChuHo, @DiaChi, @LoaiSo, @LyDoCap, @NgayCap, @NoiCap, @NguoiCap )"; 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 string laySoHK() { HoKhau lastHK = hoKhauDAO.getLast(); if (lastHK == null) { return("HK-001"); } string temp = lastHK.SoHK.Substring(3, 3); return("HK-" + ((int.Parse(temp) + 1) < 10 ? "00" + (int.Parse(temp) + 1) : ((int.Parse(temp) + 1) < 100 ? "0" + (int.Parse(temp) + 1) : "" + (int.Parse(temp) + 1)))); }
public bool create(HoKhau entity) { try { string sqlString = "INSERT INTO HoKhaus VALUES ('" + entity.SoHK + "',N'" + entity.DiaChi + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create HoKhau + " + e.Message); return(false); } }
public List <HoKhau> ReadAllByKeyword(string key) { string query = string.Empty; query += @"select * from [HO_KHAU] where SoSo like @Param or TenChuHo like @Param or DiaChi like @Param or LoaiSo like @Param "; List <HoKhau> congDans = new List <HoKhau>(); 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()) { HoKhau cd = GetFromReader(reader); congDans.Add(cd); } } con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(null); } } } return(congDans); }
private void SetHoKhauChuyenDenWidgets(HoKhau hk) { if (hk != null) { tbChuHKDen.Text = hk.TenChuHo; tbDiaChiHKDen.Text = hk.DiaChi; tbSoHKDen.Text = hk.SoHoKhau; } else { tbChuHKDen.Text = NOT_FOUND; tbDiaChiHKDen.Text = NOT_FOUND; tbSoHKDen.Text = NOT_FOUND; } }
private void DgvHoKhau_CellClick(object sender, DataGridViewCellEventArgs e) { int numrow; numrow = e.RowIndex; if (numrow == -1) { disableSelect(); } else { enableSelect(); hoKhauSelected = listHoKhau[numrow]; } }
public HoKhau Tim_MaHK(string MaHK, ref string imfor) { try { KetNoiHoKhau Connect = new KetNoiHoKhau(); HoKhau HK = Connect.TimHK(MaHK); imfor = "Tìm thấy hộ khẩu!!"; return(HK); } catch { imfor = "Không tìm thấy hộ khẩu này!!!"; return(null); } }
public ActionResult Themmoi(HoKhau sohokhau) { if (ModelState.IsValid) { if (Session["file"] != null) { sohokhau.fileSHK = (string)Session["file"]; } sohokhau.id_hs = (int)Session["id_hsSHK"]; db.HoKhaus.Add(sohokhau); db.SaveChanges(); Session["chuyenTab"] = 7; return(RedirectToAction("DetailChung/" + sohokhau.id_hs, "HocSinh")); } return(View()); }
public bool edit(HoKhau enitity) { try { string sqlString = " UPDATE HoKhaus " + " SET SoHK = '" + enitity.SoHK + "'" + ",DiaChi = N'" + enitity.DiaChi + "' " + "WHERE SoHK = '" + enitity.SoHK + "'"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi edit HoKhau + " + e.Message); return(false); } }
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); }
private HoKhau GetFromReader(SqlDataReader reader) { HoKhau hk = new HoKhau(); hk.Ma = int.Parse(reader["Ma"].ToString()); hk.SoHoKhau = reader["SoSo"].ToString(); hk.MaChuHo = int.Parse(reader["MaChuHo"].ToString()); hk.TenChuHo = reader["TenChuHo"].ToString(); hk.DiaChi = reader["DiaChi"].ToString(); hk.LoaiSo = reader["LoaiSo"].ToString(); hk.LyDoCap = reader["LyDoCap"].ToString(); hk.NgayCap = DateTime.Parse(reader["NgayCap"].ToString()); hk.NoiCap = reader["NoiCap"].ToString(); hk.NguoiCap = reader["NguoiCap"].ToString(); return(hk); }
public List <HoKhau> ReadAll() { string query = string.Empty; query += "SELECT * "; query += "FROM [HO_KHAU]"; List <HoKhau> congDans = new List <HoKhau>(); using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; try { con.Open(); SqlDataReader reader = null; reader = cmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { HoKhau cd = GetFromReader(reader); congDans.Add(cd); } } con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(null); } } } return(congDans); }
public bool Update(HoKhau cd) { string query = string.Empty; query += "UPDATE [HO_KHAU] SET "; query += "[SoSo] = @SoSo, "; query += "[MaChuHo] = @MaChuHo, "; query += "[TenChuHo] = @TenChuHo, "; query += "[DiaChi] = @DiaChi, "; query += "[LoaiSo] = @LoaiSo, "; query += "[LyDoCap] = @LyDoCap, "; query += "[NgayCap] = @NgayCap, "; query += "[NoiCap] = @NoiCap, "; query += "[NguoiCap] = @NguoiCap "; 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 HoKhau findById(string id) { try { string sqlString = "select * from HoKhaus where SoHK = " + id + ""; DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text); HoKhau hk = new HoKhau() { SoHK = (string)ds.Tables[0].Rows[0].ItemArray[0], DiaChi = (string)ds.Tables[0].Rows[0].ItemArray[1], }; return(hk); } catch (Exception e) { MessageBox.Show("Lỗi findById HoKhau + " + e.Message); return(null); } }
public FrmChiTietHoKhau(HoKhau hk) { InitializeComponent(); if (hk == null) { SetThemHoKhau(); hoKhau = new HoKhau(); hoKhau.NgayCap = DateTime.Now; } else { SetSuaHoKhau(); disableSua(); rbKhong.Select(); hoKhau = hk; setData(hoKhau); listCongDan = congDanBUS.ReadAllByMaHoKhau(hoKhau.SoHoKhau); } disableSelect(); SetDataGridView(); btnLuuSua.Click += BtnLuuSua_Click; btnLuuThem.Click += BtnLuuThem_Click; btnQuayLai.Click += BtnQuayLai_Click; btnXemNhanKhau.Click += BtnXemNhanKhau_Click; btnThemNhanKhau.Click += BtnThemNhanKhau_Click; btnXoaNhanKhau.Click += BtnXoaNhanKhau_Click; btnChonChuHo.Click += BtnChonChuHo_Click; rbCo.Click += RbCo_Click; rbKhong.Click += RbKhong_Click; loadData_Vao_GridView(); dgvCongDan.CellClick += DgvCongDan_CellClick; tbDiaChi.TextChanged += TbDiaChi_TextChanged; }
public bool taoMoiHoKhau(string soHK, string diaChi, List <CongDan> congDans, ICollection <HoKhau_QuanHe> quanHes) { HoKhau hk = new HoKhau(soHK, diaChi); if (hoKhauDAO.create(hk)) { foreach (CongDan cd in congDans) { cd.DiaChiThuongTru = diaChi; cd.MaHK = soHK; if (!congDanController.chinhSuaCongDan(cd)) { foreach (CongDan c in congDans) { c.DiaChiThuongTru = null; c.MaHK = null; congDanController.chinhSuaCongDan(c); } xoaHoKhau(hk); return(false); } } foreach (HoKhau_QuanHe qh in quanHes) { if (!hoKhauQuanHeController.taoQuanHe(soHK, qh.CongDan.MaCD, qh.QuanHe.id)) { foreach (CongDan c in congDans) { c.DiaChiThuongTru = null; c.MaHK = null; congDanController.chinhSuaCongDan(c); } hoKhauQuanHeController.xoaTatCaQuanHe(soHK); xoaHoKhau(hk); return(false); } } return(true); } return(false); }
public List <HoKhau> getAll() { try { string sqlString = "select * from HoKhaus "; DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text); DataTable dt = ds.Tables[0]; List <HoKhau> hoKhaus = new List <HoKhau>(); foreach (DataRow dr in dt.Rows) { HoKhau hk = findById((string)dr.ItemArray[0]); hoKhaus.Add(hk); } return(hoKhaus); } catch (Exception e) { MessageBox.Show("Lỗi getAll HoKhau + " + e.Message); return(null); } }