public void FromAliquotOrder(string aliquotOrderId, string aliquotLabel, string masterAccessionNo, string pLastName, string pFirstName) { this.m_AliquotOrderId = aliquotOrderId; this.m_MasterAccessionNo = masterAccessionNo; YellowstonePathology.Business.PatientName patientName = new PatientName(pLastName, pFirstName); this.m_PatientInitials = patientName.GetInitials(); this.m_AliquotLabel = aliquotLabel; }
public void FromLegacyAliquotOrder(string aliquotOrderId, string aliquotLabel, string reportNo, string pLastName, string pFirstName) { this.m_AliquotOrderId = aliquotOrderId; this.m_ReportNo = reportNo; YellowstonePathology.Business.PatientName patientName = new PatientName(pLastName, pFirstName); this.m_PatientInitials = patientName.GetInitials(); this.m_AliquotLabel = aliquotLabel; }
public void Equals_DoesNotMatchNull() { // Arrange var patientName = new PatientName("test"); // Act var result = patientName.Equals(null); // Arrange Assert.That(result, Is.False); }
public void Contains_ReturnsExpectedValue(string name, object value, bool expectedValue) { // Arrange var patientName = new PatientName(name); // Act var result = patientName.Contains(value); // Assert Assert.That(result, Is.EqualTo(expectedValue)); }
public void WriteJson_SerializesCorrectly() { // Arrange var testPatientName = new PatientName("Doe^John"); // Act var result = JsonConvert.SerializeObject(testPatientName); // Assert Assert.That(result, Is.EqualTo("\"Doe^John\"")); }
public void Equals_MatchEqualObject(string firstName, string secondName, bool expectedResult) { // Arrange var firstPatientName = new PatientName(firstName); var secondPatientName = new PatientName(secondName); // Act bool result = firstPatientName.Equals(secondPatientName); // Assert Assert.That(result, Is.EqualTo(expectedResult)); }
public void Constructor_NameIsCorrectlyParsed(string input, string expectedLastName, string expectedFirstName, string expectedMiddleName, string expectedPrefix, string expectedSuffix, string expectedToString) { // Arrange + Act var patientName = new PatientName(input); // Assert Assert.That(patientName.LastName, Is.EqualTo(expectedLastName)); Assert.That(patientName.FirstName, Is.EqualTo(expectedFirstName)); Assert.That(patientName.MiddleName, Is.EqualTo(expectedMiddleName)); Assert.That(patientName.Prefix, Is.EqualTo(expectedPrefix)); Assert.That(patientName.Suffix, Is.EqualTo(expectedSuffix)); Assert.That(patientName.DicomString, Is.EqualTo(input)); Assert.That(patientName.ToString(), Is.EqualTo(expectedToString)); }
public string Delete_Patient(PatientName Pat_Name) { SqlConnection sqlCon = new SqlConnection(ConStr); SqlCommand sqlCmd = new SqlCommand("sp_delete_Patient", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter P_ID = sqlCmd.Parameters.Add("@Pat_ID", SqlDbType.Int); P_ID.Value = Pat_Name.Pat_ID; try { sqlCon.Open(); sqlCmd.ExecuteNonQuery(); } catch (Exception ex) { return ex.ToString(); } finally { sqlCon.Close(); } return "Deleted Patient Information Successfully"; }
public void FromAliquotOrder(YellowstonePathology.Business.Test.AliquotOrder aliquotOrder, YellowstonePathology.Business.Test.AccessionOrder accessionOrder) { this.m_AliquotOrder = aliquotOrder; YellowstonePathology.Business.OrderIdParser orderIdParser = new YellowstonePathology.Business.OrderIdParser(accessionOrder.MasterAccessionNo); YellowstonePathology.Business.PatientName patientName = new PatientName(accessionOrder.PLastName, accessionOrder.PFirstName); this.m_MasterAccessionNo = orderIdParser.MasterAccessionNo; this.m_AliquotOrder = aliquotOrder; this.m_BlockTitle = aliquotOrder.PrintLabel; this.m_Verified = aliquotOrder.GrossVerified; this.m_PatientInitials = patientName.GetInitials(); this.m_EmbeddingInstructions = aliquotOrder.EmbeddingInstructions; if (accessionOrder.ClientAccessioned == true) { this.m_ClientAccessionNo = accessionOrder.ClientAccessionNo; this.m_ClientAccessioned = true; } else { this.m_ClientAccessionNo = null; this.m_ClientAccessioned = false; } this.m_CassetteColor = accessionOrder.CassetteColor; }
public void GetHashCode_SameCodeForEqualObjects() { // Arrange string name = "testName"; var firstPatientName = new PatientName(name); var secondPatientName = new PatientName(name); // Act int firstHashCode = firstPatientName.GetHashCode(); int secondHashCode = secondPatientName.GetHashCode(); // Assert Assert.That(firstHashCode, Is.EqualTo(secondHashCode)); }
public void Equals_DoesNotMatchDifferentType() { // Arrange var patientName = new PatientName("test"); // Act var result = patientName.Equals(1); // Arrange Assert.That(result, Is.False); }
public void Equals_PatientsWithSameIDAndNameAreEqual() { // Arrange var birthNumber = new BirthNumber("9107256444"); var name = new PatientName("Doe^John"); var patient1 = new PatientInfo { PatientID = birthNumber, PatientName = name }; var patient2 = new PatientInfo { PatientID = birthNumber, PatientName = name }; // Act var result = patient1.Equals(patient2); // Assert Assert.That(result, Is.True); }
/// <inheritdoc/> public string ToDelimitedString() { CultureInfo culture = CultureInfo.CurrentCulture; return(string.Format( culture, StringHelper.StringFormatSequence(0, 31, Configuration.FieldSeparator), Id, SetIdPid.HasValue ? SetIdPid.Value.ToString(culture) : null, PatientId?.ToDelimitedString(), PatientIdentifierList != null ? string.Join(Configuration.FieldRepeatSeparator, PatientIdentifierList.Select(x => x.ToDelimitedString())) : null, AlternatePatientIdPid != null ? string.Join(Configuration.FieldRepeatSeparator, AlternatePatientIdPid.Select(x => x.ToDelimitedString())) : null, PatientName != null ? string.Join(Configuration.FieldRepeatSeparator, PatientName.Select(x => x.ToDelimitedString())) : null, MothersMaidenName != null ? string.Join(Configuration.FieldRepeatSeparator, MothersMaidenName.Select(x => x.ToDelimitedString())) : null, DateTimeOfBirth.HasValue ? DateTimeOfBirth.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null, AdministrativeSex, PatientAlias != null ? string.Join(Configuration.FieldRepeatSeparator, PatientAlias.Select(x => x.ToDelimitedString())) : null, Race != null ? string.Join(Configuration.FieldRepeatSeparator, Race.Select(x => x.ToDelimitedString())) : null, PatientAddress != null ? string.Join(Configuration.FieldRepeatSeparator, PatientAddress.Select(x => x.ToDelimitedString())) : null, CountyCode, PhoneNumberHome != null ? string.Join(Configuration.FieldRepeatSeparator, PhoneNumberHome.Select(x => x.ToDelimitedString())) : null, PhoneNumberBusiness != null ? string.Join(Configuration.FieldRepeatSeparator, PhoneNumberBusiness.Select(x => x.ToDelimitedString())) : null, PrimaryLanguage?.ToDelimitedString(), MaritalStatus?.ToDelimitedString(), Religion?.ToDelimitedString(), PatientAccountNumber?.ToDelimitedString(), SsnNumberPatient, DriversLicenseNumberPatient?.ToDelimitedString(), MothersIdentifier != null ? string.Join(Configuration.FieldRepeatSeparator, MothersIdentifier.Select(x => x.ToDelimitedString())) : null, EthnicGroup != null ? string.Join(Configuration.FieldRepeatSeparator, EthnicGroup.Select(x => x.ToDelimitedString())) : null, BirthPlace, MultipleBirthIndicator, BirthOrder.HasValue ? BirthOrder.Value.ToString(Consts.NumericFormat, culture) : null, Citizenship != null ? string.Join(Configuration.FieldRepeatSeparator, Citizenship.Select(x => x.ToDelimitedString())) : null, VeteransMilitaryStatus?.ToDelimitedString(), Nationality?.ToDelimitedString(), PatientDeathDateAndTime.HasValue ? PatientDeathDateAndTime.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null, PatientDeathIndicator ).TrimEnd(Configuration.FieldSeparator.ToCharArray())); }
public void Equals_DoesMatchItself() { // Arrange var patientName = new PatientName("test"); // Act var result = patientName.Equals(patientName); // Arrange Assert.That(result, Is.True); }
private void AddPatientRecord(int isDupPatient) { if (rbtnMale.Checked == true) { Pat_Det.Gender = "M"; } else { Pat_Det.Gender = "F"; } PatientName Pat_Name = new PatientName(); int patFacID; patFacID = Pat_Info.Get_FacID(txtClinicFacility.Text); if (patFacID == 0) { Pat_Det.FacID = 0; } else { Pat_Det.FacID = patFacID; } Pat_Det.MRN = txtMRN.Text; Pat_Name.FirstName = txtPatientFName.Text; Pat_Name.MiddleName = txtPatientMName.Text; Pat_Name.LastName = txtPatientLName.Text; if (rbtnMale.Checked == true) { Pat_Det.Gender = "M"; } else { Pat_Det.Gender = "F"; } Pat_Det.DOB = txtDOB.Text; Pat_Det.SSN = txtSSN.Text; Pat_Det.eContactFName = txtecontactFNAME.Text.Trim(); Pat_Det.eContactLName = txtecontactLNAME.Text.Trim(); Pat_Det.eContactPhone = txtecontactPHONE.Text.Trim(); if (ddlecontactREL.SelectedValue != "0") Pat_Det.eContactRelation = ddlecontactREL.SelectedValue; Pat_Det.PatientAddress1 = txtAddress1.Text; Pat_Det.PatientAddress2 = txtAddress2.Text; Pat_Det.Pat_City = txtCity.Text; Pat_Det.Pat_state = txtState.Text; Pat_Det.Pat_ZIP = txtZip.Text; Pat_Det.PatientShipAddress1 = txtSAddr1.Text; Pat_Det.PatientShipAddress2 = txtSAddr2.Text; Pat_Det.Pat_SCity = txtSCity1.Text; Pat_Det.Pat_Sstate = txtSState.Text; Pat_Det.Pat_SZIP = txtSZIP.Text; Pat_Det.Pat_Phone = txtPhone.Text; Pat_Det.Pat_WPhone = txtWorkPhone.Text; Pat_Det.Pat_CellPhone = txtCellPhone.Text; string diag_Code = ""; if (txtDiagn1.Text.Trim() != "") diag_Code = txtDiagn1.Text.Trim(); if (txtDiagn2.Text.Trim() != "") { if (diag_Code.Trim() != "") diag_Code = diag_Code + "," + txtDiagn2.Text.Trim(); else diag_Code = diag_Code + txtDiagn2.Text.Trim(); } if (txtDiagn3.Text.Trim() != "") { if (diag_Code.Trim() != "") diag_Code = diag_Code + "," + txtDiagn3.Text.Trim(); else diag_Code = diag_Code + txtDiagn3.Text.Trim(); } if (txtDiagn4.Text.Trim() != "") { if (diag_Code.Trim() != "") diag_Code = diag_Code + "," + txtDiagn4.Text.Trim(); else diag_Code = diag_Code + txtDiagn4.Text.Trim(); } if (txtDiagn5.Text.Trim() != "") { if (diag_Code.Trim() != "") diag_Code = diag_Code + "," + txtDiagn5.Text.Trim(); else diag_Code = diag_Code + txtDiagn5.Text.Trim(); } Pat_Det.Pat_Diagnosis = diag_Code; Pat_Det.Pat_Pre_Doc = txtDoctor.Text; Pat_Det.DocID = Int32.Parse(Pat_Info.Get_DocID(txtDoctor.Text).ToString()); if (chkAutoreFillOption.Checked) Pat_Det.Pat_AutoFill = "Y"; else Pat_Det.Pat_AutoFill = "N"; if (chkHippa.Checked) { Pat_Det.HIPPANotice = "Y"; Pat_Det.HIPPADate = txtHippaDate.Text; } else Pat_Det.HIPPANotice = "N"; if (ddlPrimInsurance.Enabled == true) Pat_Det.PrimaryInsID = int.Parse(ddlPrimInsurance.SelectedValue.ToString()); else Pat_Det.PrimaryInsID = 0; //if(ddlPatStatus.Enabled==true) Pat_Det.PatientStatus = 'Y'; string userID = (string)Session["User"]; if (Pat_Det.FacID == 0) { //lblStatus.Visible = true; //lblStatus.Text = "No Facilities Found / Invalid Facility..!"; divPatWarning.Visible = true; divPatError.Visible = false; divPatSuccess.Visible = false; lblAddPatientStatus.Text = "No Facilities Found / Invalid Facility..!"; mpeAddPatientStatus.Show(); } else if (Pat_Det.DocID == 0) { //lblStatus.Visible = true; //lblStatus.Text = "No Doctors Found / Invalid Doctor..!"; divPatWarning.Visible = true; divPatError.Visible = false; divPatSuccess.Visible = false; lblAddPatientStatus.Text = "No Doctors Found / Invalid Doctor..!"; mpeAddPatientStatus.Show(); } else { //Insert New Patient Details string patID = Pat_Info.set_PatientInfo(userID, Pat_Name, Pat_Det); hidPat_ID.Value = patID; //lblStatus.Visible = true; //lblStatus.Text = "Patient Added Successfully..!"; tabCntPatient.Visible = true; tabCntPatient.ActiveTabIndex = 0; divPatWarning.Visible = false; divPatError.Visible = false; divPatSuccess.Visible = true; //if(isDupPatient==0) // lblAddPatientStatus.Text = "Patient Record Added Successfully..!"; //else // lblAddPatientStatus.Text = "Patient Duplicate Record Added Successfully..!"; lblAddPatientStatus.Text = "Patient Record Added Successfully..!"; mpeAddPatientStatus.Show(); } }
protected void btnUpdate_Click(object sender, ImageClickEventArgs e) { objNLog.Info("Event Started.."); //if (lblStatus.Visible == true) // lblStatus.Visible = false; PatientPersonalDetails Pat_Det = new PatientPersonalDetails(); PatientInfoDAL Pat_Info = new PatientInfoDAL(); try { PatientName Pat_Name = new PatientName(); int facID=Pat_Info.Get_FacID(txtClinicFacility.Text); if (facID == 0) { Pat_Det.FacID = 0; } else { Pat_Det.FacID = facID; } Pat_Det.MRN = txtMRN.Text; Pat_Name.FirstName = txtPatientFName.Text; Pat_Name.LastName = txtPatientLName.Text; Pat_Name.MiddleName = txtPatientMName.Text; if (rbtnMale.Checked == true) { Pat_Det.Gender = "M"; } else { Pat_Det.Gender = "F"; } Pat_Det.DOB = txtDOB.Text; Pat_Det.SSN = txtSSN.Text; Pat_Det.eContactFName = txtecontactFNAME.Text.Trim(); Pat_Det.eContactLName = txtecontactLNAME.Text.Trim(); Pat_Det.eContactPhone = txtecontactPHONE.Text.Trim(); if (ddlecontactREL.SelectedValue != "0") Pat_Det.eContactRelation = ddlecontactREL.SelectedValue; Pat_Det.PatientAddress1 = txtAddress1.Text; Pat_Det.PatientAddress2 = txtAddress2.Text; Pat_Det.Pat_City = txtCity.Text; Pat_Det.Pat_state = txtState.Text; Pat_Det.Pat_ZIP = txtZip.Text; Pat_Det.PatientShipAddress1 = txtSAddr1.Text; Pat_Det.PatientShipAddress2 = txtSAddr2.Text; Pat_Det.Pat_SCity = txtSCity1.Text; Pat_Det.Pat_Sstate = txtSState.Text; Pat_Det.Pat_SZIP = txtSZIP.Text; Pat_Det.Pat_Phone = txtPhone.Text; Pat_Det.Pat_WPhone = txtWorkPhone.Text; Pat_Det.Pat_CellPhone = txtCellPhone.Text; string diag_Code = ""; if (txtDiagn1.Text.Trim() != "") diag_Code = txtDiagn1.Text.Trim(); if (txtDiagn2.Text.Trim() != "") { if (diag_Code.Trim() != "") diag_Code = diag_Code + "," + txtDiagn2.Text.Trim(); else diag_Code = diag_Code + txtDiagn2.Text.Trim(); } if (txtDiagn3.Text.Trim() != "") { if (diag_Code.Trim() != "") diag_Code = diag_Code + "," + txtDiagn3.Text.Trim(); else diag_Code = diag_Code + txtDiagn3.Text.Trim(); } if (txtDiagn4.Text.Trim() != "") { if (diag_Code.Trim() != "") diag_Code = diag_Code + "," + txtDiagn4.Text.Trim(); else diag_Code = diag_Code + txtDiagn4.Text.Trim(); } if (txtDiagn5.Text.Trim() != "") { if (diag_Code.Trim() != "") diag_Code = diag_Code + "," + txtDiagn5.Text.Trim(); else diag_Code = diag_Code + txtDiagn5.Text.Trim(); } Pat_Det.Pat_Diagnosis = diag_Code; Pat_Det.Pat_Pre_Doc = txtDoctor.Text; Pat_Det.DocID = Int32.Parse(Pat_Info.Get_DocID(txtDoctor.Text).ToString()); if (chkAutoreFillOption.Checked) Pat_Det.Pat_AutoFill = "Y"; else Pat_Det.Pat_AutoFill = "N"; if (chkHippa.Checked) { Pat_Det.HIPPANotice = "Y"; Pat_Det.HIPPADate = txtHippaDate.Text; } else Pat_Det.HIPPANotice = "N"; Pat_Det.Pat_ID = int.Parse(hidPat_ID.Value.ToString()); if (ddlPrimInsurance.Enabled == true ) Pat_Det.PrimaryInsID = int.Parse(ddlPrimInsurance.SelectedValue.ToString()); if (ddlPatStatus.Enabled == true) Pat_Det.PatientStatus = char.Parse(ddlPatStatus.SelectedValue); string userID = (string)Session["User"]; if (Pat_Det.FacID == 0) { //lblStatus.Visible=true; //lblStatus.Text = "No Facilities Found / Invalid Facility..!"; divPatWarning.Visible = true; divPatError.Visible = false; divPatSuccess.Visible = false; lblAddPatientStatus.Text = "No Facilities Found / Invalid Facility..!"; mpeAddPatientStatus.Show(); } else if (Pat_Det.DocID == 0) { //lblStatus.Visible = true; //lblStatus.Text = "No Doctors Found / Invalid Doctor..!"; divPatWarning.Visible = true; divPatError.Visible = false; divPatSuccess.Visible = false; lblAddPatientStatus.Text = "No Doctors Found / Invalid Doctor..!"; mpeAddPatientStatus.Show(); } else { Pat_Info.update_patInfo(userID, Pat_Det, Pat_Name); Response.Redirect("AllPatientProfile.aspx?patID=" + Request.QueryString["patID"].ToString()); } } catch (Exception ex) { objNLog.Error("Error : " + ex.Message); } objNLog.Info("Event Completed.."); }
public Object GetRidePatView(int daysAhead) { // get the basic ride data DbService db = new DbService(); Dictionary <int, RideSlimExt> dic = new Dictionary <int, RideSlimExt>(); //List<RideSlimExt> rides = new List<RideSlimExt>(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@daysAhead", daysAhead); cmd.CommandText = "spGetBasicRidePatData"; //if (db.con.State == ConnectionState.Closed) //{ // con.Open(); //} //command.Connection = con; SqlDataReader dr = db.GetDataReaderSP(cmd); while (dr.Read()) { Id = Convert.ToInt32(dr["ridepatnum"]); Destination = dr["destination"].ToString(); Origin = dr["origin"].ToString(); PickUpTime = Convert.ToDateTime(dr["PickUpTime"].ToString()); bool isAnonymous = true; if (dr["IsAnonymous"] == System.DBNull.Value) { isAnonymous = false; } else { isAnonymous = Convert.ToBoolean(dr["IsAnonymous"]); } PatientName = dr["patient"].ToString(); if (isAnonymous || PatientName.Contains("אנונימי") || PatientName.Contains("Anonymous")) { PatientName = "אנונימי"; } CellPhone = dr["CellPhone"].ToString(); RideSlimExt rse = new RideSlimExt(PatientName, "", 0, Origin, Destination, PickUpTime, Id, CellPhone); rse.Area = dr["area"].ToString(); rse.OnlyEscort = Convert.ToBoolean(dr["onlyEscort"]); dic.Add(Id, rse); } dr.Close(); // get the escorts cmd.CommandText = "spGetEscortsForRides"; dr = db.GetDataReaderSP(cmd); while (dr.Read()) { int ridepatnum = Convert.ToInt32(dr["ridepatnum"]); dic[ridepatnum].escorts = new List <EscoretSlim>(); string displayName = dr["DisplayName"].ToString(); bool isAnonymous = true; if (dr["IsAnonymous"] == System.DBNull.Value) { isAnonymous = false; } else { isAnonymous = Convert.ToBoolean(dr["IsAnonymous"]); } if (isAnonymous != true && !displayName.Contains("אנונימי") && !displayName.Contains("Anonymus")) { string cellphone = dr["CellPhone"].ToString(); dic[ridepatnum].escorts.Add(new EscoretSlim(displayName, cellphone, 0)); } else { dic[ridepatnum].escorts.Add(new EscoretSlim("אנונימי", "", 0)); } } dr.Close(); // get the equipment cmd.CommandText = "spGetEquipmentPerPatient"; dr = db.GetDataReaderSP(cmd); while (dr.Read()) { string patient = dr["patient"].ToString(); string equipment = dr["Name"].ToString(); foreach (KeyValuePair <int, RideSlimExt> kv in dic) { if (kv.Value.PatientName == patient) { if (kv.Value.equipment == null) { kv.Value.equipment = new List <string>(); } kv.Value.equipment.Add(equipment); } } } db.CloseConnection(); List <RideSlimExt> l = dic.Values.ToList <RideSlimExt>(); Object o = RideSlimExtToObject(l); return(o); }
public void FromAliquotOrder(YellowstonePathology.Business.Test.AliquotOrder aliquotOrder, YellowstonePathology.Business.Test.AccessionOrder accessionOrder) { this.m_AliquotOrder = aliquotOrder; YellowstonePathology.Business.OrderIdParser orderIdParser = new YellowstonePathology.Business.OrderIdParser(accessionOrder.MasterAccessionNo); YellowstonePathology.Business.PatientName patientName = new PatientName(accessionOrder.PLastName, accessionOrder.PFirstName); this.m_MasterAccessionNo = orderIdParser.MasterAccessionNo; this.m_AliquotOrder = aliquotOrder; this.m_BlockTitle = aliquotOrder.PrintLabel; this.m_Verified = aliquotOrder.GrossVerified; this.m_PatientInitials = patientName.GetInitials(); this.m_EmbeddingInstructions = aliquotOrder.EmbeddingInstructions; if(accessionOrder.ClientAccessioned == true) { this.m_ClientAccessionNo = accessionOrder.ClientAccessionNo; this.m_ClientAccessioned = true; } else { this.m_ClientAccessionNo = null; this.m_ClientAccessioned = false; } if(YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference.UseLaserCassettePrinter == false) { this.m_CassetteColumn = accessionOrder.PrintMateColumnNumber.ToString(); } else { YellowstonePathology.Business.Common.PrintMateCarousel printMateCarousel = new Common.PrintMateCarousel(); YellowstonePathology.Business.Common.PrintMateColumn printMateColumn = printMateCarousel.GetColumn(accessionOrder.PrintMateColumnNumber); this.m_CassetteColumn = printMateColumn.GeneralDataColor.ToString(); } }
public DataTable getPatSearch(PatientName Pat_Name) { SqlConnection con = new SqlConnection(ConStr); SqlCommand sqlCmd = new SqlCommand("select * from Patient_Info where Pat_FName ='"+Pat_Name.FirstName+"' and Pat_LName = '"+Pat_Name.LastName+ "'", con); SqlDataReader sqlDr; DataTable dtable = new DataTable(); // DataRow dr; con.Open(); sqlDr = sqlCmd.ExecuteReader(); dtable.Load(sqlDr); con.Close(); return dtable; }
public void Equals_WithDifferentType_ReturnsFalse() { // Arrange var birthNumber = new BirthNumber("9107256444"); var name = new PatientName("Doe^John"); var patient = new PatientInfo { PatientID = birthNumber, PatientName = name }; // Act var result = patient.Equals(new object()); // Assert Assert.That(result, Is.False); }
public string Update_Patient(PatientName Pat_Name, PatientPersonalDetails Pat_Per_Details, PatientAddress Pat_Add, PatientInsuranceDetails Pat_Ins_Details, PatientAllergies Pat_Allergies, FacilityInfo Fac_Info, PharmacyInfo Phrm_Info,ProviderInfo Prov_Info) { SqlConnection sqlCon = new SqlConnection(ConStr); SqlCommand sqlCmd = new SqlCommand("sp_update_Patient", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter P_ID = sqlCmd.Parameters.Add("@Pat_ID", SqlDbType.Int); P_ID.Value = Pat_Name.Pat_ID; SqlParameter P_MName = sqlCmd.Parameters.Add("@Pat_MName", SqlDbType.VarChar, 50); if (Pat_Name.MiddleName != null) P_MName.Value = Pat_Name.MiddleName; else P_MName.Value = Convert.DBNull; SqlParameter P_Gender = sqlCmd.Parameters.Add("@Pat_Gender", SqlDbType.Char, 1); if (Pat_Per_Details.Gender != null) P_Gender.Value = Pat_Per_Details.Gender; else P_Gender.Value = Convert.DBNull; SqlParameter P_DOB = sqlCmd.Parameters.Add("@Pat_DOB", SqlDbType.DateTime); if (Pat_Per_Details.DOB != null) P_DOB.Value = DateTime.Parse(Pat_Per_Details.DOB); else { Nullable<DateTime> NullDate = null; P_DOB.Value = NullDate; } SqlParameter P_SSN = sqlCmd.Parameters.Add("@Pat_SSN", SqlDbType.VarChar, 50); if (Pat_Per_Details.SSN != null) P_SSN.Value = Pat_Per_Details.SSN; else P_SSN.Value = Convert.DBNull; SqlParameter P_Address1 = sqlCmd.Parameters.Add("@Pat_Address1", SqlDbType.VarChar, 50); if (Pat_Add.Address1 != null) P_Address1.Value = Pat_Add.Address1; else P_Address1.Value = Convert.DBNull; SqlParameter P_Address2 = sqlCmd.Parameters.Add("@Pat_Address2", SqlDbType.VarChar, 50); if (Pat_Add.Address2 != null) P_Address2.Value = Pat_Add.Address2; else P_Address2.Value = Convert.DBNull; SqlParameter P_City = sqlCmd.Parameters.Add("@Pat_City", SqlDbType.VarChar, 50); if (Pat_Add.City != null) P_City.Value = Pat_Add.City; else P_City.Value = Convert.DBNull; SqlParameter P_State = sqlCmd.Parameters.Add("@Pat_State", SqlDbType.VarChar, 50); if (Pat_Add.State != null) P_State.Value = Pat_Add.State; else P_State.Value = Convert.DBNull; SqlParameter P_ZIP = sqlCmd.Parameters.Add("@Pat_Zip", SqlDbType.VarChar, 50); if (Pat_Add.Zip != null) P_ZIP.Value = Pat_Add.Zip; else P_ZIP.Value = Convert.DBNull; SqlParameter P_PDoc = sqlCmd.Parameters.Add("@Pat_PDoc", SqlDbType.VarChar, 50); if (Pat_Per_Details.Pat_Pre_Doc != null) P_PDoc.Value = Pat_Per_Details.Pat_Pre_Doc; else P_PDoc.Value = Convert.DBNull; SqlParameter P_MRN = sqlCmd.Parameters.Add("@Pat_MRN", SqlDbType.VarChar, 15); if (Pat_Per_Details.MRN != null) P_MRN.Value = Pat_Per_Details.MRN; else P_MRN.Value = Convert.DBNull; SqlParameter Fac_ID = sqlCmd.Parameters.Add("@Fac_ID", SqlDbType.Int); if (Fac_Info.FacilityNO != null) Fac_ID.Value = Fac_Info.FacilityNO; else Fac_ID.Value = Convert.DBNull; SqlParameter Phrm_ID = sqlCmd.Parameters.Add("@Phrm_ID", SqlDbType.Int); if (Phrm_Info.PhrmID != null) Phrm_ID.Value = Phrm_Info.PhrmID; else Phrm_ID.Value = Convert.DBNull; //SqlParameter PI_InsName = sqlCmd.Parameters.Add("@Ins_Name", SqlDbType.VarChar, 50); //if (Pat_Ins_Details.InsuranceName != null) // PI_InsName.Value = Pat_Ins_Details.InsuranceName; //else // PI_InsName.Value = Convert.DBNull; int InsID = getInsuranceID(Pat_Ins_Details); Pat_Ins_Details.InsuranceID = InsID; SqlParameter Ins_ID = sqlCmd.Parameters.Add("@Ins_ID", SqlDbType.Int); if (Pat_Ins_Details.InsuranceID.ToString() != "0") Ins_ID.Value = Pat_Ins_Details.InsuranceID; else Ins_ID.Value = Convert.DBNull; SqlParameter PI_No = sqlCmd.Parameters.Add("@PI_Number", SqlDbType.Int); if (Pat_Ins_Details.PI_PolicyNo.ToString() != "0") PI_No.Value = Pat_Ins_Details.PI_PolicyNo; else PI_No.Value = Convert.DBNull; SqlParameter PI_PolicyID = sqlCmd.Parameters.Add("@PI_PolicyID", SqlDbType.Int); if (Pat_Ins_Details.PI_PolicyID.ToString() != "0") PI_PolicyID.Value = Pat_Ins_Details.PI_PolicyID; else PI_PolicyID.Value = Convert.DBNull; SqlParameter PI_GroupNo = sqlCmd.Parameters.Add("@PI_GroupNo", SqlDbType.Int); if (Pat_Ins_Details.PI_GroupNo.ToString() != "0") PI_GroupNo.Value = Pat_Ins_Details.PI_GroupNo; else PI_GroupNo.Value = Convert.DBNull; SqlParameter PI_BINNo = sqlCmd.Parameters.Add("@PI_BINNo", SqlDbType.Int); if (Pat_Ins_Details.PI_BINNo.ToString() != "0") PI_BINNo.Value = Pat_Ins_Details.PI_BINNo; else PI_BINNo.Value = Convert.DBNull; SqlParameter PI_InsdName = sqlCmd.Parameters.Add("@PI_InsdName", SqlDbType.VarChar, 50); if (Pat_Ins_Details.InsuredName != null) PI_InsdName.Value = Pat_Ins_Details.InsuredName; else PI_InsdName.Value = Convert.DBNull; SqlParameter PI_InsdDOB = sqlCmd.Parameters.Add("@PI_InsdDOB", SqlDbType.DateTime); if (Pat_Ins_Details.InsuredDOB != null) PI_InsdDOB.Value = DateTime.Parse( Pat_Ins_Details.InsuredDOB); else { Nullable<DateTime> NullDate = null; PI_InsdDOB.Value = NullDate; } SqlParameter PI_InsdSSN = sqlCmd.Parameters.Add("@PI_InsdSSN", SqlDbType.VarChar, 50); if (Pat_Ins_Details.InsuredSSN != null) PI_InsdSSN.Value = Pat_Ins_Details.InsuredSSN; else PI_InsdSSN.Value = Convert.DBNull; SqlParameter PI_InsdRel = sqlCmd.Parameters.Add("@PI_InsdRel", SqlDbType.VarChar, 50); if (Pat_Ins_Details.InsuredRelation != null) PI_InsdRel.Value = Pat_Ins_Details.InsuredRelation; else PI_InsdRel.Value = Convert.DBNull; SqlParameter PA_Desc = sqlCmd.Parameters.Add("@PA_Desc", SqlDbType.VarChar, 200); if (Pat_Allergies.AllergyDescription != null) PA_Desc.Value = Pat_Allergies.AllergyDescription; else PA_Desc.Value = Convert.DBNull; try { sqlCon.Open(); sqlCmd.ExecuteNonQuery(); } catch (Exception ex) { return ex.ToString(); } finally { sqlCon.Close(); } return "Updated Patient Information Successfully"; }
public void update_patInfo(string userID,PatientPersonalDetails Pat_Info, PatientName Pat_Name) { objNLog.Info("Function Started with Pat_Info, Pat_Name as argument..."); bool successFlag = false; SqlConnection sqlCon = new SqlConnection(conStr); try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_update_PatientInfo"; cmd.Connection = sqlCon; SqlParameter sql_FacId = cmd.Parameters.Add("@FacId", SqlDbType.Int); sql_FacId.Value = Pat_Info.FacID; SqlParameter sql_PatMRN = cmd.Parameters.Add("@Pat_MRN", SqlDbType.VarChar,15); sql_PatMRN.Value = Pat_Info.MRN; SqlParameter sql_PatFname = cmd.Parameters.Add("@Pat_Fname", SqlDbType.VarChar, 50); sql_PatFname.Value = Pat_Name.FirstName; SqlParameter sql_PatMname = cmd.Parameters.Add("@Pat_Mname", SqlDbType.VarChar, 50); sql_PatMname.Value = Pat_Name.MiddleName; SqlParameter sql_PatLname = cmd.Parameters.Add("@Pat_Lname", SqlDbType.VarChar, 50); sql_PatLname.Value = Pat_Name.LastName; SqlParameter sql_PatGender = cmd.Parameters.Add("@Pat_Gender", SqlDbType.Char, 1); sql_PatGender.Value = Pat_Info.Gender; SqlParameter sql_PatDob = cmd.Parameters.Add("@Pat_DOB", SqlDbType.DateTime2, 7); sql_PatDob.Value = Convert.ToDateTime(Pat_Info.DOB); SqlParameter sql_PatSSN = cmd.Parameters.Add("@Pat_SSN", SqlDbType.VarChar, 16); sql_PatSSN.Value = Pat_Info.SSN; SqlParameter sql_PatAdd1 = cmd.Parameters.Add("@Pat_Address1", SqlDbType.VarChar, 50); sql_PatAdd1.Value = Pat_Info.PatientAddress1; SqlParameter sql_PatAdd2 = cmd.Parameters.Add("@Pat_Address2", SqlDbType.VarChar, 50); sql_PatAdd2.Value = Pat_Info.PatientAddress2; SqlParameter sql_PatCity = cmd.Parameters.Add("@Pat_City", SqlDbType.VarChar, 50); sql_PatCity.Value = Pat_Info.Pat_City ; SqlParameter sql_PatState = cmd.Parameters.Add("@Pat_State", SqlDbType.VarChar, 14); sql_PatState.Value = Pat_Info.Pat_state; SqlParameter sql_PatZip = cmd.Parameters.Add("@Pat_Zip", SqlDbType.VarChar, 10); sql_PatZip.Value = Pat_Info.Pat_ZIP; SqlParameter sql_PatSAdd1 = cmd.Parameters.Add("@Pat_SAddress1", SqlDbType.VarChar, 50); sql_PatSAdd1.Value = Pat_Info.PatientShipAddress1; SqlParameter sql_PatSAdd2 = cmd.Parameters.Add("@Pat_SAddress2", SqlDbType.VarChar, 50); sql_PatSAdd2.Value = Pat_Info.PatientShipAddress2; SqlParameter sql_PatSCity = cmd.Parameters.Add("@Pat_SCity", SqlDbType.VarChar, 50); sql_PatSCity.Value = Pat_Info.Pat_SCity; SqlParameter sql_PatSState = cmd.Parameters.Add("@Pat_SState", SqlDbType.VarChar, 14); sql_PatSState.Value = Pat_Info.Pat_Sstate; SqlParameter sql_PatSZip = cmd.Parameters.Add("@Pat_SZip", SqlDbType.VarChar, 10); sql_PatSZip.Value = Pat_Info.Pat_SZIP; SqlParameter sql_PatPhone = cmd.Parameters.Add("@Pat_Phone", SqlDbType.VarChar, 16); sql_PatPhone.Value = Pat_Info.Pat_Phone;//@Pat_WPhone SqlParameter sql_PatCPhone = cmd.Parameters.Add("@Pat_CPhone", SqlDbType.VarChar, 16); sql_PatCPhone.Value = Pat_Info.Pat_CellPhone; SqlParameter sql_PatWPhone = cmd.Parameters.Add("@Pat_WPhone", SqlDbType.VarChar, 16); sql_PatWPhone.Value = Pat_Info.Pat_WPhone; SqlParameter sql_patDoc = cmd.Parameters.Add("@Pat_PDoc", SqlDbType.VarChar, 50); sql_patDoc.Value = Pat_Info.Pat_Pre_Doc; SqlParameter sql_AutoFill = cmd.Parameters.Add("@AutoFill", SqlDbType.Char, 1); sql_AutoFill.Value = Pat_Info.Pat_AutoFill; SqlParameter sql_DocId = cmd.Parameters.Add("@DocId", SqlDbType.Int); sql_DocId.Value = Pat_Info.DocID; SqlParameter sql_PatPrmIns = cmd.Parameters.Add("@Pat_PrimInsu_ID", SqlDbType.Int); if(Pat_Info.PrimaryInsID!=0) sql_PatPrmIns.Value = Pat_Info.PrimaryInsID; SqlParameter par_DiagnnosisCode = cmd.Parameters.Add("@DiagnnosisCode", SqlDbType.VarChar, 255); par_DiagnnosisCode.Value = Pat_Info.Pat_Diagnosis; SqlParameter par_Patid = cmd.Parameters.Add("@Pat_ID", SqlDbType.Int); if (Pat_Info.Pat_ID != null) par_Patid.Value = Pat_Info.Pat_ID; //SqlParameter sql_Pharmacy = cmd.Parameters.Add("@Pharmacy", SqlDbType.VarChar, 255); //sql_Pharmacy.Value = Pat_Info.PhacyName; SqlParameter sql_userid = cmd.Parameters.Add("@UserID", SqlDbType.VarChar, 20); sql_userid.Value = userID; SqlParameter sql_HIPPA_Notice = cmd.Parameters.Add("@HIPPA", SqlDbType.Char, 1); sql_HIPPA_Notice.Value = Pat_Info.HIPPANotice ; SqlParameter sql_HIPPA_Date = cmd.Parameters.Add("@HIPPADate", SqlDbType.Date , 7); if(Pat_Info.HIPPANotice=="Y") sql_HIPPA_Date.Value = Pat_Info.HIPPADate; SqlParameter sql_ecFNAME = cmd.Parameters.Add("@ecFNAME", SqlDbType.VarChar, 20); sql_ecFNAME.Value = Pat_Info.eContactFName; SqlParameter sql_ecLNAME = cmd.Parameters.Add("@ecLNAME", SqlDbType.VarChar, 20); sql_ecLNAME.Value = Pat_Info.eContactLName; SqlParameter sql_ecPHONE = cmd.Parameters.Add("@ecPHONE", SqlDbType.VarChar, 50); sql_ecPHONE.Value = Pat_Info.eContactPhone; SqlParameter sql_ecREL = cmd.Parameters.Add("@ecREL", SqlDbType.Char, 1); sql_ecREL.Value = Pat_Info.eContactRelation; SqlParameter sql_IsActive = cmd.Parameters.Add("@Pat_Status", SqlDbType.Char, 1); sql_IsActive.Value = Pat_Info.PatientStatus; sqlCon.Open(); cmd.ExecuteNonQuery(); successFlag = true; objUALog.LogUserActivity(conStr, userID, "Updated Patient Profile Info. with PatID = " + Pat_Info.Pat_ID.ToString(), "Patient_Info", Pat_Info.Pat_ID ); } catch (SqlException SqlEx) { objNLog.Error("SQLException : " + SqlEx.Message); throw new Exception("Exception re-Raised from DL with SQLError# " + SqlEx.Number + " while Updating Patient Info.", SqlEx); } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); throw new Exception("**Error occured while Updating Patient Info.", ex); } finally { sqlCon.Close(); objNLog.Info("Finally Block: " + successFlag); } objNLog.Info("Function Completed..."); }
public void GetHashCode_PatientsWithSameIDAndNameAreEqual() { // Arrange var birthNumber = new BirthNumber("9107256444"); var name = new PatientName("Doe^John"); var patient1 = new PatientInfo { PatientID = birthNumber, PatientName = name }; var patient2 = new PatientInfo { PatientID = birthNumber, PatientName = name }; // Act var hash1 = patient1.GetHashCode(); var hash2 = patient2.GetHashCode(); // Assert Assert.That(hash1, Is.EqualTo(hash2)); }
private IList <RestoreQueue> InternalSelect(int startRowIndex, int maximumRows, out int resultCount) { resultCount = 0; if (maximumRows == 0) { return(new List <RestoreQueue>()); } if (SearchKeys != null) { IList <RestoreQueue> archiveQueueList = new List <RestoreQueue>(); foreach (ServerEntityKey key in SearchKeys) { archiveQueueList.Add(RestoreQueue.Load(key)); } resultCount = archiveQueueList.Count; return(archiveQueueList); } WebQueryRestoreQueueParameters parameters = new WebQueryRestoreQueueParameters(); parameters.StartIndex = startRowIndex; parameters.MaxRowCount = maximumRows; if (Partition != null) { parameters.ServerPartitionKey = Partition.Key; } if (!string.IsNullOrEmpty(PatientId)) { string key = PatientId.Replace("*", "%"); key = key.Replace("?", "_"); parameters.PatientId = key; } if (!string.IsNullOrEmpty(PatientName)) { string key = PatientName.Replace("*", "%"); key = key.Replace("?", "_"); parameters.PatientsName = key; } if (String.IsNullOrEmpty(ScheduledDate)) { parameters.ScheduledTime = null; } else { parameters.ScheduledTime = DateTime.ParseExact(ScheduledDate, DateFormats, null); } if (StatusEnum != null) { parameters.RestoreQueueStatusEnum = StatusEnum; } List <string> groupOIDs = new List <string>(); CustomPrincipal user = Thread.CurrentPrincipal as CustomPrincipal; if (user != null) { if (!user.IsInRole(MatrixPACS.Enterprise.Common.AuthorityTokens.DataAccess.AllStudies)) { foreach (var oid in user.Credentials.DataAccessAuthorityGroups) { groupOIDs.Add(oid.ToString()); } parameters.CheckDataAccess = true; parameters.UserAuthorityGroupGUIDs = StringUtilities.Combine(groupOIDs, ","); } } IList <RestoreQueue> list = _searchController.FindRestoreQueue(parameters); resultCount = parameters.ResultCount; return(list); }
public DataTable getPatInsDetails(PatientName Pat_Name) { SqlConnection con = new SqlConnection(ConStr); SqlCommand sqlCmd = new SqlCommand("select * from Patient_Ins where Pat_ID = '" + Pat_Name.Pat_ID + "'", con); SqlDataReader sqlDr; DataTable dtable = new DataTable(); // DataRow dr; con.Open(); sqlDr = sqlCmd.ExecuteReader(); dtable.Load(sqlDr); con.Close(); return dtable; }