Download Plagiarism Scan Report and Code Analysis - Prof. Silva and more Summaries Law in PDF only on Docsity!
PLAGIARISM SCAN REPORT
Plagiarised
Unique
Content Checked For Plagiarism
public class Usuario { // Atributos public int Id { get; set; } public string Nome { get; set; } public string Email { get; set; }
// Relacionamento com Carrinho public virtual Carrinho Carrinho { get; set; } }
public class Produto { // Atributos public int Id { get; set; } public string Nome { get; set; } public decimal Preco { get; set; }
// Relacionamento com Carrinho public virtual Carrinho Carrinho { get; set; } }
public class Carrinho { // Atributos public int Id { get; set; } public DateTime DataCriacao { get; set; }
// Relacionamentos public virtual Usuario Usuario { get; set; } public virtual List Produtos { get; set; } } using System; using System.Collections.Generic; using System.Data.SqlClient;
public class CarrinhoRepository
Date 2023-11-
Words 828
Characters 9722
private string connectionString;
public CarrinhoRepository(string connectionString) { this.connectionString = connectionString; }
public Carrinho ObterCarrinhoPorId(int carrinhoId) { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM Carrinho WHERE Id = @CarrinhoId", connection)) { command.Parameters.AddWithValue("@CarrinhoId", carrinhoId);
using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { // Mapear os dados do banco para um objeto Carrinho Carrinho carrinho = new Carrinho { Id = reader.GetInt32(reader.GetOrdinal("Id")), DataCriacao = reader.GetDateTime(reader.GetOrdinal("DataCriacao")), // Outros mapeamentos };
return carrinho; } } } }
return null; // Retorna null se não encontrar o carrinho com o ID especificado }
public void AdicionarCarrinho(Carrinho carrinho) { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO Carrinho (DataCriacao) VALUES (@DataCriacao); SELECT SCOPE_IDENTITY();", connection)) { command.Parameters.AddWithValue("@DataCriacao", carrinho.DataCriacao);
// Executar o comando e obter o ID do novo carrinho int novoCarrinhoId = Convert.ToInt32(command.ExecuteScalar());
// Definir o ID do carrinho recém-criado
using (SqlCommand command = new SqlCommand("SELECT * FROM Carrinho", connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Carrinho carrinho = MapearCarrinho(reader); carrinhos.Add(carrinho); } } } }
return carrinhos; }
public Carrinho ObterCarrinhoPorId(int carrinhoId) { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM Carrinho WHERE Id = @CarrinhoId", connection)) { command.Parameters.AddWithValue("@CarrinhoId", carrinhoId);
using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { return MapearCarrinho(reader); } } } }
return null; // Retorna null se não encontrar o carrinho com o ID especificado }
public void AdicionarCarrinho(Carrinho carrinho) { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO Carrinho (DataCriacao) VALUES (@DataCriacao); SELECT SCOPE_IDENTITY();", connection)) { command.Parameters.AddWithValue("@DataCriacao", carrinho.DataCriacao);
int novoCarrinhoId = Convert.ToInt32(command.ExecuteScalar());
carrinho.Id = novoCarrinhoId;
foreach (Produto produto in carrinho.Produtos) { AdicionarProdutoAoCarrinho(novoCarrinhoId, produto); } } } }
public void AtualizarCarrinho(Carrinho carrinho) { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open();
using (SqlCommand command = new SqlCommand("UPDATE Carrinho SET DataCriacao = @DataCriacao WHERE Id = @CarrinhoId", connection)) { command.Parameters.AddWithValue("@DataCriacao", carrinho.DataCriacao); command.Parameters.AddWithValue("@CarrinhoId", carrinho.Id);
command.ExecuteNonQuery(); } } }
public void ExcluirCarrinho(int carrinhoId) { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open();
using (SqlCommand command = new SqlCommand("DELETE FROM Carrinho WHERE Id = @CarrinhoId", connection)) { command.Parameters.AddWithValue("@CarrinhoId", carrinhoId);
command.ExecuteNonQuery(); } } }
private void AdicionarProdutoAoCarrinho(int carrinhoId, Produto produto) { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO Produto (CarrinhoId, Nome, Preco) VALUES (@CarrinhoId, @Nome, @Preco)", connection)) { command.Parameters.AddWithValue("@CarrinhoId", carrinhoId); command.Parameters.AddWithValue("@Nome", produto.Nome); command.Parameters.AddWithValue("@Preco", produto.Preco);
command.ExecuteNonQuery();
public class Produto { public int Id { get; set; } public string Nome { get; set; } public decimal Preco { get; set; } }
Gerenciamento de Carrinhos
Gerenciamento de Carrinhos
Matched Source
Similarity 18%
Title : Identifier expected c# - Stack Overflow
https://stackoverflow.com/questions/10979827/identifier-expected-c-sharp
Similarity 10%
Title : stackoverflow.com › questions › 72282458properties - explain public variable ; (vs) public variable ... May 18, 2022 · public class Dog { public string Name { get; set; } } This definitely creates a field in the background, and I can find out by using ILSpy to decompile it and we see the following: Notice the Name property is there as you'd expect, with its getter and setter. https://stackoverflow.com/questions/72282458/explain-public-variable-vs-public-variable-get-set-difference-in-c/
Similarity 25%
Title : Posting Data to Existing Server Database? - Sitefinity
https://community-archive.progress.com/forums/00295/40161.html
Similarity 8%
Title : Criação de uma aplicação Web ASP.NET MVC usando ...
https://docplayer.com.br/2136930-Criacao-de-uma-aplicacao-web-asp-net-mvc-usando-code-first.html
