public RESTStatus ReportEventLog(SQLLib sql, ListEventLogReport EventLogList, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
EventLogList.MachineID = ni.Username;
lock (ni.sqllock)
{
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM ComputerAccounts WHERE MachineID=@m",
new SQLParam("@m", EventLogList.MachineID))) == 0)
{
ni.Error = "Invalid MachineID";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Denied);
}
}
if (EventLogList.Items == null)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
if (EventLogList.Items.Count == 0)
{
return(RESTStatus.Created);
}
DateTime DT = DateTime.Now;
foreach (EventLogReport ar in EventLogList.Items)
{
if (NullTest.Test(ar) == false)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
CommonUtilities.CalcEventLogID(ar);
}
List <SQLParam> sqlparams = new List <SQLParam>();
sqlparams.Add(new SQLParam("@id", EventLogList.MachineID));
int count = 1;
string vars = "";
foreach (EventLogReport ar in EventLogList.Items)
{
sqlparams.Add(new SQLParam("@p" + count.ToString(), ar.LogID));
vars += "@p" + count.ToString() + ",";
count++;
}
if (vars.EndsWith(",") == true)
{
vars = vars.Substring(0, vars.Length - 1);
}
List <string> LogIDinDB = new List <string>();
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("SELECT LogID FROM EventLog WHERE MachineID=@id and LogID in (" + vars + ")", sqlparams.ToArray());
while (dr.Read())
{
LogIDinDB.Add(Convert.ToString(dr["LogID"]));
}
dr.Close();
}
List <EventLogReport> RemoveEVL = new List <EventLogReport>();
foreach (EventLogReport ar in EventLogList.Items)
{
if (LogIDinDB.Contains(ar.LogID) == true)
{
RemoveEVL.Add(ar);
continue;
}
if (SettingsManager.Settings.KeepEventLogDays > 0)
{
if (ar.TimeGenerated < DateTime.UtcNow.AddDays(0 - SettingsManager.Settings.KeepEventLogDays))
{
RemoveEVL.Add(ar);
continue;
}
}
}
foreach (EventLogReport ar in RemoveEVL)
{
EventLogList.Items.Remove(ar);
}
List <EventLogReportFull> car = new List <EventLogReportFull>();
lock (ni.sqllock)
{
try
{
sql.BeginTransaction();
sql.SEHError = true;
foreach (EventLogReport ar in EventLogList.Items)
{
EventLogReportFull arr = new EventLogReportFull();
ClassCopy.CopyClassData(ar, arr);
arr.Reported = DateTime.UtcNow;
arr.MachineID = EventLogList.MachineID;
List <SQLData> d = sql.InsertFromClassPrep(arr);
foreach (SQLData dd in d)
{
if (dd.Column == "ID")
{
dd.Data = DBNull.Value;
break;
}
}
car.Add(arr);
sql.InsertFromClass("EventLog", arr);
}
sql.CommitTransaction();
}
catch (Exception ee)
{
sql.RollBackTransaction();
FoxEventLog.WriteEventLog("DB Error: Cannot insert data to EventLog: " + ee.ToString() + "\r\n\r\nJSON: " +
JsonConvert.SerializeObject(car, Formatting.Indented), System.Diagnostics.EventLogEntryType.Error);
return(RESTStatus.ServerError);
}
finally
{
sql.SEHError = false;
}
}
Thread t = new Thread(new ParameterizedThreadStart(new DReportingThread(ReportingThread)));
t.Start(car);
return(RESTStatus.Created);
}
public RESTStatus ReportAddRemovePrograms(SQLLib sql, ListAddRemoveApps AddRemoveList, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
AddRemoveList.MachineID = ni.Username;
lock (ni.sqllock)
{
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM ComputerAccounts WHERE MachineID=@m",
new SQLParam("@m", AddRemoveList.MachineID))) == 0)
{
ni.Error = "Invalid MachineID";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Denied);
}
}
if (AddRemoveList.Items == null)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
if (AddRemoveList.SIDUsers == null)
{
AddRemoveList.SIDUsers = new List <string>();
}
foreach (AddRemoveApp rep in AddRemoveList.Items)
{
if (rep.ProductID == null)
{
rep.ProductID = "";
}
if (rep.Name == null)
{
rep.Name = "";
}
if (rep.DisplayVersion == null)
{
rep.DisplayVersion = "";
}
if (rep.UninstallString == null)
{
rep.UninstallString = "";
}
if (rep.Language == null)
{
rep.Language = "";
}
if (rep.DisplayLanguage == null)
{
rep.DisplayLanguage = "";
}
if (rep.HKCUUser == null)
{
rep.HKCUUser = "";
}
rep.ProductID = rep.ProductID.Trim();
rep.Name = rep.Name.Trim();
rep.DisplayVersion = rep.DisplayVersion.Trim();
rep.UninstallString = rep.UninstallString.Trim();
rep.Language = rep.Language.Trim();
rep.DisplayLanguage = rep.DisplayLanguage.Trim();
rep.HKCUUser = rep.HKCUUser.Trim();
}
List <AddRemoveApp> Installed = new List <AddRemoveApp>();
List <AddRemoveApp> Reported = AddRemoveList.Items;
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("SELECT * FROM AddRemovePrograms WHERE MachineID=@id", new SQLParam("@id", AddRemoveList.MachineID));
while (dr.Read())
{
AddRemoveApp ar = new AddRemoveApp();
ar.DisplayLanguage = Convert.ToString(dr["DisplayLanguage"]);
ar.DisplayVersion = Convert.ToString(dr["DisplayVersion"]);
ar.IsMSI = Convert.ToBoolean(dr["IsMSI"]);
ar.IsWOWBranch = Convert.ToBoolean(dr["IsWOWBranch"]);
ar.IsSystemComponent = Convert.ToBoolean(dr["IsSystemComponent"]);
ar.Language = Convert.ToString(dr["Language"]);
ar.MachineID = Convert.ToString(dr["MachineID"]);
ar.Name = Convert.ToString(dr["Name"]);
ar.ProductID = Convert.ToString(dr["ProductID"]);
ar.UninstallString = Convert.ToString(dr["UninstallString"]);
ar.VersionMajor = Convert.ToInt32(dr["VersionMajor"]);
ar.VersionMinor = Convert.ToInt32(dr["VersionMinor"]);
ar.HKCUUser = Convert.ToString(dr["HKCUUser"]);
if (string.IsNullOrWhiteSpace(ar.HKCUUser) == true)
{
ar.HKCUUser = "";
}
Installed.Add(ar);
}
dr.Close();
}
List <AddRemoveApp> Updated = new List <AddRemoveApp>();
List <AddRemoveApp> Unchanged = new List <AddRemoveApp>();
List <AddRemoveApp> Removed = new List <AddRemoveApp>();
List <AddRemoveApp> Added = new List <AddRemoveApp>();
foreach (AddRemoveApp inst in Installed)
{
if (inst.ProductID == null)
{
inst.ProductID = "";
}
if (inst.Name == null)
{
inst.Name = "";
}
if (inst.DisplayVersion == null)
{
inst.DisplayVersion = "";
}
if (inst.UninstallString == null)
{
inst.UninstallString = "";
}
if (inst.Language == null)
{
inst.Language = "";
}
if (inst.DisplayLanguage == null)
{
inst.DisplayLanguage = "";
}
inst.ProductID = inst.ProductID.Trim();
inst.Name = inst.Name.Trim();
inst.DisplayVersion = inst.DisplayVersion.Trim();
inst.UninstallString = inst.UninstallString.Trim();
inst.Language = inst.Language.Trim();
inst.DisplayLanguage = inst.DisplayLanguage.Trim();
inst.HKCUUser = inst.HKCUUser.Trim();
bool Found = false;
foreach (AddRemoveApp rep in Reported)
{
if (rep.ProductID.ToLower() == inst.ProductID.ToLower() && rep.IsWOWBranch == inst.IsWOWBranch && rep.HKCUUser == inst.HKCUUser)
{
if (rep.IsMSI == inst.IsMSI && rep.IsSystemComponent == inst.IsSystemComponent && rep.Name.ToLower() == inst.Name.ToLower() &&
rep.DisplayVersion.ToLower() == inst.DisplayVersion.ToLower() && inst.UninstallString.ToLower() == rep.UninstallString.ToLower() &&
rep.VersionMajor == inst.VersionMajor && rep.VersionMinor == inst.VersionMinor && rep.Language.ToLower() == inst.Language.ToLower() &&
rep.DisplayLanguage.ToLower() == inst.DisplayLanguage.ToLower())
{
Unchanged.Add(rep);
Found = true;
break;
}
else
{
Updated.Add(rep);
Found = true;
break;
}
}
}
if (Found == false)
{
if (inst.HKCUUser != "" && AddRemoveList.SIDUsers.Contains(inst.HKCUUser, StringComparer.InvariantCultureIgnoreCase) == false)
{
//likely that this user is not logged on or such
Unchanged.Add(inst);
}
else
{
Removed.Add(inst);
}
}
}
foreach (AddRemoveApp inst in Reported)
{
bool Found = false;
foreach (AddRemoveApp rep in Installed)
{
if (rep.ProductID.ToLower() == inst.ProductID.ToLower() && rep.IsWOWBranch == inst.IsWOWBranch && rep.HKCUUser == inst.HKCUUser)
{
Found = true;
break;
}
}
if (Found == false)
{
Added.Add(inst);
}
}
lock (ni.sqllock)
{
try
{
sql.BeginTransaction();
sql.SEHError = true;
foreach (AddRemoveApp ar in Removed)
{
sql.ExecSQL("DELETE FROM AddRemovePrograms WHERE MachineID=@id AND IsWOWBranch=@wow AND ProductID=@prod AND HKCUUser=@user",
new SQLParam("@id", AddRemoveList.MachineID),
new SQLParam("@prod", ar.ProductID),
new SQLParam("@user", ar.HKCUUser),
new SQLParam("@wow", ar.IsWOWBranch));
}
foreach (AddRemoveApp ar in Updated)
{
sql.ExecSQL(@"UPDATE AddRemovePrograms SET
IsMSI=@IsMSI,
IsSystemComponent=@IsSystemComponent,
Name=@Name,
DisplayVersion=@DisplayVersion,
UninstallString=@UninstallString,
VersionMajor=@VersionMajor,
VersionMinor=@VersionMinor,
Language=@Language,
DisplayLanguage=@DisplayLanguage,
DT=@DT
WHERE MachineID=@id AND IsWOWBranch=@wow AND ProductID=@prod AND HKCUUser=@user",
new SQLParam("@id", AddRemoveList.MachineID),
new SQLParam("@prod", ar.ProductID),
new SQLParam("@wow", ar.IsWOWBranch),
new SQLParam("@IsMSI", ar.IsMSI),
new SQLParam("@IsSystemComponent", ar.IsSystemComponent),
new SQLParam("@Name", ar.Name.Trim()),
new SQLParam("@DisplayVersion", ar.DisplayVersion),
new SQLParam("@UninstallString", ar.UninstallString),
new SQLParam("@VersionMajor", ar.VersionMajor),
new SQLParam("@VersionMinor", ar.VersionMinor),
new SQLParam("@Language", ar.Language),
new SQLParam("@DisplayLanguage", ar.DisplayLanguage),
new SQLParam("@user", ar.HKCUUser),
new SQLParam("@DT", DateTime.UtcNow));
}
foreach (AddRemoveApp ar in Added)
{
sql.InsertMultiData("AddRemovePrograms",
new SQLData("MachineID", AddRemoveList.MachineID),
new SQLData("ProductID", ar.ProductID),
new SQLData("IsWOWBranch", ar.IsWOWBranch),
new SQLData("IsMSI", ar.IsMSI),
new SQLData("IsSystemComponent", ar.IsSystemComponent),
new SQLData("Name", ar.Name.Trim()),
new SQLData("DisplayVersion", ar.DisplayVersion),
new SQLData("UninstallString", ar.UninstallString),
new SQLData("VersionMajor", ar.VersionMajor),
new SQLData("VersionMinor", ar.VersionMinor),
new SQLData("Language", ar.Language),
new SQLData("DisplayLanguage", ar.DisplayLanguage),
new SQLData("HKCUUser", ar.HKCUUser),
new SQLData("DT", DateTime.UtcNow));
}
sql.CommitTransaction();
}
catch (Exception ee)
{
sql.RollBackTransaction();
FoxEventLog.WriteEventLog("DB Error: Cannot update AddRemovePrograms: " + ee.ToString(), System.Diagnostics.EventLogEntryType.Error);
return(RESTStatus.ServerError);
}
finally
{
sql.SEHError = false;
}
}
AddRemoveProgramsLst l = new AddRemoveProgramsLst();
l.Added = Added;
l.Removed = Removed;
l.Unchanged = Unchanged;
l.Updated = Updated;
l.MachineID = AddRemoveList.MachineID;
Thread t = new Thread(new ParameterizedThreadStart(new DReportingThread(ReportingThread)));
t.Start(l);
return(RESTStatus.Created);
}
public RESTStatus ReportStatups(SQLLib sql, ListStartupItems StartupList, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
StartupList.MachineID = ni.Username;
lock (ni.sqllock)
{
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM ComputerAccounts WHERE MachineID=@m",
new SQLParam("@m", StartupList.MachineID))) == 0)
{
ni.Error = "Invalid MachineID";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Denied);
}
}
if (StartupList.Items == null)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
if (StartupList.SIDUsers == null)
{
StartupList.SIDUsers = new List <string>();
}
foreach (StartupItem rep in StartupList.Items)
{
if (string.IsNullOrWhiteSpace(rep.Location) == true)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
if (string.IsNullOrWhiteSpace(rep.Key) == true)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
if (string.IsNullOrWhiteSpace(rep.HKCUUser) == true)
{
rep.HKCUUser = "";
}
if (string.IsNullOrWhiteSpace(rep.Item) == true)
{
rep.Item = "";
}
}
List <StartupItem> Installed = new List <StartupItem>();
List <StartupItem> Reported = StartupList.Items;
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("SELECT * FROM Startups WHERE MachineID=@id", new SQLParam("@id", StartupList.MachineID));
while (dr.Read())
{
StartupItem ar = new StartupItem();
ar.Location = Convert.ToString(dr["Location"]);
ar.Key = Convert.ToString(dr["Key"]);
ar.Item = Convert.ToString(dr["Item"]);
ar.HKCUUser = Convert.ToString(dr["HKCUUser"]);
if (string.IsNullOrWhiteSpace(ar.HKCUUser) == true)
{
ar.HKCUUser = "";
}
Installed.Add(ar);
}
dr.Close();
}
List <StartupItem> Updated = new List <StartupItem>();
List <StartupItem> Unchanged = new List <StartupItem>();
List <StartupItem> Removed = new List <StartupItem>();
List <StartupItem> Added = new List <StartupItem>();
foreach (StartupItem inst in Installed)
{
inst.Location = inst.Location.Trim();
inst.Key = inst.Key.Trim();
inst.Item = inst.Item.Trim();
inst.HKCUUser = inst.HKCUUser.Trim();
bool Found = false;
foreach (StartupItem rep in Reported)
{
rep.Location = rep.Location.Trim();
rep.Key = rep.Key.Trim();
rep.Item = rep.Item.Trim();
rep.HKCUUser = rep.HKCUUser.Trim();
if (rep.Location.ToLower() == inst.Location.ToLower() && rep.Key == inst.Key && rep.HKCUUser == inst.HKCUUser)
{
if (rep.Item.ToLower() == inst.Item.ToLower())
{
Unchanged.Add(rep);
Found = true;
break;
}
else
{
Updated.Add(rep);
Found = true;
break;
}
}
}
if (Found == false)
{
if (inst.HKCUUser != "" && StartupList.SIDUsers.Contains(inst.HKCUUser, StringComparer.InvariantCultureIgnoreCase) == false)
{
//likely that this user is not logged on or such
Unchanged.Add(inst);
}
else
{
Removed.Add(inst);
}
}
}
foreach (StartupItem inst in Reported)
{
bool Found = false;
foreach (StartupItem rep in Installed)
{
if (rep.Key.ToLower() == inst.Key.ToLower() && rep.Location == inst.Location && rep.HKCUUser == inst.HKCUUser)
{
Found = true;
break;
}
}
if (Found == false)
{
Added.Add(inst);
}
}
lock (ni.sqllock)
{
try
{
sql.BeginTransaction();
sql.SEHError = true;
foreach (StartupItem ar in Removed)
{
sql.ExecSQL("DELETE FROM Startups WHERE MachineID=@id AND [Key]=@key AND Location=@location AND HKCUUser=@user",
new SQLParam("@id", StartupList.MachineID),
new SQLParam("@key", ar.Key),
new SQLParam("@user", ar.HKCUUser),
new SQLParam("@location", ar.Location));
}
foreach (StartupItem ar in Updated)
{
sql.ExecSQL(@"UPDATE Startups SET
Item=@item,
DT=@DT
WHERE MachineID=@id AND [Key]=@key AND Location=@location AND HKCUUser=@user",
new SQLParam("@id", StartupList.MachineID),
new SQLParam("@key", ar.Key),
new SQLParam("@user", ar.HKCUUser),
new SQLParam("@location", ar.Location),
new SQLParam("@item", ar.Item),
new SQLParam("@DT", DateTime.UtcNow));
}
foreach (StartupItem ar in Added)
{
sql.InsertMultiData("Startups",
new SQLData("MachineID", StartupList.MachineID),
new SQLData("Item", ar.Item),
new SQLData("Location", ar.Location),
new SQLData("Key", ar.Key),
new SQLData("HKCUUser", ar.HKCUUser),
new SQLData("DT", DateTime.UtcNow));
}
sql.CommitTransaction();
}
catch (Exception ee)
{
sql.RollBackTransaction();
FoxEventLog.WriteEventLog("DB Error: Cannot update Startups: " + ee.ToString(), System.Diagnostics.EventLogEntryType.Error);
return(RESTStatus.ServerError);
}
finally
{
sql.SEHError = false;
}
}
StartupLst l = new StartupLst();
l.Added = Added;
l.Removed = Removed;
l.Unchanged = Unchanged;
l.Updated = Updated;
l.MachineID = StartupList.MachineID;
Thread t = new Thread(new ParameterizedThreadStart(new DReportingThread(ReportingThread)));
t.Start(l);
return(RESTStatus.Created);
}
public RESTStatus ReportDiskData(SQLLib sql, ListDiskDataReport DiskDataList, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
DiskDataList.MachineID = ni.Username;
lock (ni.sqllock)
{
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM ComputerAccounts WHERE MachineID=@m",
new SQLParam("@m", DiskDataList.MachineID))) == 0)
{
ni.Error = "Invalid MachineID";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.NotFound);
}
}
if (DiskDataList.Items == null)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
lock (ni.sqllock)
{
sql.ExecSQL("UPDATE DiskData SET DevicePresent=0 WHERE MachineID=@m",
new SQLParam("@m", DiskDataList.MachineID));
}
foreach (DiskDataReport dr in DiskDataList.Items)
{
lock (ni.sqllock)
{
sql.ExecSQL("DELETE FROM DiskData WHERE MachineID=@m AND DeviceID=@d",
new SQLParam("@d", dr.DeviceID),
new SQLParam("@m", DiskDataList.MachineID));
}
}
List <List <SQLData> > bulkdata = new List <List <SQLData> >();
DateTime DT = DateTime.Now;
DiskDataReport cdr = null;
lock (ni.sqllock)
{
try
{
sql.BeginTransaction();
sql.SEHError = true;
foreach (DiskDataReport dr in DiskDataList.Items)
{
sql.InsertMultiData("DiskData",
new SQLData("MachineID", dr.MachineID),
new SQLData("DevicePresent", true),
new SQLData("LastUpdated", DT),
new SQLData("DeviceID", dr.DeviceID),
new SQLData("Access", dr.Access),
new SQLData("Automount", dr.Automount),
new SQLData("Availability", dr.Availability),
new SQLData("Capacity", dr.Capacity),
new SQLData("Caption", dr.Caption),
new SQLData("Compressed", dr.Compressed),
new SQLData("ConfigManagerErrorCode", dr.ConfigManagerErrorCode),
new SQLData("Description", dr.Description),
new SQLData("DirtyBitSet", dr.DirtyBitSet),
new SQLData("DriveLetter", dr.DriveLetter),
new SQLData("DriveType", dr.DriveType),
new SQLData("ErrorDescription", dr.ErrorDescription),
new SQLData("ErrorMethodology", dr.ErrorMethodology),
new SQLData("FileSystem", dr.FileSystem),
new SQLData("FreeSpace", dr.FreeSpace),
new SQLData("Label", dr.Label),
new SQLData("LastErrorCode", dr.LastErrorCode),
new SQLData("MaximumFileNameLength", dr.MaximumFileNameLength),
new SQLData("Name", dr.Name),
new SQLData("PNPDeviceID", dr.PNPDeviceID),
new SQLData("SerialNumber", dr.SerialNumber),
new SQLData("Status", dr.Status));
}
sql.CommitTransaction();
}
catch (Exception ee)
{
sql.RollBackTransaction();
FoxEventLog.WriteEventLog("DB Error: Cannot insert data to DiskData: " + ee.ToString() + "\r\n\r\nJSON: " +
JsonConvert.SerializeObject(cdr, Formatting.Indented), System.Diagnostics.EventLogEntryType.Error);
return(RESTStatus.ServerError);
}
finally
{
sql.SEHError = false;
}
}
Thread t = new Thread(new ParameterizedThreadStart(new DReportingThread(ReportingThread)));
t.Start(DiskDataList);
return(RESTStatus.Success);
}
