/// <summary> /// fetches different kinds of lookups /// </summary> /// <param name="t"></param> /// <param name="Id"></param> /// <param name="search"></param> /// <returns></returns> public static DataTable RetrieveLookup(dbTable t, int Id = 0, String search = "") { List <parmStructure> lstParms = new List <parmStructure>(); String sp = ""; switch (t) { case dbTable.employee: if (Id != 0) { lstParms.Add(new parmStructure("@id", Id, ParameterDirection.Input, SqlDbType.Int)); } else if (search != "") { lstParms.Add(new parmStructure("@search", search, ParameterDirection.Input, SqlDbType.VarChar, 50)); } sp = "EmployeeLookup"; break; case dbTable.department: sp = "DepartmentLookup"; break; case dbTable.job: sp = "JobLookup"; break; default: throw new Exception("There was an error at the SQL layer"); } return(DataAccess.GetData(sp, lstParms)); }
/// <summary> /// creates a look up from a database table /// </summary> /// <param name="t"></param> /// <returns></returns> public static List <Lookup> Create(dbTable t) { DataTable dt = EmployeeSQL.Retrieve(t); return(RePackage(dt)); }