public static bool WriteWebFeedToDB_ForexFactory_com()
{
XDocument feed = XDocument.Load(ConfigurationSettings.AppSettings["WebFeed_ForexFactory_com"]);
FXEventsDataContext fxdc = new FXEventsDataContext();
var feedpost = from post in feed.Descendants("event")
select new fxevent_staging
{
name = post.Element("title").Value,
next_date = DateTime.Parse(post.Element("date").Value),
next_time = TimeSpan.Parse(post.Element("time").Value),
recurring = 1,
watch = 0,
importance = (post.Element("impact").Value) == "Medium" ? (short)2 : (short)1,
previous = Convert.ToDecimal(post.Element("previous").Value),
currency = post.Element("country").Value
};
fxdc.fxevent_stagings.InsertAllOnSubmit(feedpost);
fxdc.SubmitChanges();
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
NameValueCollection coll = new NameValueCollection(Request.Form);
FXEventsDataContext fxdc = new FXEventsDataContext();
String[] aEvtids;
switch (coll["a"])
{
case "getFXEvents":
IEnumerable <fxevent> fxevents = from fxe in fxdc.fxevents
select fxe;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("fxevents", fxevents, "templates/fxevent.xslt").ToString());
break;
case "getFXEventsAddFormRow":
IEnumerable <fxevent> fxeventform = from fxe in fxdc.fxevents
select fxe;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("fxevents", fxeventform, "templates/fxevent_add.xslt").ToString());
break;
case "getFXEventsSelect":
IEnumerable <fxevent> fxevents_select = from fxe in fxdc.fxevents
select fxe;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("fxevents", fxevents_select, "templates/fxevent_select.xslt").ToString());
break;
case "delFXEvents":
aEvtids = ((String)coll["evtids"]).Split();
var fxevents_deleted = from fxe in fxdc.fxevents where aEvtids.Contains(fxe.eventid)
select fxe;
fxdc.fxevents.DeleteAllOnSubmit(fxevents_deleted);
try
{
fxdc.SubmitChanges();
Response.Write("Successfully deleted records.");
}
catch (Exception ex)
{
Response.Write(ex);
// Provide for exceptions.
}
break;
case "updateFXEvent":
break;
case "addFXEvent":
fxevent fxevt = new fxevent();
fxevt.currency = coll["curr"];
fxevt.eventid = coll["eventid"];
fxevt.importance = Convert.ToInt16(coll["importance"]);
fxevt.name = coll["name"];
fxevt.next_date = Convert.ToDateTime(coll["next_date"]);
//fxevt.next_time = Convert.ToDateTime(coll["next_time"]);
fxevt.previous = Convert.ToDecimal(coll["previous"]);
fxevt.recurring = Convert.ToByte(coll["recurring"]);
fxevt.watch = Convert.ToByte(coll["watch"]);
fxdc.fxevents.InsertOnSubmit(fxevt);
fxdc.SubmitChanges();
Response.Write("Adding " + fxevt.eventid + " (" + fxevt.name + "). Err No: " + fxevt.err_no + ", Err Desc: " + fxevt.err_desc);
break;
case "getFXEventAliases":
IEnumerable <fxevent_alias> fxevent_aliases = from fxe in fxdc.fxevent_alias
select fxe;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("fxevent_aliases", fxevent_aliases, "templates/fxevent_alias.xslt").ToString());
break;
case "getFXEventAliasesAddFormRow":
IEnumerable <fxevent_alias> fxevent_aliasform = from fxe in fxdc.fxevent_alias
select fxe;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("fxevent_aliases", fxevent_aliasform, "templates/fxevent_alias_add.xslt").ToString());
break;
case "delFXEventAliases":
aEvtids = ((String)coll["evtids"]).Split();
var fxevent_aliases_deleted = from fxe in fxdc.fxevent_alias where aEvtids.Contains(fxe.id.ToString())
select fxe;
fxdc.fxevent_alias.DeleteAllOnSubmit(fxevent_aliases_deleted);
try
{
fxdc.SubmitChanges();
Response.Write("Successfully deleted records.");
}
catch (Exception ex)
{
Response.Write(ex);
// Provide for exceptions.
}
break;
case "updateFXEventAlias":
break;
case "addFXEventAlias":
fxevent_alias fxevtals = new fxevent_alias();
fxevtals.eventid = coll["eventid"];
fxevtals.alias_name = coll["name"];
fxdc.fxevent_alias.InsertOnSubmit(fxevtals);
fxdc.SubmitChanges();
Response.Write("Adding " + fxevtals.eventid + " (" + fxevtals.alias_name + "). Err No: " + fxevtals.err_no + ", Err Desc: " + fxevtals.err_desc);
break;
case "getCurrencies":
IEnumerable <currency> currency = from fxc in fxdc.currencies
select fxc;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("currencies", currency, "templates/currency.xslt").ToString());
break;
case "getCurrenciesAddFormRow":
IEnumerable <currency> currencyform = from fxc in fxdc.currencies
select fxc;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("currencies", currencyform, "templates/currency_add.xslt").ToString());
break;
case "getCurrencySelect":
IEnumerable <currency> currencyselect = from fxc in fxdc.currencies orderby fxc.currencyid
select fxc;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("currencies", currencyselect, "templates/currency_select.xslt").ToString());
break;
case "addCurrency":
currency fxcurr = new currency();
fxcurr.currencyid = coll["curr"];
fxcurr.name = coll["name"];
fxdc.currencies.InsertOnSubmit(fxcurr);
fxdc.SubmitChanges();
Response.Write("Adding " + fxcurr.currencyid + " (" + fxcurr.name + "). Err No: " + fxcurr.err_no + ", Err Desc: " + fxcurr.err_desc);
break;
case "getCurrencyPairs":
IEnumerable <currencypair> currencypair = from fxc in fxdc.currencypairs
select fxc;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("currencypairs", currencypair, "templates/currencypair.xslt").ToString());
break;
case "getCurrencyPairsAddFormRow":
IEnumerable <currencypair> currencypairform = from fxc in fxdc.currencypairs
select fxc;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("currencypairs", currencypairform, "templates/currencypair_add.xslt").ToString());
break;
case "getCurrencyPairSelect":
IEnumerable <currencypair> currencypairselect = from fxc in fxdc.currencypairs
select fxc;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("currencypairs", currencypairselect, "templates/currencypair_select.xslt").ToString());
break;
case "addCurrencyPair":
currencypair fxcurrpair = new currencypair();
fxcurrpair.@base = coll["base"];
fxcurrpair.quote = coll["quote"];
fxcurrpair.lastmodified = DateTime.Now;
fxdc.currencypairs.InsertOnSubmit(fxcurrpair);
fxdc.SubmitChanges();
Response.Write("Adding " + fxcurrpair.@base + "/" + fxcurrpair.quote + ". Err No: " + fxcurrpair.err_no + ", Err Desc: " + fxcurrpair.err_desc);
break;
case "getFXEventsStaging":
IEnumerable <fxevent_staging> fxstagedevents = from fxe in fxdc.fxevent_stagings
select fxe;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("fxevents_staging", fxstagedevents, "templates/fxevent_staging.xslt").ToString());
break;
case "getFXEventAliasesSelect":
IEnumerable <fxevent_alias> fxeventaliasselect = from fxe in fxdc.fxevent_alias
select fxe;
Response.Write(FXTransforms.Linq2SQL_XSLTransform("fxevent_aliases", fxeventaliasselect, "templates/fxevent_alias_select.xslt").ToString());
break;
case "downloadFXEventsStagingFeed":
Response.Write(FXTransforms.WriteWebFeedToDB_ForexFactory_com());
break;
default:
// Do nothing.
Response.Write("Nothing to see here...");
break;
}
}