private void SetBlackListSummarySeason(DataTable dt, BlackListViewModel blackListDetails)
{
List <BlackListSummary> listOfBlackList = new List <BlackListSummary>();
BlackListSummary summaryDetails = new BlackListSummary();
blackListDetails.seasonID = Convert.ToInt16(dt.Rows[0]["ID_TEMPORADA"].ToString());
blackListDetails.dtUpdateFormated = dt.Rows[0]["DT_FORMATADA"].ToString();
blackListDetails.seasonName = dt.Rows[0]["NM_TEMPORADA"].ToString();
for (var i = 0; i < dt.Rows.Count; i++)
{
summaryDetails = new BlackListSummary();
summaryDetails.userID = Convert.ToInt32(dt.Rows[i]["ID_USUARIO"].ToString());
summaryDetails.psnID = dt.Rows[i]["PSN_ID"].ToString();
summaryDetails.nameUser = dt.Rows[i]["NM_USUARIO"].ToString();
summaryDetails.noWarning = Convert.ToInt16(dt.Rows[i]["QT_ADVERTENCIAS"].ToString());
summaryDetails.noPartialOmission = Convert.ToInt16(dt.Rows[i]["QT_OMISSAO_PARCIAL"].ToString());
summaryDetails.noTotalOmission = Convert.ToInt16(dt.Rows[i]["QT_OMISSAO_TOTAL"].ToString());
summaryDetails.noUnsportsmanlike = Convert.ToInt16(dt.Rows[i]["QT_ANTIDESPORTIVA"].ToString());
summaryDetails.total = Convert.ToInt16(dt.Rows[i]["PT_TOTAL"].ToString());
listOfBlackList.Add(summaryDetails);
}
blackListDetails.listSummary = listOfBlackList;
listOfBlackList = null;
summaryDetails = null;
}
private void SetBlackListDetailsSeason(DataTable dt, BlackListViewModel blackListDetails)
{
List <BlackListDetails> listOfBlackList = new List <BlackListDetails>();
BlackListDetails summaryDetails = new BlackListDetails();
blackListDetails.seasonID = Convert.ToInt16(dt.Rows[0]["ID_TEMPORADA"].ToString());
blackListDetails.userID = Convert.ToInt16(dt.Rows[0]["ID_USUARIO"].ToString());
blackListDetails.dtUpdateFormated = dt.Rows[0]["DT_FORMATADA"].ToString();
blackListDetails.seasonName = dt.Rows[0]["NM_TEMPORADA"].ToString();
blackListDetails.psnID = dt.Rows[0]["PSN_ID"].ToString();
blackListDetails.nameUser = dt.Rows[0]["NM_USUARIO"].ToString();
for (var i = 0; i < dt.Rows.Count; i++)
{
summaryDetails = new BlackListDetails();
summaryDetails.matchID = Convert.ToInt16(dt.Rows[i]["ID_TABELA_JOGO"].ToString());
summaryDetails.championshipID = Convert.ToInt16(dt.Rows[i]["ID_CAMPEONATO"].ToString());
summaryDetails.championshipName = dt.Rows[i]["NM_CAMPEONATO"].ToString();
summaryDetails.stageName = dt.Rows[i]["NM_FASE"].ToString();
summaryDetails.typeMode = dt.Rows[i]["TYPE_MODE"].ToString();
summaryDetails.roundID = Convert.ToInt16(dt.Rows[i]["IN_NUMERO_RODADA"].ToString());
summaryDetails.noWarning = Convert.ToInt16(dt.Rows[i]["IN_ADVERTENCIAS"].ToString());
summaryDetails.noPartialOmission = Convert.ToInt16(dt.Rows[i]["IN_OMISSAO_PARCIAL"].ToString());
summaryDetails.noTotalOmission = Convert.ToInt16(dt.Rows[i]["IN_OMISSAO_TOTAL"].ToString());
summaryDetails.noUnsportsmanlike = Convert.ToInt16(dt.Rows[i]["IN_ANTIDESPORTIVA"].ToString());
summaryDetails.valueBlackList = Convert.ToInt16(dt.Rows[i]["PT_NEGATIVO"].ToString());
listOfBlackList.Add(summaryDetails);
}
blackListDetails.listDetails = listOfBlackList;
listOfBlackList = null;
summaryDetails = null;
}
public ActionResult BlackListDetails(FormCollection formHTML)
{
HttpResponseMessage response = null;
BlackListViewModel modelReturnJSON = null;
BlackListViewModel model = new BlackListViewModel();
try
{
model.actionUser = "******";
model.seasonID = Convert.ToInt16(formHTML["seasonID"]);
model.userID = Convert.ToInt16(formHTML["userID"]);
response = GlobalVariables.WebApiClient.PostAsJsonAsync("BlackList", model).Result;
modelReturnJSON = response.Content.ReadAsAsync <BlackListViewModel>().Result;
switch (response.StatusCode)
{
case HttpStatusCode.Created:
if (modelReturnJSON.returnMessage == "BlackListSuccessfully")
{
return(View(modelReturnJSON));
}
else
{
TempData["returnMessage"] = "Ocorreu algum erro na exibição do detalhe da Lista Negra. (" + modelReturnJSON.returnMessage + ")";
return(View(modelReturnJSON));
}
default:
TempData["returnMessage"] = "Ocorreu algum erro na exibição do detalhe da Lista Negra. (" + response.StatusCode + ")";
ModelState.AddModelError("", "application error.");
return(View(modelReturnJSON));
}
}
catch (Exception ex)
{
TempData["returnMessage"] = "Erro interno - Exibição do detalhe da Lista Negra: (" + ex.InnerException.Message + ")";
ModelState.AddModelError("", "application error.");
return(View(model));
}
finally
{
response = null;
modelReturnJSON = null;
model = null;
}
}
// GET: BlackLists/Edit/5
public IActionResult Edit(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
Blacklist blacklist = _context.BlackLists.Single(m => m.Id == id);
if (blacklist == null)
{
return(HttpNotFound());
}
return(View(BlackListViewModel.Create(blacklist)));
}
public ActionResult RankingSupporters()
{
HttpResponseMessage response = null;
RankingSupportersModel modelReturnJSON = null;
BlackListViewModel model = new BlackListViewModel();
try
{
model.actionUser = "******";
response = GlobalVariables.WebApiClient.PostAsJsonAsync("HomeUser", model).Result;
modelReturnJSON = response.Content.ReadAsAsync <RankingSupportersModel>().Result;
switch (response.StatusCode)
{
case HttpStatusCode.Created:
if (modelReturnJSON.returnMessage == "rankingSuccessfully")
{
return(View(modelReturnJSON));
}
else
{
TempData["returnMessage"] = "Ocorreu algum erro na exibição do Ranking das Torcidas do Arena. (" + modelReturnJSON.returnMessage + ")";
return(View(modelReturnJSON));
}
default:
TempData["returnMessage"] = "Ocorreu algum erro na exibição do Ranking das Torcidas do Arena. (" + response.StatusCode + ")";
ModelState.AddModelError("", "application error.");
return(View(modelReturnJSON));
}
}
catch (Exception ex)
{
TempData["returnMessage"] = "Erro interno - Exibição do Ranking das Torcidas do Arena: (" + ex.InnerException.Message + ")";
ModelState.AddModelError("", "application error.");
return(View(model));
}
finally
{
response = null;
modelReturnJSON = null;
model = null;
}
}
public IActionResult Edit(BlackListViewModel model)
{
if (ModelState.IsValid)
{
var item = new Blacklist
{
Id = model.Id,
Description = model.Description,
PhoneNumber = model.PhoneNumber,
User = CurrentUser
};
_context.Update(item);
_context.SaveChanges();
var editUrl = Url.Action("Edit", new { id = model.Id });
SuccessMessage($"<a href=\"{editUrl}\">Запись</a> была успешно изменена");
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult BlackList()
{
List <KaraListeDTO> list = _aracService.GetBlackList();
List <BlackListViewModel> blackList = new List <BlackListViewModel>();
foreach (var item in list)
{
BlackListViewModel black = new BlackListViewModel();
black.ID = item.ID;
black.Aciklama = item.Aciklama;
AracDTO arac = _aracService.Car(Convert.ToInt32(item.AracID));
AracMarkaDTO marka = _aracService.Brand(Convert.ToInt32(arac.MarkaID));
AracModelDTO model = _aracService.Model(Convert.ToInt32(arac.ModelID));
black.Marka = marka.Marka;
black.Model = model.Model;
black.Plaka = arac.Plaka;
blackList.Add(black);
}
return(View(blackList));
}
public IHttpActionResult blackList(BlackListViewModel model)
{
db.openConnection();
DataTable dt = null;
Boolean bActionUser = false;
try
{
if (model.actionUser == "summaryList")
{
paramName = new string[] { "pIdTemp" };
paramValue = new string[] { Convert.ToString(model.seasonID) };
dt = db.executePROC("spGetListaNegraSummaryByTemporada", paramName, paramValue);
SetBlackListSummarySeason(dt, model);
bActionUser = true;
}
else if (model.actionUser == "detailsList")
{
paramName = new string[] { "pIdTemp", "pIdUsu" };
paramValue = new string[] { Convert.ToString(model.seasonID), Convert.ToString(model.userID) };
dt = db.executePROC("spGetListaNegraDetalheByTemporadaEUsuario", paramName, paramValue);
SetBlackListDetailsSeason(dt, model);
bActionUser = true;
}
else if (model.actionUser == "delete_by_match")
{
paramName = new string[] { "pIdJogo" };
paramValue = new string[] { model.matchID.ToString() };
dt = db.executePROC("spRemoveListaNegraByJogo", paramName, paramValue);
if (dt.Rows.Count > 0)
{
model.messageBlackList = dt.Rows[0]["DSC_COMENTARIO_RETIRADA_LISTA_NEGRA"].ToString();
}
bActionUser = true;
}
else if (model.actionUser == "add_by_match")
{
paramName = new string[] { "pIdTemp", "pIdCamp", "pIdUsu", "pIdJogo", "pSgTpListaNegra" };
paramValue = new string[] { model.seasonID.ToString(), model.championshipID.ToString(), model.userID.ToString(), model.matchID.ToString(), model.messageBlackList };
dt = db.executePROC("spAddListaNegra", paramName, paramValue);
bActionUser = true;
}
else if (model.actionUser == "get_by_match_user")
{
paramName = new string[] { "pIdUsu", "pIdJogo" };
paramValue = new string[] { model.userID.ToString(), model.matchID.ToString() };
dt = db.executePROC("spGetListaNegraDetalheByJogo", paramName, paramValue);
if (dt.Rows.Count == 0)
{
model.valueBlackList = 0;
model.messageBlackList = String.Empty;
}
else if (Convert.ToInt16(dt.Rows[0]["IN_ADVERTENCIAS"].ToString()) == 1)
{
model.valueBlackList = Convert.ToInt16(ConfigurationManager.AppSettings["black.list.warning"].ToString());
model.messageBlackList = "Advertência<br>(" + dt.Rows[0]["PT_NEGATIVO"].ToString() + " ponto negativo)";
}
else if (Convert.ToInt16(dt.Rows[0]["IN_OMISSAO_PARCIAL"].ToString()) == 1)
{
model.valueBlackList = Convert.ToInt16(ConfigurationManager.AppSettings["black.list.partial.omission"].ToString());
model.messageBlackList = "Omissão Parcial<br>(" + dt.Rows[0]["PT_NEGATIVO"].ToString() + " pontos negativos)";
}
else if (Convert.ToInt16(dt.Rows[0]["IN_ANTIDESPORTIVA"].ToString()) == 1)
{
model.valueBlackList = Convert.ToInt16(ConfigurationManager.AppSettings["black.list.unsportsmanlike"].ToString());
model.messageBlackList = "Atitude Antidesportiva<br>(" + dt.Rows[0]["PT_NEGATIVO"].ToString() + " pontos negativos)";
}
else if (Convert.ToInt16(dt.Rows[0]["IN_OMISSAO_TOTAL"].ToString()) == 1)
{
model.valueBlackList = Convert.ToInt16(ConfigurationManager.AppSettings["black.list.total.omission"].ToString());
model.messageBlackList = "Omissão Total<br>(" + dt.Rows[0]["PT_NEGATIVO"].ToString() + " pontos negativos)";
}
bActionUser = true;
}
if (bActionUser)
{
model.returnMessage = "BlackListSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
else
{
return(StatusCode(HttpStatusCode.NotAcceptable));
}
}
catch (Exception ex)
{
model = new BlackListViewModel();
model.returnMessage = "error_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
finally
{
db.closeConnection();
dt = null;
}
}
