コード例 #1
0
        private void bReschedule_Click(object sender, EventArgs e)
        {
            /* DataGridViewRow row = slots.CurrentRow;
             * dbAppointment app = new dbAppointment();
             * string date = row.Cells[1].Value.ToString();
             * string time = row.Cells[2].Value.ToString();
             *
             * int mrn = Convert.ToInt16(row.Cells[0].Value.ToString());
             * app.editAppointment(mrn, date, time);
             *
             * slots.Hide();
             * bReschedule.Visible = false;
             * button2.Visible = false;
             */
            DataGridViewRow row = slots.CurrentRow;
            dbAppointment   app = new dbAppointment();

            try
            {
                string date = row.Cells[1].Value.ToString();
                string time = row.Cells[2].Value.ToString();

                int mrn = Convert.ToInt16(row.Cells[0].Value.ToString());
                app.editAppointment(mrn, date, time);

                slots.Hide();
                bReschedule.Visible = false;
                button3.Visible     = false;
                button2.Visible     = false;
            }
            catch (NullReferenceException ex)
            {
                MessageBox.Show("There are no busy slots");
            }
        }
コード例 #2
0
        public void checkBusySlots(DataGridView slots, string date)
        {
            //MessageBox.Show(date);
            dbAppointment d  = new dbAppointment();
            DataSet       ds = d.getSlots(date);

            slots.DataSource = ds.Tables["appointment"].DefaultView;
            slots.Show();
        }
コード例 #3
0
        public bool scheduleAppointment()
        {
            dbAppointment app = new dbAppointment();

            if (app.storeAppointment(mrn, date, time))
            {
                return(true);
            }
            return(false);
        }
コード例 #4
0
        public bool validateAppointmentForm(f_ScheduleAppointment app, string mrntext, string daytext, string monthtext, string yeartext, string hourtext, string mintext, string amorpmtext)//appointment form validation
        {
            if (mrntext == "" || daytext == "DD" || monthtext == "MM" || yeartext == "YYYY" || hourtext == "Hr" || mintext == "Min")
            {
                return(false);
            }
            else
            {
                dbAppointment db   = new dbAppointment();
                bool          flag = db.checkMrn(mrntext);
                if (flag == true)
                {
                    app.Hide();
                    bAppointment appoint = new bAppointment(mrntext, daytext, monthtext, yeartext, hourtext, mintext, amorpmtext);
                    if (appoint.scheduleAppointment())
                    {
                        MessageBox.Show("Appointment fixed");
                        f_ReceptionHome rec = new f_ReceptionHome();
                        rec.Show();
                    }

                    else
                    {
                        MessageBox.Show("Time slot already booked! Try again!");
                        f_ReceptionHome rec = new f_ReceptionHome();
                        rec.Show();
                    }

                    return(true);
                }
                else
                {
                    MessageBox.Show("The MRN entered is not valid! Please enter a valid number");
                    return(true);
                }
            }
        }
コード例 #5
0
        public void deleteAppointment(string m, string date, string time)
        {
            dbAppointment db = new dbAppointment();

            db.deleteAppointment(m, date, time);
        }