public async Task <IActionResult> Edit(int id, [Bind("EngId,EngName,BuildingId,FloorId,Rtp,Rtt")] FloorEngModel floorEngModel)
{
if (id != floorEngModel.EngId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(floorEngModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FloorEngModelExists(floorEngModel.EngId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["EngId"] = new SelectList(_context.AppUsers, "Id", "Email", floorEngModel.EngId);
ViewData["BuildingId"] = new SelectList(_context.Buildings, "BuildingId", "BuildingId", floorEngModel.BuildingId);
ViewData["BuildingId"] = new SelectList(_context.Floors, "BuildingId", "FloorId", floorEngModel.BuildingId);
return(View(floorEngModel));
}
public async Task <IActionResult> Create([Bind("EngId,EngName,BuildingId,FloorId,Rtp,Rtt")] FloorEngModel floorEngModel)
{
if (ModelState.IsValid)
{
_context.Add(floorEngModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["EngId"] = new SelectList(_context.AppUsers, "Id", "Email", floorEngModel.EngId);
ViewData["BuildingId"] = new SelectList(_context.Buildings, "BuildingId", "BuildingId", floorEngModel.BuildingId);
ViewData["BuildingId"] = new SelectList(_context.Floors, "BuildingId", "FloorId", floorEngModel.BuildingId);
return(View(floorEngModel));
}
public async Task <IActionResult> EditEngList(List <FloorEngListViewModel> data, string AsignEngId,
string QueryEngId, string QueryBuildingId)
{
// Get Login User's details.
var user = _userRepo.Find(u => u.UserName == this.User.Identity.Name).FirstOrDefault();
/* Target engineer ID. */
int asignEngId = Convert.ToInt32(AsignEngId);
/* Deal all input data. */
foreach (var item in data)
{
/* Create or edit the selected row data. */
if (item.IsSelected == true)
{
/* Insert values to floorEngModel to save or create. */
FloorEngModel floorEngModel = new FloorEngModel
{
EngId = asignEngId,
EngName = _context.AppUsers.Find(asignEngId).UserName,
BuildingId = item.BuildingId,
FloorId = item.FloorId,
Rtp = user.Id,
Rtt = DateTime.UtcNow.AddHours(08)
};
/* If data isn't in the database, create data.*/
if (item.EngId == null)
{
_context.Add(floorEngModel);
}
else
{
/* If data exist, find and delete odd data, then create a new one. */
int engId = item.EngId.GetValueOrDefault();
var originData = _context.FloorEngs.Find(engId, item.BuildingId, item.FloorId);
_context.FloorEngs.Remove(originData);
_context.FloorEngs.Add(floorEngModel);
}
}
}
await _context.SaveChangesAsync();
return(RedirectToAction("GetEditList", new { EngineerId = QueryEngId, BuildingId = QueryBuildingId }));
}