public async Task UpdateRecordAsync()
{
var client = new HetznerDnsClient(this._apiKey);
var zoneResponse = await client.GetZonesAsync();
Assert.IsNotNull(zoneResponse);
var zoneId = zoneResponse.Zones.FirstOrDefault()?.Id;
var createRecord = new CreateRecord
{
ZoneId = zoneId,
Name = "_acme-challenge.unittest",
Type = DnsRecordType.TXT,
Value = "testest",
Ttl = 0
};
var createdRecord = await client.CreateRecordAsync(createRecord);
Assert.IsNotNull(createdRecord);
var updateRecord = new UpdateRecord
{
ZoneId = createRecord.ZoneId,
Type = DnsRecordType.TXT,
Name = createRecord.Name,
Value = "update-record",
Ttl = 10,
};
var updatedRecord = await client.UpdateRecordAsync(createdRecord.Id, updateRecord);
Assert.IsNotNull(updatedRecord);
}
public async Task <IActionResult> Index(string sector, string source, int year, Decimal?value, string?valueStr)
{
AnnualEnergyConsumption modRecord = _context.AnnualEnergyConsumption
.Where(t => t.sector.SectorName == sector & t.energysource.SourceName == source & t.Year == year)
.First();
if (modRecord.Value == value)
{
UpdateRecord updRecord = new UpdateRecord();
updRecord.Sector = sector;
updRecord.Source = source;
updRecord.Year = year;
updRecord.Value = (Decimal)value;
updRecord.origValue = value;
return(View(updRecord));
}
else
{
modRecord.Value = Convert.ToDecimal(valueStr);
_context.AnnualEnergyConsumption.Update(modRecord);
await _context.SaveChangesAsync();
UpdateRecord updRecord = new UpdateRecord();
updRecord.Sector = sector;
updRecord.Source = source;
updRecord.Year = year;
updRecord.Value = _context.AnnualEnergyConsumption
.Where(t => t.sector.SectorName == sector & t.energysource.SourceName == source & t.Year == year)
.Select(v => v.Value)
.First();
updRecord.origValue = value;
return(View(updRecord));
}
}
public async Task <IActionResult> Index(string county, string population, int?value, string?valueStr)
{
Demographic modRecord = dbContext.Demographics
.Where(d => d.county.CountyName == county & d.population.PopTypeName == population)
.First();
if (modRecord.Value == value)
{
UpdateRecord updRecord = new UpdateRecord();
updRecord.County = county;
updRecord.Population = population;
updRecord.Value = (int)value;
updRecord.origValue = value;
return(View(updRecord));
}
else
{
modRecord.Value = Convert.ToInt32(valueStr);
dbContext.Demographics.Update(modRecord);
await dbContext.SaveChangesAsync();
UpdateRecord updRecord = new UpdateRecord();
updRecord.County = county;
updRecord.Population = population;
updRecord.Value = dbContext.Demographics
.Where(d => d.county.CountyName == county & d.population.PopTypeName == population)
.Select(v => v.Value)
.First();
updRecord.origValue = value;
return(View(updRecord));
}
}
public ActionResult SavEdit(Building building, bool IsCreate)
{
if (Session["admin"] != null)
{
building.CreateTime = DateTime.Now.ToString("yyyy-MM-dd");
building.BuildingIndex = ToSmall(building.BuildingIndex);
string[] pics = building.BuildingPics.Substring(0, building.BuildingPics.Length - 1).Split(' ');
StringBuilder sb = new StringBuilder();
foreach (var pic in pics)
{
sb.Append(ToSmall(pic));
sb.Append(" ");
}
building.BuildingPics = sb.ToString();
if (IsCreate)
{
/////////////////////////////////////////////////////////////////////////////////
building.CompanyId = getSession.CompanyId;
building.CreateUserId = getSession.AdminId;
/////////////////////////////////////////////////////////////////////////////////
db.Entry(building).State = EntityState.Modified;
}
else
{
building.CompanyId = getSession.CompanyId;
building.CreateUserId = getSession.AdminId;
db.Building.Add(building);
}
db.SaveChanges();
string buildingId = building.Id.ToString();
UpdateRecord record = db.UpdateRecord.Where(item => item.BuildingId == buildingId).FirstOrDefault();
if (record != null)
{
record.UpdateTime = DateTime.Now;
db.Entry(record).State = EntityState.Modified;
}
else
{
record = new UpdateRecord();
record.BuildingId = buildingId;
record.UpdateTime = DateTime.Now;
db.UpdateRecord.Add(record);
}
db.SaveChanges();
return(RedirectToAction("List"));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
