public JsonResult Search(JQueryDataTablesModel jQueryDataTablesModel)
{
int totalRecordCount;
int searchRecordCount;
var customers = InMemoryCategoryRepository.GetCategories(startIndex: jQueryDataTablesModel.iDisplayStart,
pageSize: jQueryDataTablesModel.iDisplayLength, sortedColumns: jQueryDataTablesModel.GetSortedColumns(),
totalRecordCount: out totalRecordCount, searchRecordCount: out searchRecordCount, searchString: jQueryDataTablesModel.sSearch);
return(Json(new JQueryDataTablesResponse <Category>(items: customers,
totalRecords: totalRecordCount,
totalDisplayRecords: searchRecordCount,
sEcho: jQueryDataTablesModel.sEcho)));
}
public void WeightTest()
{
var categoryRepository = new InMemoryCategoryRepository();
var category = categoryRepository.GetCategory("Security");
var category2 = categoryRepository.GetCategory("Currency");
var securityRepository = new InMemorySecurityRepository();
var security = securityRepository.GetOrCreate("TSX", "XSB");
var security2 = securityRepository.GetOrCreate("NASDAQ", "MSFT");
using (var tokenManager = new QuestradeApiTokenManager(new Configuration()))
{
var api = new QuestradeService(tokenManager, securityRepository, categoryRepository);
var weights = api.GetWeights(category, security);
weights = api.GetWeights(category, security);
weights = api.GetWeights(category, security2);
weights = api.GetWeights(category2, security);
weights = api.GetWeights(category2, security2);
}
}
private static ErrorCode QuickQuestradeWeightReportOperation(string portfolioName)
{
var portfolio = new Portfolio
{
Name = portfolioName
};
var categoryRepository = new InMemoryCategoryRepository();
var securityRepo = new InMemorySecurityRepository();
var securityCategory = categoryRepository.GetCategory("Security");
var currencyCategory = categoryRepository.GetCategory("Currency");
var assetAllocationCategory = categoryRepository.GetCategory("AssetAllocation");
using (var tokenManager = new QuestradeApiTokenManager(Configuration))
{
var api = new QuestradeService(tokenManager, securityRepo, categoryRepository);
portfolio.Accounts = api.GetAccounts();
var morningstar = new MorningstarService(new Scraper(), securityRepo, categoryRepository);
var weights = new List <CategoryWeight>();
foreach (var account in portfolio.Accounts)
{
account.Positions = api.GetPositions(account);
foreach (var position in account.Positions)
{
weights.AddRange(morningstar.GetWeights(assetAllocationCategory, position.Security));
//weights.AddRange(api.GetWeights(securityCategory, position.Security));
//weights.AddRange(api.GetWeights(currencyCategory, position.Security));
}
}
var reporter = new StringWeightReporter(api);
var report = reporter.GetReport(portfolio, new[] { assetAllocationCategory }, weights.Distinct());
Console.Write(report);
}
return(ErrorCode.NoError);
}
protected override void Seed(VideoGameBlog.Data.EntityFramework.InitDbContext context)
{
var userMgr = new UserManager <BlogUser>(new UserStore <BlogUser>(context));
var roleMgr = new RoleManager <BlogRole>(new RoleStore <BlogRole>(context));
if (!roleMgr.RoleExists("Admin"))
{
roleMgr.Create(new BlogRole()
{
Name = "Admin"
});
}
if (!roleMgr.RoleExists("Marketing"))
{
roleMgr.Create(new BlogRole()
{
Name = "Marketing"
});
}
if (!roleMgr.RoleExists("Disabled"))
{
roleMgr.Create(new BlogRole()
{
Name = "Disabled"
});
}
// create the default user
var admin = new BlogUser()
{
UserName = "******",
Email = "*****@*****.**",
PhoneNumber = "1111111111"
};
var marketing = new BlogUser()
{
UserName = "******",
Email = "*****@*****.**",
PhoneNumber = "2222222222"
};
var disabled = new BlogUser()
{
UserName = "******",
Email = "*****@*****.**",
PhoneNumber = "3333333333"
};
// create the user with the manager class
if (userMgr.FindByName(admin.UserName) == null)
{
userMgr.Create(admin, "corndog123");
}
if (userMgr.FindByName(marketing.UserName) == null)
{
userMgr.Create(marketing, "corndog123");
}
if (userMgr.FindByName(disabled.UserName) == null)
{
userMgr.Create(disabled, "corndog123");
}
// add the user to the admin role
userMgr.AddToRole(admin.Id, "Admin");
userMgr.AddToRole(marketing.Id, "Marketing");
userMgr.AddToRole(disabled.Id, "Disabled");
InMemoryCategoryRepository catRepo = new InMemoryCategoryRepository();
foreach (var c in catRepo.GetAll())
{
context.Categories.AddOrUpdate(c);
context.SaveChanges();
}
InMemoryTagRepository tagRepo = new InMemoryTagRepository();
foreach (var t in tagRepo.GetAll())
{
context.Tags.AddOrUpdate(t);
context.SaveChanges();
}
InMemoryStaticPageRepository statRepo = new InMemoryStaticPageRepository();
foreach (var s in statRepo.GetAll())
{
context.StaticPages.AddOrUpdate(s);
context.SaveChanges();
}
InMemoryPostRepository postRepo = new InMemoryPostRepository();
foreach (var p in postRepo.GetAll())
{
context.Posts.AddOrUpdate(p);
context.SaveChanges();
}
}
