public List<Area> getAllArea() {
List<Area> areaList = new ArrayList<Area>();
con = new DBConnection();
try {
cstmt = con.connection.prepareCall("{call getAllArea()}");
ResultSet rs = cstmt.executeQuery();
while (rs.next()) {
Area objArea = new Area();
objArea.setAreaID(rs.getInt("AreaID"));
objArea.setAreaName(rs.getString("AreaName"));
City c = new City();
c.setCityName(rs.getString("CityName"));
objArea.setCity(c);
areaList.add(objArea);
}
rs.close();
} catch (Exception ex) {
ex.getMessage();
} finally {
con.closeConnection();
}
return areaList;
}
public ArrayList<Vendor> getAllVendors() {
con = new DBConnection();
ArrayList<Vendor> vendors = new ArrayList<Vendor>();
try {
cstmt = con.connection.prepareCall("{call getAllVendors ()}");
ResultSet rs = cstmt.executeQuery();
while (rs.next()) {
Vendor objVendor = new Vendor();
objVendor.setUserName(rs.getString("UserName"));
objVendor.setVendorName(rs.getString("VendorName"));
Area objArea = new Area(); // Creating area object
objArea.setAreaName(rs.getString("AreaName")); // setting areaname of vendor
City objCity = new City();
objCity.setCityName(rs.getString("CityName")); // setting cityname
objArea.setCity(objCity);
objVendor.setArea(objArea);
// setting all other fields
objVendor.setMobileNo(rs.getString("MobileNo"));
objVendor.setEmailID(rs.getString("EmailID"));
objVendor.setLane(rs.getString("Lane"));
objVendor.setOwnerName(rs.getString("OwnerName"));
objVendor.setLandlineNumber(rs.getString("LandlineNo"));
objVendor.setStatus(rs.getBoolean("Status"));
vendors.add(objVendor);
}
rs.close();
} catch (Exception ex) {
ex.getMessage();
} finally {
con.closeConnection();
}
return vendors;
}
public Area getArea(int area_id) {
Area objArea = null;
con = new DBConnection();
try {
cstmt = con.connection.prepareCall("{call getArea(?)}");
cstmt.setInt(1, area_id);
ResultSet rs = cstmt.executeQuery();
if (rs.next()) {
objArea = new Area();
objArea.setAreaName(rs.getString("AreaName"));
objArea.setAreaID(rs.getInt("AreaID"));
City ct = new City();
// ct.setCityID(rs.getInt("CityID"));
ct.setCityName(rs.getString("CityName"));
objArea.setCity(ct);
}
rs.close();
} catch (Exception ex) {
ex.getMessage();
} finally {
con.closeConnection();
}
return objArea;
}
