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) { // 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(); } }
public ActionResult Login(LogUserViewModel model, string returnUrl) { // Lets first check if the Model is valid or not if (ModelState.IsValid) { using (var entities = new LeaguesEntities()) { string username = model.Username; string password = model.Password; // Now if our password was enctypted or hashed we would have done the // same operation on the user entered password here, But for now // since the password is in plain text lets just authenticate directly var users = entities.Users.Where(x => x.username == model.Username); // User found in the database if (users != null && users.Count() == 1 && users.First().password == model.Password) { var user = users.First(); FormsAuthentication.SetAuthCookie(username, false); string roles = user.Roles; FormsAuthenticationTicket ticket = new FormsAuthenticationTicket( 1, // Ticket version user.username, // username to be used by ticket DateTime.Now, // ticket issue date-time DateTime.Now.AddMinutes(60), // Date and time the cookie will expire false, // persistent cookie? roles ?? "", // user data, role of the user FormsAuthentication.FormsCookiePath); string encryptCookie = FormsAuthentication.Encrypt(ticket); HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptCookie); HttpContext.Response.Cookies.Add(cookie); if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\")) { return(RedirectToAction("Index", "Home")); } else { return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("", "The user name or password provided is incorrect."); } } } // If we got this far, something failed, redisplay form return(View(model)); }
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(); } }
public static string Wednesday() { var topLine = new StringBuilder(); using (var db = new LeaguesEntities()) { var teams = db.WednesdayTeams.Count(); var rinks = teams / 2; var tline = new StringBuilder(); tline.Append("WK,Date,GRN,DIR,Bound,"); for (var rink = 0; rink < rinks; rink++) { tline.Append($"{rink},"); } var tline1 = tline.ToString(); topLine.Append(tline1.Substring(0, tline1.Length - 1) + "\n"); var weeks = db.WednesdaySchedules.SortBy("Id"); foreach (var week in weeks) { var matches = db.WednesdayMatches.Where(x => x.GameDate == week.id).OrderBy(x => x.Rink); var weekLine = new StringBuilder(); string grn = string.Empty; string dir = string.Empty; string bound = string.Empty; switch ((week.id - 1) % 9) { case 1: grn = "Luba"; dir = "N-S"; bound = "Red"; break; case 2: grn = "Phillips"; dir = "E-W"; bound = "White"; break; case 3: grn = "Luba"; dir = "E-W"; bound = "Yellow"; break; case 4: grn = "Phillips"; dir = "N-S"; bound = "Red"; break; case 5: grn = "Luba"; dir = "N-S"; bound = "White"; break; case 6: grn = "Phillips"; dir = "E-W"; bound = "Yellow"; break; case 7: grn = "Luba"; dir = "E-W"; bound = "Red"; break; case 8: grn = "Phillips"; dir = "N-S"; bound = "White"; break; case 0: grn = "Luba"; dir = "N-S"; bound = "Yellow"; break; } var date = $"{week.GameDate.Month}/{week.GameDate.Day}"; weekLine.Append($"{week.id},{date},{grn},{dir},{bound},"); foreach (var match in matches) { if (match.Rink != -1) { weekLine.Append($"{match.Team1}-{match.Team2},"); } } var wline = weekLine.ToString(); topLine.Append(wline.Substring(0, wline.Length - 1) + "\n"); } } return(topLine.ToString()); }
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); }