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);
}
