/// <summary>
/// Checks whether user with specified nickname or email exists in database
/// </summary>
/// <remarks>using Entity Framework</remarks>
/// <param name="loginOrEmail">Nickame or email of the user</param>
/// <returns><c>true</c> if user with specified nickname or email exists, otherwise <c>false</c></returns>
public bool UserExists(string loginOrEmail)
{
using (var context = new TextEditorDbContext())
{
return(context.Users.Any(u => u.Login == loginOrEmail || u.Email == loginOrEmail));
}
}
/// <summary>
/// Gets user by their nickname or email from database
/// </summary>
/// <remarks>using Entity Framework</remarks>
/// <param name="loginOrEmail">Nickame or email of the user</param>
/// <returns> Information about retrived user</returns>
public User GetUserByLoginOrEmail(string loginOrEmail)
{
using (var context = new TextEditorDbContext())
{
return(context.Users.FirstOrDefault(u => u.Login == loginOrEmail || u.Email == loginOrEmail));
}
}
/// <summary>
/// Gets user by id from database
/// </summary>
/// <remarks>using Entity Framework</remarks>
/// <param name="guid">Id of the user</param>
/// <returns>Information about the retrived user</returns>
public User GetUserByGuid(Guid guid)
{
using (TextEditorDbContext context = new TextEditorDbContext())
{
return(context.Users.FirstOrDefault(u => u.Guid == guid));
}
}
/// <summary>
/// Gets list of all users from database
/// </summary>
/// <remarks>using Entity Framework</remarks>
/// <returns>List of all users</returns>
public IEnumerable <User> GetAllUsers()
{
using (var context = new TextEditorDbContext())
{
return(context.Users.ToList());
}
}
/// <summary>
/// Gets all request about changes in files from database for certain user
/// </summary>
/// <remarks>using Entity Framework</remarks>
/// <param name="userGuid">Id of the user to retrieve requests</param>
/// <returns>List of user requests</returns>
public IEnumerable <UserRequest> GetUserRequests(Guid userGuid)
{
using (TextEditorDbContext context = new TextEditorDbContext())
{
return(context.Users.Include(u => u.Requests).Single(x => x.Guid == userGuid).Requests.OrderByDescending(r => r.ChangedAt).ToList());
}
}
/// <summary>
/// Saves new user in database
/// </summary>
/// <remarks>using Entity Framework</remarks>
/// <param name="user">Information about new user to save</param>
public void AddUser(User user)
{
using (TextEditorDbContext context = new TextEditorDbContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
/// <summary>
/// Saves new user request about changing file in the database
/// </summary>
/// <remarks>using Entity Framework</remarks>
/// <param name="userGuid">Id of the user who created request</param>
/// <param name="request">New user request to save</param>
public void AddUserRequest(Guid userGuid, UserRequest request)
{
using (TextEditorDbContext context = new TextEditorDbContext())
{
context.Users.Single(x => x.Guid == userGuid).Requests.Add(request);
context.SaveChanges();
}
}
public List <EditingInfo> GetEditingInfoes(string filePath)
{
List <EditingInfo> result = null;
using (TextEditorDbContext db = new TextEditorDbContext())
{
result = db.EditingInfos.Include(e => e.User).Where(i => i.FilePath == filePath).ToList();
}
return(result);
}
public EditingInfo CreateEditingInfo(User user, string filePath, bool isFileChanged, DateTime editingDate)
{
EditingInfo info = null;
using (TextEditorDbContext db = new TextEditorDbContext())
{
User dbUser = db.Users.FirstOrDefault(u => u.Id == user.Id);
info = new EditingInfo(filePath, isFileChanged, editingDate);
if (dbUser.EditingInfos == null)
{
dbUser.EditingInfos = new List <EditingInfo>();
}
dbUser.EditingInfos.Add(info);
info.User = dbUser;
db.EditingInfos.Add(info);
db.SaveChanges();
}
return(info);
}
