List <VulpesSMARTInfo> LoadData(string MachineID, SQLLib sql)
{
List <VulpesSMARTInfo> lst = new List <VulpesSMARTInfo>();
SqlDataReader dr = sql.ExecSQLReader("Select * from SMARTData WHERE MachineID=@id", new SQLParam("@id", MachineID));
while (dr.Read())
{
VulpesSMARTInfo s = new VulpesSMARTInfo();
sql.LoadIntoClass(dr, s);
lst.Add(s);
}
dr.Close();
foreach (VulpesSMARTInfo sm in lst)
{
sm.Attributes = new Dictionary <int, VulpesSMARTAttribute>();
dr = sql.ExecSQLReader("Select * from SMARTDataAttributes WHERE MachineID=@id AND PnPDeviceID=@pnp",
new SQLParam("@id", MachineID),
new SQLParam("@pnp", sm.PNPDeviceID));
while (dr.Read())
{
VulpesSMARTAttribute attr = new VulpesSMARTAttribute();
sql.LoadIntoClass(dr, attr);
sm.Attributes.Add(attr.ID, attr);
}
dr.Close();
}
return(lst);
}
public RESTStatus GetPackage(SQLLib sql, object dummy, NetworkConnectionInfo ni, Int64 id)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
lock (ni.sqllock)
{
if (PackageExists(sql, id) == false)
{
ni.Error = "Invalid data";
ni.ErrorID = ErrorFlags.InvalidID;
return(RESTStatus.NotFound);
}
}
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("Select * FROM Packages WHERE ID=@id",
new SQLParam("@id", id));
dr.Read();
PackageData = new PackageData();
sql.LoadIntoClass(dr, PackageData);
dr.Close();
}
return(RESTStatus.Success);
}
public RESTStatus GetPackages(SQLLib sql, object dummy, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
PackageDataList = new PackageDataList();
PackageDataList.Items = new List <FoxSDC_Common.PackageData>();
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("Select * FROM Packages");
while (dr.Read())
{
PackageData pd = new PackageData();
sql.LoadIntoClass(dr, pd);
PackageDataList.Items.Add(pd);
}
dr.Close();
}
return(RESTStatus.Success);
}
public RESTStatus GetSTask(SQLLib sql, object dummy, NetworkConnectionInfo ni, Int64 id)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("select * from SimpleTasks WHERE ID=@id", new SQLParam("@id", id));
if (dr.HasRows == false)
{
dr.Close();
return(RESTStatus.NotFound);
}
SimpleTask = new SimpleTask();
while (dr.Read())
{
sql.LoadIntoClass(dr, SimpleTask);
}
dr.Close();
}
return(RESTStatus.Success);
}
public RESTStatus GetPackageSigned(SQLLib sql, object dummy, NetworkConnectionInfo ni, Int64 id)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
lock (ni.sqllock)
{
if (PackageExists(sql, id) == false)
{
ni.Error = "Invalid data";
ni.ErrorID = ErrorFlags.InvalidID;
return(RESTStatus.NotFound);
}
}
PackageData pp = null;
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("Select * FROM Packages WHERE ID=@id",
new SQLParam("@id", id));
dr.Read();
pp = new PackageData();
sql.LoadIntoClass(dr, pp);
dr.Close();
}
PackageDataSigned = new PackageDataSigned();
PackageDataSigned.Package = pp;
if (Certificates.Sign(PackageDataSigned, SettingsManager.Settings.UseCertificate) == false)
{
FoxEventLog.WriteEventLog("Cannot sign package element with Certificate " + SettingsManager.Settings.UseCertificate, System.Diagnostics.EventLogEntryType.Warning);
ni.Error = "Cannot sign package element with Certificate " + SettingsManager.Settings.UseCertificate;
ni.ErrorID = ErrorFlags.CannotSign;
return(RESTStatus.ServerError);
}
return(RESTStatus.Success);
}
public RESTStatus ListSTasks(SQLLib sql, object dummy, NetworkConnectionInfo ni, string id)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
lock (ni.sqllock)
{
SqlDataReader dr;
if (string.IsNullOrWhiteSpace(id) == false)
{
if (Computers.MachineExists(sql, id) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.NotFound);
}
dr = sql.ExecSQLReader("select SimpleTasks.*,ComputerName from SimpleTasks inner join ComputerAccounts on ComputerAccounts.MachineID=SimpleTasks.MachineID where SimpleTasks.MachineID=@m order by MachineID,Name",
new SQLParam("@m", id));
}
else
{
dr = sql.ExecSQLReader("select SimpleTasks.*,ComputerName from SimpleTasks inner join ComputerAccounts on ComputerAccounts.MachineID=SimpleTasks.MachineID order by MachineID,Name");
}
SimpleList = new SimpleTaskLiteList();
SimpleList.List = new List <SimpleTaskLite>();
while (dr.Read())
{
SimpleTaskLite d = new SimpleTaskLite();
sql.LoadIntoClass(dr, d);
SimpleList.List.Add(d);
}
dr.Close();
}
return(RESTStatus.Success);
}
public RESTStatus ListDiskData(SQLLib sql, object dummy, NetworkConnectionInfo ni, string id)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
lock (ni.sqllock)
{
SqlDataReader dr;
if (string.IsNullOrWhiteSpace(id) == false)
{
if (Computers.MachineExists(sql, id) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.NotFound);
}
dr = sql.ExecSQLReader("select DiskData.*,ComputerName from DiskData inner join ComputerAccounts on ComputerAccounts.MachineID=DiskData.MachineID where diskData.MachineID=@m order by MachineID,Caption",
new SQLParam("@m", id));
}
else
{
dr = sql.ExecSQLReader("select DiskData.*,ComputerName from DiskData inner join ComputerAccounts on ComputerAccounts.MachineID=DiskData.MachineID order by MachineID,Caption");
}
LstDiskData = new ListDiskDataReport();
LstDiskData.Items = new List <DiskDataReport>();
while (dr.Read())
{
DiskDataReport d = new DiskDataReport();
sql.LoadIntoClass(dr, d);
LstDiskData.Items.Add(d);
}
dr.Close();
}
return(RESTStatus.Success);
}
public RESTStatus GetSTaskSigned(SQLLib sql, object dummy, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
SimpleTask SimpleTask;
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("select top 1 * from SimpleTasks WHERE MachineID=@id AND GETUTCDATE()>isnull(execafter,'2010-01-01') ORDER BY ID asc",
new SQLParam("@id", ni.Username));
if (dr.HasRows == false)
{
dr.Close();
return(RESTStatus.NoContent);
}
SimpleTask = new SimpleTask();
while (dr.Read())
{
sql.LoadIntoClass(dr, SimpleTask);
}
dr.Close();
}
STaskDataSigned = new SimpleTaskDataSigned();
STaskDataSigned.STask = SimpleTask;
if (Certificates.Sign(STaskDataSigned, SettingsManager.Settings.UseCertificate) == false)
{
FoxEventLog.WriteEventLog("Cannot sign STask Data with Certificate " + SettingsManager.Settings.UseCertificate, System.Diagnostics.EventLogEntryType.Warning);
ni.Error = "Cannot sign STask Data with Certificate " + SettingsManager.Settings.UseCertificate;
ni.ErrorID = ErrorFlags.CannotSign;
return(RESTStatus.ServerError);
}
return(RESTStatus.Success);
}