public Users GetUser(int id) { using (var context = new TranslatorHistoryDatabaseEntities()) { return context.Users.FirstOrDefault(user => user.Id == id); } }
public List<History> GetAllHistory(int userId) { using (var context = new TranslatorHistoryDatabaseEntities()) { return context.History.Where(c => c.UserId == userId).ToList(); } }
//private readonly string connectionString; //public SqlUserssRepositary(string connectionString) //{ // this.connectionString = connectionString; //} public List<Users> GetAllUsers() { using (var context = new TranslatorHistoryDatabaseEntities()) { return context.Users.ToList(); } }
public void DeleteUser(int userId) { using (var context = new TranslatorHistoryDatabaseEntities()) { context.Users.Remove(context.Users.FirstOrDefault(u => u.Id == userId)); context.SaveChanges(); } }
public int Add(History item) { using (var context = new TranslatorHistoryDatabaseEntities()) { context.History.Add(item); context.SaveChanges(); return item.Id; } }
public int AddUser(Users user) { using (var context = new TranslatorHistoryDatabaseEntities()) { context.Users.Add(user); context.SaveChanges(); return user.Id; } }
public List<History> GetLastHistoryEntries(int userId, int lastCount) { using (var context = new TranslatorHistoryDatabaseEntities()) { int count = context.History.Count(c => c.UserId == userId); var history = context.History.Where(c => c.UserId == userId); return count <= lastCount ? history.ToList() : history.OrderBy(c => c.Id).Skip(count - lastCount).ToList(); } }
public void BanUser(int userId) { using (var context = new TranslatorHistoryDatabaseEntities()) { var user = context.Users.FirstOrDefault(u => u.Id == userId); if (user == null) return; user.Disabled = !user.Disabled; context.SaveChanges(); } }
public void UpdateUser(Users obj) { using (var context = new TranslatorHistoryDatabaseEntities()) { var user = context.Users.First(u => u.Id == obj.Id); user.Email = obj.Email; user.Firstname = obj.Firstname; user.Lastname = obj.Lastname; context.SaveChanges(); } }
public List<History> GetHistory(int userId, int page, int itemsPerPage) { // TODO: реалізувати метод GetHistory, який приймає номер сторінки і к-сть записів на одну сторінку return GetAllHistory(userId); using (var context = new TranslatorHistoryDatabaseEntities()) { return context.History.Where(c => c.UserId == userId).ToList() //.OrderByDescending(c => c.Time) .Skip(Math.Max(0, context.History.Count() - page * itemsPerPage)) .Take(itemsPerPage) .ToList(); } }
public bool DoesUserExist(string login, string password) { using (var context = new TranslatorHistoryDatabaseEntities()) { return (context.Users.Any(u => u.Login == login && u.Password == password)); } }
public Users CheckUser(string login, string password) { using (var context = new TranslatorHistoryDatabaseEntities()) { return (context.Users.FirstOrDefault(u => u.Login == login && u.Password == password)); } }
public Users GetUserByLogin(string login) { using (var context = new TranslatorHistoryDatabaseEntities()) { return (context.Users.FirstOrDefault(u => u.Login == login)); } }