public Report()
{
IDbFactory factory = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
_reportDefRepo = new DataReport <ReportServer>(factory);
_reportRepo = new DataReport <TReport>(factory);
}
public ICDRequestFormService()
{
BC = new ICDRequestFormBC(
DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow),
DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc)
);
}
public DocumentService()
{
_dbFactory = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc);
_documentRepository = new DocumentRepository(_dbFactory);
_work = new UnitOfWork(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc));
_webHelper = new WebHelper();
}
public NotificationService()
{
var dbContext = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
dataProcessingProvider = new TicketDataProcessingProvider(dbContext);
ticketEnquiry = new TicketDataProcessingProvider(dbContext);
}
public AttachmentService()
{
_dbFactory = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc);
_tempFileRepository = new AttachementRepository <FileTemp>(_dbFactory);
_work = new UnitOfWork(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc));
_webHelper = new WebHelper();
}
public EFormIntegrated() : base()
{
var dbSource = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
requestHeaderRepo = new RequestHeaderRepository(dbSource);
formIntegratedRepo = new SimpleRepository <TicketFormIntegrated>(dbSource);
}
public TicketService()
{
var dbContext = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
dataProcessingProvider = new TicketDataProcessingProvider(dbContext);
this.unitOfWork = new UnitOfWork(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
ticketEnquiry = (ITicketEnquiry)dataProcessingProvider;
load = new LoadTicketData(dataProcessingProvider);
this.subCategoryRepo = new TicketSubCategoryRepository(dbContext);
this.categoryRepo = new TicketCategoryRepository(dbContext);
this.agentRepo = new TicketAgentRepository(dbContext);
this.deptRepo = new TicketDeptRepository(dbContext);
this.groupPolicyRepo = new TicketGroupPolicyRepository(dbContext);
this.teamRepo = new TicketTeamRepository(dbContext);
this.teamAgentAssignRepo = new TicketTeamAgentAssignRepository(dbContext);
this.ticketItemRepo = new TicketItemRepository(dbContext);
this.ticketLookupRepo = new TicketLookupRepository(dbContext);
this.slaRepo = new TicketSlaRepository(dbContext);
this.priorityRepo = new TicketPriorityRepository(dbContext);
this.groupPolicyTeamAssignRepo = new TicketGroupPolicyTeamAssignRepository(dbContext);
this.ticketingRepo = new TicketingRepository(dbContext);
this.groupPolicyReportAssignRepo = new TicketGroupPolicyReportAssignRepository(dbContext);
this.slaMappingRepo = new TicketSlaMappingRepository(dbContext);
}
public PBFRequestFormService()
{
var workflow = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
var docWorkflow = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc);
BC = new PBFRequestFormBC(workflow, docWorkflow);
}
public AbstractTicketIntegrated()
{
var dbSource = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
ticketService = new TicketService();
dataProProvider = new TicketDataProcessingProvider(dbSource);
empRepo = new EmployeeRepository(dbSource);
}
public IEnumerable <T> AttachFileTemp <T>(int requestId) where T : FileUpload
{
var attachementRepo = new AttachementRepository <T>(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc));
var attachments = attachementRepo.GetAll().Where(t => t.Id == requestId);
return(attachments);
}
public ATTRequestFormService()
{
workflow = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
var docWorkflow = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc);
BC = new ATTRequestFormBC(workflow, docWorkflow);
_FlightDetailRepository = new FlightDetailRepository(workflow);
}
public MailEntegrated() : base()
{
var dbSource = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
emailRepo = new SimpleRepository <EmailItem>(dbSource);
deptRepo = new TicketDepartmentRepository(dbSource);
fileUploadRepo = new UploadFileRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc));
emailAttchedRepo = new SimpleRepository <Domain.Entities.Email.FileAttachement>(dbSource);
}
public WorklistService(string userAccount = null)
{
IDbFactory dbFactory = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
_actLog = new ActivityHistoryRepository(dbFactory);
_repo = new WMRepository(dbFactory);
_provider = new ProcInstProvider(userAccount);
_account = userAccount.FQNWithK2Label();
}
protected ScheduleJobBase()
{
_EmailService = new EmailService();
_DbFactory = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
_JobRepository = new JobRepository(_DbFactory);
_EmailContentRepository = new EmailContentRepository(_DbFactory);
_RecipientRepository = new RecipientRepository(_DbFactory);
_Job = _JobRepository.Get(p => p.KeyValue == KeyValue);
Attachments = new List <EmailFileAttachment>();
}
public IEnumerable <ItemTypeDto> GetItemTypes(int itemId)
{
var sql = "SELECT IT.ID, " +
" IT.ITEM_TYPE_NAME itemTypeName, " +
" IT.DESCRIPTION description " +
"FROM IT.ITEM_ITEM_TYPE IIT " +
" INNER JOIN IT.ITEM_TYPE IT ON IIT.ITEM_TYPE_ID = IT.ID " +
"WHERE IIT.ITEM_ID = @itemId ORDER BY IT.SEQUENCE, IT.ITEM_TYPE_NAME ";
IRequestItemRepository requestItemRepository = new RequestItemRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
IEnumerable <ItemTypeDto> itemTypes = requestItemRepository.SqlQuery <ItemTypeDto>(sql, new object[] { new SqlParameter("@itemId", itemId) });
return(itemTypes);
}
public FormsController()
{
_attachmentService = new Lazy <IAttachmentService>(() => new AttachmentService(), true);
_documentRepository = new DocumentRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
_fileRepository = new DocumentFileRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc));
_worklistRepository = new WMRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
_deprecatedProcCode.Add(PROCESSCODE.ITF);
_deprecatedProcCode.Add(PROCESSCODE.BCJ);
_deprecatedProcCode.Add(PROCESSCODE.AVJB);
_deprecatedProcCode.Add(PROCESSCODE.RSVNFF);
_deprecatedProcCode.Add(PROCESSCODE.RSVNCR);
_deprecatedProcCode.Add(PROCESSCODE.ERF);
_deprecatedProcCode.Add(PROCESSCODE.ATT);
_deprecatedProcCode.Add(PROCESSCODE.PB);
}
public IEnumerable <ItemRoleDto> GetItemRoles(int itemId, int itemTypeId)
{
IRequestItemRepository requestItemRepository = new RequestItemRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
var sql = " SELECT IR.ID id, " +
" IR.ROLE_NAME roleName, " +
" IR.DESCRIPTION description, " +
" IR.ADMIN isAdmin " +
"FROM IT.ITEM_ITEM_TYPE IIT " +
" INNER JOIN IT.ITEM_ROLE_MAPPING TM ON IIT.ID = TM.ITEM_ITEM_TYPE_ID " +
" INNER JOIN IT.ITEM_ROLE IR ON IR.ID = TM.ITEM_ROLE_ID " +
"WHERE IIT.ITEM_ID = @itemId AND IIT.ITEM_TYPE_ID = @itemTypeId ORDER BY IR.SEQUENCE, IR.ROLE_NAME ";
IEnumerable <ItemRoleDto> itemRoles = requestItemRepository.SqlQuery <ItemRoleDto>(sql, new object[] { new SqlParameter("@itemId", itemId), new SqlParameter("@itemTypeId", itemTypeId) });
return(itemRoles);
}
protected string GetReferenceNo()
{
ILookupRepository lookupReposity = new LookupRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
var lookup = lookupReposity.GetLookup("[HR].[EMPLOYEE_REQUISITION].[REFERENCE_NO]");
if ((HR_RECRUITMENT.Equals(CurrentActivity().ActivityName)) && lookup != null)
{
int stockNum = Convert.ToInt32(lookup.Value);
lookup.Value = (++stockNum).ToString();
lookupReposity.Update(lookup);
return(string.Concat(DateTime.Now.ToString("yyyyMMdd"), "-", stockNum.ToString("0000")));
}
else
{
return(null);
}
}
protected string GetProjectReference(bool hasRef)
{
ILookupRepository lookupReposity = new LookupRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
var lookup = lookupReposity.GetLookup("[EVENT].[PROJECT_BRIEF].[PROJECT_REFERENCE]");
if ((MARCOM_TECHNICAL.Equals(CurrentActivity().ActivityName)) && lookup != null && !hasRef)
{
int stockNum = Convert.ToInt32(lookup.Value);
lookup.Value = (++stockNum).ToString();
lookupReposity.Update(lookup);
return(string.Concat(DateTime.Now.ToString("yy"), stockNum.ToString("0000")));
}
else
{
return(null);
}
}
public IEnumerable <ItemDto> GetItems(int sessionId, bool deprecated = false)
{
var sql = "SELECT ID id, " +
" DEPT_SESSION_ID sessionId, " +
" REQUEST_ITEM_NAME itemName, " +
" DESCRIPTION description, " +
" HOD_REQUIRED hodRequired " +
"FROM IT.ITEM " +
"WHERE DEPT_SESSION_ID = @sessionId " +
(!deprecated ? " AND DEPRECATED = 0 " : string.Empty) +
"ORDER BY SEQUENCE, REQUEST_ITEM_NAME ";
IRequestItemRepository requestItemRepository = new RequestItemRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
IEnumerable <ItemDto> items = requestItemRepository.SqlQuery <ItemDto>(sql, new object[] { new SqlParameter("@sessionId", sessionId) });
return(items);
}
public BcjRequestContentService()
{
var workflow = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
_projectDetailRepository = new ProjectDetailRepository(workflow);
}
public RequestHeaderService()
{
IDbFactory dbFactory = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
requestHeaderRepo = new RequestHeaderRepository(dbFactory);
}
public GenericFormRpt()
{
IDbFactory factory = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
_procInstRepo = new DataReport <GenericForm>(factory);
}
public IEnumerable <AttandanceDetailType> GetAttandanceDetailTypeList()
{
ATDDetailTypeRepository rep = new ATDDetailTypeRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
return(rep.GetAll().ToList());
}
protected IEnumerable <TEntity> SqlQuery <TEntity>(string sql, params object[] parameters) where TEntity : class
{
var dbContext = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow).init();
return(dbContext.Database.SqlQuery <TEntity>(sql, parameters));
}
public RoleRightService()
{
_Repository = new RoleRightRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
}
public AuthRepository() : base(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow))
{
userManager = new UserManager <IdentityUser>(new UserStore <IdentityUser>(DbContext));
}
public LookupService()
{
menuReposity = new MenuRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
lookupReposity = new LookupRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
lookupChildReposity = new LookupRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
}
public SchedulerService()
{
IDbFactory dbFactory = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
_JobRepository = new JobRepository(dbFactory);
}
public IEnumerable <N2WorkType> GetWorkTypes()
{
IN2WorkTypeRepository workTypeRepository = new N2WorkTypeRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
return(workTypeRepository.GetAll().OrderBy(p => p.Sequence).ToList());
}
