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 bool IsFileProcessed(string file, string connectionString)
{
using (HTMLFileContentDbContext dbContext = new HTMLFileContentDbContext(connectionString))
{
if (dbContext.W3SVCLogFilesProcessed.Where(x => x.fileName == file).Count() > 0)
{
return(true);
}
}
return(false);
}
public static string GetContentForDisplay(int contentID, string connectionString)
{
StringBuilder sb = new StringBuilder();
using (HTMLFileContentDbContext dbContext = new HTMLFileContentDbContext(connectionString))
{
var hTMLContent = dbContext.HTMLContent.FirstOrDefault(x => x.HTMLContentID == contentID);
foreach (var item in hTMLContent.ContentItems)
{
sb.AppendLine(item.Content);
}
}
return(sb.ToString());
}
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 List <ContentListItem> GetContentList(ContentArea contentArea, string connectionString)
{
List <ContentListItem> contentList = new List <ContentListItem>();
using (HTMLFileContentDbContext dbContext = new HTMLFileContentDbContext(connectionString))
{
contentList = dbContext.HTMLContent.Where(x => x.ContentArea == contentArea)
.OrderBy(x => x.DisplayOrder).ThenBy(x => x.MainTitle)
.Select(x => new ContentListItem
{
MainTitle = x.MainTitle,
SecondaryTitle = x.SecondaryTitle,
HTMLContentID = x.HTMLContentID
}).ToList();
}
return(contentList);
}
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();
}
}
