private void btnSaveExit_Click(object sender, RoutedEventArgs e)
{
SingleDay sd = new SingleDay(1, GlobalVars.SingleDayToEdit.Date);
sd.Visits[GlobalVars.VisitToEditIndex].Pat = GlobalVars.PatientsList[dgPat.SelectedIndex];
DBManager.UpdateTimeTable(GlobalVars.SingleDayToEdit, sd);
Close();
}
public static int UpdateTimeTable(SingleDay iSDOld, SingleDay iSDNew)
{
RemoveSingleDay(iSDOld.Id);
AddSingleDayVisit(iSDNew);
return 0;
}
//Single day with visits - to edit
public static int AddSingleDayVisit(SingleDay iDay)
{
SingleDay sd = new SingleDay(1, iDay.Date);
sd.Visits = GlobalVars.SingleDayToEdit.Visits;
sd.Visits[GlobalVars.VisitToEditIndex] = iDay.Visits[GlobalVars.VisitToEditIndex];
GlobalVars.SingleDaysList.Add(sd);
Serialize(GlobalVars.SingleDaysList, GlobalVars.SingleDaysDbName);
CreatingDatabaseSelects.SingleDayInsert(sd);
return 0;
}
public static int AddSingleDay(SingleDay iDay)
{
GlobalVars.SingleDaysList.Add(new SingleDay(++GlobalVars.SingleDaysIdCounter, iDay.Date));
Serialize(GlobalVars.SingleDaysList, GlobalVars.SingleDaysDbName);
CreatingDatabaseSelects.SingleDayInsert(iDay);
return 0;
}
public static void SingleDayInsert(SingleDay iSD)
{
if (GlobalVars.ConnectedToDatabase)
{
MySqlConnection con = new MySqlConnection(MyConnectionString);
con.Open();
try
{
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "insert into timetable(id, date) values(" + iSD.Id + ",'" + iSD.Date.ToString()+"');";
cmd.ExecuteNonQuery();
foreach (SingleVisit s in iSD.Visits)
{
cmd.CommandText = "insert into singlevisit(id, day_id, minutes) values(" + s.Id + "," + iSD.Id + "," + s.Minutes + ");";
cmd.ExecuteNonQuery();
}
}
catch (Exception)
{
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}
/* -- TimeTable -- */
public static void SingleDayUpdate(SingleDay iSD)
{
if (GlobalVars.ConnectedToDatabase)
{
SingleDayDelete(iSD.Id);
SingleDayInsert(iSD);
}
}