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);
}
}
