public static void DeleteObject(VariableHydroPlant dataObject) { string query = string.Format("DELETE FROM {0} " + "WHERE Id = {1}", table, dataObject.Id); DataBaseManager.ExecuteQuery(query); }
public VariableHydroPlantViewModel(VariableHydroPlant variableHydroPlant) { this.variableHydroPlant = variableHydroPlant; }
public VariableHydroPlantViewModel() { variableHydroPlant = new VariableHydroPlant(); Case = 1; Segment = 1; }
public static int UpdateObject(VariableHydroPlant dataObject) { bool isNew = false; string query = string.Format("SELECT Recurso " + "FROM {0} " + "WHERE Id = {1}", table, dataObject.Id); OleDbDataReader reader = DataBaseManager.ReadData(query); if (!reader.Read()) { query = string.Format("INSERT INTO {0}(Recurso, Embalse, Segmento, Volumen, FactorConversion, GeneracionMaxima, Escenario) " + "VALUES(@Name, @Reservoir, @Segment, @Level, @ProductionFactor, @Max, @Case)", table); isNew = true; } else { query = string.Format("UPDATE {0} SET " + "Recurso = @Name, " + "Embalse = @Reservoir, " + "Segmento = @Segment, " + "Volumen = @Level, " + "FactorConversion = @ProductionFactor, " + "GeneracionMaxima = @Max, " + "escenario = @Case " + "WHERE Id = @Id", table); } DataBaseManager.DbConnection.Close(); using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection)) { command.Parameters.Add("@Name", OleDbType.VarChar); command.Parameters.Add("@Reservoir", OleDbType.VarChar); command.Parameters.Add("@Segment", OleDbType.Numeric); command.Parameters.Add("@Level", OleDbType.Numeric); command.Parameters.Add("@ProductionFactor", OleDbType.Numeric); command.Parameters.Add("@Max", OleDbType.Numeric); command.Parameters.Add("@Case", OleDbType.Numeric); command.Parameters.Add("@Id", OleDbType.Numeric); DataBaseManager.DbConnection.Open(); command.Parameters["@Name"].Value = dataObject.Name; command.Parameters["@Reservoir"].Value = dataObject.Reservoir; command.Parameters["@Segment"].Value = dataObject.Segment; command.Parameters["@Level"].Value = dataObject.Level; command.Parameters["@ProductionFactor"].Value = dataObject.ProductionFactor; command.Parameters["@Max"].Value = dataObject.Max; command.Parameters["@Case"].Value = dataObject.Case; 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); } }