public ActionResult Edit([Bind(Include = "Id,ActaId,LiberationPlaceId,NroLiberacion,FechaDeLiberacion,NroJuzgado,FechaCarga,Convenio,Cuotas,Acarreo,NroRecibo,Importe,MontoEnCuotas,FechaEmisionRecibo,Enable,UsuarioId,Person,PersonId")] Liberation liberation)
{
if (ModelState.IsValid)
{
liberation.Person.Nombre = liberation.Person.Nombre?.ToUpper();
liberation.Person.Altura = liberation.Person.Altura?.ToUpper();
liberation.Person.Apellido = liberation.Person.Apellido?.ToUpper();
liberation.Person.EntreCalle = liberation.Person.EntreCalle?.ToUpper();
liberation.Person.Partido = liberation.Person.Partido?.ToUpper();
liberation.Person.Barrio = liberation.Person.Barrio?.ToUpper();
liberation.Person.Calle = liberation.Person.Calle?.ToUpper();
liberation.Person.Id = liberation.PersonId;
liberation.Acta = db.Acts.Find(liberation.ActaId);
db.Entry(liberation).State = EntityState.Modified;
db.Entry(liberation.Acta).State = EntityState.Modified;
db.Entry(liberation.Person).State = EntityState.Modified;
db.SaveChanges();
TempData["message"] = "Los cambios se han grabado correctamente.";
//Audito
AuditHelper.Auditar("Modificacion", liberation.Id.ToString(), "Liberations", ModuleDescription, WindowDescription);
return(RedirectToAction("Index", "Acts"));
}
return(RedirectToAction("Index", "Acts"));
}
// GET: Liberations/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
TempData["message"] = "Lo sentimos! No se encontro la liberación";
return(RedirectToAction("Index", "Acts"));
}
Act act = db.Acts.Find(id);
Liberation liberation = db.Liberations.Where(x => x.ActaId == act.Id).FirstOrDefault();
if (liberation == null)
{
TempData["message"] = "Lo sentimos! No se encontro la liberación";
return(RedirectToAction("Index", "Acts"));
}
ViewBag.listaLiberationPlace = new List <LiberationPlace>(db.LiberationPlaces.ToList().Where(x => x.Enable == true).ToList());
ViewBag.listaTipos = new List <VehicleType>(db.VehicleTypes.ToList().Where(x => x.Enable == true).ToList());
ViewBag.listaMarcas = new List <VehicleBrand>(db.VehicleBrands.ToList().Where(x => x.Enable == true).ToList());
ViewBag.listaModelos = new List <VehicleModel>(db.VehicleModels.ToList().Where(x => x.Enable == true).ToList());
ViewBag.listaDominios = new List <Domain>(db.Domains.ToList());
ViewBag.ActaId = liberation.ActaId;
ViewBag.PersonId = liberation.PersonId;
ViewBag.Id = liberation.Id;
ViewBag.listaCalles = GetCalles();
ViewBag.listaBarrios = GetBarrios();
return(View(liberation));
}
// GET: Liberations/Create
public ActionResult Create(int?id)
{
Liberation liberation = new Liberation();
liberation.Acta = new Act();
liberation.Acta = db.Acts.Find(id);
liberation.Person = db.People.Where(x => x.DNI == liberation.Acta.DNI).FirstOrDefault();
if (liberation.Person == null)
{
liberation.Person = new Person();
liberation.Person.DNI = liberation.Acta.DNI;
liberation.Person.Apellido = liberation.Acta.Apellido;
liberation.Person.Nombre = liberation.Acta.Nombre;
ViewBag.PersonId = null;
}
else
{
ViewBag.PersonId = liberation.Person.Id;
}
ViewBag.listaLiberationPlace = new List <LiberationPlace>(db.LiberationPlaces.ToList().Where(x => x.Enable == true).ToList());
ViewBag.listaTipos = new List <VehicleType>(db.VehicleTypes.ToList().Where(x => x.Enable == true).ToList());
ViewBag.listaMarcas = new List <VehicleBrand>(db.VehicleBrands.ToList().Where(x => x.Enable == true).ToList());
ViewBag.listaModelos = new List <VehicleModel>(db.VehicleModels.ToList().Where(x => x.Enable == true).ToList());
ViewBag.listaDominios = new List <Domain>(db.Domains.ToList());
ViewBag.ActaId = id;
ViewBag.listaCalles = GetCalles();
ViewBag.listaBarrios = GetBarrios();
return(View(liberation));
}
public ActionResult DeleteConfirmed(int id)
{
Liberation liberation = db.Liberations.Find(id);
db.Liberations.Remove(liberation);
db.SaveChanges();
//Audito
AuditHelper.Auditar("Baja", liberation.Id.ToString(), "Liberations", ModuleDescription, WindowDescription);
return(RedirectToAction("Index"));
}
// GET: Liberations/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Liberation liberation = db.Liberations.Find(id);
if (liberation == null)
{
return(HttpNotFound());
}
return(View(liberation));
}
private List <ActIndexViewModel> GetActIndexFiltrado()
{
try
{
var lista = db.Acts.Where(x => x.Enable == true).Select(c => new { c.Id, c.FechaCarga, c.FechaInfraccion, c.NroActa, c.Dominio, c.EstadoVehiculo, c.DNI, c.Nombre, c.Apellido }).OrderByDescending(x => x.FechaInfraccion).OrderByDescending(x => x.FechaCarga).Take(1000);
;
List <ActIndexViewModel> acts = new List <ActIndexViewModel>();
var liberations = db.Liberations.Where(x => x.Enable == true).ToList();
foreach (var item in lista)
{
ActIndexViewModel act = new ActIndexViewModel();
Liberation liberation = new Liberation();
//Busco si tiene un liberacion
liberation = liberations.Where(x => x.ActaId == item.Id).FirstOrDefault();
act.Id = item.Id;
act.NroActa = item.NroActa;
if (liberation != null)
{
act.NroLiberacion = liberation.NroLiberacion;
}
act.Apellido = item.Apellido;
act.DNI = item.DNI;
act.Dominio = item.Dominio;
act.Estado = item.EstadoVehiculo;
act.FechaCarga = item.FechaCarga;
act.FechaInfraccion = item.FechaInfraccion;
acts.Add(act);
}
return(acts);
}
catch (Exception e)
{
throw;
}
}
public ActionResult Create([Bind(Include = "ActaId,LiberationPlaceId,NroLiberacion,FechaDeLiberacion,NroJuzgado,FechaCarga,Convenio,Cuotas,Acarreo,NroRecibo,Importe,MontoEnCuotas,FechaEmisionRecibo,Enable,UsuarioId,Person,PersonId")] Liberation liberation)
{
ModelState.Remove("PersonId");
if (ModelState.IsValid)
{
liberation.Enable = true;
if (liberation.PersonId != 0)
{
if (liberation.Person != null)
{
liberation.Person.Id = liberation.PersonId;
db.Entry(liberation.Person).State = EntityState.Modified;
}
}
Act act = db.Acts.Find(liberation.ActaId);
liberation.Person.Nombre = liberation.Person.Nombre?.ToUpper();
liberation.Person.Altura = liberation.Person.Altura?.ToUpper();
liberation.Person.Apellido = liberation.Person.Apellido?.ToUpper();
liberation.Person.EntreCalle = liberation.Person.EntreCalle?.ToUpper();
liberation.Person.Partido = liberation.Person.Partido?.ToUpper();
liberation.Person.Barrio = liberation.Person.Barrio?.ToUpper();
liberation.Person.Calle = liberation.Person.Calle?.ToUpper();
act.FechaEstado = DateTime.Now;
act.EstadoVehiculo = "Liberado";
db.Liberations.Add(liberation);
db.Entry(act).State = EntityState.Modified;
db.SaveChanges();
TempData["message"] = "Los cambios se han grabado correctamente.";
//Audito
AuditHelper.Auditar("Alta", liberation.Id.ToString(), "Liberations", ModuleDescription, WindowDescription);
return(RedirectToAction("Index", "Acts"));
}
return(RedirectToAction("Index", "Acts"));
}
private List <ActIndexViewModel> ArmarConsulta(string NroActa, string NroLiberacion, string Estado, string DNI, string Apellido, string Dominio, string FechaDesde, string FechaHasta)
{
List <ActIndexViewModel> acts = new List <ActIndexViewModel>();
DateTime?dtFechaDesde = null;
DateTime?dtFechaHasta = null;
if (!String.IsNullOrEmpty(FechaDesde))
{
dtFechaDesde = Convert.ToDateTime(FechaDesde);
}
if (!String.IsNullOrEmpty(FechaHasta))
{
dtFechaHasta = Convert.ToDateTime(FechaHasta);
}
try
{
List <Liberation> liberationsList = new List <Liberation>();
var lista = db.Acts
.Where(x => x.Enable == true)
.Where(x => !string.IsNullOrEmpty(NroActa) ? (x.NroActa == NroActa && x.NroActa != null) : true)
.Where(x => !string.IsNullOrEmpty(Estado) ? (x.EstadoVehiculo == Estado && x.EstadoVehiculo != null) : true)
.Where(x => !string.IsNullOrEmpty(DNI) ? (x.DNI == DNI && x.DNI != null) : true)
.Where(x => !string.IsNullOrEmpty(Apellido) ? (x.Apellido == Apellido && x.Apellido != null) : true)
.Where(x => !string.IsNullOrEmpty(Dominio) ? (x.Dominio == Dominio && x.Dominio != null) : true)
.Where(x => !string.IsNullOrEmpty(FechaDesde) ? (x.FechaInfraccion >= dtFechaDesde && x.FechaInfraccion != null) : true)
.Where(x => !string.IsNullOrEmpty(FechaHasta) ? (x.FechaInfraccion <= dtFechaHasta && x.FechaInfraccion != null) : true)
.Where(x => !string.IsNullOrEmpty(NroLiberacion) ? (db.Liberations.Where(y => y.ActaId == x.Id && y.NroLiberacion == NroLiberacion).Any()) : true)
.Select(c => new { c.Id, c.FechaCarga, c.FechaInfraccion, c.NroActa, c.Dominio, c.EstadoVehiculo, c.DNI, c.Nombre, c.Apellido }).OrderByDescending(x => x.FechaInfraccion).Take(1000);
;
// List<ActIndexViewModel> acts = new List<ActIndexViewModel>();
var liberations = db.Liberations.Where(x => x.Enable == true).ToList();
foreach (var item in lista)
{
ActIndexViewModel act = new ActIndexViewModel();
Liberation liberation = new Liberation();
//Busco si tiene un liberacion
liberation = liberations.Where(x => x.ActaId == item.Id).FirstOrDefault();
act.Id = item.Id;
act.NroActa = item.NroActa;
if (liberation != null)
{
act.NroLiberacion = liberation.NroLiberacion;
}
act.Apellido = item.Apellido;
act.DNI = item.DNI;
act.Dominio = item.Dominio;
act.Estado = item.EstadoVehiculo;
act.FechaCarga = item.FechaCarga;
act.FechaInfraccion = item.FechaInfraccion;
acts.Add(act);
}
}
catch (Exception e)
{
throw;
}
return(acts);
}
