public void setComboBox() { // Workers ClinicTableAdapters.WorkersTableAdapter daWorkers = new ClinicTableAdapters.WorkersTableAdapter(); Clinic.WorkersDataTable dtWorkers = daWorkers.GetDataByActiveWorkers(); CmbWorker.DataSource = dtWorkers; CmbWorker.SelectedIndex = 0; CmbWorker.AutoCompleteMode = AutoCompleteMode.Append; CmbWorker.AutoCompleteSource = AutoCompleteSource.ListItems; CmbWorker.DisplayMember = "FullName"; CmbWorker.ValueMember = "ID"; //PatientsID ClinicTableAdapters.PatientsTableAdapter daPatients = new ClinicTableAdapters.PatientsTableAdapter(); Clinic.PatientsDataTable dtPatients = daPatients.GetData(); CmblPatientId.DataSource = dtPatients; CmblPatientId.AutoCompleteMode = AutoCompleteMode.Append; CmblPatientId.AutoCompleteSource = AutoCompleteSource.ListItems; CmblPatientId.DisplayMember = "ID"; CmblPatientId.ValueMember = "ID"; handeled = true; CmblPatientId.SelectedIndex = 0; //PatientsName CmbPatientName.DataSource = dtPatients; CmbPatientName.AutoCompleteMode = AutoCompleteMode.Append; CmbPatientName.AutoCompleteSource = AutoCompleteSource.ListItems; CmbPatientName.DisplayMember = "FullName"; CmbPatientName.ValueMember = "ID"; handeled = true; CmbPatientName.SelectedIndex = 0; // Relations ClinicTableAdapters.RelationsTableAdapter daRelations = new ClinicTableAdapters.RelationsTableAdapter(); Clinic.RelationsDataTable dtRelations = daRelations.GetData(); CmbRelationship.DataSource = dtRelations; CmbRelationship.SelectedIndex = 0; CmbRelationship.AutoCompleteMode = AutoCompleteMode.Append; CmbRelationship.AutoCompleteSource = AutoCompleteSource.ListItems; CmbRelationship.DisplayMember = "Name"; CmbRelationship.ValueMember = "ID"; // Contact Type ClinicTableAdapters.ContactsTypeTableAdapter daContactsType = new ClinicTableAdapters.ContactsTypeTableAdapter(); Clinic.ContactsTypeDataTable dtContactsType = daContactsType.GetData(); CmbContactType.DataSource = dtContactsType; CmbContactType.SelectedIndex = 0; CmbContactType.AutoCompleteMode = AutoCompleteMode.Append; CmbContactType.AutoCompleteSource = AutoCompleteSource.ListItems; CmbContactType.DisplayMember = "Name"; CmbContactType.ValueMember = "ID"; HourPicker.Format = DateTimePickerFormat.Time; HourPicker.ShowUpDown = true; HourPicker.CustomFormat = "HH:mm"; }
private void BtnSave_Click(object sender, EventArgs e) { ClinicTableAdapters.WorkersTableAdapter daWorkers = new ClinicTableAdapters.WorkersTableAdapter(); String fullname = TxtFirstName.Text + " " + TxtLastName.Text; Clinic.WorkersDataTable workerCheck = new Clinic.WorkersDataTable(); workerCheck = daWorkers.GetDataByID(Int32.Parse(TxtID.Text)); if (workerCheck.Rows.Count == 0) { daWorkers.Insert(Int32.Parse(TxtID.Text), TxtFirstName.Text, TxtLastName.Text, 0, true, fullname); BtnAddNewWorker.Visible = true; BtnPermissions.Visible = true; workerCheck = daWorkers.GetData(); DgWorkers.DataSource = workerCheck; DgWorkers.Refresh(); DgWorkers.Visible = true; BtnExitNoSave.Visible = false; BtnSave.Visible = false; } else MessageBox.Show("עובד עם תעודת זהות זו כבר קיים במערכת.", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); }
public void fillDataTable() { ClinicTableAdapters.WorkersTableAdapter daWorkers = new ClinicTableAdapters.WorkersTableAdapter(); Clinic.WorkersDataTable dtWorkers = daWorkers.GetData(); DgWorkers.DataSource = dtWorkers; }