public static List <ChatMessage> ChatInit()
{
try
{
LinqGameDataContext dc = new LinqGameDataContext();
List <LinqGameChat> lList = (from c in dc.LinqGameChats
where c.PostedAt > DateTime.Now.Subtract(new TimeSpan(0, 5, 0))
select c).ToList <LinqGameChat>();
List <ChatMessage> cmList = new List <ChatMessage>();
if (lList.Count > 0)
{
foreach (LinqGameChat lgc in lList)
{
cmList.Add(new ChatMessage(lgc));
}
}
else
{
LinqGameChat lgc = (from c in dc.LinqGameChats
orderby c.ChatLineID descending
select c).First <LinqGameChat>();
cmList.Add(new ChatMessage(lgc));
}
return(cmList);
}
catch
{
return(new List <ChatMessage>());
}
}
public ChatMessage(LinqGameChat gc)
{
lineId = gc.ChatLineID;
dt = gc.PostedAt;
voice = gc.User.Nickname;
isExCathedra = gc.IsExCathedra.GetValueOrDefault(false);
message = gc.ChatText;
}
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);
}
}
private void detach_LinqGameChats(LinqGameChat entity)
{
this.SendPropertyChanging();
entity.User = null;
}
private void attach_LinqGameChats(LinqGameChat entity)
{
this.SendPropertyChanging();
entity.User = this;
}
partial void DeleteLinqGameChat(LinqGameChat instance);
partial void UpdateLinqGameChat(LinqGameChat instance);
partial void InsertLinqGameChat(LinqGameChat instance);
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;
}
}