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