protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack && !IsCallback) { UserGridView.DataBind(); } }
protected void UserGridViewBind() { try { using (Storage db = new Storage()) { var users = db.Users.Select(u => new { Login = u.Login, Name = u.Name, Surname = u.Surname, Password = u.Password, Role = u.UserRole.Name, Status = u.Status }).ToList(); UserGridView.DataSource = users; UserGridView.DataBind(); } } catch (Exception ex) { Loger.Log(Response, ex); } }
protected void UserGridView_SelectedIndexChanged(object sender, GridViewCommandEventArgs e) { try { int rowIndex = Convert.ToInt32(e.CommandArgument); string Login = UserGridView.Rows[rowIndex].Cells[0].Text; using (Storage db = new Storage()) { DAL.User cu = db.Users.Include("UserRole").Where(u => u.Login == Login).FirstOrDefault(); if (cu != null) { cu.Status = (cu.Status) ? false : true; db.SaveChanges(); } UserGridView.DataBind(); } } catch (Exception ex) { Loger.Log(Response, ex); } }
void deleteUser() { if (checkUserExist()) { try { SqlConnection conn = new SqlConnection(strConn); if (conn.State == ConnectionState.Closed) { conn.Open(); } //DELETE 語法 SqlCommand sqlCmd = new SqlCommand("DELETE FROM user_master_table WHERE user_id = @user_id", conn); //接收TextBox值寫入@user_id參數 sqlCmd.Parameters.AddWithValue("@user_id", UserIDTextBox.Text.Trim()); //Trim 移除前後空白 sqlCmd.ExecuteNonQuery(); conn.Close(); Response.Write("<script>alert('User delete successful!');</script>"); clearForm(); UserGridView.DataBind(); } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } } else { Response.Write("<script>alert('Invalid User ID');</script>"); } }
public void LoadBranchList() { if (UserGridView.RowCount == 0) { return; } var selected = UserGridView.GetFocusedRowCellValue(colusername); UserModel user = user_coll.FirstOrDefault(u => u.username == selected.ToString()); var UserBranches = user.UserHasBranches.Select(ub => ub.branch_name); var Branches = branch_coll.Where(b => UserBranches.Contains(b)); var NotBranches = branch_coll.Where(b => !UserBranches.Contains(b)); BranchGridControl.DataSource = Branches; BranchComboBoxEdit.Properties.Items.Clear(); foreach (BranchModel branch in NotBranches) { BranchComboBoxEdit.Properties.Items.Add(branch.branch_name); } BranchGridControl.DataSource = Branches; }
private void RemoveUser_Click(object sender, EventArgs e) { if (!validator.Validate()) { return; } DialogResult dialog = MessageBox.Show("Yakin ?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialog != DialogResult.Yes) { return; } try { var selected = UserGridView.GetFocusedRowCellValue(colusername); UserModel userModel = user_coll.FirstOrDefault(u => u.username == selected.ToString()); RolesModel roles = roles_coll.FirstOrDefault(r => r.rolename == RolesComboBoxEdit.Text); userAkses.RevokeRoleFromUser(userModel, roles); var users = user_has_roles_coll.Where(uhr => uhr.rolename.rolename == RolesComboBoxEdit.Text).Select(uhr => uhr.username.username); UserGridControl.DataSource = user_coll.Where(u => users.Contains(u.username)); } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnDeleteUserRepo_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { try { if (!User.UserInAction("can delete")) { return; } var res = UserGridView.GetFocusedRow(); if (UserGridView.GetFocusedRow() is Users item) { if (MessageBox.Show("Do you want to delete this?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } UnitOfWork unitOfWork = new UnitOfWork(); unitOfWork.UsersRepo.Delete(m => m.Id == item.Id); unitOfWork.Save(); Init(); } } catch (Exception exception) { MessageBox.Show(exception.Message, exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadData() { RegisterAppLayer ObjAppLayer = new RegisterAppLayer(); List <RegDetails> listUser = ObjAppLayer.GetPersonDetails(); if (listUser.Count > 0) { UserGridView.Rows.Clear(); DataGridViewRow row; int i = 0; foreach (var RegDetails in listUser) { row = new DataGridViewRow(); UserGridView.Rows.Add(); row = UserGridView.Rows[i]; row.Cells["ColFirstName"].Value = RegDetails.FirstName; row.Cells["ColLastName"].Value = RegDetails.LastName; row.Cells["ColEmail"].Value = RegDetails.Email; row.Cells["ColMobile"].Value = RegDetails.Mobile; row.Cells["ColUserName"].Value = RegDetails.UserName; i++; } UserGridView.ClearSelection(); } }
protected void loadUser() { var conn = new MySqlConnection(strcon); conn.Open(); string getdata = "SELECT * FROM Users WHERE UserId = '" + UserIdHF.Value + "'"; var cmd = new MySqlCommand(getdata, conn); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); int count = ds.Tables[0].Rows.Count; if (ds.Tables[0].Rows.Count > 0) { UserGridView.DataSource = ds; UserGridView.DataBind(); } else { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); UserGridView.DataSource = ds; UserGridView.DataBind(); int columncount = UserGridView.Rows[0].Cells.Count; lblmsg.Text = " No data found !!!"; } conn.Close(); }
public void loadGrid() { string UserQuery = @"SELECT [Patient_ID],[Patient_Name],[Patient_Mobile],[Patient_Address] FROM [dbo].[Patient]"; UserGridView.DataSource = db.getData(UserQuery); UserGridView.DataBind(); }
public void PopulateGridview() { DataTable dtbl = new DataTable(); using (SqlConnection sqlCon = new SqlConnection(connectionString)) { string UserQuery = @"SELECT [Patient_ID],[Patient_Name],[Patient_Mobile],[Patient_Address] FROM [dbo].[Patient]"; sqlCon.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter(UserQuery, sqlCon); sqlDa.Fill(dtbl); } if (dtbl.Rows.Count > 0) { UserGridView.DataSource = dtbl; UserGridView.DataBind(); } else { dtbl.Rows.Add(dtbl.NewRow()); UserGridView.DataSource = dtbl; UserGridView.DataBind(); UserGridView.Rows[0].Cells.Clear(); UserGridView.Rows[0].Cells.Add(new TableCell()); UserGridView.Rows[0].Cells[0].ColumnSpan = dtbl.Columns.Count; UserGridView.Rows[0].Cells[0].Text = "No Data Found ..!"; UserGridView.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; } }
protected void Button1_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); foreach (GridViewRow row in UserGridView.Rows) { if (row.RowType == DataControlRowType.DataRow) { var chkBox = row.Cells[0].FindControl("ChkUser") as CheckBox; if (chkBox.Checked) { string ID = UserGridView.DataKeys[row.RowIndex].Value + ""; var ddl = row.Cells[row.Cells.Count - 1].FindControl("ddlRole") as DropDownList; var val = ddl.SelectedValue; sb.AppendLine(string.Format("update XK_User set RoleID=" + val + " where ID=" + ID)); } } } if (sb.Length > 0) { var userBLL = new UserBLL(); var result = userBLL.UpdateByCommandString(sb.ToString(), ""); if (result > 0) { lbTip.Text = "修改成功!!!"; var userList = userBLL.GetAll(new User(), ""); UserGridView.DataSource = userList; UserGridView.DataBind(); } } }
protected void Button2_Click(object sender, EventArgs e) { string whereString = ""; foreach (GridViewRow row in UserGridView.Rows) { if (row.RowType == DataControlRowType.DataRow) { var chkBox = row.Cells[0].FindControl("ChkUser") as CheckBox; if (chkBox.Checked) { string ID = UserGridView.DataKeys[row.RowIndex].Value + ""; whereString += ID + ","; } } } if (whereString.Length > 0) { whereString = " where ID in(" + whereString.TrimEnd(',') + ")"; var userBLL = new UserBLL(); var result = userBLL.UpdateByCommandString("delete from XK_User " + whereString, ""); if (result > 0) { lbTip.Text = "删除成功!!!"; var userList = userBLL.GetAll(new User(), ""); UserGridView.DataSource = userList; UserGridView.DataBind(); } } }
private void UserGridView_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { BeginInvoke(new MethodInvoker(delegate { UserGridView.PostEditor(); UserGridView.UpdateCurrentRow(); })); }
private void btnEditUserRepo_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { if (UserGridView.GetFocusedRow() is Users item) { frmAddEditUser frm = new frmAddEditUser(MethodType.Edit, item); frm.ShowDialog(); Init(); } }
private void BindUserGrid() { DataTable dt = GetUserRecords(); if (dt.Rows.Count > 0) { UserGridView.DataSource = dt; UserGridView.DataBind(); } }
public void BindData() { string where = GetWhere(); DataTable dt = userManager.GetAllUserMessage(where); UserGridView.DataSource = dt; UserGridView.AutoResizeColumns( DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader); this.UserGridView.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill; }
protected void Page_Load(object sender, EventArgs e) { ViewState["RoleList"] = BindRole(); if (!IsPostBack) { var userBLL = new UserBLL(); var userList = userBLL.GetAll(new User(), ""); UserGridView.DataSource = userList; UserGridView.DataBind(); } }
void BindData() { string sql = "SELECT * FROM tbl_emp_user JOIN tbl_privilege ON emp_user_privilege=privilege_id"; MySqlDataAdapter da = dBScript.getDataSelect(sql); DataSet ds = new DataSet(); da.Fill(ds); UserGridView.DataSource = ds.Tables[0]; UserGridView.DataBind(); lbUserNull.Text = "พบข้อมูลจำนวน " + ds.Tables[0].Rows.Count + " แถว"; }
public void PopulateUserDetails() { con.Open(); cmd = new SqlCommand("select username,Roles.role from users join roles on users.role=roles.roleid where roles.roleid <> 0", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); UserGridView.DataSource = ds; UserGridView.DataBind(); }
// Populate the page with entity data private void PopulatePage() { List <UserDto> users = UserService.GetUsers(); if (users.Count > 0) { UserGridView.DataSource = UserService.GetUsers(); UserGridView.DataBind(); } else { hiddenDiv.Visible = true; } }
protected void UserGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamLoginID", e.Keys[0]); DBAgent.AddParameter("@ParamUpdatedBy", Session["LoginID"]); DBAgent.ExecuteNonQuery("dbo.spDeleteUser"); e.Cancel = true; UserGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("UserGridView_RowDeleting: UserManagement.aspx", ex.Message); } }
private void UserGridView_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e) { try { UserGridView.GetDataRow(UserGridView.FocusedRowHandle); if (UserGridView.FocusedColumn.FieldName == "MASTER") { if (Convert.ToBoolean(e.Value) == true) { UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["ADMIN"], false); UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["REPORT"], false); UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["TRANSACTION"], false); } } if (UserGridView.FocusedColumn.FieldName == "TRANSACTION") { if (Convert.ToBoolean(e.Value) == true) { UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["ADMIN"], false); UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["REPORT"], false); UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["MASTER"], false); } } if (UserGridView.FocusedColumn.FieldName == "ADMIN") { if (Convert.ToBoolean(e.Value) == true) { UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["MASTER"], false); UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["REPORT"], false); UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["TRANSACTION"], false); } } if (UserGridView.FocusedColumn.FieldName == "REPORT") { if (Convert.ToBoolean(e.Value) == true) { UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["MASTER"], false); UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["ADMIN"], false); UserGridView.SetRowCellValue(UserGridView.FocusedRowHandle, UserGridView.Columns["TRANSACTION"], false); } } } catch (Exception ex) { ProjectFunctions.SpeakError(ex.Message); } }
private void btnImpersonateRepo_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { if (UserGridView.GetFocusedRow() is Users item) { var th = new Thread(() => { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); BonusSkins.Register(); Application.Run(new Main(new string[] { item.Id })); }); th.ApartmentState = ApartmentState.STA; th.Start(); } }
// // Remove User Button // private void btnRemoveUser_Click(object sender, EventArgs e) { string name = UserGridView.CurrentRow.Cells["username"].FormattedValue.ToString(); if (!name.Equals("admin")) { commandRows.Add("/user/remove"); commandRows.Add("=numbers=" + name); ExecuteParameterCommand(commandRows); } else { MessageBox.Show("Couldn't change User <admin>"); } UserGridView.Refresh(); UserGridView.Rows.Clear(); commandRows.Add("/user/print"); displayUsers(getUsers(commandRows)); }
private void TambahBranch_Click(object sender, EventArgs e) { if (!AssignBranchValidationProvider.Validate()) { return; } if (UserGridView.RowCount == 0) { return; } var selected = UserGridView.GetFocusedRowCellValue(colusername); UserModel user = user_coll.FirstOrDefault(u => u.username == selected.ToString()); BranchModel branch = branch_coll.FirstOrDefault(b => b.branch_name == BranchComboBoxEdit.Text); userAkses.AddBranchForUser(user, branch); LoadBranchList(); }
protected void UserGridView_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridViewCustomButtonCallbackEventArgs e) { try { securityAgent = new CryptoProvider(); DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamLoginID", UserGridView.GetRowValues(e.VisibleIndex, "LoginID")); DBAgent.AddParameter("@ParamNewPassword", securityAgent.GetTemporaryPassword()); DBAgent.AddParameter("@ParamIsTempPassword", 1); DBAgent.AddParameter("@ParamComment", "Password reset by Admin"); DBAgent.ExecuteNonQuery("dbo.spUpdatePassword"); UserGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("UserGridView_CustomButtonCallback: UserManagement.aspx", ex.Message); } }
private void HapusBranch_Click(object sender, EventArgs e) { if (!AssignBranchValidationProvider.Validate()) { return; } if (UserGridView.RowCount == 0) { return; } var selected = UserGridView.GetFocusedRowCellValue(colusername); UserModel user = user_coll.FirstOrDefault(u => u.username == selected.ToString()); var selectedBranch = BranchGridView.GetFocusedRowCellValue(colbranchname); BranchModel branch = branch_coll.FirstOrDefault(b => b.branch_name == selectedBranch.ToString()); userAkses.RemoveBranchFromUser(user, branch); LoadBranchList(); }
protected void UserGridView_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { securityAgent = new CryptoProvider(); DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamUserName", e.NewValues["UserName"]); DBAgent.AddParameter("@ParamFirstName", e.NewValues["FirstName"]); DBAgent.AddParameter("@ParamLastName", e.NewValues["LastName"]); DBAgent.AddParameter("@ParamPassword", securityAgent.GetTemporaryPassword()); DBAgent.AddParameter("@ParamModifiedBy", Session["LoginID"]); DBAgent.ExecuteNonQuery("dbo.spAddUser"); e.Cancel = true; UserGridView.CancelEdit(); UserGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("UserGridView_RowInserting: UserManagement.aspx", ex.Message); } }
protected void editUserButton_Click(object sender, EventArgs e) { string edit = "Update [dbo].[User] set FirstName = @FirstName, LastName = @LastName, PersonEmail = @Email, PersonPhone=@Phone, JobLevel = @JobLevel, Permission = @Permission, LastUpdatedBy = @LastUpdatedBy, LastUpdated = @LastUpdated where UserID = @user"; sc.Open(); SqlCommand edituser = new SqlCommand(edit, sc); edituser.Parameters.AddWithValue("@FirstName", HttpUtility.HtmlEncode(txtFirstName.Text)); edituser.Parameters.AddWithValue("@LastName", HttpUtility.HtmlEncode(txtLastName.Text)); edituser.Parameters.AddWithValue("@Email", HttpUtility.HtmlEncode(txtEmail.Text)); edituser.Parameters.AddWithValue("@Phone", HttpUtility.HtmlEncode(txtPhone.Text)); edituser.Parameters.AddWithValue("@JobLevel", txtJobLevel.SelectedItem.Text); edituser.Parameters.AddWithValue("@Permission", txtPermission.SelectedItem.Text); edituser.Parameters.AddWithValue("@LastUpdatedBy", Session["User"]); edituser.Parameters.AddWithValue("@LastUpdated", DateTime.Now); edituser.Parameters.AddWithValue("@user", UserGridView.SelectedRow.Cells[8].Text); edituser.ExecuteNonQuery(); UserGridView.DataBind(); sc.Close(); }