public static void AddFileAsProcessed(string file, string connectionString)
{
using (HTMLFileContentDbContext dbContext = new HTMLFileContentDbContext(connectionString))
{
W3SVCLogFilesProcessed w3SVCLogFilesProcessed = new W3SVCLogFilesProcessed();
w3SVCLogFilesProcessed.fileName = file;
w3SVCLogFilesProcessed.DateProcessed = DateTime.Now;
dbContext.W3SVCLogFilesProcessed.Add(w3SVCLogFilesProcessed);
dbContext.SaveChanges();
}
}
public static void SaveContentItemView(HTMLContentView hTMLContentView, string connectionString)
{
using (HTMLFileContentDbContext dbContext = new HTMLFileContentDbContext(connectionString))
{
Mapper.CreateMap <HTMLContentView, HTMLContent>();
Mapper.CreateMap <ContentItemView, ContentItem>();
var hTMLContent = Mapper.Map <HTMLContentView, HTMLContent>(hTMLContentView);
foreach (var item in hTMLContentView.ContentItemsView)
{
hTMLContent.ContentItems.Add(Mapper.Map <ContentItemView, ContentItem>(item));
}
dbContext.HTMLContent.Add(hTMLContent);
dbContext.SaveChanges();
}
}
public static void StoreLine(List <string> lines, string connectionString)
{
using (HTMLFileContentDbContext dbContext = new HTMLFileContentDbContext(connectionString))
{
foreach (string line in lines)
{
string[] lineContent = line.Split(' ');
W3SVCLogFile w3SVCLogFile = new W3SVCLogFile();
w3SVCLogFile.Date = DateTime.ParseExact(lineContent[(int)W3SVCLogFileFields.Date], "yyyy-MM-dd", CultureInfo.InvariantCulture);
w3SVCLogFile.Time = DateTime.ParseExact(lineContent[(int)W3SVCLogFileFields.Time], "H:m:s", null);
w3SVCLogFile.CsBytes = Convert.ToInt32(lineContent[(int)W3SVCLogFileFields.CsBytes]);
w3SVCLogFile.CsCookie = lineContent[(int)W3SVCLogFileFields.CsCookie];
w3SVCLogFile.CSMethod = lineContent[(int)W3SVCLogFileFields.CSMethod];
w3SVCLogFile.CsReferer = lineContent[(int)W3SVCLogFileFields.CsReferer];
w3SVCLogFile.ClientIP = lineContent[(int)W3SVCLogFileFields.ClientIP];
w3SVCLogFile.CSUriQuery = lineContent[(int)W3SVCLogFileFields.CSUriQuery];
w3SVCLogFile.CSUriStem = lineContent[(int)W3SVCLogFileFields.CSUriStem];
w3SVCLogFile.CsUserAgent = lineContent[(int)W3SVCLogFileFields.CsUserAgent];
w3SVCLogFile.CsUsername = lineContent[(int)W3SVCLogFileFields.CsUsername];
w3SVCLogFile.CsVersion = lineContent[(int)W3SVCLogFileFields.CsVersion];
w3SVCLogFile.ScBytes = Convert.ToInt32(lineContent[(int)W3SVCLogFileFields.ScBytes]);
w3SVCLogFile.ScStatus = Convert.ToInt32(lineContent[(int)W3SVCLogFileFields.ScStatus]);
w3SVCLogFile.ScSubStatus = Convert.ToInt32(lineContent[(int)W3SVCLogFileFields.ScSubStatus]);
w3SVCLogFile.ScWin32Status = Convert.ToInt32(lineContent[(int)W3SVCLogFileFields.ScWin32Status]);
w3SVCLogFile.SourceIP = lineContent[(int)W3SVCLogFileFields.SourceIP];
w3SVCLogFile.SourceSitename = lineContent[(int)W3SVCLogFileFields.SourceSitename];
w3SVCLogFile.SPort = Convert.ToInt32(lineContent[(int)W3SVCLogFileFields.SPort]);
w3SVCLogFile.TimeTaken = Convert.ToInt32(lineContent[(int)W3SVCLogFileFields.TimeTaken]);
dbContext.W3SVCLogFile.Add(w3SVCLogFile);
}
dbContext.SaveChanges();
}
}