コード例 #1
0
        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();
                    }
                }
            }
        }
コード例 #2
0
        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;
            }
        }
コード例 #3
0
        public void PopulateEmployeeDetails()
        {
            TBikeDAL MyDAL = new TBikeDAL();

            DataTable ResultTable = MyDAL.ShowAllEmployeeDetails();


            dataGrid1.ItemsSource         = ResultTable.DefaultView;
            dataGrid1.AutoGenerateColumns = false;
            dataGrid1.CanUserAddRows      = false;
        }
コード例 #4
0
        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();
                }
            }
        }