public HT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet Lay(int Ma_Lien_Ket)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("HT_Nhom_Nguoi_Dung_Nguoi_Dung_Lay", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pMa_Lien_Ket = new SqlParameter("@Ma_Lien_Ket", SqlDbType.Int, 4);
pMa_Lien_Ket.Value = Ma_Lien_Ket;
myCommand.Parameters.Add(pMa_Lien_Ket);
SqlParameter pMa_Nhom_Nguoi_Dung = new SqlParameter("@Ma_Nhom_Nguoi_Dung", SqlDbType.Int, 4);
pMa_Nhom_Nguoi_Dung.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(pMa_Nhom_Nguoi_Dung);
SqlParameter pMa_Nguoi_Dung = new SqlParameter("@Ma_Nguoi_Dung", SqlDbType.Int, 4);
pMa_Nguoi_Dung.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(pMa_Nguoi_Dung);
myConnection.Open();
myCommand.ExecuteNonQuery();
HT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet myHT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet = new HT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet();
myHT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet.Ma_Lien_Ket = Ma_Lien_Ket;
myHT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet.Ma_Nhom_Nguoi_Dung = (int)pMa_Nhom_Nguoi_Dung.Value;
myHT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet.Ma_Nguoi_Dung = (int)pMa_Nguoi_Dung.Value;
return(myHT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet);
}
}
}
public void Cap_Nhat(HT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet myHT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("HT_Nhom_Nguoi_Dung_Nguoi_Dung_Cap_Nhat", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pMa_Lien_Ket = new SqlParameter("@Ma_Lien_Ket", SqlDbType.Int, 4);
pMa_Lien_Ket.Value = myHT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet.Ma_Lien_Ket;
myCommand.Parameters.Add(pMa_Lien_Ket);
SqlParameter pMa_Nhom_Nguoi_Dung = new SqlParameter("@Ma_Nhom_Nguoi_Dung", SqlDbType.Int, 4);
pMa_Nhom_Nguoi_Dung.Value = myHT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet.Ma_Nhom_Nguoi_Dung;
myCommand.Parameters.Add(pMa_Nhom_Nguoi_Dung);
SqlParameter pMa_Nguoi_Dung = new SqlParameter("@Ma_Nguoi_Dung", SqlDbType.Int, 4);
pMa_Nguoi_Dung.Value = myHT_Nhom_Nguoi_Dung_Nguoi_Dung_Chi_Tiet.Ma_Nguoi_Dung;
myCommand.Parameters.Add(pMa_Nguoi_Dung);
myConnection.Open();
myCommand.ExecuteNonQuery();
}
}
}
