public static void DeleteCorteLinea(CorteLinea CorteLinea) { string query = string.Format("DELETE FROM {0} " + "WHERE nombre = {1} " + "AND Sentido = {2}", table, CorteLinea.Name, CorteLinea.Sentido); DataBaseManager.ExecuteQuery(query); }
public static void UpdateCorteLinea(CorteLinea CorteLinea) { string query = string.Format("UPDATE {0} SET " + "Linea = @Linea, " + "WHERE nombre = @Name AND " + "Sentido = @Sentido", table); using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection)) { command.Parameters.Add("@Linea", OleDbType.VarChar); command.Parameters.Add("@Name", OleDbType.VarChar); command.Parameters.Add("@Sentido", OleDbType.Numeric); DataBaseManager.DbConnection.Open(); command.Parameters["@Linea"].Value = CorteLinea.Linea; command.Parameters["@Name"].Value = CorteLinea.Name; command.Parameters["@Sentido"].Value = CorteLinea.Sentido; int rowsAffected = command.ExecuteNonQuery(); DataBaseManager.DbConnection.Close(); } }
public CorteLineaViewModel(CorteLinea CorteLinea) : base() { this.CorteLinea = CorteLinea; }