//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);
}