public async Task <IActionResult> PutDeliveryMethod(int id, DeliveryMethodObjectModel deliveryMethodAjax)
{
deliveryMethodAjax.Name = deliveryMethodAjax.Name.Trim();
if (id != deliveryMethodAjax.Id || string.IsNullOrEmpty(deliveryMethodAjax.Name))
{
_logger.LogError("Запрашиваемая доставка не найдена: id={0}", id);
return(new ObjectResult(new ServerActionResult()
{
Success = false,
Info = "Запрашиваемая доставка не найдена",
Status = StylesMessageEnum.danger.ToString()
}));
}
_context.Entry(deliveryMethodAjax).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(NoContent());
}
public async Task <IQueryable <PropertyOwner> > Handle(AllOwnerListQuery request, CancellationToken cancellationToken)
{
var allOwners = (from o in _context.PropertyOwner
join op in _context.OwnerProperty on o.Id equals op.PropertyOwnerId
join p in _context.Property on op.PropertyId equals p.Id
select new {
}
);
var owners = _context.PropertyOwner
.Include(a => a.Address)
.ToList();
foreach (var owner in owners)
{
_context.Entry(owner)
.Collection(c => c.OwnerProperty).Load();
foreach (var op in owner.OwnerProperty)
{
_context.Entry(op)
.Reference(o => o.Property).Load();
}
}
var result = _context.PropertyOwner //;
.Include(op => op.OwnerProperty)
.ThenInclude(p => p.Property).ToList();
return(result.AsQueryable());
// return owners.AsQueryable();
//throw new NotImplementedException();
}
public async Task <IActionResult> PutProfile(int id, СonversationDocumentModel ajaxConversation)
{
if (id != ajaxConversation.Id)
{
return(null); // BadRequest();
}
_context.Entry(ajaxConversation).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw;
}
return(null); // NoContent();
}
public async Task <IActionResult> PutNotification(int id, NotificationObjectModel ajaxNotification)
{
if (id != ajaxNotification.Id)
{
return(BadRequest());
}
_context.Entry(ajaxNotification).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw;
}
return(NoContent());
}
public async Task <PropertyDetailViewModel> Handle(PropertyDetailsQuery request, CancellationToken cancellationToken)
{
//var ppt = _context.Property
// .Select(p => new
// {
// p.Id,
// p.PropertyName,
// Owners = string.Join(", ", p.OwnerProperty
// .Select(o => o.PropertyOwner.FirstName))
// }).FirstOrDefault(i => i.Id == request.Id);
var ppt = _context.Property
.Include(a => a.Address)
.FirstOrDefault(p => p.Id == request.Id);
_context.Entry(ppt)
.Collection(c => c.OwnerProperty).Load();
foreach (var op in ppt.OwnerProperty)
{
_context.Entry(op)
.Reference(o => o.PropertyOwner).Load();
}
var prop = _context.Property
//.Include(c => c.ManagementContract)
.Include(fe => fe.Feature)
.Include(fa => fa.Facility)
.Include(a => a.Address)
.Include(m => m.PropertyImg)
.Include(op => op.OwnerProperty)
.ThenInclude(po => po.PropertyOwner)
.Where(po => po.Id == request.Id)
.Select(op => new PropertyDetailViewModel
{
PropertyName = op.PropertyName,
PropertyId = op.Id,
PropertyDesc = op.PropertyDesc,
PropertyLogoImgUrl = op.PropertyLogoImgUrl,
PropertyVideoUrl = op.PropertyVideoUrl,
IsActive = op.IsActive,
IsShared = op.IsShared,
IsBasementSuite = op.IsBasementSuite,
PropertyType1 = op.Type.ToString(),
Status = op.Status.ToString(),
PropertyBuildYear = op.PropertyBuildYear,
PropertySuiteNumber = op.Address.PropertySuiteNumber,
PropertyNumber = op.Address.PropertyNumber,
PropertyStreet = op.Address.PropertyStreet,
PropertyCity = op.Address.PropertyCity,
PropertyStateProvince = op.Address.PropertyStateProvince,
PropertyZipPostCode = op.Address.PropertyZipPostCode,
PropertyCountry = op.Address.PropertyCountry,
GpslatitudeValue = op.Address.GpslatitudeValue,
GpslongitudeValue = op.Address.GpslongitudeValue,
NumberOfBathrooms = op.Feature.NumberOfBathrooms,
NumberOfBedrooms = op.Feature.NumberOfBedrooms,
NumberOfLayers = op.Feature.NumberOfLayers,
NumberOfParking = op.Feature.NumberOfParking,
BasementAvailable = op.Feature.BasementAvailable,
TotalLivingArea = op.Feature.TotalLivingArea,
FeatureNotes = op.Feature.Notes,
Stove = op.Facility.Stove,
Refrigerator = op.Facility.Refrigerator,
Dishwasher = op.Facility.Dishwasher,
Laundry = op.Facility.Laundry,
BlindsCurtain = op.Facility.BlindsCurtain,
Furniture = op.Facility.Furniture,
Tvinternet = op.Facility.Tvinternet,
CommonFacility = op.Facility.CommonFacility,
SecuritySystem = op.Facility.SecuritySystem,
UtilityIncluded = op.Facility.UtilityIncluded,
FireAlarmSystem = op.Facility.FireAlarmSystem,
Others = op.Facility.Others,
FacilityNotes = op.Facility.Notes,
CreationDate = op.Created.ToString("MMMM dd, yyyy"),
UpdateDate = op.Modified.ToString("MMMM dd, yyyy"),
OwnerList = op.OwnerProperty.Select(o => o.PropertyOwner).ToList(),
ContractList = op.ManagementContract /*.Where(c =>c.IsActive == true)*/.ToList(),
ImagetList = op.PropertyImg.ToList()
});
//.FirstOrDefault(op => op.PropertyId == request.Id);
//var pptList = (from p in _context.Property
// .Include(fe => fe.Feature)
// .Include(fa => fa.Facility)
// .Include(a => a.Address)
// .Include(m => m.PropertyImg)
// join op in _context.OwnerProperty on p.Id equals op.PropertyId
// join po in _context.PropertyOwner on op.PropertyOwnerId equals po.Id
// select new PropertyDetailViewModel
// {
// PropertyName = p.PropertyName
// }
// );
var property = _context.Property
.Include(c => c.ManagementContract)
.Include(fe => fe.Feature)
.Include(fa => fa.Facility)
.Include(a => a.Address)
.Include(m => m.PropertyImg)
.Include(op => op.OwnerProperty)
.ThenInclude(po => po.PropertyOwner).ToList();
//return property.FirstOrDefault(p => p.Id == request.Id);
return(prop.FirstOrDefault(p => p.PropertyId == request.Id));
//throw new NotImplementedException();
}