internal void SaveAccount(int id, string email, string password, string userType, account cont)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
if (id == -1)
{
if (userType == "Admin")
{
context.AddAccount(email, password, 2);
}
else if (userType == "Patient")
{
context.AddAccount(email, password, 3);
}
else if (userType == "Doctor")
{
context.AddAccount(email, password, 1);
}
context.SaveChanges();
}
else
{
context.ModifyAccount(id, email, password);
context.SaveChanges();
}
MainViewModel.Instance.ActiveScreen = new AccountsViewModel(cont);
}
public ObservableCollection <DoctorPatients> GetPatientsDoctor(doctor doc)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
List <DoctorPatients> auxList = new List <DoctorPatients>();
foreach (var patient in context.patients)
{
int counter = 0;
if (patient.idDoc == doc.idDoctor)
{
foreach (var appointment in context.appointments)
{
if (appointment.idPatient == patient.idPatient)
{
counter += 1;
}
}
auxList.Add(new DoctorPatients(doc, patient, counter));
}
}
var a = auxList.OrderBy(si => si.NumberOfProcedures).ToList();
ObservableCollection <DoctorPatients> auxList2 = new ObservableCollection <DoctorPatients>();
auxList.Sort(new Comparison <DoctorPatients>((x, y) => x.NumberOfProcedures.CompareTo(y.NumberOfProcedures)));
foreach (var patient in auxList)
{
auxList2.Add(patient);
}
return(auxList2);
}
internal void DeleteAccount(int id, account _cont)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
context.DeactivateAccount(id);
context.SaveChanges();
MainViewModel.Instance.ActiveScreen = new AccountsViewModel(_cont);
}
internal void SaveAppointment(patient selectedPatient, doctor doctor, DateTime selectedDate, doctorProcedure procedure, int duration)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
context.AddAppointment(selectedDate, duration, doctor.idDoctor, selectedPatient.idPatient, procedure.idProcedure);
context.SaveChanges();
MainViewModel.Instance.ActiveScreen = new AppointemtsViewModel();
}
internal void Remove(doctorProcedure selectedProcedure)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
context.DeactivateMedicalProcedure(selectedProcedure.idProcedure, selectedProcedure.nameProcedure, 1);
MainViewModel.Instance.ActiveScreen = new ProcedureViewModel();
}
public void RemovePatient(patient selectedPatient)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
context.DeactivatePatient(selectedPatient.idPatient);
context.SaveChanges();
MainViewModel.Instance.ActiveScreen = new PatientViewModel();
}
public ObservableCollection <account> GetAllAccounts()
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
ObservableCollection <account> auxList = new ObservableCollection <account>();
foreach (var account in context.accounts.ToList())
{
// if (auxList.Contains(room.id) == false)
if (account.recordStatus == "Active")
{
auxList.Add(account);
}
}
return(auxList);
}
public ObservableCollection <doctorProcedure> GetAllProcedures()
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
ObservableCollection <doctorProcedure> auxList = new ObservableCollection <doctorProcedure>();
foreach (var procedure in context.doctorProcedures)
{
if (procedure.recordStatus == "Active")
{
auxList.Add(procedure);
}
}
return(auxList);
}
public ObservableCollection <patient> DisplayAllPatients()
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
var auxList = context.patients;
ObservableCollection <patient> listToReturn = new ObservableCollection <patient>();
foreach (var patient in context.patients)
{
if (patient.recordStatus != "Inactive")
{
listToReturn.Add(patient);
}
}
return(listToReturn);
}
public ObservableCollection <doctor> DisplayAllDoctors()
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
var auxList = context.doctors;
ObservableCollection <doctor> listToReturn = new ObservableCollection <doctor>();
foreach (var doctor in context.doctors)
{
if (doctor.recordStatus != "Inactive")
{
listToReturn.Add(doctor);
}
}
return(listToReturn);
}
public ObservableCollection <appointment> GetAllAppointments()
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
ObservableCollection <appointment> auxList = new ObservableCollection <appointment>();
foreach (var appointment in context.appointments.ToList())
{
if (appointment.recordStatus.Equals("Active"))
{
auxList.Add(appointment);
}
}
return(auxList);
}
public ObservableCollection <patient> DisplayAllPatients()
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
var auxList = context.patients;
ObservableCollection <patient> listToReturn = new ObservableCollection <patient>();
foreach (var patient in context.patients)
{
if (patient.recordStatus != "Inactive")
{
listToReturn.Add(patient);
}
}
//return context.doctors.Cast<ObservableCollection<doctor>>().OrderBy(doctor=>doctor).Select(doctor=>doctor);
return(listToReturn);
}
public ObservableCollection <patient> SearchPatients(string fullname, string email)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
var auxList = context.patients;
ObservableCollection <patient> listToReturn = new ObservableCollection <patient>();
foreach (var patientFound in context.SearchPatient(fullname, email).ToList())
{
if (patientFound.recordStatus != "Inactive")
{
patient aux = new patient();
aux.fullname = patientFound.fullname;
listToReturn.Add(aux);
}
}
return(listToReturn);
}
public string GetMonthlySalary(doctor doc)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
//ObjectResult<int?> resultList = null;
//var OutputParamter = new ObjectParameter("salary", typeof(int));
//resultList = context.CalculateSalaryOnMonth(doc.idDoctor, OutputParamter);
//return resultList.ToString();
int salary = 0;
foreach (var appointment in context.appointments)
{
if (appointment.idDoctor == doc.idDoctor)
{
salary = salary + int.Parse(appointment.doctorProcedure.price.ToString());
}
}
return(salary.ToString());
}
public void SignUp(string name, string password)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
var conturi = context.accounts.ToList();
bool contExistent = false;
foreach (var cont in conturi)
{
if (cont.email == name)
{
MessageBox.Show("Cont deja creat!");
contExistent = true;
}
}
if (contExistent == false)
{
context.AddAccount(name, password, 2);
context.SaveChanges();
MessageBox.Show("Cont creat cu succes!");
MainViewModel.Instance.ActiveScreen = new LogInViewModel();
}
}
internal void Modify(appointment selectedAppointment, patient selectedPatient, doctor doctor, DateTime selectedDate, doctorProcedure procedure, int duration)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
context.ModifyAppointment(selectedDate, duration, selectedAppointment.idAppointment, doctor.idDoctor, selectedPatient.idPatient, procedure.idProcedure);
}
internal void Remove(appointment selectedAppointment)
{
DentistOfficeEntities2 context = new DentistOfficeEntities2();
context.DeactivateAppointment(selectedAppointment.idAppointment);
}
