public void GetMaintenenceRequests(int propertyID)
{
using (var context = new LocalPropManageEntities())
{
var maintenceRequests = (from x in context.MaintenceRequests where x.PropertyID == propertyID select x).ToList();
dynamic MaintenceWrapper = new { allMaintenceRequest = maintenceRequests };
Context.Response.Write(JsonConvert.SerializeObject(MaintenceWrapper, Formatting.Indented));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (int.TryParse(Request.QueryString["propertyID"], out int propId))
{
using (var context = new LocalPropManageEntities())
{
Property prop = (from x in context.Properties
where x.PropertyID == propId
select x).FirstOrDefault();
if (prop != null)
{
//populate address
lblPropertyName.Text = prop.PropertyName;
lblPropertyAddress.Text = prop.PropertyAddress1;
lblPropertyPhone.Text = prop.Phone;
}
}
}
}
public void GetWorkOrders(int propertyID)
{
using (var context = new LocalPropManageEntities())
{
var WorkOrders = (from wo in context.WorkOrders
join u in context.Users on wo.ApprovedBy equals u.UserID
where wo.OrderFinished == null
where (from m in context.MaintenceRequests
where m.PropertyID == propertyID
select m.RequestID).Contains(wo.MaintenceRequestID)
select new { wo.WorkOrderID,
ApprovedBy = string.Concat(u.FirstName, " ", u.LastName),
wo.ApproveDate, wo.MaintenceRequestID, wo.CurrentStatus,
wo.Notes, wo.OrderStarted, wo.OrderFinished }
).ToList();
dynamic workOrdersWrapper = new { allWorkOrders = WorkOrders };
Context.Response.Write(JsonConvert.SerializeObject(workOrdersWrapper, Formatting.Indented));
}
}
public void GetResidents(int propertyID)
{
using (var context = new LocalPropManageEntities())
{
var residentResults = (from x in context.Residents
select new
{
x.ResidentID,
x.UnitID,
x.MoveInDate,
x.MoveOutDate,
x.FirstName,
x.LastName,
x.Email,
x.Phone,
x.Birthday,
x.MiddleName,
x.PropertyID
}
).ToList();
dynamic residentWrapper = new { allResidents = residentResults };
Context.Response.Write(JsonConvert.SerializeObject(residentWrapper, Formatting.Indented));
}
}
