private void mnuReport_Click(object sender, RoutedEventArgs e)
{
DataModel.IISM_Dataset.CorporationDataTable dt = new DataModel.IISM_Dataset.CorporationDataTable();
DataModel.IISM_DatasetTableAdapters.CorporationTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.CorporationTableAdapter();
adpt.Fill(dt);
DataModel.IISM_Dataset.BussinessTypeDataTable dt2 = new DataModel.IISM_Dataset.BussinessTypeDataTable();
DataModel.IISM_DatasetTableAdapters.BussinessTypeTableAdapter adpt2 = new DataModel.IISM_DatasetTableAdapters.BussinessTypeTableAdapter();
adpt2.Fill(dt2);
var qry = from corp in dt
join bs in dt2 on corp.BussinessTypeID equals bs.BussinessTypeID
select new
{
CorpId = corp.CorpID.ToString("00"), CorpName = corp.CorpDesc,
corp.Address, corp.Postal, corp.Phone, corp.Email, corp.Fax, IsActive = corp.Active,
BussinessTypeID = corp.BussinessTypeID.ToString("000"), bs.BussinessDesc
};
Classes.FillDataGridcs._lst.Clear();
Classes.FillDataGridcs.DataGridName = "Corporations";
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();
}
//Executer Report - DVG 07-20-18
private void mnuReport_Click(object sender, RoutedEventArgs e)
{
DataModel.IISM_Dataset.BussinessTypeDataTable dt = new DataModel.IISM_Dataset.BussinessTypeDataTable();
DataModel.IISM_DatasetTableAdapters.BussinessTypeTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.BussinessTypeTableAdapter();
adpt.Fill(dt);
var qry = from i in dt
select new
{
ID = i.BussinessTypeID.ToString("000"),
i.BussinessDesc
};
Classes.FillDataGridcs._lst.Clear();
Classes.FillDataGridcs.DataGridName = "Bussiness Type";
foreach (var item in qry)
{
Classes.FillDataGridcs.AddElements(item);
}
dt.Dispose(); adpt.Dispose();
IISM.DataGrid.TemplateDataGrid OpenW = new IISM.DataGrid.TemplateDataGrid();
OpenW.Show();
}
private void mnuReport_Click(object sender, RoutedEventArgs e)
{
DataModel.IISM_Dataset.BussinessTypeDataTable dt = new DataModel.IISM_Dataset.BussinessTypeDataTable();
DataModel.IISM_DatasetTableAdapters.BussinessTypeTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.BussinessTypeTableAdapter();
adpt.Fill(dt);
DataModel.IISM_Dataset.CustomersDataTable dt2 = new DataModel.IISM_Dataset.CustomersDataTable();
DataModel.IISM_DatasetTableAdapters.CustomersTableAdapter adpt2 = new DataModel.IISM_DatasetTableAdapters.CustomersTableAdapter();
adpt2.Fill(dt2);
var qry = from Cust in dt2
join bs in dt on Cust.BussinessTypeID equals bs.BussinessTypeID
select new
{
CustID = Cust.CstnoID.ToString("0000"), Cust.CstName, Cust.Address, Cust.Postal,
Cust.Phone, Cust.Email, Cust.Fax, IsActive = Cust.Active, Cust.BussinessTypeID, bs.BussinessDesc
};
Classes.FillDataGridcs._lst.Clear();
Classes.FillDataGridcs.DataGridName = "Customers";
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)
{
try
{
DataModel.IISM_Dataset.SUPPLIERSDataTable dt = new DataModel.IISM_Dataset.SUPPLIERSDataTable();
DataModel.IISM_DatasetTableAdapters.SUPPLIERSTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.SUPPLIERSTableAdapter();
adpt.Fill(dt);
DataModel.IISM_Dataset.BussinessTypeDataTable dt2 = new DataModel.IISM_Dataset.BussinessTypeDataTable();
DataModel.IISM_DatasetTableAdapters.BussinessTypeTableAdapter adpt2 = new DataModel.IISM_DatasetTableAdapters.BussinessTypeTableAdapter();
adpt2.Fill(dt2);
var qry = from s in dt
join bt in dt2 on s.BussinessTypeID equals bt.BussinessTypeID
select new
{
SupplierId = s.SupplierID.ToString("00000"),
s.Name,
s.Address,
s.Postal,
s.Phone,
s.EMAIL,
s.FAX,
BussinessTypeID = s.BussinessTypeID.ToString("000"),
bt.BussinessDesc
};
Classes.FillDataGridcs._lst.Clear();
Classes.FillDataGridcs.DataGridName = "Suppliers";
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();
}
catch (Exception)
{
}
}
