private void refreshGrid()
{
registrarVisitView visitSearchCriteria = new registrarVisitView();
visitSearchCriteria.doctorFname = registrarTextBoxDoctorFName.Text;
visitSearchCriteria.doctorLname = registrarTextBoxDoctorLName.Text;
visitSearchCriteria.patientFname = registrarTextBoxPatientFName.Text;
visitSearchCriteria.patientLname = registrarTextBoxPatientLName.Text;
visitSearchCriteria.state = registrarStateComboBox.Text;
if (dataTimePickerRegDate.Checked)
{
visitSearchCriteria.registration_date = dataTimePickerRegDate.Value;
}
else
{
visitSearchCriteria.registration_date = DateTime.MinValue;
}
dataGridViewRegistrar.DataSource = RegistrationFacade.GetVisits(visitSearchCriteria);
dataGridViewRegistrar.Columns[0].Visible = false;
dataGridViewRegistrar.Columns[1].HeaderText = "Patient first name";
dataGridViewRegistrar.Columns[2].HeaderText = "Patient last name";
dataGridViewRegistrar.Columns[3].HeaderText = "Doctor first name";
dataGridViewRegistrar.Columns[4].HeaderText = "Doctor last name";
dataGridViewRegistrar.Columns[5].HeaderText = "State";
dataGridViewRegistrar.Columns[6].HeaderText = "Registration date";
dataGridViewRegistrar.Columns[7].HeaderText = "Cancel date";
dataGridViewRegistrar.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
/*///////////////////////////////////////////////////////////////////////*/
//registrarTextBoxIDRegistration
//private void registrarTextBoxIDRegistration_Enter(object sender, EventArgs e)
//{
// if (registrarTextBoxIDRegistration.Text == "ID Registration")
// {
// registrarTextBoxIDRegistration.Text = "";
// registrarTextBoxIDRegistration.ForeColor = SystemColors.WindowText;
// }
//}
//private void registrarTextBoxIDRegistration_Leave(object sender, EventArgs e)
//{
// if (registrarTextBoxIDRegistration.Text.Length == 0)
// {
// registrarTextBoxIDRegistration.Text = "ID Registration";
// registrarTextBoxIDRegistration.ForeColor = SystemColors.GrayText;
// }
//}
private void Initialize(int?idVisit = null)
{
this.registrarTextBoxPatientName.ReadOnly = true;
this.registrarTextBoxDoctor.ReadOnly = true;
if (idVisit != null)
{
registrarVisitView visitSearchCriteria = new registrarVisitView();
visitSearchCriteria.id_visit = (int)idVisit;
var visit = RegistrationFacade.GetVisits(visitSearchCriteria).FirstOrDefault();
this.idVisit = visit.id_visit;
this.dataTimePickerRegDate.Value = visit.registration_date;
this.registrarTextBoxPatientName.Text = visit.patientLname;
this.registrarTextBoxDoctor.Text = visit.doctorLname;
this.registrarStateComboBox.SelectedIndex = this.registrarStateComboBox.FindStringExact(visit.state);
}
}
public static IQueryable <registrarVisitView> GetVisits(registrarVisitView searchCrit)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
var res = from el in dc.registrarVisitViews
where
(String.IsNullOrEmpty(searchCrit.doctorFname) || el.doctorFname.StartsWith(searchCrit.doctorFname))
&&
(String.IsNullOrEmpty(searchCrit.doctorLname) || el.doctorLname.StartsWith(searchCrit.doctorLname))
&&
(String.IsNullOrEmpty(searchCrit.patientFname) || el.patientFname.StartsWith(searchCrit.patientFname))
&&
(String.IsNullOrEmpty(searchCrit.patientFname) || el.patientFname.StartsWith(searchCrit.patientFname))
&&
(String.IsNullOrEmpty(searchCrit.state) || el.state.StartsWith(searchCrit.state))
&&
((searchCrit.registration_date.CompareTo(DateTime.MinValue) == 0) || (el.registration_date.Year == searchCrit.registration_date.Year) && (el.registration_date.Month == searchCrit.registration_date.Month) && (el.registration_date.Day == searchCrit.registration_date.Day))
// && inne ...
select el;
return(res);
}
