private void btnLogin_Click(object sender, EventArgs e)
        {
            // we need to call the user class to check if the user is valid or not.
            User obj = new User();
            obj.UserName = txtUserName.Text;
            obj.Password = txtPassword.Text;
            if(obj.IsValid(obj))
            {
                // valid user
               this.Close();
               BIT.frmMain.ProfileType = obj.ProfileType + " / " + obj.UserName;

            }
            else
            {
                switch (obj.UserID)
                {
                    case -1:
                        MessageBox.Show("Username is incorrect.");
                        break;
                    case -2:
                        MessageBox.Show("Password is incorrect.");
                        break;
                    case -3:
                        MessageBox.Show("Account has not been activated.");
                        break;
                    case -4:
                        MessageBox.Show("User is Locked.");
                        break;

                    default:
                        MessageBox.Show("Invalid credentials");
                        break;
                }
                // invalid user
                //MessageBox.Show("Invalid credentials");
                txtPassword.Text = "";
            }
        }
        private void btnListDelete_Click(object sender, EventArgs e)
        {
            try
            {
                User user = new User();
                DataTable dtUser = new DataTable();
                string msg = "MESSAGE: ";
                int IndexSelected;

                switch (BIT.frmEdit.TabPageSelected)
                {
                    case "tabPageEditClient":                    // Client* selected
                        user.UserName = client.ClientEmailPrimary;
                        dtUser = deleteUserData("Client", user);
                         IndexSelected = dgvListClient.CurrentRow.Index;
                         dt.Rows[IndexSelected].Delete();
                         dgvListClient.Refresh();
                         msg = msg + "Client Deactivated! ";
                        break;
                    case "tabPageEditContractor":                // Contractor* selected
                        user.UserName = contractor.ContractorEmailPrimary;
                        dtUser = deleteUserData("Contractor", user);
                        IndexSelected = dgvListContractor.CurrentRow.Index;
                        dt.Rows[IndexSelected].Delete();
                        dgvListContractor.Refresh();
                        msg = msg + "Contractor Deactivated! ";
                        break;
                    case "tabPageEditCoordinator":               // Coordinator* selected
                        user.UserName = coordinator.CoordinatorEmailPrimary;
                        dtUser = deleteUserData("Coordinator", user);
                        IndexSelected = dgvListCoordinator.CurrentRow.Index;
                        dt.Rows[IndexSelected].Delete();
                        dgvListCoordinator.Refresh();
                        msg = msg + "Coordinator Deactivated! ";
                        break;
                    case "tabPageEditRequest":                   // Request* selected

                        break;
                    case "tabPageEditJob":                       // Job* selected

                        break;
                    case "tabPageEditContractorSkill":          // ContractorSkill* selected

                        break;
                    case "tabPageEditSkill":                     // Skill* selected

                        break;
                    case "tabPageEditLocation":                  // Location* selected

                        break;
                    // ... unauthorized user...
                    default:
                        break;
                }

                if (dtUser.Rows.Count > 0)
                    msg = msg + "with ID: " + Convert.ToString(dtUser.Rows[0][0]);

                MessageBox.Show(msg);

                //lblNewMessage.Text = msg;
                //btnListEdit.Visible = false;

            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.GetType() + ex.Message);
            }
        }
 private DataTable deleteUserData(string roleData, User user)
 {
     DataTable dt = new DataTable();
     dt = User.DeactivateUser(UserRole, roleData, UserLogin, user);
     return dt;
 }
        private User populateCoordinatorUserUIdata(User user)
        {
            user.UserName = coordinator.CoordinatorEmailPrimary;
            user.Email = coordinator.CoordinatorEmailPrimary;

            return user;
        }
        private User populateClientUserUIdata(User user)
        {
            user.UserName = client.ClientEmailPrimary;
            user.Email = client.ClientEmailPrimary;

            return user;
        }
 private DataTable createUserdata(User user, string roleData)
 {
     DataTable dt = new DataTable();
     dt = User.InsertUser(UserRole, roleData, UserLogin, user);
     return dt;
 }
        private void btnNewCreateUser_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            string msg = "MESSAGE: ";

            switch (TabPageSelected)
            {
                case "tabPageNewClient":                    // Client* selected
                    user = new User();
                    dt = createUserdata(populateClientUserUIdata(user), "Client");
                    msg = msg + "Client User Approved & Login Created! ";
                    //client.ClientID = Convert.ToInt32(dt.Rows[0][0]);
                    break;
                case "tabPageNewContractor":                // Contractor* selected
                    user = new User();
                    dt = createUserdata(populateContractorUserUIdata(user), "Contractor");
                    msg = msg + "Contractor User Approved & Login Created! ";
                    //contractor.ContractorID = Convert.ToInt32(dt.Rows[0][0]);
                    break;
                case "tabPageNewCoordinator":               // Coordinator* selected
                    user = new User();
                    dt = createUserdata(populateCoordinatorUserUIdata(user), "Coordinator");
                    msg = msg + "Coordinator User Approved & Login Created! ";
                    //coordinator.CoordinatorID = Convert.ToInt32(dt.Rows[0][0]);
                    break;
                case "tabPageNewRequest":                   // Request* selected

                    break;
                case "tabPageNewJob":                       // Job* selected

                    break;
                case "tabPageNewContractorSkill":          // ContractorSkill* selected

                    break;
                case "tabPageNewSkill":                     // Skill* selected

                    break;
                case "tabPageNewLocation":                  // Location* selected

                    break;
                // ... unauthorized user...
                default:
                    break;
            }

            if (dt.Rows.Count > 0)
                msg = msg + "processed..."; //+ Convert.ToString(dt.Rows[0][0]);

            lblNewMessage.Text = msg;

            pictureBoxCorrect.Visible = true;
            btnNewCreateUser.Visible = false;
            btnNewSave.Visible = true;
        }