private void wndwStart_Loaded(object sender, RoutedEventArgs e) { tollgatemanagement.Database1DataSet database1DataSet = ((tollgatemanagement.Database1DataSet)(this.FindResource("database1DataSet"))); // Load data into the table Employee. You can modify this code as needed. tollgatemanagement.Database1DataSetTableAdapters.EmployeeTableAdapter database1DataSetEmployeeTableAdapter = new tollgatemanagement.Database1DataSetTableAdapters.EmployeeTableAdapter(); database1DataSetEmployeeTableAdapter.Fill(database1DataSet.Employee); System.Windows.Data.CollectionViewSource employeeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("employeeViewSource"))); employeeViewSource.View.MoveCurrentToFirst(); }
private void Window_Loaded(object sender, RoutedEventArgs e) { // Load data into the table PassType. You can modify this code as needed. tollgatemanagement.Database1DataSetTableAdapters.PassTypeTableAdapter database1DataSetPassTypeTableAdapter = new tollgatemanagement.Database1DataSetTableAdapters.PassTypeTableAdapter(); database1DataSetPassTypeTableAdapter.Fill(getDatabaseDataSet.PassType); System.Windows.Data.CollectionViewSource passTypeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("passTypeViewSource"))); passTypeViewSource.View.MoveCurrentToFirst(); // Load data into the table VAPTable. You can modify this code as needed. tollgatemanagement.Database1DataSetTableAdapters.VAPTableTableAdapter database1DataSetVAPTableTableAdapter = new tollgatemanagement.Database1DataSetTableAdapters.VAPTableTableAdapter(); database1DataSetVAPTableTableAdapter.Fill(getDatabaseDataSet.VAPTable); System.Windows.Data.CollectionViewSource vAPTableViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("vAPTableViewSource"))); vAPTableViewSource.View.MoveCurrentToFirst(); // Load data into the table TollPassDetails. You can modify this code as needed. tollgatemanagement.Database1DataSetTableAdapters.TollPassDetailsTableAdapter database1DataSetTollPassDetailsTableAdapter = new tollgatemanagement.Database1DataSetTableAdapters.TollPassDetailsTableAdapter(); database1DataSetTollPassDetailsTableAdapter.Fill(getDatabaseDataSet.TollPassDetails); System.Windows.Data.CollectionViewSource tollPassDetailsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("tollPassDetailsViewSource"))); tollPassDetailsViewSource.View.MoveCurrentToFirst(); // Load data into the table TollArea. You can modify this code as needed. tollgatemanagement.Database1DataSetTableAdapters.TollAreaTableAdapter database1DataSetTollAreaTableAdapter = new tollgatemanagement.Database1DataSetTableAdapters.TollAreaTableAdapter(); database1DataSetTollAreaTableAdapter.Fill(getDatabaseDataSet.TollArea); System.Windows.Data.CollectionViewSource tollAreaViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("tollAreaViewSource"))); tollAreaViewSource.View.MoveCurrentToFirst(); // Load data into the table PassReciptDetails. You can modify this code as needed. tollgatemanagement.Database1DataSetTableAdapters.PassReciptDetailsTableAdapter database1DataSetPassReciptDetailsTableAdapter = new tollgatemanagement.Database1DataSetTableAdapters.PassReciptDetailsTableAdapter(); database1DataSetPassReciptDetailsTableAdapter.Fill(getDatabaseDataSet.PassReciptDetails); System.Windows.Data.CollectionViewSource passReciptDetailsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("passReciptDetailsViewSource"))); passReciptDetailsViewSource.View.MoveCurrentToFirst(); // Load data into the table Employee. You can modify this code as needed. tollgatemanagement.Database1DataSetTableAdapters.EmployeeTableAdapter database1DataSetEmployeeTableAdapter = new tollgatemanagement.Database1DataSetTableAdapters.EmployeeTableAdapter(); database1DataSetEmployeeTableAdapter.Fill(getDatabaseDataSet.Employee); System.Windows.Data.CollectionViewSource employeeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("employeeViewSource"))); employeeViewSource.View.MoveCurrentToFirst(); // Load data into the table VehicleType. You can modify this code as needed. tollgatemanagement.Database1DataSetTableAdapters.VehicleTypeTableAdapter database1DataSetVehicleTypeTableAdapter = new tollgatemanagement.Database1DataSetTableAdapters.VehicleTypeTableAdapter(); database1DataSetVehicleTypeTableAdapter.Fill(getDatabaseDataSet.VehicleType); System.Windows.Data.CollectionViewSource vehicleTypeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("vehicleTypeViewSource"))); vehicleTypeViewSource.View.MoveCurrentToFirst(); }
private void btnSignIn_Click(object sender, RoutedEventArgs e) { tollgatemanagement.Database1DataSetTableAdapters.EmployeeTableAdapter database1DataSetEmployeeTableAdapter = new tollgatemanagement.Database1DataSetTableAdapters.EmployeeTableAdapter(); tollgatemanagement.Database1DataSetTableAdapters.ProcCheckUserExistTableAdapter q = new tollgatemanagement.Database1DataSetTableAdapters.ProcCheckUserExistTableAdapter(); Database1DataSet.ProcCheckUserExistDataTable t = q.GetData(txtUserName.Text, txtPassword.Password); if ((t.Count == 1) && (t[0][0] != null)) { AppDetails.Create(Convert.ToInt32(t[0][0]), Convert.ToInt32(t[0][1]), Convert.ToBoolean(t[0][2])); if (AppDetails.isAdmin) { ShowPage(new Administrator(this)); } else { ShowPage(new Employee(this)); } } else { MessageBox.Show("Please check your username or password and try again!", "Wrong Username or Password"); } }