public IEnumerable <UspSiteSelectReturnModel.ResultSetModel1> GetSiteById(int siteId) { UspSiteSelectReturnModel uspsiteselect_result; using (var db = new DBAMPContext()) { try { uspsiteselect_result = db.UspSiteSelect(siteId); } catch (Exception ex) { string sqlParam = "UspSiteSelect(" + siteId + ")"; string methodName = "JCRAPI/Business/SiteServices/GetSiteById"; exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteId, sqlParam, string.Empty); return(null); } } return(uspsiteselect_result.ResultSet1); }