public int GetDenomValueByCode(int code) { int denom = 0; using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "GetDenomValueByCode")) { try { using (ExCommsSQLDataAccess DataContext = this.GetDataContext()) { ExCommsSQLDataAccess.rsp_GetDenomByCodeResult denom_code = DataContext.rsp_GetDenomByCode(code).SingleOrDefault(); if (denom_code != null) { denom = denom_code.Column1; } } } catch (Exception ex) { Log.Exception(ex); } } return(denom); }