public ActionResult TenantViewPayments(int id)
{
//List<BGBC.Web.Models.TenantViewPayment> tenantViewPayment = new List<Models.TenantViewPayment>();
List <vRentPayment> rentpay = new List <vRentPayment>();
try
{
User tuser = _userRepository.Get(id);
Profile profile = tuser.Profiles.FirstOrDefault();
ViewBag.Name = tuser.FirstName + " " + tuser.LastName;
ViewBag.Address = profile.BillingAddress;
ViewBag.State = profile.BillingState;
ViewBag.City = profile.BillingCty;
ViewBag.Zip = profile.BillingZip;
rentpay = BGBCFunctions.RentPayments().Where(x => x.TenantUserID == id).ToList();
return(View(rentpay));
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return(View(new List <vRentPayment>()));
}
public ActionResult ViewPayments(int id)
{
List <BGBC.Web.Models.AllPropertiesAndTenant> allPropertiesAndTenant = new List <Models.AllPropertiesAndTenant>();
try
{
Property p = _propertyRepo.Get(id);
BGBC.Web.Models.AllPropertiesAndTenant propertiesTenant = new Models.AllPropertiesAndTenant();
ViewBag.PropertyID = p.PropertyID;
ViewBag.Name = p.Name;
ViewBag.Address = p.Address;
ViewBag.Address2 = p.Address2;
ViewBag.City = p.City;
ViewBag.State = p.State;
ViewBag.Zip = p.Zip;
propertiesTenant.tenantRentPay = new List <Models.TenantRentPay>();
foreach (var t in p.Tenants)
{
BGBC.Web.Models.TenantRentPay tenantRentPay = new BGBC.Web.Models.TenantRentPay();
tenantRentPay.tname = t.User.FirstName;
tenantRentPay.RentPayment = BGBCFunctions.RentPayments().Where(x => x.TenantUserID == t.User.UserID).ToList();
propertiesTenant.tenantRentPay.Add(tenantRentPay);
}
allPropertiesAndTenant.Add(propertiesTenant);
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return(View(allPropertiesAndTenant));
}
public ActionResult ViewPropertyPayment(int id)
{
List <vRentPayment> rentpay = new List <vRentPayment>();
try
{
// User user = _userRepository.Get(((BGBC.Core.CustomPrincipal)(User)).UserId);
Property property = _propertyRepo.Get(id);
ViewBag.PropertyID = property.PropertyID;
ViewBag.Name = property.Name;
rentpay = BGBCFunctions.RentPayments().Where(x => x.PropertyID == id).OrderByDescending(o => o.TransDate).ToList();
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return(View(rentpay));
}
public ActionResult ViewTenantsPayment(int id)
{
List <vRentPayment> rentpay = new List <vRentPayment>();
try
{
User tuser = _userRepository.Get(id);
Profile profile = tuser.Profiles.FirstOrDefault();
ViewBag.Name = tuser.FirstName + " " + tuser.LastName;
rentpay = BGBCFunctions.RentPayments().Where(x => x.TenantUserID == id).ToList();
return(View(rentpay));
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return(View(new List <vRentPayment>()));
}
public ActionResult TenantPaymentHistory(int?id)
{
IEnumerable <vRentPayment> paymentdetails = new List <vRentPayment>();
try
{
paymentdetails = BGBCFunctions.RentPayments()
.Where(x => x.TenantUserID == (id == null ? ((BGBC.Core.CustomPrincipal)(User)).UserId : id))
.OrderByDescending(d => d.TransDate).ToList();
Tenant tenants = _tenantRepo.Get().Where(x => x.UserID == (id == null ? ((BGBC.Core.CustomPrincipal)(User)).UserId : id)).FirstOrDefault();
ViewBag.Propertyname = (tenants != null ? tenants.Property.Name : "");
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return(View(paymentdetails));
}
public ActionResult PropertyPaymentsHistory(int id)
{
List <vRentPayment> rentpay = new List <vRentPayment>();
try
{
User user = _userRepository.Get(((BGBC.Core.CustomPrincipal)(User)).UserId);
Property property = _propertyRepo.Get((int)user.Properties.FirstOrDefault().PropertyID);
ViewBag.Address = property.Address;
ViewBag.Address2 = property.Address2;
ViewBag.City = property.City;
ViewBag.State = property.State;
ViewBag.Zip = property.Zip;
rentpay = BGBCFunctions.RentPayments().Where(x => x.PropertyID == id).ToList();
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return(View(rentpay));
}
public ActionResult AllPropertiesAndTenant()
{
List <BGBC.Web.Models.AllPropertiesAndTenant> allPropertiesAndTenant = new List <Models.AllPropertiesAndTenant>();
List <Property> property = _pro.GetRef(((BGBC.Core.CustomPrincipal)(User)).UserId);
foreach (var p in property)
{
BGBC.Web.Models.AllPropertiesAndTenant allProps = new Models.AllPropertiesAndTenant();
allProps.Pname = p.Name;
allProps.tenantRentPay = new List <Models.TenantRentPay>();
foreach (var t in p.Tenants)
{
BGBC.Web.Models.TenantRentPay tRentPay = new BGBC.Web.Models.TenantRentPay();
tRentPay.tname = t.User.FirstName + " " + t.User.LastName;
tRentPay.RentPayment = BGBCFunctions.RentPayments().Where(x => x.TenantUserID == t.User.UserID).OrderByDescending(d => d.TransDate).Take(5).ToList();
allProps.tenantRentPay.Add(tRentPay);
}
allPropertiesAndTenant.Add(allProps);
}
return(View(allPropertiesAndTenant));
}
public ActionResult PaymentHistory(string sortOrder, string currentFilter, string searchString, int?page, string pageSize, string searchOwner)
{
int currentPageSize = int.Parse(pageSize == null ? "10" : pageSize), pageNumber = (page ?? 1);
try
{
var rentPayments = BGBCFunctions.RentPayments();
ViewBag.currentSort = sortOrder;
ViewBag.dateSortParam = sortOrder == "date" ? "date_desc" : "date";
ViewBag.idSortParam = sortOrder == "id" ? "id_desc" : "id";
ViewBag.nameSortParam = sortOrder == "name" ? "name_desc" : "name";
ViewBag.ownerSortParam = sortOrder == "owner" ? "owner_desc" : "owner";
ViewBag.descSortParam = sortOrder == "desc" ? "desc_desc" : "desc";
ViewBag.amountSortParam = sortOrder == "amount" ? "amount_desc" : "amount";
ViewBag.commentSortParam = sortOrder == "comment" ? "comment_desc" : "comment";
if (pageSize != null)
{
ViewBag.currentPageSize = currentPageSize;
}
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.currentFilter = searchString;
ViewBag.page = pageNumber;
if (!string.IsNullOrEmpty(searchString))
{
rentPayments = rentPayments.Where(x => x.TenantLastName.Contains(searchString) || x.TenantFirstName.Contains(searchString) ||
x.OwnerFirstName.Contains(searchString) || x.OwnerLastName.Contains(searchString) ||
x.TransID.Contains(searchString));
// || x.Amount.Equals(searchString)|| x.TransDate.Equals(searchString));
}
if (!string.IsNullOrEmpty(searchOwner))
{
rentPayments = rentPayments.Where(x => x.OwnerFirstName.Contains(searchOwner));
ViewBag.currentFilterForDropdown = searchOwner;
}
switch (sortOrder)
{
case "date_desc":
rentPayments = rentPayments.OrderByDescending(x => x.TransDate);
break;
case "id":
rentPayments = rentPayments.OrderBy(x => x.ID);
break;
case "id_desc":
rentPayments = rentPayments.OrderByDescending(x => x.ID);
break;
case "name":
rentPayments = rentPayments.OrderBy(x => x.TenantFirstName);
break;
case "name_desc":
rentPayments = rentPayments.OrderByDescending(x => x.TenantFirstName);
break;
case "owner":
rentPayments = rentPayments.OrderBy(x => x.OwnerFirstName);
break;
case "owner_desc":
rentPayments = rentPayments.OrderByDescending(x => x.OwnerFirstName);
break;
case "desc":
rentPayments = rentPayments.OrderBy(x => x.Description);
break;
case "desc_desc":
rentPayments = rentPayments.OrderByDescending(x => x.Description);
break;
case "amount":
rentPayments = rentPayments.OrderBy(x => x.Amount);
break;
case "amount_desc":
rentPayments = rentPayments.OrderByDescending(x => x.Amount);
break;
case "comment":
rentPayments = rentPayments.OrderBy(x => x.Comments);
break;
case "comment_desc":
rentPayments = rentPayments.OrderByDescending(x => x.Comments);
break;
default:
rentPayments = rentPayments.OrderBy(x => x.TransDate);
break;
}
PropagateOwnerDropdown(ViewBag.currentFilterForDropdown);
return(View(rentPayments.ToPagedList(pageNumber, currentPageSize)));
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return(View(new List <vRentPayment>()));
}
