private void Form1_Load(object sender, EventArgs e)
{
ctx = new Northwind.Northwind();
var query = ctx.Customers;
customerBindingSource.DataSource = query.ToList();
}
public void ProcessRequest(HttpContext context)
{
string customerID = Convert.ToString(context.Request.Params.Get(CUSTOMER));
DateTime dateTo = Convert.ToDateTime(context.Request.Params.Get(DATE_TO));
DateTime dateFrom = Convert.ToDateTime(context.Request.Params.Get(DATE_FROM));
int take = Convert.ToInt32(context.Request.Params.Get(TAKE));
int skip = Convert.ToInt32(context.Request.Params.Get(SKIP));
using (var db = new Northwind.Northwind())
{
List <Order> orders = db.Orders.ToList();
if (!string.IsNullOrWhiteSpace(customerID))
{
orders = orders.Where(x => x.CustomerID == customerID).ToList();
}
if (dateFrom != DateTime.MinValue)
{
orders = orders.Where(x => x.RequiredDate >= dateFrom).ToList();
}
if (dateTo != DateTime.MinValue)
{
orders = orders.Where(x => x.RequiredDate <= dateTo).ToList();
}
if (skip != 0)
{
orders = orders.Skip(skip).ToList();
}
if (take != 0)
{
orders = orders.Take(take).ToList();
}
if (context.Request.Headers.Get(1).Contains("xml"))
{
ShowXmlFile(orders.ToList(), context);
}
else
{
ShowExcelFile(orders.ToList(), context);
}
}
}
