static void Main(string[] args)
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ODBCDataConnectionString"].ConnectionString;
Program.da = new SqlServerAccesssODBC(connectionString);
Persona oPersona = new Persona(9, "Carlos", "Cadtro");
Persona.Truncate();
oPersona.Save();
oPersona.id = 1;
oPersona.nombre = "Edwin";
oPersona.apellidos = "Jimenez";
oPersona.Save();
oPersona.Delete();
DataTable result = Persona.Select();
foreach (DataRow item in result.Rows)
{
Console.WriteLine("------------------------");
Console.WriteLine(item["Nombre"]);
Console.WriteLine(item["Apellidos"]);
Console.WriteLine("------------------------");
}
Console.ReadLine();
}
public void delete(string ID)
{
using (DBAccess.DBAccess db = new DBAccess.DBAccess())
{
string[,] param = {
{"@ID", ID}
};
db.ExecuteNonQuery("sprDeleteCustomer", param);
}
}
static void Main()
{
Application.EnableVisualStyles();
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Pg"].ConnectionString;
Program.da = new PgAccess(connectionString);
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
}
public void add(ModelCustomer MC)
{
using (DBAccess.DBAccess db = new DBAccess.DBAccess())
{
string[,] param = {
{"@NAME", MC.Name},
{"@ADDRESS", MC.Address}
};
db.ExecuteNonQuery("sprInsertCustomer", param);
}
}
public BacktestEngine(EWrapperImpl wrapper, DBAccess.DBAccess db, XmlNode config)
{
_wrapper = wrapper;
_db = db;
_tm = ThreadManager.instance;
lock (_lock)
{
_wrapper.nextOrderId = DBAccess.DBAccess.instance.getMaxOrderId() + 1;
}
_config = config;
_account = config["Account"].InnerText;
_startDate = DateTime.Parse(config["StartDate"].InnerText);
string endDateStr = config["EndDate"].InnerText;
if (endDateStr == "Today")
{
_endDate = DateTime.Today;
}
else
{
_endDate = DateTime.Parse(endDateStr);
}
_barType = config["BarType"].InnerText;
_minBarSize = Int32.Parse(config["MinBarSize"].InnerText);
_slippage = Int32.Parse(config["Slippage"].InnerText);
_limitIncludeTouch = Boolean.Parse(config["LimitIncludeTouch"].InnerText);
_source = config["MarketDataSource"].InnerText;
_reportFolder = config["ReportFolder"].InnerText;
_interval = new TimeSpan(0, 0, _minBarSize);
_mktData = new Dictionary <int, Bar[]>();
_currMktIndices = new Dictionary <int, int>();
_barIds = new List <int>();
_barTickerMap = new Dictionary <int, int>();
_tickTickerMap = new Dictionary <int, int>();
_mktTimeZoneMap = new Dictionary <int, TimeZoneInfo>();
_contractBarMap = new Dictionary <int, int>();
_orderContractMap = new Dictionary <int, Contract>();
_barSlippageMap = new Dictionary <int, double>();
_currTime = _startDate;
_currd = _currTime.Date;
_liveOrders = new SortedDictionary <int, Order>();
_ocaGroups = new Dictionary <string, List <int> >();
_childOrders = new Dictionary <int, List <int> >();
_executions = new SortedDictionary <int, Execution>();
_timeEventHandlers = new SortedDictionary <int, List <onTime> >();
_timeEventRefreshed = new Dictionary <int, bool>();
_isDone = new Dictionary <int, bool>();
_sleepId = 0;
_sleepEvents = new Dictionary <int, AutoResetEvent>();
_nextBarEvent = new ManualResetEvent(true);
}
public ModelCustomer getCustomerByID(string ID)
{
using (DBAccess.DBAccess db = new DBAccess.DBAccess())
{
string[,] param = { { "@Id", ID } };
using (SqlDataReader rdr = db.ExecuteReader("sprSelectCustomerByID", param))
{
ModelCustomer item = new ModelCustomer();
while (rdr.Read())
{
item.Id = Convert.ToInt32(rdr["Id"]);
item.Name = rdr["Name"].ToString();
item.Address = rdr["Address"].ToString();
}
return item;
}
}
}
public DataTable getAllCustomer(string strWhere, string strOrderBy)
{
using (DBAccess.DBAccess db = new DBAccess.DBAccess())
{
if (strOrderBy == "") { strOrderBy = " ORDER BY Id"; }
string[,] param = {
{ "@strWhere", strWhere },
{ "@strOrderBy", strOrderBy }
};
using (SqlDataReader rdr = db.ExecuteReader("sprSelectAllCustomer", param))
{
DataTable DT = new DataTable();
DT.Load(rdr);
return DT;
}
}
}
public int updateFlag(string ID)
{
using (DBAccess.DBAccess db = new DBAccess.DBAccess())
{
string[,] param = { { "@ID", ID } };
int UpdateFlag = Convert.ToInt32(db.ExecuteScalar("sprCustomerFlag", param));
return UpdateFlag;
}
}
public void update(ModelCustomer MC)
{
using (DBAccess.DBAccess db = new DBAccess.DBAccess())
{
string[,] param = {
{"@ID", MC.Id.ToString()},
{"@NAME", MC.Name},
{"@ADDRESS", MC.Address}
};
db.ExecuteNonQuery("sprUpdateCustomer", param);
}
}
static void Main()
{
DBAccess db = DBUtils.getDB();
//Console.WriteLine(db.getNextEventTime("EIA Report", new DateTime(2018,1,1)));
//DBUtils.createAllTables();
//Console.WriteLine(db.getContract(8991549).Symbol);
//Console.WriteLine(db.getModelParameters(1, new DateTime(2015,12,4)));
//DataTable dt = db.getHistoricalData(1, new DateTime(2013, 1, 1), new DateTime(2015, 1, 1), "close");
//for(int i=0; i < dt.Rows.Count; ++i)
//{
// for (int j = 0; j < dt.Columns.Count; ++j)
// Console.Write(dt.Rows[i][j].ToString() + "\t");
// Console.WriteLine();
//}
//string xml = File.ReadAllText(getXmlPath("model_parameters.xml"));
//db.runNonQuery("insert into model_parameters values (2, 1, '2015-12-02', '" + xml + "')");
//db.createCombos();
//db.createOrders();
//db.createContracts();
//db.createCommissions();
//db.createExecutions();
//db.createAccounts();
//db.createStrategies();
//db.createModelParameters();
//db.createPositions();
//db.createErrors();
//db.createSystemLog();
//db.createEvents();
//db.createNearbyContracts();
//String query = @"select * from test";
//DataTable dt = db.runQuery(query);
//Console.WriteLine("Hello");
//Console.WriteLine(dt.ToString());
//String model_xml = File.ReadAllText(getXmlPath("modelPairStatArb.xml"));
//int model_id = db.addModel(-1, "Test IWM/IWB Pair Stat Arb", model_xml, "Testing Russells Pair Trading 100/0.01");
//List<string> ret = db.getStrategyInfo(1);
//List<Contract> ret = db.getPairContracts(-1);
//Console.WriteLine(ret[0].ToString());
//Console.WriteLine(ret[1].ToString());
//String model_xml = File.ReadAllText(getXmlPath("modelFixedReversion.xml"));
//int model_id = db.addModel(-1, "BT_Settlement_Reversion", model_xml, "Brent Settlement Reversion");
//String strategy_xml = File.ReadAllText(getXmlPath("strategyFixedReversion.xml"));
//db.addStrategy("Fixed", "BT_Settlement_Reversion", strategy_xml, "Brent Settlement Reversion");
//String strategy_xml = File.ReadAllText(getXmlPath("RussellsDailyDownloader.xml"));
//db.addStrategy("MarketDataDownloader", "Russells_100d_100d", strategy_xml, "Russells family 100D daily data");
//String strategy_xml = File.ReadAllText(getXmlPath("BrentDataDownloader.xml"));
//db.addStrategy("MarketDataDownloader", "BD_201609_60_7d", strategy_xml, "Brent Sep - Nov 2016 1 min 7d download");
//String strategy_xml = File.ReadAllText(getXmlPath("BrentNearbyDataDownloader_Dec14-Nov15.xml"));
//db.addStrategy("MarketDataDownloader", "BD_Dec14-Nov15Contracts_60_120d", strategy_xml, "Brent multi contracts multi endDates ");
//String strategy_xml = File.ReadAllText(getXmlPath("XAUUSDDownloader.xml"));
//db.addStrategy("MarketDataDownloader", "XAUUSD-1Min-16D-endingToday", strategy_xml, "XAUUSD spot gold 16D ending Today");
//String strategy_xml = File.ReadAllText(getXmlPath("NZDUSDDownloader.xml"));
//db.addStrategy("MarketDataDownloader", "NZDUSD-1Min-1500D-ending20161130", strategy_xml, "NZDUSD spot 1500D ending 20161122");
//String strategy_xml = File.ReadAllText(getXmlPath("SGXDataDownloader.xml"));
//db.addStrategy("MarketDataDownloader", "SGX_201609_60_7d", strategy_xml, "SGX Futures Sep 2016 1 min 7d download");
//String model_xml = File.ReadAllText(getXmlPath("modelEventReversion.xml"));
//int model_id = db.addModel(-1, "EIA", model_xml, "Brent EIA Event");
//String strategy_xml = File.ReadAllText(getXmlPath("strategyEventReversion.xml"));
//db.addStrategy("EventReversion", "EIA", strategy_xml, "Brent EIA Event");
//String model_xml = File.ReadAllText(getXmlPath("modelSgxSwitch.xml"));
//int model_id = db.addModel(134421928, "STW_201609", model_xml, "STW 201609 SGX Switch");
//String strategy_xml = File.ReadAllText(getXmlPath("strategySgxSwitch.xml"));
//db.addStrategy("SgxSwitch", "STW_201609", strategy_xml, "STW 201609 SGX Switch");
//nearby contract example usage
//int conId = db.addNearbyContract("COIL", "FUT", "IPE", "ICE Brent Crude Nearby_1 Roll_2d");
//db.setNearbyContractSchedule(conId, 1, 2); //create nearby1 synthetic contract, where indexoffset = 2, i.e roll 2 days before actual expiry
//int barId = db.addBarDataId(conId, "trades", 60, "IB", "");
//db.exportBarsToFile(barId, new DateTime(2016, 9, 15), new DateTime(2016, 10, 15), getMktDataPath("test"));
//DBUtils.generatePnLReport("MyAccount", new DateTime(2016, 12, 1), DateTime.Today, "C:\\MyReportFolder");
}