/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="assetId">assetId</param>
/// <param name="companyId">companyId</param>
public bool DeleteDirect(int assetId, int companyId)
{
if (!InUse(assetId, companyId))
{
// delete in LFS tables
LfsAssetSewerLateralGateway lfsAssetSewerLateralGateway = new LfsAssetSewerLateralGateway(null);
lfsAssetSewerLateralGateway.Delete(assetId, companyId);
LfsAssetSewer lfsAssetSewer = new LfsAssetSewer(null);
lfsAssetSewer.DeleteDirect(assetId, companyId);
LfsAsset lfsAsset = new LfsAsset(null);
lfsAsset.DeleteDirect(assetId, companyId);
// delete in AM tables
AssetSewerLateral assetSewerLateral = new AssetSewerLateral(null);
assetSewerLateral.DeleteDirect(assetId, companyId);
return true;
}
else
{
return false;
}
}
/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="assetId">assetId</param>
/// <param name="companyId">companyId</param>
public bool DeleteDirect(int assetId, int companyId)
{
// Delete laterals
// ... Define initial models
AssetSewerLateral assetSewerLateral = new AssetSewerLateral(null);
// ... Load laterals
AssetSewerLateralGateway assetSewerLateralGateway = new AssetSewerLateralGateway();
assetSewerLateralGateway.LoadBySectionId(assetId, companyId);
// ... Delete laterals
foreach (AssetsTDS.AM_ASSET_SEWER_LATERALRow rowLateral in (AssetsTDS.AM_ASSET_SEWER_LATERALDataTable)assetSewerLateralGateway.Table)
{
assetSewerLateral.DeleteDirect(rowLateral.AssetID, companyId);
}
// Delete section
AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway(null);
assetSewerSectionGateway.Delete(assetId, companyId);
AssetSewer assetSewer = new AssetSewer(null);
assetSewer.DeleteDirect(assetId, companyId);
Asset asset = new Asset(null);
asset.DeleteDirect(assetId, companyId);
return true;
}
/// <summary>
/// UpdateFieldsForSections
/// </summary>
/// <param name="companyId">companyId</param>
/// <param name="currentProjectId">currentProjectId</param>
private void UpdateFieldsForSections(int companyId, int currentProjectId)
{
AssetSewerSectionGateway assetSewerFindSectionGateway = new AssetSewerSectionGateway();
AssetSewerMHGateway assetSewerFindMHGateway = new AssetSewerMHGateway();
WorkGateway workGateway = new WorkGateway();
foreach (ProjectSectionsNavigatorTDS.LFS_PROJECT_SECTIONS_NAVIGATORRow row in (ProjectSectionsNavigatorTDS.LFS_PROJECT_SECTIONS_NAVIGATORDataTable)Table)
{
//General data for asset
assetSewerFindSectionGateway.LoadByAssetId(row.AssetID, companyId); //COMPANY_ID
// ... For usmh
row.USMHDescription = "";
if (!row.IsUSMHNull())
{
assetSewerFindMHGateway.LoadByAssetId(row.USMH, companyId);
row.USMHDescription = assetSewerFindMHGateway.GetMHID(row.USMH);
}
// ... For dsmh
row.DSMHDescription = "";
if (!row.IsDSMHNull())
{
assetSewerFindMHGateway.LoadByAssetId(row.DSMH, companyId);
row.DSMHDescription = assetSewerFindMHGateway.GetMHID(row.DSMH);
}
// ... For Works
row.RehabAssessment = workGateway.ExistsProjectIdAssetIdWorkTypeCompanyId(row.AssetID, currentProjectId, "Rehab Assessment", companyId);
row.FullLengthLining = workGateway.ExistsProjectIdAssetIdWorkTypeCompanyId(row.AssetID, currentProjectId, "Full Length Lining", companyId);
row.JunctionLining = workGateway.ExistsProjectIdAssetIdWorkTypeCompanyId(row.AssetID, currentProjectId, "Junction Lining Section", companyId);
row.WorksDescription = "";
if (row.RehabAssessment) row.WorksDescription = row.WorksDescription + "Rehab Assessment";
if (row.FullLengthLining)
{
if (row.WorksDescription.Trim().Length > 0)
{
row.WorksDescription = row.WorksDescription + ", Full Length Lining";
}
else
{
row.WorksDescription = row.WorksDescription + "Full Length Lining";
}
}
if (row.JunctionLining)
{
if (row.WorksDescription.Trim().Length > 0)
{
row.WorksDescription = row.WorksDescription + ", Junction Lining";
}
else
{
row.WorksDescription = row.WorksDescription + "Junction Lining";
}
}
// ... For Laterals
AssetSewerLateralGateway assetSewerLateralGateway = new AssetSewerLateralGateway();
assetSewerLateralGateway.LoadBySectionId(row.AssetID, companyId);
AssetSewerLateral assetSewerLateral = new AssetSewerLateral(assetSewerLateralGateway.Data);
row.LateralsDescription = assetSewerLateral.GetAllLaterals(row.AssetID, companyId);
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// InsertDirect
/// </summary>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="section_">section_</param>
/// <param name="address">address</param>
/// <param name="lateralId">lateralId</param>
/// <param name="latitudeAtSection">latitudeAtSection</param>
/// <param name="longitudeAtSection">longitudeAtSection</param>
/// <param name="latitudeAtPropertyLine">latitudeAtPropertyLine</param>
/// <param name="longitudeAtPropertyLine">longitudeAtPropertyLine</param>
/// <param name="state">state</param>
/// <param name="size_">size_</param>
/// <param name="distanceFromUSMH">distanceFromUSMH</param>
/// <param name="distanceFromDSMH">distanceFromDSMH</param>
/// <param name="mapSize">mapSize</param>
/// <param name="deleted">deleted</param>
/// <param name="companyId">companyId</param>
/// <param name="connectionType">connectionType</param>
/// <returns>lateral_assetId</returns>
public int InsertDirect(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int section_, string address, string lateralId, string latitudeAtSection, string longitudeAtSection, string latitudeAtPropertyLine, string longitudeAtPropertyLine, string state, string size_, string distanceFromUSMH, string distanceFromDSMH, string mapSize, bool deleted, int companyId, string connectionType)
{
// insert lateral in AM tables (only if not exists)
AssetSewerLateral assetSewerLateral = new AssetSewerLateral(null);
int lateral_assetId = assetSewerLateral.InsertDirect(countryId, provinceId, countyId, cityId, section_, address, lateralId, latitudeAtSection, longitudeAtSection, latitudeAtPropertyLine, longitudeAtPropertyLine, state, size_, distanceFromUSMH, distanceFromDSMH, mapSize, deleted, companyId, connectionType);
// verify if section exists in LFS tables for insertion
LfsAssetSewerLateralGateway lfsAssetSewerLateralGateway = new LfsAssetSewerLateralGateway();
lfsAssetSewerLateralGateway.LoadByAssetId(lateral_assetId, companyId);
if (lfsAssetSewerLateralGateway.Table.Rows.Count == 0)
{
new LfsAsset(new DataSet()).InsertDirect(lateral_assetId, deleted, companyId);
new LfsAssetSewer(new DataSet()).InsertDirect(lateral_assetId, deleted, companyId);
lfsAssetSewerLateralGateway.Insert(lateral_assetId, deleted, companyId);
}
return lateral_assetId;
}
/// <summary>
/// Update Lateral
/// </summary>
/// <param name="row">row</param>
/// <param name="projectId">projectId</param>
/// <param name="sectionAssetId">sectionAssetId</param>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="videoLength">videoLength</param>
/// <param name="companyId">companyId</param>
private void UpdateLateral(FullLengthLiningTDS.LateralDetailsRow row, int projectId, int sectionAssetId, Int64 countryId, Int64? provinceId, Int64? countyId, Int64? cityId, string videoLength, int companyId)
{
// not modified variables
FullLengthLiningTDS fullLengthLining = (FullLengthLiningTDS)Data;
FullLengthLiningLateralDetailsGateway fullLengthLiningLateralDetailsGateway = new FullLengthLiningLateralDetailsGateway(fullLengthLining);
int lateral = row.Lateral;
AssetSewerLateralGateway assetSewerLateralGateway = new AssetSewerLateralGateway();
assetSewerLateralGateway.LoadByAssetId(lateral, companyId);
int section_ = assetSewerLateralGateway.GetSection(lateral);
string address = assetSewerLateralGateway.GetAddress(lateral);
string lateralId = assetSewerLateralGateway.GetLateralId(lateral);
string latitudeAtSection = assetSewerLateralGateway.GetLatitudeAtSection(lateral);
string longitudeAtSection = assetSewerLateralGateway.GetLongitudeAtSection(lateral);
string latitudeAtPropertyLine = assetSewerLateralGateway.GetLatitudeAtPropertyLine(lateral);
string longitudeAtPropertyLine = assetSewerLateralGateway.GetLongitudeAtPropertyLine(lateral);
string mapSize = assetSewerLateralGateway.GetMapSize(lateral);
// original values
string originalState = fullLengthLiningLateralDetailsGateway.GetLiveOriginal(lateral);
string originalSize = fullLengthLiningLateralDetailsGateway.GetSizeOriginal(lateral);
string originalDistanceFromUsmh = fullLengthLiningLateralDetailsGateway.GetDistanceFromUSMHOriginal(lateral);
string originalDistanceFromDsmh = fullLengthLiningLateralDetailsGateway.GetDistanceFromDSMHOriginal(lateral);
string originalConnectionType = fullLengthLiningLateralDetailsGateway.GetConnectionTypeOriginal(lateral);
string originalAddress = fullLengthLiningLateralDetailsGateway.GetMnOriginal(lateral);
// new values
string newState = fullLengthLiningLateralDetailsGateway.GetLive(lateral);
string newSize = fullLengthLiningLateralDetailsGateway.GetSize(lateral);
string newDistanceFromUsmh = fullLengthLiningLateralDetailsGateway.GetDistanceFromUSMH(lateral);
string newDistanceFromDsmh = fullLengthLiningLateralDetailsGateway.GetDistanceFromDSMH(lateral);
string newConnectionType = fullLengthLiningLateralDetailsGateway.GetConnectionType(lateral);
string newAddress = fullLengthLiningLateralDetailsGateway.GetMn(lateral);
// update asset laterals
AssetSewerLateral assetSewerLateral = new AssetSewerLateral(null);
assetSewerLateral.UpdateDirect(lateral, section_, originalAddress, lateralId, latitudeAtSection, longitudeAtSection, latitudeAtPropertyLine, longitudeAtPropertyLine, originalState, originalSize, originalDistanceFromUsmh, originalDistanceFromDsmh, mapSize, false, companyId, originalConnectionType, lateral, section_, newAddress, lateralId, latitudeAtSection, longitudeAtSection, latitudeAtPropertyLine, longitudeAtPropertyLine, newState, newSize, newDistanceFromUsmh, newDistanceFromDsmh, mapSize, false, companyId, newConnectionType);
}
/// <summary>
/// LateralUpdate
/// </summary>
/// <param name="currentProjectId">currentProjectId</param>
/// <param name="assetId">assetId</param>
/// <param name="distanceFromDsmh">distanceFromDsmh</param>
/// <param name="distanceFromUsmh">distanceFromUsmh</param>
/// <param name="mapSize">mapSize</param>
/// <param name="companyId">companyId</param>
/// <param name="clientLateralId">clientLateralId</param>
/// <param name="address">address</param>
/// <param name="connectionType">connectionType</param>
private void LateralUpdate(int currentProjectId, int assetId, string distanceFromDsmh, string distanceFromUsmh, string mapSize, int companyId, string clientLateralId, string address, string connectionType)
{
AssetSewerLateralGateway assetSewerLateralGateway = new AssetSewerLateralGateway();
assetSewerLateralGateway.LoadByAssetId(assetId, companyId);
// original values
int originalSection_ = assetSewerLateralGateway.GetSection(assetId);
string originalAddress = assetSewerLateralGateway.GetAddress(assetId);
string originalLateralId = assetSewerLateralGateway.GetLateralId(assetId);
string originalLatitudeAtSection = assetSewerLateralGateway.GetLatitudeAtSection(assetId);
string originalLongitudeAtSection = assetSewerLateralGateway.GetLongitudeAtSection(assetId);
string originalLatitudeAtPropertyLine = assetSewerLateralGateway.GetLatitudeAtPropertyLine(assetId);
string originalLongitudeAtPropertyLine = assetSewerLateralGateway.GetLongitudeAtPropertyLine(assetId);
string originalState = assetSewerLateralGateway.GetState(assetId);
string originalSize_ = assetSewerLateralGateway.GetSize(assetId);
string originalDistanceFromUsmh = assetSewerLateralGateway.GetDistanceFromUSMH(assetId);
string originalDistanceFromDsmh = assetSewerLateralGateway.GetDistanceFromDSMH(assetId);
string originalMapSize = assetSewerLateralGateway.GetMapSize(assetId);
bool originalDelete = assetSewerLateralGateway.GetDeleted(assetId);
int originalCompanyId = assetSewerLateralGateway.GetCompanyId(assetId);
string originalConnectionType = assetSewerLateralGateway.GetConnectionType(assetId);
// new values
string newAddress = address;
string newDistanceFromUsmh = originalDistanceFromUsmh;
string newDistanceFromDsmh = originalDistanceFromDsmh;
string newMapSize = mapSize;
string newConnectionType = connectionType;
// Update Sewer lateral
AssetSewerLateral assetSewerLateral = new AssetSewerLateral(null);
assetSewerLateral.UpdateDirect(assetId, originalSection_, originalAddress, originalLateralId, originalLatitudeAtSection, originalLongitudeAtSection, originalLatitudeAtPropertyLine, originalLongitudeAtPropertyLine, originalState, originalSize_, originalDistanceFromUsmh, originalDistanceFromDsmh, originalMapSize, originalDelete, originalCompanyId, originalConnectionType, assetId, originalSection_, newAddress, originalLateralId, originalLatitudeAtSection, originalLongitudeAtSection, originalLatitudeAtPropertyLine, originalLongitudeAtPropertyLine, originalState, originalSize_, newDistanceFromUsmh, newDistanceFromDsmh, newMapSize, originalDelete, originalCompanyId, newConnectionType);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
int clientId = projectGateway.GetClientID(currentProjectId);
LfsAssetSewerLateralClientGateway lfsAssetSewerLateralClientGateway = new LfsAssetSewerLateralClientGateway();
lfsAssetSewerLateralClientGateway.LoadAllByAssetIdClientId(assetId, clientId, companyId);
if (lfsAssetSewerLateralClientGateway.Table.Rows.Count == 0)
{
LfsAssetSewerLateralClient lfsAssetSewerLateralClient = new LfsAssetSewerLateralClient(null);
lfsAssetSewerLateralClient.InsertDirect(assetId, clientId, clientLateralId, false, companyId);
}
else
{
LfsAssetSewerLateralClient lfsAssetSewerLateralClient = new LfsAssetSewerLateralClient(null);
string originalClientLateralId = lfsAssetSewerLateralClientGateway.GetClientLateralId(assetId, clientId);
string newClientLateralId = clientLateralId;
lfsAssetSewerLateralClient.UpdateDirect(assetId, clientId, originalClientLateralId, false, companyId, assetId, clientId, newClientLateralId, false, companyId);
}
}
