// DB Viewer
private void DataSourceCon(String cmd)
{
NumOfPatients2.Text = NumberOfPatients.ToString();
// Automatically generate the DataGridView columns.
dataGridView1.AutoGenerateColumns = true;
dataGridView1.AllowUserToResizeColumns = true;
dataGridView1.AllowUserToResizeRows = true;
try
{
// Set up the data source.
newBS.DataSource = myDSconnection.GetData(cmd);
dataGridView1.DataSource = newBS.DataSource;
// Set the DataGridView control's border.
dataGridView1.BorderStyle = BorderStyle.Fixed3D;
// Put the cells in edit mode when user enters them.
dataGridView1.EditMode = DataGridViewEditMode.EditOnEnter;
}
catch (SqlException)
{
MessageBox.Show("To run this sample replace connection.ConnectionString" +
" with a valid connection string to a Your DB" +
" database accessible to your system.", "ERROR",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
System.Threading.Thread.CurrentThread.Abort();
}
}
// Fill the Comboboxes with Data
public void FillComboBoxes()
{
// Diagnosis and Treatment Plans Grid
string SqlCommand = "SELECT DISTINCT Diagnose FROM DiagnosisList";
BSS.DataSource = Con.GetData(SqlCommand);
Login_Form.DiagList = (DataTable)BSS.DataSource;
DiagnosisColumn.DataSource = Login_Form.DiagList;
DiagnosisColumn.DisplayMember = "Diagnose";
// Dates and Procedures Grid
SqlCommand = "SELECT DISTINCT Procedures FROM ProcedureList";
BSS.DataSource = Con.GetData(SqlCommand);
Login_Form.ProcList = (DataTable)BSS.DataSource;
Dates_Procedures.DataSource = Login_Form.ProcList;
Dates_Procedures.DisplayMember = "Procedures";
}
// View the data of the result search
public void ViewData()
{
// Automatically generate the DataGridView columns.
DataTable Check = new DataTable();
try
{
Search_Result_dataGridView.AutoGenerateColumns = true;
Search_Result_dataGridView.AllowUserToResizeColumns = true;
Search_Result_dataGridView.AllowUserToResizeRows = true;
// Set up the data source.
BS.DataSource = myDSC.GetData(sqlCommand);
Check = myDSC.GetData(sqlCommand);
if (Check.Rows.Count == 0)
{
ShowForm = false;
MessageBox.Show("This Search key is not exist in the database\nPlease try again with different Search Key/s");
return;
}
Search_Result_dataGridView.DataSource = BS.DataSource;
// Set the DataGridView control's border.
Search_Result_dataGridView.BorderStyle = BorderStyle.Fixed3D;
// Put the cells in edit mode when user enters them.
Search_Result_dataGridView.EditMode = DataGridViewEditMode.EditOnEnter;
}
catch (SqlException)
{
MessageBox.Show("To run this sample replace connection.ConnectionString" +
" with a valid connection string to a Your DB" +
" database accessible to your system.", "ERROR",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
System.Threading.Thread.CurrentThread.Abort();
}
}
private void IntializeComboboxes()
{
String SqlCommand = "SELECT DISTINCT Procedures FROM ProcedureList";
BS.DataSource = con.GetData(SqlCommand);
if (Login_Form.ProcList.Rows.Count != 0)
{
Procedures_comboBox.DataSource = Login_Form.ProcList;
}
else
{
Procedures_comboBox.DataSource = BS;
}
Procedures_comboBox.DisplayMember = "Procedures";
Procedures_comboBox.SelectedIndex = -1;
}
// Check if Search key is exist
private bool Check_IfExist(String Option, String SearchKey)
{
DataSourceConnection Check = new DataSourceConnection();
DataTable _Check = new DataTable();
if (Option == "Diagnose")
{
_Check = Check.GetData("Select Diagnose from Diagnosis where Diagnose LIKE '%" + SearchKey + "%'");
if (_Check.Rows.Count == 0)
{
MessageBox.Show("This Diagnose is not exist on your database");
return false;
}
}
else if (Option == "Procedures")
{
_Check = Check.GetData("Select Procedures from Dates where Procedures LIKE '%" + SearchKey + "%'");
if (_Check.Rows.Count == 0)
{
MessageBox.Show("This Procedure is not exist on your database");
return false;
}
}
if (Option == "Visit_date")
{
DateTime temp = DateTime.Parse(SearchKey);
if (!SearchContext.Patient_info.Any(i => i.Visit_date == temp))
{
MessageBox.Show("This Visit date is not exist on your database");
return false;
}
}
else if (Option == "Doctor_name")
{
_Check = Check.GetData("Select Doctor_name from Dates where Doctor_name LIKE '%" + SearchKey + "%'");
if (_Check.Rows.Count == 0)
{
MessageBox.Show("This Doctor Name is not exist on your database");
return false;
}
}
else if (Option == "Sex")
{
if (!SearchContext.Patient_info.Any(i => i.Sex == SearchKey))
{
MessageBox.Show("This Sex is not exist on your database");
return false;
}
}
else if (Option == "Relative_marriage")
{
if (!SearchContext.Patient_info.Any(i => i.Relative_marriage == SearchKey))
{
MessageBox.Show("This Relative Marriage is not exist on your database");
return false;
}
}
else if (Option == "Patient_name")
{
_Check = Check.GetData("Select Patient_name from Patient_info where Patient_name LIKE '%" + SearchKey + "%'");
if (_Check.Rows.Count == 0)
{
MessageBox.Show("This Patient Name is not exist on your database");
return false;
}
}
else if (Option == "Age")
{
int temp = Int32.Parse(SearchKey);
if (!SearchContext.Patient_info.Any(i => i.Age == temp))
{
MessageBox.Show("This Age is not exist on your database");
return false;
}
}
return true;
}
// Intialize DiagList And ProcList
private void IntializeLists()
{
string SqlCommand = "SELECT DISTINCT Diagnose FROM DiagnosisList";
BS.DataSource = con.GetData(SqlCommand);
if (Login_Form.DiagList.Rows.Count != 0)
{
Set_Search_Diagnosis_comboBox.DataSource = Login_Form.DiagList;
SetK_P1_Diagnosis_comboBox.DataSource = Login_Form.DiagList;
SetK_P2_Diagnosis_comboBox.DataSource = Login_Form.DiagList;
}
else
{
Set_Search_Diagnosis_comboBox.DataSource = BS.DataSource;
SetK_P1_Diagnosis_comboBox.DataSource = BS.DataSource;
SetK_P2_Diagnosis_comboBox.DataSource = BS.DataSource;
}
Set_Search_Diagnosis_comboBox.DisplayMember = "Diagnose";
Set_Search_Diagnosis_comboBox.SelectedIndex = -1;
SetK_P1_Diagnosis_comboBox.DisplayMember = "Diagnose";
SetK_P1_Diagnosis_comboBox.SelectedIndex = -1;
SetK_P2_Diagnosis_comboBox.DisplayMember = "Diagnose";
SetK_P2_Diagnosis_comboBox.SelectedIndex = -1;
SqlCommand = "SELECT DISTINCT Procedures FROM ProcedureList";
BS.DataSource = con.GetData(SqlCommand);
if (Login_Form.ProcList.Rows.Count != 0)
{
Set_Search_Procedures_comboBox.DataSource = Login_Form.ProcList;
SetK_P1_DAP_comboBox.DataSource = Login_Form.ProcList;
SetK_P2_DAP_comboBox.DataSource = Login_Form.ProcList;
}
else
{
Set_Search_Procedures_comboBox.DataSource = BS.DataSource;
SetK_P1_DAP_comboBox.DataSource = BS.DataSource;
SetK_P2_DAP_comboBox.DataSource = BS.DataSource;
}
Set_Search_Procedures_comboBox.DisplayMember = "Procedures";
Set_Search_Procedures_comboBox.SelectedIndex = -1;
SetK_P1_DAP_comboBox.DisplayMember = "Procedures";
SetK_P1_DAP_comboBox.SelectedIndex = -1;
SetK_P2_DAP_comboBox.DisplayMember = "Procedures";
SetK_P2_DAP_comboBox.SelectedIndex = -1;
//---------------------
TableNames.Add("Diagnose", "Diagnosis");
TableNames.Add("Procedures", "Dates");
TableNames.Add("Visit_date", "Patient_info");
TableNames.Add("Sex", "Patient_info");
TableNames.Add("Relative_marriage", "Patient_info");
TableNames.Add("Patient_name", "Patient_info");
TableNames.Add("Age", "Patient_info");
TableNames.Add("Doctor_name", "Dates");
//---------------------------------
SearchOptions.Add("Diagnose");
SearchOptions.Add("Procedures");
SearchOptions.Add("Visit_date");
SearchOptions.Add("Sex");
SearchOptions.Add("Relative_marriage");
SearchOptions.Add("Patient_name");
SearchOptions.Add("Age");
SearchOptions.Add("Doctor_name");
}
// Check if Search key is exist
private bool Check_IfExist(String Option, String SearchKey)
{
DataSourceConnection Check = new DataSourceConnection();
DataTable _Check = new DataTable();
if (Option == "Diagnose")
{
_Check = Check.GetData("Select Diagnose from Diagnosis where Diagnose LIKE '%" + SearchKey + "%'");
if (_Check.Rows.Count == 0)
{
MessageBox.Show("This Diagnose is not exist on your database");
return(false);
}
}
else if (Option == "Procedures")
{
_Check = Check.GetData("Select Procedures from Dates where Procedures LIKE '%" + SearchKey + "%'");
if (_Check.Rows.Count == 0)
{
MessageBox.Show("This Procedure is not exist on your database");
return(false);
}
}
if (Option == "Visit_date")
{
DateTime temp = DateTime.Parse(SearchKey);
if (!SearchContext.Patient_info.Any(i => i.Visit_date == temp))
{
MessageBox.Show("This Visit date is not exist on your database");
return(false);
}
}
else if (Option == "Doctor_name")
{
_Check = Check.GetData("Select Doctor_name from Dates where Doctor_name LIKE '%" + SearchKey + "%'");
if (_Check.Rows.Count == 0)
{
MessageBox.Show("This Doctor Name is not exist on your database");
return(false);
}
}
else if (Option == "Sex")
{
if (!SearchContext.Patient_info.Any(i => i.Sex == SearchKey))
{
MessageBox.Show("This Sex is not exist on your database");
return(false);
}
}
else if (Option == "Relative_marriage")
{
if (!SearchContext.Patient_info.Any(i => i.Relative_marriage == SearchKey))
{
MessageBox.Show("This Relative Marriage is not exist on your database");
return(false);
}
}
else if (Option == "Patient_name")
{
_Check = Check.GetData("Select Patient_name from Patient_info where Patient_name LIKE '%" + SearchKey + "%'");
if (_Check.Rows.Count == 0)
{
MessageBox.Show("This Patient Name is not exist on your database");
return(false);
}
}
else if (Option == "Age")
{
int temp = Int32.Parse(SearchKey);
if (!SearchContext.Patient_info.Any(i => i.Age == temp))
{
MessageBox.Show("This Age is not exist on your database");
return(false);
}
}
return(true);
}