public void PopulateSpecialsist() { cmbDoctorName.DisplayMember = "DisplayName"; //cmbDoctorName.ValueMember = "PersonId"; DataBase db = new SpecialistData(); List <Specialist> list = db.GetList().ConvertAll(x => x as Specialist); BindingSource bs = new BindingSource(); List <Specialist> otherSpecialists = GetOtherDoctors(list, _student.ProfessionalServiceProviders.ConvertAll(x => x as Specialist)); bs.DataSource = otherSpecialists; cmbDoctorName.DataSource = bs; cmbDoctorName.SelectedIndex = -1; cmbDoctorName.Refresh(); }
public void PopulateSpecialists() { // cmbSpecialistId.SelectedIndexChanged -= cmbSpecialistId_SelectedIndexChanged; string sql = "SELECT * FROM vw_ProfessionalServiceProviders WHERE ProfessionalServiceProviderTypeId = " + _appointmentBase.ProfessionalServiceProviderTypeId;// cmbAppointmentType.SelectedValue; SpecialistData sd = new SpecialistData(); List <Specialist> specialists = sd.GetList(sql).ConvertAll(x => x as Specialist); cmbSpecialistId.DataSource = null; cmbSpecialistId.DataSource = specialists; cmbSpecialistId.ValueMember = "PersonId"; cmbSpecialistId.DisplayMember = "FullName"; cmbSpecialistId.Refresh(); //cmbSpecialistId.SelectedIndex = -1; //cmbSpecialistId.SelectedIndexChanged += cmbSpecialistId_SelectedIndexChanged; }
public void LoadFullList() { ep.SetError(dgProfessionalServices, ""); try { DataBase db = new SpecialistData(); _allProfessionals = db.GetList().ConvertAll(x => x as Specialist); _filteredList = _allProfessionals; _groupList = _allProfessionals; } catch (Exception ex) { ep.SetError(dgProfessionalServices, ex.Message); } }
private void PopulateComboBox() { SpecialistData ps = new SpecialistData(); List <ProfessionalServiceType> list = ps.GetProfessionalServiceTypes(); List <ProfessionalServiceType> listExcludingDoctors = list.FindAll(x => x.ProfessionalServiceProviderTypeId != 1); cmbPersonType.DataSource = listExcludingDoctors; cmbPersonType.DisplayMember = "ProfessionalServiceProviderType"; cmbPersonType.ValueMember = "ProfessionalServiceProviderTypeId"; cmbPersonType.Refresh(); cmbPersonType.DataBindings.Add("SelectedValue", Specialist, "ProfessionalServiceProviderTypeId"); if (DefaultSelectedValue != 0) { cmbPersonType.SelectedValue = DefaultSelectedValue; } }
public void PopulateCmboBoxes() { try { SpecialistData sd = new SpecialistData(); List <ProfessionalServiceType> list = sd.GetProfessionalServiceTypes(); ProfessionalServiceType specialistType = new ProfessionalServiceType(); cmbAppointmentType.DataSource = list; cmbAppointmentType.DisplayMember = "ProfessionalServiceProviderType"; cmbAppointmentType.ValueMember = "ProfessionalServiceProviderTypeId"; cmbAppointmentType.Refresh(); StaffData staffData = new StaffData(); List <Staff> staff = staffData.GetList().ConvertAll(x => x as Staff); cmbStaffAccompanyingId.DataSource = staff; cmbStaffAccompanyingId.ValueMember = "PersonId"; cmbStaffAccompanyingId.DisplayMember = "FullName"; cmbStaffAccompanyingId.Refresh(); StudentData studentData = new StudentData(); List <Student> students = studentData.GetList("SELECT * FROM vw_Residents").ConvertAll(x => x as Student); cmbResidentId.DataSource = students; cmbResidentId.ValueMember = "PersonId"; cmbResidentId.DisplayMember = "FullName"; cmbResidentId.Refresh(); //cmbAppointmentType.SelectedIndex = -1; // cmbSpecialistId.SelectedIndex = -1; //cmbStaffAccompanyingId.SelectedIndex = -1; //cmbResidentId.SelectedIndex = -1; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public override void Commit() { DataBase db = new SpecialistData(); _professionalAddEdit.Specialist.PersonId = db.Add(_professionalAddEdit.Specialist); }
public override void Commit() { DataBase db = new SpecialistData(); db.Update(_professionalAddEdit.Specialist); }