public AddEquipmentsReport(string user_id) { InitializeComponent(); try { // maintainance_reports.ItemsSource = values.AsDataView(); ExcelFileSelector fileS = new ExcelFileSelector(); fileS.ShowDialog(); values = DBManager.SelectFromExcel(fileS.fileName, fileS.sheetName, fileS.cellValues); values.Columns.Add("user_id", typeof(System.String)); //MessageBox.Show("Error Occured", "Invalid Data size", MessageBoxButton.OK, MessageBoxImage.Error); foreach (DataRow row in values.Rows) { row["user_id"] = user_id;//need to set value to NewColumn column } /* if (values.Columns.Count != 12) * { * MessageBox.Show( "Invalid Data size", "Error Occured", MessageBoxButton.OK, MessageBoxImage.Error); * this.Close(); * }*/ maintainance_reports.ItemsSource = values.AsDataView(); } catch { } }
public PurchaseRequest() { InitializeComponent(); try { // purchase_request.ItemsSource = values.AsDataView(); ExcelFileSelector fileS = new ExcelFileSelector(); fileS.ShowDialog(); values = DBManager.SelectFromExcel(fileS.fileName, fileS.sheetName, fileS.cellValues); purchase_request.ItemsSource = values.AsDataView(); } catch { } }
public NewServiceRequest() { InitializeComponent(); try { // maintainance_request.ItemsSource = values.AsDataView(); ExcelFileSelector fileS = new ExcelFileSelector(); fileS.ShowDialog(); values = DBManager.SelectFromExcel(fileS.fileName, fileS.sheetName, fileS.cellValues); service_request.ItemsSource = values.AsDataView(); } catch (Exception ex) { } }
public NewInsurancePayment() { InitializeComponent(); try { // insurance_payments.ItemsSource = values.AsDataView(); ExcelFileSelector fileS = new ExcelFileSelector(); fileS.ShowDialog(); values = DBManager.SelectFromExcel(fileS.fileName, fileS.sheetName, fileS.cellValues); insurance_payments.ItemsSource = values.AsDataView(); } catch { } }
public AddMaintainanceReport() { InitializeComponent(); // maintainance_reports.ItemsSource = values.AsDataView(); ExcelFileSelector fileS = new ExcelFileSelector(); fileS.ShowDialog(); try { DataTable values = DBManager.SelectFromExcel(fileS.fileName, fileS.sheetName, fileS.cellValues); maintainance_reports.ItemsSource = values.AsDataView(); } catch (Exception ex) { } }