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(); } }
protected void Ingresar(object sender, EventArgs e) { ASPxButton boton = (ASPxButton)sender; Control main = boton.Parent; string encargado = "Bodega"; Label usuario = (Label)main.Parent.Parent.FindControl("lblUsuario"); if (usuario != null) { encargado = usuario.Text; } ASPxListBox list = (ASPxListBox)main.FindControl("ASPxListBox1"); ASPxComboBox combo = (ASPxComboBox)main.FindControl("ASPxComboBox1"); string id_compra = ASPxComboBox1.SelectedItem.Value.ToString(); if (list.Items.Count == 0) { return; } SOLICITUD_COMPRA compra = CRUD_SolicitudCompra.Read(Int32.Parse(id_compra)); RECEPCION_MATERIAL recepcion = new RECEPCION_MATERIAL(); recepcion.RM_ENCARGADO_RECEPCION = encargado; recepcion.RM_FECHA = DateTime.Now; CRUD_RecepcionMaterial.Create(recepcion); int id_recep = (Int32)CRUD_RecepcionMaterial.getEnd().RM_ID; foreach (ListEditItem item in list.Items) { MATERIAL material = CRUD_Material.Read(Int32.Parse(item.GetValue("M_ID").ToString())); DETALLE_RECEPCION_MATERIAL detalle = new DETALLE_RECEPCION_MATERIAL(); detalle.RM_ID = id_recep; detalle.M_ID = material.M_ID; detalle.DRM_CANTIDAD = Int32.Parse(item.GetValue("D_CANTIDAD").ToString()); CRUD_RecepcionMaterialDetalle.Create(detalle); } compra.E_ID = 2; CRUD_SolicitudCompra.Update(compra); COMPRA_RECEPCION ligar = new COMPRA_RECEPCION(); ligar.SC_ID = compra.SC_ID; ligar.RM_ID = id_recep; CRUD_CompraRecepcion.Create(ligar); Response.Redirect("~/RecepcionMaterial.aspx"); }
public static void Delete(DETALLE_RECEPCION_MATERIAL rec_mat_det_del) { using (BODEXDataContext ctx = new BODEXDataContext()) { DETALLE_RECEPCION_MATERIAL borrar = (from rec_mat_det in ctx.ListaRecepcionMaterialDetalle where rec_mat_det.RM_ID.Equals(rec_mat_det_del.RM_ID) && rec_mat_det.M_ID.Equals(rec_mat_det_del.M_ID) select rec_mat_det).First <DETALLE_RECEPCION_MATERIAL>(); ctx.ListaRecepcionMaterialDetalle.DeleteOnSubmit(borrar); ctx.SubmitChanges(); } }
public static void Update(DETALLE_RECEPCION_MATERIAL rec_mat_det_upd) { using (BODEXDataContext ctx = new BODEXDataContext()) { DETALLE_RECEPCION_MATERIAL recepcion_mat_det = (from rec_mat_det in ctx.ListaRecepcionMaterialDetalle where rec_mat_det.RM_ID.Equals(rec_mat_det_upd.RM_ID) && rec_mat_det.M_ID.Equals(rec_mat_det_upd.M_ID) select rec_mat_det).First <DETALLE_RECEPCION_MATERIAL>(); recepcion_mat_det.DRM_CANTIDAD = rec_mat_det_upd.DRM_CANTIDAD; ctx.SubmitChanges(); } }