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>()); } }