public DataTable BuscarIngresoNumeroIngreso(DIngresoArticulo ingreso) { string cadena = "sp_buscar_ingreso_por_numero_ingreso"; DataTable tabla = new DataTable(); SqlConnection cn = new SqlConnection(); try { cn.ConnectionString = Conexion.conectar; cn.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cadena, cn)) { da.SelectCommand.Parameters.AddWithValue("@id", ingreso.NumIngreso); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.Fill(tabla); } } catch (Exception) { return(tabla); throw; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } return(tabla); }
public int Insertar(DIngresoArticulo ingreso) { int ultimoid = 0; string cadena = "sp_insertar_ingreso_articulo"; SqlConnection cn = new SqlConnection(); try { // code here cn.ConnectionString = Conexion.conectar; cn.Open(); using (SqlCommand cmd = new SqlCommand(cadena, cn)) { cmd.Parameters.AddWithValue("@comprobante", ingreso.Comprobante); cmd.Parameters.AddWithValue("@numingreso", ingreso.NumIngreso); cmd.Parameters.AddWithValue("@impuesto", ingreso.Impuesto); cmd.Parameters.AddWithValue("@idproveedor", ingreso.IdProveedor); cmd.Parameters.AddWithValue("@idusuario", ingreso.IdUsuario); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ultimoid", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); cn.Close(); ultimoid = Convert.ToInt32(cmd.Parameters["@ultimoid"].Value.ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error ... ???", MessageBoxButtons.OK, MessageBoxIcon.Error); return(ultimoid); throw; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } return(ultimoid); }
public bool ActualizarEstado(DIngresoArticulo ingreso) { int rpta = 0; string cadena = "sp_anular_ingreso_articulo"; SqlConnection cn = new SqlConnection(); try { // code here cn.ConnectionString = Conexion.conectar; cn.Open(); using (SqlCommand cmd = new SqlCommand(cadena, cn)) { cmd.Parameters.AddWithValue("@estado", ingreso.Estado); cmd.Parameters.AddWithValue("@id", ingreso.IdIngresoArticulo); cmd.CommandType = CommandType.StoredProcedure; rpta = cmd.ExecuteNonQuery(); if (rpta == 1) { return(true); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error ... ???", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); throw; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } return(false); }