private StandardGenerateNewSeasonChampionshipLeagueDetailsModel getDetailsChampionshipLeague(string modeType, string championshipType) { DataTable dt = null; StandardGenerateNewSeasonChampionshipLeagueDetailsModel modelDetails = new StandardGenerateNewSeasonChampionshipLeagueDetailsModel(); try { paramName = new string[] { "pTpModalidade", "pSgCampeonato" }; paramValue = new string[] { modeType, championshipType }; dt = db.executePROC("spGetAllChampionshipLeagueDetailsNewTemporada", paramName, paramValue); if (dt.Rows.Count > 0) { modelDetails.modeType = modeType; modelDetails.championshipType = championshipType; modelDetails.startDate = Convert.ToDateTime(dt.Rows[0]["DATA_INICIO"].ToString()); modelDetails.totalTeams = Convert.ToInt16(dt.Rows[0]["QT_TIMES"].ToString()); modelDetails.totalDaysToPlayStage0 = Convert.ToInt16(dt.Rows[0]["DIAS_FASE_CLASSIFICACAO"].ToString()); modelDetails.totalDaysToPlayPlayoff = Convert.ToInt16(dt.Rows[0]["DIAS_FASE_PLAYOFF"].ToString()); modelDetails.totalRelegate = Convert.ToInt16(dt.Rows[0]["QT_TIMES_REBAIXADOS"].ToString()); modelDetails.hasChampionship = Convert.ToBoolean(dt.Rows[0]["IN_CAMPEONATO_ATIVO"].ToString()); modelDetails.championshipID = Convert.ToInt16(dt.Rows[0]["ID_CAMPEONATO"].ToString()); modelDetails.championship_ByGroup = Convert.ToBoolean(dt.Rows[0]["IN_CAMPEONATO_GRUPO"].ToString()); modelDetails.totalGroups = Convert.ToInt16(dt.Rows[0]["QT_GRUPOS"].ToString()); modelDetails.championship_byGroupPots = Convert.ToBoolean(dt.Rows[0]["IN_CAMPEONATO_GRUPO_POR_POTES"].ToString()); modelDetails.championship_DoubleRound = Convert.ToBoolean(dt.Rows[0]["IN_DOUBLE_ROUND"].ToString()); } return(modelDetails); } catch { return(new StandardGenerateNewSeasonChampionshipLeagueDetailsModel()); } finally { dt = null; modelDetails = null; } }
public ActionResult GenerateNewSeason(FormCollection formHTML) { HttpResponseMessage response = new HttpResponseMessage(); GenerateNewSeasonDetailsModel modelReturnJSON = new GenerateNewSeasonDetailsModel(); GenerateNewSeasonDetailsModel modelReturnView = new GenerateNewSeasonDetailsModel(); StandardGenerateNewSeasonChampionshipLeagueDetailsModel modelLeague = null; StandardGenerateNewSeasonChampionshipCupDetailsModel modelCup = null; GenerateNewSeasonStandardDetailsModel modelTeam = null; GenerateNewSeasonStandardDetailsModel modelTeamDetails = null; string actionForm = "show-settings"; if (formHTML["actionForm"] != null) { actionForm = formHTML["actionForm"].ToLower(); } setViewBagVariables(); ViewBag.inFormScript = "1"; try { modelReturnView = (GenerateNewSeasonDetailsModel)TempData["FullModel"]; if (actionForm == "save-details-championship-league") { modelReturnView.drawDate = Convert.ToDateTime(formHTML["txtDrawDate"]); for (int i = 0; i < modelReturnView.listChampionshipLeagueDetails.Count; i++) { modelLeague = modelReturnView.listChampionshipLeagueDetails[i]; modelLeague.startDate = Convert.ToDateTime(formHTML["txtStartDate-" + modelLeague.championshipType]); modelLeague.totalTeams = Convert.ToInt16(formHTML["txtTotalTeams-" + modelLeague.championshipType]); modelLeague.totalDaysToPlayStage0 = Convert.ToInt16(formHTML["txtDaysStage0-" + modelLeague.championshipType]); modelLeague.totalDaysToPlayPlayoff = Convert.ToInt16(formHTML["txtDaysPlayoff-" + modelLeague.championshipType]); modelLeague.totalRelegate = Convert.ToInt16(formHTML["txtRelegate-" + modelLeague.championshipType]); modelLeague.totalGroups = Convert.ToInt16(formHTML["txtTotalGroups-" + modelLeague.championshipType]); if (formHTML["chkChampionshipActive-" + modelLeague.championshipType] == "on") { modelLeague.hasChampionship = true; } else { modelLeague.hasChampionship = false; } if (formHTML["chkChampionshipByGroup-" + modelLeague.championshipType] == "on") { modelLeague.championship_ByGroup = true; } else { modelLeague.championship_ByGroup = false; } if (formHTML["chkChampionshipGroupsByPots-" + modelLeague.championshipType] == "on") { modelLeague.championship_byGroupPots = true; } else { modelLeague.championship_byGroupPots = false; } if (formHTML["chkChampionshipDoubleRound-" + modelLeague.championshipType] == "on") { modelLeague.championship_DoubleRound = true; } else { modelLeague.championship_DoubleRound = false; } } TempData["actionSuccessfully"] = "Set Up Initial for " + modelReturnJSON.modeType + " for league-mode was saved successfully"; modelReturnView.actionUser = "******"; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnView).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonDetailsModel>().Result; modelReturnJSON = modelReturnView; } else if (actionForm == "save-details-championship-cup") { for (int i = 0; i < modelReturnView.listChampionshipCupDetails.Count; i++) { modelCup = modelReturnView.listChampionshipCupDetails[i]; modelCup.startDate = Convert.ToDateTime(formHTML["txtStartDate-" + modelCup.championshipType]); modelCup.totalTeams = Convert.ToInt16(formHTML["txtTotalTeams-" + modelCup.championshipType]); modelCup.totalDaysToPlayStage0 = Convert.ToInt16(formHTML["txtDaysStage0-" + modelCup.championshipType]); modelCup.totalDaysToPlayPlayoff = Convert.ToInt16(formHTML["txtDaysPlayoff-" + modelCup.championshipType]); modelCup.totalGroups = Convert.ToInt16(formHTML["txtTotalGroups-" + modelCup.championshipType]); modelCup.totalTeamsPreCup = Convert.ToInt16(formHTML["txtTotalTeamsPreCup-" + modelCup.championshipType]); if (formHTML["chkChampionshipActive-" + modelCup.championshipType] == "on") { modelCup.hasChampionship = true; } else { modelCup.hasChampionship = false; } if (formHTML["chkChampionshipByGroup-" + modelCup.championshipType] == "on") { modelCup.championship_ByGroup = true; } else { modelCup.championship_ByGroup = false; } if (formHTML["chkChampionshipGroupsByPots-" + modelCup.championshipType] == "on") { modelCup.championship_byGroupPots = true; } else { modelCup.championship_byGroupPots = false; } if (formHTML["chkChampionshipJustSerieA-" + modelCup.championshipType] == "on") { modelCup.hasJust_SerieA = true; } else { modelCup.hasJust_SerieA = false; } if (formHTML["chkChampionshipJustSerieB-" + modelCup.championshipType] == "on") { modelCup.hasJust_SerieB = true; } else { modelCup.hasJust_SerieB = false; } if (formHTML["chkChampionshipJustSerieC-" + modelCup.championshipType] == "on") { modelCup.hasJust_SerieC = true; } else { modelCup.hasJust_SerieC = false; } if (formHTML["chkChampionshipSerieA_B-" + modelCup.championshipType] == "on") { modelCup.has_SerieA_B = true; } else { modelCup.has_SerieA_B = false; } if (formHTML["chkChampionshipSerieA_B_C-" + modelCup.championshipType] == "on") { modelCup.has_SerieA_B_C_D = true; } else { modelCup.has_SerieA_B_C_D = false; } if (formHTML["chkChampionshipNationalTeams-" + modelCup.championshipType] == "on") { modelCup.has_NationalTeams = true; } else { modelCup.has_NationalTeams = false; } if (formHTML["chkChampionshipDestiny-" + modelCup.championshipType] == "on") { modelCup.hasChampionshipDestiny = true; } else { modelCup.hasChampionshipDestiny = false; } if (formHTML["chkChampionshipSource-" + modelCup.championshipType] == "on") { modelCup.hasChampionshipSource = true; } else { modelCup.hasChampionshipSource = false; } } TempData["actionSuccessfully"] = "Set Up Initial for " + modelReturnJSON.modeType + " for cup-mode was saved successfully"; modelReturnView.actionUser = "******"; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnView).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonDetailsModel>().Result; modelReturnJSON = modelReturnView; } else if (actionForm == "delete-team") { modelReturnView.championshipType = formHTML["championshipType"]; modelReturnView.itemID = Convert.ToInt32(formHTML["itemID"]); modelReturnView.itemName = formHTML["itemName"]; modelReturnView.actionUser = "******"; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnView).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonDetailsModel>().Result; TempData["actionSuccessfully"] = "The team (" + modelReturnView.itemName + ") was deleted successfully from " + modelReturnView.championshipType; modelReturnJSON = modelReturnView; } else if (actionForm == "add-team") { modelReturnView.championshipType = formHTML["txtChampionshipType"]; modelReturnView.itemID = Convert.ToInt32(formHTML["txtTeam"]); modelReturnView.poteNumber = Convert.ToInt16(formHTML["txtPotNumber"]); TempData["actionSuccessfully"] = "The team (" + modelReturnView.itemName + ") was added successfully to " + modelReturnView.championshipType; modelReturnView.actionUser = "******"; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnView).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonDetailsModel>().Result; modelReturnJSON = modelReturnView; } else { modelReturnJSON.returnMessage = "GenerateNewSeasonSuccessfully"; modelReturnJSON.actionUser = actionForm.ToUpper(); response.StatusCode = HttpStatusCode.Created; } switch (response.StatusCode) { case HttpStatusCode.Created: if (modelReturnJSON.returnMessage == "GenerateNewSeasonSuccessfully") { //nothing to do } else { TempData["returnMessage"] = "Some error occurred when the system was trying to show the view: Generate New Season - Set Up Initial. (" + modelReturnJSON.returnMessage + ")"; } return(View(modelReturnJSON)); default: TempData["returnMessage"] = "Some error occurred when the system was trying to show the view: Generate New Season - Set Up Initial. (" + response.StatusCode + ")"; ModelState.AddModelError("", "application error."); return(View(modelReturnJSON)); } } catch (Exception ex) { TempData["returnMessage"] = "Internal error - when the system was trying to show the view: Generate New Season - Set Up Initial. (" + ex.Message + ")"; ModelState.AddModelError("", "application error."); return(View(modelReturnView)); } finally { response = null; modelReturnJSON = null; modelReturnView = null; modelLeague = null; modelCup = null; modelTeam = null; modelTeamDetails = null; } }
public IHttpActionResult getPost(GenerateNewSeasonDetailsModel model) { db.openConnection(GlobalVariables.DATABASE_NAME_STAGING); StandardGenerateNewSeasonChampionshipLeagueDetailsModel modelLeague = null; StandardGenerateNewSeasonChampionshipCupDetailsModel modelCup = null; GenerateNewSeasonGenerateModel modelGenerate = new GenerateNewSeasonGenerateModel();; DataTable dt = null; int i, j = 0; string[] allChampionshipsSelected = { }; Boolean VARIABLE_FALSE = false; Boolean VARIABLE_TRUE = true; try { if (model.actionUser == "getSeasonDetails") { paramName = new string[] { }; paramValue = new string[] { }; dt = db.executePROC("spGetAllSeasonDetailsNewTemporada", paramName, paramValue); model.seasonID = Convert.ToInt16(dt.Rows[0]["ID_TEMPORADA"].ToString()); model.seasonName = dt.Rows[0]["NM_TEMPORADA"].ToString(); model.userID = Convert.ToInt16(dt.Rows[0]["ID_USUARIO"].ToString()); model.userName = dt.Rows[0]["NM_USUARIO"].ToString(); model.psnID = dt.Rows[0]["PSN_ID"].ToString(); model.drawDate = Convert.ToDateTime(dt.Rows[0]["DATA_SORTEIO"].ToString()); model.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "getAllChampionshipsActiveDetails") { paramName = new string[] { "pTpModalidade" }; paramValue = new string[] { model.modeType }; dt = db.executePROC("spGetAllChampionshipTypesNewTemporadaByMode", paramName, paramValue); model.listChampionshipLeagueDetails = new List <StandardGenerateNewSeasonChampionshipLeagueDetailsModel>(); model.listChampionshipCupDetails = new List <StandardGenerateNewSeasonChampionshipCupDetailsModel>(); model.listOfTeams = new List <GenerateNewSeasonStandardDetailsModel>(); for (i = 0; i < dt.Rows.Count; i++) { if (GlobalVariables.GENERATE_NEWSEASON_CHAMPIONSHIP_ALLSERIES.IndexOf(dt.Rows[i]["SG_CAMPEONATO"].ToString()) > -1) { model.listChampionshipLeagueDetails.Add(getDetailsChampionshipLeague(model.modeType, dt.Rows[i]["SG_CAMPEONATO"].ToString())); } else { model.listChampionshipCupDetails.Add(getDetailsChampionshipCup(model.modeType, dt.Rows[i]["SG_CAMPEONATO"].ToString())); } } getAllTeamToTheMainModel(ref model); model.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "saveChampionshipsLeagueDetails") { paramName = new string[] { "pIdTemporada", "pNmTemporada", "pIdUsu", "pNmUsu", "pPsnID", "pDtSorteio" }; paramValue = new string[] { model.seasonID.ToString(), model.seasonName, model.userID.ToString(), model.userName, model.psnID, model.drawDate.ToString("dd/MM/yyyy") + ";[DATE-TYPE]" }; db.executePROCNonResult("spAddUpdateSeasonGenerateNewSeason", paramName, paramValue); for (i = 0; i < model.listChampionshipLeagueDetails.Count; i++) { modelLeague = model.listChampionshipLeagueDetails[i]; string active = Convert.ToBoolean(modelLeague.hasChampionship) ? "1" : "0"; string byGroup = Convert.ToBoolean(modelLeague.championship_ByGroup) ? "1" : "0"; string byGroupPots = Convert.ToBoolean(modelLeague.championship_byGroupPots) ? "1" : "0"; string doubleRound = Convert.ToBoolean(modelLeague.championship_DoubleRound) ? "1" : "0"; paramName = new string[] { "pTpModalidade", "pSgCampeonato", "pDtInicio", "pQtTimes", "pQtDiasFase0", "pQtDiasPlayoff", "pQtTimesRebaixados", "pInAtivo", "pInPorGrupo", "pQtGrupos", "pInPorPotes", "pInDoubleRound" }; paramValue = new string[] { modelLeague.modeType, modelLeague.championshipType, modelLeague.startDate.ToString("dd/MM/yyyy") + ";[DATE-TYPE]", modelLeague.totalTeams.ToString(), modelLeague.totalDaysToPlayStage0.ToString(), modelLeague.totalDaysToPlayPlayoff.ToString(), modelLeague.totalRelegate.ToString(), active, byGroup, modelLeague.totalGroups.ToString(), byGroupPots, doubleRound }; db.executePROCNonResult("spUpdateChampionshipLeagueGenerateNewSeason", paramName, paramValue); } model.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "saveChampionshipsCupDetails") { for (i = 0; i < model.listChampionshipCupDetails.Count; i++) { modelCup = model.listChampionshipCupDetails[i]; string active = Convert.ToBoolean(modelCup.hasChampionship) ? "1" : "0"; string byGroup = Convert.ToBoolean(modelCup.championship_ByGroup) ? "1" : "0"; string byGroupPots = Convert.ToBoolean(modelCup.championship_byGroupPots) ? "1" : "0"; string destiny = Convert.ToBoolean(modelCup.hasChampionshipDestiny) ? "1" : "0"; string source = Convert.ToBoolean(modelCup.hasChampionshipSource) ? "1" : "0"; string justSerieA = Convert.ToBoolean(modelCup.hasJust_SerieA) ? "1" : "0"; string justSerieB = Convert.ToBoolean(modelCup.hasJust_SerieB) ? "1" : "0"; string justSerieC = Convert.ToBoolean(modelCup.hasJust_SerieC) ? "1" : "0"; string serieA_B = Convert.ToBoolean(modelCup.has_SerieA_B) ? "1" : "0"; string serieA_B_C = Convert.ToBoolean(modelCup.has_SerieA_B_C) ? "1" : "0"; string serieA_B_C_D = Convert.ToBoolean(modelCup.has_SerieA_B_C_D) ? "1" : "0"; string nationalTeam = Convert.ToBoolean(modelCup.has_NationalTeams) ? "1" : "0"; paramName = new string[] { "pTpModalidade", "pSgCampeonato", "pDtInicio", "pQtTimes", "pQtDiasFase0", "pQtDiasPlayoff", "pInAtivo", "pInPorGrupo", "pQtGrupos", "pInPorPotes", "pInDestino", "pInOrigem", "pInSerieA", "pInSerieB", "pInSerieC", "pInSerieA_B", "pInSerieA_B_C", "pInSerieA_B_C_D", "pInSelecao" }; paramValue = new string[] { modelCup.modeType, modelCup.championshipType, modelCup.startDate.ToString("dd/MM/yyyy") + ";[DATE-TYPE]", modelCup.totalTeams.ToString(), modelCup.totalDaysToPlayStage0.ToString(), modelCup.totalDaysToPlayPlayoff.ToString(), active, byGroup, modelCup.totalGroups.ToString(), byGroupPots, destiny, source, justSerieA, justSerieB, justSerieC, serieA_B, serieA_B_C, serieA_B_C_D, nationalTeam }; db.executePROCNonResult("spUpdateChampionshipCupGenerateNewSeason", paramName, paramValue); } model.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "addTeam") { paramName = new string[] { "pTpModalidade", "pSgCampeonato", "pIdStandard", "pIdItem", "pIdNumPote" }; paramValue = new string[] { model.modeType, model.championshipType, GlobalVariables.GENERATE_NEWSEASON_ITEM_TYPE_TEAM.ToString(), model.itemID.ToString(), model.poteNumber.ToString() }; db.executePROCNonResult("spAddTeamGenerateNewSeason", paramName, paramValue); getAllTeamToTheMainModel(ref model); model.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "delTeam") { paramName = new string[] { "pTpModalidade", "pSgCampeonato", "pIdStandard", "pIdItem", "pNmItem" }; paramValue = new string[] { model.modeType, model.championshipType, GlobalVariables.GENERATE_NEWSEASON_ITEM_TYPE_TEAM.ToString(), model.itemID.ToString(), model.itemName }; db.executePROCNonResult("spDeleteTeamGenerateNewSeason", paramName, paramValue); getAllTeamToTheMainModel(ref model); model.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "validate") { paramName = new string[] { }; paramValue = new string[] { }; dt = db.executePROC("spValidGenerationNewSeason", paramName, paramValue); modelGenerate.DatabasesLookTheSame = false; modelGenerate.NewSeasonIsGenerated = false; modelGenerate.hasEuroCup = false; modelGenerate.hasEuropeLeague = false; modelGenerate.hasSerieB_FUT = false; modelGenerate.hasSerieB_PRO = false; modelGenerate.hasSerieD_H2H = false; modelGenerate.hasWorldCup = false; if (dt.Rows[0]["databasesLookTheSame"].ToString() == "1") { modelGenerate.DatabasesLookTheSame = true; } if (dt.Rows[0]["generateNewSeasonIsDone"].ToString() == "1") { modelGenerate.NewSeasonIsGenerated = true; } if (dt.Rows[0]["hasWorldCup"].ToString() == "1") { modelGenerate.hasWorldCup = true; } if (dt.Rows[0]["hasEuroCup"].ToString() == "1") { modelGenerate.hasEuroCup = true; } if (dt.Rows[0]["hasSerieD_H2H"].ToString() == "1") { modelGenerate.hasSerieD_H2H = true; } if (dt.Rows[0]["hasSerieB_FUT"].ToString() == "1") { modelGenerate.hasSerieB_FUT = true; } if (dt.Rows[0]["hasSerieB_PRO"].ToString() == "1") { modelGenerate.hasSerieB_PRO = true; } if (dt.Rows[0]["hasEuroLeague"].ToString() == "1") { modelGenerate.hasEuropeLeague = true; } modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "prepare-database-bkp") { paramName = new string[] { }; paramValue = new string[] { }; dt = db.executePROC("spPrepareDatabaseBKPToNegerateNewSeason", paramName, paramValue); modelGenerate.DatabasesLookTheSame = true; modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "prepare-generate") { modelGenerate = model.newSeasonModel; paramName = new string[] { }; paramValue = new string[] { }; dt = db.executePROC("spInitializeProxTemporada", paramName, paramValue); modelGenerate.currentSeasonID = Convert.ToInt16(dt.Rows[0]["PreviousTemporadaID"].ToString()); modelGenerate.preparationBkpDatabaseIsDone = true; //Today (23/07/19) we don't keep more the match comments modelGenerate.preparationCommentDatabaseIsDone = true; modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "generate-calculate-season-h2h") { modelGenerate = model.newSeasonModel; paramName = new string[] { "pIdTemp" }; paramValue = new string[] { modelGenerate.currentSeasonID.ToString() }; dt = db.executePROC("spCalculateEndOfTemporadaH2H", paramName, paramValue); modelGenerate.seasonID = Convert.ToInt16(dt.Rows[0]["NewTemporadaID"].ToString()); modelGenerate.seasonName = dt.Rows[0]["NewTemporadaName"].ToString(); modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "generate-calculate-season-fut") { modelGenerate = model.newSeasonModel; paramName = new string[] { "pIdTemp", "pIdNewTemp" }; paramValue = new string[] { modelGenerate.currentSeasonID.ToString(), modelGenerate.seasonID.ToString() }; db.executePROCNonResult("spCalculateEndOfTemporadaFUT", paramName, paramValue); modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "generate-calculate-season-pro") { modelGenerate = model.newSeasonModel; paramName = new string[] { "pIdTemp", "pIdNewTemp" }; paramValue = new string[] { modelGenerate.currentSeasonID.ToString(), modelGenerate.seasonID.ToString() }; db.executePROCNonResult("spCalculateEndOfTemporadaPRO", paramName, paramValue); modelGenerate.calculateEndOfSeasonIsDone = true; modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "generate-championships-league-h2h") { modelGenerate = model.newSeasonModel; paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "H2H", "SERIE_A", "DIV1", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.serieAID_H2H = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.serieAID_H2H > 0) { modelGenerate.serieAIsGenerated_H2H = true; } paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "H2H", "SERIE_B", "DIV2", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.serieBID_H2H = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.serieBID_H2H > 0) { modelGenerate.serieBIsGenerated_H2H = true; } paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "H2H", "SERIE_C", "DIV3", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.serieCID_H2H = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.serieCID_H2H > 0) { modelGenerate.serieCIsGenerated_H2H = true; } modelGenerate.serieDID_H2H = 0; if (modelGenerate.hasSerieD_H2H) { paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "H2H", "SERIE_D", "DIV4", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.serieDID_H2H = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.serieDID_H2H > 0) { modelGenerate.serieDIsGenerated_H2H = true; } } paramName = new string[] { "pIdTemp", "pIdSerieA", "pIdSerieB", "pIdSerieC", "pIdSerieD", "pQtLimitMaxLstNegra", "pCodAcessoTapetao", "pCodAcesso", "pCodAcessoRelegated", "pCodAcessoInvited" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), modelGenerate.serieAID_H2H.ToString(), modelGenerate.serieBID_H2H.ToString(), modelGenerate.serieCID_H2H.ToString(), modelGenerate.serieDID_H2H.ToString(), ConfigurationManager.AppSettings["renewal.total.limit.blackList"].ToString(), ConfigurationManager.AppSettings["access.current.season.access.direct"].ToString(), ConfigurationManager.AppSettings["access.current.season.access"].ToString(), ConfigurationManager.AppSettings["access.current.season.access"].ToString(), ConfigurationManager.AppSettings["access.current.season.invite"].ToString() }; dt = db.executePROC("spRellocationLigasH2H", paramName, paramValue); modelGenerate.rellocationOfSeries_H2H = true; modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "generate-championships-cup-h2h") { modelGenerate = model.newSeasonModel; modelGenerate.worldCupID_H2H = 0; if (modelGenerate.hasWorldCup) { paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "H2H", "WORLDCP", "CPDM", VARIABLE_TRUE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.worldCupID_H2H = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.worldCupID_H2H > 0) { modelGenerate.worldCupIsGenerated = true; } } modelGenerate.euroCupID_H2H = 0; if (modelGenerate.hasEuroCup) { paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "H2H", "EUROCUP", "ERCP", VARIABLE_TRUE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.euroCupID_H2H = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.euroCupID_H2H > 0) { modelGenerate.euroCupIsGenerated = true; } } paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "H2H", "CHAMPLG", "CPGL", VARIABLE_TRUE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.championsLeagueID = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.championsLeagueID > 0) { modelGenerate.championsLeagueIsGenerated = true; } modelGenerate.europeLeagueID = 0; if (modelGenerate.hasEuropeLeague) { paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "H2H", "EUROPLG", "CPSA", VARIABLE_TRUE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.europeLeagueID = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.europeLeagueID > 0) { modelGenerate.europeLeagueIsGenerated = true; } } paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "H2H", "UEFACUP", "CPGL", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.uefaCupID = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.uefaCupID > 0) { modelGenerate.uefaCupIsGenerated = true; } modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "generate-championships-fut") { modelGenerate = model.newSeasonModel; paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "FUT", "SERIE_A", "FUT1", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.serieAID_FUT = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.serieAID_FUT > 0) { modelGenerate.serieAIsGenerated_FUT = true; } modelGenerate.serieBID_FUT = 0; if (modelGenerate.hasSerieB_FUT) { paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "FUT", "SERIE_B", "FUT2", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.serieBID_FUT = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.serieBID_FUT > 0) { modelGenerate.serieBIsGenerated_FUT = true; } } paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "FUT", "FUT-CUP", "CFUT", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.futCupID = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.futCupID > 0) { modelGenerate.futCupIsGenerated = true; } modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "generate-championships-pro") { modelGenerate = model.newSeasonModel; paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "PRO", "SERIE_A", "PRO1", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.serieAID_PRO = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.serieAID_PRO > 0) { modelGenerate.serieAIsGenerated_PRO = true; } modelGenerate.serieBID_PRO = 0; if (modelGenerate.hasSerieB_PRO) { paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "PRO", "SERIE_B", "PRO2", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.serieBID_PRO = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.serieBID_PRO > 0) { modelGenerate.serieBIsGenerated_PRO = true; } } paramName = new string[] { "pIdTemp", "pTpModalidade", "pSgCampeonato", "pTpCamp", "pByGroup" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), "PRO", "PRO-CUP", "CPRO", VARIABLE_FALSE.ToString() + ";[BOOLEAN-TYPE]" }; dt = db.executePROC("spAddNewChampionship", paramName, paramValue); modelGenerate.proCupID = Convert.ToInt16(dt.Rows[0]["idCampNew"].ToString()); if (modelGenerate.proCupID > 0) { modelGenerate.proCupIsGenerated = true; } paramName = new string[] { "pIdTemp", "pIdCamp" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), modelGenerate.proCupID.ToString() }; dt = db.executePROC("spSubscriptionPlayersForPROCLUB", paramName, paramValue); modelGenerate.validationSquadOfProClubIsDone = true; modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else if (model.actionUser == "generate-maintenance") { modelGenerate = model.newSeasonModel; paramName = new string[] { "pIdTemp", "pIdSerieA", "pIdSerieB", "pIdSerieC", "pIdSerieD", "pIdFutA", "pIdFutB", "pIdProA", "pIdProB" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), modelGenerate.serieAID_H2H.ToString(), modelGenerate.serieBID_H2H.ToString(), modelGenerate.serieCID_H2H.ToString(), modelGenerate.serieDID_H2H.ToString(), modelGenerate.serieAID_FUT.ToString(), modelGenerate.serieBID_FUT.ToString(), modelGenerate.serieAID_PRO.ToString(), modelGenerate.serieBID_PRO.ToString() }; dt = db.executePROC("spMaintenanceBancoAndManagers", paramName, paramValue); modelGenerate.maintenanceOfBenchIsDone = true; paramName = new string[] { "pIdTemp" }; paramValue = new string[] { modelGenerate.seasonID.ToString() }; dt = db.executePROC("spGenerateClashesNewTemporada", paramName, paramValue); modelGenerate.tableOfClashesIsDone = true; paramName = new string[] { "pIdTemp", "pIdSerieA" }; paramValue = new string[] { modelGenerate.seasonID.ToString(), modelGenerate.serieAID_H2H.ToString() }; dt = db.executePROC("spDeleteAllTablesForNewTemporada", paramName, paramValue); modelGenerate.purgingOfSystemTablesIsDone = true; modelGenerate.NewSeasonIsGenerated = true; modelGenerate.returnMessage = "GenerateNewSeasonSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } else { return(StatusCode(HttpStatusCode.NotAcceptable)); } } catch (Exception ex) { modelGenerate.returnMessage = "error_" + ex.Message; return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelGenerate)); } finally { db.closeConnection(); dt = null; modelLeague = null; modelCup = null; modelGenerate = null; } }