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