/// <summary>
/// Create a new iis_failed_request object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
/// <param name="url">Initial value of the url property.</param>
/// <param name="duration">Initial value of the duration property.</param>
/// <param name="created">Initial value of the created property.</param>
/// <param name="computer">Initial value of the computer property.</param>
/// <param name="status">Initial value of the status property.</param>
public static iis_failed_request Createiis_failed_request(global::System.Int32 id, global::System.String url, global::System.Int32 duration, global::System.DateTime created, global::System.String computer, global::System.String status)
{
iis_failed_request iis_failed_request = new iis_failed_request();
iis_failed_request.ID = id;
iis_failed_request.url = url;
iis_failed_request.duration = duration;
iis_failed_request.created = created;
iis_failed_request.computer = computer;
iis_failed_request.status = status;
return(iis_failed_request);
}
/// <summary>
/// Deprecated Method for adding a new object to the iis_failed_request EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToiis_failed_request(iis_failed_request iis_failed_request)
{
base.AddObject("iis_failed_request", iis_failed_request);
}
/// <summary>
/// Deprecated Method for adding a new object to the iis_failed_request EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToiis_failed_request(iis_failed_request iis_failed_request)
{
base.AddObject("iis_failed_request", iis_failed_request);
}
public static void TransferToSqlAzure()
{
GenUtils.LogMsg("info", "IIS_FailedRequestLogs.TransferToSqlAzure", null);
var bs = BlobStorage.MakeDefaultBlobStorage();
var containername = "wad-iis-failedreqlogfiles";
var failed_req_dicts = (List<Dictionary<string, string>>)bs.ListBlobs(containername).response;
failed_req_dicts = failed_req_dicts.FindAll(blob => (blob["Name"].EndsWith("xsl") == false));
var failed_req_blobs = failed_req_dicts.Select(blob => blob["Name"]);
var model_name = "iis_failed_request";
var conn_str = GenUtils.MakeEntityConnectionString(model_name);
var entities = new iis_failed_request_entities(conn_str);
foreach (var blobname in failed_req_blobs)
{
var iis_failed_request = new iis_failed_request();
XDocument xdoc;
XElement failed_request;
try
{
var response = bs.GetBlob(containername, blobname).HttpResponse;
xdoc = XmlUtils.XdocFromXmlBytes(response.bytes);
failed_request = xdoc.Root;
XNamespace evt_ns = "http://schemas.microsoft.com/win/2004/08/events/event";
var system = failed_request.Descendants(evt_ns + "System").First();
var time_created_str = system.Element(evt_ns + "TimeCreated").Attribute("SystemTime").Value;
iis_failed_request.computer = system.Element(evt_ns + "Computer").Value;
iis_failed_request.created = DateTime.Parse(time_created_str);
iis_failed_request.reason = failed_request.Attribute("failureReason").Value;
iis_failed_request.duration = Convert.ToInt32(failed_request.Attribute("timeTaken").Value);
iis_failed_request.status = failed_request.Attribute("statusCode").Value;
iis_failed_request.url = failed_request.Attribute("url").Value;
}
catch (Exception ex_xml)
{
GenUtils.PriorityLogMsg("exception", "IIS_FailedRequestLogs.TransferToSqlAzure Unpack XML", ex_xml.Message + ex_xml.InnerException.Message + ex_xml.StackTrace);
}
try
{
entities.AddObject(entitySetName: model_name, entity: iis_failed_request);
var db_result = entities.SaveChanges();
if (db_result != 1)
GenUtils.PriorityLogMsg("warning", "IIS_FailedRequestLogs.TransferToSqlAzure expected 1 saved change but got " + db_result.ToString(), null);
}
catch (Exception ex_db)
{
GenUtils.PriorityLogMsg("exception", "IIS_FailedRequestLogs.TransferToSqlAzure SaveChanges", ex_db.Message + ex_db.InnerException.Message + ex_db.StackTrace);
}
try
{
var bs_result = bs.DeleteBlob(containername, blobname);
var status = bs_result.HttpResponse.status;
if (status != System.Net.HttpStatusCode.Accepted)
GenUtils.LogMsg("warning", "IIS_FailedRequestLogs.TransferToSqlAzure expected Accepted but got " + status.ToString(), null);
}
catch (Exception bs_db)
{
GenUtils.PriorityLogMsg("exception", "IIS_FailedRequestLogs.TransferToSqlAzure DeleteBlob", bs_db.Message + bs_db.StackTrace);
}
}
}
/// <summary>
/// Create a new iis_failed_request object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
/// <param name="url">Initial value of the url property.</param>
/// <param name="duration">Initial value of the duration property.</param>
/// <param name="created">Initial value of the created property.</param>
/// <param name="computer">Initial value of the computer property.</param>
/// <param name="status">Initial value of the status property.</param>
public static iis_failed_request Createiis_failed_request(global::System.Int32 id, global::System.String url, global::System.Int32 duration, global::System.DateTime created, global::System.String computer, global::System.String status)
{
iis_failed_request iis_failed_request = new iis_failed_request();
iis_failed_request.ID = id;
iis_failed_request.url = url;
iis_failed_request.duration = duration;
iis_failed_request.created = created;
iis_failed_request.computer = computer;
iis_failed_request.status = status;
return iis_failed_request;
}