private void btnUpdate_Click(object sender, EventArgs e) { //Get the values from User UI u.id = Convert.ToInt32(txtID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.user_type = cnbUserType.Text; u.added_date = DateTime.Now; u.gender = cnbGender.Text; u.added_by = 1; //Updating Data into Database bool success = daL.Update(u); //if data is Updated the value of success will be true or else false if (success == true) { MessageBox.Show("UserData Updated Sucessfully"); clear(); } else { MessageBox.Show("Failed to Update UserData"); } //Refereshing Data Grid view DataTable dt = daL.Select(); dgvUsers.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { //Get the values UI u.id = Convert.ToInt32(txtUserId.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAdress.Text; u.gender = cmbGender.Text; u.user_type = cmbUsertype.Text; u.added_date = DateTime.Now; u.added_by = 1; //Update data in BD bool success = dal.Update(u); if (success == true) { MessageBox.Show("User succesfully Updated"); clear(); } else { MessageBox.Show("Failed to Update the user"); } //Refreshing Data Grid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { //get the values from the UI u.user_id = int.Parse(textBoxUserId.Text); u.full_name = textBoxFullName.Text; u.email = textBoxEmail.Text; u.username = textBoxUsername.Text; u.password = textBoxPassword.Text; u.contact = textBoxContact.Text; u.address = textBoxAddress.Text; u.added_date = DateTime.Now; u.image_name = imageName; //create a boolean variable to check if the data is updated successfully bool success = dal.Update(u); //check if the data is updated or not if (success == true) { //data updated successfully MessageBox.Show("User updated successfully."); //refresh data grid view DataTable dt = dal.Select(); dgvUsers.DataSource = dt; //clear the textboxes Clear(); } }
private void button2_Click(object sender, EventArgs e) { // Get the values from userUI u.id = Convert.ToInt32(textBox8.Text); u.first_name = textBox1.Text; u.last_name = textBox2.Text; u.email = textBox3.Text; u.username = textBox4.Text; u.password = textBox5.Text; u.contact = textBox6.Text; u.address = textBox7.Text; u.gender = comboBox1.Text; u.user_type = comboBox2.Text; u.added_date = DateTime.Now; u.added_by = 1; //updating into database bool success = dal.Update(u); if (success == true) { MessageBox.Show("User/Admin updated Succesfully !!!"); } else { MessageBox.Show("Values not got update, please retry.."); } }
private void btnUpdate_Click(object sender, EventArgs e) { u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtpass.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbgender.Text; u.user_type = CmbUserType.Text; u.added_date = DateTime.Now; u.added_by = 1; bool success = dal.Update(u); if (success == true) { MessageBox.Show("USER SUCCESSFULLY UPDATED"); clear(); } else { MessageBox.Show("Failed to update user"); } DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { //Get the values from User UI u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; // This DateTime.Now will show the current date when user adds data u.added_by = 1; // currently we don't have user id so we wil put it later //Updating Data into Database bool success = dal.Update(u); //if data is updated sucessfully then the value of success will be true else it will be false if (success == true) { //Data Updated Sucessfully MessageBox.Show("User Sucessfully Updated"); } else { // failed to update user MessageBox.Show("Failed to Update User"); } //Refreshing Data Grid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { //Step1: Get the Values from UI u.user_id = int.Parse(txtUserID.Text); u.full_name = txtFullName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.added_date = DateTime.Now; u.image_name = imageName; //Step 2: Create a Boolean variable to check whether the data is updated successfully or not bool success = dal.Update(u); //Let's check whether the data is updated or not if (success == true) { //Data Udated Successfully MessageBox.Show("User Updated Successfully."); //Refresh DAta Grid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; //Clear the TextBoxes Clear(); } }
private void btnUpdate_Click(object sender, EventArgs e) { u.Id = Convert.ToInt32(txtUSERID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUserName.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = comboGender.Text; u.user_type = comboUserType.Text; u.added_date = DateTime.Now; u.added_by = 1; bool success = dal.Update(u); if (success == true) { MassageBox mb = new MassageBox("Updated", MsgType.update); mb.Show(); //MessageBox.Show("User Details Updated Successfully!!!"); clear(); } else { MassageBox mb = new MassageBox("Update Failed", MsgType.retry); mb.Show(); //MessageBox.Show("Fail to Updated!!!"); } DataTable dt = dal.Select(); dgvUser.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUserName.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; u.added_by = 1; bool success = dal.Update(u); if (success) { clearFields(); } MessageBox.Show(success ? "User-i eshte bere Update me sukses" : "Update i User-it Deshtoi"); refreshDataGridView(); }
private void UpdateBtn_Click(object sender, EventArgs e) { //Step 1 get the values from UI u.user_id = int.Parse(txtboxUserID.Text); u.full_name = txtBoxFullName.Text; u.email = txtBoxEmail.Text; u.username = txtBoxUserName.Text; u.password = txtBoxPwd.Text; u.contact = txtBoxContact.Text; u.address = txtBoxAddress.Text; u.address = txtBoxAddress.Text; u.added_date = DateTime.Now; u.image_name = imageName; //Step 2 Adding into DB //Create a bool var to check success bool success = dal.Update(u); //step 3 Check if it was inserted successfully or not if (success == true) { //Data or user added Successfully MessageBox.Show("New user has been update"); } else { MessageBox.Show("Failed to add"); } //Clear the user tabs after its been updated Clear(); }
private void btnUpdate_Click(object sender, EventArgs e) { u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; u.added_by = 1; bool success = dal.Update(u); if (success == true) { MessageBox.Show("ทำการเปลี่ยนแปลงข้อมูลผู้ใช้งานเรียบร้อยแล้ว"); clear(); } else { MessageBox.Show("ไมสามารถทำการเปลี่ยนแปลงข้อมูลผู้ใช้งานได้! กรุณาลองใหม่อีกครั้ง"); } DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btn_update_Click(object sender, EventArgs e) { u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUserName.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; u.added_by = 1; bool success = dal.Update(u); if (success) { MessageBox.Show("User successfully updated."); Clear(); DataTable dt = dal.Select(); dgvUsers.DataSource = dt; } else { MessageBox.Show("User failed to update."); } }
private void btnUpdate_Click(object sender, EventArgs e) { // Get the Values From User UI userBl.id = Convert.ToInt32(txtUserID.Text); userBl.firstName = txtFirstName.Text; userBl.lastName = txtLastName.Text; userBl.email = txtEmail.Text; userBl.userName = txtUserName.Text; userBl.passWord = txtpassword.Text; userBl.Contact = txtContact.Text; userBl.address = txtAdress.Text; userBl.gender = cmbGender.Text; userBl.user_type = cmbUserType.Text; userBl.addedDate = DateTime.Now; userBl.addedBy = 1; //Updating data in database bool success = userDl.Update(userBl); if (success == true) { MessageBox.Show("Successfuly Updating Data "); } else { MessageBox.Show("Failled!!!! TO Update Data"); } //Refressing DataGGRid View DataTable DT = userDl.Select(); dgvUsers.DataSource = DT; }
private void buttonAtualizar_Click(object sender, EventArgs e) { u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUserName.Text; u.password = txtPassword.Text; u.contact = txtContato.Text; u.address = txtAddress.Text; u.genero = cmbGenero.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; u.added_by = 1; bool success = dal.Update(u); if (success == true) { MessageBox.Show("USUÁRIO ATUALIZADO COM SUCESSO!"); Limpar(); } else { MessageBox.Show("NÃO FOI POSSÍVEL ATUALIZAR USUÁRIO!"); } DataTable dt = dal.Select(); dgvUser.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { //Step1: Get the Values from UI u.user_id = int.Parse(txtUserID.Text); u.full_name = txtFullName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.added_date = DateTime.Now; u.image_name = imageName; //Upload New Image //check whether the user has selected the image or not if (imageName != "no-image.jpg") { //User has selected the image File.Copy(sourcePath, destinationPath); } //Step 2: Create a Boolean variable to check whether the data is updated successfully or not bool success = dal.Update(u); //Remove the previous Image if (rowHeaderImage != "no-image.jpg") { //Path of the Project Folder string paths = Application.StartupPath.Substring(0, (Application.StartupPath.Length - 10)); //Give the Path to the Image Folder string imagePath = paths + "\\images\\" + rowHeaderImage; //Call Clear Function to clear all the textboxes and Picturebox Clear(); //Call Garbage Collection Function GC.Collect(); GC.WaitForPendingFinalizers(); //Delete hte Physical File of the User Profile File.Delete(imagePath); } //Let's check whether the data is updated or not if (success == true) { //Data Udated Successfully MessageBox.Show("User Updated Successfully."); //Refresh DAta Grid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; //Clear the TextBoxes Clear(); } }
private void btnUpdate_Click(object sender, EventArgs e) { #region Throw Exception if (txtUserID.Text == "" && txtFirstName.Text == "" && txtLastName.Text == "" && txtEmail.Text == "" && txtUsername.Text == "" && txtPassword.Text == "" && txtContact.Text == "" && txtAddress.Text == "" && cmbGender.Text == "" && cmbUserType.Text == "") { MessageBox.Show(" Please Select First Into The DataGrid View Then Update Data.... !! "); } #endregion else { //Get the values from user UI u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; u.added_by = 1; //Updating Data into DataBase bool success = dal.Update(u); //If data is updated successfully the value of success will be true else it will be false if (success == true) { MessageBox.Show("User Successfully Updated"); clear(); } else { MessageBox.Show("Failed to Update User"); } //Refresh the Data Grid View DataTable dt = dal.select(); dgvUsers.DataSource = dt; error(); } }
private void buttonUpdate_Click(object sender, EventArgs e) { u.user_id = int.Parse(textBoxUserID.Text); u.username = textBoxUsername.Text; u.first_name = textBoxFirstName.Text; u.last_name = textBoxLastName.Text; u.email = textBoxMobile.Text; u.address = textBoxAddress.Text; u.mobile = textBoxMobile.Text; switch (comboBoxGender.SelectedIndex) { case 0: u.gender = "Male"; break; case 1: u.gender = "Female"; break; case 2: u.gender = "Other"; break; } u.enrolled_date = dateTimePickerEnrolledDate.Value; u.membership_expiry_date = dateTimePickerExpiryDate.Value; u.num_books_borrowed = int.Parse(textBoxBooksBorrowed.Text); bool successUpdated = dal.Update(u); if (successUpdated) { MessageBox.Show($"User {u.username} Updated Successfully"); //display the user in DataGrid view DataTable dt = dal.Select(); dataGridViewUsers.DataSource = dt; //clear the text inputs Clear(); } else { MessageBox.Show($"Failed to Update User {u.username}"); } }
private void BtnUpdate_Click(object sender, EventArgs e) { //Get the values from User UI u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.username = txtUsername.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; //Getting Username of the logged in user string loggedUser = frmLogin.loggedIn; userBLL usr = dal.GetIDFromUsername(loggedUser); u.added_by = usr.id; //Updatinf Data in Database bool success = dal.Update(u); //if data is update successfully the value of success will be true else it will be false if (success == true) { //Data Update Successfully MessageBox.Show("User success updated"); Clear(); } else { //Failed to Update user MessageBox.Show("Failed to Update User"); } //Refreshing Data Grid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { // Get the Values from User UI u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUserName.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbBoxGender.Text; u.user_type = cmbBoxUserType.Text; u.added_date = DateTime.Now; // Get name of logged in user first string loggedUser = frmLogin.loggedIn; // we need to get id of user. we will create another Method in UserDAL. userBLL usr = dal.GetIDFromUsername(loggedUser); u.added_by = usr.id; // updating Data into Database bool success = dal.Update(u); // If data is successfully added, then success message will come if (success == true) { MessageBox.Show("Data Updated Successfully"); clear(); } else { MessageBox.Show("Not Updated "); } //Refresh Data Grid // Refreshing Data Grid View.we will create a temporary storage data table to store data. DataTable dt = dal.Select(); // this will refer the data grid view dgvUsers.DataSource = dt; }
private void BtnUpdate_Click(object sender, EventArgs e) { //Get the Values From User Interface u.id = Convert.ToInt32(tbaddUserId.Text); u.firstName = tbFirstName.Text; u.lastName = tbLastName.Text; u.emailAddress = tbEmail.Text; u.gender = cbGender.Text; u.address = tbAddress.Text; u.phoneNumber = tbTelephone.Text; u.activity = cbActivity.Text; u.username = tbUsername.Text; u.password = tbPassword.Text; u.userType = cbUserType.Text; u.dateCreated = DateTime.Now; u.dateOfBirth = dpDOB.Value; //Get the username of the logged in User for adding to the added by field of the database string logggedUser = Login.loggedIn; userBLL usr = d.GetIDFromUsername(logggedUser); u.addedBy = usr.id; u.subscription = cbSubscription.Text; u.status = cbSubscriptionStatus.Text; //Update data in database bool success = d.Update(u); //if data is not updated successfully change value to true else false if (success == true) { MessageBox.Show("User Successfully updated"); Clear(); } else { MessageBox.Show("Failed to update User"); } //Referesh DataGrid View DataTable dt = d.SelectM(); dgvAdduser.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { //Get the values from UI u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; ///getting username of logged in user string loggedUser = frmLogin.loggedIn; userBLL usr = dal.GetIDFromUsername(loggedUser); u.added_by = usr.id; //Updating data to database bool success = dal.Update(u); //If data updated successfully the value of success is true r else it will be false if (success == true) { //data successfully updated MessageBox.Show("Use successfully Updated!"); Clear(); } else { //failed to update user MessageBox.Show("Failed to update user!"); } //refresh the datagrid view DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { if (txtUserID.Text == "") { MessageBox.Show("Please select a record"); } else { //Get the values from User UI u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; u.added_by = 1; //Updating Data into database bool success = dal.Update(u); //if data is updated successfully then the value of success will be true else it will be false if (success == true) { //Data Updated Successfully MessageBox.Show("User successfully updated"); clear(); } else { //failed to update user MessageBox.Show("Failed to update user"); } //Refreshing Data Grid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; } }
private void btnUpdate_Click(object sender, EventArgs e) { //Get the values from the UI userBLL.id = Convert.ToInt32(txtBoxUserID.Text); userBLL.first_name = txtBoxFirstName.Text; userBLL.last_name = txtBoxLastName.Text; userBLL.email = txtBoxEmail.Text; userBLL.username = txtBoxUsername.Text; userBLL.password = txtBoxPassword.Text; userBLL.contact = txtBoxContact.Text; userBLL.address = txtBoxAddress.Text; userBLL.gender = cmbGender.Text; userBLL.user_type = cmbUserType.Text; userBLL.added_date = DateTime.Now; String logged_in_user = fLogin.logged_in; userBLL user = userDAL.GetIDFromUsername(logged_in_user); userBLL.added_by = user.username; //Updating data into database bool success = userDAL.Update(userBLL); if (success == true) { MessageBox.Show("User " + txtBoxFirstName.Text + " is updated successfully"); clear(); } else { MessageBox.Show("Can not update user " + txtBoxFirstName.Text); } //refreshing data grid view DataTable dataTable = userDAL.Select(); dgvUser.DataSource = dataTable; }
private void BtnUpdate_Click(object sender, EventArgs e) { //getting data from UI u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; // change 1. when login form is done u.added_by = 1; // updating data in to database bool success = dal.Update(u); // if data is updated successfully then success will be true,false otherwise if (success == true) { //data updated sucessfully MessageBox.Show("User updated successfully"); clear(); } else { // failed to update DB MessageBox.Show("Failed to updtae User"); } //refreshing data grid view DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnUpdate_Click(object sender, EventArgs e) { u.korisnik_id = int.Parse(txtUserID.Text); u.ime_i_prezime = txtFullName.Text; u.email = txtEmail.Text; u.korisnicko_ime = txtUsername.Text; u.lozinka = txtPassword.Text; u.kontakt = txtContact.Text; u.adresa = txtAddress.Text; u.datum_dodavanja = DateTime.Now; u.slika_korisnika = slikaKorisnika; bool success = dal.Update(u); if (success == true) { MessageBox.Show("Korisnik je uspješno ažuriran."); DataTable dt = dal.Select(); dgvUsers.DataSource = dt; Clear(); } }
private void btnUpdate_Click(object sender, EventArgs e) { //Get values from user UI u.id = Convert.ToInt32(txtUserID.Text); u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUsertype.Text; u.added_date = DateTime.Now; u.added_by = 1; //Updating Data into Database bool success = dal.Update(u); //If data is successfully updated the values is true else it will be false if (success == true) { //Data update successfull MessageBox.Show("User Data update Successfully."); clear(); } else { //Data update failed MessageBox.Show("Fail to update user Data."); } //Refreshing data grid view DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }