ChatUser GetCurrentUserInstance(string login) { myChatDatabaseDataContext db = new myChatDatabaseDataContext(); var user = from User in db.Users where User.username == login && User.deleted == false select User; User currentUser = user.First <User>(); currentUser.userlastlogintime = DateTime.Now; db.SubmitChanges(); return(new ChatUser(currentUser.user_id, currentUser.username)); }
void CreateUser(string username, string password) { myChatDatabaseDataContext db = new myChatDatabaseDataContext(); User newUser = new Database.User(); newUser.username = username; newUser.password = password; newUser.usercreated = DateTime.Now; newUser.userlastlogintime = DateTime.Now; newUser.deleted = false; db.Users.InsertOnSubmit(newUser); db.SubmitChanges(); }
bool CheckUserLoginData(string username, string password) { myChatDatabaseDataContext db = new myChatDatabaseDataContext(); var user = from User in db.Users where User.username == username && User.password == password && User.deleted == false select User; if (user.Count() > 0) { return(true); } else { return(false); } }
//Auth bool IsUserExistInDatabase(string username) { myChatDatabaseDataContext db = new myChatDatabaseDataContext(); var user = from User in db.Users where User.username == username && User.deleted == false select User.username; if (user.Count() > 0) { return(true); } else { return(false); } }
bool UserDelete(bool userDataChecked, string username) { if (userDataChecked) { myChatDatabaseDataContext db = new myChatDatabaseDataContext(); var user = from User in db.Users where User.username == username && User.deleted == false select User; User currentUser = user.First <User>(); currentUser.deleted = true; db.SubmitChanges(); return(true); } else { return(false); } }
List <ChatMessage> GetNewMessages(ChatUser currentUser) { myChatDatabaseDataContext db = new myChatDatabaseDataContext(); List <ChatMessage> newMessages = new List <ChatMessage>(); var messages = from db_message in db.db_messages where db_message.date > currentUser.lastLogMsg && (db_message.receiver == currentUser.id || db_message.receiver == 0) select db_message; db_message[] tempArray = messages.ToArray <db_message>(); foreach (db_message message in tempArray) { newMessages.Add(new ChatMessage(message.sender, message.receiver, message.message)); } return(newMessages); }
//ChatMessages bool SendMessageToDatabase(string message, int source, int reciver) { try { myChatDatabaseDataContext db = new myChatDatabaseDataContext(); db_message currentMessage = new db_message(); currentMessage.message = message; currentMessage.sender = source; currentMessage.receiver = reciver; currentMessage.date = DateTime.Now; db.db_messages.InsertOnSubmit(currentMessage); db.SubmitChanges(); return(true); } catch { return(false); } }