private void InitDetailsViewModel(SeasonDetailsViewModel viewModel, SeasonDetails details)
{
InitBaseDetailViewModel(details.Detail, viewModel.Detail);
InitBaseDetailEntityStateChange(viewModel.Detail);
viewModel.Detail.SeasonTypeName = GetSeasonTypeName(details.Detail.SeasonTypeId);
ViewData[Mvc.ViewData.Controller] = Mvc.Controller.Season.Name;
}
public ActionResult <IEnumerable <SeasonDetails> > GetSeasonDetails()
{
var resultList = new List <SeasonDetails>();
var season = _context.Season.ToList();
season.ForEach(seas =>
{
var seasonOfFootballTeam = _context.SeasonOfFootballTeam.Where(x => x.Idseason == seas.Idseason)
.ToList().Select(y => y.IdfootballTeam);
var footballTeam = _context.FootballTeam.Where(x => seasonOfFootballTeam.Contains(x.IdfootballTeam)).ToList();
footballTeam.ForEach(team =>
{
var res = new SeasonDetails
{
Idseason = seas.Idseason,
YearOfSeason = seas.YearOfSeason,
IdfootballTeam = team.IdfootballTeam,
Name = team.Name,
Location = team.Location,
NumberOfPoints = team.NumberOfPoints
};
resultList.Add(res);
});
});
return(resultList);
}
protected override async Task OnInitializedAsync()
{
if (int.TryParse(Id, out int tvShowId) && int.TryParse(Number, out int seasonNumber))
{
SeasonDetails = await TVService.GetTVSeasonDetailsAsync(tvShowId, seasonNumber);
TVShowDetails = await TVService.GetTVDetailsAsync(tvShowId);
}
}
public ActionResult Edit(SeasonDetailsViewModel viewModel)
{
if (viewModel.Detail.Year < DateTime.Now.Year)
{
AddModelError(viewModel, m => m.Detail.Year, Dom.Translation.Common.YearLessCurrentYear);
}
if (ModelState.IsValid)
{
Season season = _seasonRepository.Get <Season>(viewModel.Detail.Id);
season.Year = viewModel.Detail.Year;
season.SeasonTypeId = viewModel.Detail.SeasonTypeId;
season.Statements.ToList().ForEach(x => _seasonRepository.Delete(x));
if (viewModel.StatementIds != null)
{
foreach (var pigeon in viewModel.StatementIds)
{
season.Statements.Add(
new Statement
{
PigeonId = pigeon,
SeasonId = season.Id
});
}
}
_seasonRepository.UnitOfWork.SaveChanges();
return(RedirectToAction(Mvc.Controller.Season.Details, Mvc.Controller.Season.Name, new { id = viewModel.Detail.Id }));
}
SeasonDetails details = _seasonRepository.GetSeasonDetails(UserContext.User.Id, UserContext.User.OrganizationId, viewModel.Detail.Id);
viewModel.Detail.SeasonTypeItems = InitSeasonTypeSelectListItems();
foreach (var pigeon in details.Pigeons)
{
pigeon.Ring = Format.FormattedRing(pigeon.Year, pigeon.Code, pigeon.Number);
pigeon.InStatement = details.StatementPigeonIds.Contains(pigeon.Id);
}
viewModel.StatementIds = details.StatementPigeonIds.ToList();
viewModel.StatementItems = new Dictionary <string, ICollection <SelectListItem> >();
foreach (var member in details.Members)
{
viewModel.StatementItems.Add(
Format.FormattedInitials(member.LastName, member.FirstName, member.MiddleName) + $" (#{member.Id})",
details.Pigeons
.Where(m => m.MemberId == member.Id)
.Select(g => new SelectListItem
{
Value = g.Id.ToString(),
Text = g.Ring,
Selected = g.InStatement
}).ToList()
);
}
return(View(Mvc.View.Season.Edit, viewModel));
}
public IHttpActionResult GetAllSeasons()
{
SeasonListModesViewModel seasonModel = new SeasonListModesViewModel();
SeasonDetails seasonDetails = new SeasonDetails();
List <SeasonDetails> listOfSeasons = new List <SeasonDetails>();
DataTable dt = null;
db.openConnection();
try
{
paramName = new string[] { };
paramValue = new string[] { };
dt = db.executePROC("spGetAllTemporadasNoFilterCRUD", paramName, paramValue);
for (var i = 0; i < dt.Rows.Count; i++)
{
seasonDetails = new SeasonDetails();
seasonDetails.id = Convert.ToInt16(dt.Rows[i]["ID_TEMPORADA"].ToString());
seasonDetails.name = dt.Rows[i]["NM_TEMPORADA"].ToString();
seasonDetails.active = Convert.ToByte(dt.Rows[i]["IN_TEMPORADA_ATIVA"].ToString());
seasonDetails.dtStartSeason = Convert.ToDateTime(dt.Rows[i]["DT_INICIO"].ToString());
if (!String.IsNullOrEmpty(dt.Rows[i]["DT_FIM"].ToString()))
{
seasonDetails.dtEndSeason = Convert.ToDateTime(dt.Rows[i]["DT_FIM"].ToString());
}
seasonDetails.typeMode = string.Empty;
listOfSeasons.Add(seasonDetails);
}
seasonModel.listOfSeasons = listOfSeasons;
seasonModel.returnMessage = "ModeratorSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, seasonModel));
}
catch (Exception ex)
{
seasonModel = new SeasonListModesViewModel();
seasonModel.listOfSeasons = new List <SeasonDetails>();
seasonModel.returnMessage = "errorGetAllSeasons_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, seasonModel));
}
finally
{
db.closeConnection();
seasonDetails = null;
seasonModel = null;
listOfSeasons = null;
dt = null;
}
}
public ActionResult Index()
{
HttpResponseMessage response = null;
SeasonDetails modelReturnJSON = null;
HomePageViewModel homeMode = new HomePageViewModel();
try
{
homeMode.actionUser = "******";
response = GlobalVariables.WebApiClient.PostAsJsonAsync("Season", homeMode).Result;
modelReturnJSON = response.Content.ReadAsAsync <SeasonDetails>().Result;
switch (response.StatusCode)
{
case HttpStatusCode.Created:
if (modelReturnJSON.returnMessage == "subscribeBenchSuccessfully")
{
Session["user.current.season.menu"] = null;
Session["user.current.season.summary"] = null;
homeMode.seasonID = modelReturnJSON.id;
homeMode.seasonName = modelReturnJSON.name;
ViewBag.inGentelella = "0";
return(View(homeMode));
}
else
{
//ModelState.AddModelError("", "Senha Atual inválida! Favor tentar novamente.");
TempData["returnMessage"] = "Ocorreu algum erro na exibição da Home Page do Arena. (" + modelReturnJSON.returnMessage + ")";
return(View(homeMode));
}
default:
TempData["returnMessage"] = "Ocorreu algum erro na exibição da Home Page do Arena. (" + response.StatusCode + ")";
ModelState.AddModelError("", "application error.");
return(View(homeMode));
}
}
catch (Exception ex)
{
TempData["returnMessage"] = "Erro interno - Exibindo Home Page Arena: (" + ex.InnerException.Message + ")";
ModelState.AddModelError("", "application error.");
return(View(homeMode));
}
finally
{
response = null;
modelReturnJSON = null;
homeMode = null;
}
}
public ActionResult Details(int id)
{
SeasonDetails details = _seasonRepository.GetSeasonDetails(UserContext.User.Id, UserContext.User.OrganizationId, id);
if (details.Detail == null)
{
return(NotFoundResult());
}
SeasonDetailsViewModel viewModel = Mapper.Map <SeasonDetailsViewModel>(details);
InitDetailsViewModel(viewModel, details);
return(View(Mvc.View.Season.Details, viewModel));
}
public IHttpActionResult GetSeasonDetails(int id)
{
SeasonDetails seasonDetails = new SeasonDetails();
SeasonListModesViewModel seasonModel = new SeasonListModesViewModel();
List <SeasonDetails> listOfSeasons = new List <SeasonDetails>();
DataTable dt = null;
db.openConnection();
try
{
if (String.IsNullOrEmpty(Convert.ToString(id)) || id == 0)
{
paramName = new string[] { };
paramValue = new string[] { };
dt = db.executePROC("spGetCurrentTemporada", paramName, paramValue);
SetDetailsSeason(dt, seasonDetails);
return(Ok(seasonDetails));
}
else
{
paramName = new string[] { "idTemporada" };
paramValue = new string[] { Convert.ToString(id) };
dt = db.executePROC("spGetTemporada", paramName, paramValue);
SetDetailsSeason(dt, seasonDetails);
return(Ok(seasonDetails));
}
}
catch (Exception ex)
{
seasonDetails = new SeasonDetails();
seasonDetails.returnMessage = "errorGetSeasonDetails_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, seasonDetails));
}
finally
{
db.closeConnection();
seasonDetails = null;
seasonModel = null;
listOfSeasons = null;
dt = null;
}
}
private void SetDetailsSeason(DataTable dt, SeasonDetails seasonDetails)
{
var row = dt.Rows[0];
seasonDetails.id = Convert.ToInt16(row["ID_TEMPORADA"].ToString());
seasonDetails.name = row["NM_TEMPORADA"].ToString();
seasonDetails.active = Convert.ToByte(row["IN_TEMPORADA_ATIVA"].ToString());
seasonDetails.dtStartSeason = Convert.ToDateTime(row["DT_INICIO"].ToString());
if (!String.IsNullOrEmpty(row["DT_FIM"].ToString()))
{
seasonDetails.dtEndSeason = Convert.ToDateTime(row["DT_FIM"].ToString());
}
seasonDetails.typeMode = string.Empty;
row = null;
}
public IHttpActionResult season(SeasonModesViewModel model)
{
db.openConnection();
DataTable dt = null;
SeasonDetails seasonDetails = new SeasonDetails();
try
{
if (model.actionUser == "add")
{
model.returnMessage = "subscribeBenchSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
else if (model.actionUser == "current")
{
paramName = new string[] { };
paramValue = new string[] { };
dt = db.executePROC("spGetIDCurrentTemporada", paramName, paramValue);
SetDetailsSeason(dt, seasonDetails);
seasonDetails.returnMessage = "subscribeBenchSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, seasonDetails));
}
else
{
return(StatusCode(HttpStatusCode.NotAcceptable));
}
}
catch (Exception ex)
{
model = new SeasonModesViewModel();
model.returnMessage = "error_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
finally
{
db.closeConnection();
dt = null;
seasonDetails = null;
}
}
public ActionResult Edit(int id)
{
SeasonDetails details = _seasonRepository.GetSeasonDetails(UserContext.User.Id, UserContext.User.OrganizationId, id);
if (details.Detail == null)
{
return(NotFoundResult());
}
SeasonDetailsViewModel viewModel = Mapper.Map <SeasonDetailsViewModel>(details);
viewModel.Detail.SeasonTypeItems = InitSeasonTypeSelectListItems();
foreach (var pigeon in details.Pigeons)
{
pigeon.Ring = Format.FormattedRing(pigeon.Year, pigeon.Code, pigeon.Number);
pigeon.InStatement = details.StatementPigeonIds.Contains(pigeon.Id);
}
viewModel.StatementIds = details.StatementPigeonIds.ToList();
viewModel.StatementItems = new Dictionary <string, ICollection <SelectListItem> >();
foreach (var member in details.Members)
{
viewModel.StatementItems.Add(
Format.FormattedInitials(member.LastName, member.FirstName, member.MiddleName) + $" (#{member.Id})",
details.Pigeons
.Where(m => m.MemberId == member.Id)
.Select(g => new SelectListItem
{
Value = g.Id.ToString(),
Text = g.Ring,
Selected = g.InStatement
}).ToList()
);
}
return(View(Mvc.View.Season.Edit, viewModel));
}
private static void MapSeasons(List <SeasonRequests> seasonRequests, Season tvSeason, SeasonDetails seasonEpisodes)
{
foreach (var episode in seasonEpisodes.episodes)
{
var season = seasonRequests.FirstOrDefault(x => x.SeasonNumber == episode.season_number);
if (season == null)
{
var newSeason = new SeasonRequests
{
SeasonNumber = episode.season_number,
Overview = tvSeason.overview,
Episodes = new List <EpisodeRequests>()
};
newSeason.Episodes.Add(new EpisodeRequests
{
//Url = episode...ToHttpsUrl(),
Title = episode.name,
AirDate = episode.air_date.HasValue() ? DateTime.Parse(episode.air_date) : DateTime.MinValue,
EpisodeNumber = episode.episode_number,
});
seasonRequests.Add(newSeason);
}
else
{
// We already have the season, so just add the episode
season.Episodes.Add(new EpisodeRequests
{
//Url = e.url.ToHttpsUrl(),
Title = episode.name,
AirDate = episode.air_date.HasValue() ? DateTime.Parse(episode.air_date) : DateTime.MinValue,
EpisodeNumber = episode.episode_number,
});
}
}
}
public DetailSeasonSerieView()
{
InitializeComponent();
var season = new SeasonDetails()
{
Title = "Breaking Bad",
Season = "1",
totalSeasons = "5",
Episodes = new List <EpisodeDetails>()
{
new EpisodeDetails()
{
Title = "Pilot",
Released = "2008-01-20",
Episode = "1",
imdbRating = "8.9",
//imdbID= "tt0959621"
},
new EpisodeDetails()
{
Title = "Cat's in the Bag...",
Released = "2008-01-27",
Episode = "2",
imdbRating = "8.7",
//imdbID= "tt1054724"
},
new EpisodeDetails()
{
Title = "...And the Bag's in the River",
Released = "2008-02-10",
Episode = "3",
imdbRating = "8.7",
// imdbID= "tt1054725"
},
new EpisodeDetails()
{
Title = "Cancer Man",
Released = "2008-02-17",
Episode = "4",
imdbRating = "8.3",
// imdbID= "tt1054726"
},
new EpisodeDetails()
{
Title = "Gray Matter",
Released = "2008-02-24",
Episode = "5",
imdbRating = "8.3",
//imdbID= "tt1054727"
},
new EpisodeDetails()
{
Title = "Crazy Handful of Nothin'",
Released = "2008-03-02",
Episode = "6",
imdbRating = "9.2",
// imdbID= "tt1054728"
},
new EpisodeDetails()
{
Title = "A No-Rough-Stuff-Type Deal",
Released = "2008-03-09",
Episode = "7",
imdbRating = "8.8",
// imdbID= "tt1054729"
}
}
};
TitleLabel.Text = season.Title;
SeasonLabel.Text = season.Season;
TotalSeasonsLabel.Text = season.totalSeasons;
}
