public string Gametest(string qtestuser) { string message = ""; try { //取得目前已存在的user資料 var userinfo = (from wedding in userdb.Wedding_UserAns where wedding.weddingname == User.Identity.Name select wedding).ToList(); //獲取問題 var question = (from wedding in userdb.Wedding_Question where wedding.name == User.Identity.Name select wedding).OrderBy(r => r.num).ToList(); List <Wedding_UserAns> ans = new List <Wedding_UserAns>(); // 答案取亂數 string[] TestAns = { "1", "2", "3", "4" }; Random Ran1 = new Random(); foreach (var item in question) { for (int i = 1; i <= int.Parse(qtestuser); i++) { string name = "樹林基哥A" + i; if (userinfo.Where(r => r.name == name && r.uid == item.uid).Count() == 0)//避免資料重覆 { Wedding_UserAns user = new Wedding_UserAns() { weddingname = User.Identity.Name, uid = item.uid, name = name, ans = int.Parse(TestAns[Ran1.Next(0, 4)]), XorV = "X", anstime = dt.AddSeconds(i), }; ans.Add(user); } } } userdb.Wedding_UserAns.AddRange(ans); userdb.SaveChanges(); message = "完成"; } catch (Exception ex) { message = ex.Message; } return(message); }
public string SubAns(string ans, string question) { string message = ""; try { FormsIdentity id = (FormsIdentity)User.Identity; FormsAuthenticationTicket ticket = id.Ticket; //確認是否已答題 var UserAns = (from uans in userdb.Wedding_UserAns where uans.uid == question && uans.name == User.Identity.Name select uans).FirstOrDefault(); if (UserAns != null) { return(message = "你回答過囉!!"); } //確認題目是否關閉 var questionstate = from wedding in userdb.Wedding_Question where wedding.uid == question && wedding.name == ticket.UserData && wedding.state == "V" select wedding; if (questionstate.Count() == 0) { return(message = "此題目已關閉囉!!"); } Wedding_UserAns user = new Wedding_UserAns() { name = User.Identity.Name, ans = int.Parse(ans), anstime = dt, weddingname = ticket.UserData, uid = question, XorV = "X", }; userdb.Wedding_UserAns.Add(user); userdb.SaveChanges(); message = "完成"; } catch (Exception ex) { message = ex.Message; } return(message); }