public ActionResult EditMenuMaster(int iMenuId)
{
MenuMasterBAL objMenuMasterBAL = new MenuMasterBAL();
MenuMasterBO objMenuMasterBO = objMenuMasterBAL.EditMenuMaster(iMenuId);
return(PartialView("AddMenu", objMenuMasterBO));
}
public ActionResult ViewMenuMaster(int iMenuId)
{
MenuMasterBAL objMenuMasterBAL = new MenuMasterBAL();
MenuMasterBO objMenuMasterBO = objMenuMasterBAL.ViewMenuMaster(iMenuId);
return(PartialView("ViewMenuMaster", objMenuMasterBO));
}
public List <MenuMasterBO> getMenuList()
{
DataSet objDataSet = null;
MenuMasterBO objMenuMasterBO = null;
List <MenuMasterBO> objMenuMasterBOList = new List <MenuMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDbAcess.execuitDataSet(ProcGetMenuList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objMenuMasterBO = new MenuMasterBO();
objMenuMasterBO.MenuId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objMenuMasterBO.MenuName = objDataSet.Tables[0].Rows[i][1].ToString();
objMenuMasterBO.DisplayOrder = Convert.ToInt32(objDataSet.Tables[0].Rows[i][2].ToString());
objMenuMasterBO.MenuKey = objDataSet.Tables[0].Rows[i][3].ToString();
objMenuMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][4].ToString());
objMenuMasterBO.CreatedOn = objDataSet.Tables[0].Rows[i][5].ToString();
objMenuMasterBOList.Add(objMenuMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getMenuList");
throw ex;
}
return(objMenuMasterBOList);
}
public JsonResult saveMenuMaster(MenuMasterBO Data)
{
MenuMasterBAL objMenuMasterBAL = new MenuMasterBAL();
Data.IsActive = true;
string strResult = objMenuMasterBAL.SaveorUpdateMenuMaster(Data, Convert.ToInt32(ViewData["LoginUserId"]));
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
ViewBag.MainTitle = "MenuMaster";
ViewBag.Title = "My Pages";
ViewBag.Icon = "fa fa-user";
MenuMasterBO objMenuMasterBO = new MenuMasterBO();
return(View(objMenuMasterBO));
}
public ActionResult CreateMenu()
{
ViewBag.MainTitle = "Menu Master";
ViewBag.Title = "Menu";
ViewBag.ControllerName = "Menu Master";
ViewBag.Icon = "fa fa-align Justify";
MenuMasterBO objMenuMasterBO = new MenuMasterBO();
return(PartialView("AddMenu", objMenuMasterBO));
}
public MenuMasterBO ViewMenuMaster(int iMenuId)
{
DataSet objDataSet = null;
MenuMasterBO objMenuMasterBO = null;
List <ProcParameterBO> ObjProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iMenuId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iMenuId;
ObjProcParameterBOList.Add(objDbParameter);
objDataSet = objDbAcess.execuitDataSet(ProcViewMenuMaster, ref ObjProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objMenuMasterBO = new MenuMasterBO();
objMenuMasterBO.MenuId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objMenuMasterBO.MenuName = objDataSet.Tables[0].Rows[0][1].ToString();
objMenuMasterBO.ParentMenuId = objDataSet.Tables[0].Rows[0][2].ToString();
objMenuMasterBO.DisplayOrder = Convert.ToInt32(objDataSet.Tables[0].Rows[0][3].ToString());
objMenuMasterBO.PageURL = objDataSet.Tables[0].Rows[0][4].ToString();
objMenuMasterBO.ImageURL = objDataSet.Tables[0].Rows[0][5].ToString();
objMenuMasterBO.MenuGroupId = objDataSet.Tables[0].Rows[0][6].ToString();
objMenuMasterBO.MenuKey = objDataSet.Tables[0].Rows[0][7].ToString();
objMenuMasterBO.faIcon = objDataSet.Tables[0].Rows[0][8].ToString();
objMenuMasterBO.HelpURL = objDataSet.Tables[0].Rows[0][9].ToString();
objMenuMasterBO.HelpDocURL = objDataSet.Tables[0].Rows[0][10].ToString();
objMenuMasterBO.LocalVideo = objDataSet.Tables[0].Rows[0][11].ToString();
objMenuMasterBO.LocalDocument = objDataSet.Tables[0].Rows[0][12].ToString();
objMenuMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][13].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "ViewMenuMaster");
throw ex;
}
return(objMenuMasterBO);
}
public string SaveorUpdateMenuMaster(MenuMasterBO objMenuMasterBO, int iUserId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
string strResult = "";
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iMenuId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objMenuMasterBO.MenuId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strMenuName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objMenuMasterBO.MenuName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iParentMenuId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objMenuMasterBO.ParentMenuId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iDisplayOrder";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objMenuMasterBO.DisplayOrder;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strPageURL";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objMenuMasterBO.PageURL;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strImageURL";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objMenuMasterBO.ImageURL;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iMenuGroupId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objMenuMasterBO.MenuGroupId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strMenuKey";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objMenuMasterBO.MenuKey;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strfaIcon";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objMenuMasterBO.faIcon;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strHelpURL";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objMenuMasterBO.HelpURL;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strHelpDocURL";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objMenuMasterBO.HelpDocURL;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strLocalVideo";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objMenuMasterBO.LocalVideo;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strLocalDocument";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objMenuMasterBO.LocalDocument;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@bIsActive";
objDBparameter.dbType = DbType.Boolean;
objDBparameter.ParameterValue = objMenuMasterBO.IsActive;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iUserId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDbAcess.executeNonQuery(ProcSaveMenu, ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "SaveorUpdateMenuMaster");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public string SaveorUpdateMenuMaster(MenuMasterBO objMenuMasterBO, int iUserId)
{
return(objMenuMasterDAL.SaveorUpdateMenuMaster(objMenuMasterBO, iUserId));
}
