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