public ActionResult Edit([Bind(Include = "RECORD_ID,DATA_SOURCE_ID,CATALOG_ID,RULE_NAME,POP_QUERY,EXCEPTION_QUERY,DESCRIPTION_RESOLUTION,RUN_SCHEDULE,DIMENSION,SEVERITY,LAST_RUN")] MdmDqRule mdmDqRule) { if (ModelState.IsValid) { db.Entry(mdmDqRule).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DIMENSION = new SelectList(db.MDM_AGGR_DIMENSION, "DIMENSIONID", "DIMENSION_NAME", mdmDqRule.DIMENSION); ViewBag.DATA_SOURCE_ID = new SelectList(db.MdmDQDataSources, "DS_ID", "DS_USERNAME", mdmDqRule.DATA_SOURCE_ID); ViewBag.SEVERITY = new SelectList(db.MdmDQPriorities, "PRIORITY_CODE", "PRIORITY_DESCRIPTION", mdmDqRule.SEVERITY); ViewBag.RUN_SCHEDULE = new SelectList(db.MdmDqRunSchedules, "SCHEDULE_ID", "SCHEDULE_DESCRIPTION", mdmDqRule.RUN_SCHEDULE); ViewBag.CATALOG_ID = new SelectList(db.MdmCatalogs, "CATALOG_ID", "CATALOG_NAME"); return(View(mdmDqRule)); }
//[MultipleButton(Name = "action", Argument = "Preview")] public ActionResult Preview(MdmDqRule mdmDqRule) { if (ModelState.IsValid) { string strMessage = ExecuteSql(HMTLHelperExtensions.HtmlEncode(HttpUtility.HtmlDecode(mdmDqRule.EXCEPTION_QUERY))); if (strMessage != string.Empty) { ModelState.AddModelError("EXCEPTION_QUERY", strMessage); } } ViewBag.DIMENSION = new SelectList(db.MDM_AGGR_DIMENSION, "DIMENSIONID", "DIMENSION_NAME", mdmDqRule.DIMENSION); ViewBag.DATA_SOURCE_ID = new SelectList(db.MdmDQDataSources, "DS_ID", "DS_USERNAME", mdmDqRule.DATA_SOURCE_ID); ViewBag.SEVERITY = new SelectList(db.MdmDQPriorities, "PRIORITY_CODE", "PRIORITY_DESCRIPTION", mdmDqRule.SEVERITY); ViewBag.RUN_SCHEDULE = new SelectList(db.MdmDqRunSchedules, "SCHEDULE_ID", "SCHEDULE_DESCRIPTION", mdmDqRule.RUN_SCHEDULE); ViewBag.CATALOG_ID = new SelectList(db.MdmCatalogs, "CATALOG_ID", "CATALOG_NAME"); return(View("Create", mdmDqRule)); }
// GET: Rules/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MdmDqRule mdmDqRule = db.MdmDqRules.Find(id); if (mdmDqRule == null) { return(HttpNotFound()); } ViewBag.DIMENSION = new SelectList(db.MDM_AGGR_DIMENSION, "DIMENSIONID", "DIMENSION_NAME", mdmDqRule.DIMENSION); ViewBag.DATA_SOURCE_ID = new SelectList(db.MdmDQDataSources, "DS_ID", "DS_USERNAME", mdmDqRule.DATA_SOURCE_ID); ViewBag.SEVERITY = new SelectList(db.MdmDQPriorities, "PRIORITY_CODE", "PRIORITY_DESCRIPTION", mdmDqRule.SEVERITY); ViewBag.RUN_SCHEDULE = new SelectList(db.MdmDqRunSchedules, "SCHEDULE_ID", "SCHEDULE_DESCRIPTION", mdmDqRule.RUN_SCHEDULE); ViewBag.CATALOG_ID = new SelectList(db.MdmCatalogs, "CATALOG_ID", "CATALOG_NAME"); return(View(mdmDqRule)); }
//[MultipleButton(Name = "action", Argument = "Create")] public ActionResult Create([Bind(Include = "RECORD_ID,DATA_SOURCE_ID,CATALOG_ID,RULE_NAME,POP_QUERY,EXCEPTION_QUERY,DESCRIPTION_RESOLUTION,RUN_SCHEDULE,DIMENSION,SEVERITY,LAST_RUN")] MdmDqRule mdmDqRule) { if (ModelState.IsValid) { db.MdmDqRules.Add(mdmDqRule); db.SaveChanges(); return(RedirectToAction("Index")); } //var query = eqService.GetQuery(); //ViewBag.QueryJson = query.SaveToDictionary().ToJson(); ViewBag.Message = TempData["Message"]; //return View("EasyQuery"); ViewBag.DIMENSION = new SelectList(db.MDM_AGGR_DIMENSION, "DIMENSIONID", "DIMENSION_NAME", mdmDqRule.DIMENSION); ViewBag.DATA_SOURCE_ID = new SelectList(db.MdmDQDataSources, "DS_ID", "DS_USERNAME", mdmDqRule.DATA_SOURCE_ID); ViewBag.SEVERITY = new SelectList(db.MdmDQPriorities, "PRIORITY_CODE", "PRIORITY_DESCRIPTION", mdmDqRule.SEVERITY); ViewBag.RUN_SCHEDULE = new SelectList(db.MdmDqRunSchedules, "SCHEDULE_ID", "SCHEDULE_DESCRIPTION", mdmDqRule.RUN_SCHEDULE); ViewBag.CATALOG_ID = new SelectList(db.MdmCatalogs, "CATALOG_ID", "CATALOG_NAME"); return(View(mdmDqRule)); }