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