public static string GetTypeNameByCode(string type) { var rows = LookupTypeTable.AsEnumerable().Where(p => p.Field <string>("LOOKUP_CODE") == type).ToList(); if (rows != null && rows.Count() > 0) { return(rows[0]["LOOKUP_NAME"].ToString()); } return(""); }
public static DataTable GetLookupTypesByCode(string code) { var rows = LookupTypeTable.AsEnumerable().Where(p => p.Field <string>("APP_CODE") == code); DataTable dt = new DataTable(); dt.Columns.Add("LOOKUP_CODE"); dt.Columns.Add("LOOKUP_NAME"); if (rows != null && rows.Count() > 0) { foreach (var row in rows) { DataRow dr = dt.NewRow(); dr["LOOKUP_CODE"] = row["LOOKUP_CODE"]; dr["LOOKUP_NAME"] = row["LOOKUP_NAME"]; dt.Rows.Add(dr); } } return(dt); }