public List <MONITOR> DanhSachDongCoCuaThietBi(string IDDV)
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
List <DVMT> lstDeviceMonitor = context.DVMTs
.Where(x => x.IDDV == IDDV)
.ToList();
var list = new List <DVMT>();
foreach (var e in lstDeviceMonitor)
{
list.Add(new DVMT
{
IDDV = e.IDDV,
IDMT = e.IDMT
});
}
List <MONITOR> lstSensor = new List <MONITOR>();
foreach (var item in lstDeviceMonitor)
{
MONITOR dv = context.MONITORs.FirstOrDefault(x => x.ID == item.IDMT);
dv.DVMTs = null;
dv.TYPE_MT = null;
lstSensor.Add(dv);
}
return(lstSensor);
}
public int GetStatus(string ID)
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
MONITOR mnt = context.MONITORs.FirstOrDefault(x => x.ID == ID);
return((int)mnt.STATUS);
}
public List <WARNINGSMAX> GetAllWarnings(string IDUSER)
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
USER_DEVICEController ds = new USER_DEVICEController();
List <DEVICE> lstDevice = ds.DanhSachThietBiCuaNguoiDung(IDUSER);
List <WARNINGSMAX> lstWarnings = new List <WARNINGSMAX>();
foreach (DEVICE item in lstDevice)
{
SENSORController ss = new SENSORController();
List <SENSOR> lstSS = ss.DanhSachCamBienCuaThietBi(item.ID);
foreach (SENSOR sens in lstSS)
{
WARNINGSMAX dv = context.WARNINGSMAXes.FirstOrDefault(x => x.IDSS == sens.ID);
if (dv != null)
{
dv.SENSOR = null;
dv.IDSENSOR = sens.NAME;
if (double.Parse(sens.NUMBER) >= double.Parse(dv.VALUE))
{
lstWarnings.Add(dv);
}
}
}
}
return(lstWarnings);
}
public List <DEVICE> DanhSachThietBiCuaNguoiDung(string IDUser)
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
List <USR_DV> lstUserDevice = context.USR_DVs
.Where(x => x.IDUSR == IDUser)
.ToList();
var list = new List <USR_DV>();
foreach (var e in lstUserDevice)
{
list.Add(new USR_DV
{
IDDV = e.IDDV,
IDUSR = e.IDUSR
});
}
List <DEVICE> lstDevice = new List <DEVICE>();
foreach (var item in list)
{
DEVICE dv = context.DEVICEs.FirstOrDefault(x => x.ID == item.IDDV);
dv.USR_DVs = null;
dv.DVSSes = null;
dv.DVMTs = null;
lstDevice.Add(dv);
}
return(lstDevice);
}
public List <SENSOR> DanhSachCamBienCuaThietBi(string IDDV)
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
List <DVSS> lstDeviceSenSor = context.DVSSes
.Where(x => x.IDDV == IDDV)
.ToList();
var list = new List <DVSS>();
foreach (var e in lstDeviceSenSor)
{
list.Add(new DVSS
{
IDDV = e.IDDV,
IDSS = e.IDSS
});
}
List <SENSOR> lstSensor = new List <SENSOR>();
foreach (var item in lstDeviceSenSor)
{
SENSOR dv = context.SENSORs.FirstOrDefault(x => x.ID == item.IDSS);
dv.DVSSes = null;
dv.TYPE_SS = null;
dv.WARNINGSMAXes = null;
lstSensor.Add(dv);
}
return(lstSensor);
}
public USER GetUser(string usn, string pass)
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
USER User = context.USERs.FirstOrDefault(x => x.USN == usn && x.PASS == pass);
return(User);
}
public List <USER> GetAllUser()
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
List <USER> lstUser = context.USERs.ToList();
return(lstUser);
}
public List <USER> GetAllUser()
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
List <USER> lstUser = context.USERs.ToList();
foreach (USER user in lstUser)
{
user.ID = null;
}
return(lstUser);
}
public DEVICE SearchIDs(string ID)
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
DEVICE device = context.DEVICEs.FirstOrDefault(x => x.ID == ID);
USR_DV usr_dv = context.USR_DVs.FirstOrDefault(x => x.IDDV == device.ID);
if (usr_dv != null)
{
device.ID = null;
}
return(device);
}
public bool UpdateStatus(string ID, int status)
{
try
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
MONITOR dv = context.MONITORs.FirstOrDefault(x => x.ID == ID);
if (dv != null)
{
dv.STATUS = status;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool UpdateStatus(string ID, string value)
{
try
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
SENSOR dv = context.SENSORs.FirstOrDefault(x => x.ID == ID);
if (dv != null)
{
dv.NUMBER = value;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool LuuUserDevice(string ID_User, string ID_Device)
{
try
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
USR_DV dv = new USR_DV();
dv.IDDV = ID_Device;
dv.IDUSR = ID_User;
dv.DateConnect = DateTime.Now.Date;
context.USR_DVs.InsertOnSubmit(dv);
context.SubmitChanges();
return(true);
}
catch
{
}
return(false);
}
public bool LuuDevice(string id, string partcode, string name, int status)
{
try
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
DEVICE dv = new DEVICE();
dv.ID = id;
dv.NAME = name;
dv.STATUS = status;
dv.PARTCODE = partcode;
context.DEVICEs.InsertOnSubmit(dv);
context.SubmitChanges();
return(true);
}
catch
{
}
return(false);
}
public USER GetUser(string usn, string pass)
{
AGRIBOTSYSTEMDataContext context = new AGRIBOTSYSTEMDataContext();
USER User = context.USERs.FirstOrDefault(x => x.NUMPHONE == usn && x.PASS == pass);
if (User != null)
{
return(new USER
{
ID = User.ID,
ADDRESS = User.ADDRESS,
NAME = User.NAME,
NUMPHONE = User.NUMPHONE,
PASS = User.PASS,
USN = User.USN
});
}
return(User);
}
