public JsonResult GetHoses(int dispenserId)
{
DispenserEntity dispenser = _context.Dispensers
.Include(d => d.Hoses)
.FirstOrDefault(d => d.Id == dispenserId);
if (dispenser == null)
{
return(null);
}
List <HoseEntity> aux = dispenser.Hoses.ToList();
List <HoseEntity> disps = _context.MedTemps.Include(m => m.Hose).Select(t => new HoseEntity
{
Id = t.Hose.Id,
Number = t.Hose.Number,
Type = t.Hose.Type
}).ToList();
if (disps != null)
{
foreach (HoseEntity item in disps)
{
HoseEntity test = _context.Hoses.Find(item.Id);
aux.Remove(test);
}
}
JsonResult x = Json(aux.OrderBy(c => c.Number));
return(Json(aux.OrderBy(h => h.Number)));
}
public async Task <IActionResult> DeleteHose(int?id)
{
if (id == null)
{
return(NotFound());
}
HoseEntity hose = await _context.Hoses
.FirstOrDefaultAsync(m => m.Id == id);
if (hose == null)
{
return(NotFound());
}
DispenserEntity disp = _context.Dispensers
.Include(d => d.Hoses)
.Where(d => d.Hoses.Contains(hose))
.FirstOrDefault();
_context.Hoses.Remove(hose);
await _context.SaveChangesAsync();
return(RedirectToAction($"{nameof(DetailsDispenser)}/{disp.Id}"));
}
public async Task <IActionResult> AddHose(HoseEntity hose)
{
if (ModelState.IsValid)
{
DispenserEntity dispenser = await _context.Dispensers
.Include(c => c.Hoses)
.FirstOrDefaultAsync(c => c.Id == hose.IdDispenser);
if (dispenser == null)
{
return(NotFound());
}
switch (hose.Type)
{
case "1":
hose.Type = TypeFuel.Regular.ToString();
break;
case "0":
hose.Type = TypeFuel.Diesel.ToString();
break;
case "2":
hose.Type = TypeFuel.Super.ToString();
break;
case "3":
hose.Type = TypeFuel.Exonerado.ToString();
break;
}
try
{
hose.Id = 0;
dispenser.Hoses.Add(hose);
_context.Update(dispenser);
await _context.SaveChangesAsync();
return(RedirectToAction($"{nameof(DetailsDispenser)}/{dispenser.Id}"));
}
catch (DbUpdateException dbUpdateException)
{
if (dbUpdateException.InnerException.Message.Contains("duplicate"))
{
ModelState.AddModelError(string.Empty, "There are a record with the same name.");
}
else
{
ModelState.AddModelError(string.Empty, dbUpdateException.InnerException.Message);
}
}
catch (Exception exception)
{
ModelState.AddModelError(string.Empty, exception.Message);
}
}
return(View(hose));
}
public async Task <IActionResult> EditHose(int?id)
{
if (id == null)
{
return(NotFound());
}
HoseEntity hose = await _context.Hoses.FindAsync(id);
if (hose == null)
{
return(NotFound());
}
return(View(hose));
}
public async Task <IActionResult> AddHose(int?id)
{
if (id == null)
{
return(NotFound());
}
DispenserEntity dispenser = await _context.Dispensers.FindAsync(id);
if (dispenser == null)
{
return(NotFound());
}
HoseEntity model = new HoseEntity {
IdDispenser = dispenser.Id
};
return(View(model));
}