public ActionResult Index()
{
HomeIndexViewModel model = new HomeIndexViewModel();
var db = new EvalDataContext();
var user = db.Users.Where(u=>u.UserName == User.Identity.Name).FirstOrDefault();
if (user != null)
model.IsSubAccount = user.IsSubAccount.GetValueOrDefault(false);
return View(model);
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
AuthConfig.RegisterAuth();
// If you want Entity Framework to drop and regenerate your database
// automatically whenever you change your model schema, add the following
// code to the Application_Start method in your Global.asax file.
// Note: this will destroy and re-create your database with every model change.
System.Data.Entity.Database.SetInitializer(new SelfEvalInitializer());
var ctx = new EvalDataContext();
ctx.Database.Initialize(true);
WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
Logger.ApplicationName = "FRINDOC";
}
private string buildHighchartOptions(ExportViewModel model, EvalDataContext db)
{
var users = (from u in db.Users
join b in db.Benchmarks on u.UserName equals b.User
where SqlFunctions.StringConvert((double)b.BenchmarkID).Trim() == model.SelectedBenchmarkID
select u.UserName).ToList();
if (!string.IsNullOrWhiteSpace(model.SelectedSubAccount))
{
users = new List<string>() { model.SelectedSubAccount };
}
List<int> series0List = new List<int>();
List<int> series1List = new List<int>();
string categories = string.Join(",", model.Categories.Where(c => c.ChildCategories == null || c.ChildCategories.Count == 0).Select(x => "'" + x.Title.Replace("'", "´") + "'"));
foreach (var x in model.Categories.Where(c => c.ChildCategories == null || c.ChildCategories.Count == 0))
{
int status = 0;
int goal = 0;
foreach (var q in x.Questions)
{
var s = db.UserAnswers.Where(ua => users.Contains(ua.User) && ua.QuestionID == q.QuestionID).FirstOrDefault();
var g = db.UserAnswers.Where(ua => users.Contains(ua.User) && ua.QuestionID == q.QuestionID).FirstOrDefault();
status += s != null ? int.Parse(s.Answer) : 0;
goal += g != null ? int.Parse(g.Goal) : 0;
}
status = (int)(status * x.Weight);
goal = (int)(goal * x.Weight);
series0List.Add(status);
series1List.Add(goal);
}
string series0 = string.Join(",", series0List);
string series1 = string.Join(",", series1List);
return @"
var chart = $('#highchart').highcharts();
if (typeof (chart) !== 'undefined') {
// Set categories
chart.xAxis[0].setCategories([" + categories + @"]);
// Set colors
chart.series[0].color = '#0066FF';
chart.series[1].color = '#FF0000';
chart.legend.colorizeItem(chart.series[0], chart.series[0].visible);
chart.legend.colorizeItem(chart.series[1], chart.series[1].visible);
// Set series data
chart.series[0].setData([" + series0 + @"]);//status
chart.series[1].setData([" + series1 + @"]);//goal
canvg(document.getElementById('canvas'), chart.getSVG())
var canvas = document.getElementById('canvas');
var img = canvas.toDataURL('image/png');
if ($('canvas').length > 0) {
$('#highcharts-png').attr('src', img);
}
}
";
}
