Exemplo n.º 1
0
        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();
        }
Exemplo n.º 2
0
        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);
        }