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