public bool SaveUserImage(int userId, string imagePath, int imageSize, string extension) { using (var db = new MeetUpDbContext()) { var user = db.Users .Where(u => u.Id == userId) .FirstOrDefault(); if (user == null) { return(false); } var image = new Image { Path = imagePath, UserId = userId, Size = imageSize, Extension = extension }; user.Images.Add(image); db.SaveChanges(); return(true); } }
public IEnumerable <UserListingModel> All(int page = 1, int pageSize = 10, int?withoutUserId = 0) { using (var db = new MeetUpDbContext()) { return(db .Users .Where(u => (u.Id != withoutUserId && u.Deleted == 0)) .OrderByDescending(u => u.Id) .Skip((page - 1) * pageSize) .Take(pageSize) .Select(u => new UserListingModel { Id = u.Id, Name = u.FullName, Description = u.Description, Banned = u.Banned, Sex = u.Sex, Role = u.Role, Active = u.Active, Images = u.Images.Select(i => new UserImageModel { Id = i.Id, Path = i.Path, Size = i.Size, Extension = i.Extension }) }) .ToList()); } }
public bool Create(string email, string password, string fullname, string description, DateTime?birthday = null, UserRole role = UserRole.User, UserSex sex = UserSex.Other) { using (var db = new MeetUpDbContext()) { var mailExists = db.Users.Any(u => u.Email == email); if (mailExists) { return(false); } var salt = HelperFunctions.Get_SALT(); var hashedPass = HelperFunctions.Get_HASH_SHA512(password, email, salt); var user = new User { Email = email, Password = hashedPass, Salt = salt, FullName = fullname, Description = description, Birthday = birthday, Sex = sex, Role = role, CreateTime = DateTime.Today, LastOnline = DateTime.Today }; db.Users.Add(user); db.SaveChanges(); return(true); } }
public UserViewModel GetUserById(int id) { using (var db = new MeetUpDbContext()) { return(db.Users .Where(u => u.Id == id) .Select(u => new UserViewModel { Id = u.Id, FullName = u.FullName, Email = u.Email, City = u.City.Name, Birthday = u.Birthday, Description = u.Description, Sex = u.Sex, Role = u.Role, Active = u.Active, Banned = u.Banned, Images = u.Images.Select(i => new UserImageModel { Id = i.Id, Path = i.Path, Size = i.Size, Extension = i.Extension }) }) .FirstOrDefault()); } }
public bool Login(string email, string password) { string realHashedPassword = string.Empty; byte[] salt = new byte[HelperFunctions.saltLengthLimit]; using (var db = new MeetUpDbContext()) { var user = db.Users .Where(u => u.Email == email && u.Deleted == 0 && u.Banned == 0 && u.Role == UserRole.Admin) .FirstOrDefault(); if (user == null) { return(false); } realHashedPassword = user.Password; salt = user.Salt; bool isLogin = HelperFunctions.CompareHashValue(password, email, realHashedPassword, salt); if (isLogin) { return(true); } return(false); } }
public int Count() { using (var db = new MeetUpDbContext()) { return(db.Users.Count()); } }
public IEnumerable <Image> getAllPhotos(int userId) { using (var db = new MeetUpDbContext()) { return((from image in db.Images where image.UserId == userId && image.Deleted == false select image).ToList()); } }
public void DeleteImage(int id) { using (var db = new MeetUpDbContext()) { var image = db.Images .Where(u => u.Id == id) .FirstOrDefault(); image.Deleted = true; db.SaveChanges(); } }
public CityViewModel GetCityById(int id) { using (var db = new MeetUpDbContext()) { return(db.Cities .Where(u => u.Id == id) .Select(u => new CityViewModel { Id = u.Id, Name = u.Name, }) .FirstOrDefault()); } }
public UserServiceModel GetUserByEmail(string email) { using (var db = new MeetUpDbContext()) { return(db.Users .Where(u => u.Email == email) .Select(u => new UserServiceModel { Id = u.Id, Email = u.Email, FullName = u.FullName }) .FirstOrDefault()); } }
public void UpdateCity(int id, string name = null, int?deleted = null) { using (var db = new MeetUpDbContext()) { var dbCity = db.Cities .Where(u => u.Id == id) .FirstOrDefault(); dbCity.Name = name ?? dbCity.Name; dbCity.Deleted = deleted ?? dbCity.Deleted; db.SaveChanges(); } }
public void Populate() { using (var db = new MeetUpDbContext()) { if (!db.Cities.Any()) { var city = new City { Name = "Sofia" }; db.Cities.Add(city); db.SaveChanges(); } } }
private static void CreateSystemUser(MeetUpDbContext context, Guid serviceId, string serviceName) { context.AspNetUsers.AddOrUpdate( m => m.Id, new AspNetUser { Id = serviceId, FirstName = serviceName, LastName = nameof(SystemUsers), Email = $"{serviceName.ToLower()}@sysusers.internal", // must be unique, and better conform to email format InternalEmail = $"#ERR_{serviceName}#", // not possible to email sys-users, yet must be unique, conform or not? IsSystemUser = true, LanguageCode = LanguageCode.English, Tracking = EntityTracker.StartTracking(SystemUsers.Migrator) }); }
public IEnumerable <CityListingModel> All(int page = 1, int pageSize = 10) { using (var db = new MeetUpDbContext()) { return(db .Cities .OrderByDescending(u => u.Id) .Skip((page - 1) * pageSize) .Take(pageSize) .Where(u => u.Deleted == 0) .Select(u => new CityListingModel { Id = u.Id, Name = u.Name, }) .ToList()); } }
public bool Create(string name) { using (var db = new MeetUpDbContext()) { var cityExists = db.Cities.Any(u => u.Name == name); if (cityExists) { return(false); } var city = new City { Name = name, }; db.Cities.Add(city); db.SaveChanges(); return(true); } }
public void UpdateUser(int id, string fullname = null, string description = null, int?cityId = null, DateTime?birthday = null, string password = null, int?active = null, int?deleted = null, int?banned = null, UserRole?role = null, UserSex?sex = null) { using (var db = new MeetUpDbContext()) { var dbUser = db.Users .Where(u => u.Id == id) .FirstOrDefault(); if (password != null) { var salt = dbUser.Salt; var hashedPass = HelperFunctions.Get_HASH_SHA512(password, dbUser.Email, salt); dbUser.Password = hashedPass; } dbUser.FullName = fullname ?? dbUser.FullName; dbUser.Description = description ?? dbUser.Description; dbUser.CityId = cityId ?? dbUser.CityId; dbUser.Birthday = birthday ?? dbUser.Birthday; dbUser.Active = active ?? dbUser.Active; dbUser.Deleted = deleted ?? dbUser.Deleted; dbUser.Banned = banned ?? dbUser.Banned; dbUser.Sex = sex ?? dbUser.Sex; dbUser.Role = role ?? dbUser.Role; db.SaveChanges(); } }
public UnitOfWorkWithPermissions(MeetUpDbContext context, Guid userId) : base(new PermissionsWrapper(context, userId)) { _userId = userId; }
public UnitOfWorkWithPermissions(MeetUpDbContext context) : base(context) { }
public PermissionsWrapper(MeetUpDbContext context, Guid userId) { _context = context; _userId = userId; }
public UserService(MeetUpDbContext db) { this.db = db; }
public DailySuggestionService(MeetUpDbContext db) { this.db = db; }
/// <summary> /// Injection .ctor /// </summary> /// <remarks>This is slightly better, to be used with factory, but this has to be controlled by consumer code</remarks> protected BaseRepository(MeetUpDbContext context) { _context = new Lazy <MeetUpDbContext>(() => context); }