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));
}
