/// <summary>
///Save
/// </summary>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="projectId">projectId</param>
/// <param name="companyId">companyId</param>
public void Save(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int projectId, int companyId)
{
//Update Section
ManholeRehabilitationTDS manholeChanges = (ManholeRehabilitationTDS)Data.GetChanges();
if (manholeChanges.ManholeDetails.Rows.Count > 0)
{
ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway = new ManholeRehabilitationManholeDetailsGateway(manholeChanges);
// Update sections
foreach (ManholeRehabilitationTDS.ManholeDetailsRow manholeDetailsRow in (ManholeRehabilitationTDS.ManholeDetailsDataTable)manholeChanges.ManholeDetails)
{
// Unchanged values
int assetId = manholeDetailsRow.AssetID;
string mhId = manholeDetailsRow.MHID;
// Original values
string originalLatitud = manholeRehabilitationManholeDetailsGateway.GetLatitudOriginal(assetId);
string originalLongitude = manholeRehabilitationManholeDetailsGateway.GetLongitudeOriginal(assetId);
string originalAddress = manholeRehabilitationManholeDetailsGateway.GetAddressOriginal(assetId);
string originalManholeShape = manholeRehabilitationManholeDetailsGateway.GetManholeShapeOriginal(assetId);
string originalLocation = manholeRehabilitationManholeDetailsGateway.GetLocationOriginal(assetId);
int? originalMaterialID = manholeRehabilitationManholeDetailsGateway.GetMaterialIDOriginal(assetId);
string originalTopDiameter = manholeRehabilitationManholeDetailsGateway.GetTopDiameterOriginal(assetId);
string originalTopDepth = manholeRehabilitationManholeDetailsGateway.GetTopDepthOriginal(assetId);
string originalTopFloor = manholeRehabilitationManholeDetailsGateway.GetTopFloorOriginal(assetId);
string originalTopCeiling = manholeRehabilitationManholeDetailsGateway.GetTopCeilingOriginal(assetId);
string originalTopBenching = manholeRehabilitationManholeDetailsGateway.GetTopBenchingOriginal(assetId);
string originalDownDiameter = manholeRehabilitationManholeDetailsGateway.GetDownDiameterOriginal(assetId);
string originalDownDepth = manholeRehabilitationManholeDetailsGateway.GetDownDepthOriginal(assetId);
string originalDownFloor = manholeRehabilitationManholeDetailsGateway.GetDownFloorOriginal(assetId);
string originalDownCeiling = manholeRehabilitationManholeDetailsGateway.GetDownCeilingOriginal(assetId);
string originalDownBenching = manholeRehabilitationManholeDetailsGateway.GetDownBenchingOriginal(assetId);
string originalRectangle1LongSide = manholeRehabilitationManholeDetailsGateway.GetRectangle1LongSideOriginal(assetId);
string originalRectangle1ShortSide = manholeRehabilitationManholeDetailsGateway.GetRectangle1ShortSideOriginal(assetId);
string originalRectangle2LongSide = manholeRehabilitationManholeDetailsGateway.GetRectangle2LongSideOriginal(assetId);
string originalRectangle2ShortSide = manholeRehabilitationManholeDetailsGateway.GetRectangle2ShortSideOriginal(assetId);
string originalTopSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetTopSurfaceAreaOriginal(assetId);
string originalDownSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetDownSurfaceAreaOriginal(assetId);
int? originalManholeRugs = manholeRehabilitationManholeDetailsGateway.GetManholeRugsOriginal(assetId);
string originalTotalDepth = manholeRehabilitationManholeDetailsGateway.GetTotalDepthOriginal(assetId);
string originalTotalSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceAreaOriginal(assetId);
int? originalConditionRating = manholeRehabilitationManholeDetailsGateway.GetConditionRatingOriginal(assetId);
// New variables
string newLatitud = manholeRehabilitationManholeDetailsGateway.GetLatitud(assetId);
string newLongitude = manholeRehabilitationManholeDetailsGateway.GetLongitude(assetId);
string newAddress = manholeRehabilitationManholeDetailsGateway.GetAddress(assetId);
string newManholeShape = manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId);
string newLocation = manholeRehabilitationManholeDetailsGateway.GetLocation(assetId);
int? newMaterialID = manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId);
string newTopDiameter = manholeRehabilitationManholeDetailsGateway.GetTopDiameter(assetId);
string newTopDepth = manholeRehabilitationManholeDetailsGateway.GetTopDepth(assetId);
string newTopFloor = manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId);
string newTopCeiling = manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId);
string newTopBenching = manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId);
string newDownDiameter = manholeRehabilitationManholeDetailsGateway.GetDownDiameter(assetId);
string newDownDepth = manholeRehabilitationManholeDetailsGateway.GetDownDepth(assetId);
string newDownFloor = manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId);
string newDownCeiling = manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId);
string newDownBenching = manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId);
string newRectangle1LongSide = manholeRehabilitationManholeDetailsGateway.GetRectangle1LongSide(assetId);
string newRectangle1ShortSide = manholeRehabilitationManholeDetailsGateway.GetRectangle1ShortSide(assetId);
string newRectangle2LongSide = manholeRehabilitationManholeDetailsGateway.GetRectangle2LongSide(assetId);
string newRectangle2ShortSide = manholeRehabilitationManholeDetailsGateway.GetRectangle2ShortSide(assetId);
string newTopSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetTopSurfaceArea(assetId);
string newDownSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetDownSurfaceArea(assetId);
int? newManholeRugs = manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId);
string newTotalDepth = manholeRehabilitationManholeDetailsGateway.GetTotalDepth(assetId);
string newTotalSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId);
int? newConditionRating = manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId);
// Update
AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway();
assetSewerMHGateway.LoadByAssetId(assetId, companyId);
if (assetSewerMHGateway.Table.Rows.Count > 0)
{
// ... update asset manhole
AssetSewerMH assetSewerMH = new AssetSewerMH(assetSewerMHGateway.Data);
assetSewerMH.UpdateDirect(assetId, mhId, originalLatitud, originalLongitude, originalAddress, originalManholeShape, originalLocation, originalMaterialID, originalTopDiameter, originalTopDepth, originalTopFloor, originalTopCeiling, originalTopBenching, originalDownDiameter, originalDownDepth, originalDownFloor, originalDownCeiling, originalDownBenching, originalRectangle1LongSide, originalRectangle1ShortSide, originalRectangle2LongSide, originalRectangle2ShortSide, originalTopSurfaceArea, originalDownSurfaceArea, originalManholeRugs, originalTotalDepth, originalTotalSurfaceArea, false, companyId, assetId, mhId, newLatitud, newLongitude, newAddress, newManholeShape, newLocation, newMaterialID, newTopDiameter, newTopDepth, newTopFloor, newTopCeiling, newTopBenching, newDownDiameter, newDownDepth, newDownFloor, newDownCeiling, newDownBenching, newRectangle1LongSide, newRectangle1ShortSide, newRectangle2LongSide, newRectangle2ShortSide, newTopSurfaceArea, newDownSurfaceArea, newManholeRugs, newTotalDepth, newTotalSurfaceArea, false, companyId);
// ... update lfs manhole
LfsAssetSewerMH lfsAssetSewerMH = new LfsAssetSewerMH(null);
lfsAssetSewerMH.UpdateDirect(assetId, false, companyId, originalConditionRating, false, companyId, newConditionRating);
}
}
}
}
private void LoadManholeData(int assetId)
{
ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway = new ManholeRehabilitationManholeDetailsGateway(manholeRehabilitationTDS);
if (manholeRehabilitationManholeDetailsGateway.Table.Rows.Count > 0)
{
// Load Manhole Details for header
tbxManholeNumber.Text = manholeRehabilitationManholeDetailsGateway.GetMHID(assetId);
tbxStreet.Text = manholeRehabilitationManholeDetailsGateway.GetAddress(assetId);
tbxLongitude.Text = manholeRehabilitationManholeDetailsGateway.GetLongitude(assetId);
tbxLatitude.Text = manholeRehabilitationManholeDetailsGateway.GetLatitud(assetId);
if (manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId) == "")
{
ddlShape.SelectedValue = "";
hdfSavedShape.Value = "";
}
else
{
ddlShape.SelectedValue = manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId);
hdfSavedShape.Value = manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId);
}
if (manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId).HasValue)
{
int? materialId = manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId);
int materialsId = (int)materialId;
ddlMaterial.SelectedValue = materialsId.ToString();
}
else
{
ddlMaterial.SelectedIndex = 0;
}
if (manholeRehabilitationManholeDetailsGateway.GetLocation(assetId) == "")
{
ddlLocation.SelectedValue = "";
}
else
{
ddlLocation.SelectedValue = manholeRehabilitationManholeDetailsGateway.GetLocation(assetId);
}
if (manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId).HasValue)
{
ddlConditioningRating.SelectedValue = manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId).ToString();
}
else
{
ddlConditioningRating.SelectedValue = "-1";
}
}
}
private void LoadManholeGeneralDetailDate(int assetId, ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway)
{
// Load Manhole Details for header
tbxManholeNumber.Text = manholeRehabilitationManholeDetailsGateway.GetMHID(assetId);
tbxStreet.Text = manholeRehabilitationManholeDetailsGateway.GetAddress(assetId);
tbxLongitude.Text = manholeRehabilitationManholeDetailsGateway.GetLongitude(assetId);
tbxLatitude.Text = manholeRehabilitationManholeDetailsGateway.GetLatitud(assetId);
tbxShape.Text = manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId);
if (manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId).HasValue)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int? materialId = manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId);
AssetSewerMHMaterialTypeGateway assetSewerMHMaterialTypeGateway = new AssetSewerMHMaterialTypeGateway();
assetSewerMHMaterialTypeGateway.LoadByMaterialId((int)materialId, companyId);
tbxMaterial.Text = assetSewerMHMaterialTypeGateway.GetMaterialType((int)materialId);
}
else
{
tbxMaterial.Text = "";
}
tbxLocation.Text = manholeRehabilitationManholeDetailsGateway.GetLocation(assetId);
tbxConditioningRating.Text = "";
if (manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId).HasValue)
{
tbxConditioningRating.Text = manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId).ToString();
}
}
