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;
}
}
