// 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));
}
