public void UpdateCD(DTOCD DTOCd)
{
string cmd = string.Format($@"UPDATE TBL_CD SET nome = '{DTOCd.NomeCD}',
precoVenda = '{DTOCd.PrecoVenda}
'WHERE idCD = '{DTOCd.IdCD}'");
DALBanco.ExecuteQuery(cmd);
}
public void InsertCD(DTOCD DTOCd)
{
string cmd = string.Format($@"INSERT INTO TBL_CD VALUES(NULL, '{DTOCd.NomeCD}',
'{DTOCd.PrecoVenda}',
'{DTOCd.DtLancamento.ToString("yyyy/MM/dd HH:mm:ss")}');");
DALBanco.ExecuteQuery(cmd);
}
public void DeleteCD(DTOCD DTOCd)
{
string cmd = string.Format($@"DELETE FROM TBL_CD WHERE idCD = '{DTOCd.IdCD}'");
DALBanco.ExecuteQuery(cmd);
}
