public List <ClassOffice> ListOfAvailableOfficeForSelectedDay(int Calendar_day_id)
{
string querry = "" +
"SELECT * FROM tbl_Office " +
"WHERE Office_id NOT IN " +
"( " +
"SELECT tbl_Office.Office_id FROM tbl_Calendar_Day, tbl_Term, tbl_Office " +
"WHERE tbl_Calendar_Day.Calendar_day_id = tbl_Term.Calendar_day_id " +
"AND tbl_Calendar_Day.Calendar_day_id = " + Calendar_day_id +
" AND tbl_Office.Office_id = tbl_Term.Office_id " +
")";
ClassQuerry q = new ClassQuerry();
SqlDataReader dr = q.ExecuteQuerry(querry);
List <ClassOffice> list = new List <ClassOffice>();
while (dr.Read())
{
ClassOffice office = new ClassOffice();
office.OfficeId = dr.GetInt32("Office_id");
office.OfficeNumber = dr.GetInt16("Office_number");
list.Add(office);
}
q.CloseConnection();
return(list);
}
private void ButtonAdd_Click(object sender, RoutedEventArgs e)
{
ClassOffice office = new ClassOffice();
WindowOfficeDataEdition windowOfficeDataEdition = new WindowOfficeDataEdition(office);
windowOfficeDataEdition.AddNew = true;
bool update = (bool)windowOfficeDataEdition.ShowDialog();
if (update)
{
UpdateOffice(office, windowOfficeDataEdition.AddNew);
LoadDataToDataGrid();
}
}
private void UpdateOffice(ClassOffice office, bool AddNew)
{
//Update doctor info in data base
try
{
//If user choose edit
if (!AddNew)
{
ClassSQLConnections.UpdateOffice(office);
return;
}
//If user choose add
ClassSQLConnections.AddNewOffice(office);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n Try again later", "Error");
}
}
private void ButtonEdit_Click(object sender, RoutedEventArgs e)
{
if (DataGridListOfOffice.SelectedIndex == -1)
{
MessageBox.Show("Select the row corresponding to the office", "No row selected");
return;
}
//Open a new window editing existing doctor
ClassOffice office = (ClassOffice)DataGridListOfOffice.SelectedItem;
WindowOfficeDataEdition windowOfficeDataEdition = new WindowOfficeDataEdition(office);
windowOfficeDataEdition.AddNew = false;
bool update = (bool)windowOfficeDataEdition.ShowDialog();
if (update)
{
UpdateOffice(office, windowOfficeDataEdition.AddNew);
LoadDataToDataGrid();
}
}
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
}
public SqlConnections()
{
ClassOffice o1 = new ClassOffice();
o1.OfficeId = 1;
o1.OfficeNumber = 2;
ClassOffice o2 = new ClassOffice();
o1.OfficeId = 2;
o1.OfficeNumber = 3;
listOfOfices = new List <ClassOffice>()
{
o1, o2
};
ClassDoctor dct1 = new ClassDoctor();
dct1.Active = true;
dct1.Doctor_id = 20;
dct1.Name = "Jan";
dct1.Surname = "Nowak";
dct1.OfficeNumber = 100;
ClassDoctor dct2 = new ClassDoctor();
dct2.Active = true;
dct2.Doctor_id = 10;
dct2.Name = "Tomasz";
dct2.Surname = "Kowalski";
dct2.OfficeNumber = 200;
ListDoctor = new List <ClassDoctor>()
{
dct1, dct2
};
ClassUser u1 = new ClassUser();
u1.Login = "******";
u1.Password = "******";
u1.Permission = new ClassPermission();
u1.Permission.Permission = "Doctor";
u1.User_id = 1;
ClassUser u2 = new ClassUser();
u2.Login = "******";
u2.Password = "******";
u2.Permission = new ClassPermission();
u2.Permission.Permission = "Doctor";
u2.User_id = 2;
ClassUser u3 = new ClassUser();
u3.Login = "******";
u3.Password = "******";
u3.Permission = new ClassPermission();
u3.Permission.Permission = "Administrator";
u3.User_id = 3;
ListUser = new List <ClassUser>()
{
u1, u2, u3
};
}
