public static void DeleteObject(HydroPlant dataObject) { string query = string.Format("DELETE FROM {0} " + "WHERE Id = {1}", table, dataObject.Id); DataBaseManager.ExecuteQuery(query); }
/* Constructor needed to add rows in the RadGridView control */ public HydroPlantViewModel() { plant = new HydroPlant(); Company = ""; Subarea = ""; Case = 1; StartPeriod = 1; }
public static int UpdateObject(HydroPlant dataObject) { bool isNew = false; string query = string.Format("SELECT nombre " + "FROM {0} " + "WHERE Id = {1}", table, dataObject.Id); OleDbDataReader reader = DataBaseManager.ReadData(query); if (!reader.Read()) { query = string.Format("INSERT INTO {0}(nombre, FactorDisponibilidad, FactorConversionPromedio, Minimo, Maximo, CostoVariable, PorcentajeAGC, FactorConversionVariable, Obligatorio, empresa, EtapaEntrada, Escenario, Subarea) " + "VALUES(@Name, @AvailabilityFactor, @ProductionFactor, @Min, @Max, @VariableCost, @AGCPercentage, @VariableProductionFactor, @Mandatory, @Company, @StartPeriod, @Case, @Subarea)", table); isNew = true; } else { query = string.Format("UPDATE {0} SET " + "nombre = @Name, " + "FactorDisponibilidad = @AvailabilityFactor, " + "FactorConversionPromedio = @ProductionFactor, " + "Minimo = @Min, " + "Maximo = @Max, " + "CostoVariable = @VariableCost, " + "PorcentajeAGC = @AGCPercentage, " + "FactorConversionVariable = @VariableProductionFactor, " + "Obligatorio = @Mandatory, " + "empresa = @Company, " + "EtapaEntrada = @StartPeriod, " + "escenario = @Case, " + "Subarea = @Subarea " + "WHERE Id = @Id", table); } DataBaseManager.DbConnection.Close(); using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection)) { command.Parameters.Add("@Name", OleDbType.VarChar); command.Parameters.Add("@AvailabilityFactor", OleDbType.Numeric); command.Parameters.Add("@ProductionFactor", OleDbType.Numeric); command.Parameters.Add("@Min", OleDbType.Numeric); command.Parameters.Add("@Max", OleDbType.Numeric); command.Parameters.Add("@VariableCost", OleDbType.Numeric); command.Parameters.Add("@AGCPercentage", OleDbType.Numeric); command.Parameters.Add("@VariableProductionFactor", OleDbType.Numeric); command.Parameters.Add("@Mandatory", OleDbType.Numeric); command.Parameters.Add("@Company", OleDbType.VarChar); command.Parameters.Add("@StartPeriod", OleDbType.Numeric); command.Parameters.Add("@Case", OleDbType.Numeric); command.Parameters.Add("@Subarea", OleDbType.VarChar); command.Parameters.Add("@Id", OleDbType.Numeric); DataBaseManager.DbConnection.Open(); command.Parameters["@Name"].Value = dataObject.Name; command.Parameters["@AvailabilityFactor"].Value = dataObject.AvailabilityFactor; command.Parameters["@ProductionFactor"].Value = dataObject.ProductionFactor; command.Parameters["@Min"].Value = dataObject.Min; command.Parameters["@Max"].Value = dataObject.Max; command.Parameters["@VariableCost"].Value = dataObject.VariableCost; command.Parameters["@AGCPercentage"].Value = dataObject.AGCPercentage; command.Parameters["@VariableProductionFactor"].Value = dataObject.HasVariableProductionFactor; command.Parameters["@Mandatory"].Value = dataObject.IsMandatory; command.Parameters["@Company"].Value = dataObject.Company; command.Parameters["@StartPeriod"].Value = dataObject.StartPeriod; command.Parameters["@Case"].Value = dataObject.Case; command.Parameters["@Subarea"].Value = dataObject.Subarea; command.Parameters["@Id"].Value = dataObject.Id; try { int rowsAffected = command.ExecuteNonQuery(); } catch { DataBaseManager.DbConnection.Close(); throw; } DataBaseManager.DbConnection.Close(); } if (isNew) { int id; query = string.Format("SELECT Max(Id) FROM {0}", table); reader = DataBaseManager.ReadData(query); reader.Read(); id = Convert.ToInt32(reader.GetValue(0)); DataBaseManager.DbConnection.Close(); return(id); } else { return(-1); } }
public HydroPlantViewModel(HydroPlant plant) { this.plant = plant; }