/// <summary> /// /// </summary> /// <param name="propertyImageId"></param> /// <returns></returns> public PropertyModel GetPropertyByImageId(int propertyImageId) { PropertyModel model = null; using (var db = new SearchHomeEntities()) { model = db.PropertyImages.Where(x => x.PropertyId == propertyImageId) .Select(x => new PropertyModel { Images = db.PropertyImages.Where(y => y.PropertyId == propertyImageId) .Select(y => new PropertyImageModel { filePath = y.ImagePath, Id = y.Id }).ToList(), //IndividualImage = new PropertyImageModel { filePath = x.ImagePath, Id = x.Id }, Amenities = x.Property.Amenities, Address = x.Property.Address, City = x.Property.City, PropertyName = x.Property.PropertyName, State = x.Property.State, Details = x.Property.Details, Id = x.Property.Id, University = x.Property.University, LastChanged = (DateTime)x.Property.LastChange }).FirstOrDefault(); } return(model); }
protected override bool OnSaveToStorage(UsersModel model) { bool returnValue = false; USER user = null; try { using (var db = new SearchHomeEntities()) { if (model.Id == 0) { user = new USER { UserId = model.UserId, UserName = model.UserName, UserImage = model.ImagePath, Degree = model.Degree, Interests = model.Interests, University = model.University, Status = model.Status, UserEmail = model.Email, LastUpdated = DateTime.Now, IsFirstTimeRegister = model.IsFirstTimeRegister }; db.USERS.Add(user); } else { user = db.USERS.First(x => x.UserId == model.UserId); user.UserId = model.UserId; user.UserName = model.UserName; user.University = model.University; user.Degree = model.Degree; user.Interests = model.Interests; user.Status = model.Status; user.UserEmail = model.Email; user.LastUpdated = DateTime.Now; user.IsFirstTimeRegister = model.IsFirstTimeRegister; user.UserImage = model.ImagePath; } if (returnValue = db.SaveChanges() > 0) { model.UserId = user.UserId; } } } catch (Exception ex) { LogWriter.LogException("User Repository: ", ex); } return(returnValue); }
protected override bool OnSaveToStorage(PropertyModel model) { bool returnValue = false; Property property = null; try { using (var db = new SearchHomeEntities()) { if (model.Id == 0) { property = new Property { PropertyName = model.PropertyName, Address = model.Address, UserId = model.UserId, City = model.City, State = model.State, Details = model.Details, Amenities = model.Amenities, University = model.University, LastChange = DateTime.Now }; db.Properties.Add(property); } else { property = db.Properties.First(x => x.Id == model.Id); property.PropertyName = model.PropertyName; property.Address = model.Address; property.City = model.City; property.State = model.State; property.Details = model.Details; property.Amenities = model.Amenities; property.University = model.University; property.LastChange = DateTime.Now; } if (returnValue = db.SaveChanges() > 0) { model.Id = property.Id; } } } catch (Exception ex) { LogWriter.LogException("Property Repository: ", ex); } return(returnValue); }
public async Task <bool> DeleteUser(UsersModel model) { bool returnValue; using (var db = new SearchHomeEntities()) { var user = db.USERS.Where(x => x.UserId == model.UserId).First(); db.USERS.Remove(user); returnValue = db.SaveChanges() > 0; } return(await Task.FromResult(returnValue)); }
public bool SaveContextChanges(SearchHomeEntities context) { bool returnValue = false; if (context.ChangeTracker.HasChanges()) { returnValue = context.SaveChanges() > 0; } else { returnValue = true; } return(returnValue); }
public bool UpdatePropertyImages(IEnumerable <PropertyImageModel> models, int propertyId) { bool returnValue = false; using (var db = new SearchHomeEntities()) { var prop = db.PropertyImages.First(x => x.PropertyId == propertyId); foreach (var model in models) { prop.ImagePath = model.filePath; prop.LastUpdated = DateTime.Now; } returnValue = db.SaveChanges() > 0; } return(returnValue); }
public bool CheckPropertyPresent(string userId) { bool returnValue = false; try { using (var db = new SearchHomeEntities()) { returnValue = db.Properties.Where(x => x.UserId == userId).Any(); } } catch (Exception ex) { throw ex; } return(returnValue); }
protected override IQueryable <PropertyImageModel> OnGetAllItems(string userId) { List <PropertyImageModel> model = null; using (var db = new SearchHomeEntities()) { model = db.PropertyImages.Where(x => x.Property.UserId == userId) .Select(x => new PropertyImageModel { filePath = x.ImagePath, Name = x.Property.PropertyName, PropertyId = x.PropertyId, Id = x.Id }).ToList(); } return(model.AsQueryable()); }
public List <PropertyImageModel> GetAllPropertyImages() { List <PropertyImageModel> model = null; using (var db = new SearchHomeEntities()) { model = db.PropertyImages .Select(x => new PropertyImageModel { filePath = x.ImagePath, Name = x.Property.PropertyName, PropertyId = x.PropertyId, Id = x.Id, ImageUploadedTime = (DateTime)x.Property.LastChange }).ToList(); } return(model); }
public IQueryable <PropertyModel> GetAllItems() { List <PropertyModel> model = null; try { using (var db = new SearchHomeEntities()) { model = (from pt in db.Properties join user in db.USERS on pt.UserId equals user.UserId join pimg in db.PropertyImages on pt.Id equals pimg.PropertyId select new PropertyModel { Id = pt.Id, Address = pt.Address, City = pt.City, State = pt.State, Details = pt.Details, Amenities = pt.Amenities, University = pt.University, PropertyName = pt.PropertyName, UserId = pt.UserId, Users = new UsersModel { Email = user.UserEmail, UserName = user.UserName }, IndividualImage = new PropertyImageModel { filePath = pimg.ImagePath, Id = pimg.Id }, LastChanged = (DateTime)pt.LastChange }).OrderByDescending(x => x.LastChanged).ToList(); } } catch (Exception ex) { throw ex; } return(model.AsQueryable()); }
public bool AddPropertyImages(IEnumerable <PropertyImageModel> models, int propertyId) { bool returnValue = false; using (var db = new SearchHomeEntities()) { foreach (var model in models) { var propertyImage = new PropertyImage { ImagePath = model.filePath, Name = model.Name, PropertyId = propertyId, Size = model.Size }; db.PropertyImages.Add(propertyImage); } returnValue = db.SaveChanges() > 0; } return(returnValue); }
public PropertyModel GetPropertyByPropertyId(int propertyId) { PropertyModel model = null; using (var db = new SearchHomeEntities()) { model = db.Properties.Where(x => x.Id == propertyId) .Select(x => new PropertyModel { Amenities = x.Amenities, Address = x.Address, City = x.City, PropertyName = x.PropertyName, State = x.State, Details = x.Details, UserId = x.UserId, University = x.University }).FirstOrDefault(); } return(model); }
public IQueryable <UsersModel> GetAllUsers() { List <UsersModel> usersModel = null; using (var db = new SearchHomeEntities()) { usersModel = db.USERS.Select(x => new UsersModel { Email = x.UserEmail, UserId = x.UserId, University = x.University, Degree = x.Degree, Interests = x.Interests, Status = x.Status, ImagePath = x.UserImage, UserName = x.UserName, LastUpdated = x.LastUpdated }).OrderByDescending(x => x.LastUpdated).ToList(); } return(usersModel.AsQueryable()); }
protected override bool OnRemoveFromStorage(PropertyModel model) { bool returnValue; try { using (var db = new SearchHomeEntities()) { var propImage = db.PropertyImages.Where(x => x.PropertyId == model.Id); db.PropertyImages.RemoveRange(propImage); var property = db.Properties.Where(x => x.Id == model.Id).First(); db.Properties.Remove(property); returnValue = db.SaveChanges() > 0; } } catch (Exception ex) { throw ex; } return(returnValue); }
public UsersModel GetUserProfile(string userId) { UsersModel model = null; using (var db = new SearchHomeEntities()) { model = db.USERS.Where(x => x.UserId == userId) .Select(y => new UsersModel { Id = y.Id, UserName = y.UserName, University = y.University, ImagePath = y.UserImage, Status = y.Status, Degree = y.Degree, Interests = y.Interests, LastUpdated = y.LastUpdated, UserId = y.UserId, Email = y.UserEmail, IsFirstTimeRegister = y.IsFirstTimeRegister }).FirstOrDefault(); } return(model); }
public bool DeleteUserProperty(PropertyModel model) { bool returnValue = false; try { using (var db = new SearchHomeEntities()) { var propImg = db.PropertyImages.Where(x => x.Property.UserId == model.UserId); db.PropertyImages.RemoveRange(propImg); var properties = db.Properties.Where(x => x.UserId == model.UserId); db.Properties.RemoveRange(properties); returnValue = db.SaveChanges() > 0; } } catch (Exception ex) { throw ex; } return(returnValue); }
public EntityRepositoryBase(SearchHomeEntities entities) { Context = entities; }