long _lngPKID = 0; // Primary key variable set it to 0
#endregion
#region Constructor
/// <summary>
/// load the query that has been passed to the first parameter value
/// and place it in a datatable
/// </summary>
/// <param name="pStrQuery"></param>
/// <param name="pDtb"></param>
public FrmPermissions(String pStrQuery, DataTable pDtb)
{
InitializeComponent();
_permission = new Permission(); // create a new instance
pDtb = _dbConn.GetDataTable(pStrQuery); // get the current query and place it into the datatable
dgvData.DataSource = pDtb; // display datatable in the datagrid view
dgvData.Columns[0].Visible = false; // set the first row to invisible
populateEmployeeCombo(); //populate the employee combo box
populateFormsCombo(); // populate the forms combo box
_dtb = pDtb; // set the global value to the paremeter value
_strQuery = pStrQuery; // set the global variable to the parameter value
}
private void dgvData_Click(object sender, EventArgs e)
{
mnuSave.Enabled = false;
ErrorProvider.Dispose();
// if there is an id value in this current row
if (dgvData["EmployeeFormID", dgvData.CurrentCell.RowIndex].Value.ToString() != string.Empty)
{
// give the primary key variable the current id of the current row selected
_lngPKID = long.Parse(dgvData["EmployeeFormID", dgvData.CurrentCell.RowIndex].Value.ToString());
_permission = new Permission(_lngPKID); // create a new instance of the permission but pass it the id
displayRecord(); // display the current record
groupBox1.Enabled = true; groupBox2.Enabled = true; groupBox3.Enabled = true; groupBox4.Enabled = true;
mnuSave.Enabled = true;
}
}
private void dgvData_DoubleClick(object sender, EventArgs e)
{
// the there are no id values in this current row
if (dgvData["EmployeeFormID", dgvData.CurrentCell.RowIndex].Value.ToString() == string.Empty)
{
_lngPKID = 0; // set the primary key to 0
clearFields(); // clear the fields
_permission = new Permission(); // and make a new instance of permissions
groupBox1.Enabled = true; groupBox2.Enabled = true; groupBox3.Enabled = true; groupBox4.Enabled = true;
}
}