public void CapNhatQuyen_NhanVien(string manv, CTQuyenCollection ctquyenColl)
{
if (ctquyenColl != null && ctquyenColl.Count != 0)
{
//xóa hết
SqlConnection cnn = new SqlConnection(cnnstr);
SqlCommand cmdXoa = new SqlCommand("DELETE from Nhanvien_Quyen where manv=@manv ", cnn);
cmdXoa.Parameters.AddWithValue("@manv", manv);
cnn.Open();
cmdXoa.ExecuteNonQuery();
cnn.Close();
//thêm lại từ đầu
for (int i = 0; i < ctquyenColl.Count; i++)
{
SqlCommand cmdLuu = new SqlCommand("INSERT into Nhanvien_Quyen VALUES(@manv,@mactquyen)", cnn);
cmdLuu.Parameters.AddWithValue("@manv", manv);
cmdLuu.Parameters.AddWithValue("@mactquyen", ctquyenColl.Index(i).MaCTQuyen);
cnn.Open();
cmdLuu.ExecuteNonQuery();
cnn.Close();
}
}
}
