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