public CompradorResult AdicionarComprador(Comprador comprador)
{
CompradorResult result = new CompradorResult();
SqlConnection conn = new SqlConnection(_sqlConn.SqlConnection);
string sql = "INSERT INTO Comprador(Nome, Sobrenome) VALUES(@nome, @sobrenome)";
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@nome", comprador.Nome));
cmd.Parameters.Add(new SqlParameter("@sobrenome", comprador.Sobrenome));
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
result.ProccessOk = false;
result.MsgError = ex.ToString();
return(result);
}
finally
{
conn.Close();
}
result.ProccessOk = true;
return(result);
}
public CompradorResult GetComprador(int id)
{
CompradorResult result = new CompradorResult();
SqlConnection conn = new SqlConnection(_sqlConn.SqlConnection);
string sql = "SELECT * FROM Comprador WHERE id=@id";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
result.Comprador.Id = int.Parse(reader["Id"].ToString());
result.Comprador.Nome = reader["Nome"].ToString();
result.Comprador.Sobrenome = reader["Sobrenome"].ToString();
}
}
catch (Exception ex)
{
result.ProccessOk = false;
result.MsgError = ex.ToString();
return(result);
}
finally
{
conn.Close();
}
result.ProccessOk = true;
return(result);
}
public CompradorResult AtualizarComprador(Comprador comprador)
{
CompradorResult result = new CompradorResult();
SqlConnection conn = new SqlConnection(_sqlConn.SqlConnection);
string sql = "UPDATE Comprador SET Nome = @nome, Sobrenome = @sobrenome WHERE Id = @id";
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@sobrenome", comprador.Sobrenome));
cmd.Parameters.Add(new SqlParameter("@nome", comprador.Nome));
cmd.Parameters.Add(new SqlParameter("@id", comprador.Id));
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
result.ProccessOk = false;
result.MsgCatch = ex.ToString();
return(result);
}
finally
{
conn.Close();
}
result.ProccessOk = true;
return(result);
}
