コード例 #1
0
        //return a list of computers
        public List <Computer> getComputers(Lab l)
        {
            List <Computer> computers = new List <Computer>();

            int    cID     = 0;
            string cType   = "";
            bool   cStatus = true;
            int    cLID    = 0;

            string query = "select * from computers";

            if (OpenConnection() == true)
            {
                MySqlCommand    cmd    = new MySqlCommand(query, connection);
                MySqlDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    cID   = reader.GetInt32(0);
                    cType = reader.GetString(1);
                    if (reader.GetInt32(2) == 1)
                    {
                        cStatus = true;
                    }

                    else
                    {
                        cStatus = false;
                    }
                    cLID = reader.GetInt32(3);

                    if (cLID == l.getLabID())
                    {
                        Computer aComputer = new Computer(cID, cType, cStatus, cLID);
                        computers.Add(aComputer);
                    }
                }
            }
            CloseConnection();
            return(computers);
        }
コード例 #2
0
        public void refreshDisplay(Lab selectedLab)
        {
            ConnectDB db = new ConnectDB();

            label1.Text = selectedLab.getLabName().ToUpper();
            List <Button>   computersList = this.panel1.Controls.OfType <Button>().ToList();
            List <Computer> computerList  = db.getComputers(selectedLab);

            computersList.Reverse();

            //setup computers =========================================================================
            foreach (Button b in computersList)
            {
                b.Hide();
            }
            for (int i = 0; i < selectedLab.getCapacity(); i++)
            {
                computersList.ElementAt(i).Show();
                computersList.ElementAt(i).Text = computerList.ElementAt(i).getComputerID().ToString();

                if (computerList.ElementAt(i).getCompStatus())
                {
                    computersList.ElementAt(i).BackColor = Color.Green;
                }
                else
                {
                    computersList.ElementAt(i).BackColor = Color.Red;
                }
            }
            //==========================================================================================

            //setup detail information =================================================================
            capacityBox.Text = selectedLab.getCapacity().ToString() + " computers are in this lab";

            if (selectedLab.getPrinter())
            {
                printerBox.Text = "Printer is available";
            }
            else
            {
                printerBox.Text = "No printer is in this lab";
            }

            if (selectedLab.getProjector())
            {
                projectorBox.Text = "Projector is available";
            }
            else
            {
                projectorBox.Text = "No projector is in this lab";
            }
            if (selectedLab.getAvailableComp() > 1)
            {
                availableC.Text = selectedLab.getAvailableComp().ToString() + " computers are available";
            }
            else
            {
                availableC.Text = selectedLab.getAvailableComp().ToString() + " computer is available";
            }
            //============================================================================================

            //setup schedule
            scheduleBox.Clear();
            string[] s;
            s = selectedL.getSchedule().Split(',');
            foreach (string ss in s)
            {
                scheduleBox.AppendText(ss + "\n");
            }
        }
コード例 #3
0
        //return a list of labs
        public List <Lab> getLabs()
        {
            List <Lab> labs = new List <Lab>();

            int    labid    = 0;
            string name     = "";
            bool   proj     = true;
            bool   printer  = true;
            string sche     = "";
            bool   status   = true;
            int    capacity = 0;
            string query    = "select * from labs";

            if (OpenConnection() == true)
            {
                MySqlCommand    cmd    = new MySqlCommand(query, connection);
                MySqlDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    labid = reader.GetInt32(0);
                    name  = reader.GetString(1);


                    if (reader.GetInt32(2) == 1)
                    {
                        proj = true;
                    }
                    else
                    {
                        proj = false;
                    }
                    if (reader.GetInt32(3) == 1)
                    {
                        printer = true;
                    }
                    else
                    {
                        printer = false;
                    }

                    sche = reader.GetString(4);

                    if (reader.GetInt32(5) == 1)
                    {
                        status = true;
                    }
                    else
                    {
                        status = false;
                    }
                    capacity = reader.GetInt32(6);

                    Lab aLab = new Lab(labid, name, proj, printer, status, sche, capacity);

                    labs.Add(aLab);
                }
            }
            foreach (Lab l in labs)
            {
                l.setAvailableComp(GetAvailableComp(l.getLabID()));
            }

            return(labs);
        }
コード例 #4
0
 public LabDetail(Lab sL)
 {
     InitializeComponent();
     selectedL = sL;
     refreshDisplay(selectedL);
 }