protected void cvUsmhDsmhDBEdit_ServerValidate(object source, ServerValidateEventArgs args)
{
// Initialize
args.IsValid = true;
// Validate if mh already exists
int companyId = Int32.Parse(hdfCompanyId.Value);
Int64? countryId = null; if (hdfCountryId.Value != "0") countryId = Int64.Parse(hdfCountryId.Value);
Int64? provinceId = null; if (hdfProvinceId.Value != "0") provinceId = Int64.Parse(hdfProvinceId.Value);
Int64? countyId = null; if (hdfCountyId.Value != "0") countyId = Int64.Parse(hdfCountyId.Value);
Int64? cityId = null; if (hdfCityId.Value != "0") cityId = Int64.Parse(hdfCityId.Value);
int projectId = int.Parse(hdfProjectId.Value);
CustomValidator cvUsmhDsmhDBEdit = (CustomValidator)source;
GridViewRow gridRow = (GridViewRow)cvUsmhDsmhDBEdit.NamingContainer;
string usmh = ((TextBox)gridRow.FindControl("tbxUsmhEdit")).Text;
string dsmh = ((TextBox)gridRow.FindControl("tbxDsmhEdit")).Text;
AssetSewerMHGateway assetSewerMhGatewayUSMH = new AssetSewerMHGateway();
assetSewerMhGatewayUSMH.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, usmh, companyId, "", "", "");//TODO MH
AssetSewerMHGateway assetSewerMhGatewayDSMH = new AssetSewerMHGateway();
assetSewerMhGatewayDSMH.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, dsmh, companyId, "", "", "");//TODO MH
if (assetSewerMhGatewayUSMH.Table.Rows.Count > 0 && assetSewerMhGatewayDSMH.Table.Rows.Count > 0)
{
int assetIdUsmh = assetSewerMhGatewayUSMH.GetAssetID(usmh);
int assetIdDsmh = assetSewerMhGatewayDSMH.GetAssetID(dsmh);
AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(null);
if (assetSewerMhGateway.USmhDsmhInUseForSections(assetIdUsmh, assetIdDsmh, companyId))
{
args.IsValid = false;
}
}
}
protected void cvUsmhDsmhDBAdd_ServerValidate(object source, ServerValidateEventArgs args)
{
bool usmhAndDsmhValid = true;
args.IsValid = true;
// Validate if mh already exists
int companyId = Int32.Parse(hdfCompanyId.Value);
Int64? countryId = null; if (hdfCountryId.Value != "0") countryId = Int64.Parse(hdfCountryId.Value);
Int64? provinceId = null; if (hdfProvinceId.Value != "0") provinceId = Int64.Parse(hdfProvinceId.Value);
Int64? countyId = null; if (hdfCountyId.Value != "0") countyId = Int64.Parse(hdfCountyId.Value);
Int64? cityId = null; if (hdfCityId.Value != "0") cityId = Int64.Parse(hdfCityId.Value);
int projectId = int.Parse(hdfProjectId.Value);
string usmh = ((TextBox)grdProjectAddSectionsNew.FooterRow.FindControl("tbxUsmhAdd")).Text;
string dsmh = ((TextBox)grdProjectAddSectionsNew.FooterRow.FindControl("tbxDsmhAdd")).Text;
AssetSewerMHGateway assetSewerMhGatewayUSMH = new AssetSewerMHGateway();
assetSewerMhGatewayUSMH.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, usmh, companyId, "", "", "");// TODO MH
AssetSewerMHGateway assetSewerMhGatewayDSMH = new AssetSewerMHGateway();
assetSewerMhGatewayDSMH.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, dsmh, companyId, "", "", ""); // TODO MH
if (assetSewerMhGatewayUSMH.Table.Rows.Count > 0 && assetSewerMhGatewayDSMH.Table.Rows.Count > 0)
{
int assetIdUsmh = assetSewerMhGatewayUSMH.GetAssetID(usmh);
int assetIdDsmh = assetSewerMhGatewayDSMH.GetAssetID(dsmh);
AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(null);
if (assetSewerMhGateway.USmhDsmhInUseForSections(assetIdUsmh, assetIdDsmh, companyId))
{
usmhAndDsmhValid = false;
}
}
if (usmhAndDsmhValid)
{
foreach (GridViewRow row in grdProjectAddSectionsNew.Rows)
{
string usmhRow = ((TextBox)row.FindControl("tbxUsmh")).Text;
string dsmhRow = ((TextBox)row.FindControl("tbxDsmh")).Text;
if ((usmhRow == usmh && dsmhRow == dsmh) || (usmhRow == dsmh && dsmhRow == usmh))
{
usmhAndDsmhValid = false;
}
}
}
args.IsValid = usmhAndDsmhValid;
}
// ////////////////////////////////////////////////////////////////////////
// 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="mhid">mhid</param>
/// <param name="latitude">latitude</param>
/// <param name="longitude">longitude</param>
/// <param name="address">address</param>
/// <param name="deleted">deleted</param>
/// <param name="companyId">companyId</param>
/// <param name="manholeShape">manholeShape</param>
/// <param name="location">location</param>
/// <param name="materialID">materialID</param>
/// <param name="topDiameter">topDiameter</param>
/// <param name="topDepth">topDepth</param>
/// <param name="topFloor">topFloor</param>
/// <param name="topCeiling">topCeiling</param>
/// <param name="topBenching">topBenching</param>
/// <param name="downDiameter">downDiameter</param>
/// <param name="downDepth">downDepth</param>
/// <param name="downFloor">downFloor</param>
/// <param name="downCeiling">downCeiling</param>
/// <param name="downBenching">downBenching</param>
/// <param name="rectangle1LongSide">rectangle1LongSide</param>
/// <param name="rectangle1ShortSide">rectangle1ShortSide</param>
/// <param name="rectangle2LongSide">rectangle2LongSide</param>
/// <param name="rectangle2ShortSide">rectangle2ShortSide</param>
/// <param name="topSurfaceArea">topSurfaceArea</param>
/// <param name="downSurfaceArea">downSurfaceArea</param>
/// <param name="manholeRugs">manholeRugs</param>
/// <param name="totalDepth">totalDepth</param>
/// <param name="totalSurfaceArea">totalSurfaceArea</param>
public int InsertDirect(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, string mhid, string latitude, string longitude, string address, bool deleted, int companyId, string manholeShape, string location, int? materialID, string topDiameter, string topDepth, string topFloor, string topCeiling, string topBenching, string downDiameter, string downDepth, string downFloor, string downCeiling, string downBenching, string rectangle1LongSide, string rectangle1ShortSide, string rectangle2LongSide, string rectangle2ShortSide, string topSurfaceArea, string downSurfaceArea, int? manholeRugs, string totalDepth, string totalSurfaceArea)
{
AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway();
assetSewerMhGateway.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, mhid, companyId, latitude, longitude, address);
int mh_assetId = 0;
if (assetSewerMhGateway.Table.Rows.Count == 0)
{
mh_assetId = new Asset(new DataSet()).InsertDirect("Sewer", countryId, provinceId, countyId, cityId, deleted, companyId);
new AssetSewer(new DataSet()).InsertDirect(mh_assetId, "MH", deleted, companyId);
assetSewerMhGateway.Insert(mh_assetId, mhid, latitude, longitude, address, deleted, companyId, manholeShape, location, materialID, topDiameter, topDepth, topFloor, topCeiling, topBenching, downDiameter, downDepth, downFloor, downCeiling, downBenching, rectangle1LongSide, rectangle1ShortSide, rectangle2LongSide, rectangle2ShortSide, topSurfaceArea, downSurfaceArea, manholeRugs, totalDepth, totalSurfaceArea);
}
else
{
mh_assetId = assetSewerMhGateway.GetAssetID(mhid);
}
return mh_assetId;
}
/// <summary>
/// UpdateMH
/// </summary>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="mhId">mhId</param>
/// <param name="originalUsmhAddress">originalUsmhAddress</param>
/// <param name="newUsmhAddress">newUsmhAddress</param>
/// <param name="companyId">companyId</param>
private void UpdateMH(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, string mhId, string originalAddress, string newAddress, int companyId)
{
// Get unchanged data
// ... mh
AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway();
assetSewerMHGateway.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, mhId, companyId, "", "", ""); //TODO MH
// Update mh
if (assetSewerMHGateway.Table.Rows.Count > 0)
{
int originalAssetId = assetSewerMHGateway.GetAssetID(mhId);
string originalLatitude = assetSewerMHGateway.GetLatitude(mhId);
string originalLongitude = assetSewerMHGateway.GetLongitude(mhId);
bool originalDeleted = assetSewerMHGateway.GetDeleted(mhId);
int originalCompanyId = assetSewerMHGateway.GetCompanyId(mhId);
string originalManholeShape = assetSewerMHGateway.GetManholeShape(mhId);
string originalLocation = assetSewerMHGateway.GetLocation(mhId);
int? originalMaterialID = assetSewerMHGateway.GetMaterialID(mhId);
string originalTopDiameter = assetSewerMHGateway.GetTopDepth(mhId);
string originalTopDepth = assetSewerMHGateway.GetTopDepth(mhId);
string originalTopFloor = assetSewerMHGateway.GetTopFloor(mhId);
string originalTopCeiling = assetSewerMHGateway.GetTopFloor(mhId);
string originalTopBenching = assetSewerMHGateway.GetTopBenching(mhId);
string originalDownDiameter = assetSewerMHGateway.GetDownDiameter(mhId);
string originalDownDepth = assetSewerMHGateway.GetDownDepth(mhId);
string originalDownFloor = assetSewerMHGateway.GetDownFloor(mhId);
string originalDownCeiling = assetSewerMHGateway.GetDownCeiling(mhId);
string originalDownBenching = assetSewerMHGateway.GetDownBenching(mhId);
string originalRectangle1LongSide = assetSewerMHGateway.GetRectangle1LongSide(mhId);
string originalRectangle1ShortSide = assetSewerMHGateway.GetRectangle1ShortSide(mhId);
string originalRectangle2LongSide = assetSewerMHGateway.GetRectangle2LongSide(mhId);
string originalRectangle2ShortSide = assetSewerMHGateway.GetRectangle2ShortSide(mhId);
string originalTopSurfaceArea = assetSewerMHGateway.GetTopSurfaceArea(mhId);
string originalDownSurfaceArea = assetSewerMHGateway.GetDownSurfaceArea(mhId);
int? originalManholeRugs = assetSewerMHGateway.GetManholeRugs(mhId);
string originalTotalDepth = assetSewerMHGateway.GetTotalDepth(mhId);
string originalTotalSurfaceArea = assetSewerMHGateway.GetTotalSurfaceArea(mhId);
AssetSewerMH assetSewerMH = new AssetSewerMH(assetSewerMHGateway.Data);
assetSewerMH.UpdateDirect(originalAssetId, mhId, originalLatitude, originalLongitude, originalAddress, originalManholeShape, originalLocation, originalMaterialID, originalTopDiameter, originalTopDepth, originalTopFloor, originalTopCeiling, originalTopBenching, originalDownDiameter, originalDownDepth, originalDownFloor, originalDownCeiling, originalDownBenching, originalRectangle1LongSide, originalRectangle1ShortSide, originalRectangle2LongSide, originalRectangle2ShortSide, originalTopSurfaceArea, originalDownSurfaceArea, originalManholeRugs, originalTotalDepth, originalTotalSurfaceArea, originalDeleted, originalCompanyId, originalAssetId, mhId, originalLatitude, originalLongitude, newAddress, originalManholeShape, originalLocation, originalMaterialID, originalTopDiameter, originalTopDepth, originalTopFloor, originalTopCeiling, originalTopBenching, originalDownDiameter, originalDownDepth, originalDownFloor, originalDownCeiling, originalDownBenching, originalRectangle1LongSide, originalRectangle1ShortSide, originalRectangle2LongSide, originalRectangle2ShortSide, originalTopSurfaceArea, originalDownSurfaceArea, originalManholeRugs, originalTotalDepth, originalTotalSurfaceArea, originalDeleted, originalCompanyId);
}
}
protected void cvMhIdFooter_ServerValidate(object source, ServerValidateEventArgs args)
{
// Validate if mh already exists
int companyId = Int32.Parse(hdfCompanyId.Value);
string mhId = ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxMhIdAdd")).Text;
Int64? countryId = null; if (hdfCountryId.Value != "0") countryId = Int64.Parse(hdfCountryId.Value);
Int64? provinceId = null; if (hdfProvinceId.Value != "0") provinceId = Int64.Parse(hdfProvinceId.Value);
Int64? countyId = null; if (hdfCountyId.Value != "0") countyId = Int64.Parse(hdfCountyId.Value);
Int64? cityId = null; if (hdfCityId.Value != "0") cityId = Int64.Parse(hdfCityId.Value);
int projectId = Convert.ToInt32(ddlProject.SelectedValue);
string latitud = ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxLatitudeAdd")).Text;
string longitude = ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxLongitudeAdd")).Text;
string address = ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxStreetAdd")).Text;
AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway();
assetSewerMhGateway.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, mhId, companyId, latitud, longitude, address);
if (assetSewerMhGateway.Table.Rows.Count > 0)
{
int assetIdMh = assetSewerMhGateway.GetAssetID(mhId);
if (assetSewerMhGateway.IsUsedInMHProject(projectId, assetIdMh))
{
args.IsValid = false;
}
else
{
assetSewerMhGateway.LoadTop1ByMhIdProjectId(mhId, Convert.ToInt32(ddlProject.SelectedValue), companyId);
if (assetSewerMhGateway.Table.Rows.Count > 0)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
}
else
{
args.IsValid = true;
}
//AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway();
//if (ddlProject.SelectedIndex != 0)
//{
// assetSewerMHGateway.LoadTop1ByMhIdProjectId(mhId, Convert.ToInt32(ddlProject.SelectedValue), companyId);
//}
//else
//{
// assetSewerMHGateway.LoadTop1ByMhId(mhId, companyId);
//}
//if (assetSewerMHGateway.Table.Rows.Count > 0)
//{
// args.IsValid = false;
//}
//else
//{
// args.IsValid = true;
//}
}