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); }