Download - Initial Report (Housing)
-
7/29/2019 Initial Report (Housing)
1/127
INDEX
INTRODUCTION
Final Report (Housing module)
-
7/29/2019 Initial Report (Housing)
2/127
SRS
SDS
CODE
INTRODUCTION
The housing module is to render the block management with the proper specifications of everyhousing aspect in the block. It covers:(a) a description of the environment in which the application is expected to operate,(b) a definition of the applications capabilities, and(c) a specification of the applications functional and nonfunctional requirements.
-
7/29/2019 Initial Report (Housing)
3/127
Databases have been setup for each aspects introduced for future references.
Three level of approach has been brought forward in regards to handling of data- The BDO, theHigher Authority and the citizen. Their level of availability of data has been discussed in details in theSRS portion.
The maintenance division is responsible for development of the Google map attachment of all thesystem as to point out their exact location on the block and specify their details as well.
Other aspects have also been introduced which will be seen in the SRS and SDS division.
SRS
1. Introduction:
This is the Software Requirements Specification (SRS) for the Housing facilities under the construct of the Block Management
System. The documents purpose is to convey information about the applications requirements to the reader providing :
(a) a description of the environment in which the application is expected to operate,
-
7/29/2019 Initial Report (Housing)
4/127
(b) a definition of the applications capabilities, and
(c) a specification of the applications functional and nonfunctional requirements.
This document is intended to serve several types of readers:
First, it is anticipated that the SRS will be used by the citizens residing or willing to reside in the block. They will
use the information recorded here as the basis for meeting their demands to buy, rent or sell accommodations for bothresidential and commercial purposes.
Second, the District Magistrate or some higher officials will review the document to clarify their understanding of
what the application does and how it is being handled. Also, they will have an understanding of how their needs of
land and house overview as well as population distribution over various housing categories.
Third, the Block Development Officers Assistants will use this document to establish a basis for agreement between
the client and development team about the functionality to be provided by the application. It will give him/her a clear
idea regarding how to insert and update the records. They can also check that whether all the necessary fields against a
record have been properly dealt with or not.
Fourth, the test planners will use this document to derive test plans and test cases.
Finally, the project manager will use this document during project planning and monitoring.
Scope of Product:
The purpose of this software development project is to create a new application called: Block Management System and
handle the Housing constructs. The client for this project wishes to enter the specifications and get the desired results. The
application will provide the following capabilities:
This application will be accessed via a computer system with internet facility.
The citizens will use this application to get the required information about accommodation or land, that they wish to sell, buy
or rent for either residential and commercial purposes.
Insertion, updation and deletion of the records is the responsibility of the BDO assistants.
This application will be used by the BDO assistants to keep track of the houses and plots along with their types as well as
their transaction details.
This application will generate reports for administrative purposes for the BDO, DM and other higher level officials.
This application will provide search results based on certain specifications.
The project's client has determined that this application will provide the following benefits:
Provide additional flexibility and convenience to the citizen regarding their search and business.
Provide better reliability and security of the housing information under the block.
Provide a more productive environment for the BDO staff members along with the citizens.
Reduce the cost of operations for the housing business.
-
7/29/2019 Initial Report (Housing)
5/127
Reduce the complexities of the transactions involved.
Provide a categorized and well defined search facility.
People can advertise their property through this application.
2. Enhancement Request:
Use Case Diagrams:
2.1 B.D.O. Office:The requests by the user that are to be introduced into the system entirely.
To visualize the details geographically using GOOGLE EARTHincorporating factors like :
Housing Location for Residential purpose.
Housing Location for Commercial purpose.
In case of requirement of update details regarding properties following details should be
monitored :1. Ownership Update2. Property-type Update
-
7/29/2019 Initial Report (Housing)
6/127
2.2 Citizen:
To visualize the details geographically using GOOGLE EARTH incorporatingfactors like :
1. Housing Location for Residential purpose.2. Housing Location for Commercial purpose.
Use Case Diagrams:
A citizen can perform the following operations:i. For a given address, he/she can search & locate the exact position of any
property(residential or commercial).
2.3 Higher Authorities:
Use Case Diagrams:
To visualize the details geographically using GOOGLE EARTH incorporating factors like :
1. Housing Location for Residential purpose.2. Housing Location for Commercial purpose.
-
7/29/2019 Initial Report (Housing)
7/127
He/she can view accurate statistics filed in by the B.D.O. & listen the area or for some enquired information.
3. Problem Report:Some of the problems faced were:
1. Problems in Computers: Frequent problems in computer were also one of the hindrances in our path such
as Insufficient RAM (which made the computer slow)
External Interface Requirement:
-
7/29/2019 Initial Report (Housing)
8/127
Hardware Interfaces:
The required hardware is:
Intel(R) Pentium CPU
2.80 GHz128 MB of RAM or more.
Software Interfaces:
ASP-.Net and Oracle 9i.
Communications Interfaces:
Following protocol is needed for communication purpose:
Hyper Text Transfer Protocol (HTTP).
Operating Environment:This project is developed on the following platform:
Windows XP professional.
SDS
SOFTWARE DESIGN SPECIFICATION
For
HOUSING
Under
THE BLOCK MANAGEMENT SYSTEM
-
7/29/2019 Initial Report (Housing)
9/127
1. Introduction:
This is the Software Design Specification (SDS) for the Housing facilities under
the construct of the Block Management System. The documents purpose is to convey
information about the applications requirements to the reader providing :(a) a description of the environment in which the application is expected to
operate,
(b) a definition of the applications capabilities, and(c) a specification of the applications functional and nonfunctional requirements.
This document is intended to serve several types of readers:
First, it is anticipated that the SDS will be used by the citizens residingor willing to reside in the block. They will use the information recorded here asthe basis for meeting their demands to buy, rent or sell accommodations for both
residential and commercial purposes.
Second, the District Magistrate or some higher officials will reviewthe document to clarify their understanding of what the application does and how itis being handled. Also, they will have an understanding of how their needs of land
and house overview as well as population distribution over various housing
categories.
Third, the Block Development Officers Assistants will use thisdocument to establish a basis for agreement between the client and developmentteam about the functionality to be provided by the application. It will give him/her a
clear idea regarding how to insert and update the records. They can also check that
whether all the necessary fields against a record have been properly dealt with or
-
7/29/2019 Initial Report (Housing)
10/127
not.
Fourth, the test planners will use this document to derive test plans andtest cases.
Finally, the project manager will use this document during projectplanning and monitoring.
Scope of Product:
The purpose of this software development project is to create a new application called: Block
Management System and handle the Housing constructs. The client for this project wishes to enterthe specifications and get the desired results. The application will provide the following capabilities:
This application will be accessed via a computer system with internet facility.
The citizens will use this application to get the required information about accommodation or land,that they wish to sell, buy or rent for either residential and commercial purposes.
Insertion, updation and deletion of the records is the responsibility of the BDO assistants.
This application will be used by the BDO assistants to keep track of the houses and plots along
with their types as well as their transaction details.
This application will generate reports for administrative purposes for the BDO, DM and otherhigher level officials.
This application will provide search results based on certain specifications.
The project's client has determined that this application will provide the following benefits:
Provide additional flexibility and convenience to the citizen regarding their search and business.
Provide better reliability and security of the housing information under the block.
Provide a more productive environment for the BDO staff members along with the citizens.
Reduce the cost of operations for the housing business.
-
7/29/2019 Initial Report (Housing)
11/127
Reduce the complexities of the transactions involved.
Provide a categorized and well defined search facility.
People can advertise their property through this application.
SITEMAPS :
SITE MAP for BMS HOUSING
BDO
Maintenance
Commercial
Institutional
Residential
D frmMaintainResiInfo.aspx
frmMaintainCommInfo.aspx
frmMaintainIndustrialInfo.aspx
frmMaintainInstInfo.aspx
Industrial
frmMaintainLandInfo.aspx
Land info
frmMaintainAddInfo.aspx
Advertisement
frmHOTransactionBuySell.aspxfrmHOTransactionRentLease.aspxBuy/Sell
TransactionsRent/Lease
Transactions
-
7/29/2019 Initial Report (Housing)
12/127
FIELDS FORM NAME DETAILS
Residential frmMaintainResiInfo.aspx BDO maintains (insert,update, delete) ResidentialProperty information
Commercial frmMaintainCommInfo.aspx BDO maintains CommercialProperty information
Industrial frmMaintainIndustrialInfo.aspx BDO maintains IndustrialProperty information
Institutional frmMaintainInstInfo.aspx BDO maintains InstitutionalProperty information
Land info frmMaintainLandInfo.aspx BDO maintains Landinformation
Advertisement frmMaintainAddInfo.aspx BDO maintainsAdvertisement information
Buy/Sell Transactions frmHOTransactionBuySell.aspx BDO maintains Buy/SellTransaction information
Rent/Lease Transactions frmHOTransactionRentLease.aspx BDO maintains Rent/LeaseTransaction information
BDO main page frmHOGoogleBDO.aspx BDO selects from the pop-up
menu and performs thedesired actions on any pointin the map drawn which are asfollows:i. Selects an area and makesnecessary changes based onrequirement.ii. Marks any area in the map
-
7/29/2019 Initial Report (Housing)
13/127
& declares it as a property ofa certain type
CITIZEN View
E
ResidentialfrmResiCitz.aspx frmViewCitz1.aspx
CommercialfrmCommCitz.aspx frmViewCitz2.aspx
IndustrialfrmIndustryCitz.aspx frmViewCitz3.aspx
Institutional
frmInstituteCitz.aspx frmViewCitz4.aspx
frmViewCitz5.aspx
AdvertisementSearch
frmAdvertisementCitz.aspx
frmViewLandInfo.aspx
Land Information
-
7/29/2019 Initial Report (Housing)
14/127
FIELDS FORM NAME DETAILS
Residential frmResiCitz.aspx CITIZEN views ResidentialProperty information
Commercial frmCommCitz.aspx CITIZEN views CommercialProperty information
Industrial frmIndustryCitz.aspx CITIZEN views IndustrialProperty information.
Institutional frmInstituteCitz.aspx CITIZEN views InstitutionalProperty information
Land Information frmViewLandInfo.aspx CITIZEN views Landinformation
Advertisement Search frmAdvertisementCitz.aspx CITIZEN views PropertiesAdvertisements
DM View
higher_official_overview.aspx
Residential, Commercial,Industrial, Institutional
F
-
7/29/2019 Initial Report (Housing)
15/127
2. Forms:
1.B.D.O offices visualization:
FIELDS FORM NAME DETAILS
Residential,Commercial,
Industrial, Institutional
higher_official_overview.aspx DM can view Residential,Commercial, Industrial,
Institutional PropertyInformation for a Block.
-
7/29/2019 Initial Report (Housing)
16/127
2.Citizens Visualization:
-
7/29/2019 Initial Report (Housing)
17/127
3. DMs Visualization:
-
7/29/2019 Initial Report (Housing)
18/127
4. View Advertisement Information:
-
7/29/2019 Initial Report (Housing)
19/127
5. View Land Information:
-
7/29/2019 Initial Report (Housing)
20/127
6. Citizen Main Page:
-
7/29/2019 Initial Report (Housing)
21/127
7. Citizen Main Search Page:
-
7/29/2019 Initial Report (Housing)
22/127
8. Citizen Welcome Page:
-
7/29/2019 Initial Report (Housing)
23/127
9. View Commercial Property Information:
-
7/29/2019 Initial Report (Housing)
24/127
10. Commercial Property Search Page:
-
7/29/2019 Initial Report (Housing)
25/127
11. Delete Advertisement Information:
-
7/29/2019 Initial Report (Housing)
26/127
12. Delete Commercial Property Information:
-
7/29/2019 Initial Report (Housing)
27/127
13. Delete Industrial Property Information:
-
7/29/2019 Initial Report (Housing)
28/127
14. Delete Institutional Property Information:
-
7/29/2019 Initial Report (Housing)
29/127
15. Delete Land Information:
-
7/29/2019 Initial Report (Housing)
30/127
16. Delete Residential Property Information:
-
7/29/2019 Initial Report (Housing)
31/127
17. Commercial Occupancy Information:
-
7/29/2019 Initial Report (Housing)
32/127
18. Industrial Occupancy Information:
-
7/29/2019 Initial Report (Housing)
33/127
19. Residential Occupancy Information:
-
7/29/2019 Initial Report (Housing)
34/127
20. Transaction Buy/Sell Details:
-
7/29/2019 Initial Report (Housing)
35/127
21. Transaction Rent/Lease Details:
-
7/29/2019 Initial Report (Housing)
36/127
22. Industrial Property Search Page:
-
7/29/2019 Initial Report (Housing)
37/127
23. View Industrial Property Information:
-
7/29/2019 Initial Report (Housing)
38/127
24. Insert Advertisement Information:
-
7/29/2019 Initial Report (Housing)
39/127
25. Insert Commercial Property Information:
-
7/29/2019 Initial Report (Housing)
40/127
26. Insert Industrial Property Information:
-
7/29/2019 Initial Report (Housing)
41/127
27. Insert Institutional Property Information:
-
7/29/2019 Initial Report (Housing)
42/127
28. Insert Land Information:
-
7/29/2019 Initial Report (Housing)
43/127
29. Insert Residential Property Information:
-
7/29/2019 Initial Report (Housing)
44/127
30. View Institutional Property Information:
-
7/29/2019 Initial Report (Housing)
45/127
31. Institutional Property Search Page:
-
7/29/2019 Initial Report (Housing)
46/127
32. Maintain Advertisement Information:
-
7/29/2019 Initial Report (Housing)
47/127
33. Maintain Commercial Property Information:
-
7/29/2019 Initial Report (Housing)
48/127
34. Maintain Industrial Property Information:
-
7/29/2019 Initial Report (Housing)
49/127
35. Maintain Institutional Property Information:
-
7/29/2019 Initial Report (Housing)
50/127
36. Maintain Land Information:
-
7/29/2019 Initial Report (Housing)
51/127
37. Maintain Residential Property Information:
-
7/29/2019 Initial Report (Housing)
52/127
38. View Residential Property Information:
-
7/29/2019 Initial Report (Housing)
53/127
39. Residential Property Search Page:
-
7/29/2019 Initial Report (Housing)
54/127
40. Update Advertisement Information:
-
7/29/2019 Initial Report (Housing)
55/127
41. Update Industrial Property Information:
-
7/29/2019 Initial Report (Housing)
56/127
42. Update Institutional Property Information:
-
7/29/2019 Initial Report (Housing)
57/127
43. Update Land Information:
-
7/29/2019 Initial Report (Housing)
58/127
44. Update Residential Property Information:
-
7/29/2019 Initial Report (Housing)
59/127
45. View Advertisement Details:
-
7/29/2019 Initial Report (Housing)
60/127
46. View Commercial Property Information (Citizen):
-
7/29/2019 Initial Report (Housing)
61/127
47. View Industrial Property Information (Citizen):
-
7/29/2019 Initial Report (Housing)
62/127
48. View Institutional Property Information (Citizen):
-
7/29/2019 Initial Report (Housing)
63/127
49. View Land Information (Citizen):
-
7/29/2019 Initial Report (Housing)
64/127
50. View Commercial Property Information:
-
7/29/2019 Initial Report (Housing)
65/127
51. View Industrial Property Information:
-
7/29/2019 Initial Report (Housing)
66/127
52. View Institutional Property Information:
-
7/29/2019 Initial Report (Housing)
67/127
53. View Land Information:
-
7/29/2019 Initial Report (Housing)
68/127
54. View Residential Property Information:
-
7/29/2019 Initial Report (Housing)
69/127
55. View Residential Property Information (Citizen):
-
7/29/2019 Initial Report (Housing)
70/127
3. Database Design:
-
7/29/2019 Initial Report (Housing)
71/127
Tables:
-
7/29/2019 Initial Report (Housing)
72/127
1. HO_ad_table
COLUMN NAME DESCRIPTION
house_prop_id Property identification number
ad_date Date of Advertisement
prop_type Type of propertyCost Cost
Address Address
Area Area
ad_for Advertisement For sale,rent,pg or lease
Rent Rent cost
acc_type Accomodation Type
lease_duration Time for lease duration
trans_through Transaction through
Property_desc Property description
contact_details Contacting details
2. HO_residential_main
COLUMN NAME DESCRIPTION
house_id House identification number
house_type House type
house_desc House description
Address Address
Yoc Year of construction
no_storey No of storeysArea Area
3. HO_residential_occupants
COLUMN NAME DESCRIPTION
house_id House identification number
date_of_occupancy Date from which Occupied
occupants_details Details of occupants
no_occupants Number of occupantsoccupancy_type Type of occupant
owner_details Owner details
4. HO_commercial_main
COLUMN NAME DESCRIPTION
prop_id Property identification number
-
7/29/2019 Initial Report (Housing)
73/127
prop_type Type of property
Address Address
Yoc Year of construction
no_storey Number of storeys
Area Area
5. HO_commercial_occupants
COLUMN NAME DESCRIPTION
prop_id Property identification number
date_of_occupancy Date from which occupied
owner_details Owner details
owner_type Type of owner
current_holder Current holder of the property
lease_period Time for lease
lease_amt Money for the lease
6. HO_landinfo_table
COLUMN NAME DESCRIPTION
id_no Identification number
region_code_ Code for a region
block_code Code for a block
plot_number Unique identification number for a plot
Address Address
Area Areaconst_type
owner_details Owner details
7. HO_instituteinfo_table
COLUMN NAME DESCRIPTION
-
7/29/2019 Initial Report (Housing)
74/127
Id_no Identification numer
inst_type Institute type
inst_desc Institute description
Address Address
Yoc Year of constructionArea Area
owner_details Owner details
no_storey Number of storeys
8. HO_industrialinfo_main
COLUMN NAME DESCRIPTION
Id_no Identification numer
Property_type Type of property
Property_desc Property description
Address Address
Area Area
Yoc Year of construction
9. HO_industrial_occupancy
COLUMN NAME DESCRIPTION
Id_no Identification number
date_of_occupancy Date from which occupied
curr_occu_details Current occupants detailsoccu_type Type of occupant
owner_details Owner details
no_of_occupants No. of occupants
10. HO_transaction_buy_sell
COLUMN NAME DESCRIPTION
trans_id Unique transaction id
prop_id Unique property id
trans_date Date of Transactionprev_owner Details of Previous Owner
New_owner Details of new owner
11. HO_transaction_rent_lease
COLUMN NAME DESCRIPTION
trans_id Unique transaction id
-
7/29/2019 Initial Report (Housing)
75/127
prop_id Unique property id
start_date_rent Date from which rented
owner_details Details of Owner
tenant_details Details of Tenant
12. HO_Object_Position
COLUMN NAME DESCRIPTION
lati Unique latitude of marked property
lngi Unique longitude of marked property
mode Types of Property
4.Development Matrix:
-
7/29/2019 Initial Report (Housing)
76/127
CodingForm Name: frmHOGoogleBDO
Coding
Sl.No.
Form Name CodingResponsibility
TestingResponsibilit
y
1. frmLogin.aspx R.K. S.P.2. frmAdmin.aspx S.S. R.K.3. frmUserReg.aspx S.A.C. S.S.4. frmCitizen.aspx S.B. S.A.C.5. frmDM.aspx S.P. S.B.6. frmBMSmenuBDO.aspx R.K. S.P.7. frmHOGoogleBDO.aspx R.K. R.K.8. frmBMSLogout.aspx S.A.C. S.S.9. frmDistblckSelection.aspx S.B. S.A.C.
10. frmBMSmenuCitizen.aspx S.P. S.B.11. frmBMSmenuDM.aspx R.K. S.P.12. frmMaintainResiInfo.aspx S.S. R.K.13. frmMaintainCommInfo.aspx S.A.C. S.S.14. frmMaintainIndustrialInfo.aspx S.B. S.A.C.15. frmMaintainInstInfo.aspx S.P. S.B.16. frmMaintainLandInfo.aspx R.K. S.P.17. frmMaintainAddInfo.aspx S.S. R.K.18. frmHOTransactionBuySell.aspx S.A.C. S.S.19. frmHOTransactionRentLease.aspx
S.B. S.A.C.20. frmResiCitz.aspx S.P. S.B.21. frmCommCitz.aspx R.K. S.P.22. frmIndustryCitz.aspx S.S. R.K.23. frmInstituteCitz.aspx S.A.C. S.S.24. frmViewLandInfo.aspx S.B. S.A.C.25. frmAdvertisementCitz.aspx S.P. S.B.26. higher_official_overview.aspx R.K. S.P.
-
7/29/2019 Initial Report (Housing)
77/127
BLOCK MANAGEMENT SYSTEM
var center = new GLatLng(22.183, 88.233);var map;
var type;
function initialize(){
if (GBrowserIsCompatible()){
map = new GMap2(document.getElementById("map_canvas"));map.addControl(new GOverviewMapControl());
map.enableDoubleClickZoom();map.enableScrollWheelZoom();
map.addControl(new GMapTypeControl());map.addControl(new GLargeMapControl());map.setCenter(center, 10);
}}
function marker(){
var marker = new GMarker(center, {draggable: true});GEvent.addListener(marker, "dragstart",
function(){
marker.openInfoWindowHtml("Drag the marker wherever you want andclick on it to plot to the map");
}
);GEvent.addListener(marker, "dragend",
function(){
lati = marker.getPoint().lat();lngi = marker.getPoint().lng();marker.openInfoWindowHtml("Latitute: "+lati+"
Longitude: "+lngi);});
GEvent.addListener(marker, "click",
-
7/29/2019 Initial Report (Housing)
78/127
function(){
lati = marker.getPoint().lat();lngi = marker.getPoint().lng();type = "Residential Property";map.removeOverlay(marker);
var point=new GPoint(lngi, lati) var i = new GIcon(G_DEFAULT_ICON, "resi.png");
i.iconSize = new GSize(12,20);i.iconAnchor = new GPoint(6, 20);i.shadowSize = new GSize(12,20);
var m = new GMarker(point,{icon: i});map.addOverlay(m);
GEvent.addListener(m, "mouseover",
function(){lati = m.getPoint().lat();lngi = m.getPoint().lng();
m.openInfoWindowHtml();m.openInfoWindowTabsHtml(
[new GInfoWindowTab("Position",'Residential PropertyPosition Details:
'+"Latitute: "+lati+"
Longitude: "+lngi),new GInfoWindowTab("Maintain Data",'Select task forResidential Property:
'+'Insert
'+'Update
'+'Delete
')],{maxUrl:"http://abhishek.sur.googlepages.com"});}
);}
);
map.addOverlay(marker);}
function marker1(){
var marker = new GMarker(center, {draggable: true});GEvent.addListener(marker, "dragstart",
function(){
marker.openInfoWindowHtml("Drag the marker wherever you want andclick on it to plot to the map");
}
);GEvent.addListener(marker, "dragend",
function(){
lati = marker.getPoint().lat();lngi = marker.getPoint().lng();marker.openInfoWindowHtml("Latitute: "+lati+"
Longitude: "+lngi);});
GEvent.addListener(marker, "click",
-
7/29/2019 Initial Report (Housing)
79/127
function(){
lati = marker.getPoint().lat();lngi = marker.getPoint().lng();map.removeOverlay(marker);type = "Commercial Property";
var point=new GPoint(lngi, lati)
var i = new GIcon(G_DEFAULT_ICON, "comm.png");i.iconSize = new GSize(12,20);i.iconAnchor = new GPoint(6, 20);i.shadowSize = new GSize(12,20);
var m = new GMarker(point,{icon: i});map.addOverlay(m);
GEvent.addListener(m, "mouseover",
function(){lati = m.getPoint().lat();lngi = m.getPoint().lng();
m.openInfoWindowHtml();m.openInfoWindowTabsHtml(
[new GInfoWindowTab("Position",'Commercial PropertyPosition Details:
'+"Latitute: "+lati+"
Longitude: "+lngi),new GInfoWindowTab("Maintain Data",'Select task forCommercial Property:
'+'Insert
'+'Update
'+'Delete
')],{maxUrl:"http://abhishek.sur.googlepages.com"});}
);}
);
map.addOverlay(marker);}
function marker2(){
var marker = new GMarker(center, {draggable: true});GEvent.addListener(marker, "dragstart",
function(){
marker.openInfoWindowHtml("Drag the marker wherever you want andclick on it to plot to the map");
}
);GEvent.addListener(marker, "dragend",
function(){
lati = marker.getPoint().lat();lngi = marker.getPoint().lng();marker.openInfoWindowHtml("Latitute: "+lati+"
Longitude: "+lngi);});
GEvent.addListener(marker, "click",
-
7/29/2019 Initial Report (Housing)
80/127
function(){
lati = marker.getPoint().lat();lngi = marker.getPoint().lng();map.removeOverlay(marker);type = "Industrial Property";
var point=new GPoint(lngi, lati)
var i = new GIcon(G_DEFAULT_ICON, "ind.png");i.iconSize = new GSize(12,20);i.iconAnchor = new GPoint(6, 20);i.shadowSize = new GSize(12,20);
var m = new GMarker(point,{icon: i});map.addOverlay(m);
GEvent.addListener(m, "mouseover",
function(){lati = m.getPoint().lat();lngi = m.getPoint().lng();
m.openInfoWindowHtml();m.openInfoWindowTabsHtml(
[new GInfoWindowTab("Position",'Industrial PropertyPosition Details:
'+"Latitute: "+lati+"
Longitude: "+lngi),new GInfoWindowTab("Maintain Data",'Select task forIndustrial Property:
'+'Insert
'+'Update
'+'Delete
')],{maxUrl:"http://abhishek.sur.googlepages.com"});}
);}
);
map.addOverlay(marker);}
function marker3(){
var marker = new GMarker(center, {draggable: true});GEvent.addListener(marker, "dragstart",
function(){
marker.openInfoWindowHtml("Drag the marker wherever you want andclick on it to plot to the map");
}
);GEvent.addListener(marker, "dragend",
function(){
lati = marker.getPoint().lat();lngi = marker.getPoint().lng();marker.openInfoWindowHtml("Latitute: "+lati+"
Longitude: "+lngi);});
GEvent.addListener(marker, "click",
-
7/29/2019 Initial Report (Housing)
81/127
function(){
lati = marker.getPoint().lat();lngi = marker.getPoint().lng();map.removeOverlay(marker);type = "Institutional Property";
var point=new GPoint(lngi, lati)
var i = new GIcon(G_DEFAULT_ICON, "ins.png");i.iconSize = new GSize(12,20);i.iconAnchor = new GPoint(6, 20);i.shadowSize = new GSize(12,20);
var m = new GMarker(point,{icon: i});map.addOverlay(m);
GEvent.addListener(m, "mouseover",
function(){lati = m.getPoint().lat();lngi = m.getPoint().lng();
m.openInfoWindowHtml();m.openInfoWindowTabsHtml(
[new GInfoWindowTab("Position",'Institutional PropertyPosition Details:
'+"Latitute: "+lati+"
Longitude: "+lngi),new GInfoWindowTab("Maintain Data",'Select task forInstitutional Property:
'+'Insert
'+'Update
'+'Delete
')],{maxUrl:"http://abhishek.sur.googlepages.com"});}
);}
);
map.addOverlay(marker);}
function marker4(){
var lat=22.25; var lon=88.20; var poly = new GPolygon([ new GLatLng(lat, lon - 0.05),
new GLatLng(lat + 0.02, lon - 0.02),new GLatLng(lat + 0.06, lon),new GLatLng(lat + 0.08, lon + 0.06),
new GLatLng(lat + 0.03, lon + 0.05),new GLatLng(lat, lon + 0.10),new GLatLng(lat - 0.07, lon + 0.05),new GLatLng(lat - 0.05, lon + 0.02),new GLatLng(lat - 0.10, lon - 0.01),new GLatLng(lat - 0.09, lon - 0.07),new GLatLng(lat, lon - 0.05)],
"#f33f00", 5, 1, "#ff0000", 0.2);map.addOverlay(poly);// Creating a new marker
-
7/29/2019 Initial Report (Housing)
82/127
var marker = new GMarker(center, {draggable: false});// Adding a click-event to the markerGEvent.addListener(marker, 'click', function() {map.removeOverlay(marker);
// Create an array that will hold the tabsvar tabs = [];// Create tabs and add them to the arraytabs.push(new GInfoWindowTab('Maintain Data','Select task for Maintaining
Land Information :
'+'Insert
'+'Update
'+'Delete
'));//tabs.push(new GInfoWindowTab('Tab 2', 'Content of tab 2'));// Add tabs to the InfowWindowmarker.openInfoWindowTabsHtml(tabs);
});// Add marker to mapmap.addOverlay(marker);
}
function marker5(){
// Creating a new markervar marker = new GMarker(center, {draggable: false});
// Adding a click-event to the marker
GEvent.addListener(marker, 'click', function() {lati = marker.getPoint().lat();lngi = marker.getPoint().lng();map.removeOverlay(marker);
var point=new GPoint(lngi, lati) var i = new GIcon(G_DEFAULT_ICON, "advt.png");
i.iconSize = new GSize(12,20);i.iconAnchor = new GPoint(6, 20);i.shadowSize = new GSize(12,20);
var m = new GMarker(point,{icon: i});map.addOverlay(m);
// Create an array that will hold the tabs
var tabs = [];// Create tabs and add them to the array
tabs.push(new GInfoWindowTab('Maintain Data','Select task forAdvertisements:
'+'Insert
'+'Update
'+'Delete
'));//tabs.push(new GInfoWindowTab('Tab 2', 'Content of tab 2'));
// Add tabs to the InfowWindowmarker.openInfoWindowTabsHtml(tabs);});
// Add marker to mapmap.addOverlay(marker);
}
function marker6(){
// Creating a new marker
-
7/29/2019 Initial Report (Housing)
83/127
var marker = new GMarker(center, {draggable: false});// Adding a click-event to the markerGEvent.addListener(marker, 'click', function() {lati = marker.getPoint().lat();lngi = marker.getPoint().lng();map.removeOverlay(marker);
var point=new GPoint(lngi, lati) var i = new GIcon(G_DEFAULT_ICON, "trans.png");
i.iconSize = new GSize(12,20);i.iconAnchor = new GPoint(6, 20);i.shadowSize = new GSize(12,20);
var m = new GMarker(point,{icon: i});map.addOverlay(m);
// Create an array that will hold the tabsvar tabs = [];// Create tabs and add them to the arraytabs.push(new GInfoWindowTab('Buy/Sell','Buy/Sell TransactionDetails
'));tabs.push(new GInfoWindowTab('Rent/Lease','Rent/Lease TransactionDetails
'));// Add tabs to the InfowWindowmarker.openInfoWindowTabsHtml(tabs);});// Add marker to mapmap.addOverlay(marker);
}
function btnsave1_onclick() {document.getElementById('Text1').value = lati;document.getElementById('Text2').value = lngi;
}
function btnSave_onclick() {var xmlHttpObject = null;
try{
// Firefox, Opera 8.0+, Safari...xmlHttpObject = new XMLHttpRequest();
} catch(ex)
{ // Internet Explorer... try
{xmlHttpObject = new ActiveXObject('Msxml2.XMLHTTP');
} catch(ex)
{xmlHttpObject = new ActiveXObject('Microsoft.XMLHTTP');
}}
if (xmlHttpObject == null)
-
7/29/2019 Initial Report (Housing)
84/127
{window.alert('AJAX is not available in this browser');
}
xmlHttpObject.open("GET", "SaveToDb.aspx?Lati=" + lati + "&Lngi=" +lngi+"&type="+type, false);
window.alert("DATA SAVED!?Lati=" + lati + "&Lngi=" + lngi);xmlHttpObject.send();
}
-
7/29/2019 Initial Report (Housing)
85/127
Style="z-index: 104; left: 367px; position: relative; top: 39px"Text="Username :" Width="68px"> LOGOUT Check
-
7/29/2019 Initial Report (Housing)
86/127
-
7/29/2019 Initial Report (Housing)
87/127
Form Name: frmHODataRetrieve.aspx
-
7/29/2019 Initial Report (Housing)
88/127
Coding
BLOCK MANAGEMENT SYSTEM
-
7/29/2019 Initial Report (Housing)
89/127
LOGOUT
Form Name: frmHODataRetrieve.aspx.cs
-
7/29/2019 Initial Report (Housing)
90/127
using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Collections.Generic;using System.Text;using System.Data.SqlClient;
publicpartialclassuser1 : System.Web.UI.Page{ string[] strArray; string[] strArray1; double[] intArray;
double[] intArray1; StringBuilder sb = newStringBuilder(); StringBuilder sb1 = newStringBuilder();
protectedvoid Page_Load(object sender, EventArgs e){
intArray = newdouble[50];intArray1 = newdouble[50];strArray = newstring[50];strArray1 = newstring[50];
try{
SqlConnection conn1 = newSqlConnection(@"Server=mcom14;Database=BMS;UID=sa;Password=lab3";);
conn1.Open();
string sql1 = "SELECT lati,lngi,mode FROM HO_Object_Position"; SqlCommand cmd1 = newSqlCommand(sql1, conn1); SqlDataReader dr1 = cmd1.ExecuteReader();
int k = 0;int j = 0;
int n = 0;
while (dr1.Read())
{
if (dr1[0] != System.DBNull.Value){
intArray[j] = Convert.ToDouble(dr1[0].ToString());
} else
{intArray[j] = 0.00;
-
7/29/2019 Initial Report (Housing)
91/127
}
if (dr1[1] != System.DBNull.Value){
intArray1[j] = Convert.ToDouble(dr1[1].ToString());}
else{
intArray1[j] = 0.00;}
if (dr1[2] != System.DBNull.Value)strArray[j] = dr1[2].ToString();
elsestrArray[j] = "";
j++;k++;n++;
}
dr1.Close();conn1.Close();
sb1.Append("\n");
string str, str1, str2;
for (int i = 1; i
-
7/29/2019 Initial Report (Housing)
92/127
if (String.Compare(strArray[i - 1], "Industrial Property") ==0)
{sb1.Append(" = new
GIcon(G_DEFAULT_ICON, \"ind.png\");\n");}
else if (String.Compare(strArray[i - 1], "InstitutionalProperty") == 0)
{sb1.Append(" = new
GIcon(G_DEFAULT_ICON, \"ins.png\");\n");}
sb1.Append(str1+".iconSize = new GSize(12,20);\n");sb1.Append(str1+".iconAnchor = new GPoint(6, 20);\n");
sb1.Append(str1+".shadowSize = new GSize(12,20);\n");
sb1.Append("var ");
str2 = "m" + i.ToString();sb1.Append(str2);sb1.Append(" = new GMarker(");sb1.Append(str + ",{icon: " + str1);sb1.Append("});\n");
sb1 .Append("map.addOverlay(");sb1.Append(str2);sb1.Append(");\n");
}
sb.Append("\n"); // sb.AppendFormat("var myVar = {0};\n", sb1.ToString());
sb.AppendFormat("var myVar1 = {0};\n", intArray[0]);sb.AppendFormat("var myVar2 = {0};\n", intArray1[0]);
// sb.Append("var center; \n"); // sb.Append("var map; \n");
sb.Append("function load()\n");sb.Append("{ \n");sb.Append(" if (GBrowserIsCompatible())");sb.Append("{ \n");sb.Append("var map = new GMap2(document.getElementById(\"map\")); \n");sb.Append("map.addControl(new GOverviewMapControl()); \n");
sb.Append("map.enableDoubleClickZoom(); \n");sb.Append("map.enableScrollWheelZoom(); \n");
sb.Append("map.addControl(new GMapTypeControl()); \n");sb.Append("map.addControl(new GLargeMapControl()); \n");sb.Append("map.addControl(new GOverviewMapControl()); \n");sb.Append("map.setCenter(new GLatLng(myVar1, myVar2), 10); \n");
// sb.Append("var poly = myVar; \n"); // sb.Append("map.addOverlay(poly); \n");
sb.AppendFormat("{0} \n", sb1.ToString());sb.Append("} \n");
-
7/29/2019 Initial Report (Housing)
93/127
sb.Append("} \n");sb.Append("\n");
ClientScript.RegisterClientScriptBlock(GetType(), "load", sb.ToString());
} catch (SqlException ex)
{Response.Write("error" + ex);
}}
}
Form Name: frmHOGoogleCitizen.aspx
-
7/29/2019 Initial Report (Housing)
94/127
-
7/29/2019 Initial Report (Housing)
95/127
{maxUrl:"http://abhishek.sur.googlepages.com"});});map.addOverlay(poly);
}
LOGOUT
-
7/29/2019 Initial Report (Housing)
96/127
Form Name: frmHOGoogleCitizen.aspx.cs
using System;using System.Data;
-
7/29/2019 Initial Report (Housing)
97/127
using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Collections.Generic;using System.Text;using System.Data.SqlClient;
publicpartialclassuser1 : System.Web.UI.Page{ string[] strArray; string[] strArray1; double[] intArray; double[] intArray1; StringBuilder sb = newStringBuilder();
StringBuilder sb1 = newStringBuilder(); SqlConnection con = newSqlConnection("Server=mcom14;Database=BMS;UID=sa;Password=lab3;");
protectedvoid Page_Load(object sender, EventArgs e){
intArray = newdouble[50];intArray1 = newdouble[50];strArray = newstring[50];strArray1 = newstring[50];
try{
SqlConnection conn1 = newSqlConnection(@"Server=mcom14;Database=BMS;UID=sa;Password=lab3;");
conn1.Open();
string sql1 = "SELECT lati,lngi,mode FROM HO_Object_Position"; SqlCommand cmd1 = newSqlCommand(sql1, conn1); SqlDataReader dr1 = cmd1.ExecuteReader();
int k = 0;int j = 0;
int n = 0;
while (dr1.Read()){
if (dr1[0] != System.DBNull.Value){
intArray[j] = Convert.ToDouble(dr1[0].ToString());
} else
{intArray[j] = 0.00;
}
-
7/29/2019 Initial Report (Housing)
98/127
if (dr1[1] != System.DBNull.Value){
intArray1[j] = Convert.ToDouble(dr1[1].ToString());}
else{
intArray1[j] = 0.00;}
if (dr1[2] != System.DBNull.Value)strArray[j] = dr1[2].ToString();
elsestrArray[j] = "";
j++;k++;n++;
}
dr1.Close();
conn1.Close();
sb1.Append("\n");
string str, str1, str2;
for (int i = 1; i
-
7/29/2019 Initial Report (Housing)
99/127
if (String.Compare(strArray[i - 1], "Industrial Property") ==0)
{sb1.Append(" = new
GIcon(G_DEFAULT_ICON, \"ind.png\");\n");}
else if (String.Compare(strArray[i - 1], "InstitutionalProperty") == 0)
{sb1.Append(" = new
GIcon(G_DEFAULT_ICON, \"ins.png\");\n");}
sb1.Append(str1+".iconSize = new GSize(12,20);\n");sb1.Append(str1+".iconAnchor = new GPoint(6, 20);\n");
sb1.Append(str1+".shadowSize = new GSize(12,20);\n");
sb1.Append("var ");
str2 = "m" + i.ToString();sb1.Append(str2);sb1.Append(" = new GMarker(");sb1.Append(str + ",{icon: " + str1);sb1.Append("});\n");
sb1 .Append("map.addOverlay(");sb1.Append(str2);sb1.Append(");\n");
}
sb.Append("\n"); // sb.AppendFormat("var myVar = {0};\n", sb1.ToString());
sb.AppendFormat("var myVar1 = {0};\n", intArray[0]);sb.AppendFormat("var myVar2 = {0};\n", intArray1[0]);
// sb.Append("var center; \n"); // sb.Append("var map; \n");
sb.Append("function load()\n");sb.Append("{ \n");sb.Append(" if (GBrowserIsCompatible())");sb.Append("{ \n");sb.Append("var map = new GMap2(document.getElementById(\"map\")); \n");sb.Append("map.addControl(new GOverviewMapControl()); \n");
sb.Append("map.enableDoubleClickZoom(); \n");sb.Append("map.enableScrollWheelZoom(); \n");
sb.Append("map.addControl(new GMapTypeControl()); \n");sb.Append("map.addControl(new GLargeMapControl()); \n");sb.Append("map.addControl(new GOverviewMapControl()); \n");sb.Append("map.setCenter(new GLatLng(myVar1, myVar2), 10); \n");
// sb.Append("var poly = myVar; \n"); // sb.Append("map.addOverlay(poly); \n");
sb.AppendFormat("{0} \n", sb1.ToString());sb.Append("} \n");
-
7/29/2019 Initial Report (Housing)
100/127
sb.Append("} \n");sb.Append("\n");
ClientScript.RegisterClientScriptBlock(GetType(), "load", sb.ToString());
if (this.IsPostBack != true){
SqlCommand cmd = newSqlCommand("select distinct District_name fromAD_District", con); SqlDataAdapter adpt = newSqlDataAdapter(cmd); DataSet ds = newDataSet();
con.Open();adpt.Fill(ds);con.Close();DropDownList1.DataSource = ds.Tables[0];DropDownList1.DataTextField = "District_name";DropDownList1.DataValueField = "District_name";DropDownList1.DataBind();
}}
catch (SqlException ex){
Response.Write("error" + ex);}
} protectedvoid DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{ SqlCommand cmd = newSqlCommand("select distinct Block_name from AD_Blockwhere District_cd in (select District_cd from AD_District where District_name like '"+ DropDownList1.SelectedValue + "')", con); SqlDataAdapter adpt = newSqlDataAdapter(cmd); DataSet ds = newDataSet();
con.Open();adpt.Fill(ds);con.Close();DropDownList2.DataSource = ds.Tables[0];DropDownList2.DataTextField = "Block_name";DropDownList2.DataValueField = "Block_name";DropDownList2.DataBind();
}}
Form Name: frmHOGoogleDM.aspx
-
7/29/2019 Initial Report (Housing)
101/127
BLOCK MANAGEMENT SYSTEM var center = new GLatLng(22.183, 88.233);var map;function initialize()
{ if (GBrowserIsCompatible())
{map = new GMap2(document.getElementById("map_canvas"));map.addControl(new GOverviewMapControl());
map.enableDoubleClickZoom();map.enableScrollWheelZoom();map.addControl(new GMapTypeControl());
map.addControl(new GLargeMapControl());map.setCenter(center, 10);marker();
}}
function marker(){
lat =22.183;lon = 88.233;
var poly = new GPolygon([ new GLatLng(lat, lon - 0.05),new GLatLng(lat + 0.02, lon - 0.02),new GLatLng(lat + 0.06, lon),new GLatLng(lat + 0.08, lon + 0.06),new GLatLng(lat + 0.03, lon + 0.05),new GLatLng(lat, lon + 0.10),new GLatLng(lat - 0.07, lon + 0.05),new GLatLng(lat - 0.05, lon + 0.02),new GLatLng(lat - 0.10, lon - 0.01),
new GLatLng(lat - 0.09, lon - 0.07),new GLatLng(lat, lon - 0.05)],
"#f33f00", 5, 1, "#ff0000", 0.2);
GEvent.addListener(marker, "click", function(){ marker.openInfoWindowHtml(); marker.openInfoWindowTabsHtml([new GInfoWindowTab("POSITION","latitute "+lati+" longitude"+lngi),new GInfoWindowTab("VIEW",'
-
7/29/2019 Initial Report (Housing)
102/127
});map.addOverlay(poly);
}
LOGOUT
-
7/29/2019 Initial Report (Housing)
103/127
Style="z-index: 109; left: 253px; position: absolute; top: 22px;text-align: center" Width="65px"Target="_blank">Statistics
Form Name: frmHOGoogleDM.aspx.cs
-
7/29/2019 Initial Report (Housing)
104/127
using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Collections.Generic;using System.Text;using System.Data.SqlClient;
publicpartialclassuser1 : System.Web.UI.Page{ string[] strArray; string[] strArray1;
double[] intArray; double[] intArray1; StringBuilder sb = newStringBuilder(); StringBuilder sb1 = newStringBuilder(); SqlConnection con = newSqlConnection("Server=mcom14;Database=BMS;UID=sa;Password=lab3;");
protectedvoid Page_Load(object sender, EventArgs e){
intArray = newdouble[50];intArray1 = newdouble[50];strArray = newstring[50];strArray1 = newstring[50];
try{
SqlConnection conn1 = newSqlConnection(@"Server=mcom14;Database=BMS;UID=sa;Password=lab3;");
conn1.Open();
string sql1 = "SELECT lati,lngi,mode FROM HO_Object_Position"; SqlCommand cmd1 = newSqlCommand(sql1, conn1); SqlDataReader dr1 = cmd1.ExecuteReader();
int k = 0;int j = 0;
int n = 0;
while (dr1.Read()){
if (dr1[0] != System.DBNull.Value){
intArray[j] = Convert.ToDouble(dr1[0].ToString());
} else
-
7/29/2019 Initial Report (Housing)
105/127
{intArray[j] = 0.00;
}
if (dr1[1] != System.DBNull.Value){
intArray1[j] = Convert.ToDouble(dr1[1].ToString());}
else{
intArray1[j] = 0.00;}
if (dr1[2] != System.DBNull.Value)strArray[j] = dr1[2].ToString();
elsestrArray[j] = "";
j++;k++;n++;
}
dr1.Close();conn1.Close();
sb1.Append("\n");
string str, str1, str2;
for (int i = 1; i
-
7/29/2019 Initial Report (Housing)
106/127
} else if (String.Compare(strArray[i - 1], "Industrial Property") ==0)
{sb1.Append(" = new
GIcon(G_DEFAULT_ICON, \"ind.png\");\n");}
else if (String.Compare(strArray[i - 1], "InstitutionalProperty") == 0)
{sb1.Append(" = new
GIcon(G_DEFAULT_ICON, \"ins.png\");\n");}
sb1.Append(str1+".iconSize = new GSize(12,20);\n");sb1.Append(str1+".iconAnchor = new GPoint(6, 20);\n");
sb1.Append(str1+".shadowSize = new GSize(12,20);\n");
sb1.Append("var ");str2 = "m" + i.ToString();sb1.Append(str2);sb1.Append(" = new GMarker(");sb1.Append(str + ",{icon: " + str1);sb1.Append("});\n");
sb1 .Append("map.addOverlay(");sb1.Append(str2);sb1.Append(");\n");
}
sb.Append("\n"); // sb.AppendFormat("var myVar = {0};\n", sb1.ToString());
sb.AppendFormat("var myVar1 = {0};\n", intArray[0]);sb.AppendFormat("var myVar2 = {0};\n", intArray1[0]);
// sb.Append("var center; \n"); // sb.Append("var map; \n");
sb.Append("function load()\n");sb.Append("{ \n");sb.Append(" if (GBrowserIsCompatible())");sb.Append("{ \n");sb.Append("var map = new GMap2(document.getElementById(\"map\")); \n");sb.Append("map.addControl(new GOverviewMapControl()); \n");
sb.Append("map.enableDoubleClickZoom(); \n");sb.Append("map.enableScrollWheelZoom(); \n");sb.Append("map.addControl(new GMapTypeControl()); \n");
sb.Append("map.addControl(new GLargeMapControl()); \n");sb.Append("map.addControl(new GOverviewMapControl()); \n");sb.Append("map.setCenter(new GLatLng(myVar1, myVar2), 10); \n");
// sb.Append("var poly = myVar; \n"); // sb.Append("map.addOverlay(poly); \n");
-
7/29/2019 Initial Report (Housing)
107/127
sb.AppendFormat("{0} \n", sb1.ToString());sb.Append("} \n");sb.Append("} \n");sb.Append("\n");
ClientScript.RegisterClientScriptBlock(GetType(), "load", sb.ToString());
if (this.IsPostBack != true){
SqlCommand cmd = newSqlCommand("select distinct District_name fromAD_District", con); SqlDataAdapter adpt = newSqlDataAdapter(cmd); DataSet ds = newDataSet();
con.Open();adpt.Fill(ds);con.Close();DropDownList1.DataSource = ds.Tables[0];DropDownList1.DataTextField = "District_name";DropDownList1.DataValueField = "District_name";DropDownList1.DataBind();
}}
catch (SqlException ex){
Response.Write("error" + ex);}
} protectedvoid DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{ SqlCommand cmd = newSqlCommand("select distinct Block_name from AD_Blockwhere District_cd in (select District_cd from AD_District where District_name like '"+ DropDownList1.SelectedValue + "')", con); SqlDataAdapter adpt = newSqlDataAdapter(cmd); DataSet ds = newDataSet();
con.Open();adpt.Fill(ds);con.Close();DropDownList2.DataSource = ds.Tables[0];DropDownList2.DataTextField = "Block_name";DropDownList2.DataValueField = "Block_name";DropDownList2.DataBind();
}}
Form Name: frmHOInsertResiInfo.aspx
-
7/29/2019 Initial Report (Housing)
108/127
Untitled Page Insert NewResidential Information
Kuchha Pukka
-
7/29/2019 Initial Report (Housing)
109/127
Apartment Independent House Farm House Bunglow
-
7/29/2019 Initial Report (Housing)
110/127
Form Name: frmHOInsertResiInfo.vb
-
7/29/2019 Initial Report (Housing)
111/127
Imports System.DataImports System.Data.SqlClient
PartialClass resi_info_insert Inherits System.Web.UI.Page 'Dim con As New SqlConnection("data source=mcom14;uid=sa;password=lab3;initialcatalog=BMS") Dim Con AsNewSqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get( "AspTest"))
ProtectedSub Button1_Click(ByVal sender AsObject, ByVal e As System.EventArgs)Handles btnsubmit.Click Try Dim cmd AsNew SqlCommand("insert into HO_residential_main values('" &txtpropid.Text & "','" & cbohousetype.SelectedValue & "','" &cbohousedesc.SelectedValue & "','" & txtadd.Text & "','" & txtyoc.Text & "','" &txtnostorey.Text & "','" & txtarea.Text & "')") Dim adpt AsNew SqlDataAdapter(cmd)
Dim ds AsNew DataSet
cmd.Connection = concon.Open()adpt.Fill(ds)con.Close()
Catch ex As Exception 'Label1.Text = ex.Message EndTry
Response.Redirect("frmMaintainResiInfo.aspx") EndSub
'Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs)Handles btnrefresh.Click ' Response.Redirect("frmResiInfoInsert.aspx") 'End Sub
ProtectedSub Button3_Click(ByVal sender AsObject, ByVal e As System.EventArgs)Handles btncancel.Click
Response.Redirect("frmMaintainResiInfo.aspx") EndSub
ProtectedSub Page_Load(ByVal sender AsObject, ByVal e As System.EventArgs)HandlesMe.Load 'txtrole.Text = Request.Cookies("login")("Role_name") 'txtuid.Text = Request.Cookies("login")("User_id")
'txtuname.Text = Request.Cookies("login")("User_name")
EndSub
EndClass
Form Name: frmUpdateResiInfo.aspx
-
7/29/2019 Initial Report (Housing)
112/127
Untitled Page Update Residential
Information
-
7/29/2019 Initial Report (Housing)
113/127
Kuchha Pukka Apartment Independent House
Farm House Bunglow
-
7/29/2019 Initial Report (Housing)
114/127
-
7/29/2019 Initial Report (Housing)
115/127
Form Name: frmUpdateResiInfo.aspx.vb
Imports System.DataImports System.Data.SqlClientPartialClass frmResiInfoUpdate
-
7/29/2019 Initial Report (Housing)
116/127
Inherits System.Web.UI.Page 'Dim con As New SqlConnection("data source=mcom14;uid=sa;password=lab3;initialcatalog=BMS") Dim Con AsNewSqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get( "AspTest"))
ProtectedSub Page_Load(ByVal sender AsObject, ByVal e As System.EventArgs)HandlesMe.Load 'txtrole.Text = Request.Cookies("login")("Role_name") 'txtuid.Text = Request.Cookies("login")("User_id") 'txtuname.Text = Request.Cookies("login")("User_name") IfNotMe.IsPostBack = TrueThen
txtpropid.Text = Request.Cookies("resi")("prop_id")ddlhousetype.Text = Request.Cookies("resi")("house_type")ddlhousedesc.Text = Request.Cookies("resi")("house_desc")txtadd.Text = Request.Cookies("resi")("address")txtyoc.Text = Request.Cookies("resi")("yoc")txtnostorey.Text = Request.Cookies("resi")("no_storey")
txtarea.Text = Request.Cookies("resi")("area")
EndIf EndSub
ProtectedSub Button1_Click(ByVal sender AsObject, ByVal e As System.EventArgs)Handles btnupdate.Click Try Dim cmd AsNew SqlCommand("update HO_residential_main set house_type='" &ddlhousetype.Text & "',house_desc='" & ddlhousedesc.Text & "',address='" &txtadd.Text & "',yoc='" & txtyoc.Text & "',no_storey='" & txtnostorey.Text &"',area='" & txtarea.Text & "' where prop_id='" & txtpropid.Text & "'", con) Dim adpt AsNew SqlDataAdapter(cmd) Dim ds AsNew DataSet
con.Open()adpt.Fill(ds)con.Close()Response.Redirect("frmMaintainResiInfo.aspx")
Catch ex As Exception
EndTry
EndSub
ProtectedSub btncancel_Click(ByVal sender AsObject, ByVal e As
System.EventArgs) Handles btncancel.ClickResponse.Redirect("frmMaintainResiInfo.aspx")
EndSubEndClass
Form Name: frmDeleteResiInfo.aspx
-
7/29/2019 Initial Report (Housing)
117/127
Untitled Page Delete ResidentialInformation
-
7/29/2019 Initial Report (Housing)
118/127
-
7/29/2019 Initial Report (Housing)
119/127
Form Name: frmDeleteResiInfo.aspx.vb
Imports System.DataImports System.Data.SqlClientPartialClass resi_info_delete Inherits System.Web.UI.Page
-
7/29/2019 Initial Report (Housing)
120/127
'Dim con As New SqlConnection("data source=mcom14;uid=sa;password=lab3;initialcatalog=BMS") Dim Con AsNewSqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get( "AspTest"))
ProtectedSub Button1_Click(ByVal sender AsObject, ByVal e As System.EventArgs)Handles btndelete.Click Try Dim cmd AsNew SqlCommand("delete from HO_residential_occupants whereHO_residential_occupants.prop_id='" & txtpropid.Text & "'") Dim cmd1 AsNew SqlCommand("delete from HO_residential_main whereHO_residential_main.prop_id='" & txtpropid.Text & "'")
cmd.Connection = concon.Open()cmd.ExecuteNonQuery()con.Close()cmd1.Connection = concon.Open()cmd1.ExecuteNonQuery()
con.Close()
Catch ex As Exception
EndTryResponse.Redirect("frmMaintainResiInfo.aspx")
EndSub
ProtectedSub Button3_Click(ByVal sender AsObject, ByVal e As System.EventArgs)Handles btncancel.Click
Response.Redirect("frmMaintainResiInfo.aspx") EndSub
ProtectedSub Page_Load(ByVal sender AsObject, ByVal e As System.EventArgs)HandlesMe.Load 'txtrole.Text = Request.Cookies("login")("Role_name") 'txtuid.Text = Request.Cookies("login")("User_id") 'txtuname.Text = Request.Cookies("login")("User_name") IfNotMe.IsPostBack = TrueThen
txtpropid.Text = Request.Cookies("resi")("prop_id")txthousetype.Text = Request.Cookies("resi")("house_type")txthousedesc.Text = Request.Cookies("resi")("house_desc")txtadd.Text = Request.Cookies("resi")("address")txtyoc.Text = Request.Cookies("resi")("yoc")txtnostorey.Text = Request.Cookies("resi")("no_storey")txtarea.Text = Request.Cookies("resi")("area")
'txtcurocudetails.Text = Request.Cookies("resi")("curocudetails")
'txtnoocu.Text = Request.Cookies("resi")("noocu") 'txtocutype.Text = Request.Cookies("resi")("ocutype") 'txtownerdetails.Text = Request.Cookies("resi")("ownerdetails") 'txtstartdateocu.Text = Request.Cookies("resi")("startdateocu") EndIf EndSubEndClass
-
7/29/2019 Initial Report (Housing)
121/127
Form Name: frmViewResiInfo.aspx
-
7/29/2019 Initial Report (Housing)
122/127
Untitled Page
Residential Information
-
7/29/2019 Initial Report (Housing)
123/127
-
7/29/2019 Initial Report (Housing)
124/127
Form Name: frmViewResiInfo.aspx.vb
Imports System.DataImports System.Data.SqlClientPartialClass resi_info_view
-
7/29/2019 Initial Report (Housing)
125/127
Inherits System.Web.UI.Page Dim con AsNew SqlConnection("data source=mcom14;uid=sa;password=lab3;initialcatalog=BMS")
ProtectedSub Button1_Click(ByVal sender AsObject, ByVal e As System.EventArgs)Handles btnok.Click
Response.Redirect("frmMaintainResiInfo.aspx") EndSub ProtectedSub Button3_Click(ByVal sender AsObject, ByVal e As System.EventArgs)Handles btnok.Click
Response.Redirect("frmMaintainResiInfo.aspx") EndSub
ProtectedSub Page_Load(ByVal sender AsObject, ByVal e As System.EventArgs)HandlesMe.Load 'txtrole.Text = Request.Cookies("login")("Role_name") 'txtuid.Text = Request.Cookies("login")("User_id") 'txtuname.Text = Request.Cookies("login")("User_name") IfNotMe.IsPostBack = TrueThen
txthouseid.Text = Request.Cookies("resi")("prop_id")
txthousetype.Text = Request.Cookies("resi")("house_type")txthousedesc.Text = Request.Cookies("resi")("house_desc")txtadd.Text = Request.Cookies("resi")("address")txtyoc.Text = Request.Cookies("resi")("yoc")txtnostorey.Text = Request.Cookies("resi")("no_storey")txtarea.Text = Request.Cookies("resi")("area")
EndIf
EndSub
ProtectedSub txthousedesc_TextChanged(ByVal sender AsObject, ByVal e AsSystem.EventArgs) Handles txthousedesc.TextChanged
EndSubEndClass
Form Name: SaveToDb.aspx.vb
Coding
-
7/29/2019 Initial Report (Housing)
126/127
Imports System.DataImports System.Data.SqlClient
PartialClass SaveToDb Inherits System.Web.UI.Page
ProtectedSub Page_Load(ByVal sender AsObject, ByVal e As System.EventArgs)HandlesMe.Load Dim Lati AsString = Me.Request("Lati") Dim Lngi AsString = Me.Request("Lngi") Dim Name AsString = Me.Request("type")
IfNot (Lati = String.Empty) AndNot (Lngi = String.Empty) Then Dim conn1 AsNewSqlConnection("Server=mcom14;Database=BMS;UID=sa;Password=lab3;") Dim sql1 AsString = "insert into HO_Object_Position values ('" + Lati +"', '" + Lngi + "', '" + Name + "')" Dim cmd1 As SqlCommand = New SqlCommand(sql1, conn1)) Try
conn1.Open()cmd1.ExecuteNonQuery()conn1.Close()
Catch ex As Exception
EndTry Me.Response.ClearHeaders() Me.Response.Clear() Me.Response.Write("") Me.Response.End() EndIf
EndSubEndClass
Conclusion:
The project had its plan laid out properly and was successfully completed. The data wasretrieved and was properly utilized.
-
7/29/2019 Initial Report (Housing)
127/127