private void DeleteBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = "delete from tbl_User2 " + " where userid = '" + UsersGV.GetFocusedDataRow()["USERID"].ToString() + "' "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); MWDataManager.clsDataAccess _dbMan2 = new MWDataManager.clsDataAccess(); _dbMan2.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan2.SqlStatement = "delete from tbl_Users " + " where userid = '" + UsersGV.GetFocusedDataRow()["USERID"].ToString() + "' "; _dbMan2.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan2.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan2.ExecuteInstruction(); LoadUsers(); }
private void EditBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { PropFrm UsersFrm = new PropFrm(); UsersFrm._theConnection = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); UsersFrm.Edit.Text = "Y"; UsersFrm.UserIDTxt.Text = UsersGV.GetFocusedDataRow()["USERID"].ToString(); UsersFrm.UserNameTxt.Text = UsersGV.GetFocusedDataRow()["USERNAME"].ToString(); UsersFrm.PracticeTxt.Text = UsersGV.GetFocusedDataRow()["PracticeNo"].ToString(); UsersFrm.PasswordTxt.Text = UsersGV.GetFocusedDataRow()["Password"].ToString(); UsersFrm.PasswordConfTxt.Text = UsersGV.GetFocusedDataRow()["Password"].ToString(); UsersFrm.AccessCodeTxt.Text = UsersGV.GetFocusedDataRow()["AccessCode"].ToString(); //UsersFrm.UserNameTxt.Text = SysGrid.CurrentRow.Cells[1].Value.ToString(); //UsersFrm.PasswordTxt.Text = SysGrid.CurrentRow.Cells[2].Value.ToString(); //UsersFrm.PasswordConfTxt.Text = SysGrid.CurrentRow.Cells[3].Value.ToString(); //UsersFrm.PracticeTxt.Text = SysGrid.CurrentRow.Cells[4].Value.ToString(); //UsersFrm.AccessCodeTxt.Text = SysGrid.CurrentRow.Cells[5].Value.ToString(); // UsersFrm.ConnectionString = ConnectionString; UsersFrm.ShowDialog(); LoadUsers(); }
private void UsersGV_RowCellClick_1(object sender, RowCellClickEventArgs e) { UserRightsPnl.Width = panel1.Width / 4; //layoutControl10.Visible = true; ///Load Users Rights /// layoutControlGroup12.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = " " + " select a.Activity, " + " case when rights is null then 'N' else 'Y' end as Rights " + " from(" + " select distinct(Activity) Activity from tbl_User_Access)a " + " left outer join (" + " select Rights, Activity from tbl_User_Access where userid = '" + UsersGV.GetFocusedDataRow()["USERID"].ToString() + "')b " + " on a.Activity = b.Activity order by a.Activity "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); DataTable dt = _dbMan.ResultsDataTable; DataSet ds = new DataSet(); if (ds.Tables.Count > 0) { ds.Tables.Clear(); } ds.Tables.Add(dt); //Grd3Mnth.Visible = true; gridControl1.DataSource = ds.Tables[0]; gridColumn1.FieldName = "Activity"; gridColumn2.FieldName = "Rights"; }