public static int Update(Propiedad propiedad)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connection_DB"].ConnectionString))
{
int retval;
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.SPU_Propiedad";
cmd.Parameters.Add("@numeroFinca", SqlDbType.Int).Value = propiedad.numeroFinca;
cmd.Parameters.Add("@valor", SqlDbType.Money).Value = propiedad.valor;
cmd.Parameters.Add("@direccion", SqlDbType.VarChar).Value = propiedad.direccion;
cmd.Connection = connection;
cmd.Parameters.Add("@retValue", System.Data.SqlDbType.Int).Direction = System.Data.ParameterDirection.ReturnValue;
try
{
connection.Open();
cmd.ExecuteNonQuery();
retval = (int)cmd.Parameters["@retValue"].Value;
}
catch (Exception ex)
{
retval = -1;
throw;
}
finally
{
connection.Close();
}
return(retval); // execute not accomplish
}
}
public static Propiedad SelectPropiedad(int numeroFinca)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connection_DB"].ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.SPS_Propiedad_Detail";
cmd.Parameters.Add("@numeroFinca", SqlDbType.Int).Value = numeroFinca;
cmd.Connection = connection;
var propiedad = new Propiedad();
try
{
connection.Open();
using (var reader = cmd.ExecuteReader())
{
reader.Read();
propiedad.numeroFinca = reader.GetInt32(0);
propiedad.valor = (decimal)reader.GetSqlMoney(1);
propiedad.direccion = reader.GetString(2);
}
}
catch (Exception ex)
{
throw;
}
finally
{
connection.Close();
}
return(propiedad); // execute not accomplish
}
}
