private void CurrentMonthDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
workingDay.IsEnabled = true;
ClassCalendarDay day = (ClassCalendarDay)CurrentMonthDataGrid.SelectedItem;
if (day == null)
{
if (lastSelectedDay.IsWorkingDay == true)
{
workingDay.IsChecked = true;
}
else
{
workingDay.IsChecked = false;
}
}
else if (day.IsWorkingDay == true)
{
workingDay.IsChecked = true;
}
else
{
workingDay.IsChecked = false;
}
}
public void CreateCalendarDays(string days)
{
//String.Format("({0},'{1}','{2}',{3}),", day, new TimeSpan(7, 0, 0), new TimeSpan(20, 0, 0), calendarId)
string[] pom = days.Split(")");
foreach (var item in pom)
{
if (item.Length < 5)
{
break;
}
string[] table = item.Split(",");
int x = 0;
if (table.Length > 4)
{
x++;
}
ClassCalendarDay day = new ClassCalendarDay();
day.Day = int.Parse((table[x].Split("("))[1]);
day.StartTime = TimeSpan.Parse(table[x + 1].Split("'")[1]);
day.EndTime = TimeSpan.Parse(table[x + 2].Split("'")[1]);
day.Calendar = new ClassCalendar();
day.Calendar.CalendarId = int.Parse(table[x + 3]);
day.CalendarDayId = NextCalendarDayId;
NextCalendarDayId++;
ListCalendarDay.Add(day);
}
}
public WindowCalendarDayEdition(ClassCalendarDay CalendarDay, int year, int month, List <ClassCalendarDay> list)
{
InitializeComponent();
this.CalendarDay = CalendarDay;
this.year = year;
this.month = month;
this.list = list;
}
private ClassCalendarDay GetCalendarDayOrGenerateIt(object sender, ClassCalendar calendar)
{
if (!(sender is Button))
{
return(GetCalendarDayForSelectedCalendarDayInDataGridFromDataBase(calendar.CalendarId));
}
ClassCalendarDay day = new ClassCalendarDay();
day.Calendar = new ClassCalendar();
day.Calendar.CalendarId = calendar.CalendarId;
day.StartTime = new TimeSpan(7, 0, 0);
day.EndTime = new TimeSpan(20, 0, 0);
day.Day = 1;
int year = ((ClassCalendar)ComboBoxPickDate.SelectedItem).Year;
int month = ((ClassCalendar)ComboBoxPickDate.SelectedItem).Month;
return(day);
}
private void CheckBoxWorkingDay_Unchecked(object sender, RoutedEventArgs e)
{
workingDayFrom.IsEnabled = false;
workingDayTo.IsEnabled = false;
ClassCalendarDay day = (ClassCalendarDay)CurrentMonthDataGrid.SelectedItem;
RefreshLastSelectedItems(day);
day.IsWorkingDay = false;
//day.StartTime = ListOfOriginalDays()[lastSelectedIndex].StartTime;
// day.EndTime = ListOfOriginalDays()[lastSelectedIndex].EndTime;
days.RemoveAt(CurrentMonthDataGrid.SelectedIndex);
days.Insert(CurrentMonthDataGrid.SelectedIndex, day);
RefreshDataGrid();
workingDayFrom.ItemsSource = null;
workingDayTo.ItemsSource = null;
}
private void CheckBoxWorkingDay_Unchecked(object sender, RoutedEventArgs e)
{
workingDayFrom.IsEnabled = false;
workingDayTo.IsEnabled = false;
ClassCalendarDay day = (ClassCalendarDay)CurrentMonthDataGrid.SelectedItem;
lastSelectedDay = day;
lastSelectedIndex = CurrentMonthDataGrid.SelectedIndex;
day.IsWorkingDay = false;
days.RemoveAt(CurrentMonthDataGrid.SelectedIndex);
days.Insert(CurrentMonthDataGrid.SelectedIndex, day);
CurrentMonthDataGrid.ItemsSource = null;
CurrentMonthDataGrid.ItemsSource = days;
CurrentMonthDataGrid.SelectedIndex = lastSelectedIndex;
workingDayFrom.ItemsSource = null;
workingDayTo.ItemsSource = null;
}
private void CheckBoxWorkingDay_Checked(object sender, RoutedEventArgs e)
{
workingDayFrom.IsEnabled = true;
workingDayTo.IsEnabled = true;
ClassCalendarDay day = (ClassCalendarDay)CurrentMonthDataGrid.SelectedItem;
lastSelectedDay = day;
lastSelectedIndex = CurrentMonthDataGrid.SelectedIndex;
day.IsWorkingDay = true;
days.RemoveAt(CurrentMonthDataGrid.SelectedIndex);
days.Insert(CurrentMonthDataGrid.SelectedIndex, day);
CurrentMonthDataGrid.ItemsSource = null;
CurrentMonthDataGrid.ItemsSource = days;
CurrentMonthDataGrid.SelectedIndex = lastSelectedIndex;
workingDayFrom.ItemsSource = GenerateListOfHours(day.StartTime, day.EndTime);
workingDayTo.ItemsSource = GenerateListOfHours(day.StartTime, day.EndTime);
}
private void CheckBoxWorkingDay_Checked(object sender, RoutedEventArgs e)
{
workingDayFrom.IsEnabled = true;
workingDayTo.IsEnabled = true;
ClassCalendarDay day = (ClassCalendarDay)CurrentMonthDataGrid.SelectedItem;
RefreshLastSelectedItems(day);
day.IsWorkingDay = true;
// day.StartTime = ListOfOriginalDays()[lastSelectedIndex].StartTime;
// day.EndTime = ListOfOriginalDays()[lastSelectedIndex].EndTime;
days.RemoveAt(CurrentMonthDataGrid.SelectedIndex);
days.Insert(CurrentMonthDataGrid.SelectedIndex, day);
RefreshDataGrid();
workingDayFrom.ItemsSource = ClassHelpers.GenerateListOfHours(ListOfOriginalDays()[lastSelectedIndex].StartTime, ListOfOriginalDays()[lastSelectedIndex].EndTime - new TimeSpan(0, 15, 0));
workingDayFrom.SelectedItem = lastSelectedDay.StartTime;
workingDayTo.ItemsSource = ClassHelpers.GenerateListOfHours((TimeSpan)workingDayFrom.Items[workingDayFrom.SelectedIndex + 1], ListOfOriginalDays()[lastSelectedIndex].EndTime);
workingDayTo.SelectedIndex = workingDayTo.Items.Count - 1;
}
//Remove calendar day
private void ButtonRemove_Click(object sender, RoutedEventArgs e)
{
try
{
ClassCalendar calendar = GetCalendarForSelectedCalendarInComboboxFromDataBase();
if (calendar.Status.StatusId != sql.SelectStatusId(EnumStatus.New))
{
throw new Exception("Calendar status must be new");
}
ClassCalendarDay day = GetCalendarDayForSelectedCalendarDayInDataGridFromDataBase(calendar.CalendarId);
if (!(MessageBox.Show("Are you sure you want to delete this day?", "Continue?", MessageBoxButton.YesNo) == MessageBoxResult.Yes))
{
return;
}
sql.DeleteCalendarDay(day.CalendarDayId);
ReloadData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void CurrentMonthDataGrid_LostFocus(object sender, RoutedEventArgs e)
{
ClassCalendarDay day = (ClassCalendarDay)CurrentMonthDataGrid.SelectedItem;
RefreshLastSelectedItems(day);
}
private void RefreshLastSelectedItems(ClassCalendarDay day)
{
lastSelectedDay = day;
lastSelectedIndex = CurrentMonthDataGrid.SelectedIndex;
}
private void PrintInfo(object sender, MouseButtonEventArgs e)
{
ClassCalendarDay day = (ClassCalendarDay)CurrentMonthDataGrid.SelectedItem;
label1.Content = ClassLoggedDoctor.Doctor_Id;
}
public SqlCalendar()
{
#region Office
ClassOffice o1 = new ClassOffice();
o1.OfficeId = 1;
o1.OfficeNumber = 100;
ClassOffice o2 = new ClassOffice();
o1.OfficeId = 2;
o1.OfficeNumber = 200;
ListOffice = new List <ClassOffice>()
{
o1, o2
};
#endregion
#region Status
ClassStatus s1 = new ClassStatus();
s1.StatusId = 1;
s1.Status = "New";
ClassStatus s2 = new ClassStatus();
s2.StatusId = 2;
s2.Status = "Shared for doctors";
ClassStatus s3 = new ClassStatus();
s3.StatusId = 3;
s3.Status = "During verification";
ClassStatus s4 = new ClassStatus();
s4.StatusId = 4;
s4.Status = "Verified";
ClassStatus s5 = new ClassStatus();
s5.StatusId = 5;
s5.Status = "Waiting for administrator acceptance";
ClassStatus s6 = new ClassStatus();
s6.StatusId = 6;
s6.Status = "During verification by the doctor";
ClassStatus s7 = new ClassStatus();
s7.StatusId = 7;
s7.Status = "Accepted by the doctor";
ListStatus = new List <ClassStatus>()
{
s1, s2, s3, s4, s5, s6, s7
};
#endregion
#region Doctor
ClassDoctor dct1 = new ClassDoctor();
dct1.Active = true;
dct1.Doctor_id = 1;
dct1.Name = "Jan";
dct1.Surname = "Nowak";
dct1.OfficeNumber = 100;
ClassDoctor dct2 = new ClassDoctor();
dct2.Active = true;
dct2.Doctor_id = 2;
dct2.Name = "Tomasz";
dct2.Surname = "Kowalski";
dct2.OfficeNumber = 200;
ListDoctor = new List <ClassDoctor>()
{
dct1, dct2
};
#endregion
#region FixedTerms
ClassFixedTerms ft1 = new ClassFixedTerms();
ft1.Day = 2;
ft1.Start = new TimeSpan(8, 0, 0);
ft1.End = new TimeSpan(12, 0, 0);
ft1.DoctorId = 1;
ClassFixedTerms ft2 = new ClassFixedTerms();
ft2.Day = 3;
ft2.Start = new TimeSpan(13, 0, 0);
ft2.End = new TimeSpan(15, 0, 0);
ft2.DoctorId = 2;
ListFixedTerms = new List <ClassFixedTerms>()
{
ft1, ft2
};
#endregion
#region Calendar
ClassCalendar c1 = new ClassCalendar();
c1.Year = 2000;
c1.Month = 2;
c1.CalendarId = 1;
c1.Status = new ClassStatus();
c1.Status.StatusId = 1;
ListCalendar.Add(c1);
ClassCalendar c2 = new ClassCalendar();
c2.Year = 2000;
c2.Month = 3;
c2.CalendarId = 2;
c2.Status = new ClassStatus();
c2.Status.StatusId = 3;
ListCalendar.Add(c2);
ClassCalendar c3 = new ClassCalendar();
c3.Year = 2000;
c3.Month = 4;
c3.CalendarId = 3;
c3.Status = new ClassStatus();
c3.Status.StatusId = 1;
ListCalendar.Add(c3);
#endregion
#region Calendar Doctor
ClassCalendarDoctor cd1 = new ClassCalendarDoctor();
cd1.Calendar = new ClassCalendar();
cd1.Calendar.CalendarId = 2;
cd1.CalendarDoctorId = 1;
cd1.Doctor = new ClassDoctor();
cd1.Doctor.Doctor_id = 1;
cd1.Status = new ClassStatus();
cd1.Status.StatusId = 7;
ListCalendarDoctor.Add(cd1);
ClassCalendarDoctor cd2 = new ClassCalendarDoctor();
cd2.Calendar = new ClassCalendar();
cd2.Calendar.CalendarId = 2;
cd2.CalendarDoctorId = 2;
cd2.Doctor = new ClassDoctor();
cd2.Doctor.Doctor_id = 2;
cd2.Status = new ClassStatus();
cd2.Status.StatusId = 7;
ListCalendarDoctor.Add(cd2);
#endregion
#region Calendar Day
ClassCalendarDay d1 = new ClassCalendarDay();
d1.Calendar = new ClassCalendar();
d1.Calendar.CalendarId = 1;
d1.CalendarDayId = 1;
d1.Day = 1;
d1.StartTime = new TimeSpan(7, 0, 0);
d1.EndTime = new TimeSpan(20, 0, 0);
ListCalendarDay.Add(d1);
ClassCalendarDay d2 = new ClassCalendarDay();
d2.Calendar = new ClassCalendar();
d2.Calendar.CalendarId = 1;
d2.CalendarDayId = 2;
d2.Day = 2;
d2.StartTime = new TimeSpan(7, 0, 0);
d2.EndTime = new TimeSpan(20, 0, 0);
ListCalendarDay.Add(d2);
ClassCalendarDay d3 = new ClassCalendarDay();
d3.Calendar = new ClassCalendar();
d3.Calendar.CalendarId = 2;
d3.CalendarDayId = 3;
d3.Day = 1;
d3.StartTime = new TimeSpan(7, 0, 0);
d3.EndTime = new TimeSpan(20, 0, 0);
ListCalendarDay.Add(d3);
ClassCalendarDay d4 = new ClassCalendarDay();
d4.Calendar = new ClassCalendar();
d4.Calendar.CalendarId = 2;
d4.CalendarDayId = 4;
d4.Day = 7;
d4.StartTime = new TimeSpan(7, 0, 0);
d4.EndTime = new TimeSpan(20, 0, 0);
ListCalendarDay.Add(d4);
#endregion
#region Term
ClassTerm t1 = new ClassTerm();
t1.TermId = 1;
t1.CalendarDay = new ClassCalendarDay();
t1.CalendarDay = d3;
t1.CalendarDoctor = cd1;
t1.Date = new DateTime(2000, 3, 1);
t1.Doctor = dct1;
t1.StartTime = new TimeSpan(8, 0, 0);
t1.EndTime = new TimeSpan(12, 0, 0);
t1.Office = new ClassOffice();
t1.Office.OfficeNumber = 100;
ListTerm.Add(t1);
ClassTerm t2 = new ClassTerm();
t2.TermId = 2;
t2.CalendarDay = new ClassCalendarDay();
t2.CalendarDay = d4;
t2.CalendarDoctor = cd2;
t2.Date = new DateTime(2000, 3, 7);
t2.Doctor = dct2;
t2.StartTime = new TimeSpan(13, 0, 0);
t2.EndTime = new TimeSpan(15, 0, 0);
t2.Office = new ClassOffice();
t2.Office.OfficeNumber = 200;
ListTerm.Add(t2);
#endregion
}
