public void AddIdeaAssignment(IIdeaDatabaseDataContext dc, IdeaAssignment ideaAssignment)
{
if (ideaAssignment != null)
{
dc.IdeaAssignments.Add(ideaAssignment);
}
}
public void SubmitIdeaAssignment(ResponseBase response, int IdeaId)
{
DatabaseWrapper.databaseOperation(response,
(context, query) =>
{
List <IdeaAssignment> ideaAssignmentsList = new List <IdeaAssignment>();
Role roles = query.GetAllRoleMappings(context, RoleTypes.REVIEWER.ToString());
if (roles == null || roles.RoleMappings.Count == 0)
{
response.ErrorList.Add(Faults.ReviewerNotExists);
return;
}
foreach (var users in roles.RoleMappings)
{
IdeaAssignment ideaAssignment1 = new IdeaAssignment()
{
IdeaId = IdeaId, ReviewByUserId = users.UserId, IsActive = true, CreatedDate = DateTime.UtcNow
};
ideaAssignmentsList.Add(ideaAssignment1);
}
query.AddUserAssignmentToIdea(context, ideaAssignmentsList);
context.SubmitChanges();
}
, readOnly: false
);
}
public void SubmitIdeaAssignments(RestAPIAddIdeaStateResponse response, int UserId, int IdeaId, int ideaState)
{
DatabaseWrapper.databaseOperation(response,
(context, query) =>
{
Role roles = null;
RoleMapping roleMapping = null;
IdeaAssignment assignment = null;
if (ideaState == (int)IdeaStatusTypes.ReviewPending)
{
roles = query.GetAllRoleMappings(context, RoleTypes.REVIEWER.ToString());
}
else if (ideaState == (int)IdeaStatusTypes.SponsorPending)
{
roles = query.GetAllRoleMappings(context, RoleTypes.SPONSOR.ToString());
}
else if (ideaState == (int)IdeaStatusTypes.Sponsored)
{
roles = query.GetAllRoleMappings(context, RoleTypes.SALES.ToString());
}
if (roles == null || roles.RoleMappings.Count == 0)
{
response.ErrorList.Add(Faults.ReviewerNotExists);
return;
}
roleMapping = query.GetUserRoleMappingByRoleId(context, roles.RoleId);
assignment = query.GetAssignmentByIdeaId(context, IdeaId);
if (assignment != null)
{
assignment.ReviewByUserId = roleMapping.UserId;
}
else
{
IdeaAssignment ideaassignment = new IdeaAssignment()
{
IdeaId = IdeaId, ReviewByUserId = roleMapping.UserId, IsActive = true, CreatedDate = DateTime.UtcNow
};
query.AddIdeaAssignment(context, ideaassignment);
}
context.SubmitChanges();
}
, readOnly: false
);
}
