public JsonResult UpdateActive()
        {
            try
            {
                CertificateCategoryQuery query = new CertificateCategoryQuery();
                if (!string.IsNullOrEmpty(Request.Params["id"]))
                {
                    query.rowID = Convert.ToInt32(Request.Params["id"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["active"]))
                {
                    query.status = Convert.ToInt32(Request.Params["active"]);
                }
                _inspectionReport = new InspectionReportMgr(mySqlConnectionString);
                int res = _inspectionReport.UpdateActive(query);
                if (res > 0)
                {
                    return Json(new { success = "true", msg = "" });
                }
                else
                {
                    return Json(new { success = "false", msg = "" });
                }
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
                return Json(new { success = "false", msg = "" });
            }

        }