private void btnChangePassword_Click(object sender, EventArgs e)
 {
     try
     {
         App_Data.PisDataSetTableAdapters.UsersTableAdapter myuserAd = new App_Data.PisDataSetTableAdapters.UsersTableAdapter();
         myuserAd.UpdatePasswordQuery(txtNewPassword.Text, -1 * Classes.publicClass.UserId);
         MessageBox.Show("Password Updated Successfully");
     }
     catch
     {
         MessageBox.Show("Have U inserted Password? Error in Query");
     }
 }
        private void btnDeleteSelected_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count != 1)
            {
                MessageBox.Show("Make Sure You Have Selected Record To Delete");
            }
            else if (MessageBox.Show("Really delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {

                PatientInformationSystem.App_Data.PisDataSetTableAdapters.UsersTableAdapter UsersDA = new App_Data.PisDataSetTableAdapters.UsersTableAdapter();
                UsersDA.DeleteUserQuery(Convert.ToInt32(cmbUserIDs.Items[listView1.FocusedItem.Index]));
                MessageBox.Show("Record Deleted Successfully!");
                listView1.Items.Clear();
                myUserTbl.Clear();
                cmbUserIDs.Items.Clear();
                UsersDA.FillLoginBy(myUserTbl);
                WriteListViewforUsers(myUserTbl);
            }
        }
        private void loginbutton_Click(object sender, EventArgs e)
        {
            try
            {
                bool USerRecordFound = false;
                App_Data.PisDataSetTableAdapters.UsersTableAdapter myUsersAd = new App_Data.PisDataSetTableAdapters.UsersTableAdapter();
                App_Data.PisDataSet.UsersDataTable myUsersTbl = new App_Data.PisDataSet.UsersDataTable();
                myUsersAd.FillLoginBy(myUsersTbl);

                foreach (DataRow myRow in myUsersTbl.Rows)
                {

                    if (myRow["UserName"].ToString().ToLower().Trim() == txtUserName.Text.ToLower().Trim() && myRow["Password"].ToString().Trim() == txtPassword.Text.Trim())
                    {
                        Classes.publicClass.UserId = Convert.ToInt32(myRow["UserID"]);
                        Classes.publicClass.UserType = Convert.ToInt32(myRow["UserType"].ToString());
                        Classes.publicClass.UserName = myRow["UserName"].ToString();

                        USerRecordFound = true;

                        new Forms.MainForm().Show();
                        this.Hide();
                        //this.Close();

                        break;
                    }

                }

                if (!USerRecordFound)
                {
                    MessageBox.Show("Invalid User Name/Password\nPlease Try Again");
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show("Unable to Load Database\n" + exc.Message);
            }
        }
        private void btnAddnewUser_Click(object sender, EventArgs e)
        {
            try
            {
                byte UTyype = 2;
                App_Data.PisDataSetTableAdapters.UsersTableAdapter myuserAd = new App_Data.PisDataSetTableAdapters.UsersTableAdapter();

                if (comboBox1.SelectedItem.ToString() == "Moderator")
                    UTyype = 1;

                myuserAd.InsertUserQuery(txtuserName.Text, txtPassword.Text, UTyype);
                MessageBox.Show("User Added Successfully");
                listView1.Items.Clear();
                myUserTbl.Clear();
                cmbUserIDs.Items.Clear();
                myUserTbl.Clear();
                myuserAd.FillLoginBy(myUserTbl);
                WriteListViewforUsers(myUserTbl);
            }
            catch
            {
                MessageBox.Show("Please Verify Data!! make Sure you haven't added not available username, have given password, and have selected a type");
            }
        }
        private void UserCP_Load(object sender, EventArgs e)
        {
            App_Data.PisDataSetTableAdapters.UsersTableAdapter myUsersAd = new App_Data.PisDataSetTableAdapters.UsersTableAdapter();
            lblWelcome.Text = Classes.publicClass.UserName;

            if (Classes.publicClass.UserType == 1)//if its moderator instead of 2 which is normal user
            {
                groupBox1.Enabled = true;
                myUsersAd.FillLoginBy(myUserTbl);
                WriteListViewforUsers(myUserTbl);
            }
        }