private void NuevoToolStripButton_Click(object sender, EventArgs e) { AlbumAEForm frm = new AlbumAEForm(); frm.Text = "Nuevo Album"; DialogResult dr = frm.ShowDialog(this); if (dr == DialogResult.OK) { try { AlbumEditDto albumEditDto = frm.GetAlbum(); int interpreteId = frm.GetInterpreteId(); var album = Mapeador.ConvertirAlbum(albumEditDto, interpreteId); servicio.Agregar(album); var r = ConstruirFila(); AlbumListDto albumListDto = Mapeador.ConvertirAlbumListDto(albumEditDto); SetearFila(r, albumListDto); AgregarFila(r); Helper.MensajeBox("Registro agregado con exitó", Tipo.Success); } catch (Exception ex) { Helper.MensajeBox(ex.Message, Tipo.Error); } } }
private void SetearFila(DataGridViewRow r, AlbumListDto album) { r.Cells[cmnAlbum.Index].Value = album.Titulo; r.Cells[cmnInterprete.Index].Value = album.Interprete; r.Cells[cmnPistas.Index].Value = album.Pistas; r.Tag = album; }
public List <AlbumListDto> GetLista() { try { List <AlbumListDto> lista = new List <AlbumListDto>(); var cadenaDeComando = "SELECT AlbumId,Album,Interprete,Pistas FROM Albumes INNER JOIN Interpretes " + "ON Interpretes.InterpreteId=Albumes.InterpreteId"; var comando = new SqlCommand(cadenaDeComando, cn); var reader = comando.ExecuteReader(); while (reader.Read()) { AlbumListDto albumDto = ConstruirAlbumDto(reader); lista.Add(albumDto); } reader.Close(); return(lista); } catch (Exception e) { throw new Exception(e.Message); } }
private void detalleToolStripButton_Click(object sender, EventArgs e) { if (DatosDataGridView.SelectedRows.Count == 0) { return; } var r = DatosDataGridView.SelectedRows[0]; AlbumListDto albumDto = (AlbumListDto)r.Tag; try { Album album = servicio.GetAlbumPorId(albumDto.AlbumId); DetallesAlbumForm frm = new DetallesAlbumForm(); frm.SetAlbum(album); frm.ShowDialog(this); } catch (Exception exception) { Helper.mensajeBox(exception.Message, Tipo.Error); } }
private void NuevoToolStripButton_Click(object sender, EventArgs e) { AlbumesAEForm frm = new AlbumesAEForm(); DialogResult dr = frm.ShowDialog(this); if (dr == DialogResult.OK) { try { Album album = frm.GetAlbum(); servicio.Guardar(album); DataGridViewRow r = ConstruirFila(); AlbumListDto albumListDto = Mapeador.CrearMapper().Map <Album, AlbumListDto>(album); SetearFila(r, albumListDto); AgregarFila(r); Helper.mensajeBox("Registro agregado con éxito", Tipo.Success); } catch (Exception exception) { Helper.mensajeBox(exception.Message, Tipo.Error); } } }
public async Task <AlbumListDto> GetAlbumsAsync( int?page = Constants.Contracts.Services.Album.Operations.Gets.PARAMETER_PAGE, int?pageSize = Constants.Contracts.Services.Album.Operations.Gets.PARAMETER_PAGE_SIZE, string sortExpression = Constants.Contracts.Services.Album.Operations.Gets.PARAMETER_SORTEXPRESSION) { AlbumListDto result = new AlbumListDto(); var albums = await this.albumRepository.GetAllAsync( query => true, query => (IOrderedQueryable <Album>) query.OrderBy(sortExpression), new List <Expression <Func <Album, object> > >() { u => u.Artist }, page, pageSize); if (albums == null) { return(result); } result.FilteredCount = albums.FilteredCount; result.TotalCount = albums.TotalCount; foreach (var album in albums.PageData) { result.PageData.Add( new AlbumListItemDto { AlbumId = album.Id, AlbumName = album.Name, AlbumType = (Models.AlbumType)album.AlbumType, ArtistName = album.Artist.Name, Stock = album.Stock }); } return(result); }
private void EditarToolStripButton_Click(object sender, EventArgs e) { if (DatosDataGridView.SelectedRows.Count == 0) { return; } var r = DatosDataGridView.SelectedRows[0]; AlbumListDto albumDto = (AlbumListDto)r.Tag; try { Album album = servicio.GetAlbumPorId(albumDto.AlbumId); AlbumesAEForm frm = new AlbumesAEForm(); frm.SetAlbum(album); DialogResult dr = frm.ShowDialog(this); if (dr == DialogResult.OK) { try { servicio.Guardar(album); albumDto = Mapeador.CrearMapper().Map <Album, AlbumListDto>(album); SetearFila(r, albumDto); Helper.mensajeBox("Album Modificado", Tipo.Success); } catch (Exception exception) { Helper.mensajeBox(exception.Message, Tipo.Error); } } } catch (Exception exception) { Helper.mensajeBox(exception.Message, Tipo.Error); } }