public bool them(QLNDNHOMND pmh)
{
try
{
da.QLNDNHOMNDs.InsertOnSubmit(pmh);
da.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool xoa(QLNDNHOMND pmh)
{
try
{
QLNDNHOMND mh = da.QLNDNHOMNDs.Where(t => t.TENDN == pmh.TENDN.ToString() && t.MANHOM == pmh.MANHOM.ToString()).FirstOrDefault();
da.QLNDNHOMNDs.DeleteOnSubmit(mh);
da.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool sua(QLNDNHOMND pmh)
{
try
{
QLNDNHOMND thanhvien = da.QLNDNHOMNDs.Where(t => t.TENDN == pmh.TENDN.ToString() && t.MANHOM == pmh.MANHOM.ToString()).FirstOrDefault();
thanhvien.MANHOM = pmh.MANHOM;
thanhvien.GHICHU = pmh.GHICHU;
da.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool ktkc(QLNDNHOMND ma)
{
int r = da.QLNDNHOMNDs.Count(t => t.TENDN == ma.TENDN.ToString() && t.MANHOM == ma.MANHOM.ToString());
try
{
if (r == 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
private void button1_Click(object sender, EventArgs e)
{
QLNDNHOMND ndnnd = new QLNDNHOMND();
ndnnd.TENDN = dataGridView_NDNhomND.CurrentRow.Cells[0].Value.ToString();
ndnnd.MANHOM = cbo_NHomND.SelectedValue.ToString();
if (bll_ndnnd.ktkc(ndnnd) == false)
{
if (bll_ndnnd.xoandnnd(ndnnd) == true)
{
MessageBox.Show("thành công");
dataGridView_NDNhomND.DataSource = bll.Load_NDnhomND();
}
else
{
MessageBox.Show("thất bại");
}
}
else
{
MessageBox.Show("dữ liệu không tồn tại");
}
}
private void btn_ThemND_Click(object sender, EventArgs e)
{
QLNDNHOMND ndnnd = new QLNDNHOMND();
ndnnd.TENDN = dataGridView_QLND.CurrentRow.Cells[4].Value.ToString();
ndnnd.MANHOM = cbo_NHomND.SelectedValue.ToString();
ndnnd.GHICHU = textBox1.Text.ToString();
if (bll_ndnnd.ktkc(ndnnd) == true)
{
if (bll_ndnnd.themndnnd(ndnnd) == true)
{
MessageBox.Show("thêm thành công");
dataGridView_NDNhomND.DataSource = bll.Load_NDnhomND();
}
else
{
MessageBox.Show("thất bại");
}
}
else
{
MessageBox.Show("trùng mã");
}
}
public bool suandndn(QLNDNHOMND n)
{
return(dl.sua(n));
}
public bool xoandnnd(QLNDNHOMND n)
{
return(dl.xoa(n));
}
public bool themndnnd(QLNDNHOMND n)
{
return(dl.them(n));
}
public bool ktkc(QLNDNHOMND n)
{
return(dl.ktkc(n));
}
