private void Initialize()
{
using (var db = new HelloWorldContext())
{
var _modelRepository = new ModelDbRepository(db);
var userTypes = (from ut in _modelRepository.Fetch <UserType>()
select ut).ToList();
if (!userTypes.Any(u => u.UserTypeId == 1))
{
Trace.TraceInformation("Inserting UserType");
var userTypeSystem = new UserType {
UserTypeId = 1, UserTypeDescription = "System", CreatedOn = DateTime.Now, CreatedByUserName = "******"
};
_modelRepository.Add(userTypeSystem);
}
if (!userTypes.Any(u => u.UserTypeId == 2))
{
Trace.TraceInformation("Inserting UserType");
var userTypeBusiness = new UserType {
UserTypeId = 2, UserTypeDescription = "Business", CreatedOn = DateTime.Now, CreatedByUserName = "******"
};
_modelRepository.Add(userTypeBusiness);
}
_modelRepository.SaveChanges();
userTypes = (from ut in _modelRepository.Fetch <UserType>()
select ut).ToList();
var users = (from u in _modelRepository.Fetch <User>()
select u).ToList();
if (!users.Any(u => u.UserId == 1))
{
Trace.TraceInformation("Inserting UserType");
var userJohn = new User {
UserId = 1, FirstName = "John", LastName = "Doe", CreatedByUserName = "******", CreatedOn = DateTime.Now, UserTypeId = userTypes.FirstOrDefault().UserTypeId
};
_modelRepository.Add(userJohn);
}
if (!users.Any(u => u.UserId == 2))
{
Trace.TraceInformation("Inserting UserType");
var userJane = new User {
UserId = 2, FirstName = "Jane", LastName = "Doe", CreatedByUserName = "******", CreatedOn = DateTime.Now, UserTypeId = userTypes.FirstOrDefault().UserTypeId
};
_modelRepository.Add(userJane);
}
_modelRepository.SaveChanges();
}
}
public string HelloWorld(string firstName)
{
try
{
Initialize();
using (var db = new HelloWorldContext())
{
var _modelRepository = new ModelDbRepository(db);
var user = (from u in _modelRepository.Fetch <User>()
where u.FirstName == firstName
select u).FirstOrDefault();
if (user == null)
{
return($"Hello World - user {firstName} don't exists");
}
return($"Hello {firstName}");
}
}
catch (Exception ex)
{
//TODO: Log error
return(ex.Message);
}
}