/// <summary>
/// UpdateDirect
/// </summary>
/// <param name="originalAssetId">originalAssetId</param>
/// <param name="originalSectionId">originalSectionId</param>
/// <param name="originalStreet">originalStreet</param>
/// <param name="originalUsmh">originalUsmh</param>
/// <param name="originalDsmh">originalDsmh</param>
/// <param name="originalMapSize">originalMapSize</param>
/// <param name="originalSize">originalSize</param>
/// <param name="originalMapLength">originalMapLength</param>
/// <param name="originalLength">originalLength</param>
/// <param name="originalLaterals">originalLaterals</param>
/// <param name="originalLiveLaterals">originalLiveLaterals</param>
/// <param name="originalFlowDirection">originalFlowDirection</param>
/// <param name="originalUsmhDepth">originalUsmhDepth</param>
/// <param name="originalDsmhDepth">originalDsmhDepth</param>
/// <param name="originalSteelTapeThroughSewer">originalSteelTapeThroughSewer</param>
/// <param name="originalUsmhMouth12">originalUsmhMouth12</param>
/// <param name="originalUsmhMouth1">originalUsmhMouth1</param>
/// <param name="originalUsmhMouth2">originalUsmhMouth2</param>
/// <param name="originalUsmhMouth3">originalUsmhMouth3</param>
/// <param name="originalUsmhMouth4">originalUsmhMouth4</param>
/// <param name="originalUsmhMouth5">originalUsmhMouth5</param>
/// <param name="originalDsmhMouth12">originalDsmhMouth12</param>
/// <param name="originalDsmhMouth1">originalDsmhMouth1</param>
/// <param name="originalDsmhMouth2">originalDsmhMouth2</param>
/// <param name="originalDsmhMouth3">originalDsmhMouth3</param>
/// <param name="originalDsmhMouth4">originalDsmhMouth4</param>
/// <param name="originalDsmhMouth5">originalDsmhMouth5</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="originalCompanyId">originalCompanyId</param>
/// <param name="originalSubArea">originalSubArea</param>
/// <param name="originalThickness">originalThickness</param>
///
/// <param name="newAssetId">newAssetId</param>
/// <param name="newSectionId">newSectionId</param>
/// <param name="newStreet">newStreet</param>
/// <param name="newUsmh">newUsmh</param>
/// <param name="newDsmh">newDsmh</param>
/// <param name="newMapSize">newMapSize</param>
/// <param name="newSize">newSize</param>
/// <param name="newMapLength">newMapLength</param>
/// <param name="newLength">newLength</param>
/// <param name="newLaterals">newLaterals</param>
/// <param name="newLiveLaterals">newLiveLaterals</param>
/// <param name="newFlowDirection">newFlowDirection</param>
/// <param name="newUsmhDepth">newUsmhDepth</param>
/// <param name="newDsmhDepth">newDsmhDepth</param>
/// <param name="newSteelTapeThroughSewer">newSteelTapeThroughSewer</param>
/// <param name="newUsmhMouth12">newUsmhMouth12</param>
/// <param name="newUsmhMouth1">newUsmhMouth1</param>
/// <param name="newUsmhMouth2">newUsmhMouth2</param>
/// <param name="newUsmhMouth3">newUsmhMouth3</param>
/// <param name="newUsmhMouth4">newUsmhMouth4</param>
/// <param name="newUsmhMouth5">newUsmhMouth5</param>
/// <param name="newDsmhMouth12">newDsmhMouth12</param>
/// <param name="newDsmhMouth1">newDsmhMouth1</param>
/// <param name="newDsmhMouth2">newDsmhMouth2</param>
/// <param name="newDsmhMouth3">newDsmhMouth3</param>
/// <param name="newDsmhMouth4">newDsmhMouth4</param>
/// <param name="newDsmhMouth5">newDsmhMouth5</param>
/// <param name="newDeleted">newDeleted</param>
/// <param name="newCompanyId">newCompanyId</param>
/// <param name="newSubArea">newSubArea</param>
/// <param name="newThickness">newThickness</param>
public void UpdateDirect(int originalAssetId, string originalSectionId, string originalStreet, int? originalUsmh, int? originalDsmh, string originalMapSize, string originalSize, string originalMapLength, string originalLength, int? originalLaterals, int? originalLiveLaterals, string originalFlowDirection, string originalUsmhDepth, string originalDsmhDepth, string originalSteelTapeThroughSewer, string originalUsmhMouth12, string originalUsmhMouth1, string originalUsmhMouth2, string originalUsmhMouth3, string originalUsmhMouth4, string originalUsmhMouth5, string originalDsmhMouth12, string originalDsmhMouth1, string originalDsmhMouth2, string originalDsmhMouth3, string originalDsmhMouth4, string originalDsmhMouth5, bool originalDeleted, int originalCompanyId, string originalSubArea, string originalThickness, int newAssetId, string newSectionId, string newStreet, int? newUsmh, int? newDsmh, string newMapSize, string newSize, string newMapLength, string newLength, int? newLaterals, int? newLiveLaterals, string newFlowDirection, string newUsmhDepth, string newDsmhDepth, string newSteelTapeThroughSewer, string newUsmhMouth12, string newUsmhMouth1, string newUsmhMouth2, string newUsmhMouth3, string newUsmhMouth4, string newUsmhMouth5, string newDsmhMouth12, string newDsmhMouth1, string newDsmhMouth2, string newDsmhMouth3, string newDsmhMouth4, string newDsmhMouth5, bool newDeleted, int newCompanyId, string newSubArea, string newThickness)
{
// update AM Section
AssetSewerSection assetSewerSection = new AssetSewerSection(null);
string originalFlowOrderId = "";
string newFlowOrderId = "";
// Verify sectionId
string[] secuentialPart = originalSectionId.Split('-');
if (secuentialPart[1].Contains("."))
{
// ... Flow order for intermediate section Id
originalFlowOrderId = secuentialPart[1];
newFlowOrderId = secuentialPart[1];
}
else
{
// ... Flow Order of section Id
originalFlowOrderId = originalSectionId.Substring(originalSectionId.Length - 6, 6);
newFlowOrderId = newSectionId.Substring(newSectionId.Length - 6, 6);
}
assetSewerSection.UpdateDirect(originalAssetId, originalSectionId, originalStreet, originalUsmh, originalDsmh, originalMapSize, originalSize, originalMapLength, originalLength, originalLaterals, originalLiveLaterals, originalFlowDirection, originalUsmhDepth, originalDsmhDepth, originalDeleted, originalCompanyId, originalFlowOrderId, newAssetId, newSectionId, newStreet, newUsmh, newDsmh, newMapSize, newSize, newMapLength, newLength, newLaterals, newLiveLaterals, newFlowDirection, newUsmhDepth, newDsmhDepth, newDeleted, newCompanyId, newFlowOrderId);
// update LFS section
if (originalLength != newLength)
{
newSteelTapeThroughSewer = newLength;
}
LfsAssetSewerSectionGateway lfsAssetSewerSectionGateway = new LfsAssetSewerSectionGateway(null);
lfsAssetSewerSectionGateway.Update(originalAssetId, originalSteelTapeThroughSewer, originalUsmhMouth12, originalUsmhMouth1, originalUsmhMouth2, originalUsmhMouth3, originalUsmhMouth4, originalUsmhMouth5, originalDsmhMouth12, originalDsmhMouth1, originalDsmhMouth2, originalDsmhMouth3, originalDsmhMouth4, originalDsmhMouth5, originalDeleted, originalCompanyId, originalSubArea, originalThickness, newAssetId, newSteelTapeThroughSewer, newUsmhMouth12, newUsmhMouth1, newUsmhMouth2, newUsmhMouth3, newUsmhMouth4, newUsmhMouth5, newDsmhMouth12, newDsmhMouth1, newDsmhMouth2, newDsmhMouth3, newDsmhMouth4, newDsmhMouth5, newDeleted, newCompanyId, newSubArea, newThickness);
// delete original usmh (if not in use)
if ((newUsmh != originalUsmh) && (originalUsmh.HasValue))
{
LfsAssetSewerMH lfsAssetSewerUsmh = new LfsAssetSewerMH(null);
lfsAssetSewerUsmh.DeleteDirect((int)originalUsmh, originalCompanyId);
}
// delete original dsmh (if not in use)
if ((newDsmh != originalDsmh) && (originalDsmh.HasValue))
{
LfsAssetSewerMH lfsAssetSewerDsmh = new LfsAssetSewerMH(null);
lfsAssetSewerDsmh.DeleteDirect((int)originalDsmh, originalCompanyId);
}
}
/// <summary>
/// UpdateDirect
/// </summary>
/// <param name="originalAssetId">originalAssetId</param>
/// <param name="originalSection_">originalSection_</param>
/// <param name="originalAddress">originalAddress</param>
/// <param name="originalLateralId">originalLateralId</param>
/// <param name="originalLatitudeAtSection">originalLatitudeAtSection</param>
/// <param name="originalLongitudeAtSection">originalLongitudeAtSection</param>
/// <param name="originalLatitudeAtPropertyLine">originalLatitudeAtPropertyLine</param>
/// <param name="originalLongitudeAtPropertyLine">originalLongitudeAtPropertyLine</param>
/// <param name="originalState">originalState</param>
/// <param name="orignalSize">orignalSize</param>
/// <param name="originalDistanceFromUsmh">originalDistanceFromUsmh</param>
/// <param name="originalDistanceFromDsmh">originalDistanceFromDsmh</param>
/// <param name="originalMapSize">originalMapSize</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="originalCompanyId">originalCompanyId</param>
/// <param name="originalConnectionType">originalConnectionType</param>
///
/// <param name="newAssetId">newAssetId</param>
/// <param name="newSection_">newSection_</param>
/// <param name="newAddress">newAddress</param>
/// <param name="newLateralId">newLateralId</param>
/// <param name="newLatitudeAtSection">newLatitudeAtSection</param>
/// <param name="newLongitudeAtSection">newLongitudeAtSection</param>
/// <param name="newLatitudeAtPropertyLine">newLatitudeAtPropertyLine</param>
/// <param name="newLongitudeAtPropertyLine">newLongitudeAtPropertyLine</param>
/// <param name="newState">newState</param>
/// <param name="newSize">newSize</param>
/// <param name="newDistanceFromUsmh">newDistanceFromUsmh</param>
/// <param name="newDistanceFromDsmh">newDistanceFromDsmh</param>
/// <param name="newMapSize">newMapSize</param>
/// <param name="newDeleted">newDeleted</param>
/// <param name="newCompanyId">newCompanyId</param>
/// <param name="newConnectionType">newConnectionType</param>
public void UpdateDirect(int originalAssetId, int originalSection_, string originalAddress, string originalLateralId, string originalLatitudeAtSection, string originalLongitudeAtSection, string originalLatitudeAtPropertyLine, string originalLongitudeAtPropertyLine, string originalState, string orignalSize, string originalDistanceFromUsmh, string originalDistanceFromDsmh, string originalMapSize, bool originalDeleted, int originalCompanyId, string originalConnectionType, int newAssetId, int newSection_, string newAddress, string newLateralId, string newLatitudeAtSection, string newLongitudeAtSection, string newLatitudeAtPropertyLine, string newLongitudeAtPropertyLine, string newState, string newSize, string newDistanceFromUsmh, string newDistanceFromDsmh, string newMapSize, bool newDeleted, int newCompanyId, string newConnectionType)
{
AssetSewerLateralGateway assetSewerLateralGateway = new AssetSewerLateralGateway();
assetSewerLateralGateway.Update(originalAssetId, originalSection_, originalAddress, originalLateralId, originalLatitudeAtSection, originalLongitudeAtSection, originalLatitudeAtPropertyLine, originalLongitudeAtPropertyLine, originalState, orignalSize, originalDistanceFromUsmh, originalDistanceFromDsmh, originalMapSize, originalDeleted, originalCompanyId, originalConnectionType, newAssetId, newSection_, newAddress, newLateralId, newLatitudeAtSection, newLongitudeAtSection, newLatitudeAtPropertyLine, newLongitudeAtPropertyLine, newState, newSize, newDistanceFromUsmh, newDistanceFromDsmh, newMapSize, newDeleted, newCompanyId, newConnectionType);
// Update section
if ((originalState != newState) && ((newState == "Live") || (originalState == "Live")))
{
// ... Load section
AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway();
assetSewerSectionGateway.LoadByAssetId(originalSection_, originalCompanyId);
// ... Get old values of section
string sectionIdS = assetSewerSectionGateway.GetSectionId(originalSection_);
string streetS = assetSewerSectionGateway.GetStreet(originalSection_);
int? usmhIdS = assetSewerSectionGateway.GetUSMH(originalSection_);
int? dsmhIdS = assetSewerSectionGateway.GetDSMH(originalSection_);
string mapSizeS = assetSewerSectionGateway.GetMapSize(originalSection_);
string size_S = assetSewerSectionGateway.GetSize_(originalSection_);
string mapLengthS = assetSewerSectionGateway.GetMapSize(originalSection_);
string lengthS = assetSewerSectionGateway.GetLength(originalSection_);
int? lateralsS = assetSewerSectionGateway.GetLaterals(originalSection_);
int? liveLateralsS = assetSewerSectionGateway.GetLiveLaterals(originalSection_);
string flowDirectionS = assetSewerSectionGateway.GetFlowDirection(originalSection_);
string usmhDepthS = assetSewerSectionGateway.GetUSMHDepth(originalSection_);
string dsmhDepthS = assetSewerSectionGateway.GetDSMHDepth(originalSection_);
bool deletedS = assetSewerSectionGateway.GetDeleted(originalSection_);
string flowOrderIdS = assetSewerSectionGateway.GetFlowOrderID(originalSection_);
// ... Calculate new values of section
int? newLiveLaterals = liveLateralsS;
if (originalState == "Live")
{
newLiveLaterals = newLiveLaterals - 1;
}
if (newState == "Live")
{
newLiveLaterals = newLiveLaterals + 1;
}
// ... Update section
AssetSewerSection assetSewerSection = new AssetSewerSection(assetSewerSectionGateway.Data);
assetSewerSection.UpdateDirect(originalSection_, sectionIdS, streetS, usmhIdS, dsmhIdS, mapSizeS, size_S, mapLengthS, lengthS, lateralsS, liveLateralsS, flowDirectionS, usmhDepthS, dsmhDepthS, deletedS, originalCompanyId, flowOrderIdS, originalSection_, sectionIdS, streetS, usmhIdS, dsmhIdS, mapSizeS, size_S, mapLengthS, lengthS, lateralsS, newLiveLaterals, flowDirectionS, usmhDepthS, dsmhDepthS, deletedS, originalCompanyId, flowOrderIdS);
}
}
/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="assetId">assetId</param>
/// <param name="companyId">companyId</param>
public bool DeleteDirect(int assetId, int companyId)
{
// Get initial data
AssetSewerLateralGateway assetSewerLateralGateway = new AssetSewerLateralGateway();
assetSewerLateralGateway.LoadByAssetId(assetId, companyId);
int section_ = assetSewerLateralGateway.GetSection(assetId);
string state = assetSewerLateralGateway.GetState(assetId);
// Delete lateral
assetSewerLateralGateway.Delete(assetId, companyId);
AssetSewer assetSewer = new AssetSewer(null);
assetSewer.DeleteDirect(assetId, companyId);
Asset asset = new Asset(null);
asset.DeleteDirect(assetId, companyId);
// Update Section
// ... Load section
AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway();
assetSewerSectionGateway.LoadByAssetId(section_, companyId);
// ... Get old values of section
string sectionIdS = assetSewerSectionGateway.GetSectionId(section_);
string streetS = assetSewerSectionGateway.GetStreet(section_);
int? usmhIdS = assetSewerSectionGateway.GetUSMH(section_);
int? dsmhIdS = assetSewerSectionGateway.GetDSMH(section_);
string mapSizeS = assetSewerSectionGateway.GetMapSize(section_);
string size_S = assetSewerSectionGateway.GetSize_(section_);
string mapLengthS = assetSewerSectionGateway.GetMapSize(section_);
string lengthS = assetSewerSectionGateway.GetLength(section_);
int? lateralsS = assetSewerSectionGateway.GetLaterals(section_);
int? liveLateralsS = assetSewerSectionGateway.GetLiveLaterals(section_);
string flowDirectionS = assetSewerSectionGateway.GetFlowDirection(section_);
string usmhDepthS = assetSewerSectionGateway.GetUSMHDepth(section_);
string dsmhDepthS = assetSewerSectionGateway.GetDSMHDepth(section_);
bool deletedS = assetSewerSectionGateway.GetDeleted(section_);
string flowOrderIdS = assetSewerSectionGateway.GetFlowOrderID(section_);
// ... Calculate new values of section
int? newLaterals = lateralsS - 1;
int? newLiveLaterals = liveLateralsS;
if ((newLiveLaterals.HasValue) && (state == "Live"))
{
newLiveLaterals = newLiveLaterals - 1;
}
// ... Update section
AssetSewerSection assetSewerSection = new AssetSewerSection(assetSewerSectionGateway.Data);
assetSewerSection.UpdateDirect(section_, sectionIdS, streetS, usmhIdS, dsmhIdS, mapSizeS, size_S, mapLengthS, lengthS, lateralsS, liveLateralsS, flowDirectionS, usmhDepthS, dsmhDepthS, deletedS, companyId, flowOrderIdS, section_, sectionIdS, streetS, usmhIdS, dsmhIdS, mapSizeS, size_S, mapLengthS, lengthS, newLaterals, newLiveLaterals, flowDirectionS, usmhDepthS, dsmhDepthS, deletedS, companyId, flowOrderIdS);
return true;
}
// ////////////////////////////////////////////////////////////////////////
// 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></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)
{
AssetSewerLateralGateway assetSewerLateralGateway = new AssetSewerLateralGateway();
assetSewerLateralGateway.LoadBySectionLateralId(section_, lateralID, companyId);
int lateral_assetId = 0;
if (assetSewerLateralGateway.Table.Rows.Count == 0)
{
// Insert Asset
lateral_assetId = new Asset(new DataSet()).InsertDirect("Sewer", countryId, provinceId, countyId, cityId, deleted, companyId);
new AssetSewer(new DataSet()).InsertDirect(lateral_assetId, "Lateral", deleted, companyId);
assetSewerLateralGateway.Insert(lateral_assetId, section_, address, lateralID, latitudeAtSection, longitudeAtSection, latitudeAtPropertyLine, longitudeAtPropertyLine, state, size_, distanceFromUSMH, distanceFromDSMH, mapSize, deleted, companyId, connectionType);
// Update Section
// ... load section
AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway();
assetSewerSectionGateway.LoadByAssetId(section_, companyId);
// ... get old values of section
string sectionIdS = assetSewerSectionGateway.GetSectionId(section_);
string streetS = assetSewerSectionGateway.GetStreet(section_);
int? usmhIdS = assetSewerSectionGateway.GetUSMH(section_);
int? dsmhIdS = assetSewerSectionGateway.GetDSMH(section_);
string mapSizeS = assetSewerSectionGateway.GetMapSize(section_);
string size_S = assetSewerSectionGateway.GetSize_(section_);
string mapLengthS = assetSewerSectionGateway.GetMapSize(section_);
string lengthS = assetSewerSectionGateway.GetLength(section_);
int? lateralsS = assetSewerSectionGateway.GetLaterals(section_);
int? liveLateralsS = assetSewerSectionGateway.GetLiveLaterals(section_);
string flowDirectionS = assetSewerSectionGateway.GetFlowDirection(section_);
string usmhDepthS = assetSewerSectionGateway.GetUSMHDepth(section_);
string dsmhDepthS = assetSewerSectionGateway.GetDSMHDepth(section_);
string flowOrderIdS = assetSewerSectionGateway.GetFlowOrderID(section_);
// ... calculate new values of section
int? newLaterals = lateralsS;
if (newLaterals.HasValue)
{
newLaterals = newLaterals + 1;
}
else
{
newLaterals = 1;
}
int? newLiveLaterals = liveLateralsS;
if (state == "Live")
{
if (newLiveLaterals.HasValue)
{
newLiveLaterals = newLiveLaterals + 1;
}
else
{
newLiveLaterals = 1;
}
}
else
{
newLiveLaterals = 0;
}
// ... update section
AssetSewerSection assetSewerSection = new AssetSewerSection(assetSewerSectionGateway.Data);
assetSewerSection.UpdateDirect(section_, sectionIdS, streetS, usmhIdS, dsmhIdS, mapSizeS, size_S, mapLengthS, lengthS, lateralsS, liveLateralsS, flowDirectionS, usmhDepthS, dsmhDepthS, deleted, companyId, flowOrderIdS, section_, sectionIdS, streetS, usmhIdS, dsmhIdS, mapSizeS, size_S, mapLengthS, lengthS, newLaterals, newLiveLaterals, flowDirectionS, usmhDepthS, dsmhDepthS, deleted, companyId, flowOrderIdS);
}
else
{
lateral_assetId = assetSewerLateralGateway.GetAssetID(section_, lateralID);
}
return lateral_assetId;
}
