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