private void btn_Sua_Click(object sender, EventArgs e)
{
QL_NhomND nhomND = new QL_NhomND();
nhomND.MaNhom = txt_MaNhom.Text;
nhomND.TenNhom = txt_TenNhom.Text;
nhomND.GhiChu = txt_GhiChu.Text;
if (busNhomND.Sua(nhomND) == 1)
{
MessageBox.Show("Thành công");
}
else
{
MessageBox.Show("Thất bại");
}
}
public int Xoa(QL_NhomND pNhomND)
{
try
{
SqlDataAdapter sqlda_NhomND = new SqlDataAdapter("select * from QL_NhomNguoiDung", cnn);
DataRow dr_NhomND = ds_QLChamCong.Tables["QL_NhomNguoiDung"].Rows.Find(pNhomND.MaNhom);
if (dr_NhomND != null)
{
dr_NhomND.Delete();
}
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(sqlda_NhomND);
sqlda_NhomND.Update(ds_QLChamCong, "QL_NhomNguoiDung");
return(1);
}
catch
{
return(0);
}
}
public int Them(QL_NhomND pNhomND)
{
try
{
SqlDataAdapter sqlda_NhomND = new SqlDataAdapter("select * from QL_NhomNguoiDung", cnn);
DataRow dr_NhomND = ds_QLChamCong.Tables["QL_NhomNguoiDung"].NewRow();
dr_NhomND["MaNhom"] = pNhomND.MaNhom;
dr_NhomND["TenNhom"] = pNhomND.TenNhom;
dr_NhomND["GhiChu"] = pNhomND.GhiChu;
ds_QLChamCong.Tables["QL_NhomNguoiDung"].Rows.Add(dr_NhomND);
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(sqlda_NhomND);
sqlda_NhomND.Update(ds_QLChamCong, "QL_NhomNguoiDung");
return(1);
}
catch
{
return(0);
}
}
public int Sua(QL_NhomND pNhomND)
{
return(dalNhomND.Sua(pNhomND));
}
public int Xoa(QL_NhomND pNhomND)
{
return(dalNhomND.Xoa(pNhomND));
}
public int Them(QL_NhomND pNhomND)
{
return(dalNhomND.Them(pNhomND));
}
