public void InserirCD(tblCdDTO ObjCD)
{
string sql = string.Format($@"INSERT INTO tbl_cliente VALUES (NULL,'{ObjCD.NomeCD}',
'{ObjCD.PrecoVenda}',
'{ObjCD.DtLancamento}');");
DaoBanco.executarComando(sql);
}
public void AlterarCD(tblCdDTO dtoCd)
{
string sql = string.Format($@"UPDATE tbl_cd set nomeCD = '{dtoCd.NomeCD}',
precoVenda = '{dtoCd.PrecoVenda}',
dtLancamento = '{dtoCd.DtLancamento}'
where idCD = '{dtoCd.IdCD}';");
DaoBanco.executarComando(sql);
}
public void ExcluirCD(tblCdDTO objCD)
{
string sql = string.Format($@"DELETE FROM tbl_cd where idCD = {objCD.IdCD};");
DaoBanco.executarComando(sql);
}
