public UnitOfWork(EasyFindPropertiesEntities dbCtx)
{
_dbCtx = dbCtx;
PropertyType = new PropertyTypeRepository(_dbCtx);
AdPriority = new AdPriorityRepository(_dbCtx);
AdType = new AdTypeRepository(_dbCtx);
PropertyCategory = new PropertyCategoryRepository(_dbCtx);
PropertyCondition = new PropertyConditionRepository(_dbCtx);
PropertyImage = new PropertyImageRepository(_dbCtx);
PropertyPurpose = new PropertyPurposeRepository(_dbCtx);
PropertyRating = new PropertyRatingRepository(_dbCtx);
Property = new PropertyRepository(_dbCtx);
PropertyRequisition = new PropertyRequisitionRepository(_dbCtx);
SubscriptionType = new SubscriptionTypeRepository(_dbCtx);
Subscription = new SubscriptionRepository(_dbCtx);
TagType = new TagTypeRepository(_dbCtx);
Tennant = new TennantRepository(_dbCtx);
Owner = new OwnerRepository(_dbCtx);
Tags = new TagsRepository(_dbCtx);
Message = new MessageRepository(_dbCtx);
User = new UserRepository(_dbCtx);
UserType = new UserTypeRepository(_dbCtx);
UserTypeAssoc = new UserTypeAssocRepository(_dbCtx);
MessageTrash = new MessageTrashRepository(_dbCtx);
Meeting = new MeetingRepository(_dbCtx);
MeetingMembers = new MeetingMembersRepository(_dbCtx);
}
public ActionResult StoreInRedis()
{
PropertyRepository ir = new PropertyRepository();
try
{
if (ir.MyConnection.State == System.Data.ConnectionState.Closed)
{
ir.MyConnection.Open();
}
var list = ir.GetProperty();
//foreach (var item in list)
//{
// var name = ir.GetPropertyName(item.Name);
// item.Name = name;
//}
RedisRepository rr = new RedisRepository();
return(View("Index", list));
}
catch (Exception ex)
{
ViewBag.Error = ex + " - (Error occurred. Items were not deleted)";
return(View(new List <Property>()));
}
finally
{
if (ir.MyConnection.State == System.Data.ConnectionState.Open)
{
ir.MyConnection.Close();
}
}
}
public void UpdatePropertySuccess()
{
//Arrange
var propertyRepository = new PropertyRepository(_container);
var dbContext = _serviceProvider.GetRequiredService <DeviserDbContext>();
var properties = TestDataRepository.GetProperties();
foreach (var item in properties)
{
propertyRepository.CreateProperty(item);
}
var propertyToUpdate = propertyRepository.GetProperties().First();
propertyToUpdate.Value = "Updated Value";
//Act
var result = propertyRepository.UpdateProperty(propertyToUpdate);
//Assert
Assert.NotNull(result);
Assert.NotEqual(result.Id, Guid.Empty);
Assert.True(!string.IsNullOrEmpty(result.Name));
Assert.True(!string.IsNullOrEmpty(result.Label));
Assert.True(propertyToUpdate.Value == result.Value);
Assert.True(result.CreatedDate > DateTime.MinValue);
Assert.True(result.LastModifiedDate > DateTime.MinValue);
//Clean
dbContext.Property.RemoveRange(dbContext.Property);
}
public void GetPropertiesSuccess()
{
//Arrange
var propertyRepository = new PropertyRepository(_container);
var dbContext = _serviceProvider.GetRequiredService <DeviserDbContext>();
var properties = TestDataRepository.GetProperties();
foreach (var item in properties)
{
propertyRepository.CreateProperty(item);
}
//Act
var result = propertyRepository.GetProperties();
var resultItem = result.First();
//Assert
Assert.NotNull(result);
Assert.True(result.Count > 0);
Assert.NotNull(resultItem);
Assert.NotEqual(resultItem.Id, Guid.Empty);
Assert.True(resultItem.CreatedDate > DateTime.MinValue);
Assert.True(resultItem.LastModifiedDate > DateTime.MinValue);
//Clean
dbContext.Property.RemoveRange(dbContext.Property);
}
/// <summary>
/// 删除实体属性信息信息
/// </summary>
/// <param name="ids">要删除的实体属性信息编号</param>
/// <returns>业务操作结果</returns>
public async Task <OperationResult> DeleteCodeProperties(params Guid[] ids)
{
List <string> names = new List <string>();
UnitOfWork.EnableTransaction();
foreach (var id in ids)
{
var property = await PropertyRepository.GetAsync(id);
if (property == null)
{
continue;
}
int count = await PropertyRepository.DeleteAsync(property);
if (count > 0)
{
names.Add(property.Name);
}
}
await UnitOfWork.CommitAsync();
return(names.Count > 0
? new OperationResult(OperationResultType.Success, $"属性“{names.ExpandAndToString()}”删除成功")
: OperationResult.NoChanged);
}
public ActionResult RefreshCache()
{
//1. Load items from cache
RedisRepository rr = new RedisRepository();
var items = rr.LoadItems();
//2. hash the serialized value of items
PropertyRepository pr = new PropertyRepository();
pr.MyConnection.Open();
var itemsFromDb = pr.GetProperty();
pr.MyConnection.Close();
if (items == null)
{
rr.StoreItems(itemsFromDb);
return(Content("done"));
}
//3. compare the digest produced with the digest produced earlier while stored in application variable
if (rr.HashValue(JsonConvert.SerializeObject(items)) != rr.HashValue(JsonConvert.SerializeObject(itemsFromDb)))
{
//4. if they do not match; storeincache method and re-produce a new hashcode
rr.StoreItems(itemsFromDb); return(Content("done"));
}
return(Content("properties were not updated since they are still the same"));
}
public IPropertyService Create()
{
IPropertyRepository repository = new PropertyRepository();
PropertyService service = new PropertyService(repository);
return(service);
}
public void Setup()
{
InitialiseMapping();
_connection = new SqliteConnection("DataSource=:memory:");
_connection.Open();
var options = new DbContextOptionsBuilder <PropertyContext>()
.UseSqlite(_connection)
.Options;
var inMemoryContext = new PropertyContext(options);
inMemoryContext.Properties.AddRange(GenerateFakeProperties());
inMemoryContext.SaveChanges();
// While working with a inMemoryDb there is no need for mocking IPropertyRepository
// Instead working to implementation provides implementation test without affecting Db
// var service = new Mock<IPropertyRepository>();
// service.Setup(p => p.GetProperties()).Returns(inMemoryContext.Properties);
var service = new PropertyRepository(inMemoryContext);
Sut = new PropertiesController(service);
}
void OnSave(object sender, EventArgs e)
{
var repository = new PropertyRepository();
repository.SaveOrUpdate(Model.GetEntity());
Navigation.PopAsync();
}
public JsonResult GetSearchList(string latitude1, string latitude2)
{
var property = new List <Property>();
PropertyRepository pRepo = new PropertyRepository();
property = pRepo.GetSearchList(latitude1, latitude2);
return(Json(property));
}
public ActionResult ViewProperty(int propertyId)
{
PropertyRepository propRepo = new PropertyRepository();
var propertyObj = propRepo.GetByID(propertyId);
var viewModel = new ViewPropertyViewModel(propertyObj);
return(View(viewModel));
}
public UnitOfWork(PMSContext context)
{
_context = context;
//Courses = new CourseRepository(_context);
//Authors = new AuthorRepository(_context);
Properties = new PropertyRepository(_context);
Ventures = new VentureRepository(_context);
}
/// <summary>
/// Contructor de la clase
/// </summary>
/// <param name="context">Contexto de base de datos</param>
public UnitOfWorkSqlServerRepository(WeeloDbContext context)
{
this.context = context;
Owner = new OwnerRepository(this.context);
PropertyImage = new PropertyImageRepository(this.context);
Property = new PropertyRepository(this.context);
PropertyTrace = new PropertyTraceRepository(this.context);
}
public ActionResult DeleteAll(List <int> items)
{
PropertyRepository ir = new PropertyRepository();
List <Property> myList = new List <Property>();
try
{
if (ir.MyConnection.State == System.Data.ConnectionState.Closed)
{
ir.MyConnection.Open();
ir.MyTransaction = ir.MyConnection.BeginTransaction(); //pending until committed
}
foreach (int id in items)
{
ir.DeleteProperty(id);
}
if (items.Count > 1)
{
ViewBag.Success = "Items were deleted successfully";
}
else
{
ViewBag.Success = "Item was deleted successfully";
}
ir.MyTransaction.Commit(); //committed
//this doesnt need to participate in transaction cos its not changing anything in database, its just getting.
myList = ir.GetProperty();
return(View("Index", myList));
}
catch (Exception ex)
{
ir.MyTransaction.Rollback();
if (items.Count > 1)
{
ViewBag.Error = ex + " - (Error occurred. Items were not deleted)";
}
else
{
ViewBag.Error = ex + " - (Error occurred. Item was not deleted)";
}
myList = ir.GetProperty();
return(View("Index", myList));
}
finally
{
if (ir.MyConnection.State == System.Data.ConnectionState.Open)
{
ir.MyConnection.Close();
}
}
}
public IActionResult EditHouse(House selectedHouse)
{
//Open Edit house window with existing house
using (IPropertyRepository propRep = new PropertyRepository())
{
selectedHouse.Photos = propRep.SelectPhotos(selectedHouse.MLSNum);
}
return(View("~/Views/Property/EditProperty.cshtml", selectedHouse));
}
public ActionResult Index()
{
ViewBag.Greeting = "Bienvenido";
PropertiesResume propertiesResume = new PropertiesResume();
var repository = new PropertyRepository();
propertiesResume.Properties = repository.GetAll().Take(9).ToList();
return(View(propertiesResume));
}
public List <PropertyResponse> GetPropertyInRange(int low, int high)
{
var propertyEntities = PropertyRepository.GetPropertyInRange(low, high);
foreach (var property in propertyEntities)
{
PropertyResponses.Add(_mapper.Map <PropertyResponse>(property));
}
return(PropertyResponses);
}
public IEnumerable <PropertyResponse> GetAllProperties()
{
var propertyEntities = PropertyRepository.GetAllProperties();
foreach (var property in propertyEntities)
{
PropertyResponses.Add(_mapper.Map <PropertyResponse>(property));
}
return(PropertyResponses);
}
public ListEntryView(ListEntry listEntry)
{
_PropertyRepository = new PropertyRepository();
Model.Date = listEntry.Date;
Model.Title = listEntry.Title;
Model.Id = listEntry.Id;
CreateLayout();
}
public IEnumerable <Property> Get()
{
var service = new PropertyRepository();
var property = redis.Read <IEnumerable <Property> >("property", 0);
if (property.Count() == 0)
{
return(service.GetProperties());
}
return(property);
}
public ActionResult DeleteItems(List <int> items)
{
if (items.Count > 0)
{
PropertyRepository pr = new PropertyRepository();
List <Property> myList = new List <Property>();
try
{
if (pr.MyConnection.State == System.Data.ConnectionState.Closed)
{
pr.MyConnection.Open();
pr.MyTransaction = pr.MyConnection.BeginTransaction();
}
//delete all items
foreach (int id in items)
{
pr.DeleteProperty(id);
}
pr.MyTransaction.Commit();
if (items.Count == 1)
{
ViewBag.Success = "Property was deleted";
}
else
{
ViewBag.Success = "Properties were deleted";
}
}
catch (Exception ex)
{
pr.MyTransaction.Rollback();
//log exception
LoggingRepository.ReportError(ex);
ViewBag.Error = "Error occurred. Nothing was deleted; Try again later";
}
finally
{
myList = pr.GetProperty().ToList(); //to refresh the now updated list
if (pr.MyConnection.State == System.Data.ConnectionState.Open)
{
pr.MyConnection.Close();
}
}
return(View("Index", myList));
}
return(RedirectToAction("Index"));
}
/// <summary>
/// InsertPropertyDetails
/// </summary>
/// <param name="propertyDetail"></param>
public static void InsertPropertyDetails(PropertyDetail propertyDetail)
{
using (var propertyRepository = new PropertyRepository(new SQLiteInfoMonodroid()))
{
var detail = propertyRepository.GetPropertyDetailById(propertyDetail.ListingID);
if (detail.Result == null)
{
propertyRepository.InsertPropertyDetail(propertyDetail);
}
}
}
public ActionResult Create(PropertyViewModel p)
{
PropertyRepository cc = new PropertyRepository();
try
{
if (cc.MyConnection.State == System.Data.ConnectionState.Closed)
{
cc.MyConnection.Open();
}
//save in bucket
var myStorageManager = StorageClient.Create();
var guid = Guid.NewGuid();
var mynewobj = myStorageManager.UploadObject("programmingcloud", guid.ToString() + Path.GetExtension(p.File.FileName), p.File.ContentType, p.File.InputStream,
options: new Google.Cloud.Storage.V1.UploadObjectOptions()
{
PredefinedAcl = Google.Cloud.Storage.V1.PredefinedObjectAcl.PublicRead
});
string imgName = guid.ToString() + Path.GetExtension(p.File.FileName);
string us = User.Identity.Name;
string u = us.Substring(0, us.IndexOf("@"));
p.Username = u;
var prop = new Property()
{
Username = p.Username,
Location = p.Location,
Name = p.Name,
Description = p.Description,
Price = p.Price,
PropertyPicture = imgName
};
cc.AddProperty(prop);
ViewBag.Success = "Property was created successfully";
return(View());
}
catch (Exception ex)
{
LoggingRepository.ReportError(ex);
ViewBag.Error = ex + " - (Error occurred. Property was not added)";
return(View());
}
finally
{
if (cc.MyConnection.State == System.Data.ConnectionState.Open)
{
cc.MyConnection.Close();
}
}
}
public IActionResult DeleteHouse(int houseId)
{
//Delete house from database
List <House> Properties;
using (IPropertyRepository propRep = new PropertyRepository())
{
propRep.DeleteHouse(houseId);
Properties = propRep.PopulateHouses();
}
return(View("~/Views/Property/Houses.cshtml", Properties));
}
public async void BeginUpdateAsync(Dispatcher dispatcher)
{
this.dispatcher = dispatcher;
IsUpdating = true;
Items = null;
await ThreadPool.RunAsync(async delegate
{
var entries = await PropertyRepository.GetAllAsync();
PopulateData(entries);
});
}
/// <summary>
/// InsertProperty
/// </summary>
/// <param name="propertyList"></param>
public static void InsertProperty(List <Property> propertyList)
{
using (var propertyRepository = new PropertyRepository(new SQLiteInfoMonodroid()))
{
if (propertyRepository.GetPropertyCount() < propertyList.Count)
{
foreach (var property in propertyList)
{
propertyRepository.InsertProperty(property);
}
}
}
}
public async void Validate_Get_States()
{
var opts = new AcmeDirectorySearch.Infrastructure.DatabaseOptions();
opts.ConnectionString = fixture.DatabaseConnectionString;
var iopts = Options.Create <AcmeDirectorySearch.Infrastructure.DatabaseOptions>(opts);
var repo = new PropertyRepository(iopts);
var results = await repo.GetStates();
Assert.Equal(50, results.ToList <string>().Count);
}
/// <summary>
/// 更新实体属性信息信息
/// </summary>
/// <param name="dtos">包含更新信息的实体属性信息输入DTO</param>
/// <returns>业务操作结果</returns>
public async Task <OperationResult> UpdateCodeProperties(params CodePropertyInputDto[] dtos)
{
List <string> names = new List <string>();
UnitOfWork.EnableTransaction();
foreach (var dto in dtos)
{
dto.Validate();
CodeEntity entity = await EntityRepository.GetAsync(dto.EntityId);
if (entity == null)
{
return(new OperationResult(OperationResultType.Error, $"编号为“{dto.EntityId}”的实体信息不存在"));
}
if (await CheckCodePropertyExists(m => m.Name == dto.Name && m.EntityId == dto.EntityId, dto.Id))
{
return(new OperationResult(OperationResultType.Error, $"实体“{entity.Name}”中名称为“{dto.Name}”的属性信息已存在"));
}
if (dto.Order == 0)
{
dto.Order = PropertyRepository.Query(m => m.EntityId == entity.Id).Count() + 1;
}
int count;
if (dto.Id == default)
{
CodeProperty property = dto.MapTo <CodeProperty>();
count = await PropertyRepository.InsertAsync(property);
}
else
{
CodeProperty property = await PropertyRepository.GetAsync(dto.Id);
property = dto.MapTo(property);
count = await PropertyRepository.UpdateAsync(property);
}
if (count > 0)
{
names.Add(dto.Name);
}
}
await UnitOfWork.CommitAsync();
return(names.Count > 0
? new OperationResult(OperationResultType.Success, $"属性“{names.ExpandAndToString()}”保存成功")
: OperationResult.NoChanged);
}
public void UpdatePropertyFail()
{
//Arrange
var propertyRepository = new PropertyRepository(_container);
var dbContext = _serviceProvider.GetRequiredService <DeviserDbContext>();
var properties = TestDataRepository.GetProperties();
//Act
var result = propertyRepository.UpdateProperty(null);
//Assert
Assert.Null(result);
//Clean
dbContext.Property.RemoveRange(dbContext.Property);
}
public IActionResult EditProperty(House house, IFormFile fileSelect)
{
//Edit house in database
using (var target = new MemoryStream())
{
fileSelect.CopyTo(target);
house.PhotoData = target.ToArray();
}
List <House> Properties;
using (IPropertyRepository propRep = new PropertyRepository())
{
propRep.EditHouse(house);
Properties = propRep.PopulateHouses();
}
return(View("~/Views/Property/Houses.cshtml", Properties));
}
public PropertyController()
{
this.propertyRepository = new PropertyRepository();
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new PropertyRepository(_entities);
_results = _target.Retrieve(prop => prop.NumUnits > 5).ToList();
}
public PropertyController(PropertyRepository propertyRepository)
{
this.propertyRepository = propertyRepository;
}
