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;
}
