public ActionResult AcceptanceCriteria() { DAL.DAL dal = new DAL.DAL(); string strCommand = "SELECT RISK_CRITERIA, UPDATE_DATE, UPDATE_BY FROM RISK_THRESHOLD"; ModelAcceptanceCriteria result = dal.ReadData(strCommand, x => new ModelAcceptanceCriteria(x)).FirstOrDefault(); result.PreviousUrl = System.Web.HttpContext.Current.Request.UrlReferrer.ToString() ?? Url.Action("Index"); return(View(result)); }
public ActionResult AcceptanceCriteria(ModelAcceptanceCriteria model) { if (ModelState.IsValid) { model.UPDATE_BY = User.Identity.Name; DtoRisk dto = new DtoRisk(); dto.UpdateAcceptanceCriteria(model); dto = null; TempData["status"] = "successfully"; TempData["PreviousUrl"] = model.PreviousUrl; return(RedirectToAction("AcceptanceCriteria")); } return(View()); }
public void UpdateAcceptanceCriteria(ModelAcceptanceCriteria model) { if (model == null) { return; } string strCommand = "UPDATE RISK_THRESHOLD SET " + "RISK_CRITERIA = '{0}'," + "UPDATE_DATE = sysdate," + "UPDATE_BY = '{1}'"; strCommand = string.Format( strCommand, model.RISK_CRITERIA, model.UPDATE_BY); var dal = new DAL.DAL(); dal.ExecuteNonQuery(strCommand); dal = null; }