public bool TryLoginAttempt(User t)
{
try
{
if (t.Name.Length > 20 || t.Password.Length > 20)
{
return(false);
}
}
catch
{
return(false);
}
database1Context db = new database1Context();
IQueryable <string> q = from u in db.User where u.Name == t.Name select u.Password;
string salt = "WHAT IS THE NAME OF THE ";
string encodedPassword = GetEncodedHash(t.Password, salt);
if (q.Count() > 0)
{
return(q.Single() == encodedPassword);
}
else
{
t.Password = encodedPassword;
db.User.Add(t);
// Console.WriteLine("Sending to DB: {0}", t.ToString());
db.SaveChanges();
return(true);
}
}
public bool AddMessage(ChatMessage msg)
{
if (msg.Body.Length > 200)
{
return(false);
}
database1Context db = new database1Context();
IQueryable <int> q = from r in db.User where r.Name == msg.Username select r.Id;
if (q.Count() < 1)
{
return(false);
}
int userID = q.FirstOrDefault();
Message t = new Message()
{
UserId = userID, Text = msg.Body
};
db.Message.Add(t);
//Console.WriteLine("Sending to DB: {0}", t.ToString());
db.SaveChanges();
return(true);
}
public bool AddNewItem(ItemDetails item)
{
database1Context db = new database1Context();
IQueryable <int> q = from r in db.Item where r.Name == item.description select r.Id;
if (q.Count() > 0)
{
return(false);
}
Item i = new Item()
{
Name = item.description
};
db.Item.Add(i);
db.SaveChanges();
return(true);
}