private void mnuReport_Click(object sender, RoutedEventArgs e)
{
DataModel.IISM_Dataset.ProductsDataTable dt = new DataModel.IISM_Dataset.ProductsDataTable();
DataModel.IISM_DatasetTableAdapters.ProductsTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.ProductsTableAdapter();
adpt.Fill(dt);
DataModel.IISM_Dataset.ProducCategoryDataTable dt2 = new DataModel.IISM_Dataset.ProducCategoryDataTable();
DataModel.IISM_DatasetTableAdapters.ProducCategoryTableAdapter adpt2 = new DataModel.IISM_DatasetTableAdapters.ProducCategoryTableAdapter();
adpt2.Fill(dt2);
var qry = from p in dt
join c in dt2 on p.PCatID equals c.PCatID
select new
{
Prodno = p.ProdNoID.ToString("0000"), p.ProdName, p.Price, p.Description,
IsActive = p.Active, SalesTax = p.IVU, p.Cost, PCatID = p.PCatID.ToString("000"), c.PCatDesc
};
Classes.FillDataGridcs._lst.Clear();
Classes.FillDataGridcs.DataGridName = "Products";
foreach (var item in qry)
{
Classes.FillDataGridcs.AddElements(item);
}
dt.Dispose(); adpt.Dispose(); dt2.Dispose(); adpt2.Dispose();
IISM.DataGrid.TemplateDataGrid OpenW = new IISM.DataGrid.TemplateDataGrid();
OpenW.Show();
}
private void mnuReport_Click(object sender, RoutedEventArgs e)
{
DataModel.IISM_Dataset.ProdInventoryDataTable dt = new DataModel.IISM_Dataset.ProdInventoryDataTable();
DataModel.IISM_DatasetTableAdapters.ProdInventoryTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.ProdInventoryTableAdapter();
adpt.Fill(dt);
DataModel.IISM_Dataset.WarehouseDataTable dt2 = new DataModel.IISM_Dataset.WarehouseDataTable();
DataModel.IISM_DatasetTableAdapters.WarehouseTableAdapter adpt2 = new DataModel.IISM_DatasetTableAdapters.WarehouseTableAdapter();
adpt2.Fill(dt2);
DataModel.IISM_Dataset.ProductsDataTable dt3 = new DataModel.IISM_Dataset.ProductsDataTable();
DataModel.IISM_DatasetTableAdapters.ProductsTableAdapter adpt3 = new DataModel.IISM_DatasetTableAdapters.ProductsTableAdapter();
adpt3.Fill(dt3);
var qry = from pi in dt
join wh in dt2 on pi.WhID equals wh.WhID
join p in dt3 on pi.ProdNoID equals p.ProdNoID
orderby pi.ProdNoID, pi.WhID
select new
{
WhId = pi.WhID.ToString("00"), wh.WhDesc,
ProdNo = pi.ProdNoID.ToString("0000"), p.ProdName,
Quantity = Convert.ToDecimal(pi.Quantity)
};
Classes.FillDataGridcs._lst.Clear();
Classes.FillDataGridcs.DataGridName = "Products Inventory";
foreach (var item in qry)
{
Classes.FillDataGridcs.AddElements(item);
}
dt.Dispose(); adpt.Dispose(); dt2.Dispose(); adpt2.Dispose(); dt3.Dispose(); adpt3.Dispose();
IISM.DataGrid.TemplateDataGrid OpenW = new IISM.DataGrid.TemplateDataGrid();
OpenW.Show();
}
