public IQueryable <UserModel> Query()
{
var userQuery = _userRepository.EntityQuery("UserDetail", "Role");
var countryQuery = _countryRepository.Query();
var cityQuery = _cityRepository.Query();
var query = from user in userQuery
join country in countryQuery
on user.UserDetail.CountryId equals country.Id
join city in cityQuery
on user.UserDetail.CityId equals city.Id
//orderby new { user.Role.Name, user.UserName }
select new UserModel()
{
Active = user.Active,
ActiveText = user.Active ? "Yes" : "No",
Guid = user.Guid,
Id = user.Id,
Password = user.Password,
Role = new RoleModel()
{
Guid = user.Role.Guid,
Id = user.Role.Id,
Name = user.Role.Name
},
RoleId = user.RoleId,
UserDetail = new UserDetailModel()
{
Address = user.UserDetail.Address,
CityId = user.UserDetail.CityId,
CountryId = user.UserDetail.CountryId,
EMail = user.UserDetail.EMail,
Guid = user.UserDetail.Guid,
Id = user.UserDetail.Id,
Country = new CountryModel()
{
Id = country.Id,
Guid = country.Guid,
Name = country.Name
},
City = new CityModel()
{
Id = city.Id,
Guid = city.Guid,
Name = city.Name,
CountryId = city.CountryId
}
},
UserDetailId = user.UserDetailId,
UserName = user.UserName
};
return(query);
}
public Result Add(CityModel model)
{
try
{
if (_cityRepository.Query().Any(c => c.Name.ToUpper() == model.Name.ToUpper().Trim()))
{
return(new ErrorResult("City with the same name exists!"));
}
var entity = new City()
{
CountryId = model.CountryId,
Name = model.Name.Trim()
};
_cityRepository.Add(entity);
return(new SuccessResult());
}
catch (Exception exc)
{
return(new ExceptionResult(exc));
}
}
