List<Tuple<string, DateTime>> MakeNewRequestList()
{
using (var db = new SymsEntities())
{
var ddExps = new List<DateTime>();
var dtNow = DateTime.Today;
IEnumerable<string> syms = db.GroupSymbols.Where(v => v.groupName == ListName).Select(v => v.symbol);
for (var i = 0; i < _fwdMonths; ++i)
{
ddExps.Add(dtNow);
dtNow = dtNow.AddMonths(1);
}
return (from s in syms from exp in ddExps select new Tuple<string, DateTime>(s, exp)).ToList();
}
}
AOption.ESecType GetSecType()
{
using (var db = new SymsEntities())
{
var secType =
(db.GroupParams.Where(v => v.groupName == ListName && v.paramName == "SEC_TYPE")
.Select(v => v.paramValue)).Single();
return (secType == "Equity") ? AOption.ESecType.Equity : AOption.ESecType.Index;
}
}