public void Delete(int marketingYearId) { using (var db = new DbContext()) { Entities.TrunkFoodPlan trunkFoodPlan = db.TrunkFoodPlan.Single(x => x.MarketingYearId == marketingYearId); db.TrunkFoodPlan.Remove(trunkFoodPlan); db.SaveChanges(); } }
private TrunkFoodPlanDto ToDto(Entities.TrunkFoodPlan entity) { var dto = new TrunkFoodPlanDto { Id = entity.Id, Hectare = entity.Hectare, MarketingYearId = entity.MarketingYearId }; return(dto); }
public void Update(TrunkFoodPlanDto dto) { using (var db = new DbContext()) { Entities.TrunkFoodPlan trunkFoodPlan = db.TrunkFoodPlan.Single(x => x.MarketingYearId == dto.MarketingYearId); trunkFoodPlan.Hectare = dto.Hectare; db.SaveChanges(); } }
public void Insert(TrunkFoodPlanDto dto) { var entity = new Entities.TrunkFoodPlan { Id = dto.Id, Hectare = dto.Hectare, MarketingYearId = dto.MarketingYearId }; using (var db = new DbContext()) { db.TrunkFoodPlan.Add(entity); db.SaveChanges(); } }
public TrunkFoodPlanDto GetByMarketingYear(int marketingYearId) { using (var db = new DbContext()) { Entities.TrunkFoodPlan trunkFoodPlan = db.TrunkFoodPlan.FirstOrDefault(x => x.MarketingYearId == marketingYearId); if (trunkFoodPlan == null) { return(null); } TrunkFoodPlanDto dtos = ToDto(trunkFoodPlan); return(dtos); } }