public bool Delete(int id, int type)
{
bool result = true;
{
switch (type)
{
case 1:
Workpoint workpoint = deviceRepository.WorkpointGetByID(id);
workpoint.IsDeleted = true;
deviceRepository.WorkpointUpdate(workpoint);
cacheNinja.ClearCache("Workpoint_GetAll");
break;
case 2:
Hub hub = deviceRepository.HubGetByID(id);
hub.IsDeleted = true;
deviceRepository.HubUpdate(hub);
cacheNinja.ClearCache("Hub_GetAll");
break;
default:
break;
}
}
return(result);
}
public IActionResult CreateTelemeryByBatch(IEnumerable <Telemery> parameters)
{
DeviceManager manager = new DeviceManager();
List <Result> results = new List <Result>();
if (parameters.Count() > 0)
{
foreach (Telemery parameter in parameters)
{
if (manager.IsActive(parameter.MAC, 1))
{
Workpoint point = manager.WorkpointGetByMAC(parameter.MAC);
parameter.WorkpointID = point.ID;
parameter.IsActive = true;
parameter.IsDeleted = false;
Result result = manager.TelemeryInsert(parameter);
if (result.ID > 0)
{
results.Add(result);
}
}
}
if (results.Count() > 0)
{
return(Ok(results));
}
}
return(BadRequest());
}
public Result WorkpointUpdate(Workpoint workpoint)
{
Result result = deviceRepository.WorkpointUpdate(workpoint);
cacheNinja.ClearCache("Workpoint_GetAll");
return(result);
}
// 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);
}
public List <Workpoint> WorkpointGetAll()
{
var result = new List <Workpoint>();
var reader = dbConnection.Select("usp_Workpoint_GetAll", null, CommandType.StoredProcedure);
if (reader != null)
{
if (reader.Rows.Count > 0)
{
foreach (DataRow row in reader.Rows)
{
Workpoint item = new Workpoint();
item.ID = transform.ToInt(row["ID"]);
item.Name = row["Name"].ToString();
item.MAC = row["MAC"].ToString();
item.IPaddress = row["IPAddress"].ToString();
item.CoordinateX = transform.ToDouble(row["CoordinateX"]);
item.CoordinateY = transform.ToDouble(row["CoordinateY"]);
item.CoordinateZ = transform.ToDouble(row["CoordinateZ"]);
item.OfficeID = transform.ToInt(row["OfficeID"]);
item.FloorID = transform.ToInt(row["FloorID"]);
item.RoomID = transform.ToInt(row["RoomID"]);
item.HubID = transform.ToInt(row["HubID"]);
item.IsActive = transform.ToBool(row["IsActive"]);
item.IsDeleted = transform.ToBool(row["IsDeleted"]);
result.Add(item);
}
}
}
return(result);
}
public Workpoint WorkpointGetByID(int id)
{
Workpoint item = new Workpoint();
object parameter = new Workpoint()
{
ID = id
};
var reader = dbConnection.Select("usp_Workpoint_GetByID", parameter, CommandType.StoredProcedure);
if (reader != null)
{
if (reader.Rows.Count > 0)
{
item.ID = id;
item.IPaddress = reader.Rows[0]["OfficeID"].ToString();
item.OfficeID = transform.ToInt(reader.Rows[0]["OfficeID"]);
item.RoomID = transform.ToInt(reader.Rows[0]["RoomID"]);
item.FloorID = transform.ToInt(reader.Rows[0]["FloorID"]);
item.IsActive = transform.ToBool(reader.Rows[0]["IsActive"]);
item.IsDeleted = transform.ToBool(reader.Rows[0]["IsDeleted"]);
}
}
return(item);
}
public IActionResult Add(Workpoint workpoints, Hub hubs)
{
if (workpoints.Type == 1)
{
deviceManager.WorkpointInsert(workpoints);
}
else
if (hubs.Type == 2)
{
deviceManager.HubInsert(hubs);
}
cacheNinja.ClearCache("Workpoint_GetAll");
cacheNinja.ClearCache("Hub_GetAll");
return(RedirectToAction("Index"));
}
public IActionResult Edit(Workpoint workpoint, Hub hub, int type)
{
switch (type)
{
case 1:
deviceManager.WorkpointUpdate(workpoint);
cacheNinja.ClearCache("Workpoint_GetAll");
break;
case 2:
deviceManager.HubUpdate(hub);
cacheNinja.ClearCache("Hub_GetAll");
break;
default:
break;
}
return(RedirectToAction("Index"));
}
public bool IsActive(string MAC, int type = 0)
{
bool result = false;
try
{
switch (type)
{
case 1:
List <Workpoint> workpoints = WorkpointGetAll();
result = workpoints.FirstOrDefault(w => w.MAC.Equals(MAC)).IsActive;
break;
case 2:
List <Hub> hubs = HubGetAll();
result = hubs.FirstOrDefault(w => w.MAC.Equals(MAC)).IsActive;
break;
default:
List <Hub> xhubs = HubGetAll();
List <Workpoint> xworkpoints = WorkpointGetAll();
Hub hub = xhubs.FirstOrDefault(x => x.MAC.Equals(MAC));
Workpoint wpoint = xworkpoints.FirstOrDefault(x => x.MAC.Equals(MAC));
if (hub != new Hub())
{
result = hub.IsActive;
}
else
{
result = wpoint.IsActive;
}
break;
}
}
catch (Exception error)
{
result = false;
}
return(result);
}
public Workpoint WorkpointGetByMAC(string MAC)
{
Workpoint workpoint = WorkpointGetAll().FirstOrDefault(w => w.MAC.Equals(MAC));
return(workpoint);
}
public Result WorkpointInsert(Workpoint workpoint)
{
Result result = deviceRepository.WorkpointInsert(workpoint);
return(result);
}
public Result WorkpointUpdate(Workpoint parameter)
{
var result = dbConnection.Update("usp_Workpoint_Update", parameter);
return(result);
}
public Result WorkpointInsert(Workpoint parameter)
{
var result = dbConnection.Insert("usp_Workpoint_Insert", parameter);
return(result);
}
