Beispiel #1
0
        public static void UpdatePeriodicArea(PeriodicArea periodicArea)
        {
            string query = string.Format("UPDATE {0} SET " +
                                         "Demanda = @Load, " +
                                         "limiteImportacion = @ImportationLimit, " +
                                         "limiteExportacion = @ExportationLimit " +
                                         "WHERE nombre = @Name AND " +
                                         "periodo = @Period", table);

            using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection))
            {
                command.Parameters.Add("@Load", OleDbType.Numeric);
                command.Parameters.Add("@ImportationLimit", OleDbType.Numeric);
                command.Parameters.Add("@ExportationLimit", OleDbType.Numeric);
                command.Parameters.Add("@Name", OleDbType.VarChar);
                command.Parameters.Add("@Period", OleDbType.Numeric);

                DataBaseManager.DbConnection.Open();

                command.Parameters["@Load"].Value             = periodicArea.Load;
                command.Parameters["@ImportationLimit"].Value = periodicArea.ImportationLimit;
                command.Parameters["@ExportationLimit"].Value = periodicArea.ExportationLimit;
                command.Parameters["@Name"].Value             = periodicArea.Name;
                command.Parameters["@Period"].Value           = periodicArea.Period;

                int rowsAffected = command.ExecuteNonQuery();

                DataBaseManager.DbConnection.Close();
            }
        }
Beispiel #2
0
        public static void DeletePeriodicArea(PeriodicArea periodicArea)
        {
            string query = string.Format("DELETE FROM {0} " +
                                         "WHERE nombre = '{1}' " +
                                         "AND Periodo = {2}",
                                         table, periodicArea.Name, periodicArea.Period);

            DataBaseManager.ExecuteQuery(query);
        }
Beispiel #3
0
 public PeriodicAreaViewModel(PeriodicArea periodicArea) : base(periodicArea)
 {
     this.periodicArea = periodicArea;
 }