public void StopThread(List <GetSleepThread> getThread, SleepInformation returnedThreadList, string towerName, List <int> stopGet)
{
var gt = HangfireBootstrapper.Instance.GetThreadStart();
if (gt.Count != 0)
{
getThread.AddRange(gt);
}
using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DeviceConnection"].ConnectionString))
{
stopGet.ForEach(deviceID =>
{
var oofDevice = connection.Query <GetSleepThread>($"select * from GetSleepThread where TowerName='{towerName}' and DeviceID='{deviceID}'").ToList();
if (oofDevice.Count != 0)
{
connection.Query <GetSleepThread>("delete from GetSleepThread where TowerName='" + towerName + "' and DeviceID='" + deviceID + "'");
var thb = getThread.Where(t => t.TowerName == towerName && t.DeviceID == deviceID).ToList();
thb.ForEach(t =>
{
t.thread.Abort();
getThread.Remove(t);
});
}
});
}
}
public List <GetSleepThread> UnCheckdGet(int unChechkID, string towerName, int deviceID, int towerID, string LogMap, List <GetSleepThread> getThread)
{
GetSleepThread uncheckMapLog = new GetSleepThread();
using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DeviceConnection"].ConnectionString))
{
var getcheck = connection.Query <GetSleepThread>($"select * from GetSleepThread where TowerName='{towerName}' and DeviceID='{deviceID}' and CheckID='{unChechkID}' and TowerID='{towerID}'").FirstOrDefault();
if (LogMap == "Log" || LogMap == "Map")
{
if (getcheck != null)
{
SleepInformation sleepget = new SleepInformation();
if (getThread.Count == 0)
{
getThread = sleepget.SleepGetInformation(false);
}
connection.Query <GetSleepThread>($"delete from GetSleepThread where TowerName='{towerName}' and DeviceID='{deviceID}' and CheckID='{unChechkID}' and TowerID='{towerID}'");
connection.Query <GetSleepThread>($"Update GetSleepThread Set LogID=0 where TowerName='{towerName}' and DeviceID='{deviceID}' and CheckID='{unChechkID}' and TowerID='{towerID}'");
var removeLog = getThread.Where(g => g.TowerName == towerName && g.DeviceID == deviceID && g.CheckID == unChechkID && g.TowerID == towerID).FirstOrDefault();
removeLog.thread.Abort();
getThread.Remove(removeLog);
}
else
{
connection.Query <GetSleepThread>($"Update GetSleepThread Set LogID=0 where TowerName='{towerName}' and DeviceID='{deviceID}' and CheckID='{unChechkID}' and TowerID='{towerID}'");
}
}
else
{
if (getcheck != null && getcheck.LogID != 1)
{
connection.Query <GetSleepThread>($"delete from GetSleepThread where TowerName='{towerName}' and DeviceID='{deviceID}' and CheckID='{unChechkID}' and TowerID='{towerID}'");
connection.Query <GetSleepThread>($"Update GetSleepThread Set MapID=0 where TowerName='{towerName}' and DeviceID='{deviceID}' and CheckID='{unChechkID}' and TowerID='{towerID}'");
var removeLog = getThread.Where(g => g.TowerName == towerName && g.DeviceID == deviceID && g.CheckID == unChechkID && g.TowerID == towerID).FirstOrDefault();
removeLog.thread.Abort();
getThread.Remove(removeLog);
}
else
{
connection.Query <GetSleepThread>($"Update GetSleepThread Set MapID=0 where TowerName='{towerName}' and DeviceID='{deviceID}' and CheckID='{unChechkID}' and TowerID='{towerID}'");
}
}
}
return(getThread);
}
public List <int> PlayThread(bool treadListInd, List <GetSleepThread> getThread, SleepInformation returnedThreadList, List <int> playGet, string towerName, int towerID, DeviceContext db, GetThread getThreadPreset)
{
using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DeviceConnection"].ConnectionString))
{
List <int> palayStop = new List <int>();
playGet.ForEach(deviceID =>
{
var Log = connection.Query <WalkTowerDevice>($"select * from WalkTowerDevice where LogID<>0 and TowerName='{towerName}' and DeviceID='{deviceID}'").ToList();
var Map = connection.Query <WalkTowerDevice>($"select * from WalkTowerDevice where MapID<>0 and TowerName='{towerName}' and DeviceID='{deviceID}'").ToList();
Log.ForEach(l =>
{
GetSleepThread gtl = new GetSleepThread();
gtl.DeviceID = l.DeviceID;
gtl.TowerName = l.TowerName;
gtl.IP = l.IP;
gtl.ScanInterval = l.ScanInterval;
gtl.WalkOid = l.WalkOID;
gtl.Version = l.Version;
gtl.TowerID = towerID;
gtl.CheckID = l.WalkID;
gtl.StartCorrect = l.StartCorrect;
gtl.EndCorrect = l.EndCorrect;
gtl.OneStartError = l.OneStartError;
gtl.OneEndError = l.OneEndError;
gtl.OneStartCrash = l.OneStartCrash;
gtl.OneEndCrash = l.OneEndCrash;
gtl.TwoStartError = l.TwoStartError;
gtl.TwoEndError = l.TwoEndError;
gtl.TwoStartCrash = l.TwoStartCrash;
gtl.TwoEndCrash = l.TwoEndCrash;
gtl.WalkID = l.ID;
gtl.DivideMultiply = l.DivideMultiply;
gtl.StringParserInd = l.StringParserInd;
if (l.MapID == 1)
{
gtl.MapID = 1;
}
gtl.LogID = 1;
gtl.thread = new Thread(() => getThreadPreset.ThreadPreset(l.WalkID, l.StringParserInd, l.DivideMultiply, l.ID, towerID, l.IP, l.ScanInterval, l.DeviceID, l.WalkOID, l.Version, l.StartCorrect, l.EndCorrect, l.OneStartError, l.OneEndError, l.OneStartCrash, l.OneEndCrash, l.TwoStartError, l.TwoEndError, l.TwoStartCrash, l.TwoEndCrash));
gtl.thread.Start();
getThread.Add(gtl);
db.GetSleepThread.Add(gtl);
db.SaveChanges();
});
Map.ForEach(l =>
{
if (l.LogID != 1)
{
GetSleepThread gtl = new GetSleepThread();
gtl.DeviceID = l.DeviceID;
gtl.TowerName = l.TowerName;
gtl.IP = l.IP;
gtl.ScanInterval = l.ScanInterval;
gtl.WalkOid = l.WalkOID;
gtl.Version = l.Version;
gtl.TowerID = towerID;
gtl.CheckID = l.WalkID;
gtl.StartCorrect = l.StartCorrect;
gtl.EndCorrect = l.EndCorrect;
gtl.OneStartError = l.OneStartError;
gtl.OneEndError = l.OneEndError;
gtl.OneStartCrash = l.OneStartCrash;
gtl.OneEndCrash = l.OneEndCrash;
gtl.TwoStartError = l.TwoStartError;
gtl.TwoEndError = l.TwoEndError;
gtl.TwoStartCrash = l.TwoStartCrash;
gtl.TwoEndCrash = l.TwoEndCrash;
gtl.WalkID = l.ID;
gtl.DivideMultiply = l.DivideMultiply;
gtl.StringParserInd = l.StringParserInd;;
gtl.MapID = 1;
gtl.thread = new Thread(() => getThreadPreset.ThreadPreset(l.WalkID, l.StringParserInd, l.DivideMultiply, l.ID, towerID, l.IP, l.ScanInterval, l.DeviceID, l.WalkOID, l.Version, l.StartCorrect, l.EndCorrect, l.OneStartError, l.OneEndError, l.OneStartCrash, l.OneEndCrash, l.TwoStartError, l.TwoEndError, l.TwoStartCrash, l.TwoEndCrash));
gtl.thread.Start();
getThread.Add(gtl);
db.GetSleepThread.Add(gtl);
db.SaveChanges();
}
});
if (Log.Count == 0 && Map.Count == 0)
{
palayStop.Add(deviceID);
}
});
return(palayStop);
}
}
public bool Get(List <GetSleepThread> getThread, SleepInformation returnedThreadList, string towerName, int deviceID, int towerID, DeviceContext db, GetThread getThreadPreset)
{
var gt = /* returnedThreadList.SleepGetInformation(false);*/ HangfireBootstrapper.Instance.GetThreadStart();
if (gt.Count != 0)
{
getThread.AddRange(gt);
}
using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DeviceConnection"].ConnectionString))
{
var oofDevice = connection.Query <GetSleepThread>($"select * from GetSleepThread where TowerName='{towerName}' and DeviceID='{deviceID}'").ToList();
if (oofDevice.Count != 0)
{
connection.Query <GetSleepThread>($"delete from GetSleepThread where TowerName='{towerName}' and DeviceID='{ deviceID }'");
var thb = getThread.Where(t => t.TowerName == towerName && t.DeviceID == deviceID).ToList();
thb.ForEach(t =>
{
t.thread.Abort();
getThread.Remove(t);
});
var toweroff = connection.Query <GetSleepThread>($"select * from GetSleepThread where TowerID='{towerID}'").FirstOrDefault();
if (toweroff != null)
{
return(true);
}
else
{
return(false);
}
}
else
{
var Log = connection.Query <WalkTowerDevice>($"select * from WalkTowerDevice where LogID<>0 and TowerName='{towerName}' and DeviceID='{deviceID}'").ToList();
var Map = connection.Query <WalkTowerDevice>($"select * from WalkTowerDevice where MapID<>0 and TowerName='{towerName}' and DeviceID='{deviceID}'").ToList();
Log.ForEach(l =>
{
GetSleepThread gtl = new GetSleepThread();
gtl.DeviceID = l.DeviceID;
gtl.TowerName = l.TowerName;
gtl.IP = l.IP;
gtl.ScanInterval = l.ScanInterval;
gtl.WalkOid = l.WalkOID;
gtl.Version = l.Version;
gtl.TowerID = towerID;
gtl.CheckID = l.WalkID;
gtl.StartCorrect = l.StartCorrect;
gtl.EndCorrect = l.EndCorrect;
gtl.OneStartError = l.OneStartError;
gtl.OneEndError = l.OneEndError;
gtl.OneStartCrash = l.OneStartCrash;
gtl.OneEndCrash = l.OneEndCrash;
gtl.TwoStartError = l.TwoStartError;
gtl.TwoEndError = l.TwoEndError;
gtl.TwoStartCrash = l.TwoStartCrash;
gtl.TwoEndCrash = l.TwoEndCrash;
gtl.WalkID = l.ID;
gtl.DivideMultiply = l.DivideMultiply;
gtl.StringParserInd = l.StringParserInd;
if (l.MapID == 1)
{
gtl.MapID = 1;
}
gtl.LogID = 1;
gtl.thread = new Thread(() => getThreadPreset.ThreadPreset(l.WalkID, l.StringParserInd, l.DivideMultiply, l.ID, towerID, l.IP, l.ScanInterval, l.DeviceID, l.WalkOID, l.Version, l.StartCorrect, l.EndCorrect, l.OneStartError, l.OneEndError, l.OneStartCrash, l.OneEndCrash, l.TwoStartError, l.TwoEndError, l.TwoStartCrash, l.TwoEndCrash));
gtl.thread.Start();
getThread.Add(gtl);
db.GetSleepThread.Add(gtl);
db.SaveChanges();
});
Map.ForEach(l =>
{
if (l.LogID != 1)
{
GetSleepThread gtl = new GetSleepThread();
gtl.DeviceID = l.DeviceID;
gtl.TowerName = l.TowerName;
gtl.IP = l.IP;
gtl.ScanInterval = l.ScanInterval;
gtl.WalkOid = l.WalkOID;
gtl.Version = l.Version;
gtl.TowerID = towerID;
gtl.CheckID = l.WalkID;
gtl.StartCorrect = l.StartCorrect;
gtl.EndCorrect = l.EndCorrect;
gtl.OneStartError = l.OneStartError;
gtl.OneEndError = l.OneEndError;
gtl.OneStartCrash = l.OneStartCrash;
gtl.OneEndCrash = l.OneEndCrash;
gtl.TwoStartError = l.TwoStartError;
gtl.TwoEndError = l.TwoEndError;
gtl.TwoStartCrash = l.TwoStartCrash;
gtl.TwoEndCrash = l.TwoEndCrash;
gtl.WalkID = l.ID;
gtl.DivideMultiply = l.DivideMultiply;
gtl.StringParserInd = l.StringParserInd;
gtl.MapID = 1;
gtl.thread = new Thread(() => getThreadPreset.ThreadPreset(l.WalkID, l.StringParserInd, l.DivideMultiply, l.ID, towerID, l.IP, l.ScanInterval, l.DeviceID, l.WalkOID, l.Version, l.StartCorrect, l.EndCorrect, l.OneStartError, l.OneEndError, l.OneStartCrash, l.OneEndCrash, l.TwoStartError, l.TwoEndError, l.TwoStartCrash, l.TwoEndCrash));
gtl.thread.Start();
getThread.Add(gtl);
db.GetSleepThread.Add(gtl);
db.SaveChanges();
}
});
if (Log.Count == 0 && Map.Count == 0)
{
return(false);
}
}
}
return(true);
}