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); }