Ejemplo n.º 1
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            if (Utility.Utility.IsStringNullorEmpty(etUserName.Text)) 
                MessageBox.Show(this, "Please fill username", "Caution", MessageBoxButtons.OK);
            else if (Utility.Utility.IsStringNullorEmpty(etPassword.Text))
                MessageBox.Show(this, "Please fill password", "Caution", MessageBoxButtons.OK);
            else {
                SqlUserRepository sqlUser = new SqlUserRepository();
                SqlParameter []sqlparam = SqlUtility.SetSqlParameter(new string[]{"UserName", "Password"}, new object[]{etUserName.Text, Utility.Utility.MD5(etPassword.Text)});
                
                sqlUser.ValidateLogin(sqlparam);
                sqlparam = null;
                sqlUser = null;

                if (!Constant.VisitaJayaPerkasaApplication.anyConnection) {
                    MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else if (UserProfile.user == null)
                {
                    MessageBox.Show(this, "Please correct username and password", "Caution", MessageBoxButtons.OK);
                }
                else
                {
                    VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.loginForm.Hide();
                    etPassword.Text = "";
                    new MainForm().Show();
                }
              
            }
        }
Ejemplo n.º 2
0
        public void LoadDataInBackground()
        {
            sqlUserRepository = new SqlUserRepository();
            Users = null;

                string searchValue = radTextBoxElementSearchWord.Text;
                string searchKey = radComboBoxElement.Text;

                Users = sqlUserRepository.GetUsers();

                if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                    MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                else if (Users != null)
                {
                    if (!string.IsNullOrEmpty(searchValue) && !string.IsNullOrEmpty(searchKey))
                    {
                        switch (searchKey)
                        {
                            case "First Name":
                                ShowUser = Users.Where(c => c.FirstName.Contains(searchValue)).ToList<User>();
                                break;
                            case "Last Name":
                                ShowUser = Users.Where(c => c.LastName.Contains(searchValue)).ToList<User>();
                                break;
                        }

                    }
                    else
                        ShowUser = Users;
                }
                else
                    ShowUser = null;

                if (ShowUser != null)
                {
                    totalPage = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(ShowUser.Count() / Convert.ToDecimal(pageSize))));
                    currentPage = 1;
                }
                else
                    totalPage = 0;
        }
Ejemplo n.º 3
0
        private void radButtonElementRemove_Click(object sender, EventArgs e)
        {
            if (UserGridView.SelectedRows.Count == 1)
            {
                sqlUserRepository = new SqlUserRepository();
                DialogResult dResult = MessageBox.Show(this, "Are you sure want delete this data ? ", "Confirmation", MessageBoxButtons.YesNo);
                if (dResult == DialogResult.Yes)
                {
                    GridViewRowInfo gridInfo = UserGridView.SelectedRows.First();
                    string id = gridInfo.Cells[0].Value.ToString();

                    SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(new string[] { "person_id" }, new object[] { id });

                    if (sqlUserRepository.DeleteUser(sqlParam))
                    {
                        MessageBox.Show("Data Deleted !");
                        LoadData();
                    }
                    else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                        MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    else
                        MessageBox.Show("Cannot Delete Data !");

                    sqlParam = null;
                }
            }
        }
Ejemplo n.º 4
0
        private void radButtonElement1_Click(object sender, EventArgs e)
        {
            if (etUserName.Text.Trim().Length == 0)
                MessageBox.Show(this, "Please fill username", "Information");
            else if (etPassword.Text.Trim().Length == 0)
                MessageBox.Show(this, "Please fill password", "Information");
            else if (cboUserRole.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText))
                MessageBox.Show(this, "Please select user role", "Information");
            else if (!Regex.Match(etEmail.Text.Trim(), @"^(([\w-]+\.)+[\w-]+|([a-zA-Z]{1}|[\w-]{2,}))@"
                + @"((([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\."
                + @"([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])){1}|"
                + @"([a-zA-Z]+[\w-]+\.)+[a-zA-Z]{2,4})$").Success)
            {
                MessageBox.Show(this, "invalid email", "Information");
            }
            else {
                sqlUserRepository = new SqlUserRepository();
                //Check username has already exists?
                SqlParameter[] param = SqlUtility.SetSqlParameter(new string[]{"username"}, new object[]{etUserName.Text.Trim()});
                

                if (wantToCreateUser)
                {
                    User user = new User();
                    user.Address = etAddress.Text.Trim();
                    user.DateOfBirth = DOB.Value;
                    user.Deleted = 0;
                    user.email = etEmail.Text.Trim();
                    user.FirstName = etFirstName.Text.Trim();
                    user.LastName = etLastName.Text.Trim();
                    user.MaritalStatus = (cbMarital.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText)) ? null : cbMarital.Text;
                    user.MobilePhoneNumber = etMobilePhone.Text.Trim();
                    user.Password = Utility.Utility.MD5(etPassword.Text);
                    user.PasswordHint = etPasswordHint.Text;
                    user.PersonID = Guid.NewGuid();
                    user.UserName = etUserName.Text.Trim();

                    user.RoleObj = new Role();
                    user.RoleObj.ID = Utility.Utility.ConvertToUUID(cboUserRole.SelectedValue.ToString());

                    if (sqlUserRepository.CheckUserName(param, Guid.Empty, true))
                    {
                        DialogResult dResult = MessageBox.Show(this, "Username has already deleted. Do you want to activate ?", "Confirmation", MessageBoxButtons.YesNo);
                        if (dResult == DialogResult.Yes)
                        {
                            SqlParameter[] parameters = SqlUtility.SetSqlParameter(new string[] { "person_id", "username", "password", "password_hint", "email", "first_name", "last_name", "address", "date_of_birth", "marital_status", "gender", "mobile_phone_number", "deleted", "user_role_id", "user_id", "role_id", "deleted" }
                            , new object[] { user.PersonID, user.UserName, user.Password, user.PasswordHint, user.email, user.FirstName, user.LastName, user.Address, user.DateOfBirth, user.MaritalStatus, user.Gender, user.MobilePhoneNumber, user.Deleted, Guid.NewGuid(), user.PersonID, user.RoleObj.ID, user.Deleted });

                            if (sqlUserRepository.ActivateUser(parameters))
                            {
                                MessageBox.Show(this, "Success Activate User", "Information");
                                radButtonElement2.PerformClick();
                            }
                            else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                            {
                                MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            }
                            else
                                MessageBox.Show(this, "Cannot Activate User", "Information");
                            
                            parameters = null;
                        }
                        return;
                    }
                    else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                    {
                        MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }
                    else if (sqlUserRepository.CheckUserName(param, Guid.Empty))
                    {
                        MessageBox.Show(this, "Username has already exists", "Information");
                        return;
                    }
                    else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                    {
                        MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }

                    //Create user 
                    SqlParameter []sqlParam = SqlUtility.SetSqlParameter(new string[] { "person_id", "username", "password", "password_hint", "email", "first_name", "last_name", "address", "date_of_birth", "marital_status", "gender", "mobile_phone_number", "deleted", "user_role_id", "user_id", "role_id", "deleted" }
                        , new object[] { user.PersonID, user.UserName, user.Password, user.PasswordHint, user.email, user.FirstName, user.LastName, user.Address, user.DateOfBirth, user.MaritalStatus, user.Gender, user.MobilePhoneNumber, user.Deleted, Guid.NewGuid(), user.PersonID, user.RoleObj.ID, user.Deleted });

                    if (sqlUserRepository.CreateUser(sqlParam))
                    {
                        MessageBox.Show(this, "Success create user", "Information");
                        radButtonElement2.PerformClick();
                    }
                    else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                        MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    else {
                        MessageBox.Show(this, "Cannot Create User", "Information");
                    }
                }
                else{ 
                    User user = new User();
                    user.Address = etAddress.Text.Trim();
                    user.DateOfBirth = DOB.Value;
                    user.Deleted = 0;
                    user.email = etEmail.Text.Trim();
                    user.FirstName = etFirstName.Text.Trim();
                    user.LastName = etLastName.Text.Trim();
                    user.MaritalStatus = (cbMarital.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText)) ? null : cbMarital.Text;
                    user.MobilePhoneNumber = etMobilePhone.Text.Trim();
                    user.Password = Utility.Utility.MD5(etPassword.Text);
                    user.PasswordHint = etPasswordHint.Text;
                    user.PersonID = this.user.PersonID;
                    user.UserName = etUserName.Text.Trim();

                    user.RoleObj = new Role();
                    user.RoleObj.ID = Utility.Utility.ConvertToUUID(cboUserRole.SelectedValue.ToString());
                    
                    
                    if (sqlUserRepository.CheckUserName(param, user.PersonID))
                    {
                        MessageBox.Show(this, "Username has already exist. if it has already deleted. you must activate it with create new data", "Information");
                        return;
                    }
                    else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                    {
                        MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }

                    SqlParameter []sqlParam = SqlUtility.SetSqlParameter(new string[] { "person_id", "username", "password", "password_hint", "email", "first_name", "last_name", "address", "date_of_birth", "marital_status", "gender", "mobile_phone_number", "deleted", "user_id", "role_id", "deleted" }
                        , new object[] { user.PersonID, user.UserName, user.Password, user.PasswordHint, user.email, user.FirstName, user.LastName, user.Address, user.DateOfBirth, user.MaritalStatus, user.Gender, user.MobilePhoneNumber, user.Deleted,  user.PersonID, user.RoleObj.ID, user.Deleted });

                    if (sqlUserRepository.EditUser(sqlParam))
                    {
                        MessageBox.Show(this, "Success edit user", "Information");
                        radButtonElement2.PerformClick();
                    }
                    else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                        MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    else {
                        MessageBox.Show(this, "Cannot edit User", "Information");
                    }
                }
            }
        }