//subMenu public void insertUpdateSubMenu(string DataTitle, VD_SubMenu subMenu, ref string outputMsg, ref long outputResult) { SqlCommand command = this.DataManager.CreateCommand(DataTitle, CommandType.StoredProcedure); DataManager.AddParameterWithValue(command, "@MainMenuID", subMenu.MainMenuID); DataManager.AddParameterWithValue(command, "@SubMenuID", subMenu.SubMenuID); DataManager.AddParameterWithValue(command, "@SubMenuName", subMenu.SubMenuName); DataManager.AddParameterWithValue(command, "@IsActive", subMenu.IsActive); DataManager.AddParameterWithValue(command, "@zIndex", subMenu.zIndex); SqlParameter paramOutputMsg = new SqlParameter("@outputMsg", SqlDbType.NVarChar, 1000); paramOutputMsg.Direction = ParameterDirection.Output; DataManager.AddParameter(command, paramOutputMsg); SqlParameter paramOutputResult = new SqlParameter("@outputResult", SqlDbType.BigInt); paramOutputResult.Direction = ParameterDirection.Output; DataManager.AddParameter(command, paramOutputResult); DataManager.ExecuteNonQuery(command); if (paramOutputResult.Value != null) { outputResult = (long)paramOutputResult.Value; outputMsg = paramOutputMsg.Value.ToString(); } else { outputResult = -1; outputMsg = string.Empty; } }
public VD_SubMenu getDetailsSubMenu(string _mainMenuID, string _subID) { VD_SubMenu info = new VD_SubMenu(); _DBAccess = new DBController(); DataSet ds = new DataSet(); ds = _DBAccess.getMainMenuDetails("WEB_VD_GET_DETAILS_SUBMENU", _mainMenuID, _subID); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { info.MainMenuID = Convert.ToString(ds.Tables[0].Rows[0]["MainMenuID"]); info.MainMenuName = Convert.ToString(ds.Tables[0].Rows[0]["MainMenuName"]); info.SubMenuID = Convert.ToString(ds.Tables[0].Rows[0]["SubMenuID"]); info.SubMenuName = Convert.ToString(ds.Tables[0].Rows[0]["SubMenuName"]); info.MetaTitleMainMenu = Convert.ToString(ds.Tables[0].Rows[0]["MetaTitleMainMenu"]); info.MetaDescription = Convert.ToString(ds.Tables[0].Rows[0]["MetaDescription"]); info.MetaKeywords = Convert.ToString(ds.Tables[0].Rows[0]["MetaKeywords"]); info.MetaTitle = Convert.ToString(ds.Tables[0].Rows[0]["MetaTitle"]); info.IsActive = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsActive"]); info.zIndex = Convert.ToInt32(ds.Tables[0].Rows[0]["zIndex"]); } } return(info); }
public ResultResponse insertUpdateSubMenu(VD_SubMenu _subMenu) { string _Msg = string.Empty; long _Result = 0; _rr = new ResultResponse(); _DBAccess = new DBController(); _DBAccess.insertUpdateSubMenu("WEB_VD_INSERT_UPDATE_SUBMENU", _subMenu, ref _Msg, ref _Result); _rr.Msg = _Msg; _rr.Result = _Result; return(_rr); }
public ActionResult InsertUpdateSubmenu(VD_SubMenu subMenu) { _rr = new ResultResponse(); return(Json(_rr)); }
public void insertUpdateSubMenu(string DataTitle, VD_SubMenu subMenu, ref string outputMsg, ref long outputResult) { _DB.insertUpdateSubMenu(DataTitle, subMenu, ref outputMsg, ref outputResult); }