public async Task <IActionResult> DeleteConfirmed(string submitbutton, string singarea_state, [Bind("Id", "AreaNo, AreaNa, AreaEn")] Singarea singarea)
        {
            if (!LoginUtil.CheckIfLoggedIn(HttpContext))
            {
                return(View(nameof(Index)));
            }

            StateOfRequest mState;

            if (string.IsNullOrEmpty(singarea_state))
            {
                mState = new StateOfRequest("AreaNo");
            }
            else
            {
                mState = JsonUtil.GetObjectFromJsonString <StateOfRequest>(singarea_state);
            }
            mState.StartTime = DateTime.Now;
            string temp_state = JsonUtil.SetJsonStringFromObject(mState);

            int    orgId   = mState.OrgId;
            string sButton = submitbutton.ToUpper();

            if (sButton == "CANCEL")
            {
                temp_state = JsonUtil.SetJsonStringFromObject(mState);
                return(RedirectToAction(nameof(SingareasList), new { singarea_state = temp_state }));
            }

            if (ModelState.IsValid)
            {
                // start deleting the singarea from table
                int result = await _singareasManager.DeleteOneSingareaById(orgId);

                if (result == ErrorCodeModel.Succeeded)
                {
                    // succeeded to delete a singarea
                    List <Singarea> singareasTemp = _singareasManager.GetOnePageOfSingareas(mState);
                    temp_state            = JsonUtil.SetJsonStringFromObject(mState);
                    ViewBag.SingareaState = temp_state;

                    return(View(nameof(SingareasList), singareasTemp));
                }
                else
                {
                    ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(result);
                }
            }
            else
            {
                // Model.IsValid = false
                ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(ErrorCodeModel.ModelBindingFailed);
            }

            // failed
            ViewBag.SingareaState = temp_state;
            return(View(singarea));
        }
        public async Task <IActionResult> Edit(string submitbutton, string language_state, [Bind("Id", "LangNo, LangNa, LangEn")] Language language)
        {
            if (!LoginUtil.CheckIfLoggedIn(HttpContext))
            {
                return(View(nameof(Index)));
            }

            StateOfRequest mState;

            if (string.IsNullOrEmpty(language_state))
            {
                mState = new StateOfRequest("LangNo");
            }
            else
            {
                mState = JsonUtil.GetObjectFromJsonString <StateOfRequest>(language_state);
            }
            mState.StartTime = DateTime.Now;
            string temp_state = JsonUtil.SetJsonStringFromObject(mState);

            int    orgId   = mState.OrgId; // = language.Id
            string sButton = submitbutton.ToUpper();

            if (sButton == "CANCEL")
            {
                temp_state = JsonUtil.SetJsonStringFromObject(mState);
                return(RedirectToAction(nameof(LanguagesList), new { language_state = temp_state }));
            }
            if (ModelState.IsValid)
            {
                // start updating table
                int result = await _languagesManager.UpdateOneLanguageById(orgId, language);

                if (result == ErrorCodeModel.Succeeded)
                {
                    // succeeded to update
                    Language        newLanguage   = new Language();
                    List <Language> languagesTemp = _languagesManager.FindOnePageOfLanguagesForOneLanguage(mState, newLanguage, orgId);
                    temp_state = JsonUtil.SetJsonStringFromObject(mState);

                    ViewBag.LanguageState = temp_state;
                    return(View(nameof(LanguagesList), languagesTemp));
                }
                else
                {
                    ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(result);
                }
            }
            else
            {
                // Model.IsValid = false
                ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(ErrorCodeModel.ModelBindingFailed);
            }

            ViewBag.LanguageState = temp_state;
            return(View(language));
        }
        public async Task <IActionResult> Add(string submitbutton, string singarea_state, [Bind("Id", "AreaNo, AreaNa,AreaEn")] Singarea singarea)
        {
            if (!LoginUtil.CheckIfLoggedIn(HttpContext))
            {
                return(View(nameof(Index)));
            }

            StateOfRequest mState;

            if (string.IsNullOrEmpty(singarea_state))
            {
                mState = new StateOfRequest("AreaNo");
            }
            else
            {
                mState = JsonUtil.GetObjectFromJsonString <StateOfRequest>(singarea_state);
            }
            mState.StartTime = DateTime.Now;
            string temp_state = JsonUtil.SetJsonStringFromObject(mState);

            int    orgId   = mState.OrgId;
            string sButton = submitbutton.ToUpper();

            if (sButton == "CANCEL")
            {
                Singarea        newSingarea   = new Singarea();
                List <Singarea> singareasTemp = _singareasManager.FindOnePageOfSingareasForOneSingarea(mState, newSingarea, orgId);
                mState.IsFirstAddRecord = true;
                temp_state            = JsonUtil.SetJsonStringFromObject(mState);
                ViewBag.SingareaState = temp_state;

                return(View(nameof(SingareasList), singareasTemp));
            }
            if (ModelState.IsValid)
            {
                int result = await _singareasManager.AddOneSingareaToTable(singarea);

                if (result == ErrorCodeModel.Succeeded)
                {
                    // succeeded to add the singarea
                    mState.OrgId            = singarea.Id;
                    mState.OrgNo            = singarea.AreaNo;
                    mState.IsFirstAddRecord = false;
                    temp_state = JsonUtil.SetJsonStringFromObject(mState);

                    return(RedirectToAction(nameof(Add), new { singarea_state = temp_state }));
                }
                else
                {
                    ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(result);
                }
            }
            else
            {
                // Model.IsValid = false
                ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(ErrorCodeModel.ModelBindingFailed);
            }

            ViewBag.SingareaState = temp_state;
            return(View(singarea));
        }
        public async Task <IActionResult> Edit(string submitbutton, string singer_state, [Bind("Id", "SingNo, SingNa, NumFw, NumPw, Sex, Chor, Hot, AreaId, PicFile")] Singer singer)
        {
            if (!LoginUtil.CheckIfLoggedIn(HttpContext))
            {
                return(View(nameof(Index)));
            }

            StateOfRequest mState;

            if (string.IsNullOrEmpty(singer_state))
            {
                mState = new StateOfRequest("SingNo");
            }
            else
            {
                mState = JsonUtil.GetObjectFromJsonString <StateOfRequest>(singer_state);
            }
            mState.StartTime = DateTime.Now;
            string temp_state = JsonUtil.SetJsonStringFromObject(mState);

            int    orgId   = mState.OrgId; // = singer.Id
            string sButton = submitbutton.ToUpper();

            if (sButton == "CANCEL")
            {
                temp_state = JsonUtil.SetJsonStringFromObject(mState);
                return(RedirectToAction(nameof(SingersList), new { singer_state = temp_state }));
            }
            if (ModelState.IsValid)
            {
                // start updating table
                int result = await _singersManager.UpdateOneSingerById(orgId, singer);

                if (result == ErrorCodeModel.Succeeded)
                {
                    // succeeded to update
                    Singer        newSinger   = new Singer();
                    List <Singer> singersTemp = _singersManager.FindOnePageOfSingersForOneSinger(mState, newSinger, orgId);
                    temp_state = JsonUtil.SetJsonStringFromObject(mState);

                    ViewBag.SingerState = temp_state;
                    return(View(nameof(SingersList), singersTemp));
                }
                else
                {
                    ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(result);
                }
            }
            else
            {
                // Model.IsValid = false
                ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(ErrorCodeModel.ModelBindingFailed);
            }

            List <SelectListItem> singareaSelectList = _singareasManager.GetSelectListOfSingareas(new StateOfRequest("AreaNa"));

            ViewBag.SingareaList = singareaSelectList;
            ViewBag.SingerState  = temp_state;

            return(View(singer));
        }
        public async Task <IActionResult> DeleteConfirmed(string submitbutton, string song_state, [Bind("Id", "SongNo,SongNa,SNumWord,NumFw,NumPw,Chor,NMpeg,MMpeg,VodYn,VodNo,Pathname,InDate,LanguageId,Singer1Id,Singer2Id")] Song song)
        {
            if (!LoginUtil.CheckIfLoggedIn(HttpContext))
            {
                return(View(nameof(Index)));
            }

            StateOfRequest mState;

            if (string.IsNullOrEmpty(song_state))
            {
                mState = new StateOfRequest("SongNo");
            }
            else
            {
                mState = JsonUtil.GetObjectFromJsonString <StateOfRequest>(song_state);
            }
            mState.StartTime = DateTime.Now;
            string temp_state = JsonUtil.SetJsonStringFromObject(mState);

            int    orgId   = mState.OrgId;
            string sButton = submitbutton.ToUpper();

            if (sButton == "CANCEL")
            {
                temp_state = JsonUtil.SetJsonStringFromObject(mState);
                return(RedirectToAction(nameof(SongsList), new { song_state = temp_state }));
            }

            if (ModelState.IsValid)
            {
                // start deleting the song from table
                int result = await _songsManager.DeleteOneSongById(orgId);

                if (result == ErrorCodeModel.Succeeded)
                {
                    // succeeded to delete a song
                    List <Song> songsTemp = _songsManager.GetOnePageOfSongs(mState);
                    temp_state        = JsonUtil.SetJsonStringFromObject(mState);
                    ViewBag.SongState = temp_state;

                    return(View(nameof(SongsList), songsTemp));
                }
                else
                {
                    ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(result);
                }
            }
            else
            {
                // Model.IsValid = false
                ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(ErrorCodeModel.ModelBindingFailed);
            }

            // failed
            List <SelectListItem> languageSelectList = _languagesManager.GetSelectListOfLanguages(new StateOfRequest("LangNa"));
            List <SelectListItem> singerSelectList   = _singersManager.GetSelectListOfSingers(new StateOfRequest("SingNa"));

            ViewBag.LanguageList = languageSelectList;
            ViewBag.SingerList   = singerSelectList;
            ViewBag.SongState    = temp_state;

            return(View(song));
        }