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