public async Task <IActionResult> Index(string SectorName, string SourceName, string Year, string Value) { CreationConfirmation confirmation = new CreationConfirmation(); confirmation.Heading = "New Record Successfully Created"; confirmation.WasSuccessful = true; try { Sector sector = _context.Sector.Where(s => s.SectorName == SectorName).First(); EnergySource energySource = _context.EnergySource.Where(e => e.SourceName == SourceName).First(); AnnualEnergyConsumption newRecord = new AnnualEnergyConsumption(); newRecord.sector = sector; newRecord.energysource = energySource; newRecord.Year = Convert.ToInt32(Year); newRecord.Value = Convert.ToDecimal(Value); _context.AnnualEnergyConsumption.Add(newRecord); await _context.SaveChangesAsync(); AnnualEnergyConsumption confirmRecord = _context.AnnualEnergyConsumption.Where(c => c.sector.SectorName == SectorName & c.energysource.SourceName == SourceName & c.Year == Convert.ToInt32(Year) & c.Value == Convert.ToDecimal(Value)).First(); confirmation.ConsumptionData = confirmRecord; } catch (Exception e) { confirmation.Heading = "Record Creation Failed"; confirmation.WasSuccessful = false; } return(View(confirmation)); }
public async Task <IActionResult> Index(string countyName, string popTypeName, int value) { CreationConfirmation confirmation = new CreationConfirmation(); confirmation.Heading = "New Record Successfully Created"; confirmation.WasSuccessful = true; try { //County county = dbContext.Counties.Where(c => c.CountyName == countyName).First(); //Population population = dbContext.Populations.Where(p => p.PopTypeName == popTypeName).First(); County places = new County { CountyName = countyName }; Population people = new Population { PopTypeName = popTypeName }; Demographic newRecord = new Demographic { Value = value, population = people, county = places }; //newRecord.county = county; //newRecord.population = population; //newRecord.Value = Convert.ToInt32(Value); //dbContext.Demographics.Add(newRecord); dbContext.Counties.Add(places); dbContext.Populations.Add(people); dbContext.Demographics.Add(newRecord); dbContext.SaveChanges(); Demographic confirmRecord = dbContext.Demographics.Where(d => d.county.CountyName == countyName & d.population.PopTypeName == popTypeName & d.Value == value).First(); confirmation.DemographicData = confirmRecord; } catch (Exception e) { confirmation.Heading = "Record Creation Failed"; confirmation.WasSuccessful = false; } return(View(confirmation)); }