private void mnuReport_Click(object sender, RoutedEventArgs e)
{
try
{
DataModel.IISM_Dataset.WarehouseDataTable dt = new DataModel.IISM_Dataset.WarehouseDataTable();
DataModel.IISM_DatasetTableAdapters.WarehouseTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.WarehouseTableAdapter();
adpt.Fill(dt);
var qry = from i in dt
select new
{
WhID = i.WhID.ToString("00"),
i.WhDesc,
i.Notes
};
Classes.FillDataGridcs._lst.Clear();
Classes.FillDataGridcs.DataGridName = "Warehouses";
foreach (var item in qry)
{
Classes.FillDataGridcs.AddElements(item);
}
dt.Dispose(); adpt.Dispose();
IISM.DataGrid.TemplateDataGrid OpenW = new IISM.DataGrid.TemplateDataGrid();
OpenW.Show();
}
catch (Exception)
{
}
}
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();
}
