//Thêm
public bool them_Thannhantamtru(THANNHAN_TAMTRU tb)
{
try
{
data.THANNHAN_TAMTRUs.InsertOnSubmit(tb);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//Xóa
public bool xoa_Thannhan_tamtru(string matn, string pMakt)
{
try
{
THANNHAN_TAMTRU tb = data.THANNHAN_TAMTRUs.Where(t => t.MATN == matn && t.MAKT == pMakt).FirstOrDefault();
data.THANNHAN_TAMTRUs.DeleteOnSubmit(tb);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//Sửa
public bool sua_thannhan_tamtru(THANNHAN_TAMTRU ptntamtru)
{
try
{
THANNHAN_TAMTRU nv = data.THANNHAN_TAMTRUs.Where(t => t.MATN == ptntamtru.MATN && t.MAKT == ptntamtru.MAKT).FirstOrDefault();
if (nv != null)
{
nv.MAKT = ptntamtru.MAKT;
nv.MATN = ptntamtru.MATN;
nv.NGAYVAO = ptntamtru.NGAYVAO;
nv.NGAYRA = ptntamtru.NGAYRA;
data.SubmitChanges();
}
return(true);
}
catch
{
return(false);
}
}
private void btn_luu_Click(object sender, EventArgs e)
{
if (txt_matn.Text == string.Empty || txt_tentn.Text == string.Empty || txt_scm.Text == string.Empty ||
txt_ngayvao.Text == string.Empty)
{
txt_tentn_Validating(sender, e);
txt_scm_Validating(sender, e);
//txt_ngayra_Validating(sender, e);
txt_ngayvao_Validating(sender, e);
return;
}
THANNHAN tn = new THANNHAN();
tn.MATN = txt_matn.Text;
tn.TENTN = txt_tentn.Text;
tn.SOCMNDTN = txt_scm.Text;
if (rdo_nam.Checked == true)
{
tn.GIOITINH_TN = "Nam";
}
else
{
tn.GIOITINH_TN = "true";
}
THANNHAN_TAMTRU tntt = new THANNHAN_TAMTRU();
tntt.MAKT = cbo_makt.Text;
tntt.MATN = txt_matn.Text;
tntt.NGAYVAO = Convert.ToDateTime(txt_ngayvao.Text);
if (txt_ngayra.Text == string.Empty)
{
tntt.NGAYRA = Convert.ToDateTime(txt_ngayra.Text);
}
else
{
tntt.NGAYRA = null;
}
if (btn_them.Enabled == true && btn_sua.Enabled == false)
{
if (bll_thannhan.ktkc(tn.MATN) == true)
{
MessageBox.Show("trùng khóa chính thân nhân");
return;
}
if (dal_tntamtru.ktkc_thannhan_tamtru(tntt.MATN, tntt.MAKT) == true)
{
MessageBox.Show("trùng khóa chính thân nhân tạm trú");
return;
}
if (bll_thannhan.Them_ThanNhan(tn) == true && dal_tntamtru.them_Thannhantamtru(tntt) == true)
{
MessageBox.Show("Thành công");
grv_thannhan.DataSource = dal_tntamtru.loadthannhantheoma();
}
else
{
MessageBox.Show("Thất bại");
}
}
if (btn_sua.Enabled == true && btn_luu.Enabled == true)
{
tntt.NGAYRA = Convert.ToDateTime(txt_ngayra.Text);
if (bll_thannhan.sua_thanNhan(tn) == true && dal_tntamtru.sua_thannhan_tamtru(tntt) == true)
{
MessageBox.Show("Thành công");
grv_thannhan.DataSource = dal_tntamtru.loadthannhantheoma();
}
else
{
MessageBox.Show("Thất bại");
}
}
}