private void getAllTeamToTheMainModel(ref GenerateNewSeasonDetailsModel model) { GenerateNewSeasonStandardDetailsModel modelItemDetails = null; DataTable dt = null; int j = 0; try { model.listOfTeams = new List <GenerateNewSeasonStandardDetailsModel>(); paramName = new string[] { "pTpModalidade" }; paramValue = new string[] { model.modeType }; dt = db.executePROC("spGetAllChampionshipItensNewTemporadaByModalidade", paramName, paramValue); for (j = 0; j < dt.Rows.Count; j++) { modelItemDetails = new GenerateNewSeasonStandardDetailsModel(); modelItemDetails.modeType = dt.Rows[j]["TP_MODALIDADE"].ToString(); modelItemDetails.championshipType = dt.Rows[j]["SG_CAMPEONATO"].ToString(); modelItemDetails.typeStandard = Convert.ToInt16(dt.Rows[j]["ID_STANDARD"].ToString()); modelItemDetails.id = Convert.ToInt32(dt.Rows[j]["ITEM_ID"].ToString()); modelItemDetails.name = dt.Rows[j]["ITEM_NAME"].ToString(); modelItemDetails.psnID = dt.Rows[j]["ITEM_PSN"].ToString(); modelItemDetails.poteNumber = Convert.ToInt16(dt.Rows[j]["ITEM_POTE_NUMBER"].ToString()); model.listOfTeams.Add(modelItemDetails); } if (model.modeType == "H2H") { paramName = new string[] { }; paramValue = new string[] { }; dt = db.executePROC("spGetAllTeamGenerateNewSeasonH2H", paramName, paramValue); for (j = 0; j < dt.Rows.Count; j++) { modelItemDetails = new GenerateNewSeasonStandardDetailsModel(); modelItemDetails.id = Convert.ToInt32(dt.Rows[j]["ID_TIME"].ToString()); modelItemDetails.name = dt.Rows[j]["NM_TIME"].ToString(); modelItemDetails.typeItem = dt.Rows[j]["DS_TIPO"].ToString(); model.listOfTeams.Add(modelItemDetails); } } } catch { } finally { modelItemDetails = null; dt = null; } }
public ActionResult GenerateNewSeasonPRO() { HttpResponseMessage response = new HttpResponseMessage(); GenerateNewSeasonDetailsModel modelReturnJSON = new GenerateNewSeasonDetailsModel(); GenerateNewSeasonDetailsModel modelReturnView = new GenerateNewSeasonDetailsModel(); setViewBagVariables(); ViewBag.inFormScript = "1"; try { modelReturnView.actionUser = "******"; modelReturnView.modeType = "PRO"; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnView).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonDetailsModel>().Result; if (modelReturnView.returnMessage == "GenerateNewSeasonSuccessfully") { modelReturnView.actionUser = "******"; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnView).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonDetailsModel>().Result; } modelReturnJSON = modelReturnView; switch (response.StatusCode) { case HttpStatusCode.Created: return(View("GenerateNewSeason", 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("GenerateNewSeason", 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("GenerateNewSeason", modelReturnView)); } finally { response = null; modelReturnJSON = null; modelReturnView = null; } }
public ActionResult GenerateNewSeasonShowView() { HttpResponseMessage response = new HttpResponseMessage(); GenerateNewSeasonDetailsModel modelReturnJSON = new GenerateNewSeasonDetailsModel(); GenerateNewSeasonGenerateModel modelReturnView = new GenerateNewSeasonGenerateModel(); setViewBagVariables(); ViewBag.inFormScript = "1"; try { modelReturnJSON.actionUser = "******"; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; switch (response.StatusCode) { case HttpStatusCode.Created: return(View("GenerateNewSeason_Run", modelReturnView)); default: TempData["returnMessage"] = "Some error occurred when the system was trying to show the view: Generate New Season - Validate. (" + response.StatusCode + ")"; ModelState.AddModelError("", "application error."); return(View("GenerateNewSeason_Run", modelReturnView)); } } catch (Exception ex) { TempData["returnMessage"] = "Internal error - when the system was trying to show the view: Generate New Season - Validate. (" + ex.Message + ")"; ModelState.AddModelError("", "application error."); return(View("GenerateNewSeason_Run", modelReturnView)); } finally { response = null; modelReturnJSON = null; modelReturnView = null; } }
public ActionResult GenerateNewSeason_Run(FormCollection formHTML) { HttpResponseMessage response = new HttpResponseMessage(); GenerateNewSeasonDetailsModel modelReturnJSON = new GenerateNewSeasonDetailsModel(); GenerateNewSeasonGenerateModel modelReturnView = new GenerateNewSeasonGenerateModel(); //GenerateNewSeasonGenerateModel modelReturnForm = new GenerateNewSeasonGenerateModel(); string actionForm = "validateNewSeasonIsGenerated"; if (formHTML["actionForm"] != null) { actionForm = formHTML["actionForm"].ToLower(); } setViewBagVariables(); ViewBag.inFormScript = "1"; try { if (TempData["FullModel"] != null) { modelReturnView = (GenerateNewSeasonGenerateModel)TempData["FullModel"]; } if (actionForm == "validateNewSeasonIsGenerated") { modelReturnJSON.actionUser = "******"; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; } else if (actionForm == "prepare-databases-before") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; } else if (actionForm == "generate-new-season") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; //reset the model modelReturnView = new GenerateNewSeasonGenerateModel(); modelReturnView.DatabasesLookTheSame = modelReturnJSON.newSeasonModel.DatabasesLookTheSame; modelReturnView.NewSeasonIsGenerated = modelReturnJSON.newSeasonModel.NewSeasonIsGenerated; modelReturnView.hasEuroCup = modelReturnJSON.newSeasonModel.hasEuroCup; modelReturnView.hasEuropeLeague = modelReturnJSON.newSeasonModel.hasEuropeLeague; modelReturnView.hasSerieB_FUT = modelReturnJSON.newSeasonModel.hasSerieB_FUT; modelReturnView.hasSerieB_PRO = modelReturnJSON.newSeasonModel.hasSerieB_PRO; modelReturnView.hasSerieD_H2H = modelReturnJSON.newSeasonModel.hasSerieD_H2H; modelReturnView.hasWorldCup = modelReturnJSON.newSeasonModel.hasWorldCup; modelReturnJSON.newSeasonModel = modelReturnView; modelReturnJSON.newSeasonModel.startDate = DateTime.Now; modelReturnJSON.newSeasonModel.userID = Convert.ToInt32(Session["user.id"].ToString()); modelReturnJSON.newSeasonModel.userName = Session["user.name"].ToString(); modelReturnJSON.newSeasonModel.psnID = Session["user.psnID"].ToString(); response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; modelReturnView.actionUser = "******"; } else if (actionForm == "generate-new-season-caulculate-h2h") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; modelReturnView.actionUser = "******"; } else if (actionForm == "generate-new-season-caulculate-fut") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; modelReturnView.actionUser = "******"; } else if (actionForm == "generate-new-season-caulculate-pro") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; modelReturnView.actionUser = "******"; } else if (actionForm == "generate-new-season-leagues-h2h") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; modelReturnView.actionUser = "******"; } else if (actionForm == "generate-new-season-cups-h2h") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; modelReturnView.actionUser = "******"; } else if (actionForm == "generate-new-season-fut") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; modelReturnView.actionUser = "******"; } else if (actionForm == "generate-new-season-pro") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; modelReturnView.actionUser = "******"; } else if (actionForm == "generate-new-season-maintenance") { modelReturnJSON.actionUser = "******"; modelReturnJSON.newSeasonModel = modelReturnView; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateNewSeason", modelReturnJSON).Result; modelReturnView = response.Content.ReadAsAsync <GenerateNewSeasonGenerateModel>().Result; modelReturnView.actionUser = "******"; modelReturnView.endDate = DateTime.Now; } else { modelReturnView.returnMessage = "GenerateNewSeasonSuccessfully"; modelReturnView.actionUser = actionForm.ToUpper(); response.StatusCode = HttpStatusCode.Created; } switch (response.StatusCode) { case HttpStatusCode.Created: if (modelReturnView.returnMessage == "GenerateNewSeasonSuccessfully") { if (actionForm == "prepare-databases-before") { TempData["actionSuccessfully"] = "Staging Database was prepared successfully"; } else if (actionForm == "generate-new-season-maintenance") { TempData["actionSuccessfully"] = "The New Season were generated successfully"; } else if (actionForm == "cancel-renewal") { TempData["actionSuccessfully"] = "All renewal processes were cancelled successfully"; } } else { TempData["returnMessage"] = "Some error occurred when the system was trying to show the view: Generate New Season - Generate. (" + modelReturnView.returnMessage + ")"; modelReturnView.actionUser = "******"; } return(View(modelReturnView)); default: TempData["returnMessage"] = "Some error occurred when the system was trying to show the view: Generate New Season - Generate. (" + response.StatusCode + ")"; ModelState.AddModelError("", "application error."); modelReturnView.actionUser = "******"; return(View(modelReturnView)); } } catch (Exception ex) { TempData["returnMessage"] = "Internal error - when the system was trying to show the view: Generate New Season - Generate. (" + ex.Message + ")"; ModelState.AddModelError("", "application error."); modelReturnView.actionUser = "******"; return(View(modelReturnView)); } finally { response = null; modelReturnJSON = null; modelReturnView = 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; } }