public void ViewChart()
{
try
{
using (SqlConnection con = new SqlConnection(strConString))
{
SqlCommand cmd = new SqlCommand("select * From tblTransaksi", con);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
//----ViewChart----//
//DataTable primaryData = new DataTable();
//dt.Columns.Add("Language", typeof(System.String));
//dt.Columns.Add("User", typeof(System.Double));
//dt.Rows.Add("Java", 62000);
//dt.Rows.Add("Python", 46000);
//dt.Rows.Add("Javascript", 38000);
//dt.Rows.Add("C++", 31000);
//dt.Rows.Add("C#", 27000);
//dt.Rows.Add("php", 14000);
//dt.Rows.Add("Perl", 14000);
StaticSource source = new StaticSource(dt);
DataModel model = new DataModel();
model.DataSources.Add(source);
PageLevelTheme.Theme = FusionChartsTheme.ThemeName.FUSION;
Charts.PieChart pie = new Charts.PieChart("first_3D_chart");
pie.ThreeD = true;
pie.Width.Pixel(600);
pie.Height.Pixel(450);
pie.Data.Source = model;
pie.Data.CategoryField("[Nama Perusahaan]");
pie.Data.SeriesFields("[Nama Barang]");
pie.Caption.Text = "Transaction Tables";
pie.Values.Show = false;
//Chart newChart = new Chart("column2d", "simplechart", "600", "400", "jsonurl", "data.json");
//chart.Text = newChart.Render();
//ViewData["Chart"] = pie.Render();
}
}
catch (Exception ex)
{
message = ex.Message;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Message", "alert('Oops!! following error occured : " + message.ToString() + "');", true);
}
}
protected override async Task OnInitializedAsync()
{
// create data table to store data
DataTable ChartData = new DataTable();
// Add columns to data table
ChartData.Columns.Add("Programming Language", typeof(System.String));
ChartData.Columns.Add("Users", typeof(System.Double));
// Add rows to data table
ChartData.Rows.Add("Java", 62000);
ChartData.Rows.Add("Python", 46000);
ChartData.Rows.Add("Javascript", 38000);
ChartData.Rows.Add("C++", 31000);
ChartData.Rows.Add("C#", 27000);
ChartData.Rows.Add("PHP", 14000);
ChartData.Rows.Add("Perl", 14000);
// Create static source with this data table
StaticSource source = new StaticSource(ChartData);
// Create instance of DataModel class
DataModel model = new DataModel();
// Add DataSource to the DataModel
model.DataSources.Add(source);
// Instantiate Column Chart
Charts.ColumnChart column = new Charts.ColumnChart("first_chart");
// Set Chart's width and height
column.Width.Pixel(700);
column.Height.Pixel(400);
// Set DataModel instance as the data source of the chart
column.Data.Source = model;
// Set Chart Title
column.Caption.Text = "Most popular programming language";
// Set chart sub title
column.SubCaption.Text = "2017-2018";
// hide chart Legend
column.Legend.Show = false;
// set XAxis Text
column.XAxis.Text = "Programming Language";
// Set YAxis title
column.YAxis.Text = "User";
// set chart theme
column.ThemeName = FusionChartsTheme.ThemeName.FUSION;
// set chart rendering json
ChartJson = column.Render();
}
public void OnPostChartGenerator()
{
int userID = Convert.ToInt32(HttpContext.Session.GetInt32("userID"));
var MonthList = new List <string>()
{
"Styczeń", "Luty", "Marzec", "Kwiecień", "Maj", "Czerwiec", "Lipiec", "Sierpień", "Wrzesień", "Październik", "Listopad", "Grudzień"
};
int StartDay = int.Parse(Request.Form["StartDay"]);
string StartMonth = Request.Form["StartMonth"].ToString();
int StartYear = int.Parse(Request.Form["StartYear"]);
int StartMonthValue = MonthList.IndexOf(StartMonth) + 1;
string StartDate = StartYear + "-" + StartMonthValue + "-" + StartDay;
int EndDay = int.Parse(Request.Form["EndDay"]);
string EndMonth = Request.Form["EndMonth"].ToString();
int EndYear = int.Parse(Request.Form["EndYear"]);
int EndMonthValue = MonthList.IndexOf(EndMonth) + 1;
string EndDate = EndYear + "-" + EndMonthValue + "-" + EndDay;
string Lift = Request.Form["Lift"].ToString();
IDictionary <string, string> LiftQueryList = new Dictionary <string, string>()
{
{ "Wyciskanie leżąc", "BENCH" },
{ "Wyciskanie stojąc", "OHP" },
{ "Przysiad", "SQUAT" },
{ "Martwy ciąg", "DEADLIFT" },
};
string LiftQuery = LiftQueryList[Lift];
List <string> LiftList;
List <string> DateList;
using (SqlConnection connection = new SqlConnection(_connectionString))
{
//string query = "SELECT value, m_date FROM [FOODMATE].[dbo].[Lifts] WHERE user_id = @userID AND lift_name = @liftName AND m_date BETWEEN @StartDate AND @EndDate;";
string query = "SELECT x.lift_id, x.user_id, x.m_date, x.lift_name, x.value FROM [FOODMATE].[dbo].[Lifts] x " +
"JOIN(SELECT y.m_date FROM[FOODMATE].[dbo].[Lifts] y " +
"WHERE y.user_id = @userID AND y.m_date BETWEEN @StartDate AND @EndDate group by m_date) z " +
"ON x.user_id = @UserID AND lift_name = @liftName AND x.m_date = z.m_date;";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@StartDate", StartDate);
command.Parameters.AddWithValue("@EndDate", EndDate);
command.Parameters.AddWithValue("@userID", userID);
command.Parameters.AddWithValue("@liftName", LiftQuery);
connection.Open();
LiftList = new List <string>();
DateList = new List <string>();
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dt);
foreach (DataRow row in dt.Rows)
{
LiftList.Add(row["value"].ToString());
DateList.Add(row["m_date"].ToString().Remove(10));
}
connection.Close();
}
}
// create data table to store data
DataTable ChartData = new DataTable();
// Add columns to data table
ChartData.Columns.Add("Czas", typeof(System.String));
ChartData.Columns.Add("Wielkość", typeof(System.Double));
// Add rows to data table
var i = 0;
foreach (var day in DateList)
{
ChartData.Rows.Add(DateList[i], LiftList[i]);
i++;
}
// Create static source with this data table
StaticSource source = new StaticSource(ChartData);
// Create instance of DataModel class
DataModel model = new DataModel();
// Add DataSource to the DataModel
model.DataSources.Add(source);
Charts.SplineChart splineChart = new Charts.SplineChart("spline_chart");
splineChart.ThemeName = FusionChartsTheme.ThemeName.FUSION;
splineChart.Width.Pixel(700);
splineChart.Height.Pixel(400);
splineChart.Data.Source = model;
splineChart.Caption.Text = Lift;
splineChart.Caption.Bold = true;
splineChart.Values.Show = true;
splineChart.XAxis.Text = "Czas";
splineChart.YAxis.Text = "kg";
splineChart.Legend.Show = false;
splineChart.ThemeName = FusionChartsTheme.ThemeName.FUSION;
ViewData["Chart"] = splineChart.Render();
}
public async Task OnPostAsync()
{
const string path = @"..\车辆基本信息表.csv";
CarDetails = new List <CarDetail>();
var lists = FileService.ReadFromFile(path);
CarDetails = InitializeService.InitializeCarDetail(lists);
sta = new List <CarStatic>();
Dictionary <string, CarStatic> dic = new Dictionary <string, CarStatic>();
foreach (var item in CarDetails)
{
if (dic.ContainsKey(item.CarType))
{
++dic[item.CarType].Total;
if (item.State == "y")
{
++dic[item.CarType].rent;
}
else
{
++dic[item.CarType].free;
}
}
else
{
int onrent = item.State == "y" ? 1 : 0;
dic.Add(item.CarType, new CarStatic
{
Type = item.CarType,
Total = 1,
rent = onrent,
free = 1 - onrent
});
}
}
foreach (var item in dic)
{
sta.Add(item.Value);
}
switch (SearchOption)
{
case "TotalInfo":
break;
case "BarChart":
try
{
DataTable ChartData = new DataTable();
ChartData.Columns.Add("Programming Language", typeof(System.String));
ChartData.Columns.Add("Users", typeof(int));
foreach (var item in sta)
{
ChartData.Rows.Add(item.Type, item.Total);
}
// Create static source with this data table
StaticSource source = new StaticSource(ChartData);
// Create instance of DataModel class
DataModel model = new DataModel();
// Add DataSource to the DataModel
model.DataSources.Add(source);
// Instantiate Column Chart
Charts.ColumnChart column = new Charts.ColumnChart("first_chart");
// Set Chart's width and height
column.Width.Pixel(700);
column.Height.Pixel(400);
// Set DataModel instance as the data source of the chart
column.Data.Source = model;
// Set Chart Title
column.Caption.Text = "All type of the cars";
// Set chart sub title
column.SubCaption.Text = "2020.06";
// hide chart Legend
column.Legend.Show = false;
// set XAxis Text
column.XAxis.Text = "CarType";
// Set YAxis title
column.YAxis.Text = "Total";
// set chart theme
column.ThemeName = FusionChartsTheme.ThemeName.FUSION;
// set chart rendering json
ChartJson = column.Render();
}catch
{
}
break;
default:
break;
}
}
public void OnPostChartGenerator()
{
int userID = Convert.ToInt32(HttpContext.Session.GetInt32("userID"));
var MonthList = new List <string>()
{
"Styczeń", "Luty", "Marzec", "Kwiecień", "Maj", "Czerwiec", "Lipiec", "Sierpień", "Wrzesień", "Październik", "Listopad", "Grudzień"
};
int StartDay = int.Parse(Request.Form["StartDay"]);
string StartMonth = Request.Form["StartMonth"].ToString();
int StartYear = int.Parse(Request.Form["StartYear"]);
int StartMonthValue = MonthList.IndexOf(StartMonth) + 1;
string StartDate = StartYear + "-" + StartMonthValue + "-" + StartDay;
int EndDay = int.Parse(Request.Form["EndDay"]);
string EndMonth = Request.Form["EndMonth"].ToString();
int EndYear = int.Parse(Request.Form["EndYear"]);
int EndMonthValue = MonthList.IndexOf(EndMonth) + 1;
string EndDate = EndYear + "-" + EndMonthValue + "-" + EndDay;
string BodyPart = Request.Form["BodyPart"].ToString();
IDictionary <string, string> BodyPartQueryList = new Dictionary <string, string>()
{
{ "Lewa łydka", "l_calve" },
{ "Prawa łydka", "r_calve" },
{ "Lewe udo", "l_thigh" },
{ "Prawe udo", "r_thigh" },
{ "Pośladki", "butt" },
{ "Pas", "waist" },
{ "Klatka piersiowa", "chest" },
{ "Lewe ramię", "l_arm" },
{ "Prawe ramię", "r_arm" },
{ "Lewe przedramię", "l_forearm" },
{ "Prawe przedramię", "r_forearm" },
{ "Waga", "u_weight" }
};
string BodyPartQuery = BodyPartQueryList[BodyPart];
List <string> BodyPartList;
List <string> DateList;
using (SqlConnection connection = new SqlConnection(_connectionString))
{
string query = "SELECT x.measurement_id, x.m_date, x.user_id, x.l_calve, x.r_calve, x.l_thigh, x.r_thigh, x.butt, x.waist, x.chest, x.l_arm, x.r_arm, x.l_forearm, x.r_forearm, x.u_weight FROM[FOODMATE].[dbo].[Measurements] x " +
"JOIN(SELECT y.m_date FROM [FOODMATE].[dbo].[Measurements] y " +
"WHERE y.user_id = @UserID AND y.m_date BETWEEN @StartDate AND @EndDate group by m_date) z " +
"ON x.user_id = @UserID AND x.m_date = z.m_date;";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@StartDate", StartDate);
command.Parameters.AddWithValue("@EndDate", EndDate);
command.Parameters.AddWithValue("@userID", userID);
connection.Open();
BodyPartList = new List <string>();
DateList = new List <string>();
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dt);
foreach (DataRow row in dt.Rows)
{
BodyPartList.Add(row[BodyPartQuery].ToString());
DateList.Add(row["m_date"].ToString().Remove(10));
}
connection.Close();
}
}
for (int j = 0; j <= BodyPartList.Count - 1; j++)
{
if (BodyPartList[j] == "")
{
BodyPartList[j] = BodyPartList[j - 1];
Console.WriteLine(DateList[j]);
Console.WriteLine(BodyPartList[j]);
}
}
// create data table to store data
DataTable ChartData = new DataTable();
// Add columns to data table
ChartData.Columns.Add("Czas", typeof(System.String));
ChartData.Columns.Add("Wielkość", typeof(System.Double));
// Add rows to data table
var i = 0;
foreach (var day in DateList)
{
ChartData.Rows.Add(DateList[i], BodyPartList[i]);
i++;
}
// Create static source with this data table
StaticSource source = new StaticSource(ChartData);
// Create instance of DataModel class
DataModel model = new DataModel();
// Add DataSource to the DataModel
model.DataSources.Add(source);
Charts.SplineChart splineChart = new Charts.SplineChart("spline_chart");
splineChart.ThemeName = FusionChartsTheme.ThemeName.FUSION;
splineChart.Width.Pixel(700);
splineChart.Height.Pixel(400);
splineChart.Data.Source = model;
splineChart.Caption.Text = BodyPart;
splineChart.Caption.Bold = true;
splineChart.Values.Show = true;
splineChart.XAxis.Text = "Czas";
splineChart.YAxis.Text = "cm";
splineChart.Legend.Show = false;
splineChart.ThemeName = FusionChartsTheme.ThemeName.FUSION;
ViewData["Chart"] = splineChart.Render();
}
public async Task <IActionResult> OnGetAsync(string id)
{
if (id == null)
{
return(NotFound());
}
controller = await _context.Controllers.FirstOrDefaultAsync(m => m.Id == id);
string[] values = controller.Values;
if (values.Length == 0)
{
return(Page());
}
int start_point = 0;
// create data table to store data
DataTable ChartData = new DataTable();
// Add columns to data table
if (controller.Type == "humidity")
{
ChartData.Columns.Add("time", typeof(System.String));
ChartData.Columns.Add("mm/pt", typeof(System.Double));
foreach (var item in values)
{
if (item != "")
{
ChartData.Rows.Add(start_point, item.Split('|')[1]);
start_point += 10;
}
}
}
else if (controller.Type == "temperature")
{
ChartData.Columns.Add("time", typeof(System.String));
ChartData.Columns.Add("Degrees", typeof(System.Double));
foreach (var item in values)
{
double dd = 0;
if (item != "")
{
ChartData.Rows.Add(start_point, item.Split('|')[1]);
start_point += 10;
}
}
}
else if (controller.Type == "pressure")
{
ChartData.Columns.Add("time", typeof(System.String));
ChartData.Columns.Add("bar", typeof(System.Double));
foreach (var item in values)
{
//DateTime dt = DateTime.Parse(item.Split('|')[0]);
ChartData.Rows.Add(start_point, item.Split('|')[3]);
start_point += 10;
}
start_point = 0;
}
else if (controller.Type == "movement")
{
ChartData.Columns.Add("time", typeof(System.String));
ChartData.Columns.Add("actions", typeof(System.Double));
foreach (var item in values)
{
if (item != "")
{
//DateTime dt = DateTime.Parse(item.Split('|')[0]);
int value = 0;
if (item.Split('|')[1] == "true")
{
value = 1;
}
ChartData.Rows.Add(start_point, value);
start_point += 10;
}
}
}
else if (controller.Type == "lightning")
{
ChartData.Columns.Add("time", typeof(System.String));
ChartData.Columns.Add("lux", typeof(System.Double));
foreach (var item in values)
{
if (item != "")
{
//DateTime dt = DateTime.Parse(item.Split('|')[0]);
ChartData.Rows.Add(start_point, item.Split('|')[1]);
start_point += 10;
}
}
}
else
{
ChartData.Columns.Add("sample", typeof(System.String));
ChartData.Columns.Add("sample2", typeof(System.Double));
}
// Add rows to data table
//ChartData.Rows.Add("Java", 62000);
//ChartData.Rows.Add("Python", 46000);
//ChartData.Rows.Add("Javascript", 38000);
//ChartData.Rows.Add("C++", 31000);
//ChartData.Rows.Add("C#", 27000);
//ChartData.Rows.Add("PHP", 14000);
//ChartData.Rows.Add("Perl", 14000);
// Create static source with this data table
StaticSource source = new StaticSource(ChartData);
// Create instance of DataModel class
DataModel model = new DataModel();
// Add DataSource to the DataModel
model.DataSources.Add(source);
// Instantiate Column Chart
Charts.ColumnChart column = new Charts.ColumnChart("first_chart");
// Set Chart's width and height
column.Width.Pixel(700);
column.Height.Pixel(400);
// Set DataModel instance as the data source of the chart
column.Data.Source = model;
// Set Chart Title
column.Caption.Text = controller.Type;
// Set chart sub title
// hide chart Legend
column.Legend.Show = false;
// set XAxis Text
column.XAxis.Text = "Time";
// Set YAxis title
column.YAxis.Text = "Value";
// set chart theme
column.ThemeName = FusionChartsTheme.ThemeName.FUSION;
// set chart rendering json
ChartJson = column.Render();
if (controller == null)
{
return(NotFound());
}
return(Page());
}
public IActionResult Diagram()
{
DataTable ChartData = new DataTable();
ChartData.Columns.Add("Стоимость", typeof(double));
ChartData.Columns.Add("Спрос", typeof(int));
var sales = _saleLogic.Read(null);
var products = _productLogic.Read(null);
var spros = new List <int>();
var prices = new List <double>();
if (products != null)
{
foreach (var product in products)
{
prices.Add(product.Price);
spros.Add(0);
}
}
if (sales != null)
{
foreach (var sale in sales)
{
if (sale.TableProducts != null)
{
foreach (var tp in sale.TableProducts)
{
foreach (var product in products)
{
if (tp.Product == product)
{
spros[products.IndexOf(product)] += tp.Amount;
}
}
}
}
}
}
for (int i = 0; i < products.Count(); i++)
{
ChartData.Rows.Add(prices[i], spros[i]);
}
StaticSource source = new StaticSource(ChartData);
DataModel model = new DataModel();
model.DataSources.Add(source);
Charts.ColumnChart column = new Charts.ColumnChart("first_chart");
column.Width.Pixel(700);
column.Height.Pixel(400);
column.Data.Source = model;
column.Caption.Text = "Диаграмма цена/спрос";
column.Legend.Show = false;
column.XAxis.Text = "Стоимость";
column.YAxis.Text = "Спрос";
column.ThemeName = FusionChartsTheme.ThemeName.FUSION;
return(View("Diagram", column.Render()));
}
