private questStatus delete(FMSEntities dbContext, UserPrivilegeId userPrivilegeId)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
Quest.Services.Dbio.FMS.UserPrivileges _userPrivileges = null;
status = read(dbContext, userPrivilegeId, out _userPrivileges);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the record.
dbContext.UserPrivileges.Remove(_userPrivileges);
dbContext.SaveChanges();
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* UserPrivileges
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(FMSEntities dbContext, UserPrivilege userPrivilege, out UserPrivilegeId userPrivilegeId)
{
// Initialize
userPrivilegeId = null;
// Perform create
try
{
Quest.Services.Dbio.FMS.UserPrivileges _userPrivileges = new Quest.Services.Dbio.FMS.UserPrivileges();
_userPrivileges.PrivilegeId = userPrivilege.Privilege.Id;
_userPrivileges.UserId = userPrivilege.User.Id;
_userPrivileges.Created = DateTime.Now;
dbContext.UserPrivileges.Add(_userPrivileges);
dbContext.SaveChanges();
if (_userPrivileges.Id == 0)
{
return(new questStatus(Severity.Error, "UserPrivilege not created"));
}
userPrivilegeId = new UserPrivilegeId(_userPrivileges.Id);
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, UserPrivilegeId userPrivilegeId)
{
// Initialize
questStatus status = null;
// Delete userPrivilege
status = _dbUserPrivilegesMgr.Delete(trans, userPrivilegeId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, UserPrivilegeId userPrivilegeId)
{
// Initialize
questStatus status = null;
// Perform delete in this transaction.
status = delete((FMSEntities)trans.DbContext, userPrivilegeId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(UserPrivilegeId userPrivilegeId, out UserPrivilege userPrivilege)
{
// Initialize
userPrivilege = null;
questStatus status = null;
// Read userPrivilege
status = _dbUserPrivilegesMgr.Read(userPrivilegeId, out userPrivilege);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(UserPrivilegeId userPrivilegeId)
{
// Initialize
questStatus status = null;
// Perform delete.
using (FMSEntities dbContext = new FMSEntities())
{
status = delete(dbContext, userPrivilegeId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(UserPrivilege userPrivilege, out UserPrivilegeId userPrivilegeId)
{
// Initialize
questStatus status = null;
userPrivilegeId = null;
// Create userPrivilege
status = _dbUserPrivilegesMgr.Create(userPrivilege, out userPrivilegeId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, UserPrivilegeId userPrivilegeId, out UserPrivilege userPrivilege)
{
// Initialize
questStatus status = null;
userPrivilege = null;
// Perform read
Quest.Services.Dbio.FMS.UserPrivileges _userPrivileges = null;
status = read((FMSEntities)trans.DbContext, userPrivilegeId, out _userPrivileges);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
userPrivilege = new UserPrivilege();
BufferMgr.TransferBuffer(_userPrivileges, userPrivilege);
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(UserPrivilege userPrivilege, out UserPrivilegeId userPrivilegeId)
{
// Initialize
questStatus status = null;
userPrivilegeId = null;
// Data rules.
userPrivilege.Created = DateTime.Now;
// Create the userPrivilege
using (FMSEntities dbContext = new FMSEntities())
{
status = create(dbContext, userPrivilege, out userPrivilegeId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
private questStatus read(FMSEntities dbContext, UserPrivilegeId userPrivilegeId, out Quest.Services.Dbio.FMS.UserPrivileges userPrivilege)
{
// Initialize
userPrivilege = null;
try
{
userPrivilege = dbContext.UserPrivileges.Where(r => r.Id == userPrivilegeId.Id).SingleOrDefault();
if (userPrivilege == null)
{
return(new questStatus(Severity.Warning, String.Format("WARNING: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Id {0} not found", userPrivilegeId.Id))));
}
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public questStatus Save(UserPrivilegesViewModel userPrivilegesViewModel)
{
// Initialize
questStatus status = null;
DbMgrTransaction trans = null;
Mgr mgr = new Mgr(this.UserSession);
try
{
// BEGIN TRANSACTION
status = mgr.BeginTransaction("FMS", "SaveUserPrivileges_" + userPrivilegesViewModel.Id.ToString() + "_" + Guid.NewGuid().ToString(), out trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Remove all the user's privileges.
UserId userId = new UserId(userPrivilegesViewModel.Id);
UserPrivilegesMgr userPrivilegesMgr = new UserPrivilegesMgr(this.UserSession);
status = userPrivilegesMgr.Delete(trans, userId);
if (!questStatusDef.IsSuccess(status))
{
mgr.RollbackTransaction(trans);
return(status);
}
// Save all the privileges the user is assigned.
UserPrivilege userPrivilege = new UserPrivilege();
userPrivilege.User.Id = userPrivilegesViewModel.User.Id;
foreach (BootstrapTreenodeViewModel userPrivilegeNode in userPrivilegesViewModel.UserPrivileges)
{
UserPrivilegeId userPrivilegeId = null;
userPrivilege.Privilege.Id = userPrivilegeNode.Id;
status = userPrivilegesMgr.Create(trans, userPrivilege, out userPrivilegeId);
if (!questStatusDef.IsSuccess(status))
{
mgr.RollbackTransaction(trans);
return(status);
}
}
// COMMIT TRANSACTION
status = mgr.CommitTransaction(trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
catch (System.Exception ex)
{
if (trans != null)
{
mgr.RollbackTransaction(trans);
}
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, UserPrivilege userPrivilege, out UserPrivilegeId userPrivilegeId)
{
// Initialize
questStatus status = null;
userPrivilegeId = null;
// Data rules.
userPrivilege.Created = DateTime.Now;
// Create the userPrivilege in this transaction.
status = create((FMSEntities)trans.DbContext, userPrivilege, out userPrivilegeId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
