public void Update(Employee emp)
{
// Check if employee exists in database
if (emp.Id > 0)
{
// Get employee by Id from database
var employee = _db.Employees.Where(e => e.Id == emp.Id).FirstOrDefault();
if (employee != null)
{
employee.Payroll_Number = emp.Payroll_Number;
employee.Forenames = emp.Forenames;
employee.Surname = emp.Surname;
employee.Date_of_Birth = emp.Date_of_Birth;
employee.Telephone = emp.Telephone;
employee.Mobile = emp.Mobile;
employee.Address = emp.Address;
employee.Address_2 = emp.Address_2;
employee.Postcode = emp.Postcode;
employee.EMail_Home = emp.EMail_Home;
employee.Start_Date = emp.Start_Date;
}
}
else
{
// Add to database if employee is new
_db.Employees.Add(emp);
}
_db.SaveChanges();
}
public void DeleteCardById(Guid Id)
{
var game = GetGameById(Id);
_sqlConnect.Database.ExecuteSqlCommand($"delete from Shots where game_Id = '{game.Id}' delete from Games where Id = '{game.Id}'");
_sqlConnect.SaveChanges();
}
public Avatar Create(Avatar avatar)
{
var cityEntry = _context.Add(avatar);
_context.SaveChanges();
return(cityEntry.Entity);
}
public void UpdateUserTest()
{
var builder = new DbContextOptionsBuilder <SQLDBContext>();
builder.UseInMemoryDatabase();
var options = builder.Options;
using (var context = new SQLDBContext(options))
{
var userManager = new TigerSpikeLandMarks.Managers.UserManager.UserManager(context, mockDataRepo.Object);;
var allUsers = userManager.Create(new User {
Id = 2, Username = "******", FirstName = "firstName2", LastName = "lastname2", PasswordHash = new byte[] { 0x20, 0x20, 0x20, 0x20, 0x20, 0x20, 0x20 }, PasswordSalt = new byte[] { 0x20, 0x20, 0x20, 0x20, 0x20, 0x20, 0x20 }
}, "password");
context.SaveChanges();
}
using (var context = new SQLDBContext(options))
{
var userManager = new TigerSpikeLandMarks.Managers.UserManager.UserManager(context, mockDataRepo.Object);;
var user = userManager.GetById(1);
user.FirstName = "updated";
context.SaveChanges();
}
using (var context = new SQLDBContext(options))
{
var userManager = new TigerSpikeLandMarks.Managers.UserManager.UserManager(context, mockDataRepo.Object);;
var user = userManager.GetById(1);
Assert.IsTrue("updated" == user.FirstName);
}
}
public AvatarType Create(AvatarType avatarType)
{
if (avatarType.AvatarTypeName != null)
{
_context.Attach(avatarType.AvatarTypeName).State = EntityState.Unchanged;
}
var avatarTypeEntry = _context.Add(avatarType);
_context.SaveChanges();
return(avatarTypeEntry.Entity);
}
public Owner Create(Owner owner)
{
if (owner.Address != null)
{
_context.Attach(owner.Address).State = EntityState.Unchanged;
}
var customerEntry = _context.Add(owner);
_context.SaveChanges();
return(customerEntry.Entity);
}
public User Create(User user, string password)
{
// validation
if (string.IsNullOrWhiteSpace(password))
{
throw new Exception("Password is required");
}
if (_context.Users.Any(x => x.Username == user.Username))
{
throw new Exception("Username '" + user.Username + "' is already taken");
}
byte[] passwordHash, passwordSalt;
CreatePasswordHash(password, out passwordHash, out passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
_context.Users.Add(user);
_context.SaveChanges();
return(user);
}
