public override Midia InsertMidia(MidiaType midia_type, string nome_album)
{
Midia new_album = new CD(nome_album);
string sql = "INSERT INTO CD (nome_album) " +
"VALUES (@Nome_Album)";
SqlCommand cmd = new SqlCommand(sql, SqlDbConnection.getConnection());
cmd.Parameters.AddWithValue("@Nome_Album", nome_album);
cmd.CommandType = CommandType.Text;
SqlDbConnection.cn.Open();
try
{
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Console.WriteLine("Registro incluido com sucesso!");
}
}
catch (Exception ex)
{
Console.WriteLine("Erro: " + ex.ToString());
}
finally
{
SqlDbConnection.cn.Close();
}
return(new_album);
}
//Evento DeleteButton_Click
private void btn_pnlCollections_Delete_Click(object sender, EventArgs e)
{
var confirmResult = MessageBox.Show("Are you sure to delete this item?",
"Confirm Delete!",
MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
if (listView_pnlCollections_Albuns.SelectedItems.Count > 0)
{
var codigo = listView_pnlCollections_Albuns.Items[listView_pnlCollections_Albuns.SelectedItems[0].Index].SubItems[4];
MidiaType album_type = (MidiaType)comboBox_pnlCollections_ColecaoSelecionada.SelectedItem;
switch (album_type)
{
case MidiaType.TAPE:
new_factory = new TapeFactory();
new_factory.EraseMidia(int.Parse(codigo.Text));
break;
case MidiaType.VINYL:
new_factory = new VinylFactory();
new_factory.EraseMidia(int.Parse(codigo.Text));
break;
case MidiaType.CD:
new_factory = new CDFactory();
new_factory.EraseMidia(int.Parse(codigo.Text));
break;
case MidiaType.DVD:
new_factory = new DVDFactory();
new_factory.EraseMidia(int.Parse(codigo.Text));
break;
case MidiaType.BLURAY:
new_factory = new BluRayFactory();
new_factory.EraseMidia(int.Parse(codigo.Text));
break;
case MidiaType.VCR:
new_factory = new VCRFactory();
new_factory.EraseMidia(int.Parse(codigo.Text));
break;
}
}
}
else
{
// If 'No', do something here.
}
listView_pnlCollections_Albuns.Items.Clear();
PopulateLV();
}
public override Midia CreateMidia(MidiaType midia_type, string nome_album)
{
obj_dao = new VCR_DAO();
new_album = obj_dao.InsertMidia(midia_type, nome_album);
return(new_album);
//throw new NotImplementedException();
}
public override void IntegratedTest()
{
var type = new MidiaType
{
Description = "TESTE",
Extensions = "ext,para,teste"
};
var id = _service.Insert(type);
_service.Delete(id);
}
public override void IntegratedTest()
{
var type = new MidiaType
{
Description = "TESTEEE",
Extensions = "jpeg,jpg,gif,png"
};
_service.Insert(type);
//_service.Delete(id);
}
private void btn_pnlNewAlbum_saveNewAlbum_Click(object sender, EventArgs e)
{
//Recebe o tipo de midia selecionado na combo box
MidiaType album_type = (MidiaType)comboBox_pnlNewAlbum_albumType.SelectedItem;
switch (album_type)
{
case MidiaType.TAPE:
new_factory = new TapeFactory();
new_factory.CreateMidia(album_type, tb_pnlNewAlbum_albumTitle.Text);
break;
case MidiaType.VINYL:
new_factory = new VinylFactory();
new_factory.CreateMidia(album_type, tb_pnlNewAlbum_albumTitle.Text);
break;
case MidiaType.CD:
new_factory = new CDFactory();
new_factory.CreateMidia(album_type, tb_pnlNewAlbum_albumTitle.Text);
break;
case MidiaType.DVD:
new_factory = new DVDFactory();
new_factory.CreateMidia(album_type, tb_pnlNewAlbum_albumTitle.Text);
break;
case MidiaType.BLURAY:
new_factory = new BluRayFactory();
new_factory.CreateMidia(album_type, tb_pnlNewAlbum_albumTitle.Text);
break;
case MidiaType.VCR:
new_factory = new VCRFactory();
new_factory.CreateMidia(album_type, tb_pnlNewAlbum_albumTitle.Text);
break;
}
panel_NewAlbum.Visible = false;
}
public abstract Midia CreateMidia(MidiaType midia_type, string nome_album);
public abstract Midia InsertMidia(MidiaType midia_type, string nome_album);
public void ValidateTest()
{
var midiaType = new MidiaType();
_service.Insert(midiaType);
}
/// <summary>
/// /Chama o Factory.UpdateMidia para atualizar dados sobre albuns
/// </summary>
private void UploadAlbumData()
{
if (listView_pnlCollections_Albuns.SelectedItems.Count > 0 && tb_pnlCollections_NomeAlbum.Text != "")
{
var codigo = listView_pnlCollections_Albuns.Items[listView_pnlCollections_Albuns.SelectedItems[0].Index].SubItems[4];
MidiaType album_type = (MidiaType)comboBox_pnlCollections_ColecaoSelecionada.SelectedItem;
switch (album_type)
{
case MidiaType.TAPE:
new_factory = new TapeFactory();
new_factory.EditMidia(int.Parse(codigo.Text), tb_pnlCollections_NomeAlbum.Text, tb_pnlCollections_Artista.Text,
int.Parse(tb_pnlCollections_AnoLancamento.Text), tb_pnlCollections_Gravadora.Text, tb_pnlCollections_Publisher.Text,
int.Parse(tb_pnlCollections_QtdFaixas.Text), float.Parse(tb_pnlCollections_ValorCompra.Text), comboBox_pnlCollections_Genero.Text,
int.Parse(tb_pnlCollections_Estrelas.Text));
break;
case MidiaType.VINYL:
new_factory = new VinylFactory();
new_factory.EditMidia(int.Parse(codigo.Text), tb_pnlCollections_NomeAlbum.Text, tb_pnlCollections_Artista.Text,
int.Parse(tb_pnlCollections_AnoLancamento.Text), tb_pnlCollections_Gravadora.Text, tb_pnlCollections_Publisher.Text,
int.Parse(tb_pnlCollections_QtdFaixas.Text), float.Parse(tb_pnlCollections_ValorCompra.Text), comboBox_pnlCollections_Genero.Text,
int.Parse(tb_pnlCollections_Estrelas.Text));
break;
case MidiaType.CD:
new_factory = new CDFactory();
new_factory.EditMidia(int.Parse(codigo.Text), tb_pnlCollections_NomeAlbum.Text, tb_pnlCollections_Artista.Text,
int.Parse(tb_pnlCollections_AnoLancamento.Text), tb_pnlCollections_Gravadora.Text, tb_pnlCollections_Publisher.Text,
int.Parse(tb_pnlCollections_QtdFaixas.Text), float.Parse(tb_pnlCollections_ValorCompra.Text), comboBox_pnlCollections_Genero.Text,
int.Parse(tb_pnlCollections_Estrelas.Text));
break;
case MidiaType.DVD:
new_factory = new DVDFactory();
new_factory.EditMidia(int.Parse(codigo.Text), tb_pnlCollections_NomeAlbum.Text, tb_pnlCollections_Artista.Text,
int.Parse(tb_pnlCollections_AnoLancamento.Text), tb_pnlCollections_Gravadora.Text, tb_pnlCollections_Publisher.Text,
int.Parse(tb_pnlCollections_QtdFaixas.Text), float.Parse(tb_pnlCollections_ValorCompra.Text), comboBox_pnlCollections_Genero.Text,
int.Parse(tb_pnlCollections_Estrelas.Text));
break;
case MidiaType.BLURAY:
new_factory = new BluRayFactory();
new_factory.EditMidia(int.Parse(codigo.Text), tb_pnlCollections_NomeAlbum.Text, tb_pnlCollections_Artista.Text,
int.Parse(tb_pnlCollections_AnoLancamento.Text), tb_pnlCollections_Gravadora.Text, tb_pnlCollections_Publisher.Text,
int.Parse(tb_pnlCollections_QtdFaixas.Text), float.Parse(tb_pnlCollections_ValorCompra.Text), comboBox_pnlCollections_Genero.Text,
int.Parse(tb_pnlCollections_Estrelas.Text));
break;
case MidiaType.VCR:
new_factory = new VCRFactory();
new_factory.EditMidia(int.Parse(codigo.Text), tb_pnlCollections_NomeAlbum.Text, tb_pnlCollections_Artista.Text,
int.Parse(tb_pnlCollections_AnoLancamento.Text), tb_pnlCollections_Gravadora.Text, tb_pnlCollections_Publisher.Text,
int.Parse(tb_pnlCollections_QtdFaixas.Text), float.Parse(tb_pnlCollections_ValorCompra.Text), comboBox_pnlCollections_Genero.Text,
int.Parse(tb_pnlCollections_Estrelas.Text));
break;
}
}
}
public Midia()
{
MidiaType = new MidiaType();
}
