private void button1_Click(object sender, EventArgs e)
{
//execute sql based on given parameters
MusicianBand musicianBand = new MusicianBand();
musicianBand.musicianId = lsbxMusicians.SelectedIndex;
musicianBand.bandId = cmbxBands.SelectedIndex;
musicianBand.joinedBand = txtJoined.Text;
musicianBand.leftBand = txtLeft.Text;
if (rBtnPlayed.Checked)
{
musicianBand.playedOnRelease = true;
}
mdbRepo.CreateRelationship(musicianBand);
MessageBox.Show("Musicians added to band");
}
public void CreateRelationship(MusicianBand musicianBand)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("sp_MusicianBandInsert", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MusicianID", musicianBand.musicianId);
cmd.Parameters.AddWithValue("@BandID", musicianBand.bandId);
cmd.Parameters.AddWithValue("@JoinedBand", musicianBand.joinedBand);
cmd.Parameters.AddWithValue("@LeftBand", musicianBand.leftBand);
cmd.Parameters.AddWithValue("@PlayedOnRelease", musicianBand.playedOnRelease);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
//if (i != 0)
//{
// //add error
//}
}
}
