private void AgregarConsumo() { GastosMaterial g = new GastosMaterial(); g.Cantidad = Double.Parse(txtCantidad.Text); g.IdGastoMaterial = 0; g.Material = ctrlMateriales.GetById((int)CmbMaterial.EditValue); g.Observacion = (string)txtObservacion.EditValue; g.Tipo = (GastosMaterial.TiposGasto)CmbTipoGasto.EditValue; lst.Add(g); GcConsumos.RefreshDataSource(); txtCantidad.EditValue = ""; CmbMaterial.EditValue = null; txtObservacion.EditValue = ""; CmbTipoGasto.EditValue = null; }
public List <GastosMaterial> CargarGastosMaterial(LoteEtapa e) { SqlCommand cmd = null; SqlConnection connection = null; SqlDataReader reader = null; try { connection = GetConnection(); connection.Open(); cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM [Produccion].[GastosMaterial] WHERE LoteEtapa = @LoteEtapa"; cmd.Parameters.AddWithValue("@LoteEtapa", e.IdLoteEtapa); reader = cmd.ExecuteReader(); while (reader.Read()) { GastosMaterial g = new GastosMaterial(); g.Cantidad = (double)(decimal)reader["Cantidad"]; g.IdGastoMaterial = (int)reader["IdGastoMaterial"]; g.Material = new Controlador.Produccion.ControladorMaterial().GetById((int)reader["Material"]); g.Observacion = (string)reader["Observacion"]; g.Tipo = (GastosMaterial.TiposGasto)reader["Tipo"]; e.GastosMateriales.Add(g); } return(e.GastosMateriales); } catch (Exception ex) { throw; } finally { if (connection != null) { connection.Close(); connection.Dispose(); } } }
public void AgregarGastoDeMaterial(LoteEtapa e, GastosMaterial g) { SqlConnection connection = null; SqlCommand cmd = null; try { connection = GetConnection(); connection.Open(); cmd = connection.CreateCommand(); cmd.CommandText = "UPDATE [Produccion].[Materiales] SET Existencia = Existencia - @Cantidad WHERE IdMaterial = @Material" + "" + Environment.NewLine + "INSERT INTO [Produccion].[GastosMaterial] VALUES (" + "@Material," + "@LoteEtapa," + "@Cantidad," + "@Tipo," + "@Observacion" + ")" + Environment.NewLine + "SELECT CAST(SCOPE_IDENTITY() as int)"; cmd.Parameters.AddWithValue("@Material", g.Material.IdMaterial); cmd.Parameters.AddWithValue("@LoteEtapa", e.IdLoteEtapa); cmd.Parameters.AddWithValue("@Cantidad", g.Cantidad); cmd.Parameters.AddWithValue("@Tipo", g.Tipo); cmd.Parameters.AddWithValue("@Observacion", g.Observacion); int id = (int)cmd.ExecuteScalar(); g.IdGastoMaterial = id; } catch (Exception ex) { throw ex; } finally { if (connection != null) { connection.Close(); connection.Dispose(); } } }