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