private void getSaleData() { // creating an instance of the invoice datacontext naming it dbContext InvoiceDataContext dbContext = new InvoiceDataContext(); // write a linq query var linqQuery = from SalesOrderHeader in dbContext.SalesOrderHeaders join SalesOrderDetail in dbContext.SalesOrderDetails on SalesOrderHeader.SalesOrderID equals SalesOrderDetail.SalesOrderID join SalesCustomer in dbContext.Customers on SalesOrderHeader.CustomerID equals SalesCustomer.CustomerID join ProductionProduct in dbContext.Products on SalesOrderDetail.ProductID equals ProductionProduct.ProductID join Person in dbContext.Persons on SalesCustomer.PersonID equals Person.BusinessEntityID join SalesStore in dbContext.Stores on SalesCustomer.StoreID equals SalesStore.BusinessEntityID // need a date comparison here to select records that from Order Date compared to user entry. // purchase order number is not displaying. where SalesOrderHeader.DueDate >= calStart.SelectedDate && SalesOrderHeader.DueDate <= calEnd.SelectedDate // where SalesOrderHeader.DueDate <= calEnd.SelectedDate orderby SalesCustomer.AccountNumber select new { SoldAt = SalesStore.Name, SoldTo = Person.FirstName + " " + Person.LastName, SalesCustomer.AccountNumber, SalesOrderHeader.SalesOrderNumber, SalesOrderHeader.PurchaseOrderNumber, OrderDate = SalesOrderHeader.OrderDate.ToShortDateString(), DueDate = SalesOrderHeader.DueDate.ToShortDateString(), InvoiceTotal = SalesOrderHeader.TotalDue, ProductionProduct.ProductNumber, SalesOrderDetail.OrderQty, UnitNet = SalesOrderDetail.UnitPrice, SalesOrderDetail.LineTotal, }; GridView1.DataSource = linqQuery; // GridView1.DataSource = linqQuery; GridView1.DataBind(); }
public BaseRepository() { invoiceDbContext = new InvoiceDataContext(); _innerDbSet = invoiceDbContext.Set <T>(); }
public DashBoardViewModel() { db = new InvoiceDataContext(); }
public UserController() { db = new InvoiceDataContext(); }
public InvoiceController() { _invoiceService = new InvoiceService(); db = new InvoiceDataContext(); invoiceRepository = new BaseRepository <InvoiceModel>(); }