public static List <ChampionshipMatchTableDetailsModel> getListOfMatchForMyMatches(string typeMyMatches, connectionMySQL db, int teamID, int nationalTeamID, out string returnMessage) { ChampionshipMatchTableDetailsModel modelDetails = new ChampionshipMatchTableDetailsModel(); List <ChampionshipMatchTableDetailsModel> listOfModel = new List <ChampionshipMatchTableDetailsModel>(); DataTable dt = null; string[] paramName = null; string[] paramValue = null; try { paramName = new string[] { "pTypeMyMactches", "pIdTime", "pIdSelecao" }; paramValue = new string[] { typeMyMatches, teamID.ToString(), nationalTeamID.ToString() }; dt = db.executePROC("spGetTabelaJogoAllDetailsForMyMatches", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = new ChampionshipMatchTableDetailsModel(); modelDetails.matchID = Convert.ToInt32(dt.Rows[i]["ID_TABELA_JOGO"].ToString()); modelDetails.championshipID = Convert.ToInt32(dt.Rows[i]["ID_CAMPEONATO"].ToString()); modelDetails.championshipName = dt.Rows[i]["NM_CAMPEONATO"].ToString(); modelDetails.stageID = Convert.ToInt16(dt.Rows[i]["ID_FASE"].ToString()); modelDetails.stageName = dt.Rows[i]["NM_FASE"].ToString(); modelDetails.startDate = Convert.ToDateTime(dt.Rows[i]["DT_TABELA_INICIO_JOGO"].ToString()); modelDetails.endDate = Convert.ToDateTime(dt.Rows[i]["DT_TABELA_FIM_JOGO"].ToString()); modelDetails.teamHomeID = Convert.ToInt16(dt.Rows[i]["ID_TIME_CASA"].ToString()); modelDetails.totalGoalsHome = dt.Rows[i]["QT_GOLS_TIME_CASA"].ToString(); modelDetails.teamAwayID = Convert.ToInt16(dt.Rows[i]["ID_TIME_VISITANTE"].ToString()); modelDetails.totalGoalsAway = dt.Rows[i]["QT_GOLS_TIME_VISITANTE"].ToString(); modelDetails.round = Convert.ToInt16(dt.Rows[i]["IN_NUMERO_RODADA"].ToString()); modelDetails.teamNameHome = dt.Rows[i]["1T"].ToString(); modelDetails.teamTypeHome = dt.Rows[i]["DT1"].ToString(); modelDetails.psnIDHome = dt.Rows[i]["PSN1"].ToString(); modelDetails.teamNameAway = dt.Rows[i]["2T"].ToString(); modelDetails.teamTypeAway = dt.Rows[i]["DT2"].ToString(); modelDetails.psnIDAway = dt.Rows[i]["PSN2"].ToString(); modelDetails.userHomeID = Convert.ToInt32(dt.Rows[i]["ID_USUARIO_TIME_CASA"].ToString()); modelDetails.userAwayID = Convert.ToInt32(dt.Rows[i]["ID_USUARIO_TIME_VISITANTE"].ToString()); listOfModel.Add(modelDetails); } returnMessage = "MyMatchesSuccessfully"; return(listOfModel); } catch (Exception ex) { returnMessage = "Erro na execução da procedure Lista " + typeMyMatches + " My Matches - Próximos Jogos: (" + ex.InnerException.Message + ")";; return(listOfModel); } finally { modelDetails = null; listOfModel = null; dt = null; } }
public IHttpActionResult GetAllForChampionship(string id) { ChampionshipMatchTableDetailsModel modelDetails = new ChampionshipMatchTableDetailsModel(); ChampionshipMatchTableListViewModel mainModel = new ChampionshipMatchTableListViewModel(); List <ChampionshipMatchTableDetailsModel> listOfModel = new List <ChampionshipMatchTableDetailsModel>(); DataTable dt = null; db.openConnection(); int roundStageAux = -10; int roundAux = 0; string roundQualifyDescription = String.Empty; try { if (id.All(char.IsDigit)) { paramName = new string[] { "pIdCamp" }; paramValue = new string[] { id }; dt = db.executePROC("spGetTabelaJogoAllDetailsOfCampeonato", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = GlobalFunctions.setDetailsChampionshipMatchTable(dt.Rows[i]); if (!String.IsNullOrEmpty(dt.Rows[i]["IN_BLACK_LIST"].ToString())) { modelDetails.typeBlackList = dt.Rows[i]["IN_BLACK_LIST"].ToString(); } if ((roundAux != modelDetails.round && modelDetails.stageID == 0) || (roundStageAux != modelDetails.stageID && modelDetails.stageID != 0 && modelDetails.playoffGame == 0) || (modelDetails.playoffGame > 0)) { if (modelDetails.stageID == 0) { roundQualifyDescription = modelDetails.round.ToString("00") + "ª Rodada - "; } else { roundQualifyDescription = String.Empty; } modelDetails.roundDetails = roundQualifyDescription + modelDetails.startDate.ToString("dd/MM") + " (" + modelDetails.startDate.DayOfWeek.ToString().Substring(0, 3) + ") à " + modelDetails.endDate.ToString("dd/MM") + " (" + modelDetails.endDate.DayOfWeek.ToString().Substring(0, 3) + ")"; roundAux = modelDetails.round; roundStageAux = modelDetails.stageID; } listOfModel.Add(modelDetails); } mainModel.listOfMatch = listOfModel; mainModel.returnMessage = "ModeratorSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel)); } else { int i = 0; string[] param = id.Split(Convert.ToChar(";")); paramName = new string[] { "pIdCamp", "pIdJogo" }; paramValue = new string[] { param[0], param[1] }; dt = db.executePROC("spGetTabelaJogoDetailsOfCampeonato", paramName, paramValue); if (dt.Rows.Count > 0) { modelDetails.matchID = Convert.ToInt16(dt.Rows[i]["ID_TABELA_JOGO"].ToString()); modelDetails.championshipID = Convert.ToInt16(dt.Rows[i]["ID_CAMPEONATO"].ToString()); modelDetails.championshipName = dt.Rows[i]["NM_CAMPEONATO"].ToString(); modelDetails.modeType = dt.Rows[i]["TP_CAMPEONATO"].ToString(); modelDetails.stageID = Convert.ToInt16(dt.Rows[i]["ID_FASE"].ToString()); modelDetails.stageName = dt.Rows[i]["NM_FASE"].ToString(); modelDetails.groupID = Convert.ToInt16(dt.Rows[i]["ID_Grupo"].ToString()); if (!String.IsNullOrEmpty(dt.Rows[i]["NM_Grupo"].ToString())) { modelDetails.groupName = dt.Rows[i]["NM_Grupo"].ToString(); } modelDetails.seasonName = dt.Rows[i]["NM_TEMPORADA"].ToString(); modelDetails.startDate = Convert.ToDateTime(dt.Rows[i]["DT_TABELA_INICIO_JOGO"].ToString()); modelDetails.endDate = Convert.ToDateTime(dt.Rows[i]["DT_TABELA_FIM_JOGO"].ToString()); modelDetails.teamHomeID = Convert.ToInt16(dt.Rows[i]["ID_TIME_CASA"].ToString()); modelDetails.totalGoalsHome = dt.Rows[i]["QT_GOLS_TIME_CASA"].ToString(); modelDetails.teamAwayID = Convert.ToInt16(dt.Rows[i]["ID_TIME_VISITANTE"].ToString()); modelDetails.totalGoalsAway = dt.Rows[i]["QT_GOLS_TIME_VISITANTE"].ToString(); if (!String.IsNullOrEmpty(dt.Rows[i]["DT_EFETIVACAO_JOGO"].ToString())) { modelDetails.launchDate = Convert.ToDateTime(dt.Rows[i]["DT_EFETIVACAO_JOGO"].ToString()); } modelDetails.round = Convert.ToInt16(dt.Rows[i]["IN_NUMERO_RODADA"].ToString()); if (!String.IsNullOrEmpty(dt.Rows[i]["IN_JOGO_MATAXMATA"].ToString())) { modelDetails.playoffGame = Convert.ToInt16(dt.Rows[i]["IN_JOGO_MATAXMATA"].ToString()); } modelDetails.teamURLHome = dt.Rows[i]["DS_URL1"].ToString(); modelDetails.teamNameHome = dt.Rows[i]["1T"].ToString(); modelDetails.teamTypeHome = dt.Rows[i]["DT1"].ToString(); modelDetails.userHomeID = Convert.ToInt32(dt.Rows[i]["ID1"].ToString()); modelDetails.userHomeName = dt.Rows[i]["NM_Tecnico_TimeCasa"].ToString(); modelDetails.psnIDHome = dt.Rows[i]["PSN1"].ToString(); modelDetails.teamURLAway = dt.Rows[i]["DS_URL2"].ToString(); modelDetails.teamNameAway = dt.Rows[i]["2T"].ToString(); modelDetails.teamTypeAway = dt.Rows[i]["DT2"].ToString(); modelDetails.userAwayID = Convert.ToInt32(dt.Rows[i]["ID2"].ToString()); modelDetails.userAwayName = dt.Rows[i]["NM_Tecnico_TimeVisitante"].ToString(); modelDetails.psnIDAway = dt.Rows[i]["PSN2"].ToString(); if (modelDetails.stageID == 0) { roundQualifyDescription = modelDetails.round.ToString("00") + "ª Rodada - "; } else { roundQualifyDescription = String.Empty; } modelDetails.roundDetails = roundQualifyDescription + modelDetails.startDate.ToString("dd/MM") + " (" + modelDetails.startDate.DayOfWeek.ToString().Substring(0, 3) + ") à " + modelDetails.endDate.ToString("dd/MM") + " (" + modelDetails.endDate.DayOfWeek.ToString().Substring(0, 3) + ")"; if (!String.IsNullOrEmpty(modelDetails.groupName)) { modelDetails.roundDetails = modelDetails.groupName + " - " + modelDetails.roundDetails; } } modelDetails.returnMessage = "ModeratorSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelDetails)); } } catch (Exception ex) { mainModel = new ChampionshipMatchTableListViewModel(); mainModel.listOfMatch = new List <ChampionshipMatchTableDetailsModel>(); mainModel.returnMessage = "errorGetAllMatchTableForChampionship_" + ex.Message; return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel)); } finally { db.closeConnection(); modelDetails = null; mainModel = null; listOfModel = null; dt = null; } }
public IHttpActionResult ChampionshipMatchTable(ChampionshipMatchTableDetailsModel model) { ChampionshipMatchTableListViewModel mainModel = new ChampionshipMatchTableListViewModel(); ChampionshipMatchTableClashesHistoryTotalswModel modelHistory = new ChampionshipMatchTableClashesHistoryTotalswModel(); ChampionshipMatchTableClashesHistoryTotalsByTeamswModel modelHistoryTeams = new ChampionshipMatchTableClashesHistoryTotalsByTeamswModel(); ChampionshipMatchTableDetailsModel modelDetails = new ChampionshipMatchTableDetailsModel(); db.openConnection(); DataTable dt = null; try { if (model.actionUser.ToLower() == "save_simple_result") { paramName = new string[] { "pIdJogo", "pIdCamp", "pGoalsTimeHome", "pGoalsTimeAway", "pIdUsuAcao", "pPsnIdUsuAcao" }; paramValue = new string[] { Convert.ToString(model.matchID), Convert.ToString(model.championshipID), Convert.ToString(model.totalGoalsHome), Convert.ToString(model.totalGoalsAway), Convert.ToString(model.userIDAction), model.psnIDAction }; dt = db.executePROC("spSaveSimpleResultTabelaJogo", paramName, paramValue); model.returnMessage = "ModeratorSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser.ToLower() == "decree_result") { paramName = new string[] { "pIdJogo", "pIdCamp", "pGoalsTimeHome", "pGoalsTimeAway", "pIdUsuAcao", "pPsnIdUsuAcao", "pMessage", "pSgTpListaNegra" }; paramValue = new string[] { Convert.ToString(model.matchID), Convert.ToString(model.championshipID), Convert.ToString(model.totalGoalsHome), Convert.ToString(model.totalGoalsAway), Convert.ToString(model.userIDAction), model.psnIDAction, model.messageBlackList, model.typeBlackList }; dt = db.executePROC("spDecreeSimpleResultTabelaJogo", paramName, paramValue); model.returnMessage = "ModeratorSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser.ToLower() == "delete_result_launched") { paramName = new string[] { "pIdJogo", "pIdUsuAcao", "pPsnIdUsuAcao" }; paramValue = new string[] { Convert.ToString(model.matchID), Convert.ToString(model.userIDAction), model.psnIDAction }; dt = db.executePROC("spDeleteResultTabelaJogo", paramName, paramValue); model.returnMessage = "ModeratorSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser.ToLower() == "show_historic_each_team") { List <ChampionshipMatchTableDetailsModel> listOfModel = new List <ChampionshipMatchTableDetailsModel>(); paramName = new string[] { "pIdCamp", "pIdTimeCasa", "pIdVisitante", "pTotalRegistroCada" }; paramValue = new string[] { model.championshipID.ToString(), model.teamHomeID.ToString(), model.teamAwayID.ToString(), model.totalRecordsOfHistoric.ToString() }; dt = db.executePROC("spGetAllTabelaJogoAllHistoricoByTimes", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = new ChampionshipMatchTableDetailsModel(); modelDetails.championshipName = dt.Rows[i]["NM_CAMPEONATO"].ToString(); modelDetails.stageID = Convert.ToInt16(dt.Rows[i]["ID_FASE"].ToString()); modelDetails.stageName = dt.Rows[i]["NM_FASE"].ToString(); modelDetails.startDate = Convert.ToDateTime(dt.Rows[i]["DT_TABELA_INICIO_JOGO"].ToString()); modelDetails.endDate = Convert.ToDateTime(dt.Rows[i]["DT_TABELA_FIM_JOGO"].ToString()); modelDetails.teamHomeID = Convert.ToInt16(dt.Rows[i]["ID_TIME_CASA"].ToString()); modelDetails.totalGoalsHome = dt.Rows[i]["QT_GOLS_TIME_CASA"].ToString(); modelDetails.teamAwayID = Convert.ToInt16(dt.Rows[i]["ID_TIME_VISITANTE"].ToString()); modelDetails.totalGoalsAway = dt.Rows[i]["QT_GOLS_TIME_VISITANTE"].ToString(); modelDetails.round = Convert.ToInt16(dt.Rows[i]["IN_NUMERO_RODADA"].ToString()); modelDetails.teamNameHome = dt.Rows[i]["1T"].ToString(); modelDetails.teamTypeHome = dt.Rows[i]["DT1"].ToString(); modelDetails.psnIDHome = dt.Rows[i]["PSN1"].ToString(); modelDetails.teamNameAway = dt.Rows[i]["2T"].ToString(); modelDetails.teamTypeAway = dt.Rows[i]["DT2"].ToString(); modelDetails.psnIDAway = dt.Rows[i]["PSN2"].ToString(); listOfModel.Add(modelDetails); } if (listOfModel != null) { mainModel.listOfMatch = listOfModel; } else { mainModel.listOfMatch = new List <ChampionshipMatchTableDetailsModel>(); } listOfModel = null; mainModel.returnMessage = "ModeratorSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel)); } else if (model.actionUser.ToLower() == "get_clashes_by_team") { List <ChampionshipMatchTableClashesByTeamModel> listOfModel = new List <ChampionshipMatchTableClashesByTeamModel>(); ChampionshipMatchTableClashesByTeamModel modelClashDetails = new ChampionshipMatchTableClashesByTeamModel(); int _teamID = 0; paramName = new string[] { "pIdCamp", "pIdUsu" }; paramValue = new string[] { model.championshipID.ToString(), model.userIDAction.ToString() }; dt = db.executePROC("spGetDetailsMatchesByTimeFromCampeonato", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { if (_teamID != Convert.ToInt32(dt.Rows[i]["ID_TIME"].ToString())) { if (_teamID > 0) { listOfModel.Add(modelClashDetails); } modelClashDetails = new ChampionshipMatchTableClashesByTeamModel(); modelClashDetails.userID = model.userIDAction; modelClashDetails.championshipID = model.championshipID; modelClashDetails.teamID = Convert.ToInt32(dt.Rows[i]["ID_TIME"].ToString()); modelClashDetails.teamName = dt.Rows[i]["NM_TIME"].ToString(); modelClashDetails.nextMatchID = Convert.ToInt32(dt.Rows[i]["ID_TABELA_JOGO_NEXT_MATCH"].ToString()); _teamID = modelClashDetails.teamID; } //modelClashDetails = new ChampionshipMatchTableClashesByTeamModel(); if (dt.Rows[i]["ID_ROUND"].ToString() == "0") { modelClashDetails.nextMatchTeamID = Convert.ToInt32(dt.Rows[i]["ID_TIME_NEXT_MATCH"].ToString()); modelClashDetails.nextMatchTeamName = dt.Rows[i]["NM_TIME_NEXT_MATCH"].ToString(); modelClashDetails.descriptionNextMatch = dt.Rows[i]["DS_MATCTH_1"].ToString(); } else if (dt.Rows[i]["ID_ROUND"].ToString() == "1") { modelClashDetails.descriptionPreviousMatch1_1 = dt.Rows[i]["DS_MATCTH_1"].ToString(); modelClashDetails.descriptionPreviousMatch1_2 = dt.Rows[i]["DS_MATCTH_2"].ToString(); modelClashDetails.descriptionPreviousMatch1_3 = dt.Rows[i]["DS_MATCTH_3"].ToString(); modelClashDetails.descriptionPreviousMatch1_4 = dt.Rows[i]["DS_MATCTH_4"].ToString(); modelClashDetails.statusPreviousMatch1 = dt.Rows[i]["STATUS_MATCTH"].ToString(); modelClashDetails.prevMatchID1 = Convert.ToInt32(dt.Rows[i]["ID_TABELA_JOGO_PREV_MATCH"].ToString()); } else if (dt.Rows[i]["ID_ROUND"].ToString() == "2") { modelClashDetails.descriptionPreviousMatch2_1 = dt.Rows[i]["DS_MATCTH_1"].ToString(); modelClashDetails.descriptionPreviousMatch2_2 = dt.Rows[i]["DS_MATCTH_2"].ToString(); modelClashDetails.descriptionPreviousMatch2_3 = dt.Rows[i]["DS_MATCTH_3"].ToString(); modelClashDetails.descriptionPreviousMatch2_4 = dt.Rows[i]["DS_MATCTH_4"].ToString(); modelClashDetails.statusPreviousMatch2 = dt.Rows[i]["STATUS_MATCTH"].ToString(); modelClashDetails.prevMatchID2 = Convert.ToInt32(dt.Rows[i]["ID_TABELA_JOGO_PREV_MATCH"].ToString()); } else if (dt.Rows[i]["ID_ROUND"].ToString() == "3") { modelClashDetails.descriptionPreviousMatch3_1 = dt.Rows[i]["DS_MATCTH_1"].ToString(); modelClashDetails.descriptionPreviousMatch3_2 = dt.Rows[i]["DS_MATCTH_2"].ToString(); modelClashDetails.descriptionPreviousMatch3_3 = dt.Rows[i]["DS_MATCTH_3"].ToString(); modelClashDetails.descriptionPreviousMatch3_4 = dt.Rows[i]["DS_MATCTH_4"].ToString(); modelClashDetails.statusPreviousMatch3 = dt.Rows[i]["STATUS_MATCTH"].ToString(); modelClashDetails.prevMatchID3 = Convert.ToInt32(dt.Rows[i]["ID_TABELA_JOGO_PREV_MATCH"].ToString()); } //listOfModel.Add(modelClashDetails); } if (dt.Rows.Count > 0) { listOfModel.Add(modelClashDetails); } if (listOfModel != null) { mainModel.listOfClashes = listOfModel; } else { mainModel.listOfClashes = new List <ChampionshipMatchTableClashesByTeamModel>(); } listOfModel = null; modelClashDetails = null; mainModel.returnMessage = "ModeratorSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel)); } else if (model.actionUser.ToLower() == "clashes_historic_by_coaches") { paramName = new string[] { "pType", "pIdUsuLogged", "pPsnIDSearch" }; paramValue = new string[] { model.modeType, model.userIDAction.ToString(), model.psnIDSearch }; dt = db.executePROC("spGetTotalsClashesHistory", paramName, paramValue); if (dt.Rows.Count > 0) { if (dt.Rows[0]["errorID"].ToString() == "0") { modelHistory.userIDLogged = model.userIDAction; modelHistory.psnIDLogged = model.psnIDAction; modelHistory.userIDSearch = Convert.ToInt32(dt.Rows[0]["idUsuSearch"].ToString()); modelHistory.psnIDSearch = model.psnIDSearch; modelHistory.totalWinUsuLogged = Convert.ToInt16(dt.Rows[0]["totalWinUsuLogged"].ToString()); modelHistory.totalWinUsuSearch = Convert.ToInt16(dt.Rows[0]["totalWinUsuSearch"].ToString()); modelHistory.totalDraw = Convert.ToInt16(dt.Rows[0]["totalDraw"].ToString()); modelHistory.totalLossUsuLogged = Convert.ToInt16(dt.Rows[0]["totalLossUsuLogged"].ToString()); modelHistory.totalLossUsuSearch = Convert.ToInt16(dt.Rows[0]["totalLossUsuSearch"].ToString()); modelHistory.totalGoalsUsuLogged = Convert.ToInt16(dt.Rows[0]["totalGoalsUsuLogged"].ToString()); modelHistory.totalGoalsUsuSearch = Convert.ToInt16(dt.Rows[0]["totalGoalsUsuSearch"].ToString()); modelHistory.returnMessage = "ModeratorSuccessfully"; modelHistory.listOfMatchDraw = new List <ChampionshipMatchTableDetailsModel>(); modelHistory.listOfMatchWinUsuLogged = new List <ChampionshipMatchTableDetailsModel>(); modelHistory.listOfMatchWinUsuSearch = new List <ChampionshipMatchTableDetailsModel>(); paramName = new string[] { "pType", "pIdUsuLogged", "pIdUsuSearch" }; paramValue = new string[] { model.modeType, modelHistory.userIDLogged.ToString(), modelHistory.userIDSearch.ToString() }; dt = db.executePROC("spGetAllClashesHistory", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = GlobalFunctions.setDetailsChampionshipMatchTable(dt.Rows[i]); if (modelDetails.totalGoalsHome == modelDetails.totalGoalsAway) { modelHistory.listOfMatchDraw.Add(modelDetails); } else if (Convert.ToInt16(modelDetails.totalGoalsHome) > Convert.ToInt16(modelDetails.totalGoalsAway) && modelDetails.userHomeID == modelHistory.userIDLogged) { modelHistory.listOfMatchWinUsuLogged.Add(modelDetails); } else if (Convert.ToInt16(modelDetails.totalGoalsHome) > Convert.ToInt16(modelDetails.totalGoalsAway) && modelDetails.userHomeID == modelHistory.userIDSearch) { modelHistory.listOfMatchWinUsuSearch.Add(modelDetails); } else if (Convert.ToInt16(modelDetails.totalGoalsHome) < Convert.ToInt16(modelDetails.totalGoalsAway) && modelDetails.userAwayID == modelHistory.userIDLogged) { modelHistory.listOfMatchWinUsuLogged.Add(modelDetails); } else if (Convert.ToInt16(modelDetails.totalGoalsHome) < Convert.ToInt16(modelDetails.totalGoalsAway) && modelDetails.userAwayID == modelHistory.userIDSearch) { modelHistory.listOfMatchWinUsuSearch.Add(modelDetails); } } } else { modelHistory.returnMessage = "PsnIDSearchNotFound"; } } return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelHistory)); } else if (model.actionUser.ToLower() == "clashes_historic_by_teams") { paramName = new string[] { "pType", "pIdTimeHome", "pIdTimeAway" }; paramValue = new string[] { model.modeType, model.teamHomeID.ToString(), model.teamAwayID.ToString() }; dt = db.executePROC("spGetTotalsClashesHistoryByTimes", paramName, paramValue); if (dt.Rows.Count > 0) { modelHistoryTeams.teamIDHome = model.teamHomeID; modelHistoryTeams.teamIDAway = model.teamAwayID; modelHistoryTeams.teamNameHome = dt.Rows[0]["nmTimeHome"].ToString(); modelHistoryTeams.teamNameAway = dt.Rows[0]["nmTimeAway"].ToString(); modelHistoryTeams.totalDraw = Convert.ToInt16(dt.Rows[0]["totalDraw"].ToString()); modelHistoryTeams.totalWinTeamHome = Convert.ToInt16(dt.Rows[0]["totalWinUsuLogged"].ToString()); modelHistoryTeams.totalWinTeamAway = Convert.ToInt16(dt.Rows[0]["totalWinUsuSearch"].ToString()); modelHistoryTeams.totalLossTeamHome = Convert.ToInt16(dt.Rows[0]["totalLossUsuLogged"].ToString()); modelHistoryTeams.totalLossTeamAway = Convert.ToInt16(dt.Rows[0]["totalLossUsuSearch"].ToString()); modelHistoryTeams.totalGoalsTeamHome = Convert.ToInt16(dt.Rows[0]["totalGoalsUsuLogged"].ToString()); modelHistoryTeams.totalGoalsTeamAway = Convert.ToInt16(dt.Rows[0]["totalGoalsUsuSearch"].ToString()); modelHistoryTeams.returnMessage = "ModeratorSuccessfully"; modelHistoryTeams.listOfMatchDraw = new List <ChampionshipMatchTableDetailsModel>(); modelHistoryTeams.listOfMatchWinTeamHome = new List <ChampionshipMatchTableDetailsModel>(); modelHistoryTeams.listOfMatchWinTeamAway = new List <ChampionshipMatchTableDetailsModel>(); paramName = new string[] { "pType", "pIdTimeHome", "pIdTimeAway" }; paramValue = new string[] { model.modeType, model.teamHomeID.ToString(), model.teamAwayID.ToString() }; dt = db.executePROC("spGetAllClashesHistoryByTeams", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = GlobalFunctions.setDetailsChampionshipMatchTable(dt.Rows[i]); if (modelDetails.totalGoalsHome == modelDetails.totalGoalsAway) { modelHistoryTeams.listOfMatchDraw.Add(modelDetails); } else if (Convert.ToInt16(modelDetails.totalGoalsHome) > Convert.ToInt16(modelDetails.totalGoalsAway) && modelDetails.teamHomeID == modelHistoryTeams.teamIDHome) { modelHistoryTeams.listOfMatchWinTeamHome.Add(modelDetails); } else if (Convert.ToInt16(modelDetails.totalGoalsHome) > Convert.ToInt16(modelDetails.totalGoalsAway) && modelDetails.teamHomeID == modelHistoryTeams.teamIDAway) { modelHistoryTeams.listOfMatchWinTeamAway.Add(modelDetails); } else if (Convert.ToInt16(modelDetails.totalGoalsHome) < Convert.ToInt16(modelDetails.totalGoalsAway) && modelDetails.teamAwayID == modelHistoryTeams.teamIDHome) { modelHistoryTeams.listOfMatchWinTeamHome.Add(modelDetails); } else if (Convert.ToInt16(modelDetails.totalGoalsHome) < Convert.ToInt16(modelDetails.totalGoalsAway) && modelDetails.teamAwayID == modelHistoryTeams.teamIDAway) { modelHistoryTeams.listOfMatchWinTeamAway.Add(modelDetails); } } } return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelHistoryTeams)); } else { return(StatusCode(HttpStatusCode.NotAcceptable)); } } catch (Exception ex) { model.returnMessage = "errorPostChampionshipMatchTable_" + ex.Message; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } finally { db.closeConnection(); dt = null; mainModel = null; modelDetails = null; modelHistory = null; modelHistoryTeams = null; } }
public static ChampionshipMatchTableDetailsModel setDetailsChampionshipMatchTable(DataRow rowMatchTable) { ChampionshipMatchTableDetailsModel modelDetails = new ChampionshipMatchTableDetailsModel(); try { modelDetails = new ChampionshipMatchTableDetailsModel(); modelDetails.matchID = Convert.ToInt16(rowMatchTable["ID_TABELA_JOGO"].ToString()); modelDetails.championshipID = Convert.ToInt16(rowMatchTable["ID_CAMPEONATO"].ToString()); modelDetails.championshipName = rowMatchTable["NM_CAMPEONATO"].ToString(); modelDetails.stageID = Convert.ToInt16(rowMatchTable["ID_FASE"].ToString()); modelDetails.stageName = rowMatchTable["NM_FASE"].ToString(); modelDetails.groupID = Convert.ToInt16(rowMatchTable["ID_Grupo"].ToString()); if (!String.IsNullOrEmpty(rowMatchTable["NM_Grupo"].ToString())) { modelDetails.groupName = rowMatchTable["NM_Grupo"].ToString(); } modelDetails.seasonName = rowMatchTable["NM_TEMPORADA"].ToString(); modelDetails.startDate = Convert.ToDateTime(rowMatchTable["DT_TABELA_INICIO_JOGO"].ToString()); modelDetails.endDate = Convert.ToDateTime(rowMatchTable["DT_TABELA_FIM_JOGO"].ToString()); modelDetails.teamHomeID = Convert.ToInt16(rowMatchTable["ID_TIME_CASA"].ToString()); modelDetails.totalGoalsHome = rowMatchTable["QT_GOLS_TIME_CASA"].ToString(); modelDetails.teamAwayID = Convert.ToInt16(rowMatchTable["ID_TIME_VISITANTE"].ToString()); modelDetails.totalGoalsAway = rowMatchTable["QT_GOLS_TIME_VISITANTE"].ToString(); if (!String.IsNullOrEmpty(rowMatchTable["DT_EFETIVACAO_JOGO"].ToString())) { modelDetails.launchDate = Convert.ToDateTime(rowMatchTable["DT_EFETIVACAO_JOGO"].ToString()); } modelDetails.round = Convert.ToInt16(rowMatchTable["IN_NUMERO_RODADA"].ToString()); if (!String.IsNullOrEmpty(rowMatchTable["IN_JOGO_MATAXMATA"].ToString())) { modelDetails.playoffGame = Convert.ToInt16(rowMatchTable["IN_JOGO_MATAXMATA"].ToString()); } modelDetails.teamURLHome = rowMatchTable["DS_URL1"].ToString(); modelDetails.teamNameHome = rowMatchTable["1T"].ToString(); modelDetails.teamTypeHome = rowMatchTable["DT1"].ToString(); if (!String.IsNullOrEmpty(rowMatchTable["ID_USUARIO_TIME_CASA"].ToString())) { modelDetails.userHomeID = Convert.ToInt32(rowMatchTable["ID_USUARIO_TIME_CASA"].ToString()); modelDetails.psnIDHome = rowMatchTable["NM_Tecnico_TimeCasa"].ToString(); modelDetails.userHomeName = rowMatchTable["NM_Tecnico_TimeCasa"].ToString(); if (String.IsNullOrEmpty(modelDetails.psnIDHome)) { modelDetails.psnIDHome = rowMatchTable["PSN1"].ToString(); modelDetails.userHomeName = rowMatchTable["PSN1"].ToString(); } } else { modelDetails.userHomeID = Convert.ToInt32(rowMatchTable["IDUSU1"].ToString()); modelDetails.psnIDHome = rowMatchTable["PSN1"].ToString(); modelDetails.userHomeName = rowMatchTable["PSN1"].ToString(); } modelDetails.teamURLAway = rowMatchTable["DS_URL2"].ToString(); modelDetails.teamNameAway = rowMatchTable["2T"].ToString(); modelDetails.teamTypeAway = rowMatchTable["DT2"].ToString(); if (!String.IsNullOrEmpty(rowMatchTable["ID_USUARIO_TIME_VISITANTE"].ToString())) { modelDetails.userAwayID = Convert.ToInt32(rowMatchTable["ID_USUARIO_TIME_VISITANTE"].ToString()); modelDetails.psnIDAway = rowMatchTable["NM_Tecnico_TimeVisitante"].ToString(); modelDetails.userAwayName = rowMatchTable["NM_Tecnico_TimeVisitante"].ToString(); if (String.IsNullOrEmpty(modelDetails.psnIDAway)) { modelDetails.psnIDAway = rowMatchTable["PSN2"].ToString(); modelDetails.userAwayName = rowMatchTable["PSN2"].ToString(); } } else { modelDetails.userAwayID = Convert.ToInt32(rowMatchTable["IDUSU2"].ToString()); modelDetails.psnIDAway = rowMatchTable["PSN2"].ToString(); modelDetails.userAwayName = rowMatchTable["PSN2"].ToString(); } if (DateTime.Now.Date >= modelDetails.startDate) { modelDetails.launchResultReleased = true; } else { modelDetails.launchResultReleased = false; } return(modelDetails); } catch (Exception ex) { return(modelDetails); } finally { modelDetails = null; } }