public static string GetPrsnlAliasLic(string personId)
{
string returnval = "";
DateTime todayDt = DateTime.Today;
StringBuilder sb = new StringBuilder();
sb.Append("SELECT prsnl_alias_type_cd, alias_pool_Cd, alias ");
sb.Append("FROM BAR_PRSNL_ALIAS ");
sb.Append("WHERE person_id = " + long.Parse(personId) + " ");
sb.Append("AND alias_pool_cd = '275985665' ");
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);
}
List <Prsnl_Alias> aliases = new List <Prsnl_Alias>();
foreach (DataRow row in dt.Rows)
{
Prsnl_Alias pa = LoadPrsnlAlias(row);
//aliases.Add(pa);
returnval = pa.Alias;
break;
}
dt.Dispose();
return(returnval);
}
private static Prsnl_Alias LoadPrsnlAlias(DataRow row)
{
Prsnl_Alias alias = new Prsnl_Alias();
alias.Aleas_Pool = CodeValueDAL.GetCodeValueDisplay(row["alias_pool_Cd"].ToString());
alias.Alias_Type = CodeValueDAL.GetCodeValueDisplay(row["prsnl_alias_type_cd"].ToString());
alias.Alias = row["alias"].ToString();
return(alias);
}
