/// <summary> /// This method edits data about patient and save changes to database. /// </summary> /// <param name="patient">Patient to be edited.</param> /// <returns>True if edited, false if not.</returns> public bool EditPatient(vwClinicPatient patient) { try { using (ClinicEntities context = new ClinicEntities()) { tblClinicPatient patientToEdit = context.tblClinicPatients.Where(x => x.PatientId == patient.PatientId).FirstOrDefault(); patientToEdit.ExpirationDateOfHealthInsurance = patient.ExpirationDateOfHealthInsurance; patientToEdit.HealthInsuranceCardNumber = patient.HealthInsuranceCardNumber; patientToEdit.UniqueNumberOfSelectedDoctor = patient.UniqueNumberOfSelectedDoctor; context.SaveChanges(); tblUser userToEdit = context.tblUsers.Where(x => x.UserId == patient.UserId).FirstOrDefault(); userToEdit.NameAndSurname = patient.NameAndSurname; userToEdit.IdentityCardNumber = patient.IdentityCardNumber; userToEdit.Gender = patient.Gender; userToEdit.DateOfBirth = patient.DateOfBirth; userToEdit.Citizenship = patient.Citizenship; userToEdit.Username = patient.Username; userToEdit.Password = Encryption.EncryptPassword(patient.Password); context.SaveChanges(); return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }
/// <summary> /// This method deletes patient from database. /// </summary> /// <param name="patient">Patient to be deleted.</param> /// <returns>True if deleted, false if not.</returns> public bool DeletePatient(vwClinicPatient patient) { try { using (ClinicEntities context = new ClinicEntities()) { tblClinicPatient patientToDelete = context.tblClinicPatients.Where(x => x.PatientId == patient.PatientId).FirstOrDefault(); //finding user to be deleted tblUser userToDelete = context.tblUsers.Where(x => x.UserId == patient.UserId).FirstOrDefault(); context.tblClinicPatients.Remove(patientToDelete); context.SaveChanges(); context.tblUsers.Remove(userToDelete); context.SaveChanges(); return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }
/// <summary> /// This method adds patient to DbSet and save changes to database. /// </summary> /// <param name="patient"></param> /// <returns>True if added, false if not.</returns> public bool CreatePatient(vwClinicPatient patient) { try { using (ClinicEntities context = new ClinicEntities()) { tblUser user = new tblUser { Citizenship = patient.Citizenship, DateOfBirth = patient.DateOfBirth, Gender = patient.Gender, IdentityCardNumber = patient.IdentityCardNumber, NameAndSurname = patient.NameAndSurname, Password = Encryption.EncryptPassword(patient.Password), Username = patient.Username }; context.tblUsers.Add(user); context.SaveChanges(); patient.UserId = user.UserId; tblClinicPatient newPatient = new tblClinicPatient { ExpirationDateOfHealthInsurance = patient.ExpirationDateOfHealthInsurance, HealthInsuranceCardNumber = patient.HealthInsuranceCardNumber, UniqueNumberOfSelectedDoctor = patient.UniqueNumberOfSelectedDoctor, UserId = patient.UserId }; context.tblClinicPatients.Add(newPatient); context.SaveChanges(); return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }