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