public static void update(Guid userAccountID, Guid id, string name, string notes, List <int> userAccountAccessEnum)
{
UserAccountRole objOld = new UserAccountRole(id);
string log = "";
log = Util.appendChange(log, objOld.Name, name, "Name: '{0}' to '{1}'");
log = Util.appendChange(log, objOld.Notes, notes, "Notes: '{0}' to '{1}'");
using (SqlConnection sqlConnection = new SqlConnection(DBConnection.ConnectionString))
{
if (!string.IsNullOrEmpty(log))
{
SqlQueryResult result = DBConnection.query(
sqlConnection,
QueryTypes.ExecuteNonQuery,
"UserAccountRoles_update",
new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, id),
new SqlQueryParameter(COL_DB_Name, SqlDbType.NVarChar, Util.wrapNullable(name))
);
if (result.IsSuccessful)
{
LOGGING.ActivityLog.add(sqlConnection, userAccountID, id, String.Format("Updated: {0}", log));
}
}
UserAccountAccessRoleAssignment.update(sqlConnection, userAccountID, id, userAccountAccessEnum);
}
}
protected override void virtual_dgv_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (Util.isColumnMatch(sender, e, col_dgv_Special))
{
UserAccountRole.updateSpecialStatus(UserAccount.LoggedInAccount.Id, selectedRowID(), !Util.getCheckboxValue(sender, e));
populateGridViewDataSource(true);
}
}
protected override void populateInputFields()
{
UserAccountRole obj = new UserAccountRole(selectedRowID());
itxt_Name.ValueText = obj.Name;
itxt_Notes.ValueText = obj.Notes;
//populate access tree
clearUserAccountAccessTree();
DataTable accesses = UserAccountAccessRoleAssignment.getByUserAccountRoleId(obj.Id);
CheckBox checkbox;
foreach (DataRow row in accesses.Rows)
{
_userAccountAccessDictionary.TryGetValue(Util.parseEnum <UserAccountAccessEnum>(row[UserAccountAccessRoleAssignment.COL_DB_UserAccountAccess_EnumId]), out checkbox);
checkbox.Checked = true;
}
}
protected override void setupFields()
{
setColumnsDataPropertyNames(UserAccount.COL_DB_Id, UserAccount.COL_DB_Active, null, null, null, null);
col_dgv_Username = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Username", itxt_Username.LabelText, UserAccount.COL_DB_Username, true, true, "", true, false, 60, DataGridViewContentAlignment.MiddleLeft);
itxt_Username.MaxLength = UserAccount.USERNAME_MAXLENGTH;
col_dgv_Firstname = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Firstname", itxt_Firstname.LabelText, UserAccount.COL_DB_Firstname, true, true, "", true, false, 60, DataGridViewContentAlignment.MiddleLeft);
col_dgv_Lastname = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Lastname", itxt_Lastname.LabelText, UserAccount.COL_DB_Lastname, true, true, "", true, false, 60, DataGridViewContentAlignment.MiddleLeft);
col_dgv_Birthday = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Birthday", idtp_Birthdate.LabelText, UserAccount.COL_DB_Birthdate, true, true, "", true, false, 60, DataGridViewContentAlignment.MiddleLeft);
col_dgv_Address1 = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Address1", itxt_Address1.LabelText, UserAccount.COL_DB_Address1, true, true, "", true, true, 60, DataGridViewContentAlignment.MiddleLeft);
col_dgv_Address2 = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Address2", itxt_Address2.LabelText, UserAccount.COL_DB_Address2, true, true, "", true, true, 60, DataGridViewContentAlignment.MiddleLeft);
col_dgv_Phone1 = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Phone1", itxt_Phone1.LabelText, UserAccount.COL_DB_Phone1, true, true, "", true, false, 60, DataGridViewContentAlignment.MiddleLeft);
col_dgv_Phone2 = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Phone2", itxt_Phone2.LabelText, UserAccount.COL_DB_Phone2, true, true, "", true, false, 60, DataGridViewContentAlignment.MiddleLeft);
col_dgv_Email = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Email", itxt_Email.LabelText, UserAccount.COL_DB_Email, true, true, "", true, false, 50, DataGridViewContentAlignment.MiddleLeft);
col_dgv_Notes = base.addColumn <DataGridViewTextBoxCell>(dgv, "col_dgv_Notes", itxt_Notes.LabelText, UserAccount.COL_DB_Notes, true, true, "", false, true, 50, DataGridViewContentAlignment.MiddleLeft);
col_dgv_Notes.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
UserAccountRole.populateCheckedListBox(clbUserAccountRoles, false, UserAccount.LoggedInAccount.Special || UserAccount.IsCreateAccount);
}
protected override void updateActiveStatus(Guid id, Boolean activeStatus)
{
UserAccountRole.updateActiveStatus(UserAccount.LoggedInAccount.Id, id, activeStatus);
}
protected override void add()
{
UserAccountRole.add(UserAccount.LoggedInAccount.Id, itxt_Name.ValueText, itxt_Notes.ValueText, getSelectedUserAccountAccessEnum());
}
protected override void update()
{
UserAccountRole.update(UserAccount.LoggedInAccount.Id, selectedRowID(), itxt_Name.ValueText, itxt_Notes.ValueText, getSelectedUserAccountAccessEnum());
}
protected override System.Data.DataView loadGridviewDataSource()
{
return(UserAccountRole.get(chkIncludeInactive.Checked, true, null, itxt_Name.ValueText, itxt_Notes.ValueText).DefaultView);
}
/*******************************************************************************************************/
#region METHODS
#endregion
/*******************************************************************************************************/
#region EVENT HANDLERS
private void btnRoles_Click(object sender, EventArgs e)
{
Util.displayForm(null, new LOGIN.MasterData_v1_UserAccountRoles_Form());
UserAccountRole.populateCheckedListBox(clbUserAccountRoles, false, true);
}
