public ApplicantHistoryModel GetPreviousAddressInfoPV(int id, long UserID) { ShomaRMEntities db = new ShomaRMEntities(); ApplicantHistoryModel model = new ApplicantHistoryModel(); long ptoid = UserID; var getAHRdata = db.tbl_ApplicantHistory.Where(p => p.TenantID == id && p.ParentTOID == ptoid).OrderByDescending(s => s.AHID).FirstOrDefault(); if (getAHRdata != null) { DateTime?moveInFrom = null; try { moveInFrom = Convert.ToDateTime(getAHRdata.MoveInDateFrom); } catch { } DateTime?moveInTo = null; try { moveInTo = Convert.ToDateTime(getAHRdata.MoveInDateTo); } catch { } model.Country = getAHRdata.Country; model.HomeAddress1 = getAHRdata.HomeAddress1; model.HomeAddress2 = getAHRdata.HomeAddress2; model.StateHome = getAHRdata.StateHome; model.CityHome = getAHRdata.CityHome; model.ZipHome = getAHRdata.ZipHome; model.RentOwn = getAHRdata.RentOwn; model.MoveInDateFromTxt = moveInFrom == null ? "" : moveInFrom.Value.ToString("MM/dd/yyy"); model.MoveInDateToTxt = moveInTo == null ? "" : moveInTo.Value.ToString("MM/dd/yyy"); model.MonthlyPayment = !string.IsNullOrWhiteSpace(getAHRdata.MonthlyPayment) ? getAHRdata.MonthlyPayment : ""; model.Reason = !string.IsNullOrWhiteSpace(getAHRdata.Reason) ? getAHRdata.Reason : ""; var stateStr = db.tbl_State.Where(co => co.ID == getAHRdata.StateHome).FirstOrDefault(); model.StateString = stateStr.StateName; int ctryString = Convert.ToInt32(model.Country); var countryStr = db.tbl_Country.Where(co => co.ID == ctryString).FirstOrDefault(); model.CountryString = countryStr.CountryName; model.RentOwnString = model.RentOwn == 1 ? "Rent" : model.RentOwn == 2 ? "Own" : ""; model.ApartmentCommunity = !string.IsNullOrWhiteSpace(getAHRdata.ApartmentCommunity) ? getAHRdata.ApartmentCommunity : ""; model.ManagementCompany = !string.IsNullOrWhiteSpace(getAHRdata.ManagementCompany) ? getAHRdata.ManagementCompany : ""; model.ManagementCompanyPhone = !string.IsNullOrWhiteSpace(getAHRdata.ManagementCompanyPhone) ? getAHRdata.ManagementCompanyPhone : ""; model.IsProprNoticeLeaseAgreement = getAHRdata.IsProprNoticeLeaseAgreement; model.stringIsProprNoticeLeaseAgreement = model.IsProprNoticeLeaseAgreement == 1 ? "Yes" : "No"; } model.AHID = AHID; return(model); }
public ApplicantHistoryModel GetApplicantHistoryDetails(long AHID) { ShomaRMEntities db = new ShomaRMEntities(); ApplicantHistoryModel model = new ApplicantHistoryModel(); var getAHRdata = db.tbl_ApplicantHistory.Where(p => p.AHID == AHID).FirstOrDefault(); if (getAHRdata != null) { DateTime?moveInFrom = null; try { moveInFrom = Convert.ToDateTime(getAHRdata.MoveInDateFrom); } catch { } DateTime?moveInTo = null; try { moveInTo = Convert.ToDateTime(getAHRdata.MoveInDateTo); } catch { } model.Country = getAHRdata.Country; model.HomeAddress1 = getAHRdata.HomeAddress1; model.HomeAddress2 = getAHRdata.HomeAddress2; model.StateHome = getAHRdata.StateHome; model.CityHome = getAHRdata.CityHome; model.ZipHome = getAHRdata.ZipHome; model.RentOwn = getAHRdata.RentOwn; model.MoveInDateFromTxt = moveInFrom == null ? "" : moveInFrom.Value.ToString("MM/dd/yyy"); model.MoveInDateToTxt = moveInTo == null ? "" : moveInTo.Value.ToString("MM/dd/yyy"); model.MonthlyPayment = getAHRdata.MonthlyPayment; model.Reason = !string.IsNullOrWhiteSpace(getAHRdata.Reason) ? getAHRdata.Reason : ""; var stateStr = db.tbl_State.Where(co => co.ID == getAHRdata.StateHome).FirstOrDefault(); model.StateString = stateStr.StateName; int ctryString = Convert.ToInt32(model.Country); var countryStr = db.tbl_Country.Where(co => co.ID == ctryString).FirstOrDefault(); model.CountryString = countryStr.CountryName; model.RentOwnString = model.RentOwn == 1 ? "Rent" : model.RentOwn == 2 ? "Own" : ""; model.ApartmentCommunity = getAHRdata.ApartmentCommunity; model.ManagementCompany = getAHRdata.ManagementCompany; model.ManagementCompanyPhone = getAHRdata.ManagementCompanyPhone; model.IsProprNoticeLeaseAgreement = getAHRdata.IsProprNoticeLeaseAgreement; } model.AHID = AHID; return(model); }
public ApplicantHistoryModel GetMonthsFromApplicantHistory(long TenantId, string FromDateAppHis, string ToDateAppHis) { ShomaRMEntities db = new ShomaRMEntities(); ApplicantHistoryModel model = new ApplicantHistoryModel(); try { long ptoid = ShomaGroupWebSession.CurrentUser != null ? ShomaGroupWebSession.CurrentUser.UserID : 0; int monthsCount = 0; string fromDateDB = string.Empty; string toDateDB = string.Empty; var moveInApplHist = db.tbl_ApplicantHistory.Where(co => co.TenantID == TenantId && co.ParentTOID == ptoid).ToList(); if (moveInApplHist != null) { foreach (var item in moveInApplHist) { fromDateDB = Convert.ToString(item.MoveInDateFrom.Value.ToString("MM/dd/yyyy")); toDateDB = Convert.ToString(item.MoveInDateTo.Value.ToString("MM/dd/yyyy")); DateTime dtFromDB = Convert.ToDateTime(fromDateDB); DateTime dtToDB = Convert.ToDateTime(toDateDB); int givenDate = ((dtToDB.Year - dtFromDB.Year) * 12) + dtToDB.Month - dtFromDB.Month; monthsCount += givenDate + 1; } } DateTime dtCurrentFromDB = Convert.ToDateTime(FromDateAppHis); DateTime dtCurrentToDB = Convert.ToDateTime(ToDateAppHis); int givenCurrentDate = ((dtCurrentToDB.Year - dtCurrentFromDB.Year) * 12) + dtCurrentToDB.Month - dtCurrentFromDB.Month; monthsCount += givenCurrentDate + 1; model.TotalMonthsApplicantHistory = monthsCount; db.Dispose(); return(model); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }
public string SaveUpdateApplicantHistory(ApplicantHistoryModel model) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); int userid = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID : 0; if (model.AHID == 0) { var saveApplicantHistory = new tbl_ApplicantHistory() { Country = model.Country, HomeAddress1 = model.HomeAddress1, HomeAddress2 = model.HomeAddress2, StateHome = model.StateHome, CityHome = model.CityHome, ZipHome = model.ZipHome, RentOwn = model.RentOwn, MoveInDateFrom = model.MoveInDateFrom, MoveInDateTo = model.MoveInDateTo, MonthlyPayment = model.MonthlyPayment, Reason = model.Reason, TenantID = model.TenantID, ApartmentCommunity = model.ApartmentCommunity, ManagementCompany = model.ManagementCompany, ManagementCompanyPhone = model.ManagementCompanyPhone, IsProprNoticeLeaseAgreement = model.IsProprNoticeLeaseAgreement, ParentTOID = userid, }; db.tbl_ApplicantHistory.Add(saveApplicantHistory); db.SaveChanges(); msg = "Applicant History Saved Successfully"; } else { var getApplicantHistorydata = db.tbl_ApplicantHistory.Where(p => p.AHID == model.AHID).FirstOrDefault(); if (getApplicantHistorydata != null) { getApplicantHistorydata.Country = model.Country; getApplicantHistorydata.HomeAddress1 = model.HomeAddress1; getApplicantHistorydata.HomeAddress2 = model.HomeAddress2; getApplicantHistorydata.StateHome = model.StateHome; getApplicantHistorydata.CityHome = model.CityHome; getApplicantHistorydata.ZipHome = model.ZipHome; getApplicantHistorydata.RentOwn = model.RentOwn; getApplicantHistorydata.MoveInDateFrom = model.MoveInDateFrom; getApplicantHistorydata.MoveInDateTo = model.MoveInDateTo; getApplicantHistorydata.MonthlyPayment = model.MonthlyPayment; getApplicantHistorydata.Reason = model.Reason; getApplicantHistorydata.ApartmentCommunity = model.ApartmentCommunity; getApplicantHistorydata.ManagementCompany = model.ManagementCompany; getApplicantHistorydata.ManagementCompanyPhone = model.ManagementCompanyPhone; getApplicantHistorydata.IsProprNoticeLeaseAgreement = model.IsProprNoticeLeaseAgreement; } db.SaveChanges(); msg = "Applicant History Updated Successfully"; } db.Dispose(); return(msg); }