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