public int Update(gbmodel.physician.TreatingPhysician p_oPhysician, gbmodel.user.User p_oUser) { SqlConnection connection = new SqlConnection(DBUtil.ConnectionString); int result = 0; try { connection.Open(); SqlCommand sqlCommand = new SqlCommand("SP_MST_DOCTOR", connection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@SZ_DOCTOR_ID", p_oPhysician.DoctorID); sqlCommand.Parameters.AddWithValue("@SZ_DOCTOR_NAME", p_oPhysician.DoctorName); sqlCommand.Parameters.AddWithValue("@SZ_DOCTOR_LICENSE_NUMBER", p_oPhysician.LicenseNumber); sqlCommand.Parameters.AddWithValue("@SZ_COMPANY_ID", p_oUser.Account.ID); sqlCommand.Parameters.AddWithValue("@SZ_OFFICE_ID", p_oPhysician.Provider.Id); sqlCommand.Parameters.AddWithValue("@SZ_WCB_AUTHORIZATION", p_oPhysician.WCBAuthorization); sqlCommand.Parameters.AddWithValue("@SZ_WCB_RATING_CODE", p_oPhysician.WCBRatingCode); sqlCommand.Parameters.AddWithValue("@SZ_NPI", p_oPhysician.NPI); sqlCommand.Parameters.AddWithValue("@SZ_FEDERAL_TAX_ID", p_oPhysician.FederalTaxID); sqlCommand.Parameters.AddWithValue("@BIT_TAX_ID_TYPE", p_oPhysician.BitTaxIDType); sqlCommand.Parameters.AddWithValue("@SZ_PROCEDURE_GROUP_ID", p_oPhysician.Specialty.ID); sqlCommand.Parameters.AddWithValue("@SZ_TITLE", p_oPhysician.Title); sqlCommand.Parameters.AddWithValue("@I_IS_EMPLOYEE", p_oPhysician.EmployeeType); sqlCommand.Parameters.AddWithValue("@IS_REFERRAL", p_oPhysician.IsReferral); sqlCommand.Parameters.AddWithValue("@BT_IS_UNBILLED", p_oPhysician.IsUnBilled); sqlCommand.Parameters.AddWithValue("@BT_SUPERVISING_DOCTOR", p_oPhysician.IsSupervisingDoctor); sqlCommand.Parameters.AddWithValue("@FLAG", "UPDATE"); result = sqlCommand.ExecuteNonQuery(); } catch (Exception ex) { } finally { if (connection != null) { if (connection.State == ConnectionState.Open) { connection.Close(); } connection = null; } } return(result); }
public string CheckDoctorVisitExists(gbmodel.physician.TreatingPhysician p_oPhysician, gbmodel.user.User p_oUser) { SqlConnection connection = new SqlConnection(DBUtil.ConnectionString); string result = ""; try { connection.Open(); SqlCommand sqlCommand = new SqlCommand("sp_exists_doctor_visit", connection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@sz_doctor_id", p_oPhysician.DoctorID); sqlCommand.Parameters.AddWithValue("@sz_company_id", p_oUser.Account.ID); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { result = sqlDataReader["RECORD EXISTS"].ToString(); } } catch (Exception ex) { } finally { if (connection != null) { if (connection.State == ConnectionState.Open) { connection.Close(); } connection = null; } } return(result); }