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);
}
