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