public ActionResult RenewalNewSeason() { HttpResponseMessage response = null; GenerateRenewalViewModel modelReturnJSON = new GenerateRenewalViewModel(); renewalDetailsModel model = new renewalDetailsModel(); try { model.userID = Convert.ToInt16(Session["user.id"]); model.userName = Session["user.name"].ToString(); model.psnID = Session["user.psnID"].ToString(); model.actionUser = "******"; modelReturnJSON.renewalModel = model; modelReturnJSON.actionUser = model.actionUser; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateRenewal", modelReturnJSON).Result; modelReturnJSON = response.Content.ReadAsAsync <GenerateRenewalViewModel>().Result; switch (response.StatusCode) { case HttpStatusCode.Created: if (modelReturnJSON.returnMessage == "GenerateRenewalSuccessfully") { return(View(modelReturnJSON.renewalModel)); } else { //ModelState.AddModelError("", "Senha Atual inválida! Favor tentar novamente."); TempData["returnMessage"] = "Ocorreu algum erro na exibição da tela de renovação para a próxima temporda - todas as modalidades. (" + modelReturnJSON.returnMessage + ")"; return(View(model)); } default: TempData["returnMessage"] = "Ocorreu algum erro na exibição da tela de renovação para a próxima temporda - todas as modalidades. (" + response.StatusCode + ")"; ModelState.AddModelError("", "application error."); return(View(model)); } } catch (Exception ex) { TempData["returnMessage"] = "Erro interno - renovação próxima temporada - todas as modalidades: (" + ex.Message + ")"; ModelState.AddModelError("", "application error."); return(View(model)); } finally { response = null; modelReturnJSON = null; model = null; } }
public ActionResult GenerateRenewal(FormCollection formHTML) { HttpResponseMessage response = new HttpResponseMessage(); GenerateRenewalViewModel modelReturnJSON = new GenerateRenewalViewModel(); GenerateRenewalViewModel modelReturnView = new GenerateRenewalViewModel(); string actionForm = "summary"; if (formHTML["actionForm"] != null) { actionForm = formHTML["actionForm"].ToLower(); } setViewBagVariables(); try { if (TempData["FullModel"] != null) { modelReturnView = (GenerateRenewalViewModel)TempData["FullModel"]; } modelReturnJSON.inRenewalWithWorldCup = Convert.ToInt16(ConfigurationManager.AppSettings["renewal.h2h.worldcup"].ToString()); modelReturnJSON.inRenewalWithEuro = Convert.ToInt16(ConfigurationManager.AppSettings["renewal.h2h.uefaeuro"].ToString()); if (actionForm == "summary") { modelReturnJSON.actionUser = "******"; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateRenewal", modelReturnJSON).Result; modelReturnJSON = response.Content.ReadAsAsync <GenerateRenewalViewModel>().Result; } else if (actionForm == "prepare-database-before") { modelReturnJSON = modelReturnView; modelReturnJSON.actionUser = "******"; modelReturnJSON.dataBaseName = GlobalVariables.DATABASE_NAME_STAGING; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateRenewal", modelReturnJSON).Result; modelReturnJSON = response.Content.ReadAsAsync <GenerateRenewalViewModel>().Result; } else if (actionForm == "generate-renewal") { modelReturnJSON = modelReturnView; modelReturnJSON.actionUser = "******"; modelReturnJSON.dataBaseName = GlobalVariables.DATABASE_NAME_STAGING; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateRenewal", modelReturnJSON).Result; modelReturnJSON = response.Content.ReadAsAsync <GenerateRenewalViewModel>().Result; } else if (actionForm == "cancel-renewal") { modelReturnJSON = modelReturnView; modelReturnJSON.actionUser = "******"; modelReturnJSON.dataBaseName = GlobalVariables.DATABASE_NAME_STAGING; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateRenewal", modelReturnJSON).Result; modelReturnJSON = response.Content.ReadAsAsync <GenerateRenewalViewModel>().Result; } else if (actionForm == "create-spooler") { modelReturnJSON = modelReturnView; modelReturnJSON.actionUser = "******"; modelReturnJSON.dataBaseName = GlobalVariables.DATABASE_NAME_STAGING; modelReturnJSON.userActionID = Convert.ToInt32(Session["user.id"]); response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateRenewal", modelReturnJSON).Result; modelReturnJSON = response.Content.ReadAsAsync <GenerateRenewalViewModel>().Result; } else if (actionForm == "cancel-spooler") { modelReturnJSON = modelReturnView; modelReturnJSON.actionUser = "******"; modelReturnJSON.dataBaseName = GlobalVariables.DATABASE_NAME_STAGING; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateRenewal", modelReturnJSON).Result; modelReturnJSON = response.Content.ReadAsAsync <GenerateRenewalViewModel>().Result; } else { modelReturnJSON.returnMessage = "GenerateRenewalSuccessfully"; modelReturnJSON.actionUser = actionForm.ToUpper(); response.StatusCode = HttpStatusCode.Created; } switch (response.StatusCode) { case HttpStatusCode.Created: if (modelReturnJSON.returnMessage == "GenerateRenewalSuccessfully") { if (actionForm == "prepare-database-before") { TempData["actionSuccessfully"] = "Staging Database was prepared successfully"; } else if (actionForm == "generate-renewal") { TempData["actionSuccessfully"] = "The renewals were generated successfully"; } else if (actionForm == "cancel-renewal") { TempData["actionSuccessfully"] = "All renewal processes were cancelled successfully"; } else if (actionForm == "cancel-spooler") { TempData["actionSuccessfully"] = "The email spooler for renewal was cancelled successfully"; } else if (actionForm == "create-spooler") { TempData["actionSuccessfully"] = "The email spooler for renewal was created successfully"; } } else { TempData["returnMessage"] = "Some error occurred when the system was trying to show the view: Generate Renewal - Summary. (" + modelReturnJSON.returnMessage + ")"; } return(View(modelReturnJSON)); default: TempData["returnMessage"] = "Some error occurred when the system was trying to show the view: Generate Renewal - Summary. (" + response.StatusCode + ")"; ModelState.AddModelError("", "application error."); return(View(modelReturnView)); } } catch (Exception ex) { TempData["returnMessage"] = "Internal error - when the system was trying to show the view: Generate Renewal - Summary. (" + ex.Message + ")"; ModelState.AddModelError("", "application error."); return(View(modelReturnView)); } finally { response = null; modelReturnJSON = null; modelReturnView = 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; } }
public IHttpActionResult hallOfFame(GenerateRenewalViewModel model) { if (String.IsNullOrEmpty(model.dataBaseName)) { model.dataBaseName = GlobalVariables.DATABASE_NAME_ONLINE; } db.openConnection(model.dataBaseName); DataTable dt = null; try { if (model.actionUser == "summary") { getSummaryDetails(ref model, db); return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "prepareDatabaseBefore") { paramName = new string[] { }; paramValue = new string[] { }; db.executePROCNonResult("spDeleteAllRecords", paramName, paramValue); db.executePROCNonResult("spTransferDataFromOnlineDtb", paramName, paramValue); getSummaryDetails(ref model, db, true); return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "generateRenewal") { string inWorldCup_Euro = "0"; if (model.inRenewalWithEuro == 1 || model.inRenewalWithWorldCup == 1) { inWorldCup_Euro = "1"; } paramName = new string[] { "pInWorldCupNextSeason" }; paramValue = new string[] { inWorldCup_Euro }; db.executePROCNonResult("spGenerateRenewalsForNextSeason", paramName, paramValue); getSummaryDetails(ref model, db, true); return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "createSpooler") { paramName = new string[] { "pIdUsuAction" }; paramValue = new string[] { model.userActionID.ToString() }; db.executePROCNonResult("spCreateRenewalSpoolerForNextSeason", paramName, paramValue); getSummaryDetails(ref model, db, true); return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "cancelRenewal") { paramName = new string[] { }; paramValue = new string[] { }; db.executePROCNonResult("spCancelRenewalsForNextSeason", paramName, paramValue); getSummaryDetails(ref model, db, true); return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "cancelSpooler") { paramName = new string[] { }; paramValue = new string[] { }; db.executePROCNonResult("spCancelRenewalSpoolerForNextSeason", paramName, paramValue); getSummaryDetails(ref model, db, true); return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "getDetailsRenewalHome") { paramName = new string[] { "pIdUser" }; paramValue = new string[] { model.renewalModel.userID.ToString() }; dt = db.executePROC("spGetAllDetailsRenewalHome", paramName, paramValue); model.renewalModel.seasonID = Convert.ToInt16(dt.Rows[0]["temporadaID"].ToString()); if (!String.IsNullOrEmpty(dt.Rows[0]["confirmH2H"].ToString())) { if (dt.Rows[0]["confirmH2H"].ToString() == "1") { model.renewalModel.checkYESH2H = true; } else if (dt.Rows[0]["confirmH2H"].ToString() == "0") { model.renewalModel.checkNOH2H = true; } } if (!String.IsNullOrEmpty(dt.Rows[0]["confirmFUT"].ToString())) { if (dt.Rows[0]["confirmFUT"].ToString() == "1") { model.renewalModel.checkYESFUT = true; } else if (dt.Rows[0]["confirmFUT"].ToString() == "0") { model.renewalModel.checkNOFUT = true; } } if (!String.IsNullOrEmpty(dt.Rows[0]["confirmPRO"].ToString())) { if (dt.Rows[0]["confirmPRO"].ToString() == "1") { model.renewalModel.checkYESPRO = true; } else if (dt.Rows[0]["confirmPRO"].ToString() == "0") { model.renewalModel.checkNOPRO = true; } } if (!String.IsNullOrEmpty(dt.Rows[0]["confirmWC"].ToString())) { if (dt.Rows[0]["confirmWC"].ToString() == "1") { model.renewalModel.checkYESWDC = true; } else if (dt.Rows[0]["confirmWC"].ToString() == "0") { model.renewalModel.checkNOWDC = true; } } if (!String.IsNullOrEmpty(dt.Rows[0]["nmTimeFUT"].ToString())) { model.renewalModel.teamNameFUT = dt.Rows[0]["nmTimeFUT"].ToString(); } if (!String.IsNullOrEmpty(dt.Rows[0]["nmTimePRO"].ToString())) { model.renewalModel.teamNamePRO = dt.Rows[0]["nmTimePRO"].ToString(); } if (!String.IsNullOrEmpty(dt.Rows[0]["mobile"].ToString())) { model.renewalModel.ddd = dt.Rows[0]["ddd"].ToString(); model.renewalModel.mobile = dt.Rows[0]["mobile"].ToString(); } model.returnMessage = "GenerateRenewalSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else if (model.actionUser == "saveRenewalNewSeasonHome") { int confirmH2H = -1; int confirmFUT = -1; int confirmPRO = -1; int confirmWC = -1; if (model.renewalModel.checkYESH2H) { confirmH2H = 1; } else if (model.renewalModel.checkYESH2H) { confirmH2H = 0; } if (model.renewalModel.checkYESFUT) { confirmFUT = 1; } else if (model.renewalModel.checkNOFUT) { confirmFUT = 0; } if (model.renewalModel.checkYESPRO) { confirmPRO = 1; } else if (model.renewalModel.checkNOPRO) { confirmPRO = 0; } if (model.renewalModel.checkYESWDC) { confirmWC = 1; } else if (model.renewalModel.checkNOWDC) { confirmWC = 0; } paramName = new string[] { "pIdTemporada", "pIdUsu", "pInConfirmH2H", "pInConfirmFUT", "pInConfirmPRO", "pInConfirmWC", "pNmTeamFUT", "pNmTeamPRO", "pDDD", "pMobile" }; paramValue = new string[] { model.renewalModel.seasonID.ToString(), model.renewalModel.userID.ToString(), confirmH2H.ToString(), confirmFUT.ToString(), confirmPRO.ToString(), confirmWC.ToString(), model.renewalModel.teamNameFUT, model.renewalModel.teamNamePRO, model.renewalModel.ddd, model.renewalModel.mobile }; db.executePROCNonResult("spControlConfirmacaoTemporada", paramName, paramValue); model.returnMessage = "GenerateRenewalSuccessfully"; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } else { return(StatusCode(HttpStatusCode.NotAcceptable)); } } catch (Exception ex) { model.returnMessage = "error_" + ex.Message; return(CreatedAtRoute("DefaultApi", new { id = 0 }, model)); } finally { db.closeConnection(); dt = null; } }
public ActionResult ValidateRenewalNewSeason(renewalDetailsModel model, FormCollection formHTML) { HttpResponseMessage response = new HttpResponseMessage();; GenerateRenewalViewModel modelReturnJSON = new GenerateRenewalViewModel(); Boolean executeProcSaveRenewal = false; string messageReturnERROR = String.Empty; string nameFieldViewERROR = string.Empty; try { model.userID = Convert.ToInt16(Session["user.id"]); model.userName = Session["user.name"].ToString(); model.psnID = Session["user.psnID"].ToString(); modelReturnJSON.returnMessage = "GenerateRenewalSuccessfully"; response.StatusCode = HttpStatusCode.Created; if (!String.IsNullOrEmpty(formHTML["rdoModeH2H"])) { if (formHTML["rdoModeH2H"] == "1") { model.checkYESH2H = true; model.checkNOH2H = false; } else { model.checkYESH2H = false; model.checkNOH2H = true; } } if (!String.IsNullOrEmpty(formHTML["rdoModeWC"])) { if (formHTML["rdoModeWC"] == "1") { model.checkYESWDC = true; model.checkNOWDC = false; } else { model.checkYESWDC = false; model.checkNOWDC = true; } } if (!String.IsNullOrEmpty(formHTML["rdoModeFUT"])) { if (formHTML["rdoModeFUT"] == "1") { model.checkYESFUT = true; model.checkNOFUT = false; } else { model.checkYESFUT = false; model.checkNOFUT = true; } } if (!String.IsNullOrEmpty(formHTML["rdoModePRO"])) { if (formHTML["rdoModePRO"] == "1") { model.checkYESPRO = true; model.checkNOPRO = false; } else { model.checkYESPRO = false; model.checkNOPRO = true; } } if (formHTML["rdoModeFUT"] == "1" && formHTML["teamNameFUT"] == String.Empty) { messageReturnERROR = "O campo 'Nome do Time FUT' é obrigatório porque a modalidade FUT foi selecionada"; nameFieldViewERROR = "teamNameFUT"; } else if (formHTML["rdoModePRO"] == "1" && formHTML["teamNamePRO"] == String.Empty) { messageReturnERROR = "O campo 'Nome do Clube' é obrigatório porque a modalidade PRO CLUB foi selecionada"; nameFieldViewERROR = "teamNamePRO"; } else if ((formHTML["ddd"] == String.Empty && formHTML["mobile"] != String.Empty) || (formHTML["ddd"] != String.Empty && formHTML["mobile"] == String.Empty)) { messageReturnERROR = "O campo 'Celular (DDD & Numero)' está inválido, ambos os números devem ser informados"; nameFieldViewERROR = "mobile"; } else if (formHTML["rdoModeH2H"] == null && formHTML["rdoModeWC"] == null && formHTML["rdoModeFUT"] == null && formHTML["rdoModePRO"] == null) { messageReturnERROR = "Não foi possível executar o processo de renovação pois NENHUMA modalidade foi selecionada"; } else { executeProcSaveRenewal = true; model.actionUser = "******"; modelReturnJSON.renewalModel = model; modelReturnJSON.actionUser = model.actionUser; response = GlobalVariables.WebApiClient.PostAsJsonAsync("GenerateRenewal", modelReturnJSON).Result; modelReturnJSON = response.Content.ReadAsAsync <GenerateRenewalViewModel>().Result; } if (!String.IsNullOrEmpty(messageReturnERROR)) { TempData["returnMessage"] = messageReturnERROR; if (!String.IsNullOrEmpty(nameFieldViewERROR)) { ModelState.AddModelError(nameFieldViewERROR, messageReturnERROR); } } switch (response.StatusCode) { case HttpStatusCode.Created: if (modelReturnJSON.returnMessage == "GenerateRenewalSuccessfully") { if (executeProcSaveRenewal) { return(RedirectToAction("RenewalNewSeasonConfirmation", "Home", modelReturnJSON.renewalModel)); } else { return(View("RenewalNewSeason", model)); } } else { //ModelState.AddModelError("", "Senha Atual inválida! Favor tentar novamente."); TempData["returnMessage"] = "Ocorreu algum erro na inscrição do banco de Reservas H2H e/ou FUT. (" + modelReturnJSON.returnMessage + ")"; return(View("RenewalNewSeason", model)); } default: TempData["returnMessage"] = "Ocorreu algum erro na inscrição do banco de Reservas H2H e/ou FUT. (" + response.StatusCode + ")"; ModelState.AddModelError("", "application error."); return(View("RenewalNewSeason", model)); } } catch (Exception ex) { TempData["returnMessage"] = "Erro interno - inscrevendo-se no banco - H2H e/ou FUT: (" + ex.Message + ")"; ModelState.AddModelError("", "application error."); return(View("RenewalNewSeason", model)); } finally { response = null; modelReturnJSON = null; } }