public ActionResult Editar(PlanesViewModel plan, int[] Coberturas)
{
if (!ModelState.IsValid)
{
ViewBag.lista = this.ObtenerCoberturas();
ViewBag.listaCoberturasPlan = this.ObtenerCoberturasByPlan(plan.ID);
return(View(plan));
}
plan.Coberturas = Coberturas;
Services service = new Services();
var response = service.CallPost <PlanesViewModel>(plan, "https://localhost:44350/Planes/Editar", 15000);
if (response.ErrorCode != 0)
{
plan.MensajeError = response.ErrorDescription;
ViewBag.lista = this.ObtenerCoberturas();
ViewBag.listaCoberturasPlan = this.ObtenerCoberturasByPlan(plan.ID);
return(View(plan));
}
var json = service.Deserialize <Interfaz.Models.Request.Response>(response.Json);
if (json.IdError != 0)
{
plan.MensajeError = json.MessageError;
ViewBag.lista = this.ObtenerCoberturas();
ViewBag.listaCoberturasPlan = this.ObtenerCoberturasByPlan(plan.ID);
return(View(plan));
}
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Planes(PlanesViewModel model)
{
var PlaneDBOList = await _airplaneRepository.DisplayAllPlanes();
model.Planes = PlaneDBOList
.Select(PlaneDBO => new PlaneNameandPlaneID()
{
name = PlaneDBO.Name, PlaneID = PlaneDBO.PlaneID
})
.ToList();
return(RedirectToAction(nameof(Planes)));
}
public async Task <IActionResult> Planes()
{
var model = new PlanesViewModel();
var PlaneDBOList = await _airplaneRepository.DisplayAllPlanes();
model.Planes = PlaneDBOList
.Select(PlaneDBO => new PlaneNameandPlaneID()
{
name = PlaneDBO.Name, planeID = PlaneDBO.iatacode
})
.ToList();
return(View(model));
}
public async Task <IActionResult> Planes()
{
var model = new PlanesViewModel();
var PlaneDBOList = await _airplaneRepository.DisplayAllPlanes();
var specificUserPlanes = PlaneDBOList.Where(planeList => planeList.Email_Address == User.Identity.Name)
.ToList();
model.Planes = specificUserPlanes
.Select(PlaneDBO => new PlaneNameandPlaneID()
{
name = PlaneDBO.Name, PlaneID = PlaneDBO.PlaneID
})
.ToList();
return(View(model));
}
public async Task <PlanesViewModel> ObtenerPlan(int id)
{
var plan = new PlanesViewModel();
string cadenaConexion = ConfigurationManager.ConnectionStrings["Context"].ConnectionString;
using (var conexion = new SqlConnection(cadenaConexion))
{
conexion.Open();
var comando = new SqlCommand("ObtenerPlan", conexion);
comando.CommandType = System.Data.CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@ID", id);
var datos = await comando.ExecuteReaderAsync();
while (datos.Read())
{
plan.ID = int.Parse(datos["ID"].ToString());
plan.Descripcion = datos["Descripcion"].ToString();
plan.FechaModificacion = DateTime.Parse(datos["FechaModificacion"].ToString());
}
}
return(plan);
}
public async Task <Response> Editar([FromBody] PlanesViewModel planRequest)
{
planRequest.Descripcion = Utils.Utilidades.Formato(planRequest.Descripcion);
bool continuar = await new Repositorio.ConsultarPlanes().ValidarPlan(planRequest.Descripcion, planRequest.ID);
if (continuar)
{
return(new Response()
{
IdError = 1,
MessageError = string.Format("Ya existe el plan con nombre: {0}", planRequest.Descripcion)
});
}
var response = new Response();
int resultado = 0;
try
{
using (var contexto = new ContextDb())
{
var planes = await contexto.Planes.FirstOrDefaultAsync(x => x.ID.Equals(planRequest.ID));
planes.Descripcion = planRequest.Descripcion;
planes.FechaModificacion = DateTime.Now;
contexto.Entry(planes).State = System.Data.Entity.EntityState.Modified;
resultado = await contexto.SaveChangesAsync();
if (resultado > 0)
{
var listado = contexto.PlanesCobertura.Where(x => x.IDPlanes == planRequest.ID);
if (listado.Count() > 0)
{
contexto.PlanesCobertura.RemoveRange(listado);
resultado = await contexto.SaveChangesAsync();
}
if (planRequest.Coberturas != null && planRequest.Coberturas.Count() > 0)
{
foreach (var cobertura in planRequest.Coberturas)
{
contexto.PlanesCobertura.Add(new PlanesCobertura()
{
IDPlanes = planRequest.ID,
IDCoberturas = cobertura
});
}
resultado = await contexto.SaveChangesAsync();
}
}
else
{
response.MessageError = "Ocurrio un error al modificar plan";
}
}
if (resultado > 0)
{
response.IdError = 0;
}
else
{
response.IdError = 1;
response.MessageError = "Ocurrio un error al modificar las coberturas del plan";
}
}
catch (Exception error)
{
response.IdError = 2;
response.MessageError = error.Message;
}
return(response);
}
