public static string GetSessionToken(string Email)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
Guid token = Guid.NewGuid();
List <UserSession> usList = (from t in dc.UserSessions
where t.UserID == GetUser(Email).UserID
select t).ToList <UserSession>();
dc.UserSessions.DeleteAllOnSubmit <UserSession>(usList);
UserSession us = new UserSession();
us.UserID = GetUser(Email).UserID;
us.ExpiresOn = DateTime.Now.AddHours(1);
us.SessionToken = token.ToString();
dc.UserSessions.InsertOnSubmit(us);
dc.SubmitChanges();
return(token.ToString());
}
catch
{
return(string.Empty);
}
}
public static bool InsertWord(string Word)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
LinqWord word = new LinqWord();
word.Word = Word;
word.IsRemoved = false;
dc.LinqWords.InsertOnSubmit(word);
dc.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public static bool CheckSessionToken(string token)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
UserSession us = (from t in dc.UserSessions
where t.SessionToken == token &&
t.ExpiresOn > DateTime.Now
select t).First <UserSession>();
us.ExpiresOn = DateTime.Now.AddHours(1);
dc.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public static bool CheckSessionToken(string token)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
UserSession us = (from t in dc.UserSessions
where t.SessionToken == token &&
t.ExpiresOn > DateTime.Now
select t).First<UserSession>();
us.ExpiresOn = DateTime.Now.AddHours(1);
dc.SubmitChanges();
return true;
}
catch
{
return false;
}
}
public static bool PostChat(string email, string message)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
LinqGameChat lgc = new LinqGameChat();
lgc.IsExCathedra = false;
lgc.PostedAt = DateTime.Now;
lgc.GameID = 1; // Lobby - for testing
lgc.UserID = GetUser(email).UserID;
lgc.ChatText = message;
dc.LinqGameChats.InsertOnSubmit(lgc);
dc.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public static bool CreateUser(string Email, string Nickname, string Password)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
User u = new User();
u.Email = Email;
u.Nickname = Nickname;
u.VerificationToken = GetVerificationHash(Email, Password);
u.IsAdmin = false;
u.JoinDate = DateTime.Now;
dc.Users.InsertOnSubmit(u);
dc.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public static bool CreateUser(string Email, string Nickname, string Password)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
User u = new User();
u.Email = Email;
u.Nickname = Nickname;
u.VerificationToken = GetVerificationHash(Email, Password);
u.IsAdmin = false;
u.JoinDate = DateTime.Now;
dc.Users.InsertOnSubmit(u);
dc.SubmitChanges();
return true;
}
catch
{
return false;
}
}
public static bool PostChat(string email, string message)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
LinqGameChat lgc = new LinqGameChat();
lgc.IsExCathedra = false;
lgc.PostedAt = DateTime.Now;
lgc.GameID = 1; // Lobby - for testing
lgc.UserID = GetUser(email).UserID;
lgc.ChatText = message;
dc.LinqGameChats.InsertOnSubmit(lgc);
dc.SubmitChanges();
return true;
}
catch
{
return false;
}
}
public static bool InsertWord(string Word)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
LinqWord word = new LinqWord();
word.Word = Word;
word.IsRemoved = false;
dc.LinqWords.InsertOnSubmit(word);
dc.SubmitChanges();
return true;
}
catch
{
return false;
}
}
public static string GetSessionToken(string Email)
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
Guid token = Guid.NewGuid();
List<UserSession> usList = (from t in dc.UserSessions
where t.UserID == GetUser(Email).UserID
select t).ToList<UserSession>();
dc.UserSessions.DeleteAllOnSubmit<UserSession>(usList);
UserSession us = new UserSession();
us.UserID = GetUser(Email).UserID;
us.ExpiresOn = DateTime.Now.AddHours(1);
us.SessionToken = token.ToString();
dc.UserSessions.InsertOnSubmit(us);
dc.SubmitChanges();
return token.ToString();
}
catch
{
return string.Empty;
}
}
