private void txtID_EditValueChanged(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtID.Text) || string.IsNullOrWhiteSpace(txtID.Text))
{
gridControl1.DataSource = Diagnosis_cu.ItemsList;
return;
}
txtAbbreviation.EditValue = null;
txtName.Text = null;
if (DiagnosisList == null)
{
DiagnosisList = new List <Diagnosis_cu>();
}
Diagnosis_cu diagnosis =
Diagnosis_cu.ItemsList.Find(item => Convert.ToInt32(item.ID).Equals(Convert.ToInt32(txtID.EditValue)));
if (diagnosis != null)
{
DiagnosisList.Add(diagnosis);
}
gridControl1.DataSource = DiagnosisList;
gridControl1.RefreshDataSource();
}
/// <summary>
///
/// </summary>
/// <param name="accessor"></param>
/// <param name="manager"></param>
/// <param name="idDiagnosis"></param>
/// <param name="diagnosisName"></param>
private void AddDiagnosisToList(DiagnosisItem.Accessor accessor, DbManagerProxy manager, long idDiagnosis, string diagnosisName)
{
var di = accessor.CreateNewT(manager, this);
di.idfVectorSurveillanceSession = idfVectorSurveillanceSession;
di.idfsDiagnosis = idDiagnosis;
di.NationalName = diagnosisName;
DiagnosisList.Add(di);
}
private void btnSearch_Click(object sender, System.EventArgs e)
{
if (DiagnosisList == null)
{
DiagnosisList = new List <Diagnosis_cu>();
}
if (!string.IsNullOrEmpty(txtID.Text) && !string.IsNullOrWhiteSpace(txtID.Text))
{
switch (SearchPanelType)
{
case SearchPanelType.DiagnosisSearch:
Diagnosis_cu diagnosis =
Diagnosis_cu.ItemsList.Find(item => Convert.ToInt32(item.ID).Equals(Convert.ToInt32(txtID.EditValue)));
if (diagnosis != null)
{
DiagnosisList.Add(diagnosis);
}
gridControl1.DataSource = DiagnosisList;
gridControl1.RefreshDataSource();
return;
}
}
if (!string.IsNullOrEmpty(txtAbbreviation.Text) && !string.IsNullOrWhiteSpace(txtAbbreviation.Text))
{
switch (SearchPanelType)
{
case SearchPanelType.DiagnosisSearch:
DiagnosisList = Diagnosis_cu.ItemsList
.Where(item =>
item.Abbreviation != null && item.Abbreviation.Contains(txtAbbreviation.Text)).ToList();
gridControl1.DataSource = DiagnosisList;
gridControl1.RefreshDataSource();
return;
}
}
if (!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrWhiteSpace(txtName.Text))
{
switch (SearchPanelType)
{
case SearchPanelType.DiagnosisSearch:
DiagnosisList = Diagnosis_cu.ItemsList.Where(item =>
item.Name_P != null && item.Name_P.Contains(txtName.Text) ||
item.Name_S != null && item.Name_S.Contains(txtName.Text)).ToList();
gridControl1.DataSource = DiagnosisList;
gridControl1.RefreshDataSource();
return;
}
}
}
public void GetDiagnosisPatient()
{
DBClass.openConnection();
//) CAST(DateOfBirth AS date), convert(Date, DateOfBirth, 23)
//select distinct convert(VARCHAR, DataDiagnosis, 23) , NotesDiagnosis, LastNameTherapist from therapists, diagnosis where(diagnosis.IDPatient = '2') and therapists.LastNameTherapist = (select LastNameTherapist from therapists where IDTherapist = '2')
DBClass.sql = "select distinct IDDiagnosis, convert(VARCHAR, DataDiagnosis, 23) , NotesDiagnosis, LastNameTherapist " +
"from therapists, diagnosis " +
"where (diagnosis.IDPatient = '" + infoPatientTemp[0] + "') and therapists.LastNameTherapist = (select LastNameTherapist from therapists where IDTherapist = '2')";
DBClass.cmd.CommandType = CommandType.Text;
DBClass.cmd.CommandText = DBClass.sql;
DBClass.da = new SqlDataAdapter(DBClass.cmd);
DBClass.dt = new DataTable();
DBClass.da.Fill(DBClass.dt);
// wyciągamy dane
int j = 0;
DiagnosisList.Clear();
using (SqlDataReader reader = DBClass.cmd.ExecuteReader())
{
while (reader.Read())
{
for (j = 0; j <= reader.FieldCount - 1; j++) // Looping throw colums
{
data[j] = reader.GetValue(j).ToString();
}
if (data[7] == null)
{
data[7] = "";
}
DiagnosisList.Add(new DiagnosisModel
{
IDDiagnosis = (data[0]),
DataDiagnosis = data[1],
NotesDiagnosis = data[2],
LastNameTherapist = data[3]
});
//Console.WriteLine("IDTherapist - " + data[7] + data[8]);
}
}
}
