// GET: Singer/Add // the view of adding singers to Singer table public IActionResult Add(string singer_state) { 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); } if ((mState.IsFirstAddRecord) || (mState.OrgId == 0)) { // the first id of this page became the selected original id // or SateOfRequest.OrgId = 0 mState.OrgId = mState.FirstId; } List <SelectListItem> singareaSelectList = _singareasManager.GetSelectListOfSingareas(new StateOfRequest("AreaNa")); ViewBag.SingareaList = singareaSelectList; mState.StartTime = DateTime.Now; string temp_state = JsonUtil.SetJsonStringFromObject(mState); ViewBag.SingerState = temp_state; // pass the Json string to View Singer singer = new Singer(); // create a new Singer object return(View(singer)); }
public IActionResult SingareasList(string singarea_state) { 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); } List <Singarea> singareas = _singareasManager.GetOnePageOfSingareas(mState); ViewBag.SingareaState = JsonUtil.SetJsonStringFromObject(mState); return(View(singareas)); }
public IActionResult LastPage(string singarea_state) { 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; // mState.CurrentPageNo = Int32.MaxValue / mState.PageSize; // default value for View mState.CurrentPageNo = -1; // present the last page string temp_state = JsonUtil.SetJsonStringFromObject(mState); return(RedirectToAction(nameof(SingareasList), new { singarea_state = temp_state })); }
public IActionResult FirstPage(string singarea_state) { 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.CurrentPageNo = 1; // go to first page mState.StartTime = DateTime.Now; string temp_state = JsonUtil.SetJsonStringFromObject(mState); return(RedirectToAction(nameof(SingareasList), new { singarea_state = temp_state })); }
// GET: Language/Edit/5 public async Task <IActionResult> Edit(string language_state) { 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); } int id = mState.OrgId; Language language = await _languagesManager.FindOneLanguageById(id); if (language == null) { // go to previous view (List view) return(Redirect(HttpContext.Request.Headers["Referer"])); } else { mState.OrgId = language.Id; mState.OrgNo = language.LangNo; string temp_state = JsonUtil.SetJsonStringFromObject(mState); 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 IActionResult Find(string sing_no, string sing_na, string search_type, string submitbutton, string singer_state) { 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); if (string.IsNullOrEmpty(sing_no)) { sing_no = string.Empty; } sing_no = sing_no.Trim(); if (string.IsNullOrEmpty(sing_na)) { sing_na = string.Empty; } sing_na = sing_na.Trim(); string sButton = submitbutton.ToUpper(); if (sButton == "CANCEL") { temp_state = JsonUtil.SetJsonStringFromObject(mState); return(RedirectToAction(nameof(SingersList), new { singer_state = temp_state })); } if (string.IsNullOrEmpty(search_type)) { // search_type not defined return(View()); } string searchType = search_type.Trim(); mState.OrderBy = searchType; Singer singer = new Singer(); // new object singer.SingNo = sing_no; // for order by "SingNo" singer.SingNa = sing_na; // for order by "SingNa" List <Singer> singersTemp = _singersManager.FindOnePageOfSingersForOneSinger(mState, singer, -1); temp_state = JsonUtil.SetJsonStringFromObject(mState); ViewBag.SingerState = temp_state; return(View(nameof(SingersList), singersTemp)); }
public IActionResult ChangeOrder(string singer_state) { 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; // Added on 2018-11-24 // start from first page mState.CurrentPageNo = 1; List <Singer> singersTemp = _singersManager.GetOnePageOfSingers(mState); string temp_state = JsonUtil.SetJsonStringFromObject(mState); ViewBag.SingerState = temp_state; return(View(nameof(SingersList), singersTemp)); // removed on 2018-11-24 /* * int orgId = 0; * if (mState.OrgId == 0) * { * // no singer found or selected in this page * // then use the first singer of this page * orgId = mState.FirstId; * } * else * { * orgId = mState.OrgId; * } * * if (orgId != 0) * { * Singer singer = new Singer(); * List<Singer> singersTemp = _singersManager.FindOnePageOfSingersForOneSinger(mState, singer, orgId); * string temp_state = JsonUtil.SetJsonStringFromObject(mState); * * ViewBag.SingerState = temp_state; * return View(nameof(SingersList), singersTemp); * } * else * { * // return to the previous page * return Redirect(HttpContext.Request.Headers["Referer"]); * } */ }
public async Task <IActionResult> DeleteConfirmed(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; 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 deleting the singer from table int result = await _singersManager.DeleteOneSingerById(orgId); if (result == ErrorCodeModel.Succeeded) { // succeeded to delete a singer List <Singer> singersTemp = _singersManager.GetOnePageOfSingers(mState); 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); } // failed 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)); }
public async Task <IActionResult> Find(string song_no, string vod_no, string song_na, int languageId, string sing_na1, string sing_na2, string search_type, string submitbutton, string song_state) { 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); if (string.IsNullOrEmpty(song_no)) { song_no = string.Empty; } song_no = song_no.Trim(); if (string.IsNullOrEmpty(vod_no)) { vod_no = string.Empty; } vod_no = vod_no.Trim(); if (string.IsNullOrEmpty(song_na)) { song_na = string.Empty; } song_na = song_na.Trim(); string lang_no = ""; if (languageId >= 0) { Language language = await _languagesManager.FindOneLanguageById(languageId); if (language != null) { lang_no = language.LangNo; } } if (string.IsNullOrEmpty(sing_na1)) { sing_na1 = string.Empty; } sing_na1 = sing_na1.Trim(); if (string.IsNullOrEmpty(sing_na2)) { sing_na2 = string.Empty; } sing_na2 = sing_na2.Trim(); string sButton = submitbutton.ToUpper(); if (sButton == "CANCEL") { temp_state = JsonUtil.SetJsonStringFromObject(mState); return(RedirectToAction(nameof(SongsList), new { song_state = temp_state })); } if (string.IsNullOrEmpty(search_type)) { // search_type not defined return(View()); } string searchType = search_type.Trim(); mState.OrderBy = searchType; Song song = new Song(); // new object song.SongNo = song_no; // for order by "SongNo" song.SongNa = song_na; // for order by "SongNa" song.VodNo = vod_no; // for order by "VodNo" song.Language = new Language(); // for order by "LangNo" + "SongNa" song.Language.LangNo = lang_no; song.SongNa = song_na; song.Singer1 = new Singer(); // for order by "Singer1.SingNa" song.Singer1.SingNa = sing_na1; song.Singer2 = new Singer(); // for order by "Singer2.SingNa" song.Singer2.SingNa = sing_na2; List <Song> songsTemp = _songsManager.FindOnePageOfSongsForOneSong(mState, song, -1); temp_state = JsonUtil.SetJsonStringFromObject(mState); ViewBag.SongState = temp_state; return(View(nameof(SongsList), songsTemp)); }
public IActionResult Find(string lang_no, string lang_na, string search_type, string submitbutton, string language_state) { 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); if (string.IsNullOrEmpty(lang_no)) { lang_no = string.Empty; } lang_no = lang_no.Trim(); if (string.IsNullOrEmpty(lang_na)) { lang_na = string.Empty; } lang_na = lang_na.Trim(); string sButton = submitbutton.ToUpper(); if (sButton == "CANCEL") { temp_state = JsonUtil.SetJsonStringFromObject(mState); return(RedirectToAction(nameof(LanguagesList), new { language_state = temp_state })); } if (string.IsNullOrEmpty(search_type)) { // search_type not defined return(View()); } string searchType = search_type.Trim(); mState.OrderBy = searchType; Language language = new Language(); // new object language.LangNo = lang_no; // for order by "LangNo" language.LangNa = lang_na; // for order by "LangNa" List <Language> languagesTemp = _languagesManager.FindOnePageOfLanguagesForOneLanguage(mState, language, -1); temp_state = JsonUtil.SetJsonStringFromObject(mState); ViewBag.LanguageState = temp_state; return(View(nameof(LanguagesList), languagesTemp)); }
public async Task <IActionResult> Add(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; string sButton = submitbutton.ToUpper(); if (sButton == "CANCEL") { Language newLanguage = new Language(); List <Language> languagesTemp = _languagesManager.FindOnePageOfLanguagesForOneLanguage(mState, newLanguage, orgId); mState.IsFirstAddRecord = true; temp_state = JsonUtil.SetJsonStringFromObject(mState); ViewBag.LanguageState = temp_state; return(View(nameof(LanguagesList), languagesTemp)); } if (ModelState.IsValid) { int result = await _languagesManager.AddOneLanguageToTable(language); if (result == ErrorCodeModel.Succeeded) { // succeeded to add the language mState.OrgId = language.Id; mState.OrgNo = language.LangNo; mState.IsFirstAddRecord = false; temp_state = JsonUtil.SetJsonStringFromObject(mState); return(RedirectToAction(nameof(Add), new { language_state = temp_state })); } else { ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(result); } } else { // Model.IsValid = false ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(ErrorCodeModel.ModelBindingFailed); } ViewBag.LanguageState = temp_state; return(View(language)); }