public void LoadPatientsList()
{
PatientsList.Clear();
DBHandler conn = new DBHandler();
conn.InitializeConnection();
List <Patient> patients = conn.GetAllPatients();
conn.CloseConnection();
for (int i = 0; i < patients.Count; i++)
{
PatientsList.Add(patients.ElementAt(i));
}
/* var a = new Patient("Jan", "Kowalski", 18, "93827193821", 1);
* var b = new Patient("Adam", "Adamski", 19, "93827193822", 1);
* var c = new Patient("Tomasz", "Nowak", 20, "93827193823", 1);
* PatientsList.Add(a);
* PatientsList.Add(b);
* PatientsList.Add(c);*/
}
public void DataGrid_Loaded()
{
DBClass.openConnection();
//) CAST(DateOfBirth AS date), convert(Date, DateOfBirth, 23)
DBClass.sql = "select distinct IDPatient, FirstName, LastName, convert(VARCHAR, DateOfBirth, 23) , " +
"Street, ZIP, City, therapists.LastNameTherapist, patients.IDTherapist, Phone, Email " +
"from patients, therapists, therapistSpecialization where therapists.LastNameTherapist = " +
"(select LastNameTherapist from therapists where IDTherapist = patients.IDTherapist)";
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 i = 0;
int j = 0;
//Console.WriteLine("Przy bazie" + data[3]);
PatientsList.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] = "";
}
//Console.WriteLine("Przy bazie" + data[3]);
PatientsList.Add(new PatientModel {
IDPatient = (data[0]), FirstName = data[1], LastName = data[2], DateOfBirth = data[3], Street = data[4], ZIP = data[5],
City = data[6], IDTherapist = data[7], NameTherapist = (data[8]), Phone = data[9], Email = data[10]
});
//Console.WriteLine("IDTherapist - " + data[7] + data[8]);
}
}
//cmd.CommandText = "update projekt set ocena_projekt = @ocenaProjekt " +
// "where(select ID_Studenta from Student where STU_nazwisko = @nazwiskoS) = ID_studenta and " +
// "(select ID_prowadzacego from Prowadzacy where nazwisko_pro = 'Wodecki') = Pro_ID_prowadzacego and " +
// "(select ID_projektu from Projekty where temat = @temat) = ID_projektu;";
DBClass.closeConnection();
//int i = 0;
//int j = 0;
//var con = new SQLiteConnection("Data Source=Prolog;Version=3;New=False;Compress=True;");
try
{
//String con = "Server=localhost;Database=Prolog;User Id=prolog;password=prolog";
//String con = "Server=DELL-ADI\\SQLEXPRESS; uid=prolog; pwd=prolog; database=Prolog;";
////String con = " server = 194.181.228.20; uid = edenland_prolog; pwd = adikos; database = edenland_prolog;";
//MySqlConnection Connection = new MySqlConnection(con);
//string CommandText = "select * from patients";
//MySqlDataAdapter ApapterSQL = new MySqlDataAdapter();
//ApapterSQL.SelectCommand = new MySqlCommand(CommandText, Connection);
//MySqlCommandBuilder builder = new MySqlCommandBuilder(ApapterSQL);
//Connection.Open();
//DataTable dane = new DataTable();
//ApapterSQL.Fill(dane);
////ReservationFromWebList.ItemsSource = dane.DefaultView;
//ApapterSQL.Update(dane);
//con.Open();
//SQLiteCommand sqlCmd = con.CreateCommand();
//sqlCmd.CommandText = "SELECT * FROM patients ";
//using (SQLiteDataReader rdr = sqlCmd.ExecuteReader())
//{
// while (rdr.Read()) // Reading Rows
// {
// for (j = 0; j <= rdr.FieldCount - 1; j++) // Looping throw colums
// {
// data[j] = rdr.GetValue(j).ToString();
// }
// PatientsList.Add(new PatientModel { IDPatient = (data[0]), FirstName = data[1], LastName = data[2] });
// i++;
// }
//}
//Connection.Close();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
