public static List <listScorers> getListScorers(string typeMode, connectionMySQL db, int userID = 0, Boolean isSummary = true, int championshiID = 0) { List <listScorers> modelList = new List <listScorers>(); listScorers listScorers = new listScorers(); DataTable dt = null; string[] paramName = null; string[] paramValue = null; string returnMessage = String.Empty; try { paramName = new string[] { "pMode", "pIdUsu", "pInSummary", "pIdCamp" }; paramValue = new string[] { typeMode, userID.ToString(), isSummary.ToString() + ";[BOOLEAN-TYPE]", championshiID.ToString() }; dt = db.executePROC("spGetSummaryRankingListScorers", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { listScorers = new listScorers(); listScorers.playerID = Convert.ToInt32(dt.Rows[i]["ID_GOLEADOR"].ToString()); listScorers.playerName = dt.Rows[i]["NM_GOLEADOR"].ToString(); listScorers.playerFullName = dt.Rows[i]["NM_GOLEADOR_COMPLETO"].ToString(); listScorers.psnID = dt.Rows[i]["PSN_ID"].ToString(); if (!String.IsNullOrEmpty(dt.Rows[i]["DS_Tipo"].ToString())) { listScorers.teamName = dt.Rows[i]["NM_TIME"].ToString() + "-" + dt.Rows[i]["DS_Tipo"].ToString(); } else { listScorers.teamName = dt.Rows[i]["NM_TIME"].ToString(); } listScorers.totalGoals = Convert.ToInt16(dt.Rows[i]["QT_GOLS_MARCADOS"].ToString()); modelList.Add(listScorers); } return(modelList); } catch (Exception ex) { returnMessage = "Erro na execução da procedure Lista de Artilheiros " + typeMode + ": (" + ex.InnerException.Message + ")";; modelList = new List <listScorers>(); return(modelList); } finally { modelList = null; listScorers = null; dt = null; } }
public static List <squadListModel> getListOfSquadPROCLUB(connectionMySQL db, int seasonID, int managerID, out string returnMessage) { squadListModel modelDetails = new squadListModel(); List <squadListModel> listOfModel = new List <squadListModel>(); DataTable dt = null; string[] paramName = null; string[] paramValue = null; try { paramName = new string[] { "pIdTemporada", "pIdManager" }; paramValue = new string[] { seasonID.ToString(), managerID.ToString() }; dt = db.executePROC("spGetAllSquadOfClub", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = new squadListModel(); modelDetails.playerID = Convert.ToInt32(dt.Rows[i]["ID_GOLEADOR"].ToString()); modelDetails.userID = Convert.ToInt32(dt.Rows[i]["ID_USUARIO"].ToString()); modelDetails.userName = dt.Rows[i]["NM_USUARIO"].ToString(); modelDetails.psnID = dt.Rows[i]["PSN_ID"].ToString(); if (modelDetails.userID == managerID) { modelDetails.isCapitain = true; } modelDetails.recordDate = dt.Rows[i]["DT_CONFIRMACAO_FORMATADA"].ToString(); listOfModel.Add(modelDetails); } returnMessage = "MyMatchesSuccessfully"; return(listOfModel); } catch (Exception ex) { returnMessage = "Erro na execução da procedure Lista de Elencos do clube para a modalidade PRO CLUB: (" + ex.InnerException.Message + ")";; return(listOfModel); } finally { modelDetails = null; listOfModel = null; dt = null; } }
private AcceptingDetails GetAccepting(connectionMySQL db, int seasonID, int userID, int championshipID) { AcceptingDetails modelDetails = new AcceptingDetails(); DataTable dt = null; try { modelDetails.seasonID = seasonID; modelDetails.userID = userID; modelDetails.championshipID = championshipID; paramName = new string[] { "pIdTemporada", "pIdCampeonato", "pIdUsu" }; paramValue = new string[] { Convert.ToString(modelDetails.seasonID), Convert.ToString(modelDetails.championshipID), Convert.ToString(modelDetails.userID) }; dt = db.executePROC("spGetConfirmacaoTemporada", paramName, paramValue); if (dt.Rows.Count > 0) { modelDetails.confirmation = dt.Rows[0]["IN_CONFIRMACAO"].ToString(); modelDetails.ordering = dt.Rows[0]["IN_ORDENACAO"].ToString(); modelDetails.DateconfirmationFormatted = dt.Rows[0]["DT_CONFIRMACAO_FORMATADA"].ToString(); modelDetails.psnID = dt.Rows[0]["PSN_ID"].ToString(); modelDetails.teamName = dt.Rows[0]["NM_TIME"].ToString(); modelDetails.statusID = dt.Rows[0]["DS_Status"].ToString(); modelDetails.statusDescription = dt.Rows[0]["DS_Descricao_Status"].ToString(); } return(modelDetails); } catch (Exception ex) { return(modelDetails); } finally { dt = null; modelDetails = null; } }
private void getSummaryDetails(ref GenerateRenewalViewModel model, connectionMySQL db, Boolean bOpenConection = false) { DataTable dt = null; string returnMessage = String.Empty; connectionMySQL dbNew = new DBConnection.connectionMySQL(); if (bOpenConection == true) { dbNew.openConnection(GlobalVariables.DATABASE_NAME_ONLINE); } else { dbNew = db; } try { paramName = new string[] { }; paramValue = new string[] { }; dt = dbNew.executePROC("spGetSummaryGenerateRenwal", paramName, paramValue); model.seasonH2HID = Convert.ToInt16(dt.Rows[0]["seasonH2HID"].ToString()); model.seasonH2HName = dt.Rows[0]["seasonH2HName"].ToString(); model.seasonFUTID = Convert.ToInt16(dt.Rows[0]["seasonFUTID"].ToString()); model.seasonFUTName = dt.Rows[0]["seasonFUTName"].ToString(); model.seasonPROID = Convert.ToInt16(dt.Rows[0]["seasonPROID"].ToString()); model.seasonPROName = dt.Rows[0]["seasonPROName"].ToString(); model.totalUsersBcoOnLine = Convert.ToInt16(dt.Rows[0]["totalUsersBcoOnLine"].ToString()); model.totalUsersBcoStaging = Convert.ToInt16(dt.Rows[0]["totalUsersBcoStaging"].ToString()); model.lastSeasonH2HID = Convert.ToInt16(dt.Rows[0]["lastSeasonH2HID"].ToString()); model.lastSeasonH2HName = dt.Rows[0]["lastSeasonH2HName"].ToString(); model.lastSeasonFUTID = Convert.ToInt16(dt.Rows[0]["lastSeasonFUTID"].ToString()); model.lastSeasonFUTName = dt.Rows[0]["lastSeasonFUTName"].ToString(); model.lastSeasonPROID = Convert.ToInt16(dt.Rows[0]["lastSeasonPROID"].ToString()); model.lastSeasonPROName = dt.Rows[0]["lastSeasonPROName"].ToString(); model.totalUserRenewalForNextSeason = Convert.ToInt16(dt.Rows[0]["totalUsersRenewal"].ToString()); model.totalEmailSpoolerForRenewal = Convert.ToInt16(dt.Rows[0]["totalEmailsRenewal"].ToString()); if (dt.Rows[0]["totalSpoolerEmails"].ToString() == "1") { model.emailsSent = true; } else { model.emailsSent = false; } if (dt.Rows[0]["totalRenewals"].ToString() != "0") { model.renewalNewSeasonGenerated = true; } else { model.renewalNewSeasonGenerated = false; } if (dt.Rows[0]["isPreparedBefore"].ToString() == "1") { model.databaseStagingPrepared = true; } else { model.databaseStagingPrepared = false; } model.returnMessage = "GenerateRenewalSuccessfully"; } catch (Exception ex) { model = new GenerateRenewalViewModel(); model.returnMessage = "error_" + ex.Message; } finally { dt = null; if (bOpenConection == true) { dbNew.closeConnection(); } dbNew = null; } }
private List <ChampionshipTeamTableDetailsModel> getListTeamTableByChampionship(int id, connectionMySQL db) { ChampionshipTeamTableDetailsModel modelDetails = new ChampionshipTeamTableDetailsModel(); List <ChampionshipTeamTableDetailsModel> listOfModel = new List <ChampionshipTeamTableDetailsModel>(); DataTable dt = null; try { paramName = new string[] { "pIdCamp" }; paramValue = new string[] { Convert.ToString(id) }; dt = db.executePROC("spGetFirstClassificacaoTimeOfCampeonatoForSummary", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = new ChampionshipTeamTableDetailsModel(); modelDetails.championshipID = Convert.ToInt16(dt.Rows[i]["ID_CAMPEONATO"].ToString()); modelDetails.teamName = dt.Rows[i]["NM_TIME"].ToString(); modelDetails.teamType = dt.Rows[i]["DS_TIPO"].ToString(); modelDetails.totalPoint = Convert.ToInt16(dt.Rows[i]["QT_PONTOS_GANHOS"].ToString()); modelDetails.psnID = dt.Rows[i]["PSN_ID"].ToString(); listOfModel.Add(modelDetails); } return(listOfModel); } catch (Exception ex) { listOfModel = new List <ChampionshipTeamTableDetailsModel>(); return(listOfModel); } finally { dt = null; listOfModel = null; modelDetails = null; } }
private CurrentSeasonMenuViewModel getDetailsMenu(string modeType, int userActionID, int championshipID, connectionMySQL db) { CurrentSeasonMenuViewModel model = new CurrentSeasonMenuViewModel(); DataTable dt = null; try { paramName = new string[] { "pType", "pIdUsu", "pIdCamp" }; paramValue = new string[] { modeType, userActionID.ToString(), championshipID.ToString() }; dt = db.executePROC("spGetDetailsMenuCurrentSeason", paramName, paramValue); model.modeType = modeType; if (dt.Rows.Count > 0) { model.currentSeasonName = dt.Rows[0]["seasonName"].ToString(); model.currentChampionshipID = Convert.ToInt16(dt.Rows[0]["championshipID"].ToString()); model.currentChampionshipName = dt.Rows[0]["championshipName"].ToString(); model.currentChampionshipForGroup = Convert.ToInt16(dt.Rows[0]["championchipForGroup"].ToString()); model.championshipSerieAID = Convert.ToInt16(dt.Rows[0]["serieA"].ToString()); model.championshipSerieBID = Convert.ToInt16(dt.Rows[0]["serieB"].ToString()); model.championshipSerieAForGroup = Convert.ToInt16(dt.Rows[0]["serieAForGroup"].ToString()); model.championshipSerieBForGroup = Convert.ToInt16(dt.Rows[0]["serieBForGroup"].ToString()); model.teamName = dt.Rows[0]["teamName"].ToString(); model.userHasTeamFUT = Convert.ToInt16(dt.Rows[0]["userHasTeamFUT"].ToString()); model.userHasTeamPRO = Convert.ToInt16(dt.Rows[0]["userHasTeamPRO"].ToString()); model.returnMessage = "CurrentSeasonSuccessfully"; } return(model); } catch (Exception ex) { model = new CurrentSeasonMenuViewModel(); return(model); } finally { dt = null; model = null; } }
private List <AcceptingDetails> getAllAccepting(connectionMySQL db) { AcceptingDetails modelDetails = new AcceptingDetails(); List <AcceptingDetails> listOfModel = new List <AcceptingDetails>(); DataTable dt = null; try { paramName = new string[] { }; paramValue = new string[] { }; dt = db.executePROC("spGetAllConfirmacaoTemporadaNoFilterCRUD", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = new AcceptingDetails(); modelDetails.seasonID = Convert.ToInt16(dt.Rows[i]["ID_TEMPORADA"].ToString()); modelDetails.userID = Convert.ToUInt16(dt.Rows[i]["ID_USUARIO"].ToString()); modelDetails.championshipID = Convert.ToInt16(dt.Rows[i]["ID_CAMPEONATO"].ToString()); modelDetails.ordering = dt.Rows[i]["IN_ORDENACAO"].ToString(); modelDetails.primaryKey = Convert.ToString(modelDetails.seasonID) + ";" + Convert.ToString(modelDetails.userID) + ";" + Convert.ToString(modelDetails.championshipID); modelDetails.confirmation = dt.Rows[i]["IN_CONFIRMACAO"].ToString(); if (string.IsNullOrEmpty(dt.Rows[i]["IN_CONFIRMACAO"].ToString())) { modelDetails.confirmationDescription = "Ainda não confirmou"; } else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 9) { modelDetails.confirmationDescription = "Participação recusada pela Moderação"; } else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 0) { modelDetails.confirmationDescription = "Não deseja Participar"; } else if (Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 1) { modelDetails.confirmationDescription = "Confirmou Participação"; } modelDetails.totalBlackList = 0; if (!string.IsNullOrEmpty(dt.Rows[i]["PT_LSTNEGRA"].ToString())) { modelDetails.totalBlackList = Convert.ToInt16(dt.Rows[i]["PT_LSTNEGRA"].ToString()); } modelDetails.statusID = dt.Rows[i]["DS_STATUS"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[i]["IN_CONFIRMACAO"].ToString())) { if (modelDetails.statusID == "AP" && Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 0) { modelDetails.statusDescription = "DT - DESISTIU"; } else if (modelDetails.statusID == "AP" && Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 1 && modelDetails.totalBlackList >= 16) { modelDetails.statusDescription = "EA - EM ANÁLISE"; } else if (modelDetails.statusID == "AP" && Convert.ToInt16(dt.Rows[i]["IN_CONFIRMACAO"].ToString()) == 1) { modelDetails.statusDescription = "AP - APROVADO"; } else if (modelDetails.statusID == "AP") { modelDetails.statusDescription = "AG - AGUARDANDO"; } else if (modelDetails.statusID == "EA") { modelDetails.statusDescription = "EA - EM ANÁLISE"; } else if (modelDetails.statusID == "NA") { modelDetails.statusDescription = "NA - NÃO ACEITO"; } } modelDetails.teamName = dt.Rows[i]["NM_TIME"].ToString(); modelDetails.userName = dt.Rows[i]["NM_USUARIO"].ToString(); modelDetails.psnID = dt.Rows[i]["PSN_ID"].ToString(); modelDetails.DateconfirmationFormatted = dt.Rows[i]["DT_CONFIRMACAO_FORMATADA"].ToString(); listOfModel.Add(modelDetails); } return(listOfModel); } catch (Exception ex) { return(listOfModel); } finally { modelDetails = null; listOfModel = null; dt = null; } }
public static MyMatchesTotalModel getMyMatchesTotal(string typeMode, string typeMyMatches, connectionMySQL db, int userID) { MyMatchesTotalModel myMatchesTotal = new MyMatchesTotalModel(); DataTable dt = null; string[] paramName = null; string[] paramValue = null; try { paramName = new string[] { "pTypeMode", "pTypeMyMactches", "pIdUsu" }; paramValue = new string[] { typeMode, typeMyMatches, userID.ToString() }; dt = db.executePROC("spGetTotalsMyMatches", paramName, paramValue); if (dt.Rows.Count > 0) { myMatchesTotal.totalGoals = Convert.ToInt32(dt.Rows[0]["totalGoals"].ToString()); myMatchesTotal.totalGoalsFor = Convert.ToInt32(dt.Rows[0]["totalGoalsFOR"].ToString()); myMatchesTotal.totalGoalsAgainst = Convert.ToInt32(dt.Rows[0]["totalGoalsAGAINST"].ToString()); myMatchesTotal.totalMatchToPlay = Convert.ToInt32(dt.Rows[0]["totalMatchesToPlay"].ToString()); myMatchesTotal.totalMatchDelayed = Convert.ToInt32(dt.Rows[0]["totalMatchesDelayed"].ToString()); myMatchesTotal.totalMatches = Convert.ToInt32(dt.Rows[0]["totalMatches"].ToString()); myMatchesTotal.totalWins = Convert.ToInt32(dt.Rows[0]["totalWins"].ToString()); myMatchesTotal.totalLosses = Convert.ToInt32(dt.Rows[0]["totalLosses"].ToString()); myMatchesTotal.teamNameH2H = dt.Rows[0]["teamNameH2H"].ToString(); myMatchesTotal.nationalTeamNameCPDM = dt.Rows[0]["nationalTeamName"].ToString(); myMatchesTotal.teamNameFUT = dt.Rows[0]["teamNameFUT"].ToString(); myMatchesTotal.teamNamePRO = dt.Rows[0]["teamNamePRO"].ToString(); myMatchesTotal.teamIDH2H = Convert.ToInt32(dt.Rows[0]["teamIDH2H"].ToString()); myMatchesTotal.teamIDFUT = Convert.ToInt32(dt.Rows[0]["teamIDFUT"].ToString()); myMatchesTotal.teamIDPRO = Convert.ToInt32(dt.Rows[0]["teamIDPRO"].ToString()); myMatchesTotal.natonalTeamIDCPDM = Convert.ToInt32(dt.Rows[0]["nationalTeamID"].ToString()); } myMatchesTotal.returnMessage = "MyMatchesSuccessfully"; return(myMatchesTotal); } catch (Exception ex) { myMatchesTotal.returnMessage = "Erro na execução da procedure Total My Matches - Próximos Jogos " + typeMode + ": (" + ex.InnerException.Message + ")";; return(myMatchesTotal); } finally { myMatchesTotal = null; dt = null; } }
public static ChampionshipDetailsModel getChampionshipDetails(connectionMySQL db, int championshipID) { ChampionshipDetailsModel modelDetails = new ChampionshipDetailsModel(); ChampionshipStageDetailsModel stageDetails = new ChampionshipStageDetailsModel(); List <ChampionshipStageDetailsModel> listOfStage = new List <ChampionshipStageDetailsModel>(); DataTable dt = null; string[] paramName = null; string[] paramValue = null; try { paramName = new string[] { "pIdCamp" }; paramValue = new string[] { Convert.ToString(championshipID) }; dt = db.executePROC("spGetCampeonatosDetails", paramName, paramValue); if (dt.Rows.Count > 0) { modelDetails.id = Convert.ToInt32(dt.Rows[0]["ID_CAMPEONATO"].ToString()); modelDetails.seasonID = Convert.ToInt32(dt.Rows[0]["ID_TEMPORADA"].ToString()); modelDetails.name = dt.Rows[0]["NM_CAMPEONATO"].ToString(); modelDetails.seasonName = dt.Rows[0]["NM_Temporada"].ToString(); modelDetails.type = dt.Rows[0]["SG_TIPO_CAMPEONATO"].ToString(); modelDetails.typeName = dt.Rows[0]["DS_TIPO_CAMPEONATO"].ToString(); modelDetails.modeType = dt.Rows[0]["TIPO_CAMPEONATO"].ToString(); modelDetails.active = Convert.ToBoolean(dt.Rows[0]["IN_CAMPEONATO_ATIVO"].ToString()); //modelDetails.startDateFormatted = dt.Rows[0]["DT_INICIO_FORMATADA"].ToString(); //modelDetails.drawDateFormatted = dt.Rows[0]["DT_SORTEIO_FORMATADA"].ToString(); modelDetails.startDate = Convert.ToDateTime(dt.Rows[0]["DT_INICIO"].ToString()); modelDetails.drawDate = Convert.ToDateTime(dt.Rows[0]["DT_SORTEIO"].ToString()); modelDetails.totalTeam = Convert.ToInt16(dt.Rows[0]["QT_TIMES"].ToString()); modelDetails.totalGroup = Convert.ToInt16(dt.Rows[0]["QT_GRUPOS"].ToString()); modelDetails.totalQualify = Convert.ToInt16(dt.Rows[0]["QT_TIMES_CLASSIFICADOS"].ToString()); modelDetails.totalRelegation = Convert.ToInt16(dt.Rows[0]["QT_TIMES_REBAIXADOS"].ToString()); modelDetails.totalDayStageOne = Convert.ToInt16(dt.Rows[0]["QT_DIAS_PARTIDA_CLASSIFICACAO"].ToString()); modelDetails.totalDayStagePlayoff = Convert.ToInt16(dt.Rows[0]["QT_DIAS_PARTIDA_FASE_MATAxMATA"].ToString()); modelDetails.totalQualifyNextStage = Convert.ToInt16(dt.Rows[0]["QT_TIMES_PROX_CLASSIF"].ToString()); modelDetails.totalTeamQualifyDivAbove = Convert.ToInt16(dt.Rows[0]["QT_TIMES_ACESSO"].ToString()); if (!String.IsNullOrEmpty(dt.Rows[0]["IN_POSICAO_ORIGEM"].ToString())) { modelDetails.sourcePlaceFromChampionshipSource = Convert.ToInt16(dt.Rows[0]["IN_POSICAO_ORIGEM"].ToString()); if (!String.IsNullOrEmpty(dt.Rows[0]["ID_CAMPEONATO_DESTINO"].ToString())) { modelDetails.ChampionshipIDDestiny = Convert.ToInt16(dt.Rows[0]["ID_CAMPEONATO_DESTINO"].ToString()); } if (!String.IsNullOrEmpty(dt.Rows[0]["ID_CAMPEONATO_ORIGEM"].ToString())) { modelDetails.ChampionshipIDSource = Convert.ToInt16(dt.Rows[0]["ID_CAMPEONATO_ORIGEM"].ToString()); } } modelDetails.forGroup = Convert.ToBoolean(dt.Rows[0]["IN_CAMPEONATO_GRUPO"].ToString()); modelDetails.justOneTurn = Convert.ToBoolean(dt.Rows[0]["IN_CAMPEONATO_TURNO_UNICO"].ToString()); modelDetails.twoTurns = Convert.ToBoolean(dt.Rows[0]["IN_CAMPEONATO_TURNO_RETURNO"].ToString()); modelDetails.playoff = Convert.ToBoolean(dt.Rows[0]["IN_SISTEMA_MATA"].ToString()); modelDetails.twoLegs = Convert.ToBoolean(dt.Rows[0]["IN_SISTEMA_IDA_VOLTA"].ToString()); modelDetails.console = dt.Rows[0]["IN_CONSOLE"].ToString(); modelDetails.userID1 = Convert.ToInt32(dt.Rows[0]["ID_USUARIO_MODERADOR"].ToString()); modelDetails.userName1 = dt.Rows[0]["NM_Usuario"].ToString(); modelDetails.psnID1 = dt.Rows[0]["PSN_ID"].ToString(); modelDetails.email1 = dt.Rows[0]["DS_EMAIL"].ToString(); modelDetails.userID2 = Convert.ToInt32(dt.Rows[0]["ID_USUARIO_2oMODERADOR"].ToString()); modelDetails.userName2 = dt.Rows[0]["NM_Usuario2"].ToString(); modelDetails.psnID2 = dt.Rows[0]["PSN_ID2"].ToString(); modelDetails.email2 = dt.Rows[0]["DS_EMAIL2"].ToString(); modelDetails.stageID_Round = dt.Rows[0]["ID_FASE_NUMERO_RODADA"].ToString(); modelDetails.started = Convert.ToInt32(dt.Rows[0]["inInicioCampeonato"].ToString()); if (!String.IsNullOrEmpty(dt.Rows[0]["idPrimFaseCampeonato"].ToString())) { modelDetails.firstStageID = Convert.ToInt32(dt.Rows[0]["idPrimFaseCampeonato"].ToString()); } else { modelDetails.firstStageID = 99; } paramName = new string[] { "pIdCamp" }; paramValue = new string[] { Convert.ToString(championshipID) }; dt = db.executePROC("spGetAllFasePorCampeonato", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { stageDetails = new ChampionshipStageDetailsModel(); stageDetails.id = Convert.ToInt16(dt.Rows[i]["ID_FASE"].ToString()); stageDetails.name = dt.Rows[i]["NM_FASE"].ToString(); listOfStage.Add(stageDetails); } modelDetails.listOfStage = listOfStage; } return(modelDetails); } catch (Exception ex) { return(modelDetails); } finally { modelDetails = null; dt = null; paramName = null; paramValue = null; stageDetails = null; listOfStage = null; } }
public static List <ChampionshipDetailsModel> getAllActiveChampionshipCurrentSeason(connectionMySQL db, int championshipID, string modeType) { ChampionshipDetailsModel modelDetails = new ChampionshipDetailsModel(); List <ChampionshipDetailsModel> listOfModel = new List <ChampionshipDetailsModel>(); DataTable dt = null; string[] paramName = null; string[] paramValue = null; try { paramName = new string[] { "pIdTemporada" }; paramValue = new string[] { "0" }; dt = db.executePROC("spGetAllCampeonatosActiveOfTemporada", paramName, paramValue); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["ID_CAMPEONATO"].ToString() != championshipID.ToString() && (dt.Rows[i]["MODE_TYPE"].ToString() == modeType || modeType == String.Empty)) { modelDetails = new ChampionshipDetailsModel(); modelDetails.id = Convert.ToInt32(dt.Rows[i]["ID_CAMPEONATO"].ToString()); modelDetails.seasonID = Convert.ToInt32(dt.Rows[i]["ID_TEMPORADA"].ToString()); modelDetails.seasonName = dt.Rows[i]["NM_TEMPORADA"].ToString(); modelDetails.name = dt.Rows[i]["NM_CAMPEONATO"].ToString(); modelDetails.type = dt.Rows[i]["SG_TIPO_CAMPEONATO"].ToString(); modelDetails.modeType = dt.Rows[i]["MODE_TYPE"].ToString(); modelDetails.totalTeam = Convert.ToInt32(dt.Rows[i]["QT_TIMES"].ToString()); modelDetails.startDate = Convert.ToDateTime(dt.Rows[i]["DT_INICIO"].ToString()); modelDetails.drawDate = Convert.ToDateTime(dt.Rows[i]["DT_SORTEIO"].ToString()); modelDetails.active = Convert.ToBoolean(dt.Rows[i]["IN_CAMPEONATO_ATIVO"].ToString()); listOfModel.Add(modelDetails); } } return(listOfModel); } catch (Exception ex) { return(listOfModel); } finally { modelDetails = null; listOfModel = null; dt = null; paramName = null; paramValue = null; } }
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; } }