public FileResult Download(string username) { List <Game> games = db.Games.Where(x => x.Player1 == username || x.Player2 == username).ToList(); Game game = games.OrderBy(x => x.Id).Last(); List <FifthGame> fifthGames = db.FifthGames.Where(x => x.Player1 == username || x.Player2 == username).ToList(); FifthGame fifthGame = fifthGames.OrderBy(x => x.Id).Last(); GamingUser user = db.Users.First(x => x.Username == username); GamingUser firstPlayer = db.Users.First(x => x.Username == game.Player1); GamingUser secondPlayer = db.Users.First(x => x.Username == game.Player2); using (MemoryStream ms = new MemoryStream()) { string pathFile = HttpContext.Server.MapPath(@"~/Content/ExcelTemplate.xlsx"); Workbook workbook = new Workbook(pathFile); Worksheet worksheet = workbook.Worksheets[0]; worksheet.AutoFitColumns(); worksheet.Name = "Statistika"; FillTableForGame(game, firstPlayer, secondPlayer, worksheet); FillTableForFifthGame(fifthGame, user, worksheet); FillSurvey(user, worksheet); FillTasks(user, worksheet); RemoveSuperfluousErrorWarnings(worksheet); string dateTime = "" + DateTime.Now.Hour + ":" + DateTime.Now.Minute + "_" + DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year; string fileName = "Statistika_" + dateTime + ".xlsx"; workbook.Save(ms, SaveFormat.Xlsx); ms.Seek(0, SeekOrigin.Begin); return(File(ms.ToArray(), System.Net.Mime.MediaTypeNames.Application.Octet, fileName)); } }
private void FillTasks(GamingUser user, Worksheet worksheet) { MarkAnswersFromTasks(user.Question11, "22", worksheet); MarkAnswersFromTasks(user.Question12, "24", worksheet); MarkAnswersFromTasks(user.Question13, "26", worksheet); MarkAnswersFromTasks(user.Question14, "28", worksheet); MarkAnswersFromTasks(user.Question15, "30", worksheet); MarkAnswersFromTasks(user.Question16, "32", worksheet); MarkAnswersFromTasks(user.Question17, "34", worksheet); MarkAnswersFromTasks(user.Question18, "36", worksheet); MarkAnswersFromTasks(user.Question19, "38", worksheet); }
private static void FillSurvey(GamingUser user, Worksheet worksheet) { worksheet.Cells["F10"].Value = user.Question1; worksheet.Cells["F11"].Value = user.Question2; worksheet.Cells["F12"].Value = user.Question3; worksheet.Cells["F13"].Value = user.Question4; worksheet.Cells["F14"].Value = user.Question5; worksheet.Cells["F15"].Value = user.Question6; worksheet.Cells["F16"].Value = user.Question7; worksheet.Cells["F17"].Value = user.Question8; worksheet.Cells["F18"].Value = user.Question9; worksheet.Cells["F19"].Value = user.Question10; }
private static void FillTableForGame(Game game, GamingUser firstPlayer, GamingUser secondPlayer, Worksheet worksheet) { worksheet.Cells["A2"].Value = firstPlayer.FirstName + " " + firstPlayer.LastName; worksheet.Cells["A3"].Value = secondPlayer.FirstName + " " + secondPlayer.LastName; worksheet.Cells["B2"].Value = game.Player1Game1Points; worksheet.Cells["B3"].Value = game.Player2Game1Points; worksheet.Cells["C2"].Value = game.Player1Game2Points; worksheet.Cells["C3"].Value = game.Player2Game2Points; worksheet.Cells["D2"].Value = game.Player1Game3Points; worksheet.Cells["D3"].Value = game.Player2Game3Points; worksheet.Cells["E2"].Value = game.Player1Game4Points; worksheet.Cells["E3"].Value = game.Player2Game4Points; worksheet.Cells["F2"].Value = game.Player1Game1Points + game.Player1Game2Points + game.Player1Game3Points + game.Player1Game4Points; worksheet.Cells["F3"].Value = game.Player2Game1Points + game.Player2Game2Points + game.Player2Game3Points + game.Player2Game4Points; }
private static void FillTableForFifthGame(FifthGame fifthGame, GamingUser user, Worksheet worksheet) { worksheet.Cells["A6"].Value = user.FirstName + " " + user.LastName; int gameFivePlayer11Points = (int)fifthGame.Player1Game1Points; int gameFivePlayer12Points = (int)fifthGame.Player1Game2Points; int gameFivePlayer13Points = (int)fifthGame.Player1Game3Points; int gameFivePlayer14Points = (int)fifthGame.Player1Game4Points; int gameFivePlayer15Points = (int)fifthGame.Player1Game5Points; int gameFivePlayer21Points = (int)fifthGame.Player2Game1Points; int gameFivePlayer22Points = (int)fifthGame.Player2Game2Points; int gameFivePlayer23Points = (int)fifthGame.Player2Game3Points; int gameFivePlayer24Points = (int)fifthGame.Player2Game4Points; int gameFivePlayer25Points = (int)fifthGame.Player2Game5Points; if (fifthGame.Player2 == user.Username) { gameFivePlayer11Points = (int)fifthGame.Player2Game1Points; gameFivePlayer12Points = (int)fifthGame.Player2Game2Points; gameFivePlayer13Points = (int)fifthGame.Player2Game3Points; gameFivePlayer14Points = (int)fifthGame.Player2Game4Points; gameFivePlayer15Points = (int)fifthGame.Player2Game5Points; gameFivePlayer21Points = (int)fifthGame.Player1Game1Points; gameFivePlayer22Points = (int)fifthGame.Player1Game2Points; gameFivePlayer23Points = (int)fifthGame.Player1Game3Points; gameFivePlayer24Points = (int)fifthGame.Player1Game4Points; gameFivePlayer25Points = (int)fifthGame.Player1Game5Points; } worksheet.Cells["B6"].Value = gameFivePlayer11Points; worksheet.Cells["C6"].Value = gameFivePlayer12Points; worksheet.Cells["D6"].Value = gameFivePlayer13Points; worksheet.Cells["E6"].Value = gameFivePlayer14Points; worksheet.Cells["F6"].Value = gameFivePlayer15Points; worksheet.Cells["B7"].Value = gameFivePlayer21Points; worksheet.Cells["C7"].Value = gameFivePlayer22Points; worksheet.Cells["D7"].Value = gameFivePlayer23Points; worksheet.Cells["E7"].Value = gameFivePlayer24Points; worksheet.Cells["F7"].Value = gameFivePlayer25Points; worksheet.Cells["G6"].Value = gameFivePlayer11Points + gameFivePlayer12Points + gameFivePlayer13Points + gameFivePlayer14Points + gameFivePlayer15Points; worksheet.Cells["G7"].Value = gameFivePlayer21Points + gameFivePlayer22Points + gameFivePlayer23Points + gameFivePlayer24Points + gameFivePlayer25Points; }
public IHttpActionResult Register([FromBody] RegisterRequest registerRequest) { try { GamingUser user = new GamingUser { FirstName = registerRequest.FirstName, LastName = registerRequest.LastName, Password = registerRequest.Password, Username = registerRequest.Username, IsFemale = registerRequest.IsFemale, Question1 = registerRequest.Question1, Question2 = registerRequest.Question2, Question3 = registerRequest.Question3, Question4 = registerRequest.Question4, Question5 = registerRequest.Question5, Question6 = registerRequest.Question6, Question7 = registerRequest.Question7, Question8 = registerRequest.Question8, Question9 = registerRequest.Question9, Question10 = registerRequest.Question10, Question11 = registerRequest.Question11, Question12 = registerRequest.Question12, Question13 = registerRequest.Question13, Question14 = registerRequest.Question14, Question15 = registerRequest.Question15, Question16 = registerRequest.Question16, Question17 = registerRequest.Question17, Question18 = registerRequest.Question18, Question19 = registerRequest.Question19, }; db.Users.Add(user); db.SaveChanges(); HttpContext.Current.Session["username"] = user.Username; return(Ok(true)); } catch (Exception e) { return(Content(HttpStatusCode.BadRequest, "Neuspešna registracija.")); } }
public ActionResult Binding() { string s_success = JsonConvert.SerializeObject(new { success = true, message = "成功" }); string str = base.Request.Params["UserName"]; if (!string.IsNullOrEmpty(str) && (!string.IsNullOrEmpty(Session_FLDID))) { try { var xwwl_char = gamecontext.TBL_XWWL_Char.Where(a => a.FLD_ID == Session_FLDID && a.FLD_NAME == str).SingleOrDefault(); if (xwwl_char == null) { s_success = JsonConvert.SerializeObject(new { success = false, message = "数据异常" }); return(Content(s_success, MIME_JSON)); } var gameUser = cjcontext.GamingUser.Where(a => a.UserId == Session_FLDID).SingleOrDefault(); if (gameUser != null) { gameUser.UserName = str; cjcontext.Entry(gameUser).State = System.Data.EntityState.Modified; } else { gameUser = new GamingUser { UserId = Session_FLDID, UserName = str, Count = AppConfig.CJ_CS }; cjcontext.Entry(gameUser).State = System.Data.EntityState.Added; } cjcontext.SaveChanges(); return(Content(s_success, MIME_JSON)); } catch (Exception) { s_success = JsonConvert.SerializeObject(new { success = false, message = "数据异常" }); return(Content(s_success, MIME_JSON)); } } else { s_success = JsonConvert.SerializeObject(new { success = false, message = "数据异常" }); return(Content(s_success, MIME_JSON)); } }
public ActionResult Login() { string s_success = JsonConvert.SerializeObject(new { success = true, message = "登录成功" }); string s_user = Request.Params["UserName"]; string s_pwd = Request.Params["PassWord"]; if (string.IsNullOrEmpty(s_user)) { s_success = JsonConvert.SerializeObject(new { success = false, message = "请输入用户名" }); return(Content(s_success, MIME_JSON)); } if (string.IsNullOrEmpty(s_pwd)) { s_success = JsonConvert.SerializeObject(new { success = false, message = "请输入密码" }); return(Content(s_success, MIME_JSON)); } var account = accountcontext.TBL_ACCOUNT.Where(a => a.FLD_ID == s_user && a.FLD_PASSWORD == s_pwd).SingleOrDefault(); if (account == null) { s_success = JsonConvert.SerializeObject(new { success = false, message = "用户名密码有误" }); return(Content(s_success, MIME_JSON)); } var gameuser = cjcontext.GamingUser.Where(a => a.UserId == account.FLD_ID).FirstOrDefault(); if (gameuser == null) { GamingUser user = new GamingUser { UserId = account.FLD_ID, UserName = account.FLD_NAME, Count = AppConfig.CJ_CS }; cjcontext.Entry(user).State = System.Data.EntityState.Added; cjcontext.SaveChanges(); } Session["FLD_ID"] = account.FLD_ID; return(Content(s_success, MIME_JSON)); }