public static string GetLookupNameByValue(string type, string value)
{
var rows = LookupTable.AsEnumerable().Where(p => p.Field <string>("LOOKUP_CODE_LINE") == type && p.Field <string>("LOOKUP_VALUE") == value).ToList();
if (rows != null && rows.Count() > 0)
{
return(rows[0]["LOOKUP_VALUE_NAME"].ToString());
}
return("");
}
public static DataTable GetLookupValuesByType(string type)
{
var rows = LookupTable.AsEnumerable().Where(p => p.Field <string>("LOOKUP_CODE_LINE") == type);
DataTable dt = new DataTable();
dt.Columns.Add("LOOKUP_VALUE");
dt.Columns.Add("LOOKUP_VALUE_NAME");
if (rows != null && rows.Count() > 0)
{
foreach (var row in rows)
{
DataRow dr = dt.NewRow();
dr["LOOKUP_VALUE"] = row["LOOKUP_VALUE"];
dr["LOOKUP_VALUE_NAME"] = row["LOOKUP_VALUE_NAME"];
dt.Rows.Add(dr);
}
}
return(dt);
}
