public int Create(SellerCreate request)
        {
            using (var con = GetConnection())
            {
                var cmd = con.CreateCommand();

                cmd.CommandText = "Seller_Create";
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output;
                cmd.Parameters.AddWithValue("@host", request.Host);
                cmd.Parameters.AddWithValue("@dmcaEmail", request.DmcaEmail);
                cmd.Parameters.AddWithValue("@listId", request.ListId);
                cmd.Parameters.AddWithValue("@otherEmail", request.OtherEmail);
                cmd.Parameters.AddWithValue("@phone", request.Phone);
                cmd.Parameters.AddWithValue("@street", request.Street);
                cmd.Parameters.AddWithValue("@street2", request.Street2);
                cmd.Parameters.AddWithValue("@city", request.City);
                cmd.Parameters.AddWithValue("@state", request.State);
                cmd.Parameters.AddWithValue("@postalCode", request.PostalCode);
                cmd.Parameters.AddWithValue("@country", request.Country);

                cmd.ExecuteNonQuery();

                return((int)cmd.Parameters["@Id"].Value);
            }
        }
Exemplo n.º 2
0
 public int Create(SellerCreate model)
 {
     return(sellerService.Create(model));
 }