/// <summary> /// Called when [remove usb from black list]. /// </summary> /// <param name="BlackUSB">The black usb.</param> /// <returns>OnRemoveUSBFromBlackListResponse object.if successful return a "BlackProcessRemoved" Message and if the old balack process is not find for remove return "BlackProcessNotFindToRemoved" message if process watcher is stoped or not created ergo return "ProcessWatcherIsNotRunning" message else return error</returns> public static OnRemoveUSBFromBlackListResponse OnRemoveUSBFromBlackList(_m_USB_Watcher_Disable_Enable_Node RuleToRemove) { OnRemoveUSBFromBlackListResponse ROnRemoveUSBFromBlackListResponse = new OnRemoveUSBFromBlackListResponse(); try { if (mUSBw != null) { if (mUSBw.RemoveRuleFromList(RuleToRemove)) { ROnRemoveUSBFromBlackListResponse.Description = "BlackUSBRemoved"; } else { ROnRemoveUSBFromBlackListResponse.Description = "BlackUSBNotFindToRemoved"; } } else { ROnRemoveUSBFromBlackListResponse.Description = "USBWatcherIsNotRunning"; } } catch (Exception ex) { ROnRemoveUSBFromBlackListResponse.Errors.AddErrorToErrorList(MethodBase.GetCurrentMethod().ToString(), ex.Message); } return(ROnRemoveUSBFromBlackListResponse); }
public void RemoveRuleFromDB(_m_USB_Watcher_Disable_Enable_Node RuleNode) { string sql = "DELETE from DisableEnableRuleList where RuleName==@RuleName"; SQLiteCommand cmd = new SQLiteCommand(sql, dbConnection); cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SQLiteParameter("@RuleName", RuleNode.RuleName)); SQLiteDataReader reader = cmd.ExecuteReader(); }
private _m_USB_Watcher_Disable_Enable_Node ReaderToRule(SQLiteDataReader Reader) { _m_USB_Watcher_Disable_Enable_Node micden = new _m_USB_Watcher_Disable_Enable_Node(); micden.RuleName = Reader["RuleName"].ToString(); micden.StartTime = DateTime.Parse(Reader["StartTime"].ToString()); micden.EndTime = DateTime.Parse(Reader["EndTime"].ToString()); micden.Action = bool.Parse(Reader["Action"].ToString()); micden.DeviceId = Reader["DeviceId"].ToString(); micden.RuleStatus = bool.Parse(Reader["RuleStatus"].ToString()); return(micden); }
public void AddRuleToDB(_m_USB_Watcher_Disable_Enable_Node RuleNode) { SQLiteCommand cmd = new SQLiteCommand(dbConnection); cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into DisableEnableRuleList (RuleName,StartTime,EndTime,Action,DeviceId,RuleStatus) values (@RuleName,@StartTime,@EndTime,@Action,@DeviceId,@RuleStatus)"; cmd.Parameters.Add("RuleName", DbType.String).Value = RuleNode.RuleName; cmd.Parameters.Add("StartTime", DbType.DateTime).Value = RuleNode.StartTime; cmd.Parameters.Add("EndTime", DbType.DateTime).Value = RuleNode.EndTime; cmd.Parameters.Add("Action", DbType.Boolean).Value = RuleNode.Action; cmd.Parameters.Add("DeviceId", DbType.String).Value = RuleNode.DeviceId; cmd.Parameters.Add("RuleStatus", DbType.Boolean).Value = RuleNode.RuleStatus; cmd.ExecuteNonQuery(); }
/// <summary> /// Called when [add usb to black list]. /// </summary> /// <param name="BlackUSB">The black process.</param> /// <returns>OnAddUSBToBlackListResponse object.if successful return a "NewBlackUSBAdded" Message if process watcher is stoped or not created ergo return "USBWatcherIsNotRunning" message else return error</returns> public static OnAddUSBToBlackListResponse OnAddUSBToBlackList(_m_USB_Watcher_Disable_Enable_Node RuleToAdd) { OnAddUSBToBlackListResponse ROnAddUSBToBlackListResponse = new OnAddUSBToBlackListResponse(); try { if (mUSBw != null) { mUSBw.AddRuleToList(RuleToAdd); ROnAddUSBToBlackListResponse.Description = "NewBlackUSBAdded"; } else { ROnAddUSBToBlackListResponse.Description = "USBWatcherIsNotRunning"; } } catch (Exception ex) { ROnAddUSBToBlackListResponse.Errors.AddErrorToErrorList(MethodBase.GetCurrentMethod().ToString(), ex.Message); } return(ROnAddUSBToBlackListResponse); }
public bool RemoveRuleFromList(_m_USB_Watcher_Disable_Enable_Node RuleToRemove) { mUSBwdeDB.RemoveRuleFromDB(RuleToRemove); return(RuleList.Remove(RuleToRemove)); }
//TODO disable enable rule //TODO get and send db log to server public void AddRuleToList(_m_USB_Watcher_Disable_Enable_Node RuleToAdd) { mUSBwdeDB.AddRuleToDB(RuleToAdd); RuleList.Add(RuleToAdd); }