public Highcharts TransDaily(String Polling)
{
SMSServersEntities tp = new SMSServersEntities();
List <Series> sr = new List <Series>();
PollingStation pollingstation = db.PollingStations.Where(c => c.PollingStationName.Equals(Polling)).FirstOrDefault();
foreach (var sp in Getnumbers(pollingstation.ID))
{
sr.Add(new Series {
Name = sp.Abrev, Data = new Data(new object[] { Math.Round(sp.Total, 2) })
});
}
Highcharts chart1 = new Highcharts("chart1")
.InitChart(new Chart {
DefaultSeriesType = ChartTypes.Column
})
.SetTitle(new Title {
Text = "Total votes per party"
})
.SetSubtitle(new Subtitle {
Text = String.Format("Summary for: {0}", pollingstation.PollingStationName)
})
.SetXAxis(new XAxis {
Categories = new[] { pollingstation.PollingStationName }
})
.SetYAxis(new YAxis
{
Min = 0,
Title = new YAxisTitle {
Text = "Votes (%)"
}
})
.SetLegend(new Legend
{
Layout = Layouts.Vertical,
Align = HorizontalAligns.Left,
VerticalAlign = VerticalAligns.Top,
X = 100,
Y = 70,
Floating = true,
BackgroundColor = new BackColorOrGradient(ColorTranslator.FromHtml("#FFFFFF")),
Shadow = true
})
.SetTooltip(new Tooltip {
Formatter = @"function() { return ''+ this.series.name +': '+ this.y +' %'; }"
})
.SetPlotOptions(new PlotOptions
{
Column = new PlotOptionsColumn
{
PointPadding = 0.2,
BorderWidth = 0
}
})
.SetSeries(sr.ToArray());
return(chart1);
}
public Highcharts TransBasicCol()
{
SMSServersEntities tp = new SMSServersEntities();
List <Series> sr = new List <Series>();
foreach (var sp in tp.spVotePartyTransPie().ToList())
{
sr.Add(new Series {
Name = sp.Abrev, Data = new Data(new object[] { Math.Round(sp.Total, 2) })
});
}
Highcharts chart1 = new Highcharts("chart1")
.InitChart(new Chart {
DefaultSeriesType = ChartTypes.Column
})
.SetTitle(new Title {
Text = "Total votes per party"
})
.SetSubtitle(new Subtitle {
Text = "Summary: National"
})
.SetXAxis(new XAxis {
Categories = new[] { "National" }
})
.SetYAxis(new YAxis
{
Min = 0,
Title = new YAxisTitle {
Text = "Votes (%)"
}
})
.SetLegend(new Legend
{
Layout = Layouts.Vertical,
Align = HorizontalAligns.Left,
VerticalAlign = VerticalAligns.Top,
X = 100,
Y = 70,
Floating = true,
BackgroundColor = new BackColorOrGradient(ColorTranslator.FromHtml("#FFFFFF")),
Shadow = true
})
.SetTooltip(new Tooltip {
Formatter = @"function() { return ''+ this.series.name +': '+ this.y +' %'; }"
})
.SetPlotOptions(new PlotOptions
{
Column = new PlotOptionsColumn
{
PointPadding = 0.2,
BorderWidth = 0
}
})
.SetSeries(sr.ToArray());
return(chart1);
}
public List <VotesPerRegionModelView> tableRegion()
{
SMSServersEntities db = new SMSServersEntities();
List <VotesPerRegionModelView> voteCollationModelView = new List <VotesPerRegionModelView>();
List <spVotePerRegion_Result> lstCol = new List <spVotePerRegion_Result>();
foreach (iCelerium.Models.Region Reg in db.Regions.ToList())
{
lstCol = db.spVotePerRegion().Where(c => c.RegionName.Equals(Reg.RegionName)).ToList();
if (lstCol.Count() > 0)
{
VotesPerRegionModelView vot = new VotesPerRegionModelView();
foreach (spVotePerRegion_Result col in lstCol)
{
switch (col.PARTY.Trim())
{
case "NDC":
vot.NDC += col.TOTAL;
break;
case "NPP":
vot.NPP += col.TOTAL;
break;
case "CPP":
vot.CPP += col.TOTAL;
break;
case "PPP":
vot.PPP += col.TOTAL;
break;
case "OTH":
vot.OTHERS += col.TOTAL;
break;
case "IRB":
vot.REJECTED += col.TOTAL;
break;
}
vot.Region = col.RegionName;
vot.NoConstituency = db.spNumberberOfConstituency().Where(c => c.RegionName.Equals(col.RegionName)).ToList().GroupBy(o => o.ConstituencyName).Select(group => group.First()).Count();
}
vot.TOTAL = vot.NDC + vot.NPP + vot.OTHERS + vot.PPP + vot.REJECTED + vot.CPP;
voteCollationModelView.Add(vot);
}
}
return(voteCollationModelView.OrderByDescending(c => c.TOTAL).ToList());
}
public Highcharts PieData(int Polling)
{
List <ZoneData> data = new List <ZoneData>();
SMSServersEntities tp = new SMSServersEntities();
string tDate = DateTime.Today.ToString("MM/dd/yyyy");
var tran = Getnumbers(Polling);
foreach (var iTra in tran.ToList())
{
data.Add(new ZoneData {
ZoneName = iTra.Abrev, Total = (decimal)Math.Round(iTra.Total, 2)
});
}
object[,] chartData = new object[data.Count, 2];
int i = 0;
foreach (ZoneData item in data)
{
chartData.SetValue(item.ZoneName, i, 0);
chartData.SetValue(item.Total, i, 1);
i++;
}
Data dt = new Data(chartData);
Highcharts chart = new Highcharts("chart")
.InitChart(new Chart {
PlotShadow = false
})
.SetTitle(new Title {
Text = String.Format("Shares of votes as at {0}", DateTime.Now)
})
.SetTooltip(new Tooltip {
Formatter = "function() { return '<b>'+ this.point.name +'</b>: '+ this.percentage.toFixed(2) +' %'; }"
})
.SetPlotOptions(new PlotOptions
{
Pie = new PlotOptionsPie {
AllowPointSelect = true, Cursor = Cursors.Pointer, DataLabels = new PlotOptionsPieDataLabels {
Color = ColorTranslator.FromHtml("#000000"), ConnectorColor = ColorTranslator.FromHtml("#000000"), Formatter = "function() { return '<b>'+ this.point.name +'</b>: '+ Math.round(this.percentage) +' %'; }"
}
},
})
.SetSeries(new Series
{
Type = ChartTypes.Pie,
Name = "Browser share",
Data = dt
});
return(chart);
}
public ActionResult TransDaily(string searchDate)
{
List <DataClass> data = new List <DataClass>();
SMSServersEntities tp = new SMSServersEntities();
string tDate = DateTime.Today.ToString("MM/dd/yyyy");
var tran = tp.spTransDay(searchDate);
foreach (var iTra in tran.ToList())
{
data.Add(new DataClass {
ExecutionDate = iTra.Heure.Value, ExecutionValue = iTra.cTotal.Value
});
}
object[,] chartData = new object[data.Count, 2];
int i = 0;
foreach (DataClass item in data)
{
chartData.SetValue(item.ExecutionDate, i, 0);
chartData.SetValue(item.ExecutionValue, i, 1);
i++;
}
Highcharts chart1 = new Highcharts("chart1")
.InitChart(new Chart {
Type = ChartTypes.Spline
})
.SetTitle(new Title {
Text = "Transactions par heure"
})
.SetXAxis(new XAxis {
Type = AxisTypes.Category
})
.SetSeries(new[]
{
new Series {
Data = new Data(chartData), Name = "Toutes Les Transactions"
}
//,
//new Series { Data = new Data(chartData1), Name = "Toutes Les Collections" },
//new Series { Data = new Data(chartData2), Name = "Tous Les Paiements" }
});
return(this.PartialView(chart1));
}
public Highcharts TransDailyBasicBar()
{
SMSServersEntities db = new SMSServersEntities();
List <string> lstRegion = new List <string>();
lstRegion = db.spVoteAvailableRegion().ToList();
List <Series> lstSeries = new List <Series>();
foreach (var party in db.Parties.ToList())
{
List <int> lstNumbers = new List <int>();
foreach (var reg in lstRegion)
{
foreach (spVotePerRegion_Result vot in db.spVotePerRegion().OrderBy(c => c.PARTY).Where(c => c.RegionName.Equals(reg) && c.PARTY.Equals((party.Abrev.Trim()))))
{
lstNumbers.Add(vot.TOTAL);
}
}
object[] ltl = new object[lstNumbers.Count()];
for (int i = 0; i < lstNumbers.Count(); i++)
{
ltl[i] = lstNumbers.ToArray()[i];
}
Series series = new Series {
Name = party.Abrev.Trim(), Data = new Data(ltl)
};
lstSeries.Add(series);
}
Highcharts chart = new Highcharts("chart1")
.InitChart(new Chart {
DefaultSeriesType = ChartTypes.Bar
})
.SetTitle(new Title {
Text = "Historic Votes Collation by Region"
})
.SetSubtitle(new Subtitle {
Text = "Available regions only"
})
.SetXAxis(new XAxis
{
Categories = lstRegion.ToArray(),
Title = new XAxisTitle {
Text = string.Empty
}
})
.SetYAxis(new YAxis
{
Min = 0,
Title = new YAxisTitle
{
Text = "Votes (Thousands)",
Align = AxisTitleAligns.High
}
})
.SetTooltip(new Tooltip {
Formatter = "function() { return ''+ this.series.name +': '+ this.y ; }"
})
.SetPlotOptions(new PlotOptions
{
Bar = new PlotOptionsBar
{
DataLabels = new PlotOptionsBarDataLabels {
Enabled = true
}
}
})
.SetLegend(new Legend
{
Layout = Layouts.Vertical,
Align = HorizontalAligns.Right,
VerticalAlign = VerticalAligns.Top,
X = -100,
Y = 100,
Floating = true,
BorderWidth = 1,
BackgroundColor = new BackColorOrGradient(ColorTranslator.FromHtml("#FFFFFF")),
Shadow = true
})
.SetCredits(new Credits {
Enabled = false
})
.SetSeries(lstSeries.ToArray());
return(chart);
return(chart);
}
public async Task <ActionResult> Edit([Bind(Exclude = "UserName,FullName")]
EditAccountViewModel usr, FormCollection collection)
{
SMSServersEntities dba = new SMSServersEntities();
//usr.Discriminator = dba.AspNetUsers.Single(a => a.Id == usr.Id).Discriminator;
//usr.PasswordHash = dba.AspNetUsers.Single(a => a.Id == usr.Id).PasswordHash;
//usr.SecurityStamp = dba.AspNetUsers.Single(a => a.Id == usr.Id).SecurityStamp;
usr.FullName = dba.AspNetUsers.Single(a => a.Id == usr.Id).FullName;
usr.UserName = dba.AspNetUsers.Single(a => a.Id == usr.Id).UserName;
usr.Email = dba.AspNetUsers.Single(a => a.Id == usr.Id).Email;
AspNetUser aspNetUser = new AspNetUser();
aspNetUser = dba.AspNetUsers.Find(usr.Id);
//if (this.ModelState.IsValid)
//{
// this.db.Entry(usr).State = EntityState.Modified;
foreach (AspNetRole rl in dba.AspNetRoles.ToList())
{
if (!string.IsNullOrEmpty(collection[rl.Name]))
{
string User = collection[rl.Name];
if (User == "false")
{
this.UserManager.RemoveFromRole(usr.Id, rl.Name);
}
else
{
this.UserManager.AddToRole(usr.Id, rl.Name);
}
}
}
if (aspNetUser.Agent == null)
{
aspNetUser.Agent = new Agent
{
UserID = usr.Id,
RegionID = usr.RegionID,
DistrictID = usr.ContituencyID,
ContituencyID = usr.ContituencyID,
IsEnable = usr.IsEnable,
PollingStationID = usr.PollingStationID
};
}
else
{
aspNetUser.Agent.RegionID = usr.RegionID;
aspNetUser.Agent.DistrictID = usr.ContituencyID;
aspNetUser.Agent.ContituencyID = usr.ContituencyID;
aspNetUser.Agent.IsEnable = usr.IsEnable;
aspNetUser.Agent.PollingStationID = usr.PollingStationID;
}
await dba.SaveChangesAsync();
return(RedirectToAction("AccountsList"));
//}
//return this.View(usr);
}
