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 int SaveChanges()
{
// There is another location where we could create / modify Tracking records instead of in UnitOfWork object
// Then we could not expose ChangeTracker in IFullDataContext... tempting...
// TODO: left as an exercise ;-)
return(_context.SaveChanges());
}
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 void SaveDailySuggestionLog(int userId)
{
var d = new DailySuggestionLogs
{
Date = DateTime.Now,
UserId = userId
};
this.db.DailySuggestionLogs.Add(d);
db.SaveChanges();
}
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 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();
}
}
}
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 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);
}
}