public AnnualPlanStatusDto GetByMarketingYearId(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.AnnualPlanStatus annualPlan = db.AnnualPlanStatus.FirstOrDefault(x => x.MarketingYearId == marketingYearId);
return(annualPlan == null ? null : ToDto(annualPlan));
}
}
private AnnualPlanStatusDto ToDto(Entities.AnnualPlanStatus annualPlan)
{
var dto = new AnnualPlanStatusDto
{
Id = annualPlan.Id,
MarketingYearId = annualPlan.MarketingYearId,
Status = annualPlan.Status,
Description = annualPlan.Description,
TimeStamp = annualPlan.TimeStamp
};
return(dto);
}
public void Update(AnnualPlanStatusDto annualPlanStatusDto)
{
using (var db = new DbContext())
{
Entities.AnnualPlanStatus annualPlanStatus = db.AnnualPlanStatus.Single(x => x.Id == annualPlanStatusDto.Id);
annualPlanStatus.Status = annualPlanStatusDto.Status;
annualPlanStatus.Description = annualPlanStatusDto.Description;
annualPlanStatus.TimeStamp = annualPlanStatusDto.TimeStamp;
db.SaveChanges();
}
}
public void Insert(AnnualPlanStatusDto annualPlanStatusDto)
{
var entity = new Entities.AnnualPlanStatus
{
MarketingYearId = annualPlanStatusDto.MarketingYearId,
Status = annualPlanStatusDto.Status,
Description = annualPlanStatusDto.Description,
TimeStamp = annualPlanStatusDto.TimeStamp
};
using (var db = new DbContext())
{
db.AnnualPlanStatus.Add(entity);
db.SaveChanges();
}
}
