public void LinkToEmployee() { TBikeDAL MyDAL = new TBikeDAL(); int index = dataGrid1.Items.IndexOf(dataGrid1.CurrentItem); DataTable ResultTable = MyDAL.ShowAllEmployeeDetails(); if (index == -1) { index = 0; } else { string id = Convert.ToString(ResultTable.Rows[index]["EmployeeID"]); string self = Convert.ToString(ResultTable.Rows[index]["Username"]); if (id != null) { if (RankID >= 4 || self == username) { EmployeeModify emp = new EmployeeModify(); emp.PopulateDataFromLogin(username); emp.populateEmployee(id); emp.ShowDialog(); } else { PopWindow pop = new PopWindow(ImageType.Warning, "Error", "Rank too low to access this service", "Alright"); pop.ShowDialog(); } } } }
private void dataGrid1_SelectionChanged(object sender, SelectionChangedEventArgs e) { DataRowView dataRow = (DataRowView)dataGrid1.SelectedItem; int index = dataGrid1.Items.IndexOf(dataGrid1.CurrentItem); //string cellValue = dataRow.Row.ItemArray[index].ToString(); TBikeDAL MyDAL = new TBikeDAL(); DataTable ResultTable = MyDAL.ShowAllEmployeeDetails(); id = Convert.ToString(ResultTable.Rows[index]["EmployeeID"]); self = Convert.ToString(ResultTable.Rows[index]["username"]); int Rank = Convert.ToInt32(ResultTable.Rows[index]["EmployeeRank"]); if (RankID >= 4 || self == username) { if (self == username || RankID > Rank) { BTNPromote.Visibility = Visibility.Visible; } else { BTNPromote.Visibility = Visibility.Hidden; } } else { BTNPromote.Visibility = Visibility.Hidden; } }
public void PopulateEmployeeDetails() { TBikeDAL MyDAL = new TBikeDAL(); DataTable ResultTable = MyDAL.ShowAllEmployeeDetails(); dataGrid1.ItemsSource = ResultTable.DefaultView; dataGrid1.AutoGenerateColumns = false; dataGrid1.CanUserAddRows = false; }
public async void VerifyRequirements() { TBikeDAL MyDal = new TBikeDAL(); DataTable ResultTable = MyDal.SelectEmployeeID("", TBUsername.Text); DataTable ResultTableEmployee = MyDal.ShowAllEmployeeDetails(); int i = 0; int a = 0; string Email; foreach (DataRow row in ResultTableEmployee.Rows) { Email = Convert.ToString(ResultTableEmployee.Rows[i]["Email"]); if (Email == TBEmail.Text) { a = a + 1; } i++; } if (ResultTable.Rows.Count > 0) { if (TBUsername.Text == Convert.ToString(ResultTable.Rows[0]["Username"]).Trim()) { PopWindow pop = new PopWindow(ImageType.Information, "Error", "Username has been used", "ok, i will check again"); pop.ShowDialog(); } else if (TBConfirmPassword != TBPassword) { var res = await this.ShowMessageAsync("Password Not Match", "Password not match with confirm pasword"); } //TLRankDesc.Text = Convert.ToString(ResultTable.Rows[0]["EmployeeRankDesc"]).Trim(); //username = Convert.ToString(ResultTable.Rows[0]["Username"]).Trim(); //RankID = Convert.ToInt32(ResultTable.Rows[0]["EmployeeRank"]); } else { if ((TBConfirmPassword.Password.ToString().Trim()) != (TBPassword.Password.ToString().Trim())) { var res = await this.ShowMessageAsync("Password Not Match", "Password not match with confirm pasword"); } else if (a == 0) { var res = await this.ShowMessageAsync("Sorry", "This Email has no record"); } else { //var res = await this.ShowMessageAsync("No Record", "No Email address record found "); MyDal.AddNewEmployeeLoginInfo(TBEmail.Text, TBUsername.Text, TBPassword.Password.ToString().Trim()); var res = await this.ShowMessageAsync("Registration Completed", " Please go back and Login"); this.Close(); } } }