public bool modificarDB(ro_canasta_basica_Info info)
{
try
{
using (Entities_rrhh Context = new Entities_rrhh())
{
ro_canasta_basica Entity = Context.ro_canasta_basica.FirstOrDefault(q => q.Anio == info.Anio);
if (Entity == null)
{
return(false);
}
Entity.MultiploCanastaBasica = info.MultiploCanastaBasica;
Entity.MultiploFraccionBasica = info.MultiploFraccionBasica;
Entity.valorCanasta = info.valorCanasta;
Entity.Observacion = info.Observacion;
Entity.IdUsuarioUltMod = info.IdUsuarioUltMod;
Entity.FechaUltModi = info.FechaUltModi;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public ActionResult Modificar(ro_canasta_basica_Info info)
{
try
{
info.IdUsuarioUltMod = SessionFixed.IdUsuario;
if (ModelState.IsValid)
{
if (!bus_canasta.modificarDB(info))
{
ct_anio_fiscal_Bus bus_anio_fiscal = new ct_anio_fiscal_Bus();
ViewBag.lst_anio = bus_anio_fiscal.get_list(false);
return(View(info));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
return(View(info));
}
}
catch (Exception)
{
throw;
}
}
public bool guardarDB(ro_canasta_basica_Info info)
{
try
{
using (Entities_rrhh Context = new Entities_rrhh())
{
ro_canasta_basica Entity = new ro_canasta_basica
{
Anio = info.Anio,
MultiploFraccionBasica = info.MultiploFraccionBasica,
MultiploCanastaBasica = info.MultiploCanastaBasica,
valorCanasta = info.valorCanasta,
Observacion = info.Observacion,
IdUsuario = info.IdUsuario,
FechaTansaccion = DateTime.Now
};
Context.ro_canasta_basica.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public ro_canasta_basica_Info get_info(int IdEmpresa, int Anio)
{
try
{
ro_canasta_basica_Info info = new ro_canasta_basica_Info();
using (Entities_rrhh Context = new Entities_rrhh())
{
ro_canasta_basica Entity = Context.ro_canasta_basica.FirstOrDefault(q => q.Anio == Anio);
if (Entity == null)
{
return(null);
}
info = new ro_canasta_basica_Info
{
Anio = Entity.Anio,
MultiploCanastaBasica = Entity.MultiploCanastaBasica,
MultiploFraccionBasica = Entity.MultiploFraccionBasica,
Observacion = Entity.Observacion,
valorCanasta = Entity.valorCanasta
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public bool modificarDB(ro_canasta_basica_Info info)
{
try
{
return(odata.modificarDB(info));
}
catch (Exception)
{
throw;
}
}
public ActionResult Nuevo()
{
try
{
ct_anio_fiscal_Bus bus_anio_fiscal = new ct_anio_fiscal_Bus();
ViewBag.lst_anio = bus_anio_fiscal.get_list(false);
ro_canasta_basica_Info info = new ro_canasta_basica_Info();
return(View(info));
}
catch (Exception)
{
throw;
}
}
public ActionResult Index()
{
#region Validar Session
if (string.IsNullOrEmpty(SessionFixed.IdTransaccionSession))
{
return(RedirectToAction("Login", new { Area = "", Controller = "Account" }));
}
SessionFixed.IdTransaccionSession = (Convert.ToDecimal(SessionFixed.IdTransaccionSession) + 1).ToString();
SessionFixed.IdTransaccionSessionActual = SessionFixed.IdTransaccionSession;
#endregion
ro_canasta_basica_Info model = new ro_canasta_basica_Info
{
Anio = DateTime.Now.Year
};
return(View(model));
}
