private void btnAltaCantante_Click(object sender, EventArgs e)
{
ArtistDAL dal = new ArtistDAL();
Artist artista = new Artist(txtNombreArtista.Text);
dal.insertArtist(artista);
MessageBox.Show("Alta Correcta");
}
private void btnBuscar_Click(object sender, EventArgs e)
{
DataTable Items = new DataTable();
ArtistDAL aD = new ArtistDAL();
if ((txtBusqueda.Text != "") && ((cmbBuscar.Text == "Artista") || (cmbBuscar.Text == "Album") || (cmbBuscar.Text == "Canción")))
{
dataGridBuscar.Rows.Clear();
dataGridBuscar.Columns.Clear();
switch (cmbBuscar.Text)
{
case "Artista":
Items = aD.selectArtist(txtBusqueda.Text);
dataGridBuscar.Columns.Add("Artista", "Artista");
try
{
dataGridBuscar.Rows.Add(Items.Rows[0].ItemArray);
}catch
{
MessageBox.Show("Artista no encontrado.");
}
break;
case "Album":
Items = aD.selectArtistByAlbum(txtBusqueda.Text);
dataGridBuscar.Columns.Add("Artista", "Artista");
dataGridBuscar.Columns.Add("Album", "Album");
try
{
dataGridBuscar.Rows.Add(Items.Rows[0].ItemArray);
}
catch
{
MessageBox.Show("Album no encontrado.");
}
break;
case "Canción":
Items = aD.selectArtistByTrack(txtBusqueda.Text);
dataGridBuscar.Columns.Add("Artista", "Artista");
dataGridBuscar.Columns.Add("Album", "Album");
dataGridBuscar.Columns.Add("Canción", "Canción");
try
{
dataGridBuscar.Rows.Add(Items.Rows[0].ItemArray);
}
catch
{
MessageBox.Show("Canción no encontrada.");
}
break;
}
}
else
{
MessageBox.Show("¡Introduce un tipo y/o un nombre de elemento a buscar!");
}
}
/// <summary>
/// Delete an artist
/// </summary>
public static void DeleteArtist(int artistID)
{
foreach (var album in GetAlbumsByArtistId(artistID))
{
DeleteAlbumArt(album.AlbumID);
}
ArtistDAL.DeleteArtist(artistID);
DeleteArtistArt(artistID);
}
private void btnMostrarTodosArtistas_Click(object sender, EventArgs e)
{
ArtistDAL aD = new ArtistDAL();
DataTable dt = new DataTable();
dataGridBuscar.Columns.Add("Artista", "Artista");
dt = aD.selectAllArtist();
for (int i = 0; i < dt.Rows.Count; i++)
{
dataGridBuscar.Rows.Add(dt.Rows[i].ItemArray[1].ToString());
}
}
private void AlbumForm_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'chinookDataSet.Track' table. You can move, or remove it, as needed.
// this.trackTableAdapter.Fill(this.chinookDataSet.Track);
ArtistDAL aD = new ArtistDAL();
DataTable dt = new DataTable();
dt = aD.selectAllArtist();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbArtistas.Items.Add(dt.Rows[i].ItemArray[1].ToString());
}
}
private void btnAlbumAlta_Click(object sender, EventArgs e)
{
ArtistDAL dal = new ArtistDAL();
DataTable dt = new DataTable();
string nombreArtista = cbArtistas.SelectedItem.ToString();
dt = dal.selectArtistForm(nombreArtista);
string s = dt.Rows[0].ItemArray[0].ToString();
Album album = new Album(int.Parse(s), txtNombreAlbum.Text);
dal.insertAlbum(album);
MessageBox.Show("Alta Correcta");
}
/// <summary>
/// Save the artist
/// </summary>
public static void SaveArtist(Artist artist)
{
if (!artist.Validate())
{
throw new ValidationException();
}
if (artist.ArtistID == 0)
{
ArtistDAL.InsertArtist(artist);
}
else
{
ArtistDAL.UpdateArtist(artist);
}
}
private void btnAltaCancion_Click(object sender, EventArgs e)
{
ArtistDAL dal = new ArtistDAL();
DataTable dt = new DataTable();
dt = dal.selectAlbum(txtNombreAlbum.Text);
int albumId = int.Parse(dt.Rows[0].ItemArray[0].ToString());
Track pista = new Track(txtNombreCancion.Text, albumId, int.Parse(txtDuracion.Text));
dal.insertTrack(pista);
DataTable dtCancion = dal.selectTrack(txtNombreAlbum.Text);
DataRow workRow = dtCancion.NewRow();
workRow[0] = dtCancion.Rows[0].ItemArray[0];
workRow[1] = int.Parse(txtDuracion.Text);
//dtCancion.Rows.Add(workRow);
dataGridView1.DataSource = dtCancion;
}
/// <summary>
/// Search artists
/// </summary>
public static IEnumerable <Artist> SearchArtists(String query)
{
return(ArtistDAL.SearchArtists(query));
}
/// <summary>
/// Get an artist
/// </summary>
public static Artist GetArtistById(int artistID)
{
return(ArtistDAL.GetArtistById(artistID));
}
/// <summary>
/// Get all artists
/// </summary>
public static IEnumerable <Artist> GetArtists()
{
return(ArtistDAL.GetArtists());
}
