private void ContestsDataGrid_DoubleTapped(object sender, DoubleTappedRoutedEventArgs e) { // Check if any item is selected in contest ListView. if (ContestsDataGrid.SelectedIndex != -1) { ContestDetails contestDetails = (ContestDetails)ContestsDataGrid.SelectedItem; // Check if the contest has been created by the current user. if (Data.Instance.GetIfContestIsCreatedByCurrentUser(contestDetails.Id)) { this.Frame.Navigate(typeof(ContestPage), contestDetails); } else { this.Frame.Navigate(typeof(VotingPage), contestDetails); } } else { ContentDialog errorMsg = new ContentDialog { Title = "Error", Content = "You must select a contest to see it's details.", CloseButtonText = "OK" }; App.ShowContentDialog(errorMsg, null); } }
/// <summary> /// This method retrieves the most up-to-date list of contests from the database. /// </summary> /// <returns>True if success, false otherwise.</returns> public async Task <bool> RefreshContestsAdminAsync() { // Load the contest that the users has part in from the Database string query = "SELECT id_contest, contest_name, descript, start_date, limit_date, voting_limit_date " + "FROM contest_table"; SqlCommand cmd = DBSqlHelper.Connection.CreateCommand(); cmd.CommandText = query; // Execute query using (DbDataReader reader = await cmd.ExecuteReaderAsync()) { // Check if contest exists if (reader.HasRows) { ContestDetails.Clear(); while (await reader.ReadAsync()) { ContestDetails contest = new ContestDetails((int)reader[0], reader[1].ToString(), reader[2].ToString(), (DateTime)reader[3], (DateTime)reader[4], (DateTime)reader[5], false, false, false); ContestDetails.Add(contest); } return(true); } else { return(false); } } }
protected async override void OnNavigatedTo(NavigationEventArgs e) { base.OnNavigatedTo(e); ContestToLoad = (ContestDetails)e.Parameter; await LoadContestDetailsAsync(); }
private void ContestGrid_DoubleTapped(object sender, DoubleTappedRoutedEventArgs e) { // Get which contest is associated with this grid. if (ContestsListView.SelectedItems.Count == 1) { ContestDetails contestDetails = (ContestDetails)ContestsListView.SelectedItems[0]; this.Frame.Navigate(typeof(ContestPage), contestDetails); } }
private void NotificationsListView_SelectionChanged(object sender, SelectionChangedEventArgs e) { // Get selected notification id. int notificationId = ((NotificationListItem)NotificationsListView.SelectedItem).Id; // Get which contest that this notification corresponds to. ContestDetails contestToSelect = ContestDetailsList.Single(x => x.Id == notificationId); // Select the project. ContestsListView.SelectedItem = contestToSelect; }
public IActionResult Information() { ContestDetails contest = new ContestDetails(); contest.flagNameOne = HttpContext.Session.GetString("flagNameWithNameOne"); contest.flagNameTwo = HttpContext.Session.GetString("flagNameWithNameTwo"); contest.startingTime = HttpContext.Session.GetString("StartingTime"); PlayerRequest play = new PlayerRequest() { MatchId = Convert.ToInt32(HttpContext.Session.GetString("MatchId")), TourId = Convert.ToInt32(HttpContext.Session.GetString("tourId")) }; List <ContestDetailsResp> contestLst = _contestService.GetContestDetails(play); contest.ContestList = contestLst; return(View(contest)); }
private void Grid_DoubleTapped(object sender, DoubleTappedRoutedEventArgs e) { // Get which contest is associated with this grid. if (ContestsListView.SelectedItems.Count == 1) { ContestDetails contestDetails = (ContestDetails)ContestsListView.SelectedItems[0]; // Check if the contest has been created by the current user. if (Data.Instance.GetIfContestIsCreatedByCurrentUser(contestDetails.Id)) { this.Frame.Navigate(typeof(ContestPage), contestDetails); } else { this.Frame.Navigate(typeof(VotingPage), contestDetails); } } }
protected async override void OnNavigatedTo(NavigationEventArgs e) { base.OnNavigatedTo(e); LoadJudgesProgressRing.IsActive = true; LoadJudgesTextBlock.Visibility = Visibility.Visible; LoadProjectsProgressRing.IsActive = true; LoadProjectsTextBlock.Visibility = Visibility.Visible; LoadCriteriasProgressRing.IsActive = true; LoadCriteriasTextBlock.Visibility = Visibility.Visible; ContestToLoad = (ContestDetails)e.Parameter; if (ContestToLoad != null) { EditingContest = true; await LoadContestDetailsAsync(); } else { ContestToEdit = new Contest(-1, ContestToLoad, new ObservableCollection <Project>(), new ObservableCollection <JudgeMember>(), new ObservableCollection <Criteria>()); ContestToEdit.ContestDetails = new ContestDetails(); } LoadJudgesProgressRing.IsActive = false; LoadJudgesTextBlock.Visibility = Visibility.Collapsed; LoadProjectsProgressRing.IsActive = false; LoadProjectsTextBlock.Visibility = Visibility.Collapsed; LoadCriteriasProgressRing.IsActive = false; LoadCriteriasTextBlock.Visibility = Visibility.Collapsed; Judges = ContestToEdit.JudgeMembers; Projects = ContestToEdit.Projects; Criterias = ContestToEdit.Criterias; JudgesListView.ItemsSource = Judges; ProjectsListView.ItemsSource = Projects; CriteriaListView.ItemsSource = Criterias; }
public IActionResult ContestDetail(string contestName) { ContestDetails contest = new ContestDetails(); contest.flagNameOne = HttpContext.Session.GetString("flagNameWithNameOne"); contest.flagNameTwo = HttpContext.Session.GetString("flagNameWithNameTwo"); contest.startingTime = HttpContext.Session.GetString("StartingTime"); ContestRequest play = new ContestRequest() { MatchId = Convert.ToInt32(HttpContext.Session.GetString("MatchId")), TourId = Convert.ToInt32(HttpContext.Session.GetString("tourId")), SectionId = ContestHelper.GetContestSection(contestName) }; List <ContestDetailsResp> contestLst = _contestService.GetFullContestDetails(play); contest.ContestAdditionalLst = contestLst[0].AddonList; return(View(contest)); }
/// <summary> /// This method retrieves the most up-to-date list of contests from the database. /// </summary> /// <returns>True if success, false otherwise.</returns> public async Task <bool> RefreshContestsAsync() { // Load the contest that the users has part in from the Database string query = "SELECT id_contest, contest_name, descript, start_date, limit_date, voting_limit_date " + "FROM contest_table " + "WHERE id_contest IN( " + "SELECT id_contest FROM contest_juri_table contest " + "WHERE id_user = @id_user)"; SqlCommand cmd = DBSqlHelper.Connection.CreateCommand(); cmd.CommandText = query; SqlParameter sqlUserId = new SqlParameter("id_user", SqlDbType.Int); sqlUserId.Value = this.LoggedInUser.Id; cmd.Parameters.Add(sqlUserId); // Execute query using (DbDataReader reader = await cmd.ExecuteReaderAsync()) { // Check if contest exists if (reader.HasRows) { ContestDetails.Clear(); while (await reader.ReadAsync()) { ContestDetails contest = new ContestDetails((int)reader[0], reader[1].ToString(), reader[2].ToString(), (DateTime)reader[3], (DateTime)reader[4], (DateTime)reader[5], false, false, false); ContestDetails.Add(contest); } return(true); } else { return(false); } } }
private void ShowContestDetailsButton_Click(object sender, RoutedEventArgs e) { // Get which contest is associated with this grid. if (ContestsListView.SelectedItems.Count == 1) { ContestDetails contestDetails = (ContestDetails)ContestsListView.SelectedItems[0]; this.Frame.Navigate(typeof(ContestPage), contestDetails); } else { ContentDialog errorMsg = new ContentDialog { Title = "Error", Content = "You must select a contest to view it's details!", CloseButtonText = "OK" }; App.ShowContentDialog(errorMsg, null); } }
public ActionResult Index(FormCollection frm) { var usermanager = IdentityTools.NewUserManager(); //aktif kullanici ApplicationUser appuser = usermanager.FindByName(User.Identity.Name); var bonus = repoBonus.GetAll(x => x.UserId == appuser.Id && x.IsDeleted == false); //yarışma id int conid = Convert.ToInt16(frm["conid"]); var contest = repoCon.Get(x => x.Id == conid); //yarışma soruları vvar List <ContestDetails> cde = repoConDeta.GetAll(k => k.ContestId == conid).ToList(); //yarışma soruların id ekrandan geldi int id = Convert.ToInt16(frm["id"]); //soru ContestDetails cd = repoConDeta.Get(k => k.Id == id); string cvp = frm["answer"].ToString(); string numara = frm["num"].ToString(); if (bonus != null) { foreach (var item in bonus) { if (item.WheelValueId == 17 || item.WheelValueId == 10) { ViewBag.Saniye = "+"; } } } if (cd.TAns == cvp) { if ((contest.QuesCount).ToString() == numara) { var lasttrans = repoUserTrans.GetAll().OrderByDescending(x => x.Date).Take(1).FirstOrDefault(); lasttrans.Prize = contest.Prize; lasttrans.Balance = repoUserTrans.TotalBalance(appuser.Id) + contest.Prize; repoUserTrans.Update(); return(View("Win")); } return(View(cde[Convert.ToInt16(numara)])); } else { if (bonus != null) { foreach (var item in bonus) { if (item.WheelValueId == 9 && item.IsDeleted == false) { item.IsDeleted = true; repoBonus.Update(); ViewBag.Joker = "Yanlış cevap jokeri kullanıldı"; return(View(cde[Convert.ToInt16(numara)])); } } } return(View("Loose")); } }
/// <summary> /// Gets the contest with all details filled out from the database. /// </summary> /// <param name="id">The contest id to retrieve.</param> /// <returns>The contest object if it exists, null otherwise.</returns> public async Task <Contest> GetContest(int id) { // Varaiables declaration. Contest contest; SqlCommand cmd; SqlParameter sqlContestId, sqlUserId; string query; ObservableCollection <Project> contestProjects = new ObservableCollection <Project>(); ObservableCollection <JudgeMember> contestJudges = new ObservableCollection <JudgeMember>(); ObservableCollection <Criteria> contestCriterias = new ObservableCollection <Criteria>(); // Get the contest details from the database. query = "SELECT * " + "FROM contest_table " + "WHERE id_contest = @id_contest"; cmd = DBSqlHelper.Connection.CreateCommand(); cmd.CommandText = query; sqlUserId = new SqlParameter("id_user", SqlDbType.Int); sqlUserId.Value = LoggedInUser.Id; cmd.Parameters.Add(sqlUserId); sqlContestId = new SqlParameter("id_contest", SqlDbType.Int); sqlContestId.Value = id; cmd.Parameters.Add(sqlContestId); using (DbDataReader reader = await cmd.ExecuteReaderAsync()) { // Check if the contest exists. if (reader.HasRows) { await reader.ReadAsync(); ContestDetails contestDetails = new ContestDetails(id, reader.GetString(1), reader.GetString(2), reader.GetDateTime(3), reader.GetDateTime(4), reader.GetDateTime(5), false, false, false); contest = new Contest(id, contestDetails, new ObservableCollection <Project>(), new ObservableCollection <JudgeMember>(), new ObservableCollection <Criteria>()); } else { return(null); } } // Get the contest project list. query = "SELECT id_project, name, descript, id_category, project_year FROM project_table WHERE id_contest = @id_contest ORDER BY id_project"; cmd = DBSqlHelper.Connection.CreateCommand(); cmd.CommandText = query; sqlContestId = new SqlParameter("id_contest", SqlDbType.Int); sqlContestId.Value = id; cmd.Parameters.Add(sqlContestId); using (DbDataReader reader = await cmd.ExecuteReaderAsync()) { // Check if there's any projects in the contest. if (reader.HasRows) { // Read every project, and store it in a list. while (await reader.ReadAsync()) { Project project = new Project(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), new Category(reader.GetInt32(3), ""), reader.GetInt32(4)); contestProjects.Add(project); } } } // Cycle through all projects and get the full category. foreach (Project project in contestProjects) { foreach (Category category in this.Categories) { // Check if the project category id is the same as the category id. if (project.Category.Id == category.Id) { // Assign the category to the project category. project.Category = category; } } // Query the database to get the project promoters. query = "SELECT id_promoter, name, date_of_birth FROM promoter_table WHERE id_project = @id_project"; cmd = DBSqlHelper.Connection.CreateCommand(); cmd.CommandText = query; cmd.Parameters.Add(new SqlParameter("@id_project", project.Id)); project.Promoters = new ObservableCollection <Promoter>(); using (DbDataReader reader = await cmd.ExecuteReaderAsync()) { // Check if there's any projects in the contest. if (reader.HasRows) { // Read every project, and store it in a list. while (await reader.ReadAsync()) { Promoter promoter = new Promoter(reader.GetInt32(0), reader.GetString(1), reader.GetDateTime(2)); project.Promoters.Add(promoter); } } } } contest.Projects = contestProjects; // Get the contest judge list. query = "SELECT id_user, president FROM contest_juri_table WHERE id_contest = @id_contest ORDER BY id_user"; cmd = DBSqlHelper.Connection.CreateCommand(); cmd.CommandText = query; sqlContestId = new SqlParameter("id_contest", SqlDbType.Int); sqlContestId.Value = id; cmd.Parameters.Add(sqlContestId); using (DbDataReader reader = await cmd.ExecuteReaderAsync()) { // Check if there's any judges in the contest. if (reader.HasRows) { // Read every judge, and store it in a list. while (await reader.ReadAsync()) { // Check if it's not the president. if (!reader.GetBoolean(1)) { JudgeMember judge = new JudgeMember(reader.GetInt32(0), ""); contestJudges.Add(judge); } } } } // Cycle through all judges and get the full details. foreach (JudgeMember contestJudge in contestJudges) { foreach (JudgeMember judge in this.JudgeMembers) { // Check if the contest judge id is the same as the stored judge id. if (contestJudge.Id == judge.Id) { // Assign the judge details to the contest judge. contestJudge.Name = judge.Name; } } } contest.JudgeMembers = contestJudges; // Get the contest criteria list. query = "SELECT id_criteria FROM contest_criteria_table WHERE id_contest = @id_contest ORDER BY id_criteria"; cmd = DBSqlHelper.Connection.CreateCommand(); cmd.CommandText = query; sqlContestId = new SqlParameter("id_contest", SqlDbType.Int); sqlContestId.Value = id; cmd.Parameters.Add(sqlContestId); using (DbDataReader reader = cmd.ExecuteReader()) { // Check if there's any criterias in the contest. if (reader.HasRows) { // Read every criteria, and store it in a list. while (reader.Read()) { Criteria criteria = new Criteria(reader.GetInt32(0), "", ""); contestCriterias.Add(criteria); } } } // Refresh the criteria list. await this.RefreshCriteriasAsync(); // Cycle through all criteria and get the full details. foreach (Criteria contestCriteria in contestCriterias) { foreach (Criteria criteria in this.Criterias) { // Check if the criteria judge id is the same as the stored judge id. if (contestCriteria.Id == criteria.Id) { // Assign the criteria details to the contest criteria. contestCriteria.Name = criteria.Name; contestCriteria.Description = criteria.Description; } } } contest.Criterias = contestCriterias; return(contest); }
public ActionResult Create([Bind(Include = "Id,ConName,ConTypeId,QuesCount,Level,Price,Prize,Date,IsDeleted")] Contest contest) { switch (contest.ConTypeId) { case 2: contest.Picture = "/img/genelkültür.jpg"; break; case 4: contest.Picture = "/img/cografyayarisma.jpg"; break; case 5: contest.Picture = "/img/sanat.jpg"; break; case 6: contest.Picture = "/img/tarih.jpg"; break; case 7: contest.Picture = "/img/spor.jpg"; break; case 8: contest.Picture = "/img/genelyarisma.jpg"; break; } if (ModelState.IsValid) { ContestDetails cd = new ContestDetails(); ContestType contype = repoConType.Get(x => x.Id == contest.ConTypeId); string type = contype.TypeName; db.Contests.Add(contest); for (int i = 0; i < contest.QuesCount; i++) { Questions qe = new Questions(); if (type == "Genel") { qe = db.Questions.Where(u => u.IsDeleted == false && u.Level == 1).OrderBy(u => Guid.NewGuid()).Take(1).FirstOrDefault(); } else { qe = db.Questions.Where(u => u.IsDeleted == false && u.QType == type && u.Level == 1).OrderBy(u => Guid.NewGuid()).Take(1).FirstOrDefault(); } cd.ContestId = contest.Id; cd.QuesId = qe.Id; cd.ContestType = type; cd.QuesNum = (i + 1); cd.Question = qe.Question; cd.Ans1 = qe.Ans1; cd.Ans2 = qe.Ans2; cd.Ans3 = qe.Ans3; cd.Ans4 = qe.Ans4; cd.TAns = qe.TrueAns; cd.IsDeleted = false; db.ContestDetails.Add(cd); qe.IsDeleted = true; db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(contest)); }