public void Update(int idCriterio, String criterio, String tipoOpcion)
{
try
{
String query = String.Format("UPDATE xCNBVCriterios SET Criterio = '{0}', TipoOpcion = '{2}' WHERE IDCriterio = {1}", criterio, idCriterio, tipoOpcion);
DataBaseSettings db = new DataBaseSettings();
db.ExecuteQuery(query);
} catch (Exception ex)
{
throw ex;
}
}
public void Insert()
{
try
{
String query = String.Format("INSERT INTO xCNBVCriterios (Criterio, TipoOpcion) VALUES ('{0}', '{1}')", criterio, tipoOpcion);
DataBaseSettings db = new DataBaseSettings();
db.ExecuteQuery(query);
} catch (Exception ex)
{
throw ex;
}
}
public void Delete(int idCriterio)
{
try
{
String query = String.Format("DELETE xCNBVCriterios WHERE IDCriterio = {0}", idCriterio);
DataBaseSettings db = new DataBaseSettings();
db.ExecuteQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}