示例#1
0
        public static string GetPrimaryCarePhysicianName(string personId)
        {
            string today = DateTime.Today.ToString("yyyy-MM-dd");

            StringBuilder sb = new StringBuilder();

            sb.Append("SELECT  Prsnl_Person_Id, Person_Prsnl_R_Cd ");
            sb.Append("FROM  PERSON_PRSNL_RELTN ");
            sb.Append("WHERE Person_Id = '" + personId + "' ");
            sb.Append("AND Person_Prsnl_R_Cd = '1115.0000' ");
            sb.Append("AND active_ind = '1.0000' ");
            sb.Append("AND end_effective_dt_tm > '" + today + "' ");

            DataTable dt = new DataTable();

            using (var conn = new SqlConnection(GlobalSettings.SqlConnectionString()))
                using (var cmd = new SqlCommand(sb.ToString(), conn))
                    using (var da = new SqlDataAdapter(cmd))
                    {
                        cmd.CommandType = CommandType.Text;
                        da.Fill(dt);
                    }
            string result = string.Empty;

            if (dt.Rows.Count > 0)
            {
                //string physCode = EncntrPrsnlReltnDAL.GetAttendPhysician(dt.Rows[0]["Prsnl_Person_Id"].ToString());

                Provider provider = ProviderDAL.GetProvider(dt.Rows[0]["Prsnl_Person_Id"].ToString());
                result = provider.Name_Last + "," + provider.Name_First + " " + provider.Name_Middle;
            }
            return(result);
        }
示例#2
0
        public static string GetPrimaryCarePhysicianName(string personId)
        {
            DateTime todayDt = DateTime.Today;

            StringBuilder sb = new StringBuilder();

            sb.Append("SELECT  Prsnl_Person_Id, Person_Prsnl_R_Cd ");
            sb.Append("FROM  BAR_PERSON_PRSNL_RELTN ");
            sb.Append("WHERE Person_Id = " + long.Parse(personId) + " ");
            sb.Append("AND Person_Prsnl_R_Cd = '1115' ");
            sb.Append("AND active_ind = '1' ");
            sb.Append("AND END_EFFECTIVE_DT_TM > '" + todayDt + "'");

            DataTable dt = new DataTable();

            using (var conn = new SqlConnection(GlobalSettings.SqlConnectionString()))
                using (var cmd = new SqlCommand(sb.ToString(), conn))
                    using (var da = new SqlDataAdapter(cmd))
                    {
                        cmd.CommandType = CommandType.Text;
                        da.Fill(dt);
                    }
            string result = string.Empty;

            if (dt.Rows.Count > 0)
            {
                //string physCode = EncntrPrsnlReltnDAL.GetAttendPhysician(dt.Rows[0]["Prsnl_Person_Id"].ToString());

                Provider provider = ProviderDAL.GetProvider(dt.Rows[0]["Prsnl_Person_Id"].ToString());
                result = provider.Name_Last + "," + provider.Name_First + " " + provider.Name_Middle;
            }
            dt.Dispose();
            return(result);
        }
示例#3
0
        private static Provider LoadPhysician(DataRow row)
        {
            Provider provider = ProviderDAL.GetProvider(row["prsnl_person_id"].ToString());

            return(provider);
        }