예제 #1
0
        //GetPairedCinderellas
        //gets up to 15 paired cinderellas
        //Input: a List to hold the paired cinderellas, and information pulled down from the DB
        //Output: the list has been filled with at most 15 paired cinderellas
        //precondition: the DB is in a correct and valid state
        //postcondition: the DB is stil in a correct and valid state, and no suplicates have been added to the list
        public void GetPairedCinderellas(ref List<CinderellaClass> PairedCinderella)
        {
            //sets up the query to get at most 15 paired cinderellas
            string query = sql.CinderellasList(15, 3);
            //sets up the connection and the sqlDataReader
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);

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

            while (reader.Read())
            {
                //read from DB into cinderella class
                CinderellaClass cinder = new CinderellaClass(reader.GetString(1), reader.GetString(2), reader.GetInt32(0), reader.GetDateTime(3));
                bool canInsert = true;
                foreach (CinderellaClass cinderella in PairedCinderella)
                {//checks to see if the paired cinderella is already in the list and if not add them to it
                    if (cinderella.getCinderellaID() == cinder.getCinderellaID())
                    {
                        canInsert = false;
                    }
                }
                if (canInsert)
                {
                    PairedCinderella.Add(cinder);
                }
            }
            //clean up
            reader.Close();
            conn.Close();
        }
        //MakeMatch
        //handles a single matchmaking attempt
        //Input: queued cinderellas and godmothers, and empty lists for them, to be added to.
        //Output: Lists are updates with the matches
        //preconditions: the lists that are past are without error, complete in the data that they should contain, and none of them have been matched
        //Postconditions: the cinderellas have been amtched are moved to the matched lists
        public void MakeMatch(ref List<CinderellaClass> CinderellaQueue, ref List<FairyGodmother> GodMotherQueue, ref List<CinderellaClass> MatchedCinderellas, ref List<FairyGodmother> MatchedGodMother)
        {
                //Create two objects to hold the cinderellas and godmothers at the head of the queue
                CinderellaClass Cinderella = new CinderellaClass();
                FairyGodmother GodMother = new FairyGodmother();
                //get the cinderella at the head of the queue
                Cinderella = CinderellaQueue[0];
                //do the same for the godmother
                if (GodMotherQueue.Count > 0)
                {
                    GodMother = GodMotherQueue[0];
                }
                else
                {
                    GodMother = null;
                }
                //handle the best case, not special needs, no requested godmother
                if ((Cinderella.SpecialNeeds == false) && (Cinderella.RequestedGodMother == 0))
                {
                    if (GodMother != null)
                    {//deqeue the cinderella and god mother and add the match to thier appropiate lists
                        MatchedCinderellas.Add(Cinderella);
                        CinderellaQueue.RemoveAt(0);
                        MatchedGodMother.Add(GodMother);
                        GodMotherQueue.RemoveAt(0);
                    }
                }
                //special needs, no requested godmother
                if ((Cinderella.SpecialNeeds == true) && (Cinderella.RequestedGodMother == 0))
                {
                    int id = FindSpecialGodMother(ref GodMotherQueue);
                    if ((GodMother != null) && (0 > -1))//there is an availible godmother that can handle special needs
                    {
                        MatchedCinderellas.Add(Cinderella);
                        CinderellaQueue.RemoveAt(0);//deqeue cinderella
                        MatchedGodMother.Add(GodMotherQueue[id]);
                        GodMotherQueue.RemoveAt(id);//deqeue GodMother
                    }
                }
                //requested godmother
                if (Cinderella.RequestedGodMother != 0)
                {
                    if (GodMother != null)
                    {
                        int id = FindGodMotherByID(Cinderella.RequestedGodMother, ref GodMotherQueue);
                        if (id > -1)
                        {//the Requested GodMother is availible
                            MatchedCinderellas.Add(Cinderella);
                            CinderellaQueue.RemoveAt(0);//deqeue cinderella
                            MatchedGodMother.Add(GodMotherQueue[id]);
                            GodMotherQueue.RemoveAt(id);//deqeue GodMother
                        }
                        else
                        {//the GodMother is not availible at the moment

                        }
                    }
            }
        }
        //GetCinderellas
        //Fills a list with the cindererllas from the DB
        //Input: a list to hold the cinderellas, and information pulled down from the DB
        //Output: the list of cinderellas has been filled with at most 15 cinderellas
        //precondition: the DB is in a correct and valid state
        //postcondition: the DB is still in a correct and valid state,a nd no duplicate cinderellas ahve been added to the list
        public void GetCinderellas(ref List<CinderellaClass> Cinderella)
        {
            //sets up the query to get 15 cinderellas that have the correct status
            string query = sql.CinderellasList(15,2);
            //sets up the sql connection and sqlDataReader
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);

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

            while (reader.Read())
            {
                //read from DB into cinderella class
                CinderellaClass cinder = new CinderellaClass(reader.GetString(1), reader.GetString(2), reader.GetInt32(0), Convert.ToDateTime(reader.GetDateTime(3)));
                //check to see if the cinderella is already in the list
                bool cinderellaExists = false;
                foreach (CinderellaClass cinderellaToAdd in Cinderella)
                {
                    if (cinderellaToAdd.getCinderellaID() == cinder.getCinderellaID())
                    {
                        cinderellaExists = true;
                    }
                }
                //if the cinderella doesnt exist add them
                if (cinderellaExists == false)
                {
                    Cinderella.Add(cinder);
                }
            }
            //clean up
            reader.Close();
            conn.Close();
        }
예제 #4
0
        //GetCinderellas
        //Fills a list with the cindererllas from the database.
        //Input: the list of cindererllas that have been through matchmaking before, a list to fill with cindererllas, and the amount to get
        //Output: updated list of cindererllas pulled down from the db
        //precondition: all inputs are valid, and the database is functioning correctly and the data in it has no errors
        //postcondition: the queue is generated correctly
        void GetCinderellas(ref List<CinderellaClass> Cinderella, int count, ref List<int> oldCinderellas)
        {
            //sets up the query to get 15 cinderellas that have the correct status
            string query = sql.CinderellasList(15, 2);
            //sets up the sql connection and sqlDataReader
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);

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

            while (reader.Read())
            {
                //read from DB into cinderella class
                CinderellaClass cinder = new CinderellaClass(reader.GetString(1), reader.GetString(2), reader.GetInt32(0), Convert.ToDateTime(reader.GetDateTime(3)));
                //check to see if the cinderella is already in the list
                bool cinderellaExists = false;
                bool priority = false;
                foreach (CinderellaClass cinderellaToAdd in Cinderella)
                {
                    if (cinderellaToAdd.getCinderellaID() == cinder.getCinderellaID())
                    {
                        cinderellaExists = true;
                    }
                }
                if (cinderellaExists == false)
                    //cinderella doesnt exist, add to list
                {
                    if (count < 15)
                    {
                        //check to see if the cinderella has been through before
                        foreach (int id in oldCinderellas)
                        {
                            if (cinder.getCinderellaID() == id)
                            {
                                priority = true;
                            }
                        }
                        if (priority)
                            //cinderella has been through before, she gets added to the front of the queue
                        {
                            Cinderella.Insert(0, cinder);
                        }
                        else
                            //cinderella has not been through before, added normally
                        {
                            Cinderella.Add(cinder);
                        }
                    }
                    count += 1;
                }
            }
            //clean up
            reader.Close();
            conn.Close();
        }