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