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) { } }