// GET LOGS BY MAC
//public List<Log> LogGetByMAC(int MAC)
//{
// List<Log> results = LogGetAll().Where(l => l.MAC.Equals(MAC)).ToList();
// return results;
//}
public Result TelemeryInsert(Telemery telemery)
{
Result result = new Result();
TelemeryFilter filter = new TelemeryFilter();
Workpoint point = WorkpointGetByMAC(telemery.MAC);
if (point.IsActive)
{
filter.DateStart = telemery.DateCreated.AddMinutes(-2);
filter.DateEnd = telemery.DateCreated.AddMinutes(2);
filter.FloorID = point.FloorID;
filter.OfficeID = point.OfficeID;
List <Telemery> LatestTelemeries = TelemeryGetFilter(filter);
if (LatestTelemeries.Count > 0)
{
Telemery theOne = LatestTelemeries.Where(t => t.MAC.ToLower().Equals(telemery.MAC.ToLower())).FirstOrDefault();
if (!theOne.IsActive)
{
result = deviceRepository.TelemeryInsert(telemery);
}
}
else
{
result = deviceRepository.TelemeryInsert(telemery);
}
}
return(result);
}
internal List <Telemery> TelemeryGetFilter(TelemeryFilter parameter)
{
var result = new List <Telemery>();
var reader = dbConnection.Select("usp_Telemery_GetFilter", parameter, CommandType.StoredProcedure);
if (reader != null)
{
if (reader.Rows.Count > 0)
{
foreach (DataRow row in reader.Rows)
{
Telemery item = new Telemery();
item.ID = transform.ToInt(row["ID"]);
item.MAC = row["MAC"].ToString();
item.IPAddress = row["IPAddress"].ToString();
item.DateCreated = transform.ToDateTime(row["DateCreated"]);
item.Battery = Convert.ToBoolean(row["Battery"]);
item.HubID = transform.ToInt(row["HubID"]);
item.WorkpointID = transform.ToInt(row["WorkpointID"]);
item.IsActive = transform.ToBool(row["IsActive"]);
item.IsDeleted = transform.ToBool(row["IsDeleted"]);
result.Add(item);
}
}
}
return(result);
}
public IEnumerable <Telemery> RequestTelemery(TelemeryFilter filter)
{
DeviceManager manager = new DeviceManager();
return(manager.TelemeryGetFilter(filter));
}
public List <Telemery> TelemeryGetFilter(TelemeryFilter parameter)
{
return(deviceRepository.TelemeryGetFilter(parameter));
}
