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); } }