public ActionResult graph_DashboardMonitoring(string bdate)
{
PatientStatisticsDB _DB = new PatientStatisticsDB();
DataSet reportData = _DB.graph_DashboardMonitoring(bdate);
var CashList = reportData.Tables[0].AsEnumerable().Select(
r => new CashList {
NO_PATIENT_CASH = r.Field <int>("NO_PATIENT"),
DeptName_CASH = r.Field <string>("DeptName")
});
var ChargeList = reportData.Tables[1].AsEnumerable().Select(
r => new CashList
{
NO_PATIENT_CASH = r.Field <int>("NO_PATIENT"),
DeptName_CASH = r.Field <string>("DeptName")
});
var ARAMCOList = reportData.Tables[2].AsEnumerable().Select(
r => new CashList
{
NO_PATIENT_CASH = r.Field <int>("NO_PATIENT"),
DeptName_CASH = r.Field <string>("DeptName")
});
var serializer = new JavaScriptSerializer {
MaxJsonLength = Int32.MaxValue
};
var GraphList = new GraphList {
CASH = new List <CashList>(CashList.ToList())
, CHARGE = new List <CashList>(ChargeList.ToList())
, ARAMCO = new List <CashList>(ARAMCOList.ToList())
};
var result = new ContentResult
{
Content = serializer.Serialize(
new { GraphList = GraphList }
),
ContentType = "application/json"
};
return(result);
}
