public void TestAddUpdateAndDeleteUser() { UniUser user = new UniUser(); user.FirstName = "Test1"; user.SurName = "Tester"; user.EmailAddress = "*****@*****.**"; user.PermissionLevelId = 1; user.IsActive = true; user.CreatedDate = DateTime.Now; user.EnrolementYear = new DateTime(2014, 01, 01); int userId = _repository.AddOrUpdate(user); Assert.AreNotEqual(0, userId); user = _repository.GetById(userId); UniUser newUser = new UniUser(); newUser.UserId = user.UserId; newUser.FirstName = "Test2"; newUser.SurName = "Tester"; newUser.EmailAddress = "*****@*****.**"; newUser.PermissionLevelId = 1; newUser.IsActive = true; newUser.CreatedDate = DateTime.Now; newUser.EnrolementYear = new DateTime(2014, 01, 01); int userId2 = _repository.AddOrUpdate(newUser); Assert.AreEqual(userId, userId2); user = _repository.GetById(userId); Assert.AreEqual("Test2", user.FirstName); bool userRemoved = _repository.Remove(user); Assert.IsTrue(userRemoved); }
public int AddOrUpdate(UniUser user) { try { using (UniUserDbContext db = new UniUserDbContext(ConnectionString)) { db.UniUsers.AddOrUpdate(user); db.SaveChanges(); return user.UserId; } } catch (Exception e) { if (user == null) { throw new Exception("Error Adding Updating User: User null", e); } throw new Exception( "Error Adding/Updating User: {Id:" + user.UserId + " Email:" + user.EmailAddress + "}", e); } }
public bool Remove(UniUser user) { try { using (UniUserDbContext db = new UniUserDbContext(ConnectionString)) { db.UniUsers.Attach(user); db.UniUsers.Remove(user); db.SaveChanges(); return true; } } catch (Exception e) { if (user == null) { throw new Exception("Error Removing User: User null", e); } throw new Exception("Error Removing User: {Id:" + user.UserId + " Email:" + user.EmailAddress + "}", e); } }