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;
}
