コード例 #1
0
        public static Customer GetCustomer(int Id)
        {
            Customer      customer   = new Customer();
            SqlConnection connection = ContactsDB.GetConnection();

            string selectStatement =
                "SELECT Id, Name, NickName " +
                "FROM Customer " +
                "WHERE Id = @Id";

            SqlCommand selectCommand = new SqlCommand(selectStatement, connection);

            selectCommand.Parameters.AddWithValue("@Id", Id);

            try
            {
                connection.Open();
                SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow);

                if (reader.Read())
                {
                    customer.Id       = (int)reader["Id"];
                    customer.Name     = reader["Name"].ToString();
                    customer.NickName = reader["NickName"].ToString();
                }
                else
                {
                    customer = null;
                }
                reader.Close();
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
            return(customer);
        }
コード例 #2
0
        public static int AddCustomer(Customer customer)
        {
            SqlConnection connection      = ContactsDB.GetConnection();
            string        insertStatement =
                "INSERT Customer" +
                "(Name, NickName) " +
                "VALUES (@Name, @NickName)";


            SqlCommand insertCommand = new SqlCommand(insertStatement, connection);

            insertCommand.Parameters.AddWithValue("@Name", customer.Name);
            if (customer.NickName == "")
            {
                insertCommand.Parameters.AddWithValue("@NickName", DBNull.Value);
            }
            else
            {
                insertCommand.Parameters.AddWithValue("@NickName", customer.NickName);
            }

            try
            {
                connection.Open();
                insertCommand.ExecuteNonQuery();
                string selectStatement =
                    "SELECT IDENT_CURRENT('Customer') FROM Customer";
                SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
                int        Id            = Convert.ToInt32(selectCommand.ExecuteNonQuery());
                return(Id);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }