//COMPANY_ID /// <summary> /// Delete /// </summary> /// <param name="projectId">projectId</param> /// <param name="sectionId">sectionId</param> /// <param name="companyId">companyId</param> public void Delete(int projectId, int assetId, int companyId) { WorkRehabAssessmentGateway workRehabAssessmentGateway = new WorkRehabAssessmentGateway(); WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(workRehabAssessmentGateway.Data); WorkFullLengthLiningGateway workFullLengthLiningGateway = new WorkFullLengthLiningGateway(); WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(workFullLengthLiningGateway.Data); WorkJunctionLiningSectionGateway workJunctionLiningSectionGateway = new WorkJunctionLiningSectionGateway(); WorkJunctionLiningSection workJunctionLiningSection = new WorkJunctionLiningSection(workJunctionLiningSectionGateway.Data); int workIdRA = GetWorkId(projectId, assetId, "Rehab Assessment", companyId); if (workIdRA != 0) workRehabAssessment.DeleteDirect(workIdRA, companyId); int workIdFL = GetWorkId(projectId, assetId, "Full Length Lining", companyId); if (workIdFL != 0) workFullLengthLining.DeleteDirect(workIdFL, companyId); int workIdJL = GetWorkId(projectId, assetId, "Junction Lining Section", companyId); if (workIdJL != 0) workJunctionLiningSection.DeleteDirect(workIdJL, companyId); LfsAssetSewerSectionGateway lfsAssetSewerSectionGateway = new LfsAssetSewerSectionGateway(); lfsAssetSewerSectionGateway.LoadByAssetId(assetId, companyId); LfsAssetSewerSection lfsAssetSewerSection = new LfsAssetSewerSection(lfsAssetSewerSectionGateway.Data); // Update lfs asset lfsAssetSewerSection.DeleteDirect(assetId, companyId); }
/// <summary> /// DeleteDirect /// </summary> /// <param name="workId">workId</param> /// <param name="companyId">companyId</param> public void DeleteDirect(int workId, int companyId) { WorkRehabAssessmentGateway workRehabAssessmentGateway = new WorkRehabAssessmentGateway(null); workRehabAssessmentGateway.Delete(workId, companyId); Work work = new Work(null); work.DeleteDirect(workId, companyId); }
/// <summary> /// Save a Previous RA work /// </summary> /// <param name="projectId">projectId</param> /// <param name="section_assetId">section_assetId</param> /// <param name="companyId">companyId</param> private void SavePreviousRAWork(int projectId, int section_assetId, int companyId) { // Load Previous work - Rehab assessment data (last sections work) string workType = "Rehab Assessment"; WorkRehabAssessmentGateway workRehabAssessmentGateway = new WorkRehabAssessmentGateway(); workRehabAssessmentGateway.LoadTop1ByProjectIdAssetIdWorkType(projectId, section_assetId, workType, companyId); int workId = workRehabAssessmentGateway.GetWorkIdTop1(); DateTime? preFlushDate = null; if (workRehabAssessmentGateway.GetPreFlushDateTop1().HasValue) preFlushDate = workRehabAssessmentGateway.GetPreFlushDateTop1(); DateTime? preVideoDate = null; if (workRehabAssessmentGateway.GetPreVideoDateTop1().HasValue) preVideoDate = workRehabAssessmentGateway.GetPreVideoDateTop1(); // Load Previous work - General work data WorkGateway workGateway = new WorkGateway(); workGateway.LoadByWorkId(workId, companyId); int? libraryCategoriesId = null; if (workGateway.GetLibraryCategoriesId(workId).HasValue) libraryCategoriesId = workGateway.GetLibraryCategoriesId(workId); string comments = workGateway.GetComments(workId); string history = workGateway.GetHistory(workId); // Save new work WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(null); int newSectionWorkId = workRehabAssessment.InsertDirect(projectId, section_assetId, libraryCategoriesId, preFlushDate, preVideoDate, false, companyId, comments, history); // Load Previous work - Comments and History SavePreviousComments(workId, workType, companyId, newSectionWorkId); SavePreviousHistory(workId, workType, companyId, newSectionWorkId); }
/// <summary> /// UpdateDirect /// </summary> /// <param name="originalWorkId">originalWorkId</param> /// <param name="originalPreFlushDate">originalPreFlushDate</param> /// <param name="originalPreVideoDate">originalPreVideoDate</param> /// <param name="originalDeleted">originalDeleted</param> /// <param name="originalCompanyId">originalCompanyId</param> /// <param name="newWorkId">newWorkId</param> /// <param name="newPreFlushDate">newPreFlushDate</param> /// <param name="newPreVideoDate">newPreVideoDate</param> /// <param name="newDeleted">newDeleted</param> /// <param name="newCompanyId">newCompanyId</param> public void UpdateDirect(int originalWorkId, DateTime? originalPreFlushDate, DateTime? originalPreVideoDate, bool originalDeleted, int originalCompanyId, int newWorkId, DateTime? newPreFlushDate, DateTime? newPreVideoDate, bool newDeleted, int newCompanyId) { WorkRehabAssessmentGateway workRehabAssessmentGateway = new WorkRehabAssessmentGateway(Data); workRehabAssessmentGateway.Update(originalWorkId, originalPreFlushDate, originalPreVideoDate, originalDeleted, originalCompanyId, newWorkId, newPreFlushDate, newPreVideoDate, newDeleted, newCompanyId); }