public static List <tbl_lease> GetExpiringLease(int?drpval, long?lid) { DateTime addsevendays = DateTime.Now.AddDays(7), addfourteendays = DateTime.Now.AddDays(14), addthirtydays = DateTime.Now.AddDays(30), addsixtydays = DateTime.Now.AddDays(60), addonetwntydays = DateTime.Now.AddDays(120); using (var dv = new dbrealestateEntities()) { // dv.Configuration.LazyLoadingEnabled = true; var cnt = dv.tbl_lease.Where(p => p.Property.Landlord_Id == lid).ToList(); if (drpval == 0) { cnt = cnt.Where(p => p.EndDate <= addthirtydays && p.Property.Landlord_Id == lid).ToList(); } else if (drpval == 1) { cnt = cnt.Where(p => p.EndDate <= addfourteendays && p.Property.Landlord_Id == lid).ToList(); } else if (drpval == 2) { cnt = cnt.Where(p => p.EndDate <= addsevendays && p.Property.Landlord_Id == lid).ToList(); } else if (drpval == 3) { cnt = cnt.Where(p => p.EndDate <= addsixtydays && p.Property.Landlord_Id == lid).ToList(); } else if (drpval == 120) { cnt = cnt.Where(p => p.EndDate <= addonetwntydays && p.Property.Landlord_Id == lid).ToList(); } return(cnt); }; }
public static List <tbl_offer> GetApprovedOfferslandlord(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.tbl_offer.Where(p => p.LandlordId == bid && p.Approval == 0).ToList(); return(cnt1); }; }
public static List <RequestView> GetApprovedRequestdlandlord(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.RequestViews.Where(p => p.LandlordId == bid && p.Approve == 0).ToList(); return(cnt1); }; }
public static List <RequestView> GetApprovedRequestd(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.RequestViews.Where(p => p.TenantId == bid && p.Approve != 0 && p.Approve != 4 && p.Approve != 3).ToList(); return(cnt1); }; }
public static tbl_lease getleasedata(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt = dv.tbl_lease.Where(p => p.Property_Id == bid).FirstOrDefault(); return(cnt); }; }
public static User getlandlordDataByEmail(string email) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.Users.Where(p => p.Email == email).FirstOrDefault(); return(cnt1); }; }
public static Tenant getTenantDetail(long?tenantId) { using (var dv = new dbrealestateEntities()) { var gtd = dv.Tenants.Where(p => p.Tenant_Id == tenantId).FirstOrDefault(); return(gtd); }; }
public static List <Deposit> GetPendingDepositReq(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.Deposits.Where(p => p.TenantId == bid && p.DepositApproval == 0).ToList(); return(cnt1); }; }
public static List <Deposit> GetPendingDepositReqlandlord(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.Deposits.Where(p => p.LandlordId == bid && p.DepositApproval != 0 && p.DepositApproval != 4 && p.DepositApproval != 3).ToList(); return(cnt1); }; }
public static List <Purposal> GetPendingProposals(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.Purposals.Where(p => p.TenantId == bid && p.Approval == 0).ToList(); return(cnt1); }; }
public static List <Purposal> GetPendingProposalslandlord(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.Purposals.Where(p => p.LandlordId == bid && p.Approval != 0 && p.Approval != 4 && p.Approval != 3).ToList(); return(cnt1); }; }
public static List <TenancyAgreement> gettenantagreementlandlord(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.TenancyAgreements.Where(p => p.LandlordId == bid && p.ApprovalStatus != 0 && p.ApprovalStatus != 4 && p.ApprovalStatus != 3).ToList(); return(cnt1); }; }
public static List <application_details> getpendingapplicationreqlandlord(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.application_details.Where(p => p.LandlordId == bid && p.Status != 0 && p.Status != 4 && p.Status != 3).ToList(); return(cnt1); }; }
public static List <application_details> getpendingapplicationreq(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.application_details.Where(p => p.TenantId == bid && p.Status == 0).ToList(); return(cnt1); }; }
public static List <Tenant> GetTenantList(long?lid) { using (var dv = new dbrealestateEntities()) { var cnt = dv.Tenants.Where(p => p.Property_Id == lid).ToList(); return(cnt); }; }
public static PropertyImage GetFirstImage(long?pid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.PropertyImages.Where(p => p.PropertyId == pid).FirstOrDefault(); return(cnt1); }; }
public static List <UserReportsPermission> GetReportPermissions(long?id) { using (var dv = new dbrealestateEntities()) { var cnt = dv.UserReportsPermissions.Where(p => p.UserId == id).ToList(); return(cnt); }; }
public static RequestView GetRequestViewing(long?pid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.RequestViews.Where(p => p.PropertyId == pid).FirstOrDefault(); return(cnt1); }; }
public static int GetPropertiesOfBuilding(int?bid) { using (var dv = new dbrealestateEntities()) { int cnt = dv.Properties.Where(p => p.BuildingId == bid).Count(); return(cnt); }; }
public static User getlandlordname(long?pid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.Users.Where(p => p.UserID == pid).FirstOrDefault(); return(cnt1); }; }
public static Tenant getTenantDataByEmail(string email) { using (var dv = new dbrealestateEntities()) { var gtd = dv.Tenants.Where(p => p.Email == email).FirstOrDefault(); return(gtd); }; }
public static Tenant gettenantname(long?pid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.Tenants.Where(p => p.Tenant_Id == pid).FirstOrDefault(); return(cnt1); }; }
public static List <Property> GetPropertiesData(int?bid) { using (var dv = new dbrealestateEntities()) { var cnt = dv.Properties.Where(p => p.BuildingId == bid).ToList(); return(cnt); }; }
public static FaultType getfaultname(int?pid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.FaultTypes.Where(p => p.FaultTypeId == pid).FirstOrDefault(); return(cnt1); }; }
public static Property getrequestpropdata(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.Properties.Where(p => p.Property_Id == bid).FirstOrDefault(); return(cnt1); }; }
public static tbl_offer GetOffer(long?pid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.tbl_offer.Where(p => p.PropertyId == pid).FirstOrDefault(); return(cnt1); }; }
public static List <Property> GetPropertiesList(long?lid) { using (var dv = new dbrealestateEntities()) { var cnt = dv.Properties.Where(p => p.Landlord_Id == lid).ToList(); return(cnt); }; }
public static List <ReportRole> GetReportNames() { using (var dv = new dbrealestateEntities()) { var cnt = dv.ReportRoles.ToList(); return(cnt); }; }
public static List <tbl_invoice> getinvoicedata(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.tbl_invoice.Where(p => p.LandlordId == bid).ToList(); return(cnt1); }; }
public static List <tbl_offer> GetApprovedOffers(long?bid) { using (var dv = new dbrealestateEntities()) { var cnt1 = dv.tbl_offer.Where(p => p.TenantId == bid && p.Approval != 0 && p.Approval != 4 && p.Approval != 3).ToList(); return(cnt1); }; }