public void AddSaveActivity()
{
SelectedIDPatient = selectedAfterChange[0];
SelectedFirstName = selectedAfterChange[1];
SelectedLastName = selectedAfterChange[2];
SelectedDateActivity = selectedAfterChange[3];
SelectedNoteActivity = selectedAfterChange[4];
string _selectedIDTherapist = selectedAfterChange[5];
Console.WriteLine("Selcted Th2 - " + SelectedDateActivity);
getter.DataGrid_Loaded(SelectedIDPatient, SelectedFirstName, SelectedLastName);
// konwersja daty z string
//var dataToSQL = DateTime.ParseExact(SelectedDateDiagnose, "yyyy-MM-dd", CultureInfo.InvariantCulture);
//Console.WriteLine("DataSzmata - " + SelectedDateDiagnose);
// aktywność zapisywana jest do ostatniej terapii dla danego pacjenta
DBClass.openConnection();
DBClass.sql = "Insert into activities ( DateActivity, ActivityNote, IDTherapist, IDTherapy ) values " +
"('" + SelectedDateActivity + "', '" + SelectedNoteActivity + "', '" + _selectedIDTherapist + "', (select distinct MAX(IdTherapy) from therapy where therapy.IDPatient = '" + SelectedIDPatient + "'))";
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);
}
public void AddSaveDiagnosis()
{
SelectedIDPatient = selectedAfterChange[0];
SelectedFirstName = selectedAfterChange[1];
SelectedLastName = selectedAfterChange[2];
SelectedDateDiagnose = selectedAfterChange[3];
SelectedNoteDiagnose = selectedAfterChange[4];
string _selectedIDTherapist = selectedAfterChange[5];
Console.WriteLine("Selcted Th2 - " + SelectedDateDiagnose);
getter.DataGrid_Loaded(SelectedIDPatient, SelectedFirstName, SelectedLastName);
// konwersja daty z string
//var dataToSQL = DateTime.ParseExact(SelectedDateDiagnose, "yyyy-MM-dd", CultureInfo.InvariantCulture);
//Console.WriteLine("DataSzmata - " + SelectedDateDiagnose);
DBClass.openConnection();
DBClass.sql = "Insert into diagnosis ( DataDiagnosis, NotesDiagnosis, IDTherapist, IDDisorderDiagnosis, IDPatient ) values " +
"('" + SelectedDateDiagnose + "', '" + SelectedNoteDiagnose + "', '" + _selectedIDTherapist + "', '" + "0" + "', '" + SelectedIDPatient + "')";;
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);
}
public void SaveUpdatePatient()
{
SelectedIDPatient = selectedPatientAfterChange[0];
SelectedFirstName = selectedPatientAfterChange[1];
SelectedLastName = selectedPatientAfterChange[2];
SelectedDateOfBirth = selectedPatientAfterChange[3];
SelectedStreet = selectedPatientAfterChange[4];
SelectedZIP = selectedPatientAfterChange[5];
SelectedCity = selectedPatientAfterChange[6];
string _selectedIDTherapist = selectedPatientAfterChange[7];
Console.WriteLine("Selcted Th2 - " + _selectedIDTherapist);
//SelectedDateOfBirth = selectedPatientAfterChange[3];
getter.DataGrid_Loaded(SelectedIDPatient, SelectedFirstName, SelectedLastName);
// konwersja daty z string
var dataToSQL = DateTime.ParseExact(SelectedDateOfBirth, "yyyy-MM-dd", CultureInfo.InvariantCulture);
Console.WriteLine("DataSzmata - " + SelectedDateOfBirth);
DBClass.openConnection();
DBClass.sql = "Update patients Set FirstName = '" + SelectedFirstName + "', LastName = '" + SelectedLastName + "', DateOfBirth = '" + SelectedDateOfBirth + "', Street = '" + SelectedStreet +
"', ZIP = '" + SelectedZIP + "', City = '" + SelectedCity + "', IDTherapist = '" + _selectedIDTherapist + "'where IDPatient = '" + _selectedIDPatient + "'";
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);
#region Wyciągamy dane ... tu niepotrzebne
//// wyciągamy dane
//int i = 0;
//int j = 0;
//Console.WriteLine("Przy bazie" + DBClass.dt);
//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();
// //}
// //PatientsList.Add(new PatientModel { IDPatient = (data[0]), FirstName = data[1], LastName = data[2] });
// //i++;
// //Console.WriteLine("Id" + reader["id"].ToString());
// //Console.WriteLine("Id" + reader["firstName"].ToString());
// }
//}
#endregion
#region Obsługa bazy SQLite
//Console.WriteLine("Jestem w Savie Update " + _selectedIDPatient + SelectedFirstName + SelectedLastName);
//var con = new SQLiteConnection("Data Source=PrologSQLLite.db;Version=3;New=False;Compress=True;");
//try
//{
// con.Open();
// SQLiteCommand sqlCmd = con.CreateCommand();
// Console.WriteLine("Jestem w Savie Update " + _selectedIDPatient + SelectedFirstName + SelectedLastName);
// string updateSQLStatement = "Update patients Set firstName = '" + SelectedFirstName + "', lastName = '" + SelectedLastName + "'where id = '" + _selectedIDPatient + "'";
// sqlCmd = new SQLiteCommand(updateSQLStatement, con);
// using (SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(sqlCmd.CommandText, con))
// {
// DataTable dataTable = new DataTable();
// dataAdapter.Fill(dataTable);
// System.Console.WriteLine("Przesłana linia zaznaczona 03 - " + _selectedIDPatient + SelectedFirstName + SelectedLastName);
// var sqlCmdUpdate = new SQLiteCommand(updateSQLStatement, con);
// sqlCmdUpdate.ExecuteNonQuery();
// dataAdapter.Update(dataTable);
// con.Close();
// //refresh Datagrid;
// getter.DataGrid_Loaded();
// }
//}
//catch (Exception exp)
//{
// MessageBox.Show(exp.Message);
//}
#endregion
}