protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Set report mode for local processing. rv1.ProcessingMode = ProcessingMode.Local; rv1.LocalReport.DataSources.Clear(); var weekid = int.Parse(Request.QueryString["weekid"]); var ds = new LeaguesDS(); using (LeaguesEntities db = new LeaguesEntities()) { var list = db.Tuesday_GetMatchAll(weekid).ToList(); foreach (var item in list) { ds.TuesdayScoreCards.AddTuesdayScoreCardsRow( item.Rink.ToString(), item.Skip1, item.Date, item.Lead1, item.Skip2, item.Lead2, item.Team1.ToString(), item.Team2.ToString()); } } rv1.LocalReport.ReportPath = "./Reports/ReportFiles/TuesdayScoreCard.rdlc"; rv1.LocalReport.DataSources.Add(new ReportDataSource("Match", ds.TuesdayScoreCards.Rows)); // Refresh the ReportViewer. rv1.LocalReport.Refresh(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Set report mode for local processing. rv1.ProcessingMode = ProcessingMode.Local; rv1.LocalReport.DataSources.Clear(); var ds = new LeaguesDS(); using (LeaguesEntities db = new LeaguesEntities()) { var list = db.TuesdayTeams.OrderBy(x => x.id).ToList(); foreach (var item in list) { ds.TuesdayTeam.AddTuesdayTeamRow(item.id, item.Player.FullName, item.Lead.HasValue ? item.Player1.FullName : ""); } } rv1.LocalReport.DataSources.Add(new ReportDataSource("Team", ds.TuesdayTeam.Rows)); //parameters rv1.ShowToolBar = true; // Refresh the ReportViewer. rv1.LocalReport.Refresh(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var league = Request.QueryString["league"]; // Set report mode for local processing. rv1.ProcessingMode = ProcessingMode.Local; rv1.LocalReport.DataSources.Clear(); var ds = new LeaguesDS(); using (LeaguesEntities db = new LeaguesEntities()) { if (league == "Tuesday") { var list1 = db.TuesdayMatches.Where(x => x.Rink == -1).ToList(); foreach (var item in list1) { ds.Byes.AddByesRow(item.TuesdaySchedule.GameDate.ToShortDateString(), item.Team1, item.TuesdayTeam.Player.NickName + ", " + item.TuesdayTeam.Player1.NickName); } } else { foreach (var item in db.WednesdayMatches.Where(x => x.Rink == -1)) { ds.Byes.AddByesRow(item.WednesdaySchedule.GameDate.ToShortDateString(), item.Team1, item.WednesdayTeam.Player.NickName + ", " + item.WednesdayTeam.Player1.NickName); } } } rv1.LocalReport.DataSources.Add(new ReportDataSource("Byes", ds.Byes.Rows)); var p2 = new ReportParameter("League", league); rv1.LocalReport.SetParameters(new ReportParameter[] { p2 }); //parameters rv1.ShowToolBar = true; // Refresh the ReportViewer. rv1.LocalReport.Refresh(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Set report mode for local processing. rv1.ProcessingMode = ProcessingMode.Local; // Validate report source. //var rptPath = Server.MapPath(@"./Reports/BowlsInventory.rdlc"); //if(!File.Exists(rptPath)) // return; // Set report path. //this.rv1.LocalReport.ReportPath = rptPath; rv1.LocalReport.DataSources.Clear(); var ds = new LeaguesDS(); using (LeaguesEntities db = new LeaguesEntities()) { var list = db.WednesdayTeams.OrderBy(x => x.id).ToList(); foreach (var item in list) { ds.WednesdayTeam.AddWednesdayTeamRow(item.id, item.Player.FullName, item.ViceSkip.HasValue ? item.Player1.FullName : "", item.Lead.HasValue ? item.Player2.FullName : ""); } } rv1.LocalReport.DataSources.Add(new ReportDataSource("Team", ds.WednesdayTeam.Rows)); //parameters rv1.ShowToolBar = true; // Refresh the ReportViewer. rv1.LocalReport.Refresh(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var weekid = int.Parse(Request.QueryString["weekid"]); // Set report mode for local processing. rv1.ProcessingMode = ProcessingMode.Local; rv1.LocalReport.DataSources.Clear(); var ds = new LeaguesDS(); var WeekDate = ""; bool IsBye = false; bool isCancelled = false; using (LeaguesEntities db = new LeaguesEntities()) { var week = db.WednesdaySchedules.Find(weekid); WeekDate = week.GameDateFormatted; if (!week.IsCancelled) { var list = db.WednesdayMatches.Where(x => x.GameDate == weekid && x.Rink != -1) .OrderBy(x => x.Rink).ToList(); foreach (var item in list) { var forfeit = ""; switch (item.Forfeit) { case 2: forfeit = item.Team1.ToString(); break; case 3: forfeit = item.Team2.ToString(); break; } ds.Game.AddGameRow(item.Team1, item.WednesdayTeam.Player.NickName + ", " + item.WednesdayTeam.Player1.NickName + ", " + item.WednesdayTeam.Player2.NickName, item.Team2.Value, item.WednesdayTeam1.Player.NickName + ", " + item.WednesdayTeam1.Player1.NickName + ", " + item.WednesdayTeam1.Player2.NickName, item.Team1Score, item.Team2Score, item.Rink, forfeit); } var matches = db.WednesdayMatches.Where(x => x.Rink == -1 && x.GameDate == weekid); if (matches.Any()) { var match = matches.First(); ds.Byes.AddByesRow(match.WednesdaySchedule.GameDateFormatted, match.Team1, match.WednesdayTeam.Player.NickName + ", " + match.WednesdayTeam.Player1.NickName + ", " + match.WednesdayTeam.Player2.NickName); rv1.LocalReport.DataSources.Add(new ReportDataSource("Bye", ds.Byes.Rows)); IsBye = true; } else { rv1.LocalReport.DataSources.Add(new ReportDataSource("Bye", new System.Data.DataTable())); } rv1.LocalReport.DataSources.Add(new ReportDataSource("Game", ds.Game.Rows)); } else { isCancelled = true; rv1.LocalReport.DataSources.Add(new ReportDataSource("Game", new System.Data.DataTable())); rv1.LocalReport.DataSources.Add(new ReportDataSource("Bye", new System.Data.DataTable())); } } rv1.LocalReport.DataSources.Add(new ReportDataSource("Stand", CalculateStandings.Wednesday(weekid).Rows)); var p1 = new ReportParameter("WeekDate", WeekDate); var p2 = new ReportParameter("League", "Wednesday"); var p3 = new ReportParameter("IsBye", IsBye?"1":"0"); var p4 = new ReportParameter("Cancelled", isCancelled ? "1" : "0"); rv1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4 }); //parameters rv1.ShowToolBar = true; // Refresh the ReportViewer. rv1.LocalReport.Refresh(); } }
public static LeaguesDS.StandingDataTable Wednesday(int weekid) { var ds = new LeaguesDS(); var list = new List <Standing>(); using (var db = new LeaguesEntities()) { var list1 = db.WednesdayTeams.ToList(); foreach (var team in list1) { list.Add(new Standing() { TeamNumber = team.id, Wins = 0, Loses = 0, TotalScore = 0, Players = team.Player.NickName + ", " + team.Player1.NickName + ", " + team.Player2.NickName }); } var list2 = db.WednesdaySchedules.Where(x => x.id <= weekid).ToList(); foreach (var week in list2) { if (week.IsCancelled) { continue; } var total = 0; var numMatches = 0; var bye = false; int forfeit = 0; var list4 = db.WednesdayMatches.Where(x => x.GameDate == week.id).ToList(); foreach (var match in list4) { if (match.Team1Score > match.Team2Score && match.Rink != -1 && match.Forfeit == 1) { var winner = list.Find(x => x.TeamNumber == match.Team1); var loser = list.Find(x => x.TeamNumber == match.Team2); winner.Wins++; loser.Loses++; winner.TotalScore += Math.Min(20, match.Team1Score); loser.TotalScore += Math.Min(20, match.Team2Score); total += Math.Min(20, match.Team1Score); numMatches++; } else if (match.Rink != -1 && match.Forfeit == 1) { var winner = list.Find(x => x.TeamNumber == match.Team2); var loser = list.Find(x => x.TeamNumber == match.Team1); winner.Wins++; loser.Loses++; winner.TotalScore += Math.Min(20, match.Team2Score); loser.TotalScore += Math.Min(20, match.Team1Score); total += Math.Min(20, match.Team2Score); numMatches++; } else if (match.Rink != -1 && match.Forfeit == 3) { var winner = list.Find(x => x.TeamNumber == match.Team1); var loser = list.Find(x => x.TeamNumber == match.Team2); forfeit++; winner.Wins++; loser.Loses++; } else if (match.Rink != -1 && match.Forfeit == 2) { var winner = list.Find(x => x.TeamNumber == match.Team2); var loser = list.Find(x => x.TeamNumber == match.Team1); winner.Wins++; loser.Loses++; forfeit++; } else { var winner = list.Find(x => x.TeamNumber == match.Team1); winner.Wins++; bye = true; } } if (bye || forfeit > 0) { var list3 = db.WednesdayMatches.Where(x => x.GameDate == week.id).ToList(); foreach (var match in list3) { if (match.Rink != -1 && match.Forfeit == 3) { var winner = list.Find(x => x.TeamNumber == match.Team1); winner.TotalScore += total / numMatches; } else if (match.Rink != -1 && match.Forfeit == 2) { var winner = list.Find(x => x.TeamNumber == match.Team2); winner.TotalScore += total / numMatches; } else if (match.Rink == -1) { var winner = list.Find(x => x.TeamNumber == match.Team1); winner.TotalScore += total / numMatches; } } } } } list.Sort((a, b) => (b.Wins * 1000 + b.TotalScore).CompareTo(a.Wins * 1000 + a.TotalScore)); int place = 1; foreach (var item in list) { ds.Standing.AddStandingRow(item.TeamNumber, item.Players, item.TotalScore, place++, item.Wins, item.Loses); } return(ds.Standing); }