public async Task <IActionResult> OnGetAsync(long?id)
{
if (id == null)
{
return(NotFound());
}
TownItem = await _context.Towns.SingleOrDefaultAsync(m => m.Id == id);
if (TownItem == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(long?id)
{
if (id == null)
{
return(NotFound());
}
TownItem = await _context.Towns.FindAsync(id);
if (TownItem != null)
{
_context.Towns.Remove(TownItem);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public TownDetailViewModel(TownItem town = null)
{
if (town == null)
{
return;
}
OriginalModel = town;
Id = town.Id;
Name = town.Name;
GroupCount = town.Groups.Count;
Groups = new List <GroupListViewModel>(); //town.Groups.Select(t => new GroupListViewModel(t)).ToList();
Drivers = new List <DriverListViewModel>(); //town.Drivers.Select(t => new DriverListViewModel(t)).ToList();
Vehicles = new List <VehicleListViewModel>(); //town.Groups.SelectMany(g => g.Vehicles).Select(t => new VehicleListViewModel(t)).ToList();
DriverCount = town.Drivers.Count;
VehicleCount = town.Vehicles.Count;
InvalidGroupCount = town.Groups.Count(t => !t.IsValid());
InvalidDriverCount = town.Drivers.Count(t => !t.IsValid());
InvalidVehicleCount = town.Vehicles.Count(t => !t.IsValid());
IsValid = (InvalidGroupCount <= 0) && (InvalidDriverCount <= 0) && (InvalidVehicleCount <= 0);
}
public bool Add(TownItem model)
{
StringBuilder str = new StringBuilder();
str.Append("insert into Town values(@code,@name)");
SqlParameter[] parameters =
{
new SqlParameter("@code", SqlDbType.NVarChar, 50),
new SqlParameter("@name", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Name;
int returnCount = int.Parse(SqlHelper.ExecteNonQuery(CommandType.Text, str.ToString(), parameters).ToString());
if (returnCount > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Add(TownItem model)
{
return(dal.Add(model));
}
