public static AuditMaster GetAuditMaster(string tableName, int status)
{
DataTable dt = null;
AuditMaster audit = null;
try
{
using (SQLiteConnection connection = new SQLiteConnection(DBManager.ConnectionString))
{
connection.Open();
using (var transaction = connection.BeginTransaction())
{
using (SQLiteCommand selectCommand = new SQLiteCommand("select dbid, auditjobidserver,includeuser,includeprocess, " +
"includenetworkinfo,includeautorunpoints,includeprefetch," +
"includeservices,includedns,includearp,includeinstalledapp,includetask,status,receivedtime FROM " + tableName + " where status = " + status, connection))
{
using (SQLiteDataReader dataReader = selectCommand.ExecuteReader())
{
if (tableName == string.Empty)
{
tableName = "unknown";
}
dt = new DataTable(tableName);
dt.Load(dataReader);
}
}
string json = JsonConvert.SerializeObject(dt);
List <AuditMaster> listAuditMaster = JsonConvert.DeserializeObject <List <AuditMaster> >(json);
audit = listAuditMaster.FirstOrDefault();
if (audit != null)
{
UpdateQuery.UpdateAuditInitiateStatus(connection, audit.ClientJobID);
}
transaction.Commit();
}
}
}
catch (Exception)
{
throw;
}
return(audit);
}
public static AuditMaster GetAuditMaster(string auditMas)
{
AuditMaster audit = JsonConvert.DeserializeObject <AuditMaster>(auditMas);
return(audit);
}
public static void StartWindAuditor(string auditMaster)
{
winaudits.AuditMaster audit = winaudits.AuditMaster.GetAuditMaster(auditMaster);
winaudits.InsertQueries.InsertInAuditMaster(audit);
StartWindAuditor();
}
