public JsonResult AddListing()
        {
            OracleRepository repo = new OracleRepository();
            var result = repo.InsertOrUpdateListing
                (null,null,null,null,null,null,null,null,null,null,null,null,null,null,
                null,null,null,null,null,null,null,null,null,null,null,null,null,null,null, HttpContext.User.Identity.Name);

            return Json(result, JsonRequestBehavior.AllowGet);
        }
 public JsonResult SaveListing(decimal? id, string type,string subtype,string quadrant,
     string district, string city,string unit_name,
     string address,string zoning, string under_construction,
     string building_type,
     string total_building_size, decimal? landlord_contact_id,
     string year_built,string land_acres, string smallest_divisible,
     string land_serviced_type, string available,
     string term,DateTime? leased_date, string largest_contiguous,
     string ceiling_height, string mezzanine_yn,
     string yard_area_yn, string site_size, string power,
     string cranes, DateTime? sold_date, decimal? latitude, decimal? longitude,
     string legal_description_block, string legal_description_lot,
     string legal_description_plan)
 {
     OracleRepository repo = new OracleRepository();
     id= repo.InsertOrUpdateListing(id, type,  subtype,  quadrant,
                                   district,  city,  unit_name,
                                   address,  zoning,  under_construction,
                                   building_type,"",
                                   total_building_size, landlord_contact_id,
                                   year_built,  land_acres,  smallest_divisible,
                                   land_serviced_type,  available,
                                   term,  leased_date,  largest_contiguous,
                                   ceiling_height,  mezzanine_yn,
                                   yard_area_yn,  site_size,  power,
                                   cranes,  sold_date, User.Identity.Name,
                                   legal_description_block, legal_description_lot, legal_description_plan);
     if (id!=null && (latitude!=null ||longitude!=null))
     {
         repo.InsertListingLatLng(id.Value, latitude, longitude);
     }
     return Json(id, JsonRequestBehavior.AllowGet);
 }