public List <MyAccountModel> GetTenantPetLeaseDocuments(MyAccountModel model) { ShomaRMEntities db = new ShomaRMEntities(); List <MyAccountModel> listPetCertificate = new List <MyAccountModel>(); var appNow = db.tbl_ApplyNow.Where(co => co.ID == model.UserId).FirstOrDefault(); if (appNow != null) { var getPetCertificates = db.tbl_TenantPet.Where(co => co.TenantID == appNow.ID).ToList(); if (getPetCertificates != null) { foreach (var item in getPetCertificates) { listPetCertificate.Add(new MyAccountModel() { PetPhotoDoc = item.Photo, OriginalPetPhotoDoc = item.OriginalPhoto, PetVaccinationDoc = item.PetVaccinationCert, OriginalPetVaccinationDoc = item.OriginalVaccinationCert }); } } } return(listPetCertificate); }
public MyAccountModel UploadProfile(HttpPostedFileBase fileBaseUpload, MyAccountModel model) { ShomaRMEntities db = new ShomaRMEntities(); MyAccountModel profilePic = new MyAccountModel(); string filePath = ""; string fileName = ""; string sysFileName = ""; string Extension = ""; if (fileBaseUpload != null && fileBaseUpload.ContentLength > 0) { filePath = HttpContext.Current.Server.MapPath("~/Content/assets/img/tenantProfile/"); DirectoryInfo di = new DirectoryInfo(filePath); FileInfo _FileInfo = new FileInfo(filePath); if (!di.Exists) { di.Create(); } fileName = fileBaseUpload.FileName; Extension = Path.GetExtension(fileBaseUpload.FileName); sysFileName = DateTime.Now.ToFileTime().ToString() + Path.GetExtension(fileBaseUpload.FileName); fileBaseUpload.SaveAs(filePath + "//" + sysFileName); if (!string.IsNullOrWhiteSpace(fileBaseUpload.FileName)) { string afileName = HttpContext.Current.Server.MapPath("~/Content/assets/img/tenantProfile/") + "/" + sysFileName; } profilePic.TempProfilePic = sysFileName.ToString(); profilePic.OriginalProfileFile = fileName; } return(profilePic); }
public MyAccountModel GetTenantLeaseDocuments(MyAccountModel model) { ShomaRMEntities db = new ShomaRMEntities(); var appNow = db.tbl_ApplyNow.Where(co => co.ID == model.UserId).FirstOrDefault(); if (appNow != null) { var getCertificates = db.tbl_TenantOnline.Where(co => co.ProspectID == appNow.ID).FirstOrDefault(); if (getCertificates != null) { model.EnvelopeID = appNow.EnvelopeID; model.EsignatureID = appNow.EsignatureID; model.PassportDoc = getCertificates.PassportDocument; model.OriginalPassportDoc = getCertificates.PassportDocumentOriginalFile; model.IdentityDoc = getCertificates.IdentityDocument; model.OriginalIdentityDoc = getCertificates.IdentityDocumentOriginalFile; model.TaxReturnDoc1 = getCertificates.TaxReturn; model.OriginalTaxReturnDoc1 = getCertificates.TaxReturnOrginalFile; model.TaxReturnDoc2 = getCertificates.TaxReturn2; model.OriginalTaxReturnDoc2 = getCertificates.TaxReturnOrginalFile2; model.TaxReturnDoc3 = getCertificates.TaxReturn3; model.OriginalTaxReturnDoc3 = getCertificates.TaxReturnOrginalFile3; } } return(model); }
public string UpdateWorkInfo(MyAccountModel model, long UserID) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); var tblTenant = db.tbl_TenantInfo.Where(p => p.TenantID == model.ID).FirstOrDefault(); if (tblTenant != null) { tbl_TenantInfo objTable = new tbl_TenantInfo(); tblTenant.TenantID = model.ID; tblTenant.JobTitle = model.JobTitle; tblTenant.JobType = Convert.ToInt32(model.JobType); tblTenant.EmployerName = model.EmployerName; db.SaveChanges(); } var getTenatId = db.tbl_ApplyNow.Where(co => co.UserId == UserID).FirstOrDefault(); var tblTInfo = db.tbl_TenantInfo.Where(p => p.ProspectID == getTenatId.ID).FirstOrDefault(); var tblTenantOnline = db.tbl_TenantOnline.Where(p => p.ProspectID == tblTInfo.ProspectID).FirstOrDefault(); if (tblTenantOnline != null) { tbl_TenantOnline objTable = new tbl_TenantOnline(); tblTenantOnline.JobTitle = model.JobTitle; tblTenantOnline.JobType = Convert.ToInt32(model.JobType); tblTenantOnline.EmployerName = model.EmployerName; db.SaveChanges(); } db.Dispose(); return(msg); }
public string UpdateContactInfo(MyAccountModel model, long UserId) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); var tblTenant = db.tbl_TenantInfo.Where(p => p.TenantID == model.ID).FirstOrDefault(); if (tblTenant != null) { tbl_TenantInfo objTable = new tbl_TenantInfo(); tblTenant.TenantID = model.ID; tblTenant.FirstName = model.FirstName; tblTenant.LastName = model.LastName; tblTenant.MiddleInitial = model.MiddleInitial; tblTenant.Mobile = model.Mobile; tblTenant.Email = model.Email; db.SaveChanges(); var applyNow = db.tbl_ApplyNow.Where(p => p.UserId == UserId).FirstOrDefault(); if (applyNow != null) { applyNow.FirstName = model.FirstName; applyNow.LastName = model.LastName; applyNow.Phone = model.Mobile; applyNow.Email = model.Email; } db.SaveChanges(); var loginDet = db.tbl_Login.Where(p => p.UserID == UserId).FirstOrDefault(); if (loginDet != null) { loginDet.FirstName = model.FirstName; loginDet.LastName = model.LastName; loginDet.Email = model.Email; loginDet.Username = model.Email; } db.SaveChanges(); var tenantOnline = db.tbl_TenantOnline.Where(p => p.ProspectID == tblTenant.ProspectID).FirstOrDefault(); if (tenantOnline != null) { tenantOnline.FirstName = model.FirstName; tenantOnline.LastName = model.LastName; tenantOnline.MiddleInitial = model.MiddleInitial; tenantOnline.Mobile = model.Mobile; tenantOnline.Email = model.Email; } db.SaveChanges(); } db.Dispose(); return(msg); }
public string UpdateEmContactInfo(MyAccountModel model, long UserId) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); var tblTenant = db.tbl_TenantInfo.Where(p => p.TenantID == model.ID).FirstOrDefault(); if (tblTenant != null) { tbl_TenantInfo objTable = new tbl_TenantInfo(); tblTenant.TenantID = model.ID; tblTenant.EmergencyFirstName = model.EmFirstNane; tblTenant.EmergencyLastName = model.EmLastName; tblTenant.EmergencyMobile = model.EmMobile; tblTenant.EmergencyWorkPhone = model.EmWorkPhone; tblTenant.EmergencyHomePhone = model.EmHomePhone; tblTenant.EmergencyAddress1 = model.EmAddress1; tblTenant.EmergencyAddress2 = model.EmAddress2; tblTenant.EmergencyEmail = model.EmEmail; tblTenant.Relationship = model.EmRelation; db.SaveChanges(); } var getTenatId = db.tbl_ApplyNow.Where(co => co.UserId == UserId).FirstOrDefault(); var tblTInfo = db.tbl_TenantInfo.Where(p => p.ProspectID == getTenatId.ID).FirstOrDefault(); var tblTenantOnline = db.tbl_TenantOnline.Where(p => p.ProspectID == tblTInfo.ProspectID).FirstOrDefault(); if (tblTenantOnline != null) { tbl_TenantOnline objTable = new tbl_TenantOnline(); tblTenantOnline.EmergencyFirstName = model.EmFirstNane; tblTenantOnline.EmergencyLastName = model.EmLastName; tblTenantOnline.EmergencyMobile = model.EmMobile; tblTenantOnline.EmergencyWorkPhone = model.EmWorkPhone; tblTenantOnline.EmergencyHomePhone = model.EmHomePhone; tblTenantOnline.EmergencyAddress1 = model.EmAddress1; tblTenantOnline.EmergencyAddress2 = model.EmAddress2; tblTenantOnline.EmergencyEmail = model.EmEmail; tblTenantOnline.Relationship = model.EmRelation; db.SaveChanges(); } db.Dispose(); return(msg); }
public string SaveProfilePic(MyAccountModel model) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); var tblTenant = db.tbl_TenantInfo.Where(p => p.TenantID == model.ID).FirstOrDefault(); if (tblTenant != null) { tbl_TenantInfo objTable = new tbl_TenantInfo(); tblTenant.TenantID = model.ID; tblTenant.ProfilePicture = model.TempProfilePic; tblTenant.OrginalProfilePicture = model.OriginalProfileFile; db.SaveChanges(); } db.Dispose(); return(msg); }
public MyAccountModel GetTenantDetails(long TenantID) { ShomaRMEntities db = new ShomaRMEntities(); MyAccountModel model = new MyAccountModel(); var tenantData = db.tbl_TenantInfo.Where(p => p.TenantID == TenantID).FirstOrDefault(); ClearAllFields(model); if (tenantData != null) { DateTime?dob = null; try { dob = Convert.ToDateTime(tenantData.DateOfBirth.ToString()); } catch { } model.ID = tenantData.TenantID; model.ProspectID = Convert.ToInt64((tenantData.ProspectID).ToString()); model.FirstName = tenantData.FirstName; model.MiddleInitial = tenantData.MiddleInitial; model.LastName = tenantData.LastName; model.Mobile = tenantData.Mobile; model.Email = tenantData.Email; model.EmFirstNane = tenantData.EmergencyFirstName != null ? tenantData.EmergencyFirstName : ""; // model.EmMiddleName = tenantData.EmergencyLastName; model.EmLastName = tenantData.EmergencyLastName != null ? tenantData.EmergencyLastName : ""; model.EmEmail = tenantData.EmergencyEmail != null ? tenantData.EmergencyEmail : ""; model.EmMobile = tenantData.EmergencyMobile != null ? tenantData.EmergencyMobile : ""; model.EmWorkPhone = tenantData.EmergencyWorkPhone != null ? tenantData.EmergencyWorkPhone : ""; model.EmHomePhone = tenantData.EmergencyHomePhone != null ? tenantData.EmergencyHomePhone : ""; model.EmRelation = tenantData.Relationship != null ? tenantData.Relationship : ""; model.EmAddress1 = tenantData.EmergencyAddress1 != null ? tenantData.EmergencyAddress1 : ""; model.EmAddress2 = tenantData.EmergencyAddress2 != null ? tenantData.EmergencyAddress2 : ""; model.EmployerName = tenantData.EmployerName != null ? tenantData.EmployerName : ""; model.JobTitle = tenantData.JobTitle != null ? tenantData.JobTitle : ""; model.JobTypeString = tenantData.JobType == 1 ? "Permanent" : tenantData.JobType == 2 ? "Contract Basis" : ""; model.JobType = tenantData.JobType; model.OriginalProfileFile = tenantData.OrginalProfilePicture; model.TempProfilePic = tenantData.ProfilePicture; } db.Dispose(); return(model); }
public MyAccountModel CheckTenantPet(long TenantID) { ShomaRMEntities db = new ShomaRMEntities(); MyAccountModel model = new MyAccountModel(); var tenantData = db.tbl_TenantInfo.Where(p => p.TenantID == TenantID).FirstOrDefault(); if (tenantData != null) { model.HavePet = tenantData.HavePet; if (tenantData.HavePet != true) { // var petstorage = db.tbl_ApplyNow.Where(p => p.tena == TenantID).FirstOrDefault(); } } db.Dispose(); return(model); }
private void ClearAllFields(MyAccountModel model) { model.ID = 0; model.LastName = ""; model.FirstName = ""; model.PropertyID = 0; model.UnitID = 0; model.Address = ""; model.City = ""; model.State = 0; model.Zip = ""; model.HomePhone = ""; model.OfficeEmail = ""; model.OfficePhone = ""; model.OfficeName = ""; model.OfficeAddress = ""; model.OfficeCity = ""; model.OfficeState = 0; model.OfficeZip = ""; model.Occupation = ""; model.SocialSecurityNum = ""; model.DriverLicense = ""; model.DateOfBirth = null; model.CarMake = ""; model.CarModel = ""; model.CarLic = ""; model.EmergencyContact = ""; model.EmergencyPhone = ""; model.RentResp = 0; model.Income = 0; model.EmployerContact = ""; model.OfficePhoneExtension = ""; model.JobCode = ""; model.MiddleInitial = ""; model.Gender = 0; model.MaritalStatus = 0; model.StudentStatus = 0; }
public MyAccountModel GetTenantInfo(long TenantID, long UserId) { ShomaRMEntities db = new ShomaRMEntities(); MyAccountModel model = new MyAccountModel(); var tenantData = db.tbl_TenantInfo.Where(p => p.TenantID == TenantID).FirstOrDefault(); // ClearAllFields(model); if (tenantData != null) { DateTime?dob = null; try { dob = Convert.ToDateTime(tenantData.DateOfBirth.ToString()); } catch { } model.ID = tenantData.TenantID; model.LastName = tenantData.LastName; model.FirstName = tenantData.FirstName; model.PropertyID = tenantData.PropertyID; model.UnitID = tenantData.UnitID; model.MiddleInitial = tenantData.MiddleInitial; var unitname = db.tbl_PropertyUnits.Where(u => u.UID == model.UnitID).FirstOrDefault(); if (unitname != null) { model.UnitName = unitname.UnitNo; } //var getTenantDet = db.tbl_ApplyNow.Where(p => p.UserId == UserId).FirstOrDefault(); //model.LeaseTerm = getTenantDet.LeaseTerm; var monthlyRent = db.tbl_TenantMonthlyPayments.Where(p => p.TenantID == TenantID).FirstOrDefault(); model.MonthlyCharges = Convert.ToDecimal(monthlyRent.Charge_Amount); } db.Dispose(); return(model); }
public List <MyAccountModel> GetTenantVehicleLeaseDocuments(MyAccountModel model) { ShomaRMEntities db = new ShomaRMEntities(); List <MyAccountModel> listVehicleCertificate = new List <MyAccountModel>(); var appNow = db.tbl_ApplyNow.Where(co => co.ID == model.UserId).FirstOrDefault(); if (appNow != null) { var getVehicleCertificates = db.tbl_Vehicle.Where(co => co.TenantID == appNow.ID).ToList(); if (getVehicleCertificates != null) { foreach (var item in getVehicleCertificates) { listVehicleCertificate.Add(new MyAccountModel() { VehicleRegistrationDoc = item.VehicleRegistration, OriginalVehicleRegistrationDoc = item.OriginalVehicleReg }); } } } return(listVehicleCertificate); }
public long SaveUpdateTenant(MyAccountModel model) { ShomaRMEntities db = new ShomaRMEntities(); var tblTenant = db.tbl_Tenant.Where(p => p.ID == model.ID).FirstOrDefault(); if (tblTenant == null) { tbl_Tenant objTable = new tbl_Tenant(); objTable.ID = model.ID; objTable.LastName = model.LastName; objTable.FirstName = model.FirstName; objTable.PropertyID = model.PropertyID; objTable.UnitID = model.UnitID; objTable.Address = model.Address; objTable.City = model.City; objTable.State = model.State; objTable.Zip = model.Zip; objTable.HomePhone = model.HomePhone; objTable.OfficeEmail = model.OfficeEmail; objTable.OfficePhone = model.OfficePhone; objTable.OfficeName = model.OfficeName; objTable.OfficeAddress = model.OfficeAddress; objTable.OfficeCity = model.OfficeCity; objTable.OfficeState = model.OfficeState; objTable.OfficeZip = model.OfficeZip; objTable.Occupation = model.Occupation; objTable.SocialSecurityNum = model.SocialSecurityNum; objTable.DriverLicense = model.DriverLicense; objTable.DateOfBirth = model.DateOfBirth; objTable.CarMake = model.CarMake; objTable.CarModel = model.CarModel; objTable.CarLic = model.CarLic; objTable.EmergencyContact = model.EmergencyContact; objTable.EmergencyPhone = model.EmergencyPhone; objTable.RentResp = model.RentResp; objTable.Income = model.Income; objTable.EmployerContact = model.EmployerContact; objTable.OfficePhoneExtension = model.OfficePhoneExtension; objTable.JobCode = model.JobCode; objTable.MiddleInitial = model.MiddleInitial; objTable.Gender = model.Gender; objTable.MaritalStatus = model.MaritalStatus; objTable.StudentStatus = model.StudentStatus; objTable.CreatedBy = 1; objTable.CreatedDate = DateTime.Now; objTable.LastModifiedBy = Convert.ToInt32(ShomaRM.Models.ShomaGroupWebSession.CurrentUser); objTable.LastModifiedeDate = DateTime.Now; db.tbl_Tenant.Add(objTable); db.SaveChanges(); // model.ID = objTable.ID; } else { tblTenant.ID = model.ID; tblTenant.LastName = model.LastName; tblTenant.FirstName = model.FirstName; tblTenant.PropertyID = model.PropertyID; tblTenant.UnitID = model.UnitID; tblTenant.Address = model.Address; tblTenant.City = model.City; tblTenant.State = model.State; tblTenant.Zip = model.Zip; tblTenant.HomePhone = model.HomePhone; tblTenant.OfficeEmail = model.OfficeEmail; tblTenant.OfficePhone = model.OfficePhone; tblTenant.OfficeName = model.OfficeName; tblTenant.OfficeAddress = model.OfficeAddress; tblTenant.OfficeCity = model.OfficeCity; tblTenant.OfficeState = model.OfficeState; tblTenant.OfficeZip = model.OfficeZip; tblTenant.Occupation = model.Occupation; tblTenant.SocialSecurityNum = model.SocialSecurityNum; tblTenant.DriverLicense = model.DriverLicense; tblTenant.DateOfBirth = model.DateOfBirth; tblTenant.CarMake = model.CarMake; tblTenant.CarModel = model.CarModel; tblTenant.CarLic = model.CarLic; tblTenant.EmergencyContact = model.EmergencyContact; tblTenant.EmergencyPhone = model.EmergencyPhone; tblTenant.RentResp = model.RentResp; tblTenant.Income = model.Income; tblTenant.EmployerContact = model.EmployerContact; tblTenant.OfficePhoneExtension = model.OfficePhoneExtension; tblTenant.JobCode = model.JobCode; tblTenant.MiddleInitial = model.MiddleInitial; tblTenant.Gender = model.Gender; tblTenant.MaritalStatus = model.MaritalStatus; tblTenant.StudentStatus = model.StudentStatus; tblTenant.LastModifiedBy = 1; tblTenant.LastModifiedeDate = DateTime.Now; db.SaveChanges(); } db.Dispose(); return(model.ID); }