示例#1
0
        public int DeleteVentaDetails(int idVenta)
        {
            try
            {
                using (var Conexion = new EntitiesERP())
                {
                    TBL_DETAILS_VENTA tBL_DETAILS_VENTA = Conexion.TBL_DETAILS_VENTA.Where(x => x.ID_VENTA == idVenta).FirstOrDefault();

                    Conexion.Entry(tBL_DETAILS_VENTA).State = EntityState.Deleted;

                    return(Conexion.SaveChanges());
                }
            }
            catch (Exception)
            {
                return(0);
            }
        }
示例#2
0
        public int Insert(int idVenta, int idArticulo, int cantidad, double precio)
        {
            try
            {
                using (var Conexion = new EntitiesERP())
                {
                    TBL_DETAILS_VENTA tBL_DETAILS_VENTA = new TBL_DETAILS_VENTA();

                    tBL_DETAILS_VENTA.ID_VENTA    = idVenta;
                    tBL_DETAILS_VENTA.ID_ARTICULO = idArticulo;
                    tBL_DETAILS_VENTA.CANTIDAD    = cantidad;
                    tBL_DETAILS_VENTA.PRECIO      = precio;

                    Conexion.TBL_DETAILS_VENTA.Add(tBL_DETAILS_VENTA);

                    return(Conexion.SaveChanges());
                }
            }
            catch (Exception)
            {
                return(0);
            }
        }