public IHttpActionResult GetAllForChampionship(int id) { ChampionshipStageDetailsModel modelDetails = new ChampionshipStageDetailsModel(); ChampionshipStageListViewModel mainModel = new ChampionshipStageListViewModel(); List <ChampionshipStageDetailsModel> listOfModel = new List <ChampionshipStageDetailsModel>(); DataTable dt = null; db.openConnection(); try { paramName = new string[] { "pIdCamp" }; paramValue = new string[] { Convert.ToString(id) }; dt = db.executePROC("spGetAllFaseByCampeonato", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = new ChampionshipStageDetailsModel(); modelDetails.id = Convert.ToInt16(dt.Rows[i]["ID_FASE"].ToString()); modelDetails.name = dt.Rows[i]["NM_FASE"].ToString(); modelDetails.totalMatchesNoResult = Convert.ToInt16(dt.Rows[i]["TOTALMATCHESNORESULT"].ToString()); modelDetails.existMatches = Convert.ToInt16(dt.Rows[i]["EXISTMATCHES"].ToString()); modelDetails.status = dt.Rows[i]["STATUS"].ToString(); listOfModel.Add(modelDetails); } mainModel.listOfStage = listOfModel; mainModel.returnMessage = "ModeratorSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel)); } catch (Exception ex) { mainModel = new ChampionshipStageListViewModel(); mainModel.listOfStage = new List <ChampionshipStageDetailsModel>(); mainModel.returnMessage = "errorGetAllStageForChampionship_" + ex.Message; return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel)); } finally { db.closeConnection(); modelDetails = null; mainModel = null; listOfModel = null; dt = null; } }
public IHttpActionResult GetAll() { ChampionshipStageDetailsModel modelDetails = new ChampionshipStageDetailsModel(); ChampionshipStageListViewModel mainModel = new ChampionshipStageListViewModel(); List <ChampionshipStageDetailsModel> listOfModel = new List <ChampionshipStageDetailsModel>(); DataTable dt = null; db.openConnection(); try { paramName = new string[] { }; paramValue = new string[] { }; dt = db.executePROC("spGetAllFase", paramName, paramValue); for (var i = 0; i < dt.Rows.Count; i++) { modelDetails = new ChampionshipStageDetailsModel(); modelDetails.id = Convert.ToInt16(dt.Rows[i]["ID_FASE"].ToString()); modelDetails.name = dt.Rows[i]["NM_FASE"].ToString(); listOfModel.Add(modelDetails); } mainModel.listOfStage = listOfModel; mainModel.returnMessage = "ModeratorSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel)); } catch (Exception ex) { mainModel = new ChampionshipStageListViewModel(); mainModel.listOfStage = new List <ChampionshipStageDetailsModel>(); mainModel.returnMessage = "errorGetAllStage_" + ex.Message; return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel)); } finally { db.closeConnection(); modelDetails = null; mainModel = null; listOfModel = 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; } }