public List <DatHangCT> Result()
{
List <DatHangCT> list = new List <DatHangCT>();
using (var db = new NhaSachDbContext())
{
list = db.DatHangCTs.ToList();
}
return(list);
}
// GET: Chart
public ActionResult ColumnChart()
{
User nguoiDung = Session["NguoiDung"] as User;
if (nguoiDung != null && (int)nguoiDung.UserRole.RoleID == 1)
{
using (var db = new NhaSachDbContext())
{
//Pie Chart
var temp = db.DatHangs.ToList();
ArrayList header = new ArrayList {
"Task Name", "Hours"
};
ArrayList data = new ArrayList {
header
};
for (int i = 0; i < temp.Count; i++)
{
data.Add(new ArrayList {
temp[i].DatHangID.ToString(), temp[i].TriGia
});
}
string datastr = JsonConvert.SerializeObject(data, Formatting.None);
ViewBag.Data = new HtmlString(datastr);
//Area Chart
var query = db.DatHangs.Where(m => m.DaGiao == true)
.GroupBy(m => m.NgayDatHang.Year)
.Select(m => new { tong = m.Sum(a => a.TriGia), Year = m.Key.ToString() })
.ToList();
ArrayList headerAreaChart = new ArrayList {
"Year", "Tổng Tiền"
};
ArrayList dataAreaChart = new ArrayList {
headerAreaChart
};
for (int i = 0; i < query.Count; i++)
{
dataAreaChart.Add(new ArrayList {
query[i].Year, query[i].tong
});
}
string datastrArea = JsonConvert.SerializeObject(dataAreaChart, Formatting.None);
ViewBag.DataArea = new HtmlString(datastrArea);
//Column Chart
var query1 = db.DatHangCTs
.GroupBy(m => m.Sach.TenSach)
.Select(m => new
{
tong1 = m.Sum(a => a.SoLuong).ToString(),
Name = m.Key.ToString(),
tong2 =
m.Sum(a => a.ThanhTien)
})
.ToList();
ArrayList headerColumnChart = new ArrayList {
"Tên Sách", "Số Lượng", "Tổng Tiền Bán"
};
ArrayList dataColumnChart = new ArrayList {
headerColumnChart
};
for (int i = 0; i < query1.Count; i++)
{
dataColumnChart.Add(new ArrayList {
query1[i].Name, float.Parse(query1[i].tong1), query1[i].tong2
});
}
string datastrColumn = JsonConvert.SerializeObject(dataColumnChart, Formatting.None);
ViewBag.DataColumn = new HtmlString(datastrColumn);
//Donut Chart
var query2 = db.Saches.GroupBy(m => m.TenSach)
.Select(m => new { solan = m.Count(a => a.SachID == a.SachID).ToString(), name1 = m.Key.ToString() })
.ToList();
ArrayList headerDonutChart = new ArrayList {
"Tên Sách", "Số lượt xem"
};
ArrayList dataDonutChart = new ArrayList {
headerDonutChart
};
for (int i = 0; i < query2.Count; i++)
{
dataDonutChart.Add(new ArrayList {
query2[i].name1, int.Parse(query2[i].solan)
});
}
string datastrDonut = JsonConvert.SerializeObject(dataDonutChart, Formatting.None);
ViewBag.DataDonut = new HtmlString(datastrDonut);
return(View());
}
}
return(RedirectToAction("Login", "AdminUser"));
}
