public PatientAppointment FindPatientAppointment(PatientAppointment patientAppt) { PatientAppointmentInformation patientApptRecord = null;; PatientAppointment patientAppt1 = new PatientAppointment(); var appointmentquery = from patients in patientApptDataContext.PatientAppointmentInformations where patients.ApptId == patientAppt.ApptId select patients; patientApptRecord = appointmentquery.First(); patientAppt1.AppointmentDate = patientApptRecord.ApptDate; patientAppt1.ApptId = patientApptRecord.ApptId; patientAppt1.ImageAfterTherapy = dataEncryptionAlgorithm.DecryptData(patientApptRecord.ImageAfterTherapy); patientAppt1.ImageBeforeTherapy = dataEncryptionAlgorithm.DecryptData(patientApptRecord.ImageBeforeTherapy); patientAppt1.OilsAndTherapy = dataEncryptionAlgorithm.DecryptData(patientApptRecord.TherapyPerformed); patientAppt1.SessionGoals = dataEncryptionAlgorithm.DecryptData(patientApptRecord.SessionGoals); patientAppt1.PulseKD1 = dataEncryptionAlgorithm.DecryptData(patientApptRecord.KD1); patientAppt1.PulseKD2 = dataEncryptionAlgorithm.DecryptData(patientApptRecord.KD2); patientAppt1.PulseLHT = dataEncryptionAlgorithm.DecryptData(patientApptRecord.LHT); patientAppt1.PulseLV = dataEncryptionAlgorithm.DecryptData(patientApptRecord.LV); patientAppt1.PulseRLU = dataEncryptionAlgorithm.DecryptData(patientApptRecord.RLU); patientAppt1.PulseSP = dataEncryptionAlgorithm.DecryptData(patientApptRecord.SP); return(patientAppt1); }
public PatientAppointmentInformationTableManager() { // // TODO: Add constructor logic here // patientApptDataContext = new PatientAppointmentInfomationDataContext(WebConfigurationManager.ConnectionStrings["MyTherapistDatabaseConnectionString"].ConnectionString); patientAppointmentInformation = new PatientAppointmentInformation(); dataEncryptionAlgorithm = new MyTherapistEncryption.SecurityController(); }
public void Update(PatientAppointment patientAppt) { PatientAppointmentInformation patientApptRecord = null; bool insert = false; try { var appointmentquery = from patients in patientApptDataContext.PatientAppointmentInformations where patients.ApptId == patientAppt.ApptId select patients; patientApptRecord = appointmentquery.First(); patientApptRecord.LV = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseLV); patientApptRecord.RLU = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseRLU); patientApptRecord.KD1 = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseKD1); patientApptRecord.SP = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseSP); patientApptRecord.LHT = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseLHT); patientApptRecord.KD2 = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseKD2); patientApptRecord.ImageBeforeTherapy = dataEncryptionAlgorithm.EncryptData(patientAppt.ImageBeforeTherapy); patientApptRecord.ImageAfterTherapy = dataEncryptionAlgorithm.EncryptData(patientAppt.ImageAfterTherapy); patientApptRecord.TherapyPerformed = dataEncryptionAlgorithm.EncryptData(patientAppt.OilsAndTherapy); patientApptRecord.SessionGoals = dataEncryptionAlgorithm.EncryptData(patientAppt.SessionGoals); } catch (Exception ex) { ex.GetHashCode(); insert = true; } if (insert) { patientApptRecord = new PatientAppointmentInformation(); patientApptRecord.PatientId = patientAppt.PatientId; patientApptRecord.ApptId = Guid.NewGuid(); patientApptRecord.ApptDate = patientAppt.AppointmentDate; patientApptRecord.TherapistId = patientAppt.TherapistId; patientApptRecord.LV = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseLV); patientApptRecord.RLU = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseRLU); patientApptRecord.KD1 = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseKD1); patientApptRecord.SP = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseSP); patientApptRecord.LHT = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseLHT); patientApptRecord.KD2 = dataEncryptionAlgorithm.EncryptData(patientAppt.PulseKD2); patientApptRecord.ImageBeforeTherapy = dataEncryptionAlgorithm.EncryptData(patientAppt.ImageBeforeTherapy); patientApptRecord.ImageAfterTherapy = dataEncryptionAlgorithm.EncryptData(patientAppt.ImageAfterTherapy); patientApptRecord.TherapyPerformed = dataEncryptionAlgorithm.EncryptData(patientAppt.OilsAndTherapy); patientApptRecord.SessionGoals = dataEncryptionAlgorithm.EncryptData(patientAppt.SessionGoals); patientApptDataContext.PatientAppointmentInformations.InsertOnSubmit(patientApptRecord); } patientApptDataContext.SubmitChanges(); }
protected void btnDeletePatient_Click(object sender, EventArgs e) { PatientDataContext patientDC = new PatientDataContext("Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename = C:\\SoftwareDevelopmentProjects\\WebProjects\\myTherapist\\myTherapist\\App_Data\\myTherapist.mdf; Integrated Security = True"); PatientInformation patientToDelete = new PatientInformation(); PatientAppointmentInfomationDataContext patientAppointmentInformationDC = new PatientAppointmentInfomationDataContext("Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename = C:\\SoftwareDevelopmentProjects\\WebProjects\\myTherapist\\myTherapist\\App_Data\\myTherapist.mdf; Integrated Security = True"); PatientAppointmentInformation patientAppointmentInformationToDelete = new PatientAppointmentInformation(); Int32 patientId = 0; if (Session[CommonDefinitions.CommonDefinitions.PATIENT_ID] != null) { if (Session[CommonDefinitions.CommonDefinitions.DELETE_PATIENT_WARNING] == null) { lblWarningText.Text = "Click Delete again to confirm this action."; lblWarningText.ForeColor = System.Drawing.Color.Red; lblWarningText.Visible = true; Session[CommonDefinitions.CommonDefinitions.DELETE_PATIENT_WARNING] = "yes"; } else { if (Int32.TryParse(Session[CommonDefinitions.CommonDefinitions.PATIENT_ID].ToString(), out patientId)) { Session[CommonDefinitions.CommonDefinitions.DELETE_PATIENT_WARNING] = null; PatientInformationTableManager patientTableMgr = new PatientInformationTableManager(); Patient patientInfo = new Patient(); patientInfo.Id = patientId; patientTableMgr.Delete(patientInfo); lblWarningText.Visible = false; PatientListing1.LoadGrid(); } } } else { lblWarningText.Visible = true; lblWarningText.Text = "Select a patient to delete."; lblWarningText.ForeColor = System.Drawing.Color.Red; } }
partial void DeletePatientAppointmentInformation(PatientAppointmentInformation instance);
partial void InsertPatientAppointmentInformation(PatientAppointmentInformation instance);