public void Create(SobrenomeModel Sobrenome)
{
string procedure = "SP_CREATE_TBS_SOBRENOME";
// Create ADO.NET objects.
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(procedure, con);
// Configure command and add input parameters.
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param;
param = cmd.Parameters.Add("@Sobrenome", SqlDbType.NVarChar, 100);
param.Value = Sobrenome.Sobrenome;
param = cmd.Parameters.Add("@Cod", SqlDbType.BigInt);
param.Value = Sobrenome.Cod;
// Add the output parameter.
param = cmd.Parameters.Add("@SobrenomeId", SqlDbType.Int);
param.Direction = ParameterDirection.Output;
// Execute the command.
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Sobrenome.Id = (param.Value as int?).GetValueOrDefault();
}
public SobrenomeModel Obter(long cod)
{
string procedure = "SP_OBTER_TBS_SOBRENOME";
// Create ADO.NET objects.
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(procedure, con);
// Configure command and add input parameters.
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param;
param = cmd.Parameters.Add("@Cod", SqlDbType.BigInt);
param.Value = cod;
// Execute the command.
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SobrenomeModel sobrenome = new SobrenomeModel();
// Call Read before accessing data.
if (reader.Read())
{
sobrenome.Id = Convert.ToInt32(reader["id"]);
sobrenome.Cod = Convert.ToInt64(reader["cod"]);
sobrenome.Sobrenome = Convert.ToString(reader["sobrenome"]);
sobrenome.Soma = Convert.ToInt32(reader["soma"]);
}
// Call Close when done reading.
reader.Close();
return(sobrenome);
}