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>();
}
