//public ActionResult CapBook() //{ // ManageCapBookModel model = new ManageCapBookModel(); // model.PersonalSummary = new DataTableModel(1, (IQueryable)service.GetVwTLCSummaryQueryable()); // Session["ManageCapBookModel"] = model; // ViewData["SelectedCapBookPersonalId"] = (long)0; // return View(model); //} public ActionResult CapBookPartial(Nullable <long> PersonalId) { ManageCapBookModel model = (ManageCapBookModel)Session["ManageCapBookModel"]; if (PersonalId != null) { ViewData["SelectedCapBookPersonalId"] = (long)PersonalId; model.SelectedPersonnelId = (long)PersonalId; TLC_PersonalSummaryModel ps = model.PersonalSummary.GetItem(PersonalId); if (ps != null) { model.Passport = ps.EnscoPassportNo; } } IQueryable <CAP_CompetencyAssessModel> compItems = service.GetCompAssessQueryable(model.Passport, null); compItems = compItems.OrderBy(x => x.Title); model.Competency = new DataTableModel(2, compItems); if (model.Passport != null && model.SelectedPersonnelId != 0) { model.CapBooks = service.GetCAPBookQueryable().Where(x => x.EnscoPassportNo == model.Passport); model.KSAs = new DataTableModel(3, model.CapBooks.Where(x => x.CompId == (long)0)); model.Additional = new DataTableModel(3, model.CapBooks.Where(x => x.CompId == (long)0)); model.Expired = new DataTableModel(3, model.CapBooks.Where(x => x.CompId == (long)0)); model.AssessorGuide = new DataTableModel(3, model.CapBooks.Where(x => x.CompId == (long)0)); int count = model.KSAs.Dataset.Count(); } return(PartialView("CapBookPartial", model)); }
public ActionResult CapBookReport(string passportId) { CAP_BookReportModel model = new CAP_BookReportModel(); model.CapBookEnscoLogo = HttpContext.Server.MapPath("~/Images/CapEnscoLogo.png"); model.CapBookImage1 = HttpContext.Server.MapPath("~/Images/CapBook1.png"); model.CapBookImage2 = HttpContext.Server.MapPath("~/Images/CapBook2.png"); model.CapBookTlcLogo = HttpContext.Server.MapPath("~/Images/TlcLogo.png"); model.CapBookPage1 = HttpContext.Server.MapPath("~/Images/CapBookPage1.png"); model.CapBookPage2 = HttpContext.Server.MapPath("~/Images/CapBookPage2.png"); model.CapBookPage3 = HttpContext.Server.MapPath("~/Images/CapBookPage3.png"); model.CapBookPage4 = HttpContext.Server.MapPath("~/Images/CapBookPage4.png"); model.CapBookPage5 = HttpContext.Server.MapPath("~/Images/CapBookPage5.png"); model.CapBookPage6 = HttpContext.Server.MapPath("~/Images/CapBookPage6.png"); model.CapBookPage7 = HttpContext.Server.MapPath("~/Images/CapBookPage7.png"); model.CapBookPage8 = HttpContext.Server.MapPath("~/Images/CapBookPage8.png"); model.CapBookPage9 = HttpContext.Server.MapPath("~/Images/CapBookPage9.png"); model.CapBookPage10 = HttpContext.Server.MapPath("~/Images/CapBookPage10.png"); // Get User Information LookupListModel <dynamic> lkpPosition = LookupListSystem.GetLookupList("Position"); LookupListModel <dynamic> lkpDept = LookupListSystem.GetLookupList("Department"); LookupListModel <dynamic> lkpBU = LookupListSystem.GetLookupList("BusinessUnit"); UserModel user = ServiceSystem.GetUserFromPassport(passportId); model.Passport = passportId; model.Name = user.DisplayName; model.Position = (string)lkpPosition.GetDisplayValue(user.Position); model.Department = (string)lkpPosition.GetDisplayValue(user.Department); model.BusinessUnit = (string)lkpPosition.GetDisplayValue(user.BusinessUnit); model.RigFacility = UtilitySystem.Settings.RigName; if (user.Manager != null) { UserModel manager = ServiceSystem.GetUser((int)user.Manager); if (manager != null) { model.Supervisor = manager.DisplayName; } } model.OIM = IrmaServiceSystem.GetAdminCustomValue("OIMName"); CapBookReport report = new CapBookReport(); RigCapService RigCapService = new RigCapService(); IQueryable <CAP_BookModel> capBookItems = RigCapService.GetCAPBookQueryable().Where(x => x.EnscoPassportNo == passportId).OrderBy(x => x.CompId); int compNo = 1; int ksaNo = 1; CAP_BookModel lastItem = null; foreach (CAP_BookModel item in capBookItems) { if (lastItem != null) { if (lastItem.CompId != item.CompId) { compNo++; ksaNo = 0; } ksaNo++; } item.CompetencyNumber = string.Format("{0}.0", compNo); item.KSANumber = string.Format("{0}.{1}", compNo, ksaNo); model.Items.Add(item); lastItem = (lastItem == null || lastItem.CompId != item.CompId) ? item : lastItem; } List <CAP_BookReportModel> list = new List <CAP_BookReportModel>(); list.Add(model); report.DataSource = list; Session["currentReport"] = report; return(RedirectToAction("ShowReport", "Report")); }