public static XmlDocument AllInstruments()
{
var crit = new CRITERIA(0, 0, 0, 0);
//crit.INSTATTRIBUTESDATA = "All"; @@@ not working maybe wrong GV version?
crit.INSTDEFINITIONS = "All";
return XmlHandler.SerializeToXml(crit);
}
public static void test_query1()
{
var crit = new CRITERIA();
crit.TRADES = new TradeQuery[2];
crit.TRADES[0] = new TradeQuery();
crit.TRADES[1] = new TradeQuery();
crit.TRADES[0].INITTRADERCOMPANY = "My";
crit.TRADES[1].AGGTRADERCOMPANY = "My";
//crit.TRADES[0].INITTRADER = TP_SetupData.Traders["Tobias Hufschmidt"].ToString();
//crit.TRADES[1].AGGTRADER = TP_SetupData.Traders["Tobias Hufschmidt"].ToString();
// @@@ make constructor! better and save initating every object
crit.TRADES[0].LASTUPDATE = new LastUpdateQuery();
crit.TRADES[1].LASTUPDATE = new LastUpdateQuery();
crit.TRADES[0].LASTUPDATE.From = new DateTime(2016, 5, 09).ToString("s", System.Globalization.CultureInfo.InvariantCulture);
crit.TRADES[1].LASTUPDATE.From = new DateTime(2016, 5, 09).ToString("s", System.Globalization.CultureInfo.InvariantCulture);
XmlDocument query = XmlHandler.SerializeToXml(crit);
string fileName = Path.Combine(Settings.Instance.FilePath.LogFilePath, "QUERY_Test.log");
XmlHandler.Save2Log(query.OuterXml, fileName);
if (!Settings.Instance.Gateway.LoggedIn) GatewayAPI.Instance.Login();
var data = GatewayAPI.Instance.QueryXMLRecordSet(query);
fileName = Path.Combine(Settings.Instance.FilePath.DataFilePath, "DATA_Test.log");
XmlHandler.Save2Log(data, fileName);
}
//Returns a JSON with requested criteria but also returns other parent or child criteria. R
// Requested criteria is always at the end of JSON
public IHttpActionResult GetCriteria(long id)
{
CRITERIA cRITERIA = db.CRITERIA.Find(id);
if (cRITERIA == null)
{
return(NotFound());
}
return(Ok(cRITERIA));
}
public IHttpActionResult UpdateCriteria(long id, CRITERIA cRITERIA)
{
if (HttpContext.Current.Request.Cookies.AllKeys.Contains("sid"))
{
try {
response = identity.Auth(HttpContext.Current.Request.Cookies.Get("sid").Value);
}
catch {
return(BadRequest("Invalid token. Login in again!"));
}
if (!response.Roles.Contains("ADMIN"))
{
return(BadRequest("You are not authorized for this action"));
}
}
else
{
return(BadRequest("You are not logged in. Please login and try again."));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != cRITERIA.ID_CRITERIA)
{
return(BadRequest("id doesn't match"));
}
cRITERIA.DATE_MODIFIED = DateTime.Now;
db.Entry(cRITERIA).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CRITERIAExists(id))
{
return(NotFound());
}
}
return(Ok(cRITERIA));
}
public IHttpActionResult PostCriteria(CRITERIA cRITERIA)
{
if (HttpContext.Current.Request.Cookies.AllKeys.Contains("sid"))
{
try
{
response = identity.Auth(HttpContext.Current.Request.Cookies.Get("sid").Value);
}
catch
{
return(BadRequest("Invalid token. Login in again!"));
}
if (!response.Roles.Contains("ADMIN"))
{
return(BadRequest("You are not authorized for this action"));
}
}
else
{
return(BadRequest("You are not logged in. Please login and try again."));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
cRITERIA.DATE_CREATED = DateTime.Now;
db.CRITERIA.Add(cRITERIA);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (CRITERIAExists(cRITERIA.ID_CRITERIA))
{
return(Conflict());
}
}
return(Ok(cRITERIA));
}
public IHttpActionResult DeleteCRITERIA(long id)
{
if (HttpContext.Current.Request.Cookies.AllKeys.Contains("sid"))
{
try
{
response = identity.Auth(HttpContext.Current.Request.Cookies.Get("sid").Value);
}
catch
{
return(BadRequest("Invalid token. Login in again!"));
}
if (!response.Roles.Contains("ADMIN"))
{
return(BadRequest("You are not authorized for this action"));
}
}
else
{
return(BadRequest("You are not logged in. Please login and try again."));
}
CRITERIA cRITERIA = db.CRITERIA.Find(id);
foreach (CRITERIA c in db.CRITERIA)
{
if (c.PARENT_CRITERIA == id)
{
return(BadRequest("Cannot delete because criteria has subcriteria!"));
}
}
if (cRITERIA == null)
{
return(NotFound());
}
db.CRITERIA.Remove(cRITERIA);
db.SaveChanges();
return(Ok(cRITERIA));
}
public static XmlDocument CurrentTrades(string traderName, string companyName, DateTime fromDate, DateTime toDate)
{
string userID = traderName;
if (userID != "My" && userID != "All") userID = TP_SetupData.Traders[traderName].ToString();
string companyID = companyName;
if (companyID != "My" && companyID != "All") companyID = TP_SetupData.Companies[companyName].ToString();
var crit = new CRITERIA(0, 0, 2, 0);
crit.TRADES[0].INITTRADER = userID;
crit.TRADES[1].AGGTRADER = userID;
crit.TRADES[0].INITTRADERCOMPANY = companyID;
crit.TRADES[1].AGGTRADERCOMPANY = companyID;
crit.TRADES[0].LASTUPDATE = new LastUpdateQuery();
crit.TRADES[1].LASTUPDATE = new LastUpdateQuery();
crit.TRADES[0].LASTUPDATE.From = fromDate.ToString("s", System.Globalization.CultureInfo.InvariantCulture);
crit.TRADES[0].LASTUPDATE.Until = toDate.ToString("s", System.Globalization.CultureInfo.InvariantCulture);
crit.TRADES[1].LASTUPDATE.From = fromDate.ToString("s", System.Globalization.CultureInfo.InvariantCulture);
crit.TRADES[1].LASTUPDATE.Until = toDate.ToString("s", System.Globalization.CultureInfo.InvariantCulture);
return XmlHandler.SerializeToXml(crit);
}
public static XmlDocument HistTrades(string traderName, string companyName, string brokerName, DateTime fromDate, DateTime toDate)
{
// @@@ not used as GV 8.8 does not support HISTORICALTRADES ... if we get there add brokers and other stuff
string userID = traderName;
if (userID != "My" && userID != "All") userID = TP_SetupData.Traders[traderName].ToString();
string companyID = companyName;
if (companyID != "My" && companyID != "All") companyID = TP_SetupData.Companies[companyName].ToString();
var crit = new CRITERIA(0, 0, 0, 2);
crit.HISTORICALTRADES[0].INITTRADER = userID;
crit.HISTORICALTRADES[1].AGGTRADER = userID;
crit.HISTORICALTRADES[0].INITTRADERCOMPANY = companyID;
crit.HISTORICALTRADES[1].AGGTRADERCOMPANY = companyID;
crit.HISTORICALTRADES[0].LASTUPDATE = new LastUpdateQuery();
crit.HISTORICALTRADES[1].LASTUPDATE = new LastUpdateQuery();
crit.HISTORICALTRADES[0].LASTUPDATE.From = fromDate.ToString("s", System.Globalization.CultureInfo.InvariantCulture);
crit.HISTORICALTRADES[0].LASTUPDATE.Until = toDate.ToString("s", System.Globalization.CultureInfo.InvariantCulture);
crit.HISTORICALTRADES[1].LASTUPDATE.From = fromDate.ToString("s", System.Globalization.CultureInfo.InvariantCulture);
crit.HISTORICALTRADES[1].LASTUPDATE.Until = toDate.ToString("s", System.Globalization.CultureInfo.InvariantCulture);
return XmlHandler.SerializeToXml(crit);
}
public static XmlDocument AllUsersAndCompanies()
{
var crit = new CRITERIA(0, 1, 0, 0);
crit.COMPANIES = "All";
return XmlHandler.SerializeToXml(crit);
}
