public bool Update(string bridgeName, string details, bool pededstrians, bool midIsland, bool sideCurb, bool midIslandGood, bool sideCurbGood, bool lighting,
string lightLoc, string lightCount, bool elecMH, bool stcMH, string elecMhCount, string stcMhCount, bool shoulders, bool shouldersGood, bool trafficSigns,
bool guideSigns, int bridgeID, int contractorID, string num, string user, int bridgeTypeID, int cammerTypeID, double?cammerheight, int supporterTypeID,
int?supportersCount, int sideBarrierTypeID, int?lanesCount, double?laneWidth, double?tileWidth, double?entranceWidth, double?x, double?y, double?z,
int?builtYear, bool curved, bool perpend, double?curbHeight, double?curbWidth, double?midIslandWidth, bool drain, int?openingsCount, double?bridgeHeight,
int surfaceTypeID)
{
if (bridgeID == 0)
{
return(false);
}
string openingsCountPart = (openingsCount == null) ? "NULL" : ((int)openingsCount).ToString();
string cammerheightPart = (cammerheight == null) ? "NULL" : ((double)cammerheight).ToString();
string supportersCountPart = (supportersCount == null) ? "NULL" : ((int)supportersCount).ToString();
string lanesCountPart = (lanesCount == null) ? "NULL" : ((int)lanesCount).ToString();
string laneWidthPart = (laneWidth == null) ? "NULL" : ((double)laneWidth).ToString();
string tileWidthPart = (tileWidth == null) ? "NULL" : ((double)tileWidth).ToString();
string entranceWidthPart = (entranceWidth == null) ? "NULL" : ((double)entranceWidth).ToString();
string xPart = (x == null) ? "NULL" : ((double)x).ToString();
string yPart = (y == null) ? "NULL" : ((double)y).ToString();
string zPart = (z == null) ? "NULL" : ((double)z).ToString();
string builtYearPart = (builtYear == null) ? "NULL" : ((int)builtYear).ToString();
string curbHeightPart = (curbHeight == null) ? "NULL" : ((double)curbHeight).ToString();
string bridgeHeightPart = (bridgeHeight == null) ? "NULL" : ((double)bridgeHeight).ToString();
string curbWidthPart = (curbWidth == null) ? "NULL" : ((double)curbWidth).ToString();
string midIslandWidthPart = (midIslandWidth == null) ? "NULL" : ((double)midIslandWidth).ToString();
lightLoc = string.IsNullOrEmpty(lightLoc) ? "NULL" : string.Format("'{0}'", lightLoc.Replace("'", "''"));
details = string.IsNullOrEmpty(details) ? "NULL" : string.Format("'{0}'", details.Replace("'", "''"));
num = string.IsNullOrEmpty(num) ? "NULL" : string.Format("'{0}'", num.Replace("'", "''"));
string lightCountPart = lighting ? int.Parse(lightCount).ToString() : "NULL";
string elecMhCountPart = elecMH ? int.Parse(elecMhCount).ToString() : "NULL";
string stcMhCountPart = stcMH ? int.Parse(stcMhCount).ToString() : "NULL";
string sql = string.Format("update BRIDGES set BRIDGE_NAME='{0}', PEDESTRIAN='{1}', LIGHTING_TRUE='{2}', LIGHTING_LOC={3}, LIGHTING_COUNT={4}, MID_ISLAND_TRUE='{5}', " +
" SIDE_CURB_TRUE='{6}', MID_ISLAND_GOOD='{7}', SIDE_CURB_GOOD='{8}', SHOULDERS_TRUE='{9}', SHOULDERS_GOOD='{10}', ELEC_MH_TRUE='{11}', ELEC_MH_COUNT={12}, " +
" STC_MH_TRUE='{13}', STC_MH_COUNT={14}, TRAFFIC_SIGNS_TRUE='{15}', GUIDE_SIGNS_TRUE='{16}', DETAILS={17}, " +
" CONTRACTOR_ID={19}, BRIDGE_NO={20}, BRIDGE_TYPE_ID={21}, OPENINGS_COUNT={22}, CAMMERS_TYPE_ID={23}, CAMMERS_HEIGHT={24}, SUPPORTER_TYPE_ID={25}, " +
" SUPPORTERS_COUNT={26}, SIDE_BARRIER_TYPE_ID={27}, LANES_COUNT={28}, LANE_WIDTH={29}, TILE_WIDTH={30}, ENTRANCE_WIDTH={31}, COORD_X={32}, COORD_Y={33}, " +
" COORD_Z={34}, BUILT_YEAR={35}, BRIDGE_HEIGHT={36}, CURVED='{37}', ROAD_PERPEND='{38}', CURB_HEIGHT={39}, CURB_WIDTH={40}, MID_ISLAND_WIDTH={41}, " +
" DRAIN_EXISTS='{42}', SURFACE_TYPE_ID={43} where BRIDGE_ID={18} ",
bridgeName, Shared.Bool2YN(pededstrians), Shared.Bool2YN(lighting), lightLoc, lightCountPart, Shared.Bool2YN(midIsland),
Shared.Bool2YN(sideCurb), Shared.Bool2YN(midIslandGood), Shared.Bool2YN(sideCurbGood), Shared.Bool2YN(shoulders), Shared.Bool2YN(shouldersGood),
Shared.Bool2YN(elecMH), elecMhCountPart, Shared.Bool2YN(stcMH), stcMhCountPart, Shared.Bool2YN(trafficSigns), Shared.Bool2YN(guideSigns), details, bridgeID,
contractorID, num, bridgeTypeID, openingsCountPart, cammerTypeID, cammerheightPart, supporterTypeID,
supportersCountPart, sideBarrierTypeID, lanesCountPart, laneWidthPart, tileWidthPart, entranceWidthPart, xPart, yPart,
zPart, builtYearPart, bridgeHeightPart, Shared.Bool2YN(curved), Shared.Bool2YN(perpend), curbHeightPart, curbWidthPart, midIslandWidthPart,
Shared.Bool2YN(drain), surfaceTypeID);
int rows = db.ExecuteNonQuery(sql);
Shared.SaveLogfile("Bridges", bridgeID.ToString(), "Update Info", user);
return(rows > 0);
}
public bool UpdateLaneSampleDetails(string sample_No, string SAMPLE_LENGTH, string SAMPLE_WIDTH, bool hasOpening, string openingWidth, string openingLength,
bool parking, int parkingMethodID, bool uTurn, string uTurnLength, string uTurnWidth, bool sidewalkPainted, bool sidewalkPaintGood, bool hasHandicappedSlope,
bool handicappedSlopeGood, bool hasSpeedBumps, bool SpeedBumpLegal, bool SpeedBumpIllegal, string SpeedBumpsCount, bool pedestrian, bool pedestrianGood,
int SAMPLE_ID, bool concreteBlocks, string concreteBlocksCount, string user, int speedBumpType)
{
int sampleNo = int.Parse(sample_No);
string sampleWidthPart = string.IsNullOrEmpty(SAMPLE_WIDTH) ? "NULL" : decimal.Parse(SAMPLE_WIDTH).ToString("N2");
string sampleLengthPart = string.IsNullOrEmpty(SAMPLE_LENGTH) ? "NULL" : decimal.Parse(SAMPLE_LENGTH).ToString("N2");
string openingWidthPart = hasOpening ? decimal.Parse(openingWidth).ToString("N2") : "NULL";
string openingLengthPart = hasOpening ? decimal.Parse(openingLength).ToString("N2") : "NULL";
string uTurnWidthPart = uTurn ? decimal.Parse(uTurnWidth).ToString("N2") : "NULL";
string uTurnLengthPart = uTurn ? decimal.Parse(uTurnLength).ToString("N2") : "NULL";
string spBumpsCount = hasSpeedBumps ? int.Parse(SpeedBumpsCount).ToString() : "NULL";
string concreteBlocksCountPart = concreteBlocks ? int.Parse(concreteBlocksCount).ToString() : "NULL";
string parkingMethodPart = (parkingMethodID == 0) ? "NULL" : parkingMethodID.ToString();
string speedBumpTypePart = (speedBumpType == 0) ? "NULL" : speedBumpType.ToString();
string sql = string.Format("update LANE_SAMPLE_DETAILS set MAIN_SRVC_OPENING_TRUE='{0}', MAIN_SRVC_OPENING_WIDTH={1}, MAIN_SRVC_OPENING_LENGTH={2}, " +
" IS_PARKING='{3}', PARKING_METHOD={4}, U_TURN_TRUE='{5}', U_TURN_LENGTH={6}, U_TURN_WIDTH={7}, SIDEWALK_PAINT_TRUE='{8}', " +
" SIDEWALK_PAINT_GOOD='{9}', HANDICAPPED_SLOPE_TRUE='{10}', HANDICAPPED_SLOPE_GOOD='{11}', SPEED_BUMPS_TRUE='{12}', " +
" SPEED_BUMPS_LEGAL='{13}', SPEED_BUMPS_ILLEGAL='{14}', SPEED_BUMPS_COUNT={15}, PEDESTRIAN='{16}', PEDESTRIAN_GOOD='{17}', " +
" SAMPLE_NO='{19}', CONCRETE_BLOCKS='{20}', CONCRETE_BLOCKS_COUNT={21}, SPEED_BUMP_TYPE_ID={22} where SAMPLE_ID={18} ",
Shared.Bool2YN(hasOpening), openingWidthPart, openingLengthPart,
Shared.Bool2YN(parking), parkingMethodPart, Shared.Bool2YN(uTurn), uTurnLengthPart, uTurnWidthPart, Shared.Bool2YN(sidewalkPainted),
Shared.Bool2YN(sidewalkPaintGood), Shared.Bool2YN(hasHandicappedSlope), Shared.Bool2YN(handicappedSlopeGood), Shared.Bool2YN(hasSpeedBumps),
Shared.Bool2YN(SpeedBumpLegal), Shared.Bool2YN(SpeedBumpIllegal), spBumpsCount, Shared.Bool2YN(pedestrian), Shared.Bool2YN(pedestrianGood),
SAMPLE_ID, sample_No, Shared.Bool2YN(concreteBlocks), concreteBlocksCountPart, speedBumpTypePart);
int rows = db.ExecuteNonQuery(sql);
sql = string.Format("update LANE_SAMPLES set SAMPLE_LENGTH={0}, SAMPLE_WIDTH={1} where SAMPLE_ID={2} ", sampleLengthPart, sampleWidthPart, SAMPLE_ID);
rows += db.ExecuteNonQuery(sql);
rows += FixDistressesAfterAreaChange(double.Parse(SAMPLE_LENGTH), double.Parse(SAMPLE_WIDTH), SAMPLE_ID, user);
Shared.SaveLogfile("LANE_SAMPLES", SAMPLE_ID.ToString(), "Update Info", user);
return(rows > 0);
}
public bool Insert(string r4No, string r4Name, DateTime?r4Date, DateTime?openingDate, DateTime?surveyDate, DateTime?sectionsDefiningDate, int contractorID,
bool houses, bool warehouses, bool commerial, bool gardens, bool indisterial, bool rest_house, bool publics, bool drinage_cb_true, string drinage_cb_count,
bool drinage_mh_true, string drinage_mh_count, bool sewage_mh_true, string sewage_mh_count, bool Elect_mh_true, string Elect_mh_count, bool stc_mh_true,
string stc_mh_count, bool water_valve_true, string water_valve_count, bool notPavedByMunic, string NotPavedDetails, bool OwnedByMunic, string OwnedDetails,
char populationDensity, string topographyDetails, bool needMidIsland, bool needTrees, bool needLighting, bool needInfraWorks, bool needTrafficSigns,
bool needServiceLanes, bool needSpeedBumps, string neededLanesCount, bool innerWaterHas, string soilType, string moreDetails, int lightingContractorID,
DateTime?lightingFinishDate, string lightingContractName, string lightingContractNo, int treesContractorID, DateTime?treesFinishDate, string treesContractName,
string treesContractNo, int pavingContractorID, DateTime?pavingFinishDate, string pavingContractName, string pavingContractNo, string r4_length, int mainStID)
{
int rows = 0;
int newID = 0;
string r4_lengthPart = string.IsNullOrEmpty(r4_length) ? "NULL" : decimal.Parse(r4_length).ToString("N2");
string r4DatePart = (r4Date == null) ? "NULL" : string.Format("'{0}'", ((DateTime)r4Date).ToString("dd/MM/yyyy"));
string openingDatePart = (openingDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)openingDate).ToString("dd/MM/yyyy"));
string surveyDatePart = (surveyDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)surveyDate).ToString("dd/MM/yyyy"));
string sectionsDefiningDatePart = (sectionsDefiningDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)sectionsDefiningDate).ToString("dd/MM/yyyy"));
string neededLanesPart = string.IsNullOrEmpty(neededLanesCount) ? "NULL" : int.Parse(neededLanesCount).ToString();
string drinageCbCount = (drinage_cb_true || !string.IsNullOrEmpty(drinage_cb_count)) ? drinage_cb_count : "NULL";
string drinageMhCount = (drinage_mh_true || !string.IsNullOrEmpty(drinage_mh_count)) ? drinage_mh_count : "NULL";
string sewageMhCount = (sewage_mh_true || !string.IsNullOrEmpty(sewage_mh_count)) ? sewage_mh_count : "NULL";
string ElectMhCount = (Elect_mh_true || !string.IsNullOrEmpty(Elect_mh_count)) ? Elect_mh_count : "NULL";
string stcMhCount = (stc_mh_true || !string.IsNullOrEmpty(stc_mh_count)) ? stc_mh_count : "NULL";
string waterValveCount = (water_valve_true || !string.IsNullOrEmpty(water_valve_count)) ? water_valve_count : "NULL";
r4No = string.IsNullOrEmpty(r4No) ? "NULL" : string.Format("'{0}'", r4No.Replace("'", "''"));
r4Name = string.IsNullOrEmpty(r4Name) ? "NULL" : string.Format("'{0}'", r4Name.Replace("'", "''"));
NotPavedDetails = string.IsNullOrEmpty(NotPavedDetails) ? "NULL" : string.Format("'{0}'", NotPavedDetails.Replace("'", "''"));
OwnedDetails = string.IsNullOrEmpty(OwnedDetails) ? "NULL" : string.Format("'{0}'", OwnedDetails.Replace("'", "''"));
topographyDetails = string.IsNullOrEmpty(topographyDetails) ? "NULL" : string.Format("'{0}'", topographyDetails.Replace("'", "''"));
moreDetails = string.IsNullOrEmpty(moreDetails) ? "NULL" : string.Format("'{0}'", moreDetails.Replace("'", "''"));
soilType = string.IsNullOrEmpty(soilType) ? "NULL" : string.Format("'{0}'", soilType.Replace("'", "''"));
// 0 1 2 3 4 5 6
string sql = string.Format("insert into R4_STREETS(R4_ST_ID, R4_NO, R4_NAME, R4_DATE, OPENING_DATE, SURVEY_DATE, SECTIONS_DEFINING_DATE, CONTRACTOR_ID, " +
// 7 8 9 10 11 12 13 14 15 16
"DRAIN_CB_TRUE, DRAIN_CB_COUNT, DRAIN_MH_TRUE, DRAIN_MH_COUNT, ELEC_MH_TRUE, ELEC_MH_COUNT, WATER_MH_TRUE, WATER_MH_COUNT, SEWAGE_MH_TRUE, SEWAGE_MH_COUNT, " +
// 17 18 19 20 21 22 23 24 25 26 27
"STC_MH_TRUE, STC_MH_COUNT, NOT_PAVED_BY_MUNIC, NOT_PAVED_BY_DETAILS, OWNED_BY_MUNIC, OWNED_DETAILS, HOUSING, WAREHOUSES, COMMERCIAL, GARDENS, INDUSTRIAL, " +
// 28 29 30 31 32 33 34 35 36 37
"REST_HOUSES, PUBLICS, POPULATION, TOPOGRAPHY_DETAILS, NEED_MID_ISLAND, NEED_TREES, NEED_LIGHTING, NEED_INFRA_WORKS, NEED_TRAFFIC_SIGNS, NEEDED_LANES_COUNT, " +
// 38 39 40 41 42 43 44
"NEED_SERVICE_LANES, NEED_SPEED_BUMPS, INNER_WATER, SOIL_TYPE_DETAILS, R4_LENGTH, MORE_DETAILS, STREET_ID) " + // MAIN_ST_ID
" values(SEQ_R4_STREETS.nextval, {0}, {1}, {2}, {3}, {4}, {5}, {6}, " +
" '{7}', {8}, '{9}', {10}, '{11}', {12}, '{13}', {14}, '{15}', {16}, " +
" '{17}', {18}, '{19}', {20}, '{21}', {22}, '{23}', '{24}', '{25}', '{26}', '{27}', " +
" '{28}', '{29}', '{30}', {31}, '{32}', '{33}', " +
" '{34}', '{35}', '{36}', {37}, '{38}', '{39}', '{40}', {41}, {42}, {43}, {44}) ",
r4No, r4Name, r4DatePart, openingDatePart, surveyDatePart, sectionsDefiningDatePart, contractorID,
Shared.Bool2YN(drinage_cb_true), drinageCbCount, Shared.Bool2YN(drinage_mh_true), drinageMhCount, Shared.Bool2YN(Elect_mh_true), ElectMhCount,
Shared.Bool2YN(water_valve_true), waterValveCount, Shared.Bool2YN(sewage_mh_true), sewageMhCount,
Shared.Bool2YN(stc_mh_true), stcMhCount, Shared.Bool2YN(notPavedByMunic), NotPavedDetails, Shared.Bool2YN(OwnedByMunic), OwnedDetails, Shared.Bool2YN(houses),
Shared.Bool2YN(warehouses), Shared.Bool2YN(commerial), Shared.Bool2YN(gardens), Shared.Bool2YN(indisterial),
Shared.Bool2YN(rest_house), Shared.Bool2YN(publics), populationDensity, topographyDetails, Shared.Bool2YN(needMidIsland), Shared.Bool2YN(needTrees),
Shared.Bool2YN(needLighting), Shared.Bool2YN(needInfraWorks), Shared.Bool2YN(needTrafficSigns), neededLanesPart,
Shared.Bool2YN(needServiceLanes), Shared.Bool2YN(needSpeedBumps), Shared.Bool2YN(innerWaterHas), soilType, r4_lengthPart, moreDetails, mainStID);
newID = db.ExecuteInsertWithIDReturn(sql, "R4_STREETS");
if (newID != 0)
{
string lightingFinishDatePart = (lightingFinishDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)lightingFinishDate).ToString("dd/MM/yyyy"));
lightingContractNo = string.IsNullOrEmpty(lightingContractNo) ? "NULL" : string.Format("'{0}'", lightingContractNo.Replace("'", "''"));
lightingContractName = string.IsNullOrEmpty(lightingContractName) ? "NULL" : string.Format("'{0}'", lightingContractName.Replace("'", "''"));
// 0 0 1 2 3 4
sql = string.Format("insert into R4_LIGHTING(RECORD_ID, R4_ID, CONTRACTOR_ID, FINISH_DATE, CONTRACT_NAME, CONTRACT_NO) " +
" values({0}, {0}, {1}, {2}, {3}, {4})", newID, lightingContractorID, lightingFinishDatePart, lightingContractName, lightingContractNo);
rows += db.ExecuteNonQuery(sql);
string treesFinishDatePart = (treesFinishDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)treesFinishDate).ToString("dd/MM/yyyy"));
treesContractNo = string.IsNullOrEmpty(treesContractNo) ? "NULL" : string.Format("'{0}'", treesContractNo.Replace("'", "''"));
treesContractName = string.IsNullOrEmpty(treesContractName) ? "NULL" : string.Format("'{0}'", treesContractName.Replace("'", "''"));
sql = string.Format("insert into R4_PAVING(RECORD_ID, R4_ID, CONTRACTOR_ID, FINISH_DATE, CONTRACT_NAME, CONTRACT_NO) " +
" values({0}, {0}, {1}, {2}, {3}, {4})", newID, treesContractorID, treesFinishDatePart, treesContractName, treesContractNo);
rows += db.ExecuteNonQuery(sql);
string pavingFinishDatePart = (pavingFinishDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)pavingFinishDate).ToString("dd/MM/yyyy"));
pavingContractNo = string.IsNullOrEmpty(pavingContractNo) ? "NULL" : string.Format("'{0}'", pavingContractNo.Replace("'", "''"));
pavingContractName = string.IsNullOrEmpty(pavingContractName) ? "NULL" : string.Format("'{0}'", pavingContractName.Replace("'", "''"));
sql = string.Format("insert into R4_TREES(RECORD_ID, R4_ID, CONTRACTOR_ID, FINISH_DATE, CONTRACT_NAME, CONTRACT_NO) " +
" values({0}, {0}, {1}, {2}, {3}, {4})", newID, pavingContractorID, pavingFinishDatePart, pavingContractName, pavingContractNo);
rows += db.ExecuteNonQuery(sql);
return(rows > 0);
}
else
{
return(false);
}
}
public bool Update(string r4No, string r4Name, DateTime?r4Date, DateTime?openingDate, DateTime?surveyDate, DateTime?sectionsDefiningDate, int contractorID,
bool houses, bool warehouses, bool commerial, bool gardens, bool indisterial, bool rest_house, bool publics, bool drinage_cb_true, string drinage_cb_count,
bool drinage_mh_true, string drinage_mh_count, bool sewage_mh_true, string sewage_mh_count, bool Elect_mh_true, string Elect_mh_count, bool stc_mh_true,
string stc_mh_count, bool water_valve_true, string water_mh_count, bool notPavedByMunic, string NotPavedDetails, bool OwnedByMunic, string OwnedDetails,
char popDens, string topographyDetails, bool needMidIsland, bool needTrees, bool needLighting, bool needInfraWorks, bool needTrafficSigns, bool needServiceLanes,
bool needSpeedBumps, string neededLanesCount, bool innerWaterHas, string soilType, string moreDetails, int lightingContractorID, DateTime?lightingFinishDate,
string lightingContractName, string lightingContractNo, int treesContractorID, DateTime?treesFinishDate, string treesContractName, string treesContractNo,
int pavingContractorID, DateTime?pavingFinishDate, string pavingContractName, string pavingContractNo, string r4_length, int r4ID, int mainStID)
{
int rows = 0;
string r4_lengthPart = string.IsNullOrEmpty(r4_length) ? "NULL" : decimal.Parse(r4_length).ToString("N2");
string r4DatePart = (r4Date == null) ? "NULL" : string.Format("'{0}'", ((DateTime)r4Date).ToString("dd/MM/yyyy"));
string openingDatePart = (openingDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)openingDate).ToString("dd/MM/yyyy"));
string surveyDatePart = (surveyDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)surveyDate).ToString("dd/MM/yyyy"));
string sectionsDefiningDatePart = (sectionsDefiningDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)sectionsDefiningDate).ToString("dd/MM/yyyy"));
string neededLanesPart = string.IsNullOrEmpty(neededLanesCount) ? "NULL" : int.Parse(neededLanesCount).ToString();
string drinageCbCount = (drinage_cb_true || !string.IsNullOrEmpty(drinage_cb_count)) ? drinage_cb_count : "NULL";
string drinageMhCount = (drinage_mh_true || !string.IsNullOrEmpty(drinage_mh_count)) ? drinage_mh_count : "NULL";
string sewageMhCount = (sewage_mh_true || !string.IsNullOrEmpty(sewage_mh_count)) ? sewage_mh_count : "NULL";
string ElectMhCount = (Elect_mh_true || !string.IsNullOrEmpty(Elect_mh_count)) ? Elect_mh_count : "NULL";
string stcMhCount = (stc_mh_true || !string.IsNullOrEmpty(stc_mh_count)) ? stc_mh_count : "NULL";
string waterValveCount = (water_valve_true || !string.IsNullOrEmpty(water_mh_count)) ? water_mh_count : "NULL";
r4No = string.IsNullOrEmpty(r4No) ? "NULL" : string.Format("'{0}'", r4No.Replace("'", "''"));
r4Name = string.IsNullOrEmpty(r4Name) ? "NULL" : string.Format("'{0}'", r4Name.Replace("'", "''"));
NotPavedDetails = string.IsNullOrEmpty(NotPavedDetails) ? "NULL" : string.Format("'{0}'", NotPavedDetails.Replace("'", "''"));
OwnedDetails = string.IsNullOrEmpty(OwnedDetails) ? "NULL" : string.Format("'{0}'", OwnedDetails.Replace("'", "''"));
topographyDetails = string.IsNullOrEmpty(topographyDetails) ? "NULL" : string.Format("'{0}'", topographyDetails.Replace("'", "''"));
moreDetails = string.IsNullOrEmpty(moreDetails) ? "NULL" : string.Format("'{0}'", moreDetails.Replace("'", "''"));
soilType = string.IsNullOrEmpty(soilType) ? "NULL" : string.Format("'{0}'", soilType.Replace("'", "''"));
string sql = string.Format("update R4_STREETS set R4_NO={0}, R4_NAME={1}, R4_DATE={2}, OPENING_DATE={3}, SURVEY_DATE={4}, SECTIONS_DEFINING_DATE={5}, CONTRACTOR_ID={6}, " +
"DRAIN_CB_TRUE='{7}', DRAIN_CB_COUNT={8}, DRAIN_MH_TRUE='{9}', DRAIN_MH_COUNT={10}, ELEC_MH_TRUE='{11}', ELEC_MH_COUNT={12}, WATER_MH_TRUE='{13}', " +
"WATER_MH_COUNT={14}, SEWAGE_MH_TRUE='{15}', SEWAGE_MH_COUNT={16}, STC_MH_TRUE='{17}', STC_MH_COUNT={18}, NOT_PAVED_BY_MUNIC='{19}', NOT_PAVED_BY_DETAILS={20}, " +
"OWNED_BY_MUNIC='{21}', OWNED_DETAILS={22}, HOUSING='{23}', WAREHOUSES={24}, COMMERCIAL={25}, GARDENS={26}, INDUSTRIAL={27}, " +
"REST_HOUSES='{28}', PUBLICS='{29}', POPULATION='{30}', TOPOGRAPHY_DETAILS={31}, NEED_MID_ISLAND='{32}', NEED_TREES='{33}', NEED_LIGHTING='{34}', " +
"NEED_INFRA_WORKS='{35}', NEED_TRAFFIC_SIGNS='{36}', NEEDED_LANES_COUNT={37}, NEED_SERVICE_LANES='{38}', NEED_SPEED_BUMPS='{39}', INNER_WATER='{40}' " +
", SOIL_TYPE_DETAILS='{41}', R4_LENGTH={42}, MORE_DETAILS='{43}', STREET_ID={45} where R4_ST_ID={44} ", // MAIN_ST_ID
r4No, r4Name, r4DatePart, openingDate, surveyDate, sectionsDefiningDate, contractorID, Shared.Bool2YN(drinage_cb_true), drinageCbCount,
Shared.Bool2YN(drinage_mh_true), drinageMhCount, Shared.Bool2YN(Elect_mh_true), ElectMhCount, Shared.Bool2YN(water_valve_true), waterValveCount,
Shared.Bool2YN(sewage_mh_true), sewageMhCount, Shared.Bool2YN(stc_mh_true), stcMhCount, Shared.Bool2YN(notPavedByMunic), NotPavedDetails,
Shared.Bool2YN(OwnedByMunic), OwnedDetails, Shared.Bool2YN(houses), Shared.Bool2YN(warehouses), Shared.Bool2YN(commerial), Shared.Bool2YN(gardens),
Shared.Bool2YN(indisterial), Shared.Bool2YN(rest_house), Shared.Bool2YN(publics), popDens, topographyDetails, Shared.Bool2YN(needMidIsland),
Shared.Bool2YN(needLighting), Shared.Bool2YN(needInfraWorks), Shared.Bool2YN(needTrafficSigns), neededLanesCount, Shared.Bool2YN(needServiceLanes),
Shared.Bool2YN(needSpeedBumps), Shared.Bool2YN(innerWaterHas), r4_length, moreDetails, r4ID, mainStID);
rows = db.ExecuteNonQuery(sql);
string lightingFinishDatePart = (lightingFinishDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)lightingFinishDate).ToString("dd/MM/yyyy"));
lightingContractNo = string.IsNullOrEmpty(lightingContractNo) ? "NULL" : string.Format("'{0}'", lightingContractNo.Replace("'", "''"));
lightingContractName = string.IsNullOrEmpty(lightingContractName) ? "NULL" : string.Format("'{0}'", lightingContractName.Replace("'", "''"));
sql = string.Format("update R4_LIGHTING set CONTRACTOR_ID={0}, FINISH_DATE={1}, CONTRACT_NAME={2}, CONTRACT_NO={3} where RECORD_ID={4} ",
lightingContractorID, lightingFinishDatePart, lightingContractName, lightingContractNo, r4ID);
rows += db.ExecuteNonQuery(sql);
string treesFinishDatePart = (treesFinishDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)treesFinishDate).ToString("dd/MM/yyyy"));
treesContractNo = string.IsNullOrEmpty(treesContractNo) ? "NULL" : string.Format("'{0}'", treesContractNo.Replace("'", "''"));
treesContractName = string.IsNullOrEmpty(treesContractName) ? "NULL" : string.Format("'{0}'", treesContractName.Replace("'", "''"));
sql = string.Format("update R4_PAVING set CONTRACTOR_ID={0}, FINISH_DATE={1}, CONTRACT_NAME={2}, CONTRACT_NO={3} where RECORD_ID={4} ",
treesContractorID, treesFinishDatePart, treesContractName, treesContractNo, r4ID);
rows += db.ExecuteNonQuery(sql);
string pavingFinishDatePart = (pavingFinishDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)pavingFinishDate).ToString("dd/MM/yyyy"));
pavingContractNo = string.IsNullOrEmpty(pavingContractNo) ? "NULL" : string.Format("'{0}'", pavingContractNo.Replace("'", "''"));
pavingContractName = string.IsNullOrEmpty(pavingContractName) ? "NULL" : string.Format("'{0}'", pavingContractName.Replace("'", "''"));
sql = string.Format("update R4_TREES set CONTRACTOR_ID={0}, FINISH_DATE={1}, CONTRACT_NAME={2}, CONTRACT_NO={3} where RECORD_ID={4} ",
pavingFinishDatePart, pavingContractorID, pavingContractName, pavingContractNo, r4ID);
rows += db.ExecuteNonQuery(sql);
return(rows > 0);
}
public bool Insert(string bridgeName, int sectionID, int intersectID, string details, bool pededstrians, bool midIsland, bool sideCurb, bool midIslandGood,
bool sideCurbGood, bool lighting, string lightLoc, string lightCount, bool elecMH, bool stcMH, string elecMhCount, string stcMhCount, bool shoulders, bool shouldersGood,
bool trafficSigns, bool guideSigns, int contractorID, string num, string user, int bridgeTypeID, int cammerTypeID, double?cammerheight, int supporterTypeID,
int?supportersCount, int sideBarrierTypeID, int?lanesCount, double?laneWidth, double?tileWidth, double?entranceWidth, double?x, double?y, double?z,
int?builtYear, bool curved, bool perpend, double?curbHeight, double?curbWidth, double?midIslandWidth, bool drain, int?openingsCount, double?bridgeHeight,
int surfaceTypeID)
{
if (sectionID == 0 && intersectID == 0)
{
return(false);
}
string openingsCountPart = (openingsCount == null) ? "NULL" : ((int)openingsCount).ToString();
string cammerheightPart = (cammerheight == null) ? "NULL" : ((double)cammerheight).ToString();
string supportersCountPart = (supportersCount == null) ? "NULL" : ((int)supportersCount).ToString();
string lanesCountPart = (lanesCount == null) ? "NULL" : ((int)lanesCount).ToString();
string laneWidthPart = (laneWidth == null) ? "NULL" : ((double)laneWidth).ToString();
string tileWidthPart = (tileWidth == null) ? "NULL" : ((double)tileWidth).ToString();
string entranceWidthPart = (entranceWidth == null) ? "NULL" : ((double)entranceWidth).ToString();
string xPart = (x == null) ? "NULL" : ((double)x).ToString();
string yPart = (y == null) ? "NULL" : ((double)y).ToString();
string zPart = (z == null) ? "NULL" : ((double)z).ToString();
string builtYearPart = (builtYear == null) ? "NULL" : ((int)builtYear).ToString();
string curbHeightPart = (curbHeight == null) ? "NULL" : ((double)curbHeight).ToString();
string bridgeHeightPart = (bridgeHeight == null) ? "NULL" : ((double)bridgeHeight).ToString();
string curbWidthPart = (curbWidth == null) ? "NULL" : ((double)curbWidth).ToString();
string midIslandWidthPart = (midIslandWidth == null) ? "NULL" : ((double)midIslandWidth).ToString();
string locationIdPart = (sectionID == 0) ? "INTERSECT_ID " : "SECTION_ID ";
string locationIDValue = (sectionID == 0) ? intersectID.ToString() : sectionID.ToString();
lightLoc = string.IsNullOrEmpty(lightLoc) ? "NULL" : string.Format("'{0}'", lightLoc.Replace("'", "''"));
details = string.IsNullOrEmpty(details) ? "NULL" : string.Format("'{0}'", details.Replace("'", "''"));
num = string.IsNullOrEmpty(num) ? "NULL" : string.Format("'{0}'", num.Replace("'", "''"));
string lightCountPart = lighting ? int.Parse(lightCount).ToString() : "NULL";
string elecMhCountPart = elecMH ? int.Parse(elecMhCount).ToString() : "NULL";
string stcMhCountPart = stcMH ? int.Parse(stcMhCount).ToString() : "NULL";
string sql = string.Format("insert into BRIDGES(BRIDGE_ID, BRIDGE_NAME, PEDESTRIAN, {0}, LIGHTING_TRUE, LIGHTING_LOC, LIGHTING_COUNT, MID_ISLAND_TRUE, " +
" SIDE_CURB_TRUE, MID_ISLAND_GOOD, SIDE_CURB_GOOD, SHOULDERS_TRUE, SHOULDERS_GOOD, " +
" ELEC_MH_TRUE, ELEC_MH_COUNT, STC_MH_TRUE, STC_MH_COUNT, TRAFFIC_SIGNS_TRUE, GUIDE_SIGNS_TRUE, DETAILS, " +
" CONTRACTOR_ID, BRIDGE_NO, BRIDGE_TYPE_ID, OPENINGS_COUNT, CAMMERS_TYPE_ID, CAMMERS_HEIGHT, SUPPORTER_TYPE_ID, SUPPORTERS_COUNT, SIDE_BARRIER_TYPE_ID, LANES_COUNT, " +
" LANE_WIDTH, TILE_WIDTH, ENTRANCE_WIDTH, COORD_X, COORD_Y, COORD_Z, BUILT_YEAR, BRIDGE_HEIGHT, CURVED, ROAD_PERPEND, " +
" CURB_HEIGHT, CURB_WIDTH, MID_ISLAND_WIDTH, DRAIN_EXISTS, SURFACE_TYPE_ID) " +
" values(SEQ_BRIDGE.nextval, '{1}', '{2}', {3}, '{4}', {5}, {6}, '{7}', " +
" '{8}', '{9}', '{10}', '{11}', '{12}', " +
" '{13}', {14}, '{15}', {16}, '{17}', '{18}', {19}, " +
" {20}, {21}, {22}, {23}, {24}, {25}, {26}, {27}, {28}, {29}, " +
" {30}, {31}, {32}, {33}, {34}, {35}, {36}, {37}, '{38}', '{39}', " +
" {40}, {41}, {42}, '{43}', {44}) ",
// cammersCountPart, int? cammersCount,
locationIdPart, bridgeName, Shared.Bool2YN(pededstrians), locationIDValue, Shared.Bool2YN(lighting), lightLoc, lightCountPart, Shared.Bool2YN(midIsland),
Shared.Bool2YN(sideCurb), Shared.Bool2YN(midIslandGood), Shared.Bool2YN(sideCurbGood), Shared.Bool2YN(shoulders), Shared.Bool2YN(shouldersGood),
Shared.Bool2YN(elecMH), elecMhCountPart, Shared.Bool2YN(stcMH), stcMhCountPart, Shared.Bool2YN(trafficSigns), Shared.Bool2YN(guideSigns), details,
contractorID, num, bridgeTypeID, openingsCountPart, cammerTypeID, cammerheightPart, supporterTypeID, supportersCountPart, sideBarrierTypeID, lanesCountPart,
laneWidthPart, tileWidthPart, entranceWidthPart, xPart, yPart, zPart, builtYearPart, bridgeHeightPart, Shared.Bool2YN(curved), Shared.Bool2YN(perpend),
curbHeightPart, curbWidthPart, midIslandWidthPart, Shared.Bool2YN(drain), surfaceTypeID);
//int rows = db.ExecuteNonQuery(sql);
int newID = db.ExecuteNonQuery(sql); //.ExecuteInsertWithIDReturn(sql, "BRIDGES");
Shared.SaveLogfile("Bridges", newID.ToString(), "Insert Info", user);
return(newID > 0);
}
public bool Update(int DIST_CODE, string DISTRESS_AR_TYPE, string DISTRESS_EN_TYPE, bool DISTRESS_SEVERITY, double DISTRESS_DENSITY_L, double DISTRESS_DENSITY_M,
double DISTRESS_DENSITY_H)
{
DISTRESS_AR_TYPE = string.IsNullOrEmpty(DISTRESS_AR_TYPE) ? "NULL" : string.Format("'{0}'", DISTRESS_AR_TYPE.Replace("'", "''"));
DISTRESS_EN_TYPE = string.IsNullOrEmpty(DISTRESS_EN_TYPE) ? "NULL" : string.Format("'{0}'", DISTRESS_EN_TYPE.Replace("'", "''"));
string sql = string.Format("update DISTRESS_CODE set DISTRESS_AR_TYPE={1}, DISTRESS_EN_TYPE={2}, DISTRESS_SEVERITY='{3}', DISTRESS_DENSITY_L={4}, DISTRESS_DENSITY_M={5}, DISTRESS_DENSITY_H={6} where DIST_CODE={0} ",
DIST_CODE, DISTRESS_AR_TYPE, DISTRESS_EN_TYPE, Shared.Bool2YN(DISTRESS_SEVERITY), DISTRESS_DENSITY_L, DISTRESS_DENSITY_M, DISTRESS_DENSITY_H);
int rows = db.ExecuteNonQuery(sql);
return(rows > 0);
}
public bool Insert(int DIST_CODE, string DISTRESS_AR_TYPE, string DISTRESS_EN_TYPE, bool DISTRESS_SEVERITY, double DISTRESS_DENSITY_L, double DISTRESS_DENSITY_M,
double DISTRESS_DENSITY_H)
{
DISTRESS_AR_TYPE = string.IsNullOrEmpty(DISTRESS_AR_TYPE) ? "NULL" : string.Format("'{0}'", DISTRESS_AR_TYPE.Replace("'", "''"));
DISTRESS_EN_TYPE = string.IsNullOrEmpty(DISTRESS_EN_TYPE) ? "NULL" : string.Format("'{0}'", DISTRESS_EN_TYPE.Replace("'", "''"));
// 0 1 2 3 4 5 6
string sql = string.Format("insert into DISTRESS_CODE(DIST_CODE, DISTRESS_AR_TYPE, DISTRESS_EN_TYPE, DISTRESS_SEVERITY, DISTRESS_DENSITY_L, DISTRESS_DENSITY_M, DISTRESS_DENSITY_H) " +
" values({0}, {1}, {2}, '{3}', {4}, {5}, {6}) ", DIST_CODE, DISTRESS_AR_TYPE, DISTRESS_EN_TYPE, Shared.Bool2YN(DISTRESS_SEVERITY), DISTRESS_DENSITY_L,
DISTRESS_DENSITY_M, DISTRESS_DENSITY_H);
int rows = db.ExecuteNonQuery(sql);
return(rows > 0);
}
public bool Update(string SECOND_AR_NAME, string SECOND_ST_LENGTH, string SECOND_ST_WIDTH, string DIRT_LENGTH, bool LIGHTING_TRUE, string LIGHTING_LOC, bool houses,
bool Commerial, bool publics, bool gardens, bool indisterial, bool rest_house, bool NEW_BUILDINGS, bool SCHOOL, bool HOSPITAL, bool MASJID, bool SPORT_CLUB,
bool OTHER_UTIL, string otherUtilsDetails, bool drinage_mh_True, string drinage_mh_Count, bool drinage_cb_True, string drinage_cb_Count, bool Sewage_mh_True,
string Sewage_mh_Count, bool elect_mh_True, string Elect_mh_Count, bool stc_mh_True, string stc_mh_Count, bool water_valve_True, string water_valve_Count,
bool hasSpeedBumps, bool SpeedBumpLegal, bool SpeedBumpIllegal, string SpeedBumpsCount, int secondaryStreetID, string user, bool concreteBlocks, string concreteBlocksCount,
bool drilling_stc, bool drilling_elec, bool drilling_water, bool drilling_sewage, string drilling_stc_length, string drilling_elec_length, string drilling_water_length,
string drilling_sewage_length, string drainCBFair, string drainCbPoor, string drainMhFair, string drainMhPoor, string elecMhFair, string elecMhPoor, string stcMhFair,
string stcMhPoor, string sewageMhFair, string sewageMhPoor, string waterMhFair, string waterMhPoor, bool midIslandGood, bool midIslandFair, bool midIslandPoor,
bool sideCurbGood, bool sideCurbFair, bool sideCurbPoor, int speedBumpType, string lightGoodCount, string lightFairCount, string lightPoorCount, string notes,
bool midIsland, bool sideCurb, DateTime?surveyDate)
{
// string lightCount,
SECOND_ST_LENGTH = string.IsNullOrEmpty(SECOND_ST_LENGTH) ? "NULL" : SECOND_ST_LENGTH;
SECOND_ST_WIDTH = string.IsNullOrEmpty(SECOND_ST_WIDTH) ? "NULL" : SECOND_ST_WIDTH;
DIRT_LENGTH = string.IsNullOrEmpty(DIRT_LENGTH) ? "NULL" : DIRT_LENGTH;
SECOND_AR_NAME = string.IsNullOrEmpty(SECOND_AR_NAME) ? "NULL" : string.Format("'{0}'", SECOND_AR_NAME.Replace("'", "''"));
LIGHTING_LOC = string.IsNullOrEmpty(LIGHTING_LOC) ? "NULL" : string.Format("'{0}'", LIGHTING_LOC.Replace("'", "''"));
otherUtilsDetails = string.IsNullOrEmpty(otherUtilsDetails) ? "NULL" : string.Format("'{0}'", otherUtilsDetails.Replace("'", "''"));
notes = string.IsNullOrEmpty(notes) ? "NULL" : string.Format("'{0}'", notes.Replace("'", "''"));
string drinageCbCount = drinage_cb_True ? int.Parse(drinage_cb_Count).ToString() : "NULL";
string drinageMhCount = drinage_mh_True ? int.Parse(drinage_mh_Count).ToString() : "NULL";
string sewageMhCount = Sewage_mh_True ? int.Parse(Sewage_mh_Count).ToString() : "NULL";
string ElectMhCount = elect_mh_True ? int.Parse(Elect_mh_Count).ToString() : "NULL";
string stcMhCcount = stc_mh_True ? int.Parse(stc_mh_Count).ToString() : "NULL";
string waterValveCount = water_valve_True ? int.Parse(water_valve_Count).ToString() : "NULL";
string drainageCbFairPart = string.IsNullOrEmpty(drainCBFair) ? "NULL" : int.Parse(drainCBFair).ToString();
string drainageMhFairPart = string.IsNullOrEmpty(drainMhFair) ? "NULL" : int.Parse(drainMhFair).ToString();
string sewageMhFairPart = string.IsNullOrEmpty(sewageMhFair) ? "NULL" : int.Parse(sewageMhFair).ToString();
string ElectMhFairPart = string.IsNullOrEmpty(elecMhFair) ? "NULL" : int.Parse(elecMhFair).ToString();
string stcMhFairPart = string.IsNullOrEmpty(stcMhFair) ? "NULL" : int.Parse(stcMhFair).ToString();
string waterValveFairPart = string.IsNullOrEmpty(waterMhFair) ? "NULL" : int.Parse(waterMhFair).ToString();
string drainageCbPoorPart = string.IsNullOrEmpty(drainCbPoor) ? "NULL" : int.Parse(drainCbPoor).ToString();
string drainageMhPoorPart = string.IsNullOrEmpty(drainMhPoor) ? "NULL" : int.Parse(drainMhPoor).ToString();
string sewageMhPoorPart = string.IsNullOrEmpty(sewageMhPoor) ? "NULL" : int.Parse(sewageMhPoor).ToString();
string ElectMhPoorPart = string.IsNullOrEmpty(elecMhPoor) ? "NULL" : int.Parse(elecMhPoor).ToString();
string stcMhPoorPart = string.IsNullOrEmpty(stcMhPoor) ? "NULL" : int.Parse(stcMhPoor).ToString();
string waterValvePoorPart = string.IsNullOrEmpty(waterMhPoor) ? "NULL" : int.Parse(waterMhPoor).ToString();
//string lightCountPart = string.IsNullOrEmpty(lightCount) ? "NULL" : int.Parse(lightCount).ToString();
string lightGoodCountPart = string.IsNullOrEmpty(lightGoodCount) ? "NULL" : int.Parse(lightGoodCount).ToString();
string lightFairCountPart = string.IsNullOrEmpty(lightFairCount) ? "NULL" : int.Parse(lightFairCount).ToString();
string lightPoorCountPart = string.IsNullOrEmpty(lightPoorCount) ? "NULL" : int.Parse(lightPoorCount).ToString();
string spBumpsCount = hasSpeedBumps ? int.Parse(SpeedBumpsCount).ToString() : "NULL";
string concreteBlocksCountPart = concreteBlocks ? int.Parse(concreteBlocksCount).ToString() : "NULL";
string speedBumpTypePart = (speedBumpType == 0) ? "NULL" : speedBumpType.ToString();
string drillingStcLen = drilling_stc ? decimal.Parse(drilling_stc_length).ToString("0.00") : "NULL";
string drillingWaterLen = drilling_water ? decimal.Parse(drilling_water_length).ToString("0.00") : "NULL";
string drillingElecLen = drilling_elec ? decimal.Parse(drilling_elec_length).ToString("0.00") : "NULL";
string drillingSewageLen = drilling_sewage ? decimal.Parse(drilling_sewage_length).ToString("0.00") : "NULL";
string surveyDatePart = surveyDate != null?string.Format("'{0}'", ((DateTime)surveyDate).ToString("dd/MM/yyyy")) : "NULL";
// SECOND_AR_NAME
string sql = string.Format("update SECONDARY_STREET_DETAILS set SECOND_AR_NAME={0}, ARNAME={0}, SECOND_ST_LENGTH={1}, SECOND_ST_WIDTH={2}, DIRT_LENGTH={3}, " +
" LIGHTING_TRUE='{4}', LIGHTING_LOC={5}, houses='{6}', Commerial='{7}', publics='{8}', gardens='{9}', indisterial='{10}', " +
" rest_house='{11}', NEW_BUILDINGS='{12}', SCHOOL='{13}', HOSPITAL='{14}', MASJID='{15}', SPORT_CLUB='{16}', " +
" OTHER_UTIL='{17}', OTHER_UTIL_DETAILS={18}, drinage_mh_True='{19}', drinage_mh_Count={20}, drinage_cb_True='{21}', " +
" drinage_cb_Count={22}, Sewage_mh_True='{23}', Sewage_mh_Count={24}, elect_mh_True='{25}', Elect_mh_Count={26}, stc_mh_True='{27}', stc_mh_Count={28}, " +
" water_valve_True='{29}', water_valve_Count={30}, SPEED_BUMPS_TRUE='{31}', SPEED_BUMPS_LEGAL='{32}', SPEED_BUMPS_ILLEGAL='{33}', SPEED_BUMPS_COUNT={34}, " +
" DRILLINGS_STC='{36}', DRILLINGS_STC_LENGTH={37}, DRILLINGS_ELEC='{38}', DRILLINGS_ELEC_LENGTH={39}, DRILLINGS_WATER='{40}', DRILLINGS_WATER_LENGTH={41}, " +
" DRILLINGS_SEWAGE='{42}', DRILLINGS_SEWAG_LENGTH={43}, CONCRETE_BLOCKS='{44}', CONCRETE_BLOCKS_COUNT={45}, DRAIN_CB_FAIR={46}, DRAIN_CB_POOR={47}, " +
" DRAIN_MH_FAIR={48}, DRAIN_MH_POOR={49}, ELEC_MH_FAIR={50}, ELEC_MH_POOR={51}, STC_MH_FAIR={52}, STC_MH_POOR={53}, " +
" SEWAGE_MH_FAIR={54}, SEWAGE_MH_POOR={55}, WATER_MH_FAIR={56}, WATER_MH_POOR={57}, MID_ISLAND_GOOD='{58}', MID_ISLAND_FAIR='{59}', " +
" MID_ISLAND_POOR='{60}', SIDE_CURB_GOOD='{61}', SIDE_CURB_FAIR='{62}', SIDE_CURB_POOR='{63}', SPEED_BUMP_TYPE_ID={64}, LIGHT_GOOD_COUNT={65}, " +
" mid_island_True='{67}', side_Curb_True='{68}', SURVEY_DATE={69}, LIGHT_FAIR_COUNT={70}, LIGHT_POOR_COUNT={71} WHERE STREET_ID={35} ", // second_id
SECOND_AR_NAME, SECOND_ST_LENGTH, SECOND_ST_WIDTH, DIRT_LENGTH,
Shared.Bool2YN(LIGHTING_TRUE), LIGHTING_LOC, Shared.Bool2YN(houses), Shared.Bool2YN(Commerial), Shared.Bool2YN(publics), Shared.Bool2YN(gardens), Shared.Bool2YN(indisterial),
Shared.Bool2YN(rest_house), Shared.Bool2YN(NEW_BUILDINGS), Shared.Bool2YN(SCHOOL), Shared.Bool2YN(HOSPITAL), Shared.Bool2YN(MASJID), Shared.Bool2YN(SPORT_CLUB),
Shared.Bool2YN(OTHER_UTIL), otherUtilsDetails, Shared.Bool2YN(drinage_mh_True), drinageMhCount, Shared.Bool2YN(drinage_cb_True),
drinageCbCount, Shared.Bool2YN(Sewage_mh_True), sewageMhCount, Shared.Bool2YN(elect_mh_True), ElectMhCount, Shared.Bool2YN(stc_mh_True), stcMhCcount,
Shared.Bool2YN(water_valve_True), waterValveCount, Shared.Bool2YN(hasSpeedBumps), Shared.Bool2YN(SpeedBumpLegal), Shared.Bool2YN(SpeedBumpIllegal), spBumpsCount,
secondaryStreetID,
Shared.Bool2YN(drilling_stc), drillingStcLen, Shared.Bool2YN(drilling_elec), drillingElecLen, Shared.Bool2YN(drilling_water), drillingWaterLen,
Shared.Bool2YN(drilling_sewage), drillingSewageLen, Shared.Bool2YN(concreteBlocks), concreteBlocksCountPart, drainageCbFairPart, drainageCbPoorPart,
drainageMhFairPart, drainageCbPoorPart, ElectMhFairPart, ElectMhPoorPart, stcMhFairPart, stcMhPoorPart,
sewageMhFairPart, sewageMhPoorPart, waterValveFairPart, waterValvePoorPart, Shared.Bool2YN(midIslandGood), Shared.Bool2YN(midIslandFair),
Shared.Bool2YN(midIslandPoor), Shared.Bool2YN(sideCurbGood), Shared.Bool2YN(sideCurbFair), Shared.Bool2YN(sideCurbPoor), speedBumpTypePart, lightGoodCountPart,
notes, Shared.Bool2YN(midIsland), Shared.Bool2YN(sideCurb), surveyDatePart, lightFairCountPart, lightPoorCountPart);
int rows = db.ExecuteNonQuery(sql);
sql = string.Format("update STREETS set SECOND_ARNAME={0}, SECOND_ST_LENGTH={1}, SECOND_ST_WIDTH={2}, ARNAME={0}, NOTES={5} WHERE STREET_ID={4} ", //second_id SECONDARY_STREETS
SECOND_AR_NAME, SECOND_ST_LENGTH, SECOND_ST_WIDTH, SECOND_AR_NAME, secondaryStreetID, notes);
rows += db.ExecuteNonQuery(sql);
//rows += new Region().FixDistressesAfterAreaChange(double.Parse(SECOND_ST_LENGTH), double.Parse(SECOND_ST_WIDTH), secondaryStreetID, user);
rows += FixDistressesAfterAreaChange(double.Parse(SECOND_ST_LENGTH), double.Parse(SECOND_ST_WIDTH), secondaryStreetID, user);
Shared.SaveLogfile("SECONDARY_STREETS", secondaryStreetID.ToString(), "Update", user);
return(rows > 0);
}
public bool UpdateSectionInfo(string SEC_DIRECTION, decimal SEC_WIDTH, decimal SEC_LENGTH, bool houses, bool publics, bool commerial, bool gardens, bool indisterial,
bool rest_house, bool unpaved_True, string unpaved_length, string unpaved_Width, bool mid_island_True, string mid_island_width, bool sideisland_True,
string sideisland_width, bool side_Curb_True, string side_Curb_width, bool LIGHTING_True, string LIGHTING_LOC, bool brdg_TUNEL_true, string brdg_tunel_type,
bool ag_mid_island_True, bool ag_sid_island_True, bool ag_sec_island_true, bool drinage_mh_true, string drinage_mh_count, bool drinage_cb_true,
string drinage_cb_count, bool sewage_mh_true, string sewage_mh_count, bool Elect_mh_true, string Elect_mh_count, bool stc_mh_true, string stc_mh_count,
bool water_valve_true, string waterMhCount, bool intersectOpenIsland, bool intersectTrafficLight, int SEC_order, int sectionID, bool drilling_stc,
bool drilling_elec, bool drilling_water, bool drilling_sewage, string drilling_stc_length, string drilling_elec_length, string drilling_water_length,
string drilling_sewage_length, bool is_r4, bool is_r3, DateTime?r4Date, DateTime?r3Date, string drainCBFair, string drainCbPoor, string drainMhFair,
string drainMhPoor, string elecMhFair, string elecMhPoor, string stcMhFair, string stcMhPoor, string sewageMhFair, string sewageMhPoor, string waterMhFair,
string waterMhPoor, bool midIslandGood, bool midIslandFair, bool midIslandPoor, bool sideCurbGood, bool sideCurbFair, bool sideCurbPoor, bool propertyConflict,
string megacomCount, string mobyCount, string uniPoleCount, string lightingControlsCount, bool multilevel, bool sideIslandGood, bool sideIslandFair, bool sideIslandPoor,
bool markers, bool paints, bool ceramics, bool pavedbyMunic, string pavedbyMunicDetails, bool ownedByMunic, string ownedByMunicDetails, bool hasPedestrainBridges,
int pedestBridgeType, string pedestBridgesCount, bool sectionBorderOther, string sectionBorderDetails, DateTime?surveyDate, string lightGoodCount,
string lightFairCount, string lightPoorCount, string guideSignsCount, int userID, string user)
{
// string lightCount, bool lightingIsGood, bool lightFair, bool lightPoor, string user,
if (multilevel)
{
string sqlBridgeTunnels = string.Format("select bridge_id from bridges where section_id={0} union select tunnel_id from tunnels where section_id={0} ", sectionID);
DataTable dt = db.ExecuteQuery(sqlBridgeTunnels);
if (dt.Rows.Count == 0)
{
throw new Exception("هذا المقطع متعدد المستويات، يرجى إدخال بيانات الجسور أو بيانات الأنفاق الموجودة فيه");
}
}
SEC_DIRECTION = (SEC_DIRECTION == "0") ? "NULL" : string.Format("'{0}'", SEC_DIRECTION);
LIGHTING_LOC = string.IsNullOrEmpty(LIGHTING_LOC) ? "NULL" : string.Format("'{0}'", LIGHTING_LOC.Replace("'", "''"));
brdg_tunel_type = string.IsNullOrEmpty(brdg_tunel_type) ? "NULL" : string.Format("'{0}'", brdg_tunel_type.Replace("'", "''"));
pavedbyMunicDetails = string.IsNullOrEmpty(pavedbyMunicDetails) ? "NULL" : string.Format("'{0}'", pavedbyMunicDetails.Replace("'", "''"));
ownedByMunicDetails = string.IsNullOrEmpty(ownedByMunicDetails) ? "NULL" : string.Format("'{0}'", ownedByMunicDetails.Replace("'", "''"));
sectionBorderDetails = string.IsNullOrEmpty(sectionBorderDetails) ? "NULL" : string.Format("'{0}'", sectionBorderDetails.Replace("'", "''"));
string unpavedLengthPart = unpaved_True ? decimal.Parse(unpaved_length).ToString("0.00") : "NULL";
string unpavedWidthPart = unpaved_True ? decimal.Parse(unpaved_Width).ToString("0.00") : "NULL";
string drainageCbCount = drinage_cb_true ? int.Parse(drinage_cb_count).ToString() : "NULL";
string drainageMhCount = drinage_mh_true ? int.Parse(drinage_mh_count).ToString() : "NULL";
string sewageMhCount = sewage_mh_true ? int.Parse(sewage_mh_count).ToString() : "NULL";
string ElectMhCount = Elect_mh_true ? int.Parse(Elect_mh_count).ToString() : "NULL";
string stcMhCcount = stc_mh_true ? int.Parse(stc_mh_count).ToString() : "NULL";
string waterValveCount = water_valve_true ? int.Parse(waterMhCount).ToString() : "NULL";
string drainageCbFairPart = string.IsNullOrEmpty(drainCBFair) ? "NULL" : int.Parse(drainCBFair).ToString();
string drainageMhFairPart = string.IsNullOrEmpty(drainMhFair) ? "NULL" : int.Parse(drainMhFair).ToString();
string sewageMhFairPart = string.IsNullOrEmpty(sewageMhFair) ? "NULL" : int.Parse(sewageMhFair).ToString();
string ElectMhFairPart = string.IsNullOrEmpty(elecMhFair) ? "NULL" : int.Parse(elecMhFair).ToString();
string stcMhFairPart = string.IsNullOrEmpty(stcMhFair) ? "NULL" : int.Parse(stcMhFair).ToString();
string waterValveFairPart = string.IsNullOrEmpty(waterMhFair) ? "NULL" : int.Parse(waterMhFair).ToString();
string drainageCbPoorPart = string.IsNullOrEmpty(drainCbPoor) ? "NULL" : int.Parse(drainCbPoor).ToString();
string drainageMhPoorPart = string.IsNullOrEmpty(drainMhPoor) ? "NULL" : int.Parse(drainMhPoor).ToString();
string sewageMhPoorPart = string.IsNullOrEmpty(sewageMhPoor) ? "NULL" : int.Parse(sewageMhPoor).ToString();
string ElectMhPoorPart = string.IsNullOrEmpty(elecMhPoor) ? "NULL" : int.Parse(elecMhPoor).ToString();
string stcMhPoorPart = string.IsNullOrEmpty(stcMhPoor) ? "NULL" : int.Parse(stcMhPoor).ToString();
string waterValvePoorPart = string.IsNullOrEmpty(waterMhPoor) ? "NULL" : int.Parse(waterMhPoor).ToString();
string midIslandWidth = mid_island_True ? decimal.Parse(mid_island_width).ToString("0.00") : "NULL";
string sidIslandWidth = sideisland_True ? decimal.Parse(sideisland_width).ToString("0.00") : "NULL";
string sideCurbWidth = side_Curb_True ? decimal.Parse(side_Curb_width).ToString("0.00") : "NULL";
string drillingStcLen = drilling_stc ? decimal.Parse(drilling_stc_length).ToString("0.00") : "NULL";
string drillingWaterLen = drilling_water ? decimal.Parse(drilling_water_length).ToString("0.00") : "NULL";
string drillingElecLen = drilling_elec ? decimal.Parse(drilling_elec_length).ToString("0.00") : "NULL";
string drillingSewageLen = drilling_sewage ? decimal.Parse(drilling_sewage_length).ToString("0.00") : "NULL";
//string R4datePart = is_r4 ? string.Format("'{0}'", Shared.FormatDateArEgDMY(r4Date)) : "NULL";
string R4datePart = is_r4 ? string.Format("'{0}'", ((DateTime)r4Date).ToString("dd/MM/yyyy")) : "NULL";
string R3datePart = is_r3 ? string.Format("'{0}'", ((DateTime)r3Date).ToString("dd/MM/yyyy")) : "NULL";
string surveyDatePart = surveyDate != null?string.Format("'{0}'", ((DateTime)surveyDate).ToString("dd/MM/yyyy")) : "NULL";
//string noPermitsTillDatePart = is_r3 ? string.Format("'{0}'", ((DateTime)r3Date).AddMonths(6).ToString("dd/MM/yyyy")) : "NULL";
string noPermitsTillDatePart = "";
if (is_r3 && is_r4)
{
DateTime?date = (r3Date > r4Date) ? r3Date : r4Date;
noPermitsTillDatePart = string.Format("'{0}'", ((DateTime)date).AddMonths(6).ToString("dd/MM/yyyy"));
}
if (is_r3)
{
noPermitsTillDatePart = string.Format("'{0}'", ((DateTime)r3Date).AddMonths(6).ToString("dd/MM/yyyy"));
}
else if (is_r4)
{
noPermitsTillDatePart = string.Format("'{0}'", ((DateTime)r4Date).AddMonths(6).ToString("dd/MM/yyyy"));
}
else
{
noPermitsTillDatePart = "NULL";
}
//string lightCountPart = string.IsNullOrEmpty(lightCount) ? "NULL" : int.Parse(lightCount).ToString();
string lightGoodCountPart = string.IsNullOrEmpty(lightGoodCount) ? "NULL" : int.Parse(lightGoodCount).ToString();
string lightFairCountPart = string.IsNullOrEmpty(lightFairCount) ? "NULL" : int.Parse(lightFairCount).ToString();
string lightPoorCountPart = string.IsNullOrEmpty(lightPoorCount) ? "NULL" : int.Parse(lightPoorCount).ToString();
string megacomPart = string.IsNullOrEmpty(megacomCount) ? "NULL" : int.Parse(megacomCount).ToString();
string mobyPart = string.IsNullOrEmpty(mobyCount) ? "NULL" : int.Parse(mobyCount).ToString();
string unipolePart = string.IsNullOrEmpty(uniPoleCount) ? "NULL" : int.Parse(uniPoleCount).ToString();
string lightControlsPart = string.IsNullOrEmpty(lightingControlsCount) ? "NULL" : int.Parse(lightingControlsCount).ToString();
string bridgeTypePart = (pedestBridgeType == 0) ? "NULL" : pedestBridgeType.ToString();
string bridgesCountPart = string.IsNullOrEmpty(pedestBridgesCount) ? "NULL" : pedestBridgesCount.ToString();
string guideSignsCountPart = string.IsNullOrEmpty(guideSignsCount) ? "NULL" : int.Parse(guideSignsCount).ToString();
// LIGHTING_COUNT={72}, lightCountPart , LIGHTING_GOOD='{73}', LIGHT_FAIR='{87}', LIGHT_POOR='{88}', Shared.Bool2YN(lightingIsGood), Shared.Bool2YN(lightFair), Shared.Bool2YN(lightPoor),
string sql = string.Format("UPDATE SECTION_DETAILS SET SEC_DIRECTION={0}, SEC_order={1}, SEC_LENGTH={2}, SEC_WIDTH={3}, houses='{4}', publics='{5}', commerial='{6}', " +
" gardens='{7}', indisterial='{8}', rest_house='{9}', unpaved_true='{10}', unpaved_length={11}, unpaved_width={12}, MID_island_true='{13}', " +
" MID_island_WIDTH={14}, SIDEisland_true='{15}', SIDEisland_WIDTH={16}, side_curb_true='{17}', SIDE_curb_WIDTH={18}, LIGHTING_true='{19}', LIGHTING_LOC={20}, " +
" brdg_TUNEL_true='{21}', brdg_tunel_type={22}, ag_mid_island_true='{23}', ag_sid_island_true='{24}', ag_sec_island_true='{25}', " +
" drinage_mh_true='{26}', drinage_mh_count={27}, drinage_cb_true='{28}', drinage_cb_count={29}, sewage_mh_true='{30}', sewage_mh_count={31}, " +
" Elect_mh_true='{32}', Elect_mh_count={33}, stc_mh_true='{34}', stc_mh_count={35}, water_valve_true='{36}', water_valve_count={37}, " +
" INTERSECTION_OPEN_ISLAND='{38}', INTERSECTION_TRAFFIC_LIGHT='{39}', DRILLINGS_STC='{41}', DRILLINGS_STC_LENGTH={42}, DRILLINGS_ELEC='{43}', " +
" DRILLINGS_ELEC_LENGTH={44}, DRILLINGS_WATER='{45}', DRILLINGS_WATER_LENGTH={46}, DRILLINGS_SEWAGE='{47}', DRILLINGS_SEWAG_LENGTH={48}, IS_R4='{49}', IS_R3='{50}', " +
" R4_DATE={51}, R3_DATE={52}, NO_PERMIT_TILL_DATE={53}, DRAIN_CB_FAIR={54}, DRAIN_CB_POOR={55}, DRAIN_MH_FAIR={56}, DRAIN_MH_POOR={57}, " +
" ELEC_MH_FAIR={58}, ELEC_MH_POOR={59}, STC_MH_FAIR={60}, STC_MH_POOR={61}, SEWAGE_MH_FAIR={62}, SEWAGE_MH_POOR={63}, WATER_MH_FAIR={64}, WATER_MH_POOR={65}, " +
" MID_ISLAND_GOOD='{66}', MID_ISLAND_FAIR='{67}', MID_ISLAND_POOR='{68}', SIDE_CURB_GOOD='{69}', SIDE_CURB_FAIR='{70}', " +
" SIDE_CURB_POOR='{71}', LIGHTING_PROPERTY_CONFLICT='{72}', MEGACOM_COUNT={73}, MOBY_COUNT={74}, UNIPOLE_COUNT={75}, LIGHTING_CONTROLS_COUNT={76}, MULTILEVEL='{77}', " +
" SID_ISLAND_GOOD='{78}', SID_ISLAND_FAIR='{79}', SID_ISLAND_POOR='{80}', PAVED_BY_MUNIC='{81}', NOT_PAVED_BY_DETAILS={82}, " +
" OWNED_BY_MUNIC='{83}', OWNED_DETAILS={84}, PAV_MARKERS_TRUE='{85}', MARKER_CERAMIC='{86}', MARKER_PAINT='{87}', PEDESTRIAN='{88}', " +
" PEDESTRIAN_BRIDGE_TYPE={89}, PEDESTRIAN_COUNT={90}, SECTION_BORDER_OTHER='{91}', OTHER_BORDER_DETAILS={92}, SURVEY_DATE={93}, GUIDE_SIGNS_COUNT={94}, " +
" DONE_BY={95}, LIGHT_GOOD_COUNT={96}, LIGHT_FAIR_COUNT={97}, LIGHT_POOR_COUNT={98} WHERE SECTION_ID={40} ",
SEC_DIRECTION, SEC_order, SEC_LENGTH, SEC_WIDTH, Shared.Bool2YN(houses), Shared.Bool2YN(publics), Shared.Bool2YN(commerial),
Shared.Bool2YN(gardens), Shared.Bool2YN(indisterial), Shared.Bool2YN(rest_house), Shared.Bool2YN(unpaved_True), unpaved_length, unpaved_Width, Shared.Bool2YN(mid_island_True),
midIslandWidth, Shared.Bool2YN(sideisland_True), sidIslandWidth, Shared.Bool2YN(side_Curb_True), sideCurbWidth, Shared.Bool2YN(LIGHTING_True), LIGHTING_LOC,
Shared.Bool2YN(brdg_TUNEL_true), brdg_tunel_type, Shared.Bool2YN(ag_mid_island_True), Shared.Bool2YN(ag_sid_island_True), Shared.Bool2YN(ag_sec_island_true),
Shared.Bool2YN(drinage_mh_true), drainageMhCount, Shared.Bool2YN(drinage_cb_true), drainageCbCount, Shared.Bool2YN(sewage_mh_true), sewageMhCount,
Shared.Bool2YN(Elect_mh_true), ElectMhCount, Shared.Bool2YN(stc_mh_true), stcMhCcount, Shared.Bool2YN(water_valve_true), waterValveCount,
Shared.Bool2YN(intersectOpenIsland), Shared.Bool2YN(intersectTrafficLight), sectionID, Shared.Bool2YN(drilling_stc), drillingStcLen, Shared.Bool2YN(drilling_elec),
drillingElecLen, Shared.Bool2YN(drilling_water), drillingWaterLen, Shared.Bool2YN(drilling_sewage), drillingSewageLen, Shared.Bool2YN(is_r4), Shared.Bool2YN(is_r3),
R4datePart, R3datePart, noPermitsTillDatePart, drainageCbFairPart, drainageCbPoorPart, drainageMhFairPart, drainageCbPoorPart,
ElectMhFairPart, ElectMhPoorPart, stcMhFairPart, stcMhPoorPart, sewageMhFairPart, sewageMhPoorPart, waterValveFairPart, waterValvePoorPart,
Shared.Bool2YN(midIslandGood), Shared.Bool2YN(midIslandFair), Shared.Bool2YN(midIslandPoor), Shared.Bool2YN(sideCurbGood), Shared.Bool2YN(sideCurbFair),
Shared.Bool2YN(sideCurbPoor), Shared.Bool2YN(propertyConflict), megacomPart, mobyPart, unipolePart, lightControlsPart, Shared.Bool2YN(multilevel),
Shared.Bool2YN(sideIslandGood), Shared.Bool2YN(sideIslandFair), Shared.Bool2YN(sideIslandPoor), Shared.Bool2YN(pavedbyMunic), pavedbyMunicDetails,
Shared.Bool2YN(ownedByMunic), ownedByMunicDetails, Shared.Bool2YN(markers), Shared.Bool2YN(ceramics), Shared.Bool2YN(paints), Shared.Bool2YN(hasPedestrainBridges),
bridgeTypePart, bridgesCountPart, Shared.Bool2YN(sectionBorderOther), sectionBorderDetails, surveyDatePart, guideSignsCountPart,
userID, lightGoodCountPart, lightFairCountPart, lightPoorCountPart);
int rows = db.ExecuteNonQuery(sql);
sql = string.Format("update SECTIONS set SEC_DIRECTION={0}, SEC_ORDER={1}, SEC_LENGTH={2}, SEC_WIDTH={3} WHERE SECTION_ID={4} ",
SEC_DIRECTION, SEC_order, SEC_LENGTH, SEC_WIDTH, sectionID);
rows += db.ExecuteNonQuery(sql);
Shared.SaveLogfile("SECTIONs", sectionID.ToString(), "Update Info", user);
return(rows > 0);
}
