using System; using System.Linq; using System.Web.UI; using Common; public partial class Root_Invoices : Page { public int I { get; private set; } protected void Page_Load(object sender, EventArgs e) { using (var db = new DataModel()) { Trace.Warn("User.Identity.Name", User.Identity.Name); var customerLogin = db.GetCustomerLoginFromGuid(User.Identity.Name).FirstOrDefault(); if (customerLogin == null) return; var customer = db.Customers.FirstOrDefault(f => f.CustomerId == customerLogin.CustomerId); if (customer == null) return; Trace.Warn("customerLogin.CustomerId", customerLogin.CustomerId.ToString()); //var invoices = db.vwInvoicesReadyToPrints.Where(i => i.CustomerId == customerLogin.CustomerId).Distinct().OrderByDescending(o => o.Id).Take(90).ToList(); var dispatches = db.GetDispatchesReadyToPrint(customerLogin.CustomerId).OrderByDescending(o => o.DeliveryId).Take(90).ToList(); InvoicesForIncludeType.DataSource = dispatches; InvoicesForIncludeType.DataBind(); } } }