private void BindOrganizationTypesChart()
{
BarChartSeries yearSeries;
DEWSReference.DeptEstadoDataSoapClient DEWS = new DeptEstadoDataSoapClient();
foreach (DataRow dRow in DEWS.GetCorpOrganizationTypesByYearSeries().Rows)
{
yearSeries = new BarChartSeries();
yearSeries.Name = dRow["OrganizationFormType"].ToString();
yearSeries.Data = new decimal[]
{
Convert.ToDecimal(dRow["CorpTotal2008"]), Convert.ToDecimal(dRow["CorpTotal2009"]),
Convert.ToDecimal(dRow["CorpTotal2010"]), Convert.ToDecimal(dRow["CorpTotal2011"]),
Convert.ToDecimal(dRow["CorpTotal2012"])
};
bcCorpOrganizationTypes.Series.Add(yearSeries);
}
}
private void loadGenderChart()
{
BarChartSeries Male = new BarChartSeries();
Male.BarColor = "#0000FF";
Male.Name = "Male";
BarChartSeries Female = new BarChartSeries();
Female.BarColor = "#FF00FF";
Female.Name = "Female";
string strCountMale = "SELECT COUNT (*) AS 'COUNT' FROM Tenants WHERE Gender = 1";
string strCountFemale = "SELECT COUNT (*) AS 'COUNT' FROM Tenants WHERE Gender = 2";
int MaleCount = int.Parse(DataAccess.ReturnData(strCountMale, conString, "COUNT"));
int FemaleCount = int.Parse(DataAccess.ReturnData(strCountFemale, conString, "COUNT"));
Decimal[] MaleNumbers = {
Convert.ToDecimal(MaleCount)
};
Decimal[] FemaleNumbers = {
Convert.ToDecimal(FemaleCount)
};
Male.Data = MaleNumbers;
Female.Data = FemaleNumbers;
BarChartSeries[] GenderCountCollection = {
Male, Female
};
barchartGender.Series.AddRange(GenderCountCollection);
barchartGender.DataBind();
lblTotalTenants.Text = (FemaleCount + MaleCount).ToString();
}
protected void panelonload(object sender, EventArgs e)
{
try
{
var sc = new RecipeServiceSoapClient();
List<MongoMap> mn = new List<MongoMap>();
//Response.Write(sc.Search("mango"));
mn = JsonConvert.DeserializeObject<List<MongoMap>>(sc.DataAnalytics());
// String ca = null, data;
Dictionary<String,Double> dic=new Dictionary<string, Double>();
foreach (var map in mn)
{
dic.Add(map._id,map.value.count);
//Response.Write(map._id+"-"+map.value.count+"<br/>");
if (map.value.count > 100)
{
// ca += map._id.Replace("PT", "") + ",";
BarChartSeries a = new BarChartSeries();
a.Name = map._id.Replace("PT", "");
a.BarColor = GenerateRandomColour().ToString();
a.Data = new[] { Convert.ToDecimal(map.value.count) };
BarChart1.Series.Add(a);
}
GridView2.DataSource = dic;
GridView2.DataBind();
}
// BarChart1.CategoriesAxis = ca.Substring(0, ca.Count() - 1);
}
catch (Exception ex)
{
Response.Write(ex);
}
}
private void BindBarChart()
{
zgSales.Visible = false;
bcSales.Visible = true;
if (salesByMonthData == null) { salesByMonthData = CommerceReport.GetSalesByYearMonthBySite(siteSettings.SiteGuid); }
StringBuilder categories = new StringBuilder();
string comma = string.Empty;
List<decimal> revenue = new List<decimal>();
// original data is sorted descending on Y, M resorting here
DataRow[] result = salesByMonthData.Select(string.Empty, "Y ASC, M ASC");
int spaceInterval = 0;
int totalItems = result.Length;
int itemsAdded = 0;
if (totalItems > 12)
{
spaceInterval = 4;
}
int nextItemToShow = 0;
foreach (DataRow row in result)
{
categories.Append(comma);
if (itemsAdded == nextItemToShow)
{
categories.Append(row["Y"].ToString());
categories.Append("-");
categories.Append(row["M"].ToString());
nextItemToShow = itemsAdded + spaceInterval;
}
comma = ",";
revenue.Add(Convert.ToDecimal(row["Sales"]));
itemsAdded += 1;
}
bcSales.ChartTitle = Resource.SalesByMonthChartLabel;
bcSales.CategoriesAxis = categories.ToString();
BarChartSeries series = new BarChartSeries();
//series.Name = Resource.SalesByMonthChartSalesLabel;
series.Data = revenue.ToArray();
bcSales.Series.Add(series);
//bcSales.CategoriesAxis
//bcSales.Series.
}