// GET: PropertyManagement public ActionResult Index() { PropertyManagementVM model = new PropertyManagementVM(); model.UserAccount = db.UserAccounts.Where(u => u.UserName.Equals(User.Identity.Name.ToString())).FirstOrDefault(); return(View(model)); }
// GET: TrackRentDetail public ActionResult Index(int PropertyID, int TenantID) { var model = new PropertyManagementVM(); //To Find userid UserAccount usr = db.UserAccounts.Where(u => u.UserName.Equals(User.Identity.Name.ToString())).FirstOrDefault(); if (usr != null) { model.PropertyID = PropertyID; model.TenantID = TenantID; model.PropertyName = Convert.ToString(db.Properties.Where(x => x.PropertyID == PropertyID).Select(x => x.Title).FirstOrDefault()); model.TenantName = Convert.ToString(db.Tenants.Where(x => x.TenantID == TenantID).Select(x => x.TenantName).FirstOrDefault()); model.RentDetails = db.UserRentDetails.Where(e => e.UserID == usr.UserID).Where(e => e.PropertyID == PropertyID).Where(e => e.TenantID == TenantID).Select(e => e.RentDetail).ToList(); } return(View(model)); }
public ActionResult MyTenants(int?PropertyID, int?pageNo) { PopulatePropertyDropDownList(); var model = new PropertyManagementVM(); UserAccount usr = db.UserAccounts.Where(u => u.UserName.Equals(User.Identity.Name.ToString())).FirstOrDefault(); //Dropdown if (PropertyID.HasValue && PropertyID.Value > 0) { //model.Properties = db.UserTenants.Where(e => e.UserAccount.UserID == usr.UserID).Select(e => e.Property).ToList(); var tenantObj = db.UserTenants.Where(e => e.UserAccount.UserID == usr.UserID).Where(e => e.PropertyID == PropertyID).Select(e => e.Tenant).AsEnumerable(); int count = tenantObj.Count(); pageNo = pageNo ?? 1; var skipCount = (pageNo.Value - 1) * pageSize; tenantObj = tenantObj.OrderByDescending(x => x.TenantID).Skip(skipCount).Take(pageSize); model.Pager = new Pager(count, pageNo, pageSize); model.Tenants = tenantObj; } else { //model.Properties = db.UserTenants.Where(e => e.UserAccount.UserID == usr.UserID).Select(e => e.Property).ToList(); var tenantObj = db.UserTenants.Where(e => e.UserAccount.UserID == usr.UserID).Select(e => e.Tenant).AsEnumerable(); int count = tenantObj.Count(); pageNo = pageNo ?? 1; var skipCount = (pageNo.Value - 1) * pageSize; tenantObj = tenantObj.OrderByDescending(x => x.TenantID).Skip(skipCount).Take(pageSize); model.Pager = new Pager(count, pageNo, pageSize); model.Tenants = tenantObj; } model.PropertyID = PropertyID ?? default(int);; model.UserTenants = db.UserTenants; return(PartialView(model)); }
public ActionResult MyProperties(int?pageNo) { var model = new PropertyManagementVM(); UserAccount usr = db.UserAccounts.Where(u => u.UserName.Equals(User.Identity.Name.ToString())).FirstOrDefault(); if (usr != null) { var propertyObj = db.UserProperties.Where(e => e.UserAccount.UserID == usr.UserID).Select(e => e.Property).AsEnumerable(); int count = propertyObj.Count(); pageNo = pageNo ?? 1; var skipCount = (pageNo.Value - 1) * pageSize; propertyObj = propertyObj.OrderByDescending(x => x.PropertyID).Skip(skipCount).Take(pageSize); model.Pager = new Pager(count, pageNo, pageSize); model.Properties = propertyObj; } return(PartialView(model)); }