Пример #1
0
        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;
        }
Пример #2
0
        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;
        }
Пример #3
0
        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..");
            }
        }
Пример #5
0
        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;
        }
Пример #6
0
        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();
            }
        }
Пример #8
0
        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;
        }
Пример #9
0
        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();
        }
Пример #10
0
        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();
        }
Пример #11
0
        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;
        }
Пример #12
0
        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.");
            }
        }
Пример #13
0
        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;
        }
Пример #14
0
        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;
        }
Пример #15
0
        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();
            }
        }
Пример #17
0
        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}");
            }
        }
Пример #18
0
        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;
        }
Пример #19
0
        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;
        }
Пример #20
0
        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;
        }
Пример #22
0
        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;
            }
        }
Пример #23
0
        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;
        }
Пример #24
0
        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;
        }
Пример #25
0
        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();
            }
        }
Пример #26
0
        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;
        }