public static void Create(COMPRA_RECEPCION c_r)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaCompraRecepcion.InsertOnSubmit(c_r);
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_SOLICITUD_MATERIAL sol_mat_det_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaSolicitudMaterialDetalle.InsertOnSubmit(sol_mat_det_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_RECEPCION_MATERIAL rec_mat_det_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaRecepcionMaterialDetalle.InsertOnSubmit(rec_mat_det_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 void Create(SOLICITUD_COMPRA sol_comp_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaSolicitudCompra.InsertOnSubmit(sol_comp_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_DEVOLUCION_MATERIAL d_d_m_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaDevolucionMaterialDetalle.InsertOnSubmit(d_d_m_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(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_ENTREGA_MATERIAL det_entr_mat_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaEntregaMaterialDetalle.InsertOnSubmit(det_entr_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(USUARIO usu_new)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ctx.ListaUsuario.InsertOnSubmit(usu_new);
ctx.SubmitChanges();
}
}
public static void DeleteKit(MATERIAL mat_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
MATERIAL_KIT material;
try
{
material = (from mat in ctx.ListaMaterialKit
where mat.M_ID.Equals(mat_del.M_ID)
select mat).First <MATERIAL_KIT>();
}
catch (Exception e)
{
material = null;
}
while (material != null)
{
ctx.ListaMaterialKit.DeleteOnSubmit(material);
ctx.SubmitChanges();
try
{
material = (from mat in ctx.ListaMaterialKit
where mat.M_ID.Equals(mat_del.M_ID)
select mat).First <MATERIAL_KIT>();
}
catch (Exception e)
{
material = null;
}
}
MATERIAL borrar = (from mat in ctx.ListaMaterial
where mat.M_ID.Equals(mat_del.M_ID)
select mat).First <MATERIAL>();
ctx.ListaMaterial.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
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 void Delete(DETALLE_ENTREGA_MATERIAL det_entr_mat_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
DETALLE_ENTREGA_MATERIAL borrar = (from det_entr_mat in ctx.ListaEntregaMaterialDetalle
where det_entr_mat.EM_ID.Equals(det_entr_mat_del.EM_ID) && det_entr_mat.M_ID.Equals(det_entr_mat_del.M_ID)
select det_entr_mat).First <DETALLE_ENTREGA_MATERIAL>();
ctx.ListaEntregaMaterialDetalle.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void Update(DETALLE_ENTREGA_MATERIAL det_entr_mat_upd)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
DETALLE_ENTREGA_MATERIAL EntregaMaterialDetalle = (from det_entr_mat in ctx.ListaEntregaMaterialDetalle
where det_entr_mat.EM_ID.Equals(det_entr_mat_upd.EM_ID) && det_entr_mat.M_ID.Equals(det_entr_mat_upd.M_ID)
select det_entr_mat).First <DETALLE_ENTREGA_MATERIAL>();
EntregaMaterialDetalle.DEM_CANTIDAD = det_entr_mat_upd.DEM_CANTIDAD;
ctx.SubmitChanges();
}
}
public static void Delete(DETALLE_DEVOLUCION_MATERIAL d_d_m_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
DETALLE_DEVOLUCION_MATERIAL borrar = (from d_d_m in ctx.ListaDevolucionMaterialDetalle
where (d_d_m.M_ID.Equals(d_d_m_del.M_ID) && d_d_m.DM_ID.Equals(d_d_m_del.DM_ID))
select d_d_m).First <DETALLE_DEVOLUCION_MATERIAL>();
ctx.ListaDevolucionMaterialDetalle.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void Delete(ESTADO estado_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ESTADO borrar = (from e in ctx.ListaEstado
where e.E_ID.Equals(estado_del.E_ID)
select e).First <ESTADO>();
ctx.ListaEstado.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void Delete(SOLICITUD_COMPRA sol_comp_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
SOLICITUD_COMPRA borrar = (from sol_comp in ctx.ListaSolicitudCompra
where sol_comp.SC_ID.Equals(sol_comp_del.SC_ID)
select sol_comp).First <SOLICITUD_COMPRA>();
ctx.ListaSolicitudCompra.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void Delete(DEVOLUCION_A_PROVEEDOR dev_pro_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
DEVOLUCION_A_PROVEEDOR borrar = (from dev_pro in ctx.ListaDevolucionProveedor
where dev_pro.DP_ID.Equals(dev_pro_del.DP_ID)
select dev_pro).First <DEVOLUCION_A_PROVEEDOR>();
ctx.ListaDevolucionProveedor.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void Delete(UNIDAD_CLINICA uni_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
UNIDAD_CLINICA borrar = (from uni in ctx.ListaUnidadClinica
where uni.UC_ID.Equals(uni_del.UC_ID)
select uni).First <UNIDAD_CLINICA>();
ctx.ListaUnidadClinica.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void Delete(DETALLE_DEVOLUCION_A_PROVEEDOR det_dev_p_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
DETALLE_DEVOLUCION_A_PROVEEDOR borrar = (from det_dev_p in ctx.ListaDevolucionProveedorDetalle
where det_dev_p.DP_ID.Equals(det_dev_p_del.DP_ID) && det_dev_p.M_ID.Equals(det_dev_p_del.M_ID)
select det_dev_p).First <DETALLE_DEVOLUCION_A_PROVEEDOR>();
ctx.ListaDevolucionProveedorDetalle.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void updateComprar(MATERIAL_FALTANTE mat_upd)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
MATERIAL_FALTANTE material = (from mat in CRUD_Material.getAllComprar()
where mat.M_ID.Equals(mat_upd.M_ID)
select mat).First <MATERIAL_FALTANTE>();
material.M_CANTIDAD = mat_upd.M_CANTIDAD;
ctx.SubmitChanges();
}
}
public static void Delete(ENTREGA_MATERIAL entrg_mat_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
ENTREGA_MATERIAL borrar = (from entrg_mat in ctx.ListaEntregaMaterial
where entrg_mat.EM_ID.Equals(entrg_mat_del.EM_ID)
select entrg_mat).First <ENTREGA_MATERIAL>();
ctx.ListaEntregaMaterial.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void Delete(MATERIAL mat_del)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
MATERIAL borrar = (from mat in ctx.ListaMaterial
where mat.M_ID.Equals(mat_del.M_ID)
select mat).First <MATERIAL>();
ctx.ListaMaterial.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void Delete(USUARIO usuario)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
USUARIO borrar = (from u in ctx.ListaUsuario
where u.nombre.Equals(usuario.nombre)
select u).First <USUARIO>();
ctx.ListaUsuario.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
public static void Delete(COMPRA_RECEPCION cr_upd)
{
using (BODEXDataContext ctx = new BODEXDataContext())
{
COMPRA_RECEPCION borrar = (from c_r in ctx.ListaCompraRecepcion
where (c_r.SC_ID.Equals(cr_upd.SC_ID) && c_r.RM_ID.Equals(cr_upd.RM_ID))
select c_r).First <COMPRA_RECEPCION>();
ctx.ListaCompraRecepcion.DeleteOnSubmit(borrar);
ctx.SubmitChanges();
}
}
