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);
}
}
