public JsonResult GetChartData()
{
DBBusinessLayer dBBusinessLayer = new DBBusinessLayer();
DataTable bangData = dBBusinessLayer.SelectCmd("trangthai", "nhietDo,doAm", "tenChuong='ChuongGa1'");
var chartData = new object[101];
chartData[0] = new object[] {
"Thời gian",
"Nhiệt độ ",
"Độ ẩm ",
};
//if (Dem < 10)
//{
try
{
for (Int16 j = 1; j <= 100; j++)
{
chartData[j] = new object[] { DateTime.Now.ToString(), bangData.Rows[0][0], bangData.Rows[0][1] };
}
}
catch { }
return(Json(chartData, JsonRequestBehavior.AllowGet));
}
public JsonResult Update(HomeModel model)
{
DBBusinessLayer updateLM = new DBBusinessLayer();
//if (updateLM.SelectCmd(model.nhietDo, model.id) != 0)
//{
// return Json(new { Status = "Ok" }, JsonRequestBehavior.AllowGet);
//}
return(Json(new { Status = "Fail" }, JsonRequestBehavior.AllowGet));
}
//Locahost/Home/Get/12
/// <summary>
/// Đọc DB lấy các giá trị realTime lên để hiển thị.
/// </summary>
/// <returns></returns>
public JsonResult GetRealTimeValues()
{
DBBusinessLayer dbBusinessLayer = new DBBusinessLayer();
DataTable bangData = dbBusinessLayer.SelectCmd("trangthai", "*", "tenChuong='ChuongGa1'");
HomeModel model = new HomeModel()
{
id = Convert.ToInt32(bangData.Rows[0][0].ToString()),
tenChuong = bangData.Rows[0][1].ToString(),
nhietDo = Convert.ToDouble(bangData.Rows[0][2].ToString()),
doAm = Convert.ToDouble(bangData.Rows[0][3].ToString()),
tanSo = Convert.ToDouble(bangData.Rows[0][4].ToString()),
o2 = Convert.ToDouble(bangData.Rows[0][5].ToString()),
co2 = Convert.ToDouble(bangData.Rows[0][6].ToString()),
nh3 = Convert.ToDouble(bangData.Rows[0][7].ToString()),
};
return(Json(model, JsonRequestBehavior.AllowGet));
}
public frmSinhVienTheoKhoa()
{
InitializeComponent();
ds = new DataSet();
db = new DBBusinessLayer();
}
} //mã khóa học
public frmLopTheoNganh()
{
InitializeComponent();
ds = new DataSet();
db = new DBBusinessLayer();
}
//địa chỉ của image
//string imgLoc = "";
//private byte[] img = null; //image
//private object txtgioitinh;
public frmQuanLySinhVien()
{
InitializeComponent();
ds = new DataSet();
db = new DBBusinessLayer();
}
public frmQuanLyNganhHoc()
{
InitializeComponent();
ds = new DataSet();
db = new DBBusinessLayer();
}
public frmQuanLyKhoaHoc()
{
ds = new DataSet();
db = new DBBusinessLayer();
InitializeComponent();
}
public frmGiaoVienTheoMonHoc()
{
InitializeComponent();
ds = new DataSet();
db = new DBBusinessLayer();
}
public MainForm()
{
InitializeComponent();
db = new DBBusinessLayer();
ds = new DataSet();
}
