public PatientInsuranceDetails UpdatePatientInsuranceData(int id, PatientInsuranceDetails patientInfo) { try { if (id > 0) { var patientInsuranceDetails = _context.PatientInsuranceDetails.Find(id); if (patientInsuranceDetails != null) { patientInsuranceDetails.PatientID = patientInfo.PatientID; patientInsuranceDetails.InsuranceCompanyID = patientInfo.InsuranceCompanyID; patientInsuranceDetails.InsuranceCompanyAddress = patientInfo.InsuranceCompanyAddress; patientInsuranceDetails.InsuranceIDNumber = patientInfo.InsuranceIDNumber; patientInsuranceDetails.InsuranceGroupName = patientInfo.InsuranceGroupName; patientInsuranceDetails.InsurancePlanName = patientInfo.InsurancePlanName; patientInsuranceDetails.InsurancePlanTypeID = patientInfo.InsurancePlanTypeID; patientInsuranceDetails.InsuranceTypeID = patientInfo.InsuranceTypeID; patientInsuranceDetails.InsuranceClaimOfficeNumber = patientInfo.InsuranceClaimOfficeNumber; patientInsuranceDetails.VisitsAllowedPerYear = patientInfo.VisitsAllowedPerYear; patientInsuranceDetails.CardIssueDate = patientInfo.CardIssueDate; patientInsuranceDetails.Notes = patientInfo.Notes; if (!string.IsNullOrEmpty(patientInfo.Base64Front)) { patientInsuranceDetails.InsurancePhotoPathFront = patientInfo.InsurancePhotoPathFront; patientInsuranceDetails.InsurancePhotoPathThumbFront = patientInfo.InsurancePhotoPathThumbFront; } if (!string.IsNullOrEmpty(patientInfo.Base64Back)) { patientInsuranceDetails.InsurancePhotoPathBack = patientInfo.InsurancePhotoPathBack; patientInsuranceDetails.InsurancePhotoPathThumbBack = patientInfo.InsurancePhotoPathThumbBack; } patientInsuranceDetails.InsurancePersonSameAsPatient = patientInfo.InsurancePersonSameAsPatient; patientInsuranceDetails.IsActive = patientInfo.IsActive; patientInsuranceDetails.UpdatedDate = DateTime.Now; patientInsuranceDetails.UpdatedBy = patientInfo.UpdatedBy; patientInsuranceDetails.IsVerified = patientInfo.IsVerified; _context.SaveChanges(); } return(patientInsuranceDetails); } return(null); } catch (Exception ex) { throw; } }
public void Update_Pat_Insurance(string userID,PatientInsuranceDetails pInsDetails,int patID) { bool successFlag = false; SqlConnection sqlCon = new SqlConnection(conStr); objNLog.Info("Function Started with parameter pInsDetails"); try { SqlCommand sqlCmd = new SqlCommand("sp_Update_Pat_Ins", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter Pat_Ins_ID = sqlCmd.Parameters.Add("@Pat_Ins_ID", SqlDbType.Int); Pat_Ins_ID.Value = pInsDetails.PI_ID; SqlParameter Pat_ID = sqlCmd.Parameters.Add("@Pat_ID", SqlDbType.Int); Pat_ID.Value = pInsDetails.Pat_ID; SqlParameter Ins_ID = sqlCmd.Parameters.Add("@Ins_ID", SqlDbType.Int); Ins_ID.Value = pInsDetails.InsuranceID; SqlParameter PI_PolicyID = sqlCmd.Parameters.Add("@PI_PolicyID", SqlDbType.VarChar, 25); PI_PolicyID.Value = pInsDetails.PI_PolicyID; SqlParameter PI_GroupNo = sqlCmd.Parameters.Add("@PI_GroupNo", SqlDbType.VarChar, 25); PI_GroupNo.Value = pInsDetails.PI_GroupNo; SqlParameter PI_BINNo = sqlCmd.Parameters.Add("@PI_BINNo", SqlDbType.VarChar, 25); PI_BINNo.Value = pInsDetails.PI_BINNo; SqlParameter PI_InsdName = sqlCmd.Parameters.Add("@PI_InsdName", SqlDbType.VarChar, 50); PI_InsdName.Value = pInsDetails.InsuredName; SqlParameter PI_InsdDoB = sqlCmd.Parameters.Add("@PI_InsdDoB", SqlDbType.VarChar, 50); PI_InsdDoB.Value = pInsDetails.InsuredDOB; SqlParameter PI_InsdSSN = sqlCmd.Parameters.Add("@PI_InsdSSN", SqlDbType.VarChar, 50); PI_InsdSSN.Value = pInsDetails.InsuredSSN; SqlParameter PI_InsdRel = sqlCmd.Parameters.Add("@PI_InsdRel", SqlDbType.VarChar, 50); PI_InsdRel.Value = pInsDetails.InsuredRelation; SqlParameter PI_ActiveFlagYN = sqlCmd.Parameters.Add("@PI_ActiveFlagYN", SqlDbType.Char, 1); PI_ActiveFlagYN.Value = pInsDetails.IsActive; SqlParameter IsPrimaryIns = sqlCmd.Parameters.Add("@IsPrimaryIns", SqlDbType.Char, 1); IsPrimaryIns.Value = pInsDetails.IsPrimaryIns; SqlParameter PI_InsPhone = sqlCmd.Parameters.Add("@PI_InsPhone", SqlDbType.VarChar, 25); PI_InsPhone.Value = pInsDetails.InsPhone; sqlCon.Open(); sqlCmd.ExecuteNonQuery(); objNLog.Info("Insurance Updated Successfully..."); objNLog.Info("<sp_Update_Pat_Ins>Stored Procedure Executed Successfully..."); successFlag = true; objUALog.LogUserActivity(conStr, userID, "Updated Patient Insurance Info", "Patient_Ins",patID); } catch (SqlException SqlEx) { objNLog.Error("SQLException : " + SqlEx.Message); throw new Exception("Exception re-Raised from DL with SQLError# " + SqlEx.Number + " while Updating Patient Insurance.", SqlEx); } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); throw new Exception("**Error occured while Updating Patient Insurance.", ex); } finally { sqlCon.Close(); objNLog.Info("Finally Block: " + successFlag); } objNLog.Info("Status: " + successFlag); objNLog.Info("Function Terminated..."); }
public PatientInsuranceDetails UpdatePatientInsuranceData(int id, PatientInsuranceDetails patientInfo) { return(_patientCommonRepository.UpdatePatientInsuranceData(id, patientInfo)); }
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 string getInsuranceName(PatientInsuranceDetails Pat_Ins_Details) { SqlConnection con = new SqlConnection(ConStr); SqlCommand sqlCmd = new SqlCommand("select Ins_Name from Insurance_Info where Ins_ID = '" + Pat_Ins_Details.InsuranceID + "'", con); // SqlDataReader sqlDr; // DataTable dtable = new DataTable(); // DataRow dr; con.Open(); string InsuranceName = sqlCmd.ExecuteScalar().ToString(); con.Close(); return InsuranceName; }
public int getInsuranceID(PatientInsuranceDetails Pat_Ins_Details) { SqlConnection con = new SqlConnection(ConStr); SqlCommand sqlCmd = new SqlCommand("select Ins_ID from Insurance_Info where Ins_Name = '" + Pat_Ins_Details.InsuranceName + "'", con); // SqlDataReader sqlDr; // DataTable dtable = new DataTable(); // DataRow dr; con.Open(); int InsuranceID = Convert.ToInt32( sqlCmd.ExecuteScalar()); con.Close(); return InsuranceID; }