public void ProcessRequest(HttpContext context)
{
using (var dc = new LogDataContext())
{
var data = string.IsNullOrEmpty(context.Request["data"]) ? "" : (string)context.Request["data"];
foreach (var VARIABLE in data.Split(';'))
{
dc.CreateEvent(VARIABLE);
}
}
}
public void ProcessRequest( HttpContext context )
{
context.Response.ContentEncoding = Encoding.GetEncoding( 1251 );
context.Response.ContentType = "text/csv";
context.Response.AddHeader( "Content-Disposition", "attachment; filename=\"search_log.csv\"" );
DateTime date1 = DateTime.Parse( context.Request[ "date1" ] );
DateTime date2 = DateTime.Parse( context.Request[ "date2" ] );
using( var dc = new LogDataContext() )
{
context.Response.Write( "SearchDate;tbPartNumber;tbManufacturer;ClientIP\r\n" );
foreach( var log in SearchSparePartsLogDac.GetLog( dc, date1, date2 ) )
{
context.Response.Write( string.Format( "{0:yyyy-MM-dd HH:mm:ss};\"{1}\";{2};{3}\r\n",
log.SearchDate,
log.PartNumber.Replace( "\"", "\"\"" ),
log.Manufacturer != null ? "\"" + log.Manufacturer.Replace( "\"", "\"\"" ) + "\"" : "",
log.ClientIP ) );
}
}
}
public static IQueryable<SearchSparePartsLog> GetLog( LogDataContext dc, DateTime date1, DateTime date2 )
{
return _getSearchSparePartsLog( dc, date1, date2 );
}