/// <summary> /// Add All the PreQualification Questions for the application /// </summary> /// <param name="application"></param> /// <returns></returns> public async Task <bool> IgniteApplicationInsertPrequalificationQuestions(IgniteUserApplication application) { const string stored_proc = "ibs.IgniteUserApplication_InsertPrequalification"; var parameters = new DynamicParameters(); parameters.Add("ManagerName", application.ManagerName, dbType: DbType.String); parameters.Add("BuName", application.BuName, dbType: DbType.String); parameters.Add("LocationName", application.LocationName, dbType: DbType.String); parameters.Add("EmployementOverOneYear", application.EmployementOverOneYear, dbType: DbType.Boolean); parameters.Add("BachelorDegreeQualifier", application.BachelorDegreeQualifier, dbType: DbType.Boolean); parameters.Add("BachelorDegreePursuing", application.BachelorDegreePursuing, dbType: DbType.Boolean); parameters.Add("PreQualificationQuestionsCompletionDate", application.PreQualificationQuestionsCompletionDate, dbType: DbType.DateTime2); parameters.Add("ArePrequalificationQuestionComplete", application.ArePrequalificationQuestionComplete, dbType: DbType.Boolean); parameters.Add("ManagerStatusChangeDate", application.ManagerStatusChangeDate, dbType: DbType.DateTime2); parameters.Add("AreQualificationQuestionsComplete", application.AreQualificationQuestionsComplete, dbType: DbType.Boolean); parameters.Add("IgniteApplicationStatusId", application.IgniteApplicationStatusId, dbType: DbType.Int32); try { using (var conn = new SqlConnection(_configuration.Value)) { conn.Open(); await conn.ExecuteAsync(stored_proc, parameters, commandType : CommandType.StoredProcedure); } } catch (Exception ex) { throw; } return(true); }
public IViewComponentResult Invoke() { var users = _context.IgniteUsers.AsNoTracking(); var igniteUserApplications = _context.IgniteUserApplications.AsNoTracking(); var depts = _context.Departments.AsNoTracking(); // inner join on dept and user users.Include(ig => ig.Department); List <IgniteUser> igUsers = users.ToList(); List <Department> departments = depts.ToList(); IgniteUser usr = new IgniteUser(); IgniteUserApplication app = new IgniteUserApplication(); Department dept = new Department(); foreach (var m in igUsers) { usr = m; dept = m.Department; igUsers.Add(usr); departments.Add(dept); } var joinRes = (from i in igUsers join d in departments on i.FKDepartmentId equals d.DepartmentId select new IgniteUserReportView { AppUserId = i.Id, FirstName = i.FirstName, LastName = i.LastName, DepartmentId = d.DepartmentId, DepartmentName = d.DepartmentName }).ToList(); IgniteUserReportView vm = new IgniteUserReportView() { FirstName = usr.FirstName, LastName = usr.LastName, LinkClicked = usr.LinkClicked, DepartmentId = dept.DepartmentId, DepartmentName = dept.DepartmentName }; //var viewName = isNullOrEmptyViewName ?? DefaultViewName : viewName return(View(igUsers)); }
/// <summary> /// Gives new Application to user to their assigned MGTSEmployeeCode if they do not have a pre-existing application /// </summary> /// <param name="application"></param> /// <returns></returns> public async Task <bool> IgniteApplicationAddNewApplication(IgniteUserApplication application) { int newApplicationStatusId = 1; application.IgniteApplicationStatusId = newApplicationStatusId; using (var conn = new SqlConnection(_configuration.Value)) { var parameters = new DynamicParameters(); parameters.Add("MGTSEmployeeCode", application.MgtsemployeeCode, DbType.Int32); const string query = @"insert into ibs.IgniteUserApplication (MGTSEmployeeCode) values (@MGTSEmployeeCode);"; const string stored_proc = "ibs.MGTSIgniteUserApplication_Insert"; conn.Open(); await conn.ExecuteAsync(stored_proc, parameters, commandType : CommandType.StoredProcedure); } return(true); }
/// <summary> /// Add Application to user if they have a pre-existing application /// </summary> /// <param name="application"></param> /// <returns></returns> public async Task <bool> IgniteApplicationProvideNewApplicationToUserWithPreviousApplication(IgniteUserApplication application) { throw new NotImplementedException(); }