public void Insert(AchievementViewModel model)
{
var contractType = AutoMapper.Mapper.Map <AchievementViewModel, Achievement>(model);
_repository.Add(contractType);
Save();
}
/*/// <summary>
* /// Handles an individual achievement's page
* /// </summary>
* /// <param name="id">The id of the achievement</param>
* /// <returns>GET: /Achievements/{id}</returns>
* public ActionResult IndividualAchievement(int id)
* {
* if (User.Identity.IsAuthenticated)
* return RedirectToAction("IndividualAchievement", new { id = id, playerID = WebSecurity.CurrentUserId });
*
* AchievementViewModel model =
* AchievementViewModel.Populate(
* id,
* WebSecurity.IsAuthenticated ? WebSecurity.CurrentUserId : (int?)null);
*
* return View(model);
* }*/
public ActionResult IndividualAchievement(int id, int?playerID)
{
//if (playerID == null && WebSecurity.IsAuthenticated)
// return RedirectToAction("IndividualAchievement", new { id = id, playerID = WebSecurity.CurrentUserId });
AchievementViewModel model = AchievementViewModel.Populate(id);
ViewBag.servername = Request.Url.GetLeftPart(UriPartial.Authority);
bool fbEnabled = bool.Parse(JPPConstants.SiteSettings.GetValue(JPPConstants.SiteSettings.FacebookIntegrationEnabled));
if (fbEnabled)
{
ViewBag.FacebookMetaEnabled = true;
ViewBag.FacebookAppId = JPPConstants.SiteSettings.GetValue(JPPConstants.SiteSettings.FacebookAppId);
ViewBag.FacebookOgUrl = Request.Url.GetLeftPart(UriPartial.Path);
ViewBag.FacebookOgType = JPPConstants.SiteSettings.GetValue(JPPConstants.SiteSettings.FacebookAppNamespace)
+ ":achievement";
ViewBag.FacebookOgTitle = model.Title;
ViewBag.FacebookOgImageUri = JppUriInfo.GetAbsoluteUri(Request, model.Image);
ViewBag.FacebookOgDescription = model.Description;
}
return(View(model));
}
public AchievementNoteEditPage(AchievementViewModel achievementViewModel, AchievementNoteViewModel achievementNoteViewModel)
{
InitializeComponent();
_achievementViewModel = achievementViewModel;
_achievementNoteViewModel = achievementNoteViewModel;
BindingContext = achievementNoteViewModel;
}
public AchievementPage()
{
InitializeComponent();
_achievementViewModel = new AchievementViewModel(Navigation);
BindingContext = _achievementViewModel;
}
public void Delete(AchievementViewModel model)
{
var item = _repository.FindById(model.Id);
if (item != null)
{
_repository.Delete(item);
}
}
public async Task <PetAchievement> ToPetAchievementAsync(AchievementViewModel model)
{
return(new PetAchievement
{
Achievement = await _context.Achievements.FindAsync(model.AchievementId),
AchievementId = model.AchievementId,
Pet = await _context.Pets.FindAsync(model.PetId),
PetId = model.PetId
});
}
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
AchievementViewModel achievement = await _achievementService.Details((int)id);
return(View(achievement));
}
public static AchievementModel ToAchievementModel(this AchievementViewModel viewModel)
{
return(new AchievementModel
{
Id = viewModel.Id,
UserId = Settings.CurrentUserId,
AchievementNotes = viewModel.AchievementNotes.ToAchievementNoteViewModels().ToList(),
Title = viewModel.Title,
GeneralDescription = viewModel.GeneralDescription,
GeneralTimeSpent = viewModel.GeneralTimeSpent,
ImageContent = viewModel.ImageContent
});
}
public ActionResult Delete(AchievementViewModel model)
{
try
{
achievementService.Delete(model);
achievementService.Save();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public IActionResult PlayerAchievements()
{
if (HttpContext.Session.GetInt32("PlayerId") != null)
{
AchievementViewModel AVmodel = new AchievementViewModel();
AVmodel.Achievements = _playerLogic.GetAllPlayersAchievements();
return(View(AVmodel));
}
// Else
TempData["LoginError"] = "You are not logged in. Please log in and try again";
return(RedirectToAction("Login"));
}
public async Task <IActionResult> AddAchievement(AchievementViewModel model)
{
if (ModelState.IsValid)
{
var petAchievement = await _converterHelper.ToPetAchievementAsync(model);
_context.PetAchievements.Add(petAchievement);
await _context.SaveChangesAsync();
return(RedirectToAction($"{nameof(DetailsPet)}/{model.PetId}"));
}
model.Achievements = _combosHelper.GetComboAchievements();
return(View(model));
}
// GET: HallOfFame/AchievementsPRO
public ActionResult AchievementsPRO()
{
HttpResponseMessage response = null;
AchievementViewModel modelReturnJSON = null;
AchievementViewModel hallOfFameMode = new AchievementViewModel();
setViewBagVariables();
try
{
hallOfFameMode.actionUser = "******";
response = GlobalVariables.WebApiClient.PostAsJsonAsync("HallOfFame", hallOfFameMode).Result;
modelReturnJSON = response.Content.ReadAsAsync <AchievementViewModel>().Result;
switch (response.StatusCode)
{
case HttpStatusCode.Created:
if (modelReturnJSON.returnMessage == "HallOfFameSuccessfully")
{
return(View(modelReturnJSON));
}
else
{
//ModelState.AddModelError("", "Senha Atual inválida! Favor tentar novamente.");
TempData["returnMessage"] = "Ocorreu algum erro na exibição do Hall da Fama - Conquistas H2H. (" + modelReturnJSON.returnMessage + ")";
return(View(hallOfFameMode));
}
default:
TempData["returnMessage"] = "Ocorreu algum erro na exibição do Hall da Fama - Conquistas H2H. (" + response.StatusCode + ")";
ModelState.AddModelError("", "application error.");
return(View(hallOfFameMode));
}
}
catch (Exception ex)
{
TempData["returnMessage"] = "Erro interno - Exibindo Hall da Fama - Conquistas H2H: (" + ex.InnerException.Message + ")";
ModelState.AddModelError("", "application error.");
return(View(hallOfFameMode));
}
finally
{
response = null;
modelReturnJSON = null;
hallOfFameMode = null;
}
}
public void Update(AchievementViewModel model)
{
var contractType = AutoMapper.Mapper.Map <AchievementViewModel, Achievement>(model);
if (string.IsNullOrEmpty(contractType.Document))
{
var old = _repository.FindById(model.Id);
if (old != null)
{
contractType.Document = old.Document;
}
}
_repository.Update(contractType);
Save();
}
public ActionResult Edit(int id, AchievementViewModel model)
{
if (ModelState.IsValid)
{
Achievement achievement = db.Achievements.Find(id);
if (achievement == null)
{
return(HttpNotFound());
}
achievement.Discription = model.Discription;
achievement.AchievementType = model.AchievementType;
db.Entry(achievement).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeId = new SelectList(db.Employees, "Id", "FullName");
return(View(model));
}
public IActionResult EditItem(Guid id)
{
var item = _achievementRepo.Read(id);
var userInfo = _userInfoRepo.Read(_userManager.GetUserId(User));
// TODO research better alternatives for handling the errors -----
if (item == null)
{
Response.StatusCode = 404;
ViewBag.ErrorMessage = "Can't find the item you are looking for";
return(View("PageNotFound"));
}
if (item.UserInformationId != userInfo.UserInformationId)
{
Response.StatusCode = 403;
ViewBag.ErrorTitle = "Wrong user";
ViewBag.ErrorMessage = "Please login with the correct user to edit this item";
return(View("Error"));
}
var model = new AchievementViewModel()
{
ImageSrcPaths = new List <string>(),
Title = item.Title,
Summary = item.Summary,
//MainText = item.MainText,
OrderPosMaxLimit = _config.GetValue <int>("ItemSettings:MaxLimit"),
OrderPosition = item.OrderPosition,
//EnableComments = item.EnableComments,
//EnableRating = item.EnableRating,
};
foreach (var filePathContainer in item.ItemGalleryImageFilePaths)
{
model.ImageSrcPaths.Add(filePathContainer.GalleryImageFilePath);
}
return(View(model));
}
public ActionResult Create(AchievementViewModel model)
{
try
{
if (ModelState.IsValid)
{
var f = Request.Files["Document"];
if (f != null && f.ContentLength > 0)
{
string pic = System.IO.Path.GetFileName(f.FileName);//System.IO.Path.GetFileName(f.FileName);
var avatarpath = "/Uploads/Thanhtichs";
string path = System.IO.Path.Combine(Server.MapPath(avatarpath), pic);
// file is uploaded
f.SaveAs(path);
using (MemoryStream ms = new MemoryStream())
{
f.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
}
model.Document = string.Join("/", avatarpath, pic);
}
//model.Document = document;
achievementService.Insert(model);
achievementService.Save();
return(RedirectToAction("Index", "Achievement", new { employeeId = model.EmployeeId }));
}
var employees = employeeService.GetEmployeeSelectListItems().Select(x => new {
Id = x.Id,
Name = x.LastName + " - " + x.FirstName
}).ToList();
ViewBag.Employees = new SelectList(employees, "Id", "Name");
return(View(model));
}
catch (Exception e)
{
return(View(model));
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Achievement achievement = db.Achievements.Find(id);
if (achievement == null)
{
return(HttpNotFound());
}
var model = new AchievementViewModel
{
Id = achievement.AchievementId,
EmployeeName = achievement.Employee.FullName,
Discription = achievement.Discription,
AchievementType = achievement.AchievementType,
};
return(View(model));
}
public async Task <IActionResult> AddAchievement(int?id)
{
if (id == null)
{
return(NotFound());
}
var pet = await _context.Pets.FirstOrDefaultAsync(p => p.Id == id);
if (pet == null)
{
return(NotFound());
}
var view = new AchievementViewModel
{
PetId = pet.Id,
Pet = pet,
Achievements = _combosHelper.GetComboAchievements(),
};
return(View(view));
}
public ActionResult Create(AchievementViewModel model)
{
if (ModelState.IsValid)
{
var achievement = new Achievement
{
AchievementId = model.Id,
Discription = model.Discription,
AchievementType = model.AchievementType,
EmployeeId = model.EmployeeId,
};
db.Achievements.Add(achievement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
var list = db.Employees.ToList().Select(e => new { e.Id, e.FullName });
ViewBag.EmployeeId = new SelectList(list, "Id", "FullName");
ViewBag.AchievementId = new SelectList(db.Achievements, "AchievementId", "AchievementType");
return(View(model));
}
public IActionResult CreateItem()
{
// If max limit is reached ----------------------
var userInfo = _userInfoRepo.Read(_userManager.GetUserId(User));
var maxLimit = _config.GetValue <int>("ItemSettings:MaxLimit");
if (userInfo.AchievementCount >= maxLimit)
{
ViewBag.ErrorTitle = "Item limit reached!";
ViewBag.ErrorMessage = $"The limit per user is {maxLimit}. Please delete any outdated items";
return(View("Error"));
}
// -----------------------------------------------
var model = new AchievementViewModel()
{
OrderPosMaxLimit = maxLimit,
OrderPosition = userInfo.AchievementCount++
};
return(View(model));
}
public IActionResult DisplayItem(Guid id)
{
var item = _achievementRepo.Read(id);
if (item == null)
{
Response.StatusCode = 404;
ViewBag.ErrorTitle = "Wrong ID";
ViewBag.ErrorMessage = "Can't find portfolio item";
return(View("PageNotFound"));
}
var model = new AchievementViewModel()
{
//userId = item.UserInformationId.ToString(),
ImageSrcPaths = new List <string>(),
Title = item.Title,
Summary = item.Summary,
//MainText = item.MainText,
OrderPosMaxLimit = _config.GetValue <int>("ItemSettings:MaxLimit"),
OrderPosition = item.OrderPosition,
//EnableComments = item.EnableComments,
//EnableRating = item.EnableRating,
};
foreach (var filePathContainer in item.ItemGalleryImageFilePaths)
{
if (!string.IsNullOrEmpty(filePathContainer.GalleryImageFilePath))
{
model.ImageSrcPaths.Add(filePathContainer.GalleryImageFilePath);
}
}
return(View(model));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Achievement achievement = db.Achievements.Find(id);
if (achievement == null)
{
return(HttpNotFound());
}
AchievementViewModel model = new AchievementViewModel
{
Id = achievement.AchievementId,
Discription = achievement.Discription,
AchievementType = achievement.AchievementType,
};
ViewBag.EmployeeId = new SelectList(db.Employees, "Id", "FullName");
return(View());
}
public IHttpActionResult hallOfFame(HallOfFameSummaryViewModel model)
{
if (String.IsNullOrEmpty(model.dataBaseName))
{
model.dataBaseName = GlobalVariables.DATABASE_NAME_ONLINE;
}
db.openConnection(model.dataBaseName);
DataTable dt = null;
string returnMessage = String.Empty;
try
{
if (model.actionUser == "summary")
{
paramName = new string[] { };
paramValue = new string[] { };
dt = db.executePROC("spGetSummaryHallOfFame", paramName, paramValue);
model.psnIDSerieAH2H = dt.Rows[0]["psnIDH2HChampion"].ToString();
model.teamIDSerieAH2H = dt.Rows[0]["teamNameH2HChampion"].ToString();
model.psnIDSerieAFUT = dt.Rows[0]["psnIDFUTChampion"].ToString();
model.teamIDSerieAFUT = dt.Rows[0]["teamNameFUTChampion"].ToString();
model.psnIDSerieAPRO = dt.Rows[0]["psnIDPROChampion"].ToString();
model.teamIDSerieAPRO = dt.Rows[0]["teamNamePROChampion"].ToString();
model.psnIDCDM = dt.Rows[0]["psnIDCDMChampion"].ToString();
model.teamIDCDM = dt.Rows[0]["teamNameCDMChampion"].ToString();
model.psnIDUCL = dt.Rows[0]["psnIDUCLChampion"].ToString();
model.teamIDUCL = dt.Rows[0]["teamNameUCLChampion"].ToString();
model.psnIDSCP = dt.Rows[0]["psnIDSCPChampion"].ToString();
model.teamIDSCP = dt.Rows[0]["teamNameSCPChampion"].ToString();
model.returnMessage = "HallOfFameSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
else if (model.actionUser == "championshipScoring")
{
paramName = new string[] { };
paramValue = new string[] { };
dt = db.executePROC("spGetAllCampeonatosScoring", paramName, paramValue);
ChampionshipScoreViewModel championshipScoring = new ChampionshipScoreViewModel();
ChampionshipTypeModel championshipType = new ChampionshipTypeModel();
List <ChampionshipTypeModel> listOfChampionship = new List <ChampionshipTypeModel>();
try
{
for (var i = 0; i < dt.Rows.Count; i++)
{
championshipType = new ChampionshipTypeModel();
championshipType.championshipType = dt.Rows[i]["SG_TIPO_CAMPEONATO"].ToString();
championshipType.scoreChampion = Convert.ToInt16(dt.Rows[i]["PT_CAMPEAO"].ToString());
championshipType.scoreVice = Convert.ToInt16(dt.Rows[i]["PT_VICECAMPEAO"].ToString());
championshipType.scoreSemi = Convert.ToInt16(dt.Rows[i]["PT_SEMIS"].ToString());
championshipType.scoreQuarter = Convert.ToInt16(dt.Rows[i]["PT_QUARTAS"].ToString());
championshipType.scoreRound16 = Convert.ToInt16(dt.Rows[i]["PT_OITAVAS"].ToString());
championshipType.scoreQualifyNextStage = Convert.ToInt16(dt.Rows[i]["PT_CLASSIF_FASE2"].ToString());
championshipType.scoreWins = Convert.ToInt16(dt.Rows[i]["PT_VITORIAS_FASE1"].ToString());
championshipType.scoreDraws = Convert.ToInt16(dt.Rows[i]["PT_EMPATES_FASE1"].ToString());
championshipType.score2ndStage = Convert.ToInt16(dt.Rows[i]["PT_FASE2"].ToString());
listOfChampionship.Add(championshipType);
}
championshipScoring.listChampionshipScore = listOfChampionship;
championshipScoring.returnMessage = "HallOfFameSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, championshipScoring));
}
catch (Exception ex)
{
championshipScoring = new ChampionshipScoreViewModel();
model.returnMessage = "error_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, championshipScoring));
}
finally
{
championshipScoring = null;
championshipType = null;
listOfChampionship = null;
}
}
else if (model.actionUser == "blackList")
{
paramName = new string[] { };
paramValue = new string[] { };
dt = db.executePROC("spGetAllListaNegra", paramName, paramValue);
GeneralBlackListViewModel blackListModel = new GeneralBlackListViewModel();
GeneralBlackListModel listGeneralBlackList = new GeneralBlackListModel();
List <GeneralBlackListModel> listOfBlackList = new List <GeneralBlackListModel>();
try
{
for (var i = 0; i < dt.Rows.Count; i++)
{
listGeneralBlackList = new GeneralBlackListModel();
listGeneralBlackList.psnID = dt.Rows[i]["PSN_ID"].ToString();
listGeneralBlackList.userName = dt.Rows[i]["NM_USUARIO"].ToString();
listGeneralBlackList.total = Convert.ToInt16(dt.Rows[i]["TOTAL_GERAL"].ToString());
if (!String.IsNullOrEmpty(dt.Rows[i]["TOTAL_TEMP"].ToString()))
{
listGeneralBlackList.totalPreviousSeason = Convert.ToInt16(dt.Rows[i]["TOTAL_TEMP"].ToString());
}
else
{
listGeneralBlackList.totalPreviousSeason = 0;
}
listOfBlackList.Add(listGeneralBlackList);
}
blackListModel.listBlackList = listOfBlackList;
blackListModel.returnMessage = "HallOfFameSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, blackListModel));
}
catch (Exception ex)
{
blackListModel = new GeneralBlackListViewModel();
model.returnMessage = "error_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, blackListModel));
}
finally
{
blackListModel = null;
listGeneralBlackList = null;
listOfBlackList = null;
}
}
else if (model.actionUser == "renewal")
{
RenewalChampionshipModel renewalChampionship = new RenewalChampionshipModel();
RenewalViewModel RenewalModel = new RenewalViewModel();
List <RenewalChampionshipModel> listOfRenewal = new List <RenewalChampionshipModel>();
int totAcceptedApproved = 0;
int totUnderAnalysis = 0;
int blackListPoints = 0;
try
{
if (model.seasonID == 0)
{
paramName = new string[] { "pMode" };
paramValue = new string[] { "" };
dt = db.executePROC("spGetIDsTemporadaByMode", paramName, paramValue);
model.seasonID = Convert.ToInt32(dt.Rows[0]["id_current_temporada"].ToString());
model.seasonName = dt.Rows[0]["nm_current_temporada"].ToString();
model.previousSeasonID = Convert.ToInt32(dt.Rows[0]["id_previous_temporada"].ToString());
model.previousSeasonName = dt.Rows[0]["nm_previous_temporada"].ToString();
}
paramName = new string[] { "pIdTemporada", "pIdTemporadaAnt", "pIdsCampeonato" };
paramValue = new string[] { Convert.ToString(model.seasonID), Convert.ToString(model.previousSeasonID), model.championshipIDRenewal };
if (model.renewalMode == "H2H")
{
dt = db.executePROC("spGetAllConfirmacaoTemporadaOfCampeonatoH2H", paramName, paramValue);
}
else if (model.renewalMode == "FUT")
{
dt = db.executePROC("spGetAllConfirmacaoTemporadaOfCampeonatoFUT", paramName, paramValue);
}
else if (model.renewalMode == "PRO")
{
dt = db.executePROC("spGetAllConfirmacaoTemporadaOfCampeonatoPRO", paramName, paramValue);
}
for (var i = 0; i < dt.Rows.Count; i++)
{
renewalChampionship = new RenewalChampionshipModel();
renewalChampionship.psnID = dt.Rows[i]["PSN_ID"].ToString();
renewalChampionship.userName = dt.Rows[i]["NM_USUARIO"].ToString();
renewalChampionship.userID = Convert.ToInt32(dt.Rows[i]["ID_USUARIO"].ToString());
renewalChampionship.championshipID = Convert.ToInt16(dt.Rows[i]["ID_CAMPEONATO"].ToString());
renewalChampionship.teamName = dt.Rows[i]["NM_TIME"].ToString();
if (String.IsNullOrEmpty(dt.Rows[i]["PT_LSTNEGRA"].ToString()))
{
blackListPoints = 0;
}
else
{
blackListPoints = Convert.ToInt32(dt.Rows[i]["PT_LSTNEGRA"].ToString());
}
if (String.IsNullOrEmpty(dt.Rows[i]["IN_CONFIRMACAO"].ToString()))
{
renewalChampionship.actionRenewal = "Ainda não confirmou";
renewalChampionship.acceptedRenewal = "-1";
renewalChampionship.status = "AGUARDANDO";
}
else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 1 && blackListPoints >= model.totalLimitBlackList)
{
renewalChampionship.actionRenewal = "Confirmou, mas chegou ao limite de pontos na Lista Negra";
renewalChampionship.acceptedRenewal = "9";
renewalChampionship.status = "NÃO ACEITO";
totUnderAnalysis += 1;
}
else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 1)
{
renewalChampionship.actionRenewal = "Confirmou Participação";
renewalChampionship.acceptedRenewal = "1";
renewalChampionship.status = "APROVADO";
totAcceptedApproved += 1;
}
else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 0)
{
renewalChampionship.actionRenewal = "Não deseja Participar";
renewalChampionship.acceptedRenewal = "0";
renewalChampionship.status = "DESISTIU";
}
renewalChampionship.statusInitials = dt.Rows[i]["DS_STATUS"].ToString();
if (model.renewalMode == "PRO")
{
renewalChampionship.playersTotal = Convert.ToInt32(dt.Rows[i]["TOTAL_JOGADORES"].ToString());
}
renewalChampionship.blackListtotal = blackListPoints;
if (String.IsNullOrEmpty(dt.Rows[i]["PT_TOTAL"].ToString()))
{
renewalChampionship.total = 0;
}
else
{
renewalChampionship.total = Convert.ToInt32(dt.Rows[i]["PT_TOTAL"].ToString());
}
if (String.IsNullOrEmpty(dt.Rows[i]["PT_TOTAL_ATUAL"].ToString()))
{
renewalChampionship.seasonCurrentTotal = 0;
}
else
{
renewalChampionship.seasonCurrentTotal = Convert.ToInt32(dt.Rows[i]["PT_TOTAL_ATUAL"].ToString());
}
renewalChampionship.grandTotal = renewalChampionship.total + renewalChampionship.seasonCurrentTotal;
listOfRenewal.Add(renewalChampionship);
}
//get all of the bench
paramName = new string[] { "pIdTemporada", "pIdTemporadaAnt", "pIdsCampeonato" };
paramValue = new string[] { Convert.ToString(model.seasonID), Convert.ToString(model.previousSeasonID), model.championshipIDBenchRenewal };
if (model.renewalMode == "H2H")
{
dt = db.executePROC("spGetAllConfirmacaoTemporadaOfCampeonatoH2HBco", paramName, paramValue);
}
else if (model.renewalMode == "FUT")
{
dt = db.executePROC("spGetAllConfirmacaoTemporadaOfCampeonatoFUTBco", paramName, paramValue);
}
else if (model.renewalMode == "PRO")
{
dt = db.executePROC("spGetAllConfirmacaoTemporadaOfCampeonatoPROBco", paramName, paramValue);
}
for (var i = 0; i < dt.Rows.Count; i++)
{
renewalChampionship = new RenewalChampionshipModel();
renewalChampionship.psnID = dt.Rows[i]["PSN_ID"].ToString();
renewalChampionship.userName = dt.Rows[i]["NM_USUARIO"].ToString();
renewalChampionship.userID = Convert.ToInt32(dt.Rows[i]["ID_USUARIO"].ToString());
renewalChampionship.championshipID = Convert.ToInt16(dt.Rows[i]["ID_CAMPEONATO"].ToString());
renewalChampionship.teamName = dt.Rows[i]["NM_TIME"].ToString();
if (String.IsNullOrEmpty(dt.Rows[i]["PT_LSTNEGRA"].ToString()))
{
blackListPoints = 0;
}
else
{
blackListPoints = Convert.ToInt32(dt.Rows[i]["PT_LSTNEGRA"].ToString());
}
if (String.IsNullOrEmpty(dt.Rows[i]["IN_CONFIRMACAO"].ToString()))
{
renewalChampionship.actionRenewal = "Ainda não confirmou";
renewalChampionship.acceptedRenewal = "-1";
renewalChampionship.status = "AGUARDANDO";
}
else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 1 && blackListPoints >= model.totalLimitBlackList)
{
renewalChampionship.actionRenewal = "Confirmou, mas chegou ao limite de pontos na Lista Negra";
renewalChampionship.acceptedRenewal = "9";
renewalChampionship.status = "NÃO ACEITO";
totUnderAnalysis += 1;
}
else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 1)
{
renewalChampionship.actionRenewal = "Confirmou Participação";
renewalChampionship.acceptedRenewal = "1";
renewalChampionship.status = "APROVADO";
totAcceptedApproved += 1;
}
else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 0)
{
renewalChampionship.actionRenewal = "Não deseja Participar";
renewalChampionship.acceptedRenewal = "0";
renewalChampionship.status = "DESISTIU";
}
renewalChampionship.statusInitials = dt.Rows[i]["DS_STATUS"].ToString();
if (model.renewalMode == "PRO")
{
renewalChampionship.playersTotal = Convert.ToInt32(dt.Rows[i]["TOTAL_JOGADORES"].ToString());
}
renewalChampionship.blackListtotal = blackListPoints;
if (String.IsNullOrEmpty(dt.Rows[i]["PT_TOTAL"].ToString()))
{
renewalChampionship.total = 0;
}
else
{
renewalChampionship.total = Convert.ToInt32(dt.Rows[i]["PT_TOTAL"].ToString());
}
renewalChampionship.seasonCurrentTotal = 0; // Convert.ToInt16(dt.Rows[i]["PT_TOTAL_ATUAL"].ToString());
renewalChampionship.grandTotal = renewalChampionship.total + renewalChampionship.seasonCurrentTotal;
listOfRenewal.Add(renewalChampionship);
}
//get all of H2H world cup or ueaf euro
if (model.renewalMode == "H2H" && !String.IsNullOrEmpty(model.championshipIDRenewalWorldCupUefaEuro))
{
paramName = new string[] { "pIdTemporada", "pIdTemporadaAnt", "pIdsCampeonato" };
paramValue = new string[] { Convert.ToString(model.seasonID), Convert.ToString(model.previousSeasonID), model.championshipIDRenewalWorldCupUefaEuro };
dt = db.executePROC("spGetAllConfirmacaoTemporadaOfCampeonatoCDM", paramName, paramValue);
for (var i = 0; i < dt.Rows.Count; i++)
{
renewalChampionship = new RenewalChampionshipModel();
renewalChampionship.psnID = dt.Rows[i]["PSN_ID"].ToString();
renewalChampionship.userName = dt.Rows[i]["NM_USUARIO"].ToString();
renewalChampionship.userID = Convert.ToInt32(dt.Rows[i]["ID_USUARIO"].ToString());
renewalChampionship.championshipID = Convert.ToInt16(dt.Rows[i]["ID_CAMPEONATO"].ToString());
renewalChampionship.teamName = String.Empty;
if (String.IsNullOrEmpty(dt.Rows[i]["PT_LSTNEGRA"].ToString()))
{
blackListPoints = 0;
}
else
{
blackListPoints = Convert.ToInt32(dt.Rows[i]["PT_LSTNEGRA"].ToString());
}
if (String.IsNullOrEmpty(dt.Rows[i]["IN_CONFIRMACAO"].ToString()))
{
renewalChampionship.actionRenewal = "Ainda não confirmou";
renewalChampionship.acceptedRenewal = "-1";
renewalChampionship.status = "AGUARDANDO";
}
else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 1 && blackListPoints >= model.totalLimitBanWorldCupUefaEuro)
{
renewalChampionship.actionRenewal = "Confirmou, mas chegou ao limite de pontos na Lista Negra para Copa do Mundo/Eurocopa";
renewalChampionship.acceptedRenewal = "9";
renewalChampionship.status = "NÃO ACEITO";
}
else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 1)
{
renewalChampionship.actionRenewal = "Confirmou Participação";
renewalChampionship.acceptedRenewal = "1";
renewalChampionship.status = "APROVADO";
}
else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 0)
{
renewalChampionship.actionRenewal = "Não deseja Participar";
renewalChampionship.acceptedRenewal = "0";
renewalChampionship.status = "DESISTIU";
}
renewalChampionship.statusInitials = dt.Rows[i]["DS_STATUS"].ToString();
renewalChampionship.blackListtotal = blackListPoints;
if (String.IsNullOrEmpty(dt.Rows[i]["PT_TOTAL"].ToString()))
{
renewalChampionship.total = 0;
}
else
{
renewalChampionship.total = Convert.ToInt32(dt.Rows[i]["PT_TOTAL"].ToString());
}
if (String.IsNullOrEmpty(dt.Rows[i]["PT_TOTAL_ATUAL"].ToString()))
{
renewalChampionship.seasonCurrentTotal = 0;
}
else
{
renewalChampionship.seasonCurrentTotal = Convert.ToInt32(dt.Rows[i]["PT_TOTAL_ATUAL"].ToString());
}
renewalChampionship.grandTotal = renewalChampionship.total + renewalChampionship.seasonCurrentTotal;
listOfRenewal.Add(renewalChampionship);
}
}
RenewalModel.renewalMode = model.renewalMode;
RenewalModel.seasonID = model.seasonID;
RenewalModel.seasonName = model.seasonName;
RenewalModel.previousSeasonID = model.previousSeasonID;
RenewalModel.previousSeasonName = model.previousSeasonName;
RenewalModel.championshipIDBenchRenewal = model.championshipIDBenchRenewal;
RenewalModel.championshipIDRenewal = model.championshipIDRenewal;
RenewalModel.championshipIDRenewalWorldCupUefaEuro = model.championshipIDRenewalWorldCupUefaEuro;
RenewalModel.totalApprovedRenewal = totAcceptedApproved;
RenewalModel.totalUnderAnalysisRenewal = totUnderAnalysis;
RenewalModel.listOfRenewal = listOfRenewal;
RenewalModel.returnMessage = "HallOfFameSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, RenewalModel));
}
catch (Exception ex)
{
RenewalModel = new RenewalViewModel();
model.returnMessage = "error_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, RenewalModel));
}
finally
{
renewalChampionship = null;
RenewalModel = null;
listOfRenewal = null;
}
}
else if (model.actionUser == "renewalSquad")
{
RenewalPROCLUBSquadViewModel PROCLUBSquadModel = new RenewalPROCLUBSquadViewModel();
squadListModel renewalSquad = new squadListModel();
List <squadListModel> listOfSquad = new List <squadListModel>();
PROCLUBSquadModel.managerID = model.managerID;
PROCLUBSquadModel.seasonID = model.seasonID;
PROCLUBSquadModel.clubName = model.clubName;
try
{
paramName = new string[] { "pIdUsuario" };
paramValue = new string[] { Convert.ToString(PROCLUBSquadModel.managerID) };
dt = db.executePROC("spGetUsuarioById", paramName, paramValue);
PROCLUBSquadModel.psnID = dt.Rows[0]["PSN_ID"].ToString();
PROCLUBSquadModel.mangerName = dt.Rows[0]["NM_USUARIO"].ToString();
PROCLUBSquadModel.mobileNumber = dt.Rows[0]["NO_CELULAR"].ToString();
PROCLUBSquadModel.codeMobileNumber = dt.Rows[0]["NO_DDD"].ToString();
PROCLUBSquadModel.listOfSquad = GlobalFunctions.getListOfSquadPROCLUB(db, model.seasonID, model.managerID, out returnMessage);
PROCLUBSquadModel.returnMessage = "HallOfFameSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, PROCLUBSquadModel));
}
catch (Exception ex)
{
PROCLUBSquadModel = new RenewalPROCLUBSquadViewModel();
model.returnMessage = "error_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, PROCLUBSquadModel));
}
finally
{
PROCLUBSquadModel = null;
renewalSquad = null;
listOfSquad = null;
}
}
else if (model.actionUser.Substring(0, 11) == "achievement")
{
paramName = new string[] { };
paramValue = new string[] { };
if (model.actionUser.IndexOf("H2H") > 0)
{
dt = db.executePROC("spGetAchievementH2H", paramName, paramValue);
}
else if (model.actionUser.IndexOf("FUT") > 0)
{
dt = db.executePROC("spGetAchievementFUT", paramName, paramValue);
}
else if (model.actionUser.IndexOf("PRO") > 0)
{
dt = db.executePROC("spGetAchievementPRO", paramName, paramValue);
}
AchievementViewModel GeneralAchievementModel = new AchievementViewModel();
AchievementModel achievementModel = new AchievementModel();
List <AchievementModel> listOfAchievement = new List <AchievementModel>();
try
{
for (var i = 0; i < dt.Rows.Count; i++)
{
achievementModel = new AchievementModel();
achievementModel.championshipType = dt.Rows[i]["SG_TIPO_CAMPEONATO"].ToString();
achievementModel.inGroup = Convert.ToBoolean(dt.Rows[i]["IN_CAMPEONATO_GRUPO"].ToString());
achievementModel.seasonName = dt.Rows[i]["ID_TEMPORADA"].ToString() + "ª Temporada (" + dt.Rows[i]["IN_CONSOLE"].ToString() + ")";
achievementModel.userName = dt.Rows[i]["NM_USUARIO"].ToString() + " (" + dt.Rows[i]["PSN_ID"].ToString() + ")";
achievementModel.teamName = dt.Rows[i]["NM_TIME"].ToString() + "-" + dt.Rows[i]["DS_TIPO"].ToString();
listOfAchievement.Add(achievementModel);
}
GeneralAchievementModel.listOfAchievement = listOfAchievement;
GeneralAchievementModel.returnMessage = "HallOfFameSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, GeneralAchievementModel));
}
catch (Exception ex)
{
GeneralAchievementModel = new AchievementViewModel();
model.returnMessage = "error_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, GeneralAchievementModel));
}
finally
{
GeneralAchievementModel = null;
listOfAchievement = null;
achievementModel = null;
}
}
else
{
return(StatusCode(HttpStatusCode.NotAcceptable));
}
}
catch (Exception ex)
{
model = new HallOfFameSummaryViewModel();
model.returnMessage = "error_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
finally
{
db.closeConnection();
dt = null;
}
}
public AchievementNoteCreatePage(AchievementViewModel viewModel)
{
InitializeComponent();
_viewModel = viewModel;
}
public AchievementDetailPage(AchievementViewModel viewModel)
{
InitializeComponent();
BindingContext = viewModel;
_viewModel = viewModel;
}
public IActionResult EditItem(Guid id, AchievementViewModel model)
{
var item = _achievementRepo.Read(id);
var userInfo = _userInfoRepo.Read(_userManager.GetUserId(User));
// TODO research better alternatives for handling the errors -----
if (item == null)
{
Response.StatusCode = 404;
ViewBag.ErrorMessage = "Can't find the item you are looking for";
return(View("PageNotFound"));
}
if (item.UserInformationId != userInfo.UserInformationId)
{
Response.StatusCode = 403;
ViewBag.ErrorTitle = "Wrong user";
ViewBag.ErrorMessage = "Please login with the correct user to edit this item";
return(View("Error"));
}
// ----------------------------------------------
if (ModelState.IsValid)
{
model.ImageSrcPaths = new List <string>();
item.Title = model.Title;
item.Summary = model.Summary;
//item.MainText = model.MainText;
item.OrderPosition = model.OrderPosition;
//item.EnableComments = model.EnableComments;
//item.EnableRating = model.EnableRating;
var files = new List <IFormFile>()
{
model.Thumbnail,
model.GallaryImage_1,
model.GallaryImage_2,
model.GallaryImage_3,
model.GallaryImage_4,
model.GallaryImage_5
};
var filePaths = FileProcessing.UploadItemGalleryPngs(files, userInfo.ApplicationUser.UserName, item.AchievementId, this, _config, _webHostEnvironment);
var maxImageLimit = Convert.ToInt32(_config.GetSection("FileUploadSettings")["MaxImageStorageLimit"]);
for (int i = 0; i < maxImageLimit; i++)
{
if (filePaths[i] == null)
{
continue;
}
item.ItemGalleryImageFilePaths[i].GalleryImageFilePath = filePaths[i];
}
foreach (var filePathContainer in item.ItemGalleryImageFilePaths)
{
model.ImageSrcPaths.Add(filePathContainer.GalleryImageFilePath); // for img src display
}
_achievementRepo.Update(item);
return(View(model));
}
return(View(model));
}
public IActionResult CreateItem(AchievementViewModel model)
{
// If max limit is reached ----------------------
var userInfo = _userInfoRepo.Read(_userManager.GetUserId(User));
var maxLimit = _config.GetValue <int>("ItemSettings:MaxLimit");
if (userInfo.AchievementCount >= maxLimit)
{
ViewBag.ErrorTitle = "Item limit reached!";
ViewBag.ErrorMessage = $"The limit per user is {maxLimit}. Please delete any outdated items";
return(View("Error"));
}
// -----------------------------------------------
if (ModelState.IsValid)
{
var newItemId = Guid.NewGuid();
var newItem = new Achievement
{
UserInformationId = userInfo.UserInformationId,
AchievementId = newItemId,
Title = model.Title,
Summary = model.Summary,
//MainText = model.MainText,
OrderPosition = model.OrderPosition,
//EnableComments = model.EnableComments,
//EnableRating = model.EnableRating,
ItemGalleryImageFilePaths = new List <ItemGalleryImageFilePath>()
};
var files = new List <IFormFile>()
{
model.Thumbnail,
model.GallaryImage_1,
model.GallaryImage_2,
model.GallaryImage_3,
model.GallaryImage_4,
model.GallaryImage_5
};
var filePaths = FileProcessing.UploadItemGalleryPngs(files, userInfo.ApplicationUser.UserName, newItemId, this, _config, _webHostEnvironment);
var maxImageLimit = Convert.ToInt32(_config.GetSection("FileUploadSettings")["MaxImageStorageLimit"]);
// Allocate space in the DB for this item.
for (int i = 0; i < maxImageLimit; i++)
{
newItem.ItemGalleryImageFilePaths.Add(new ItemGalleryImageFilePath
{
Id = Guid.NewGuid().ToString(), //Id = $"{userInfo.ApplicationUser.UserName}_{model.Title}_Gallery_{i}"
GalleryImageFilePath = filePaths[i] ?? null,
GalleryIndex = i
});
}
model.OrderPosition = userInfo.AchievementCount++;
_userInfoRepo.Update(userInfo);
_achievementRepo.Create(newItem);
return(RedirectToAction("UserResume", new { id = _userManager.GetUserId(User) }));
}
return(View(model));
}
