public List <CheckListItem> GetDefaultCheckListItems(ChainsDBEntities context) { var defaultCollection = context.CheckListItemDefaultCollections.ToList(); var checkListItems = context.CheckListItems.Where(o => defaultCollection.Any(x => x.CheckListItemId == o.Id)); return(checkListItems.ToList()); }
public List <PropertyCheckListitem> GetCheckListItemsForProperty(Guid propertyId) { using (var context = new ChainsDBEntities()) { return(_databaseRepository.GetCheckListItemsForProperty(context, propertyId)); } }
public void DeleteProperty(ChainsDBEntities context, Guid id, string username, DateTime now) { var propertyToDelete = context.Properties.Find(id); propertyToDelete.DateDeleted = now; propertyToDelete.DeletedBy = username; propertyToDelete.Deleted = true; context.SaveChanges(); }
public void Update <T>(ChainsDBEntities context, T item, Guid id) { var entity = context.Set(typeof(T)).Find(id); if (entity == null) { return; } context.Entry(entity).CurrentValues.SetValues(item); context.SaveChanges(); }
private void AddPropertyCheckListItem(ChainsDBEntities context, Guid propertyId, List <CheckListItem> checkListItems) { var propertyCheckListItemsToAdd = new List <PropertyCheckListitem>(); foreach (var checkListItem in checkListItems) { propertyCheckListItemsToAdd.Add(new PropertyCheckListitem { Id = _guidRepository.NewGuid(), CheckListItemId = checkListItem.Id, Created = _dateRepository.Now(), PropertyId = propertyId }); } _databaseRepository.AddPropertyCheckListItems(context, propertyCheckListItemsToAdd); }
public bool Delete(Guid id, string username) { try { using (var context = new ChainsDBEntities()) { _databaseRepository.DeleteProperty(context, id, username, _dateRepository.Now()); return(true); } } catch (Exception ex) { _logger.ErrorFormat("Failed to delete property ID: {0} - Exception: {1}", id, ex.Message); return(false); } }
public List <PropertyInformationViewModel> GetAllProperties() { using (var context = new ChainsDBEntities()) { var returnList = new List <PropertyInformationViewModel>(); var propertyList = _databaseRepository.GetAllProperties(context).Where(o => !o.Deleted); propertyList.ForEach(o => { var property = Mapper.Map <PropertyInformationViewModel>((Property)o); foreach (var checkListitem in o.PropertyCheckListitems) { property.PropertyCheckListitems.Add(new PropertyCheckListItemViewModel(checkListitem)); } returnList.Add(property); }); return(returnList); } }
public bool Add(Feedback feedbackItem) { feedbackItem.AddedOn = _dateRepository.Now(); feedbackItem.Id = _guidRepository.NewGuid(); try { using (var context = new ChainsDBEntities()) { _databaseRepository.AddItem <Feedback>(context, feedbackItem); return(true); } } catch (Exception ex) { _logger.ErrorFormat("Could not save the feedback item. \r\nName: {0}\r\nEmail: {1}\r\nDetails: {2}\r\n\r\nException: {3}", feedbackItem.Name, feedbackItem.Email, feedbackItem.Details, ex.Message); return(false); } }
public bool Upsert(PropertyInformationViewModel viewModel) { try { using (var context = new ChainsDBEntities()) { var insert = viewModel.Id == _guidRepository.EmptyGuid(); Property propertyToUpsert; if (insert) { var buyerCode = GetNewCode(); _databaseRepository.AddItem(context, buyerCode); var sellerCode = GetNewCode(); _databaseRepository.AddItem(context, sellerCode); propertyToUpsert = ConvertPropertyViewModelToDBType(viewModel, buyerCode.Id, sellerCode.Id); var defaultCheckListItems = _databaseRepository.GetDefaultCheckListItems(context); _databaseRepository.AddItem(context, propertyToUpsert); AddPropertyCheckListItem(context, propertyToUpsert.Id, defaultCheckListItems); } else { propertyToUpsert = ConvertPropertyViewModelToDBType(viewModel, viewModel.BuyerCodeId, viewModel.SellerCodeId); _databaseRepository.Update(context, propertyToUpsert, propertyToUpsert.Id); } return(true); } } catch (Exception ex) { _logger.ErrorFormat("Could not save the property with RMI: {0} \r\n Exception: {1}", viewModel.RightMoveIdentifier, ex.Message); return(false); } }
public void AddPropertyCheckListItems(ChainsDBEntities context, List <PropertyCheckListitem> checkListItems) { context.PropertyCheckListitems.AddRange(checkListItems); context.SaveChanges(); }
public void AddItem <T>(ChainsDBEntities context, T item) { context.Set(typeof(T)).Add(item); context.SaveChanges(); }
public List <PropertyCheckListitem> GetCheckListItemsForProperty(ChainsDBEntities context, Guid propertyId) { return(context.PropertyCheckListitems.Where(o => o.PropertyId == propertyId).ToList()); }
public List <Property> GetAllProperties(ChainsDBEntities context) { return(context.Properties.Include("PropertyCheckListitems") /*.Include("PropertyCheckListitems.CheckListItem")*/.ToList()); }