public IEnumerable <User> GetRegisteredUsers()
{
database1Context db = new database1Context();
IOrderedQueryable <User> q = from r in db.User orderby r.Name ascending select r;
return(q.ToList <User>());
}
public List <Mod.commen.TblDepartment> GetDepartment()
{
List <Mod.commen.TblDepartment> departments = new List <Mod.commen.TblDepartment>();
try
{
using (var dBContext = new database1Context())
{
Mod.commen.TblDepartment department1;
foreach (var dept in dBContext.TblDepartment)
{
department1 = new Mod.commen.TblDepartment();
department1.DepartmentId = dept.DepartmentId;
department1.DepartmentName = dept.DepartmentName;
departments.Add(department1);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//throw;
}
return(departments);
}
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 IEnumerable <ChatMessage> GetMessages()
{
database1Context db = new database1Context();
IQueryable <ChatMessage> q = from r in db.Message
join u in db.User on r.UserId equals u.Id
orderby r.Timestamp ascending
select new ChatMessage {
Username = u.Name, Body = r.Text, DateAndTime = r.Timestamp
};
return(q.ToList <ChatMessage>());
}
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);
}
public bool GetAvailableItems(List <ItemDetails> items)
{
database1Context db = new database1Context();
IQueryable <string> q = from r in db.Item select r.Name;
if (q.Count() == 0)
{
return(false);
}
items.Clear();
foreach (var i in q)
{
items.Add(new ItemDetails {
description = i
});
}
//Item i = new Item() { Name = item.description };
//db.Item.Add(i);
//db.SaveChanges();
return(true);
}
