public SigmaResultType MultiSigmaRoleSigmaJob(TypeSigmaRole listObj)
{
TypeUserInfo userinfo = AuthMgr.GetUserInfo();
listObj.CreatedBy = userinfo.SigmaUserId;
TransactionScope scope = null;
SigmaResultType result = new SigmaResultType();
// Get connection string
string connStr = ConnStrHelper.getDbConnString();
if(listObj.SigmaRoleId != null)
RemoveSigmaRoleSigmaJob(listObj.SigmaRoleId);
int sigmaRoleId = listObj.SigmaRoleId;
using (scope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
SigmaRoleMgr sigmaRoleMgr = new SigmaRoleMgr();
switch (listObj.SigmaOperation)
{
case "C":
result = sigmaRoleMgr.AddSigmaRole(listObj);
sigmaRoleId = result.ScalarValue;
break;
case "U":
result = sigmaRoleMgr.UpdateSigmaRole(listObj);
break;
}
if (result.IsSuccessful)
{
listObj.typeSigmaRoleSigmaJob.ForEach(x => x.CreatedBy = userinfo.SigmaUserId);
listObj.typeSigmaRoleSigmaJob.ForEach(x => x.SigmaRoleId = sigmaRoleId);
foreach (TypeSigmaRoleSigmaJob anObj in listObj.typeSigmaRoleSigmaJob)
{
AddSigmaRoleSigmaJob(anObj);
}
result.IsSuccessful = true;
scope.Complete();
}
}
return result;
}
public SigmaResultType AddSigmaRole(TypeSigmaRole objSigmaRole)
{
SigmaResultType result = new SigmaResultType();
try
{
SigmaRoleMgr sigmaRoleMgr = new SigmaRoleMgr();
result = sigmaRoleMgr.AddSigmaRole(objSigmaRole);
return result;
}
catch (Exception ex)
{
// Log Exception
ExceptionHelper.logException(ex);
result.IsSuccessful = false;
result.ErrorMessage = ex.Message;
return result;
}
}
