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(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();
     }
 }
示例#4
0
 public static void Create(MATERIAL_KIT mat_new)
 {
     using (BODEXDataContext ctx = new BODEXDataContext())
     {
         ctx.ListaMaterialKit.InsertOnSubmit(mat_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();
     }
 }
示例#6
0
 public static void Create(ESTADO estado_new)
 {
     using (BODEXDataContext ctx = new BODEXDataContext())
     {
         ctx.ListaEstado.InsertOnSubmit(estado_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(COMPRA_RECEPCION c_r)
 {
     using (BODEXDataContext ctx = new BODEXDataContext())
     {
         ctx.ListaCompraRecepcion.InsertOnSubmit(c_r);
         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(DEVOLUCION_MATERIAL dev_mat_new)
 {
     using (BODEXDataContext ctx = new BODEXDataContext())
     {
         ctx.ListaDevolucionMaterial.InsertOnSubmit(dev_mat_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(DETALLE_SOLICITUD_COMPRA det_sol_comp_new)
 {
     using (BODEXDataContext ctx = new BODEXDataContext())
     {
         ctx.ListaSolicitudCompraDetalle.InsertOnSubmit(det_sol_comp_new);
         ctx.SubmitChanges();
     }
 }
示例#13
0
 public static void Create(USUARIO usu_new)
 {
     using (BODEXDataContext ctx = new BODEXDataContext())
     {
         ctx.ListaUsuario.InsertOnSubmit(usu_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();
     }
 }
示例#15
0
 public static void Create(STOCK_MATERIAL_UNIDAD stockmatunidad_new)
 {
     using (BODEXDataContext ctx = new BODEXDataContext())
     {
         ctx.ListaStockMaterialUnidad.InsertOnSubmit(stockmatunidad_new);
         ctx.SubmitChanges();
     }
 }
 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<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<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>();
     }
 }
示例#20
0
        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<RECEPCION_MATERIAL> getAll()
        {
            using (BODEXDataContext ctx = new BODEXDataContext())
            {
                var RecepcionMaterial = from recep_mat in ctx.ListaRecepcionMaterial
                                        orderby recep_mat.RM_ID
                                        select recep_mat;

                return RecepcionMaterial.ToList<RECEPCION_MATERIAL>();
            }
        }
        public static List<SOLICITUD_MATERIAL> getAll(int uc_id)
        {
            using (BODEXDataContext ctx = new BODEXDataContext())
            {
                var solicitud_material = from sol_mat in ctx.ListaSolicitudMaterial
                                         where sol_mat.UC_ID.Equals(uc_id)
                                         select sol_mat;

                return solicitud_material.ToList<SOLICITUD_MATERIAL>();
            }
        }
        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 SOLICITUD_MATERIAL getEnd()
        {
            using (BODEXDataContext ctx = new BODEXDataContext())
            {
                List<SOLICITUD_MATERIAL> solicitud_compra = (from sol_comp in ctx.ListaSolicitudMaterial
                                                           orderby sol_comp.SM_ID
                                                           select sol_comp).ToList<SOLICITUD_MATERIAL>();

                return solicitud_compra.Last<SOLICITUD_MATERIAL>();
            }
        }
示例#25
0
        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>();
            }
        }
示例#26
0
 public static void Create(MATERIAL mat_new)
 {
     using (BODEXDataContext ctx = new BODEXDataContext())
     {
         mat_new.M_STOCK_IDEAL = 100;
         mat_new.M_STOCK_BAJO = 1;
         mat_new.M_STOCK_REAL = 0;
         ctx.ListaMaterial.InsertOnSubmit(mat_new);
         ctx.SubmitChanges();
     }
 }
        public static RECEPCION_MATERIAL getEnd()
        {
            using (BODEXDataContext ctx = new BODEXDataContext())
            {
                List<RECEPCION_MATERIAL> recep = (from rec in ctx.ListaRecepcionMaterial
                                                  orderby rec.RM_ID
                                                  select rec).ToList<RECEPCION_MATERIAL>();

                return recep.Last<RECEPCION_MATERIAL>();
            }
        }
        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<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 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>();
            }
        }