Example #1
0
        public ActorBO SearchEvent(int acID)
        {
            ActorBO ac = new ActorBO();
            ac.ActorID = acID;

            string searchString = "SELECT * FROM Actor where id = " + ac.ActorID;

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();

                SqlCommand command = new SqlCommand(searchString, conn);
                SqlDataReader reader = command.ExecuteReader();

                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        ac.FirstName = reader.GetString(reader.GetOrdinal("FirstName"));
                        ac.LastName = reader.GetString(reader.GetOrdinal("LastName"));
                        ac.DateOfBirth = reader.GetDateTime(reader.GetOrdinal("DateOfBirth"));
                    }
                }

                conn.Close();
            }

            return ac;
        }
Example #2
0
        public void InsertEvent(ActorBO ac)
        {
            string insertString = @"INSERT INTO Actor(
                                                FirstName,
                                                LastName,
                                                DateOfBirth)
                                                            values(
                                                            @firstName,@lastName,
                                                            @dateOfBirth
                                                                        )";

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand command = new SqlCommand(insertString, conn);

                command.Parameters.Add("@firstName", ac.FirstName);
                command.Parameters.Add("@lastName", ac.LastName);
                command.Parameters.Add("@dateOfBirth", ac.DateOfBirth);
                command.CommandType = CommandType.Text;
                command.ExecuteNonQuery();

                conn.Close();
            }
        }
Example #3
0
        public void DeleteEvent(ActorBO ac)
        {
            string deleteString = "DELETE FROM Actor WHERE id = '" + ac.ActorID + "'";

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand command = new SqlCommand(deleteString, conn);
                command.ExecuteNonQuery();

                conn.Close();
            }
        }
Example #4
0
        public void UpdateEvent(ActorBO ac)
        {
            string updateString = @"UPDATE Actor
                                           SET
                                               FirstName=@firstName,
                                               LastName=@lastName,
                                               DateOfBirth=@dateOfBirth
                                               WHERE id = '" + ac.ActorID + "'";

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand command = new SqlCommand(updateString, conn);

                command.Parameters.Add("@firstName", ac.FirstName);
                command.Parameters.Add("@lastName", ac.LastName);
                command.Parameters.Add("@dateOfBirth", ac.DateOfBirth);

                command.ExecuteNonQuery();

                conn.Close();
            }
        }