public ActionResult GetPageDetails(string PageName) { mPage pageDetails = new mPage(); try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ERPReports"].ConnectionString.ToString())) { conn.Open(); using (SqlCommand cmdSql = conn.CreateCommand()) { cmdSql.CommandType = CommandType.StoredProcedure; cmdSql.CommandText = "spPage_GetPageDetails"; cmdSql.Parameters.AddWithValue("@PageName", PageName); using (SqlDataReader sdr = cmdSql.ExecuteReader()) { if (!sdr.Read()) { throw new InvalidOperationException("No records found."); } pageDetails.ID = Convert.ToInt32(sdr["ID"]); pageDetails.GroupLabel = sdr["GroupLabel"].ToString(); pageDetails.PageName = sdr["PageName"].ToString(); pageDetails.PageLabel = sdr["PageLabel"].ToString(); pageDetails.URL = sdr["URL"].ToString(); pageDetails.HasSub = Convert.ToInt32(sdr["HasSub"]); pageDetails.ParentMenu = sdr["ParentMenu"].ToString(); pageDetails.ParentOrder = Convert.ToInt32(sdr["ParentOrder"]); pageDetails.Order = Convert.ToInt32(sdr["Order"]); pageDetails.Icon = sdr["Icon"].ToString(); } } conn.Close(); } } catch (Exception err) { string errmsg; if (err.InnerException != null) { errmsg = "Error: " + err.InnerException.ToString(); } else { errmsg = "Error: " + err.Message.ToString(); } return(Json(new { success = false, errors = errmsg }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = true, data = new { pageDetails = pageDetails } }, JsonRequestBehavior.AllowGet)); }
public ActionResult SavePage(mPage Page) { string endMsg = ""; ModelState.Remove("ID"); if (ModelState.IsValid) { try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ERPReports"].ToString())) { conn.Open(); using (SqlCommand cmdSql = conn.CreateCommand()) { cmdSql.CommandType = CommandType.StoredProcedure; cmdSql.CommandText = "spPage_InsertUpdate"; cmdSql.Parameters.Clear(); cmdSql.Parameters.AddWithValue("@ID", Page.ID); cmdSql.Parameters.AddWithValue("@GroupLabel", Page.GroupLabel == null ? "" : Page.GroupLabel); cmdSql.Parameters.AddWithValue("@PageName", Page.PageName); cmdSql.Parameters.AddWithValue("@PageLabel", Page.PageLabel); cmdSql.Parameters.AddWithValue("@URL", Page.URL); cmdSql.Parameters.AddWithValue("@HasSub", Page.HasSub); cmdSql.Parameters.AddWithValue("@ParentMenu", Page.ParentMenu); cmdSql.Parameters.AddWithValue("@ParentOrder", Page.ParentOrder); cmdSql.Parameters.AddWithValue("@Order", Page.Order); cmdSql.Parameters.AddWithValue("@Icon", Page.Icon); cmdSql.Parameters.AddWithValue("@CreateID", Session["UserName"]); SqlParameter EndMsg = cmdSql.Parameters.Add("@EndMsg", SqlDbType.VarChar, 200); SqlParameter ErrorMessage = cmdSql.Parameters.Add("@ErrorMessage", SqlDbType.VarChar, 200); SqlParameter Error = cmdSql.Parameters.Add("@IsError", SqlDbType.Bit); EndMsg.Direction = ParameterDirection.Output; Error.Direction = ParameterDirection.Output; ErrorMessage.Direction = ParameterDirection.Output; cmdSql.ExecuteNonQuery(); error = Convert.ToBoolean(Error.Value); if (error) { modelErrors.Add(ErrorMessage.Value.ToString()); } endMsg = EndMsg.Value.ToString(); } conn.Close(); } } catch (Exception err) { string errmsg; if (err.InnerException != null) { errmsg = "Error: " + err.InnerException.ToString(); } else { errmsg = "Error: " + err.Message.ToString(); } return(Json(new { success = false, errors = errmsg }, JsonRequestBehavior.AllowGet)); } } else { foreach (var modelStateKey in ViewData.ModelState.Keys) { var modelStateVal = ViewData.ModelState[modelStateKey]; foreach (var error in modelStateVal.Errors) { var key = modelStateKey; var errMessage = error.ErrorMessage; var exception = error.Exception; modelErrors.Add(errMessage); } } } if (modelErrors.Count != 0 || error) { return(Json(new { success = false, errors = modelErrors })); } else { return(Json(new { success = true, msg = "Page was successfully " + endMsg })); } }