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