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