Exemplo n.º 1
0
        public List <AuditLogReport_VM> GetEntityDetails(AuditLogReport_VM Model)
        {
            var query = new List <AuditLogReport_VM>();

            try
            {
                using (var db = new DBConnection())
                {
                    var ds = db.ExecuteDataSet("GetEntityDetails", new SqlParameter[] {
                        new SqlParameter("@p_AuditLogID", GetDBNULL(Model.AuditLogID)),

                        new SqlParameter("@p_LanguageCode", GetDBNULLString(Model.CurrentLanguageCode)),
                        new SqlParameter("@p_UTCOffset", GetDBNULL(Model.CurrentUTCOffset, true)),
                        new SqlParameter("@p_EndUserID", GetDBNULL(Model.EndUserID, true)),
                        new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID, true)),
                        new SqlParameter("@p_ScreenID", GetDBNULL(Model.ScreenID, true)),
                        new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoints))
                    });

                    query = ConvertToList <AuditLogReport_VM>(ds.Tables[0]);
                }
            }
            catch (Exception ex)
            {
                logger.Error("AuditLogRepository_GetEntityDetails Error: ", ex);
                throw;
            }

            return(query);
        }
Exemplo n.º 2
0
 public JsonResult GetEntityDetails(AuditLogReport_VM Model)
 {
     try
     {
         GetUserInfo(Model);
         List <AuditLogReport_VM> vm = _AuditLogsReportRepo.GetEntityDetails(Model);
         return(GetDataResponse(vm));
     }
     catch (Exception ex)
     {
         return(GetDataResponseException(ex));
     }
 }