public void ConvertToDomainTypeTest()
{
var databaseUser = new DbModels.User {
Id = Guid.NewGuid(),
FirstName = "test",
LastName = "test",
Country = "UK",
City = "London",
Street = "Baker street",
HouseNumber = "221B"
};
var mockContext = new Mock <IDataContext>();
var mapper = new UserDatabaseMapper();
var result = mapper.ConvertToDomainType(databaseUser, mockContext.Object);
Assert.AreEqual(databaseUser.Id, result.Id);
Assert.AreEqual(databaseUser.FirstName, result.FirstName);
Assert.AreEqual(databaseUser.LastName, result.LastName);
Assert.AreEqual(databaseUser.Country, result.Address.Country);
Assert.AreEqual(databaseUser.City, result.Address.City);
Assert.AreEqual(databaseUser.Street, result.Address.Street);
Assert.AreEqual(databaseUser.HouseNumber, result.Address.HouseNumber);
}
public IActionResult Add([FromBody] User user)
{
// convert the user status to DbModel user status
var dbUserStatus = helper.ConvertToDbModelUserStatus(user.UserStatus);
// convert the user type to DbModel user type
var dbUserType = helper.ConvertToDbModelUserType(user.UserType);
var dbModel = new DbModels.User();
dbModel.PayRollID = user.PayRollID;
dbModel.FirstName = user.FirstName;
dbModel.LastName = user.LastName;
dbModel.UserStatus = dbUserStatus;
dbModel.UserType = dbUserType;
dbModel.PIN = user.PIN;
dbModel.ModifyDate = user.ModifyDate;
var result = _repo.Add(dbModel);
if (result.Equals("-1"))
{
return(NotFound());
}
else
{
return(Ok(result));
}
}
public void ConvertToDomainTypeTest()
{
var databaseUser = new DbModels.User {
Id = Guid.NewGuid(),
FirstName = "test",
LastName = "test",
Country = "UK",
City = "London",
Street = "Baker street",
HouseNumber = "221B"
};
var databaseTask = new DbModels.Task {
Id = Guid.NewGuid(),
Name = "test",
Time = DateTime.Now,
User = databaseUser,
UserId = databaseUser.Id
};
var mockUserMapper = new Mock <IUserDatabaseMapper>();
var mockContext = new Mock <IDataContext>();
var mapper = new TaskDatabaseMapper(mockUserMapper.Object);
var result = mapper.ConvertToDomainType(databaseTask, mockContext.Object);
Assert.AreEqual(databaseTask.Id, result.Id);
Assert.AreEqual(databaseTask.Name, result.Name);
Assert.AreEqual(databaseTask.Time, result.Time);
Assert.AreEqual(databaseTask.User.Id, result.User.Id);
}
public void ConvertToDomainTypeWithLoadedUserTest()
{
var databaseUser = new DbModels.User {
Id = Guid.NewGuid(),
FirstName = "test",
LastName = "test",
Country = "UK",
City = "London",
Street = "Baker street",
HouseNumber = "221B"
};
var databaseTask = new DbModels.Task {
Id = Guid.NewGuid(),
Name = "test",
Time = DateTime.Now,
User = databaseUser,
UserId = databaseUser.Id
};
var mockContext = new Mock <IDataContext>();
mockContext.Setup(x => x.IsLoaded(databaseTask, y => y.User)).Returns(true);
var mockUserMapper = new Mock <IUserDatabaseMapper>();
mockUserMapper.Setup(x => x.ConvertToDomainType(databaseTask.User, mockContext.Object))
.Returns(new Domain.User.User {
Id = databaseTask.User.Id,
FirstName = databaseTask.User.FirstName,
LastName = databaseTask.User.LastName,
Address = new Address {
Country = databaseTask.User.Country,
City = databaseTask.User.City,
Street = databaseTask.User.Street,
HouseNumber = databaseTask.User.HouseNumber
}
});
var mapper = new TaskDatabaseMapper(mockUserMapper.Object);
var result = mapper.ConvertToDomainType(databaseTask, mockContext.Object);
Assert.AreEqual(databaseTask.Id, result.Id);
Assert.AreEqual(databaseTask.Name, result.Name);
Assert.AreEqual(databaseTask.Time, result.Time);
Assert.AreEqual(databaseTask.User.Id, result.User.Id);
Assert.AreEqual(databaseTask.User.FirstName, result.User.FirstName);
Assert.AreEqual(databaseTask.User.LastName, result.User.LastName);
Assert.AreEqual(databaseTask.User.Country, result.User.Address.Country);
Assert.AreEqual(databaseTask.User.City, result.User.Address.City);
Assert.AreEqual(databaseTask.User.Street, result.User.Address.Street);
Assert.AreEqual(databaseTask.User.HouseNumber, result.User.Address.HouseNumber);
}
public Domain.User.User ConvertToDomainType(DbModels.User databaseType, IDataContext context)
{
return(new Domain.User.User {
Id = databaseType.Id,
FirstName = databaseType.FirstName,
LastName = databaseType.LastName,
Address = new Address {
Country = databaseType.Country,
City = databaseType.City,
Street = databaseType.Street,
HouseNumber = databaseType.HouseNumber
}
});
}
public bool Vote(IEnumerable <Candidate> candidateList)
{
bool voted = false;
// Is user logged
if (_logged)
{
// using (var transaction = _context.Database.BeginTransaction())
// {
// Prepare user predicate function
bool UserPredicate(DbModels.User u) =>
u.FirstName.Equals(_loginCredentials.FirstName) &&
u.LastName.Equals(_loginCredentials.LastName) &&
u.Pesel.Equals(_loginCredentials.Pesel);
// Check for exists user
if (_context.Users.Any(UserPredicate))
{
// Find voted
DbModels.User user = _context.Users.Single(UserPredicate);
bool validateWarnings = _loginValidatorService.ValidateWarnings();
if (!user.Voted && !validateWarnings)
{
foreach (var candidate in candidateList)
{
_context.Votes.Add(new Vote()
{
User = user, Candidate = candidate
});
}
user.Voted = true;
_context.SaveChanges();
// _context.Database.CommitTransaction();
}
}
// }
}
return(voted);
}
public static void Add(ApiContext context)
{
var userOne = new DbModels.User
{
Id = Guid.NewGuid(),
FirstName = "Bill",
LastName = "Gates"
};
context.Users.Add(userOne);
var postOne = new DbModels.Post
{
Id = Guid.NewGuid(),
UserId = userOne.Id,
Content = "This is my first comment."
};
context.Posts.Add(postOne);
context.SaveChanges();
}
public IActionResult Update(string id, [FromBody] User user)
{
// getting Pay roll ID, User
var userByID = _repo.Get(id);
if (userByID == null)
{
return(NotFound());
}
else
{
// convert the user status to DbModel user status
var dbUserStatus = helper.ConvertToDbModelUserStatus(user.UserStatus);
// convert the user type to DbModel user type
var dbUserType = helper.ConvertToDbModelUserType(user.UserType);
var dbModel = new DbModels.User();
dbModel.FirstName = user.FirstName;
dbModel.LastName = user.LastName;
dbModel.UserStatus = dbUserStatus;
dbModel.UserType = dbUserType;
dbModel.PIN = user.PIN;
dbModel.ModifyDate = user.ModifyDate;
var result = _repo.Update(id, dbModel);
if (result.Equals("-1"))
{
return(NotFound());
}
else
{
return(Ok(result));
}
}
}
public static void DeleteStorage()
{
_CurrentUserInfo = null;
}
public static void SetStorage(DbModels.User authUser)
{
_CurrentUserInfo = new PizzaBox.Domain.Models.DbModels.User();
_CurrentUserInfo = authUser;
_CurrentUserInfo.Messages = new PizzaBox.Domain.Models.Messages();
}
