public static bool TienePermiso(USUARIO usuarioLogin,
string UrlConsulta)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var EsBase = from pa in ctx.ListaPagina
where pa.P_BASE.Equals(true) &&
pa.P_NAVIGATE.Equals(UrlConsulta)
select pa;
if (EsBase.Count <PAGINA>() > 0)
{
return(true);
}
//Obtengo el Perfil del Usuario
var Retorno = from PePa in ctx.ListaPagina
where PePa.P_NAVIGATE.Equals(UrlConsulta) && (PePa.P_PERFIL.Equals(usuarioLogin.area) || PePa.P_PERFIL.Equals("All"))
select PePa;
if (Retorno.Count <PAGINA>() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static void Create(DETALLE_SOLICITUD_COMPRA det_sol_comp_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaSolicitudCompraDetalle.InsertOnSubmit(det_sol_comp_new);
ctx.SubmitChanges();
}
}
public static void Create(MATERIAL_KIT mat_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaMaterialKit.InsertOnSubmit(mat_new);
ctx.SubmitChanges();
}
}
public static void Create(DETALLE_DEVOLUCION_MATERIAL d_d_m_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaDevolucionMaterialDetalle.InsertOnSubmit(d_d_m_new);
ctx.SubmitChanges();
}
}
public static void Create(DEVOLUCION_MATERIAL dev_mat_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaDevolucionMaterial.InsertOnSubmit(dev_mat_new);
ctx.SubmitChanges();
}
}
public static void Create(UNIDAD_CLINICA uni_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaUnidadClinica.InsertOnSubmit(uni_new);
ctx.SubmitChanges();
}
}
public static void Create(DETALLE_RECEPCION_MATERIAL rec_mat_det_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaRecepcionMaterialDetalle.InsertOnSubmit(rec_mat_det_new);
ctx.SubmitChanges();
}
}
public static void Create(USUARIO usu_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaUsuario.InsertOnSubmit(usu_new);
ctx.SubmitChanges();
}
}
public static void Create(DETALLE_ENTREGA_MATERIAL det_entr_mat_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaEntregaMaterialDetalle.InsertOnSubmit(det_entr_mat_new);
ctx.SubmitChanges();
}
}
public static void Create(COMPRA_RECEPCION c_r)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaCompraRecepcion.InsertOnSubmit(c_r);
ctx.SubmitChanges();
}
}
public static void Create(STOCK_MATERIAL_UNIDAD stockmatunidad_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaStockMaterialUnidad.InsertOnSubmit(stockmatunidad_new);
ctx.SubmitChanges();
}
}
public static void Create(ENTREGA_MATERIAL entrg_mat_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaEntregaMaterial.InsertOnSubmit(entrg_mat_new);
ctx.SubmitChanges();
}
}
public static void Create(DETALLE_DEVOLUCION_A_PROVEEDOR det_dev_p_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaDevolucionProveedorDetalle.InsertOnSubmit(det_dev_p_new);
ctx.SubmitChanges();
}
}
public static void Create(DETALLE_SOLICITUD_MATERIAL sol_mat_det_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaSolicitudMaterialDetalle.InsertOnSubmit(sol_mat_det_new);
ctx.SubmitChanges();
}
}
public static void Create(ESTADO estado_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaEstado.InsertOnSubmit(estado_new);
ctx.SubmitChanges();
}
}
public static void Create(SOLICITUD_COMPRA sol_comp_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaSolicitudCompra.InsertOnSubmit(sol_comp_new);
ctx.SubmitChanges();
}
}
public static PAGINA ReadPagina(long PaginaId)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
return((from Pa in ctx.ListaPagina
where Pa.P_ID.Equals(PaginaId)
select Pa).First <PAGINA>());
}
}
public static List <DEVOLUCION_A_PROVEEDOR> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var DevolucionProveedor = from dev_pro in ctx.ListaDevolucionProveedor
orderby dev_pro.DP_ID
select dev_pro;
return(DevolucionProveedor.ToList <DEVOLUCION_A_PROVEEDOR>());
}
}
public static List <DEVOLUCION_MATERIAL> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var DevolucionMaterial = from dev_mat in ctx.ListaDevolucionMaterial
orderby dev_mat.DM_ID
select dev_mat;
return(DevolucionMaterial.ToList <DEVOLUCION_MATERIAL>());
}
}
public static List <COMPRA_RECEPCION> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var CompraRecepcion = from c_r in ctx.ListaCompraRecepcion
orderby c_r.SC_ID, c_r.RM_ID
select c_r;
return(CompraRecepcion.ToList <COMPRA_RECEPCION>());
}
}
public static List <DETALLE_DEVOLUCION_A_PROVEEDOR> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var DevolucionProveedorDetalle = from det_dev_p in ctx.ListaDevolucionProveedorDetalle
orderby det_dev_p.DP_ID, det_dev_p.M_ID
select det_dev_p;
return(DevolucionProveedorDetalle.ToList <DETALLE_DEVOLUCION_A_PROVEEDOR>());
}
}
public static List <STOCK_MATERIAL_UNIDAD> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var stock_unidad = from stock_un in ctx.ListaStockMaterialUnidad
orderby stock_un.M_ID, stock_un.UC_ID
select stock_un;
return(stock_unidad.ToList <STOCK_MATERIAL_UNIDAD>());
}
}
public static List <UNIDAD_CLINICA> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var unidades = from uni in ctx.ListaUnidadClinica
orderby uni.UC_ID
select uni;
return(unidades.ToList <UNIDAD_CLINICA>());
}
}
public static List <ENTREGA_MATERIAL> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var entrega_material = from entrg_mat in ctx.ListaEntregaMaterial
orderby entrg_mat.EM_ID
select entrg_mat;
return(entrega_material.ToList <ENTREGA_MATERIAL>());
}
}
public static List <USUARIO> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var usuario = from usu in ctx.ListaUsuario
orderby usu.nombre
select usu;
return(usuario.ToList <USUARIO>());
}
}
public static List <DETALLE_ENTREGA_MATERIAL> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var EntregaMaterialDetalle = from det_entr_mat in ctx.ListaEntregaMaterialDetalle
orderby det_entr_mat.EM_ID, det_entr_mat.M_ID
select det_entr_mat;
return(EntregaMaterialDetalle.ToList <DETALLE_ENTREGA_MATERIAL>());
}
}
public static List <SOLICITUD_COMPRA> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var solicitud_compra = from sol_comp in ctx.ListaSolicitudCompra
orderby sol_comp.SC_ID
select sol_comp;
return(solicitud_compra.ToList <SOLICITUD_COMPRA>());
}
}
public static List <ESTADO> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var estado = from e in ctx.ListaEstado
orderby e.E_ID
select e;
return(estado.ToList <ESTADO>());
}
}
public static SOLICITUD_COMPRA getEnd()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
List <SOLICITUD_COMPRA> solicitud_compra = (from sol_comp in ctx.ListaSolicitudCompra
orderby sol_comp.SC_ID
select sol_comp).ToList <SOLICITUD_COMPRA>();
return(solicitud_compra.Last <SOLICITUD_COMPRA>());
}
}
public static List <DETALLE_DEVOLUCION_MATERIAL> getAll()
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
var DevolucionMaterialDetalle = from d_d_m in ctx.ListaDevolucionMaterialDetalle
orderby d_d_m.DM_ID, d_d_m.M_ID
select d_d_m;
return(DevolucionMaterialDetalle.ToList <DETALLE_DEVOLUCION_MATERIAL>());
}
}
