Exemplos de Equipment_Manager ExcelFileSelector em C# (CSharp)

Exemplo n.º 1

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

Exemplo n.º 2

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

Exemplo n.º 3

Arquivo: NewServiceRequest.xaml.cs Projeto: samirahmt2018/EquipmentManager

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

Exemplo n.º 4

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

Exemplo n.º 5

Arquivo: AddMaintainanceReport.xaml.cs Projeto: samirahmt2018/EquipmentManager

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