public List <ResultsDTO> GetUsersRole() { SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); List <ResultsDTO> list = new List <ResultsDTO>(); using (sqlconn) { using (SqlCommand cmd = new SqlCommand("getUserRoles", sqlconn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; sqlconn.Open(); using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { ResultsDTO userCampaign = new ResultsDTO { UserId = rdr["UserId"].ToString(), RoleId = rdr["UserId"].ToString() }; list.Add(userCampaign); } } } } return(list); }
public IEnumerable <ResultsDTO> GetAllResults() { List <ResultsDTO> rList = new List <ResultsDTO>(); using (SqlConnection conn = new SqlConnection(dbConnection)) { using (SqlCommand cmd = new SqlCommand("usp_GetAllResults", conn)) { cmd.CommandType = CommandType.StoredProcedure; conn.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { ResultsDTO rDTO = new ResultsDTO(); try { rDTO.PlayerId = Convert.ToInt32(dataReader["PlayerId"].ToString()); } catch { rDTO.PlayerId = 0; } rDTO.Results = Convert.ToInt32(dataReader["Result"].ToString()); rDTO.Time = dataReader["Time"].ToString(); rDTO.Clicks = Convert.ToInt32(dataReader["Clicks"].ToString()); rList.Add(rDTO); } } conn.Close(); } return(rList); }
public bool addResult(ResultsDTO rDTO) { DatabaseManager addOneResult = new DatabaseManager(); bool isSuccesful = addOneResult.AddResult(rDTO); return(isSuccesful); }
public SearchModel(ResultsDTO dto) { this.jobId = dto.jobId; this.applicationId = dto.applicationId; this.contractCode = dto.contractCode; this.contractDesc = dto.contractDesc; this.districtCode = dto.districtCode; this.districtDesc = dto.districtDesc; this.jobAddress = dto.jobAddress; this.districtAddress = dto.districtAddress; this.districtPostCode = dto.districtPostCode; }
public ActionResult AddResultsToEncounter([FromBody] ResultsDTO results) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { encounterBusinessLogic.AddResults(results.Positions, results.EncounterId); return(Ok(new ResponseOkDTO())); } catch (Exception e) { return(StatusCode(500, e.Message)); } }
public bool AddResult(ResultsDTO rDTO) { bool isSuccessful = true; using (SqlConnection conn = new SqlConnection(dbConnection)) { using (SqlCommand cmd = new SqlCommand("usp_InsertResult", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PlayerId", rDTO.PlayerId); cmd.Parameters.AddWithValue("@Result", rDTO.Results); cmd.Parameters.AddWithValue("@Time", rDTO.Time); cmd.Parameters.AddWithValue("@Clicks", rDTO.Clicks); conn.Open(); cmd.ExecuteNonQuery(); } conn.Close(); } return(isSuccessful); }
public IActionResult Upcoming(string search) { ViewData["CurrentFilter"] = search; var all = _competitionService.GetUpcomingEvents(null, false); var athletics = _competitionService.GetUpcomingEvents(AthleticsId, false); var cycling = _competitionService.GetUpcomingEvents(CyclingId, false); var other = _competitionService.GetUpcomingEvents(0, false); if (!String.IsNullOrEmpty(search)) { var searchToUpper = search.ToUpper(); all = all.Where(u => u.CompetitionInstanceName.ToUpper().Contains(searchToUpper)); athletics = athletics.Where(u => u.CompetitionInstanceName.ToUpper().Contains(searchToUpper)); cycling = cycling.Where(u => u.CompetitionInstanceName.ToUpper().Contains(searchToUpper)); other = other.Where(u => u.CompetitionInstanceName.ToUpper().Contains(searchToUpper)); } var model = new ResultsDTO { All = all, Athletics = athletics, Cycling = cycling, Other = other }; return(View(model)); }
/// <summary> /// Returns the partial view of the results /// </summary> /// <param name="objAvailabilityDTO">AvailabilityDTO of the users paramaters for searching</param> /// <returns>Partial View</returns> // [HttpPost] public PartialViewResult GetResults(AvailabilityDTO objAvailabilityDTO) { //Gets all rooms with the same room type that have no bookings between the selected dates var temprooms = context.Rooms.Where(r => r.RoomTypeId == objAvailabilityDTO.RoomTypeId).Where(m => m.Reservations.All(r => r.Depature <= objAvailabilityDTO.Arrival || r.Arrival >= objAvailabilityDTO.Departure)); List <Room> rooms = new List <Room>(); foreach (Room r in temprooms) { rooms.Add(r); } ResultsDTO results = new ResultsDTO { AvailableRooms = rooms, Arrival = objAvailabilityDTO.Arrival, Departure = objAvailabilityDTO.Departure }; if (!results.AvailableRooms.Any()) { ViewBag.Any = "There is no available rooms during this time! "; } //returns the partial view to be displayed with Ajax dynamically return(PartialView("_Results", results)); }
// GET: Results/ResultsChart public ActionResult ResultsChart() { String uId = User.Identity.GetUserId(); // get logged in users Id ResultsViewModel rVM = new ResultsViewModel(); // get all the user roles ResultsDTO results = new ResultsDTO(); // List <ResultsDTO> resultsDTO = rVM.GetUsersRole(); bool found = false; foreach (var result in resultsDTO) { if (uId != result.UserId) { found = true; } } CampaignViewModel camVM = new CampaignViewModel(); // get all the campaign List <CampaignDTO> campaign = new List <CampaignDTO>(); campaign = camVM.GetAllCampaigns(); ChartsViewModel cVM = new ChartsViewModel(); RegisterViewModel userDetails = cVM.GetUserDetailsById(uId); // get signed in users details List <string> usersCountryCampainglist = new List <string>(); // get the campaigns name from the list campaings model and add them to string list if (found == true) // if the user exist { foreach (var cam in campaign) { if (userDetails.Country == cam.Country) { if (!usersCountryCampainglist.Contains(cam.Description.ToString())) { usersCountryCampainglist.Add(cam.Description); } } } } //bool isEmpty = !results.Any(); bool isEmpty = !usersCountryCampainglist.Any(); if (!isEmpty) // check if the list is not null than add the values to the object , else redirect the user that there are no campaigns in the country { results.Campagin = usersCountryCampainglist.First(); results.Campaigns = usersCountryCampainglist; ViewBag.Campaign = usersCountryCampainglist.First(); // get the first country for the Campaigns var collectedCampaign = usersCountryCampainglist.First(); // get the first country for the Campaigns CampaignDashBoardList(collectedCampaign); // default draw of the data return(View("~/Views/Results/ResultsChart.cshtml", results)); // return with the values to view. } else { return(View("~/Views/Results/NotFound.cshtml")); // no ca } }
public IActionResult HandleButtonClick(int index) { // set the size of the board int size = (int)Math.Sqrt(cells.Length); // selects the cell out of the cell list //Cell cell = cellList.ElementAt(index); MouseEventArgs me = new MouseEventArgs(); var User = HttpContext.Session.GetInt32("_Id"); UserID = (int)User; //if (cellList.ElementAt(index).visited == false) //{ if (me.Button.Equals(0)) { cellList.ElementAt(index).flagged = false; clickCount++; // Left click // check if the cell is a bomb if (cellList.ElementAt(index).live != true && cellList.ElementAt(index).liveNeighbors <= 1) { // Call the Flood Fill method cb.floodFill(cells, cellList.ElementAt(index).row, cellList.ElementAt(index).col, size); } else if (cellList.ElementAt(index).liveNeighbors > 1) { cellList.ElementAt(index).visited = true; } else if (cellList.ElementAt(index).live == true) { // set visited to true to reveal the bomb cellList.ElementAt(index).visited = true; lose = true; endTime = cb.stopTimer(); ResultData resultData = new ResultData(); ResultsDTO rDTO = new ResultsDTO(UserID, 0, endTime, clickCount); resultData.addResult(rDTO); } } // checks for win condition if (cb.boardCheck(cells, size) == true) { win = true; endTime = cb.stopTimer(); ResultData resultData = new ResultData(); ResultsDTO rDTO = new ResultsDTO(UserID, 1, endTime, clickCount); resultData.addResult(rDTO); } if (lose == true) { // reveals the board after a loss cb.revealBoard(cells, size); // Lose statement ViewBag.win = "BOOM! You set off a bomb! You Lose!"; } else if (win == true) { cb.revealBoard(cells, size); // win statement ViewBag.win = "All Bomb Locations Identified! You Win!"; } //} return(View("Board", cellList)); }