public HT_Nhom_Nguoi_Dung_Chi_Tiet Lay(int Ma_Nhom_Nguoi_Dung) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("HT_Nhom_Nguoi_Dung_Lay", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pMa_Nhom_Nguoi_Dung = new SqlParameter("@Ma_Nhom_Nguoi_Dung", SqlDbType.Int, 4); pMa_Nhom_Nguoi_Dung.Value = Ma_Nhom_Nguoi_Dung; myCommand.Parameters.Add(pMa_Nhom_Nguoi_Dung); SqlParameter pTen_Nhom_Nguoi_Dung = new SqlParameter("@Ten_Nhom_Nguoi_Dung", SqlDbType.NVarChar, 250); pTen_Nhom_Nguoi_Dung.Direction = ParameterDirection.Output; myCommand.Parameters.Add(pTen_Nhom_Nguoi_Dung); SqlParameter pSTT = new SqlParameter("@STT", SqlDbType.Int, 4); pSTT.Direction = ParameterDirection.Output; myCommand.Parameters.Add(pSTT); myConnection.Open(); myCommand.ExecuteNonQuery(); HT_Nhom_Nguoi_Dung_Chi_Tiet myHT_Nhom_Nguoi_Dung_Chi_Tiet = new HT_Nhom_Nguoi_Dung_Chi_Tiet(); myHT_Nhom_Nguoi_Dung_Chi_Tiet.Ma_Nhom_Nguoi_Dung = Ma_Nhom_Nguoi_Dung; myHT_Nhom_Nguoi_Dung_Chi_Tiet.Ten_Nhom_Nguoi_Dung = (string)pTen_Nhom_Nguoi_Dung.Value; myHT_Nhom_Nguoi_Dung_Chi_Tiet.STT = (int)pSTT.Value; return(myHT_Nhom_Nguoi_Dung_Chi_Tiet); } } }
public void Cap_Nhat(HT_Nhom_Nguoi_Dung_Chi_Tiet myHT_Nhom_Nguoi_Dung_Chi_Tiet) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("HT_Nhom_Nguoi_Dung_Cap_Nhat", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pMa_Nhom_Nguoi_Dung = new SqlParameter("@Ma_Nhom_Nguoi_Dung", SqlDbType.Int, 4); pMa_Nhom_Nguoi_Dung.Value = myHT_Nhom_Nguoi_Dung_Chi_Tiet.Ma_Nhom_Nguoi_Dung; myCommand.Parameters.Add(pMa_Nhom_Nguoi_Dung); SqlParameter pTen_Nhom_Nguoi_Dung = new SqlParameter("@Ten_Nhom_Nguoi_Dung", SqlDbType.NVarChar, 250); pTen_Nhom_Nguoi_Dung.Value = myHT_Nhom_Nguoi_Dung_Chi_Tiet.Ten_Nhom_Nguoi_Dung; myCommand.Parameters.Add(pTen_Nhom_Nguoi_Dung); SqlParameter pSTT = new SqlParameter("@STT", SqlDbType.Int, 4); pSTT.Value = myHT_Nhom_Nguoi_Dung_Chi_Tiet.STT; myCommand.Parameters.Add(pSTT); myConnection.Open(); myCommand.ExecuteNonQuery(); } } }