private void OptionsGridView_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e) { try { OptionsGridView.GetDataRow(OptionsGridView.FocusedRowHandle); if (OptionsGridView.FocusedColumn.FieldName == "MASTER") { if (Convert.ToBoolean(e.Value) == true) { OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["ADMIN"], false); OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["REPORT"], false); OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["TRANSACTION"], false); } } if (OptionsGridView.FocusedColumn.FieldName == "TRANSACTION") { if (Convert.ToBoolean(e.Value) == true) { OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["ADMIN"], false); OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["REPORT"], false); OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["MASTER"], false); } } if (OptionsGridView.FocusedColumn.FieldName == "ADMIN") { if (Convert.ToBoolean(e.Value) == true) { OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["MASTER"], false); OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["REPORT"], false); OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["TRANSACTION"], false); } } if (OptionsGridView.FocusedColumn.FieldName == "REPORT") { if (Convert.ToBoolean(e.Value) == true) { OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["MASTER"], false); OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["ADMIN"], false); OptionsGridView.SetRowCellValue(OptionsGridView.FocusedRowHandle, OptionsGridView.Columns["TRANSACTION"], false); } } } catch (Exception ex) { ProjectFunctions.SpeakError(ex.Message); } }
private void BtnSaveOpts_Click(object sender, EventArgs e) { try { using (var con = new SqlConnection(ProjectFunctions.GetConnection())) { OptionsGridView.UpdateCurrentRow(); OptionsGridView.CloseEditor(); con.Open(); var cmd = new SqlCommand { Connection = con }; var Dt = (OptionsGrid.DataSource as DataTable).GetChanges(); var MaxRow = Dt.Rows.Count; for (var i = 0; i < MaxRow; i++) { var currentrow = Dt.Rows[i]; DataSet ds = ProjectFunctions.GetDataSet("Select ProgCode From UserProgAccess Where UserName='******' And ProgCode='" + currentrow["ProgCode"].ToString() + "'"); if (ds.Tables[0].Rows.Count > 0) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_UpdateUserWorkAllocation"; } else { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_InsertUserWorkAllocation"; } cmd.Parameters.Add("@dUserName", SqlDbType.VarChar).Value = currentrow["Username"]; cmd.Parameters.Add("@dProgCode", SqlDbType.VarChar).Value = currentrow["ProgCode"]; if (currentrow["&Add"].ToString() == "True") { cmd.Parameters.Add("@dProgAdd_F", SqlDbType.SmallInt).Value = -1; } else { cmd.Parameters.Add("@dProgAdd_F", SqlDbType.SmallInt).Value = 0; } if (currentrow["SELECTFIELD"].ToString() == "True") { cmd.Parameters.Add("@dSelectField", SqlDbType.SmallInt).Value = -1; } else { cmd.Parameters.Add("@dSelectField", SqlDbType.SmallInt).Value = 0; } if (currentrow["EDIT"].ToString() == "True") { cmd.Parameters.Add("@dProgUpd_F", SqlDbType.SmallInt).Value = -1; } else { cmd.Parameters.Add("@dProgUpd_F", SqlDbType.SmallInt).Value = 0; } if (currentrow["DELETE"].ToString() == "True") { cmd.Parameters.Add("@dProgDel_F", SqlDbType.SmallInt).Value = -1; } else { cmd.Parameters.Add("@dProgDel_F", SqlDbType.SmallInt).Value = 0; } if (currentrow["TRANSACTION"].ToString() == "True") { cmd.Parameters.Add("@dTransactionsMenu", SqlDbType.SmallInt).Value = -1; } else { cmd.Parameters.Add("@dTransactionsMenu", SqlDbType.SmallInt).Value = 0; } if (currentrow["MASTER"].ToString() == "True") { cmd.Parameters.Add("@dMasterMenu", SqlDbType.SmallInt).Value = -1; } else { cmd.Parameters.Add("@dMasterMenu", SqlDbType.SmallInt).Value = 0; } if (currentrow["ADMIN"].ToString() == "True") { cmd.Parameters.Add("@dAdministratorMenu", SqlDbType.SmallInt).Value = -1; } else { cmd.Parameters.Add("@dAdministratorMenu", SqlDbType.SmallInt).Value = 0; } if (currentrow["REPORT"].ToString() == "True") { cmd.Parameters.Add("@dReportMenu", SqlDbType.SmallInt).Value = -1; } else { cmd.Parameters.Add("@dReportMenu", SqlDbType.SmallInt).Value = 0; } if (currentrow["SPLRIGHTS"].ToString() == "True") { cmd.Parameters.Add("@dProgSpl_U", SqlDbType.SmallInt).Value = -1; } else { cmd.Parameters.Add("@dProgSpl_U", SqlDbType.SmallInt).Value = 0; } cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } BtnCancle_Click(null, e); } } catch (Exception ex) { ProjectFunctions.SpeakError(ex.Message); } }