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