public static IEnumerable <Request> GetRequests(Guid id)
{
using (var context = new WordsCountDBContext())
{
return(context.Requests.Where(r => r.OwnerGuid == id).ToList());
}
}
public static User GetUser(String login)
{
using (var context = new WordsCountDBContext())
{
IEnumerable <User> us = context.Users.Where(user => user.Login == login);
if (us.Count() > 0)
{
return(us.First());
}
else
{
return(null);
}
}
}
public static bool AddUser(User user)
{
using (var context = new WordsCountDBContext())
{
context.Users.Add(user);
try
{
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public static bool AddRequest(Request request)
{
using (var context = new WordsCountDBContext())
{
context.Requests.Add(request);
try
{
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public static User UpdateUserDate(Guid userGuid)
{
using (var context = new WordsCountDBContext())
{
IEnumerable <User> us = context.Users.Where(user => user.Guid == userGuid);
if (us.Count() > 0)
{
User up = us.First();
up.DateOfEnter = DateTime.Now.ToLocalTime();
context.SaveChanges();
return(up);
}
else
{
return(null);
}
}
}