public ActionResult Index(string IdPais = "")
{
#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
#region Permisos
seg_Menu_x_Empresa_x_Usuario_Info info = bus_permisos.get_list_menu_accion(Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.IdUsuario, "General", "Pais", "Index");
ViewBag.Nuevo = info.Nuevo;
#endregion
tb_region_Info model = new tb_region_Info
{
IdTransaccionSession = Convert.ToDecimal(SessionFixed.IdTransaccionSession),
IdPais = IdPais
};
var lst = bus_region.get_list(model.IdPais, true);
Lista_Region.set_list(lst, model.IdTransaccionSession);
return(View(model));
}
public List <tb_region_Info> Get_List_Region()
{
try
{
string mensaje = "";
List <tb_region_Info> lstCiudad = new List <tb_region_Info>();
using (EntitiesGeneral Base = new EntitiesGeneral())
{
var vciudad = from c in Base.tb_region
select c;
foreach (var item in vciudad)
{
tb_region_Info infoCiudad = new tb_region_Info();
infoCiudad.Cod_Region = item.Cod_Region;
infoCiudad.Nom_region = item.Nom_region;
lstCiudad.Add(infoCiudad);
}
}
return(lstCiudad);
}
catch (Exception ex)
{
return(new List <tb_region_Info>());
}
}
public ActionResult Consultar(string codRegion = "", bool Exito = false)
{
tb_region_Info model = bus_region.get_info(codRegion);
if (model == null)
{
ViewBag.IdPais = model.IdPais;
return(RedirectToAction("Index", ViewBag.IdPais = model.IdPais));
}
#region Permisos
seg_Menu_x_Empresa_x_Usuario_Info info = bus_permisos.get_list_menu_accion(Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.IdUsuario, "General", "Pais", "Index");
if (model.estado == false)
{
info.Modificar = false;
info.Anular = false;
}
model.Nuevo = (info.Nuevo == true ? 1 : 0);
model.Modificar = (info.Modificar == true ? 1 : 0);
model.Anular = (info.Anular == true ? 1 : 0);
#endregion
if (Exito)
{
ViewBag.MensajeSuccess = MensajeSuccess;
}
cargar_combos();
return(View(model));
}
public bool guardarDB(tb_region_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_region Entity = new tb_region
{
Cod_Region = info.Cod_Region = get_id(),
Nom_region = info.Nom_region,
codigo = info.codigo,
estado = info.estado = true,
IdPais = info.IdPais
};
Context.tb_region.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public tb_region_Info get_info(string CodRegion)
{
try
{
tb_region_Info info = new tb_region_Info();
using (Entities_general Context = new Entities_general())
{
tb_region Entity = Context.tb_region.FirstOrDefault(q => q.Cod_Region == CodRegion);
if (Entity == null)
{
return(null);
}
info = new tb_region_Info
{
Cod_Region = Entity.Cod_Region,
codigo = Entity.codigo,
Nom_region = Entity.Nom_region,
estado = Entity.estado,
IdPais = Entity.IdPais
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public ActionResult Modificar(tb_region_Info model)
{
if (!bus_region.modificarDB(model))
{
ViewBag.IdPais = model.IdPais;
cargar_combos();
return(View(model));
}
return(RedirectToAction("Index", new { IdPais = model.IdPais }));
}
public ActionResult Nuevo(string IdPais = "")
{
tb_region_Info model = new tb_region_Info
{
IdPais = IdPais
};
ViewBag.IdPais = IdPais;
cargar_combos();
return(View(model));
}
public bool anularDB(tb_region_Info info)
{
try
{
return(odata.anularDB(info));
}
catch (Exception)
{
throw;
}
}
public bool modificarDB(tb_region_Info info)
{
try
{
return(odata.modificarDB(info));
}
catch (Exception)
{
throw;
}
}
public ActionResult Anular(string codRegion = "")
{
tb_region_Info model = bus_region.get_info(codRegion);
if (model == null)
{
ViewBag.IdPais = model.IdPais;
return(RedirectToAction("Index", ViewBag.IdPais = model.IdPais));
}
cargar_combos();
return(View(model));
}
public ActionResult Nuevo(string IdPais = "")
{
#region Permisos
seg_Menu_x_Empresa_x_Usuario_Info info = bus_permisos.get_list_menu_accion(Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.IdUsuario, "General", "Pais", "Index");
if (!info.Nuevo)
{
return(RedirectToAction("Index"));
}
#endregion
tb_region_Info model = new tb_region_Info
{
IdPais = IdPais
};
ViewBag.IdPais = IdPais;
cargar_combos();
return(View(model));
}
public ActionResult Modificar(string codRegion = "")
{
#region Permisos
seg_Menu_x_Empresa_x_Usuario_Info info = bus_permisos.get_list_menu_accion(Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.IdUsuario, "General", "Pais", "Index");
if (!info.Modificar)
{
return(RedirectToAction("Index"));
}
#endregion
tb_region_Info model = bus_region.get_info(codRegion);
if (model == null)
{
ViewBag.IdPais = model.IdPais;
return(RedirectToAction("Index", ViewBag.IdPais = model.IdPais));
}
cargar_combos();
return(View(model));
}
public bool anularDB(tb_region_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_region Entity = Context.tb_region.FirstOrDefault(q => q.Cod_Region == info.Cod_Region);
if (Entity == null)
{
return(false);
}
Entity.estado = info.estado = false;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
