public tb_TarjetaCredito_Info GetInfo(int IdTarjeta)
{
try
{
tb_TarjetaCredito_Info info = new tb_TarjetaCredito_Info();
using (Entities_general Context = new Entities_general())
{
tb_TarjetaCredito Entity = Context.tb_TarjetaCredito.FirstOrDefault(q => q.IdTarjeta == IdTarjeta);
if (Entity == null)
{
return(null);
}
info = new tb_TarjetaCredito_Info
{
IdTarjeta = Entity.IdTarjeta,
NombreTarjeta = Entity.NombreTarjeta,
Estado = Entity.Estado
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public bool GuardarBD(tb_TarjetaCredito_Info info)
{
try
{
using (Entities_general db = new Entities_general())
{
db.tb_TarjetaCredito.Add(new tb_TarjetaCredito
{
IdTarjeta = get_id(),
NombreTarjeta = info.NombreTarjeta,
Estado = info.Estado = true,
IdUsuario = info.IdUsuario,
Fecha_Transac = DateTime.Now
});
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool AnularBD(tb_TarjetaCredito_Info info)
{
try
{
using (Entities_general db = new Entities_general())
{
tb_TarjetaCredito entity = db.tb_TarjetaCredito.Where(q => q.IdTarjeta == info.IdTarjeta).FirstOrDefault();
if (entity == null)
{
return(false);
}
entity.Estado = info.Estado;
entity.IdUsuarioUltAnu = info.IdUsuario;
entity.Fecha_UltAnu = DateTime.Now;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public tb_TarjetaCredito_Info getInfo(int IdEmpresa, int IdTarjeta)
{
try
{
tb_TarjetaCredito_Info info;
using (Entities_general db = new Entities_general())
{
//q.IdEmpresa== IdEmpresa &&
var Entity = db.tb_TarjetaCredito.Where(q => q.IdTarjeta == IdTarjeta).FirstOrDefault();
if (Entity == null)
{
return(null);
}
info = new tb_TarjetaCredito_Info
{
//IdEmpresa = Entity.IdEmpresa,
IdTarjeta = Entity.IdTarjeta,
NombreTarjeta = Entity.NombreTarjeta,
//IdBanco = Entity.IdBanco,
Estado = Entity.Estado
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public bool guardarDB(tb_TarjetaCredito_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_TarjetaCredito Entity = new tb_TarjetaCredito
{
//IdEmpresa = info.IdEmpresa,
IdTarjeta = info.IdTarjeta = getId(info.IdEmpresa),
NombreTarjeta = info.NombreTarjeta,
//IdBanco = info.IdBanco,
Estado = true,
IdUsuario = info.IdUsuario,
Fecha_Transac = info.Fecha_Transac = DateTime.Now
};
Context.tb_TarjetaCredito.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool anularDB(tb_TarjetaCredito_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
// q.IdEmpresa == info.IdEmpresa &&
tb_TarjetaCredito Entity = Context.tb_TarjetaCredito.FirstOrDefault(q => q.IdTarjeta == info.IdTarjeta);
if (Entity == null)
{
return(false);
}
Entity.Estado = info.Estado = false;
Entity.IdUsuarioUltAnu = info.IdUsuarioUltAnu;
Entity.Fecha_UltAnu = info.Fecha_UltAnu = DateTime.Now;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool modificarDB(tb_TarjetaCredito_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
//q.IdEmpresa== info.IdEmpresa &&
tb_TarjetaCredito Entity = Context.tb_TarjetaCredito.FirstOrDefault(q => q.IdTarjeta == info.IdTarjeta);
if (Entity == null)
{
return(false);
}
Entity.NombreTarjeta = info.NombreTarjeta;
//Entity.IdBanco = info.IdBanco;
Entity.IdUsuarioUltMod = info.IdUsuarioUltMod;
Entity.Fecha_UltMod = info.Fecha_UltMod = DateTime.Now;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public ActionResult Anular(tb_TarjetaCredito_Info model)
{
model.IdUsuarioUltAnu = SessionFixed.IdUsuario;
if (!bus_TarjetaCredito.AnularBD(model))
{
return(View(model));
}
return(RedirectToAction("Index"));
}
public ActionResult Anular(int IdTarjeta = 0)
{
tb_TarjetaCredito_Info model = bus_TarjetaCredito.GetInfo(IdTarjeta);
if (model == null)
{
return(RedirectToAction("Index"));
}
return(View(model));
}
public bool AnularBD(tb_TarjetaCredito_Info info)
{
try
{
return(odata.AnularBD(info));
}
catch (Exception)
{
throw;
}
}
public bool ModificarDB(tb_TarjetaCredito_Info info)
{
try
{
return(odata.modificarDB(info));
}
catch (Exception)
{
throw;
}
}
public bool GuardarDB(tb_TarjetaCredito_Info info)
{
try
{
return(odata.guardarDB(info));
}
catch (Exception)
{
throw;
}
}
public tb_TarjetaCredito_Info get_info_demanda(int IdTarjetaCredito)
{
try
{
tb_TarjetaCredito_Info info = new tb_TarjetaCredito_Info();
using (Entities_general Context = new Entities_general())
{
info = (from q in Context.tb_TarjetaCredito
where q.IdTarjeta == IdTarjetaCredito
select new tb_TarjetaCredito_Info
{
IdTarjeta = q.IdTarjeta,
NombreTarjeta = q.NombreTarjeta,
Estado = q.Estado
}).FirstOrDefault();
}
return(info);
}
catch (Exception)
{
throw;
}
}
public ActionResult Nuevo()
{
tb_TarjetaCredito_Info model = new tb_TarjetaCredito_Info();
return(View(model));
}
