private void FillOfficeList()
        {
            clinic aClinic = new clinic();

            foreach (DataRow aRow in aClinic.GetAllData("name").Rows)
            {
                aClinic = new clinic();
                aClinic.Load(aRow);

                pnlOffices.Children.Add(GenerateClinicUI(aClinic, user_preferences_clinics.Get(ActiveUser.UserObject.id, aClinic.id)));
            }
        }
        private void FillOfficeList()
        {
            clinic aClinic = new clinic();
            int    incr    = 0;

            foreach (DataRow aRow in aClinic.GetAllData("name").Rows)
            {
                incr    = incr + 30;
                aClinic = new clinic();
                aClinic.Load(aRow);
                var a = GenerateClinicUI(aClinic, user_preferences_clinics.Get(ActiveUser.UserObject.id, aClinic.id), incr);
                pnlOffices.Controls.Add(a);
            }
        }
        private void InitializeClinics()
        {
            clinic cln = new clinic();

            cmbClinic.Items.Clear();
            cmbBasicClinic.Items.Clear();
            cmbClinic.Items.Add("Show All");
            cmbBasicClinic.Items.Add("Show All");

            DataTable dt = cln.Search(cln.SearchSQL + " ORDER BY name");

            foreach (DataRow aClinic in dt.Rows)
            {
                cln = new clinic();
                cln.Load(aClinic);
                cmbClinic.Items.Add(cln);
                cmbBasicClinic.Items.Add(cln);
            }
        }