/// <summary>
/// Update the TIP status.
/// </summary>
/// <param name="model"></param>
public void UpdateTipStatus(DRCOG.Domain.Models.TipStatusModel model)
{
using (var db = new Models.TRIPSEntities())
{
var p = db.ProgramInstances.Single(pi => pi.TimePeriodID == model.TimePeriodId);
var tp = db.TimePeriods.Single(t => t.TimePeriodID == model.TimePeriodId);
var tpi = db.TIPProgramInstances.Single(pi => pi.TimePeriodID == model.TimePeriodId && pi.TIPProgramID == p.ProgramID);
//p.ClosingDate = ?
p.Current = model.IsCurrent;
p.Notes = model.Notes;
p.Pending = model.IsPending;
p.Previous = model.IsPrevious;
tpi.AdoptionDate = model.Adoption;
tpi.GovernorApprovalDate = model.GovernorApproval;
tpi.PublicHearingDate = model.PublicHearing;
tpi.ShowDelayDate = model.ShowDelayDate;
tpi.USDOTApprovalDate = model.USDOTApproval;
tpi.USEPAApprovalDate = model.EPAApproval;
var fs = new FundingIncrementSetter(db, tp);
fs.SetFundingIncrement(model.FundingIncrement_Year_1, "Year 1");
fs.SetFundingIncrement(model.FundingIncrement_Year_2, "Year 2");
fs.SetFundingIncrement(model.FundingIncrement_Year_3, "Year 3");
fs.SetFundingIncrement(model.FundingIncrement_Year_4, "Year 4");
fs.SetFundingIncrement(model.FundingIncrement_Year_5, "Year 5");
fs.SetFundingIncrement(model.FundingIncrement_Year_6, "Year 6");
fs.SetFundingIncrement(model.FundingIncrement_Years_4_6, "Years 4-6");
fs.SetFundingIncrement(model.FundingIncrement_Years_5_6, "Years 5-6");
db.SaveChanges();
}
}
/// <summary>
/// Get TIP Status
/// </summary>
/// <remarks>obsoletes TIP.GetStatus</remarks>
/// <param name="rtpYearId">ID of the RTP Plan Year</param>
/// <returns></returns>
public DRCOG.Domain.Models.TipStatusModel GetTipStatus(int rtpYearId)
{
var model = new DRCOG.Domain.Models.TipStatusModel();
using (var db = new Models.TRIPSEntities())
{
var p = db.ProgramInstances.Single(pi => pi.TimePeriodID == rtpYearId);
var tp = db.TimePeriods.Single(t => t.TimePeriodID == rtpYearId);
var tpi = db.TIPProgramInstances.Single(pi => pi.TimePeriodID == rtpYearId && pi.TIPProgramID == p.ProgramID);
model.Adoption = tpi.AdoptionDate;
model.EPAApproval = tpi.USEPAApprovalDate;
model.GovernorApproval = tpi.GovernorApprovalDate;
model.IsCurrent = p.Current.Value;
model.IsPending = p.Pending.Value;
model.IsPrevious = p.Previous.Value;
model.LastAmended = tpi.LastAmendmentDate;
model.Notes = p.Notes;
model.ProgramId = p.ProgramID;
model.PublicHearing = tpi.PublicHearingDate;
model.ShowDelayDate = tpi.ShowDelayDate;
model.TimePeriodId = tpi.TimePeriodID;
model.TipYear = tp.TimePeriod1;
model.USDOTApproval = tpi.USDOTApprovalDate;
foreach (var f in tp.FundingIncrements)
{
Logger.Debug("'" + f.FundingIncrement1 + "'");
}
var fs = new FundingIncrementSetter(db, tp);
model.FundingIncrement_Year_1 = fs.GetFundingIncrement("Year 1");
model.FundingIncrement_Year_2 = fs.GetFundingIncrement("Year 2");
model.FundingIncrement_Year_3 = fs.GetFundingIncrement("Year 3");
model.FundingIncrement_Year_4 = fs.GetFundingIncrement("Year 4");
model.FundingIncrement_Year_5 = fs.GetFundingIncrement("Year 5");
model.FundingIncrement_Year_6 = fs.GetFundingIncrement("Year 6");
model.FundingIncrement_Years_4_6 = fs.GetFundingIncrement("Years 4-6");
model.FundingIncrement_Years_5_6 = fs.GetFundingIncrement("Years 5-6");
}
return model;
}
