Exemplo n.º 1
0
        //mainMenu
        public void insertUpdateMainMenu(string DataTitle, VD_MainMenu mainMenu, ref string outputMsg, ref long outputResult)
        {
            SqlCommand command = this.DataManager.CreateCommand(DataTitle, CommandType.StoredProcedure);

            DataManager.AddParameterWithValue(command, "@MainMenuID", mainMenu.MainMenuID);
            DataManager.AddParameterWithValue(command, "@MainMenuName", mainMenu.MainMenuName);
            DataManager.AddParameterWithValue(command, "@IsActive", mainMenu.IsActive);
            DataManager.AddParameterWithValue(command, "@zIndex", mainMenu.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;
            }
        }
Exemplo n.º 2
0
        public ResultResponse insertUpdateMainMenu(VD_MainMenu _mainMenu)
        {
            string _Msg    = string.Empty;
            long   _Result = 0;

            _rr       = new ResultResponse();
            _DBAccess = new DBController();
            _DBAccess.insertUpdateMainMenu("WEB_VD_INSERT_UPDATE_MAINMENU", _mainMenu, ref _Msg, ref _Result);
            _rr.Msg    = _Msg;
            _rr.Result = _Result;

            return(_rr);
        }
Exemplo n.º 3
0
        public VD_MainMenu getDetailsMainMenu(string ID)
        {
            VD_MainMenu       info   = new VD_MainMenu();
            List <VD_SubMenu> lstSub = new List <VD_SubMenu>();

            _DBAccess = new DBController();
            DataSet ds = new DataSet();

            ds = _DBAccess.GetEntityDetails("WEB_VD_GET_DETAILS_MAINMENU", ID);
            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.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"]);
                }
                if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
                {
                    foreach (DataRow row in ds.Tables[1].Rows)
                    {
                        lstSub.Add(new VD_SubMenu
                        {
                            ID                = Convert.ToInt64(row["ID"]),
                            MainMenuID        = Convert.ToString(row["MainMenuID"]),
                            MainMenuName      = Convert.ToString(ds.Tables[0].Rows[0]["MainMenuName"]),
                            SubMenuID         = Convert.ToString(row["SubMenuID"]),
                            SubMenuName       = Convert.ToString(row["SubMenuName"]),
                            MetaTitleMainMenu = Convert.ToString(row["MetaTitleMainMenu"]),
                            MetaDescription   = Convert.ToString(row["MetaDescription"]),
                            MetaKeywords      = Convert.ToString(row["MetaKeywords"]),
                            MetaTitle         = Convert.ToString(row["MetaTitle"]),
                            IsActive          = Convert.ToBoolean(row["IsActive"]),
                            zIndex            = Convert.ToInt32(row["zIndex"])
                        });
                    }
                }
            }

            info.lstSubMenu = lstSub;

            return(info);
        }
Exemplo n.º 4
0
 public ActionResult InsertUpdateMainmenu(VD_MainMenu mainMenu)
 {
     _rr = new ResultResponse();
     return(Json(_rr));
 }
Exemplo n.º 5
0
 public void insertUpdateMainMenu(string DataTitle, VD_MainMenu mainMenu, ref string outputMsg, ref long outputResult)
 {
     _DB.insertUpdateMainMenu(DataTitle, mainMenu, ref outputMsg, ref outputResult);
 }