public int AddNewCustomPermission(TBL_User_CustomPermissions permission)
{
int newID = 0;
try
{
TBL_User_CustomPermissions newPermission = new TBL_User_CustomPermissions()
{
CanAddNew = permission.CanAddNew,
CanApprove = permission.CanApprove,
CanAuthorize = permission.CanAuthorize,
CanCheck = permission.CanCheck,
CanDelete = permission.CanDelete,
CanModify = permission.CanModify,
CanPrint = permission.CanPrint,
CanView = permission.CanView,
fk_ModuleId = permission.fk_ModuleId,
fk_FormId = permission.fk_FormId,
fk_EmployeeId = permission.fk_EmployeeId
};
_dbContext.TBL_User_CustomPermissions.Add(newPermission);
_dbContext.SaveChanges();
newID = newPermission.pk_CustomPermissionID;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceUsers::AddNewCustomPermission", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(newID);
}
public bool RemoveCustomPermission(int permissionID)
{
bool result = false;
try
{
TBL_User_CustomPermissions model = _dbContext.TBL_User_CustomPermissions.Where(x => x.pk_CustomPermissionID == permissionID).FirstOrDefault();
if (model != null)
{
_dbContext.TBL_User_CustomPermissions.Remove(model);
_dbContext.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceUsers::RemoveCustomPermission", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
public void UpdateControlAccessListForRole(int roleID, int employeeID)
{
try
{
foreach (WhosWhoModel model in this.ListControlAccess)
{
TBL_MP_Master_RoleForm roleForm = (new ServiceRoles()).GetRoleFormDBRecordByRoleIDnFormID(roleID, (int)model.FormID);
if (roleForm != null)
{
model.CanAddNew = roleForm.CanAddNew;
model.CanApprove = roleForm.CanApprove;
model.CanAuthorize = roleForm.CanAuthorize;
model.CanCheck = roleForm.CanCheck;
model.CanDelete = roleForm.CanDelete;
model.CanModify = roleForm.CanModify;
model.CanPrepare = roleForm.CanPrepare;
model.CanPrint = roleForm.CanPrint;
model.CanView = roleForm.CanView;
}
else
{
model.CanAddNew = model.CanApprove = model.CanAuthorize = model.CanCheck = model.CanDelete = model.CanModify = model.CanPrepare = model.CanPrint = model.CanView = false;
}
}
//if custom privleges are set for particular employee
foreach (WhosWhoModel model in this.ListControlAccess)
{
TBL_User_CustomPermissions EmproleForm = (new ServiceRoles()).GetEmpRoleFormDBRecordByRoleIDnFormID(employeeID, (int)model.FormID);
if (EmproleForm != null)
{
model.CanAddNew = EmproleForm.CanAddNew;
model.CanApprove = EmproleForm.CanApprove;
model.CanAuthorize = EmproleForm.CanAuthorize;
model.CanCheck = EmproleForm.CanCheck;
model.CanDelete = EmproleForm.CanDelete;
model.CanModify = EmproleForm.CanModify;
model.CanPrepare = EmproleForm.CanPrepare;
model.CanPrint = EmproleForm.CanPrint;
model.CanView = EmproleForm.CanView;
}
//else
// model.CanAddNew = model.CanApprove = model.CanAuthorize = model.CanCheck = model.CanDelete = model.CanModify = model.CanPrepare = model.CanPrint = model.CanView = false;
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceWhoseWho::UpdateControlAccessListForRole", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmAddEditCustomPermission_Load(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
try
{
SetPermissionButtonsTag();
PopulateModulesDropdown();
PopulateModuleFormsDropdown();
if (this.CustomPermissionID != 0)
{
TBL_User_CustomPermissions model = (new ServiceUsers()).GetCustomPermissionByPermissionID(this.CustomPermissionID);
if (model != null)
{
this.SelectedModuleID = (int)model.fk_ModuleId;
cboModules.SelectedItem = ((List <SelectListItem>)cboModules.DataSource).Where(x => x.ID == SelectedModuleID).FirstOrDefault();
this.SelectedFormID = (int)model.fk_FormId;
cboForms.SelectedItem = ((List <SelectListItem>)cboForms.DataSource).Where(x => x.ID == SelectedFormID).FirstOrDefault();
btnCanAddNewRecord.Checked = model.CanAddNew;
PermissionsButton_Click(btnCanAddNewRecord, null);
btnCanApproveRecord.Checked = model.CanApprove;
PermissionsButton_Click(btnCanApproveRecord, null);
btnCanAuthorizeRecord.Checked = model.CanAuthorize;
PermissionsButton_Click(btnCanAuthorizeRecord, null);
btnCanCheckRecord.Checked = model.CanCheck;
PermissionsButton_Click(btnCanCheckRecord, null);
btnCanDeleteRecord.Checked = model.CanDelete;
PermissionsButton_Click(btnCanDeleteRecord, null);
btnCanModifyRecord.Checked = model.CanModify;
PermissionsButton_Click(btnCanModifyRecord, null);
btnCanPrintRecord.Checked = model.CanPrint;
PermissionsButton_Click(btnCanPrintRecord, null);
btnCanViewRecord.Checked = model.CanView;
PermissionsButton_Click(btnCanViewRecord, null);
}
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditCustomPermission::frmAddEditCustomPermission_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Cursor = Cursors.Default;
}
public TBL_User_CustomPermissions GetEmpRoleFormDBRecordByRoleIDnFormID(int EmpID, int formID)
{
TBL_User_CustomPermissions EmproleForm = null;
try
{
EmproleForm = (from xx in _dbContext.TBL_User_CustomPermissions where xx.fk_EmployeeId == EmpID && xx.fk_FormId == formID select xx).FirstOrDefault();
}
catch (Exception ex)
{
string errMessage = string.Format("{0}\n{1}", ex.Message, ex.InnerException.Message);
MessageBox.Show(errMessage, "ServiceRoles::GetRoleFormDBRecordByRoleIDnFormID", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(EmproleForm);
}
public TBL_User_CustomPermissions GetCustomPermissionByPermissionID(int permissionID)
{
TBL_User_CustomPermissions model = null;
try
{
model = _dbContext.TBL_User_CustomPermissions.Where(x => x.pk_CustomPermissionID == permissionID).FirstOrDefault();
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceUsers::GetCustomPermissionByPermissionID", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(model);
}
public bool UpdateCustomPermission(int permissionID, TBL_User_CustomPermissions updatePermission)
{
bool result = false;
try
{
TBL_User_CustomPermissions model = _dbContext.TBL_User_CustomPermissions.Where(x => x.pk_CustomPermissionID == permissionID).FirstOrDefault();
if (model != null)
{
model.CanAddNew = updatePermission.CanAddNew;
model.CanApprove = updatePermission.CanApprove;
model.CanAuthorize = updatePermission.CanAuthorize;
model.CanCheck = updatePermission.CanCheck;
model.CanDelete = updatePermission.CanDelete;
model.CanModify = updatePermission.CanModify;
model.CanPrint = updatePermission.CanPrint;
model.CanView = updatePermission.CanView;
model.fk_ModuleId = updatePermission.fk_ModuleId;
model.fk_FormId = updatePermission.fk_FormId;
model.fk_EmployeeId = updatePermission.fk_EmployeeId;
_dbContext.SaveChanges();
result = true;
}
;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceUsers::AddNewCustomPermission", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
private void btnSave_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
try
{
TBL_User_CustomPermissions model = null;
errorProvider1.Clear();
if (this.ValidateChildren())
{
if (this.CustomPermissionID != 0)
{
model = (new ServiceUsers()).GetCustomPermissionByPermissionID(this.CustomPermissionID);
model.CanAddNew = btnCanAddNewRecord.Checked;
model.CanApprove = btnCanApproveRecord.Checked;
model.CanAuthorize = btnCanAuthorizeRecord.Checked;
model.CanCheck = btnCanCheckRecord.Checked;
model.CanDelete = btnCanDeleteRecord.Checked;
model.CanModify = btnCanModifyRecord.Checked;
model.CanPrint = btnCanPrintRecord.Checked;
model.CanView = btnCanViewRecord.Checked;
model.fk_ModuleId = this.SelectedModuleID;
model.fk_FormId = this.SelectedFormID;
model.fk_EmployeeId = this.SelectedEmployeeID;
if ((new ServiceUsers()).UpdateCustomPermission(this.CustomPermissionID, model))
{
this.DialogResult = DialogResult.OK;
}
}
else
{
model = new TBL_User_CustomPermissions()
{
CanAddNew = btnCanAddNewRecord.Checked,
CanApprove = btnCanApproveRecord.Checked,
CanAuthorize = btnCanAuthorizeRecord.Checked,
CanCheck = btnCanCheckRecord.Checked,
CanDelete = btnCanDeleteRecord.Checked,
CanModify = btnCanModifyRecord.Checked,
CanPrint = btnCanPrintRecord.Checked,
CanView = btnCanViewRecord.Checked,
fk_ModuleId = this.SelectedModuleID,
fk_FormId = this.SelectedFormID,
fk_EmployeeId = this.SelectedEmployeeID
};
int newID = (new ServiceUsers()).AddNewCustomPermission(model);
if (newID > 0)
{
this.DialogResult = DialogResult.OK;
}
}
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditCustomPermission::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Cursor = Cursors.Default;
}
