//public ActionResult Edit(int id, FormCollection collection)
public ActionResult Edit(ReportAdmin model)
{
try
{
if (!ModelState.IsValid)
{
ViewBag.Status = Common.GetSelectList(Common.SelectListType.Inactive);
return(View(model));
}
using (DBManager db = new DBManager())
{
int result;
string procedureName = "CPK.uspReportUpdate";
List <SqlParameter> paraList = new List <SqlParameter>();
paraList.Add(Common.GetParameter("ReportID", DbType.String, model.ReportID, ParameterDirection.Input));
paraList.Add(Common.GetParameter("ReportName", DbType.String, model.ReportName, ParameterDirection.Input));
paraList.Add(Common.GetParameter("ReportPath", DbType.String, model.ReportPath, ParameterDirection.Input));
paraList.Add(Common.GetParameter("Description", DbType.String, model.Description, ParameterDirection.Input));
paraList.Add(Common.GetParameter("IsActive", DbType.String, model.IsActive, ParameterDirection.Input));
result = db.GetExecuteNonQuery(paraList, procedureName);
}
TempData["message"] = "Successfully Updated!";
TempData["messageType"] = "Success"; ViewBag.messageType = "Information";
return(RedirectToAction("List"));
}
catch
{
TempData["message"] = "Error occured while updating!";
TempData["messageType"] = "Error";
return(RedirectToAction("List"));
}
}
public ActionResult Details(int id)
{
ReportAdmin reportAdmin = null;
using (DBManager db = new DBManager())
{
string procedureName = "CPK.uspReportDetail";
List <SqlParameter> paraList = new List <SqlParameter>();
paraList.Add(Common.GetParameter("ReportID", DbType.String, id, ParameterDirection.Input));
DataSet DbSet = db.GetSelectQuery(paraList, procedureName);
reportAdmin = Common.DataToClass <ReportAdmin>(DbSet.Tables[0].Rows[0]);
}
return(View(reportAdmin));
}
