public void ExitSetCarLocationToNone() { eProc = new EventProcessor(); Parking park = new Parking(Parking.NONE); ExitEvent ev = new ExitEvent(new DateTime(2015, 09, 01), newCar); eProc.Process(ev); Assert.AreEqual(park.Name, newCar.Parking.Name); }
public ActionResult RemoveOwnerVehicleFromParking(int slotNumber) { Parking result = this.driverService.UnParkVehicle(slotNumber); if (result != null) { return(this.Ok(new ResponseEntity(HttpStatusCode.OK, "Vehicle Unparked Successfully", result))); } return(this.BadRequest(new ResponseEntity(HttpStatusCode.BadRequest, "No Record Found", null))); }
public static ParkingDto EntityToDto(this Parking parking) { return(new ParkingDto() { Address = parking.Address, Description = parking.Description, Document = parking.Document, //Id = parking.Id, Phone = parking.Phone }); }
public IHttpActionResult Delete(Parking parking) { apiResp = new ApiResponse { Message = "Se elimino existosamente" }; var mng = new ParkingManager(); mng.Delete(parking); return(Ok(apiResp)); }
public IActionResult Create([FromBody] Parking parking) { if (parking == null) { return(BadRequest()); } _service.Create(parking); return(CreatedAtRoute("Getparking", new { id = parking.Id }, parking)); }
public ActionResult Create([Bind(Include = "parkid,areaname,rate")] Parking parking) { if (ModelState.IsValid) { db.Parkings.Add(parking); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(parking)); }
public IHttpActionResult GetParking(int id) { Parking parking = db.Parkings.Find(id); if (parking == null) { return(NotFound()); } return(Ok(parking)); }
public async Task <IActionResult> Create([Bind("ParkingID,VisitorName,VisitoCarNo,ParkingPurpose")] Parking parking) { if (ModelState.IsValid) { _context.Add(parking); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(parking)); }
public async Task <IActionResult> UnesiSifru(int id, [Bind("ID,Naziv,PocetakRadnogVremena,KrajRadnogVremena,PocetakJeftinogVremena,KrajJeftinogVremena,Sifra,OdobrenSGMjesecno,OdobrenSGUzastopno,OdobrenOSInvaliditetom,Cijena")] Parking parking) { if (id != parking.ID) { return(NotFound()); } System.Diagnostics.Debug.WriteLine(id); int ovajid = id; return(RedirectToAction("Index", new { id = ovajid })); }
/// <summary> /// Adding vehicles To ParkingLot. /// </summary> /// <param name="parkingLot">Parkinglot Object.</param> /// <returns>Parkinglot Objects.</returns> public ParkingLot ParkVehicle(Parking parkingLot) { ParkingLot parking = this.repository.AddVehicle(parkingLot); if (parking != null) { this.service.AddToQueue(parking.Role + " Parked Vehicle Having Number " + parking.Vehicle_Number + " At Time " + parking.EntryTime); } return(parking); }
public ActionResult AddOwnerVehicleToParking(Parking parking) { var result = this.driverService.ParkVehicle(parking); if (result != null) { return(this.Ok(new ResponseEntity(HttpStatusCode.OK, "Vehicle Parked Successfully", result))); } return(this.BadRequest(new ResponseEntity(HttpStatusCode.BadRequest, "Vehicle already Parked", null))); }
public void ShouldReturnLotNumberWhenParkingAvailable() { //arange Parking park = new Parking(2, 10, 5); park.OccupyFreeLot("license1"); //act string answer = park.OccupyFreeLot("lic2"); //assert Assert.Equal("Please proceed to lot 1", answer); }
/// <summary> /// This method used for for parking new vehicle in parking lot. /// </summary> /// <param name="parking">Parking data.</param> /// <returns>Boolean result.</returns> public ParkingDetails ParkVehicle(Parking parking) { ParkingDetails parkingDetails = this.parkingRepository.ParkVehicle(parking); if (parkingDetails != null) { this.mSMQService.SendDataToQueue("Parked vehicle number: " + parkingDetails.VehicleNumber + " At time: " + parkingDetails.EntryTime + " Parking id:" + parkingDetails.ParkingId); } return(parkingDetails); }
public ActionResult Edit([Bind(Include = "ID_PARKING,NOMBRE_PARK,DIRECCION_PARK,COMUNA_PARK,REGION_PARK,CANTIDAD_PARK")] Parking park_mod) { park_mod.ID_EMPRESA = 1; if (ModelState.IsValid) { db.Entry(park_mod).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(park_mod)); }
public void ParkAllFull4McMcThrowsExeptionTest() { // Should throw exception // Setup string[] park = new string[2]; park[0] = "abc123:uyt345"; park[1] = "dbc423:uto765"; //Act Parking.Add(park, "1poi43", VehicleType.Mc); // Should throw exception }
public Form2() { InitializeComponent(); parking = new Parking(5); for (int i = 1; i < 6; i++) { listBox.Items.Add("Уровень " + i); } listBox.SelectedIndex = parking.getCurrentLevel; Draw(); }
public void ParkDuplicateCarVsCarRegistrationNumberThrowsExceptionTest() { // Should throw exception // Setup string[] park = new string[2]; park[0] = null; park[1] = "uto765"; //Act Parking.Add(park, "uto765", VehicleType.Car); // Should throw exception }
public void FindFreePlaceAllFull2McMcTest() { // Should throw exception // Setup string[] park = new string[1]; park[0] = "abc123:uyt345"; int actualPlace = -1; //Act actualPlace = Parking.FindFreePlace(park, VehicleType.Mc); // Should throw exception }
public void TestAddVehicleToParkArea() { Parking parking = new Parking(); bool result = parking.AddParkedVehicle(new ParkingGarage.Models.ParkingModel.ParkedCars { ParkedSlots = "10", PlateNumber = "CSC 1295", VehicleType = ParkingGarage.Models.VehicleType.car }); Assert.IsFalse(result, "Should be true"); }
public void RemoveNotFound4McThrowsExeptionTest() { // Should throw exception // Setup string[] park = new string[2]; park[0] = "abc123:uyt345"; park[1] = "dbc423:uto765"; //Act Parking.Remove(park, "1poi43"); // Should throw exception }
private void Page_Loaded(object sender, RoutedEventArgs e) { xDocument = XMLObjectModel.GetXDocument(); parking = new Parking(Parking.GetParkCards(xDocument), xDocument); if (xDocument != null) { foreach (ParkCard parkCard in parking) { listBoxProducts.Items.Add(parkCard.ID + '-' + parkCard.SecondName + '.' + parkCard.FirstName[0]); } } }
public Parking GetParkingById(int id) { try { Parking parking = context.Parkings.Find(id); return(parking); } catch { return(new Parking()); } }
public async Task <IActionResult> Create([Bind("ParkingCode,BoatTypeId,ActualBoatId")] Parking parking) { if (ModelState.IsValid) { _context.Add(parking); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["BoatTypeId"] = new SelectList(_context.BoatType, "BoatTypeId", "Name", parking.BoatTypeId); return(View(parking)); }
public async Task <int> SeedParkingsAsync(ApplicationDbContext context) { var parkings = new Parking[] { new Parking() { Name = "Sofia one", TownId = 1, Town = new Town() { CountryId = 1, Name = "Sofia", }, Address = "Some street", Capacity = 100, }, new Parking() { Name = "Athens one", TownId = 2, Town = new Town() { CountryId = 2, Name = "Athens", }, Address = "Some street", Capacity = 100, }, new Parking() { Name = "Bucharest one", TownId = 3, Town = new Town() { CountryId = 3, Name = "Bucharest", }, Address = "Some street", Capacity = 100, }, }; foreach (var parking in parkings) { await context.Parkings.AddAsync(parking); } await context.SaveChangesAsync(); return(parkings.Length); }
public void Update(Parking parking) { IsRefreshing = true; var oldParqueo = parqueos .Where(c => c.IdParqueo == parking.IdParqueo) .FirstOrDefault(); oldParqueo = parking; Parqueos = new ObservableCollection <Parking>( parqueos.OrderBy(c => c.Descripcion)); IsRefreshing = false; }
public void ParkDuplicateMcVsCarRegistrationNumberThrowsExceptionTest() { // Should throw exception // Setup string[] park = new string[2]; park[0] = "abc123"; park[1] = ":dbc423"; //Act Parking.Add(park, "abc123", VehicleType.Mc); // Should throw exception }
public void AddCarTest() { Parking parking = new Parking(); Car car = parking.AddCar("mmmm", new User() { Username = "******" }, new DateTime(2018, 2, 23)); Assert.NotNull(car.StateNumber); Assert.NotNull(car.Owner); Assert.Contains(car, parking.Cars); }
static void Main(string[] args) { var path = @""; // Deserializing if (File.Exists(path)) { using (var reader = new StreamReader(path)) { string json = reader.ReadToEnd(); // NewtonSoft json Parking parking = JsonConvert.DeserializeObject <Parking>(json); // javascriptSerializer //JavascriptSerializer serializer = new JavascriptSerializer(); //var parking = serializer.Deserialize<Parking>(json); Console.WriteLine(parking.Address); } } // Serializing Parking parkingOne = new Parking() { Id = 1, Address = "324 East 7th St, brooklyn", Cars = new List <Car> { new Car() { Id = 1, Make = "BMW", Model = "X5", Owner = new Owner { FirstName = "Obed", LastName = "Garcia" }, DateOfBuy = new DateTime(2020, 6, 18) } } }; // NewtonSoft json string jsonSerialized = JsonConvert.SerializeObject(parkingOne, Formatting.Indented); Console.WriteLine(jsonSerialized); // javascriptSerializer //JavascriptSerializer serializer = new JavascriptSerializer(); //var jsonSerialized = serializer.Serialize(parkingOne); }
public bool Insert(Parking acc) { try { obj.Parkings.Add(acc); return(obj.SaveChanges() > 0); } catch { return(false); } }
public async Task <ActionResult> Create([Bind(Include = "ParkingID,Name,Address,Phone,IsOverNight,Website,OpenTime,Price,Lat,Lng")] Parking parking) { if (ModelState.IsValid) { db.Parkings.Add(parking); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(parking)); }
public void AddExistsParkingLevel() { var parking = new Parking(Address.BelarusMinskNemiga); var parkingLevel1 = new ParkingLevel(1); var parkingLevel2 = new ParkingLevel(1); var result1 = parking.AddParkingLevel(parkingLevel1); var result2 = parking.AddParkingLevel(parkingLevel2); Assert.IsTrue(result1.IsSuccess); Assert.IsFalse(result2.IsSuccess); }
public Parking fetchGarageParkingById(String sessionId, int parkingId,String language) { if (!authenticateUser(sessionId)) { throw Utils.RaiseException(Context.Request.Url.AbsoluteUri, "fetchGarageParkingById", USER_NOT_AUTHENTICATE, "401", "fetchGarageParkingById"); } language = getLanguage(language); String conStr = ConfigurationManager.ConnectionStrings["CityParkCS"].ConnectionString; Parking parking = null; using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand()) { /*String fetchDataSql = String.Format( @"SELECT *, priceTbl.firstHourPrice, priceTbl.extraQuarterPrice, priceTbl.allDayPrice FROM CITYPARK.[dbo].[Parking] as parkingTbl, CITYPARK.[dbo].[parking_shortrange] as priceTbl where parkingTbl.parkingID='{0}' and parkingTbl.parkingID=priceTbl.parkId", parkingId); //This is the old SQL*/ String fetchDataSql = String.Format( @"DECLARE @Date DATETIME SET @Date = GETDATE() SELECT top 1.*, CASE WHEN DATEPART(dw, @Date) BETWEEN 1 and 5 and DATENAME(hour, @Date)< Weekday_OneTimeHour THEN (select WeekDay_FirstHourPrice) WHEN DATEPART(dw, @Date) BETWEEN 1 and 5 and DATENAME(hour, @Date)>=Weekday_OneTimeHour THEN (select Weekday_OneTimePrice) WHEN DATEPART(dw, @Date)=6 and DATENAME(hour, @Date)<Friday_OneTimeHour THEN (select Friday_FirstHourPrice) WHEN DATEPART(dw, @Date)=6 and DATENAME(hour, @Date)>=Friday_OneTimeHour THEN (select Friday_OneTimePrice) WHEN DATEPART(dw, @Date)=7 and DATENAME(hour, @Date)<Saturday_FirstHourPrice THEN (select Saturday_FirstHourPrice) WHEN DATEPART(dw, @Date)=7 and DATENAME(hour, @Date)>=Saturday_OneTimeHour THEN (select Saturday_OneTimePrice) ELSE WeekDay_FirstHourPrice END AS FirstHourPrice, CASE WHEN DATEPART(dw, @Date) BETWEEN 1 and 5 THEN (select WeekDay_extraQuarterPrice) WHEN DATEPART(dw, @Date)=6 THEN (select Friday_extraQuarterPrice) WHEN DATEPART(dw, @Date)=7 THEN (select Saturday_extraQuarterPrice) ELSE WeekDay_extraQuarterPrice END AS extraQuarterPrice, allDayPrice FROM [CITYPARK].[dbo].[Parking] WHERE parkingID ='{0}'", parkingId); cmd.Connection = con; cmd.CommandText = fetchDataSql; con.Open(); using (SqlDataReader sqlDataReader = cmd.ExecuteReader()) { if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { String parkingID = sqlDataReader["parkingID"].ToString(); String qHouseNumber = sqlDataReader["house_number"].ToString(); if ("NULL".Equals(qHouseNumber) || "".Equals(qHouseNumber.Trim())) qHouseNumber = "0"; int parkingIdInt = Convert.ToInt32(parkingID); int houseNumInt = Convert.ToInt32(qHouseNumber); String name; String street; String city; if (language.Equals("en")) { name = sqlDataReader["parkingNameEnglish"].ToString(); street = sqlDataReader["addressEnglish"].ToString(); city = sqlDataReader["cityEnglish"].ToString(); } else { name = sqlDataReader["name"].ToString(); street = sqlDataReader["street_name"].ToString(); city = sqlDataReader["City"].ToString(); } parking = new Parking(parkingIdInt, name, city, street, houseNumInt, sqlDataReader["latitude"].ToString(), sqlDataReader["longitude"].ToString()); parking.Comment = sqlDataReader["comment"].ToString(); parking.Coupon_text = sqlDataReader["coupon_text"].ToString(); parking.Current_Pnuyot = sqlDataReader["current_Pnuyot"].ToString(); parking.Image = sqlDataReader["image"].ToString(); parking.Image2 = sqlDataReader["image2"].ToString(); parking.Withlock = sqlDataReader["Withlock"].ToString(); parking.Underground = sqlDataReader["Underground"].ToString(); parking.Nolimit = sqlDataReader["Nolimit"].ToString(); parking.Roof = sqlDataReader["Roof"].ToString(); parking.Criple = sqlDataReader["Criple"].ToString(); parking.Toshav = sqlDataReader["toshav"].ToString(); parking.Jenion = sqlDataReader["jenion"].ToString(); parking.FirstHourPrice = sqlDataReader["firstHourPrice"].ToString(); parking.ExtraQuarterPrice = sqlDataReader["extraQuarterPrice"].ToString(); parking.AllDayPrice = sqlDataReader["allDayPrice"].ToString(); if("ahuzot".Equals(parking.Owner)) { try { String externalIdStr = sqlDataReader["externalid"].ToString(); if ("NULL".Equals(externalIdStr) || "".Equals(externalIdStr.Trim())) externalIdStr = "-1"; int externalId = Convert.ToInt32(externalIdStr); new Thread(() => AhuzotHoffApi.updateServiceProviderLog("fetchGarageParkingById", sessionId, externalId)).Start(); } catch (Exception e) { log.Error(e.Message); } } } } } } } return parking; }
public List<Parking> getParkingReleases(String sessionId, float latitude, float longitude, int distance,String language) { if (!authenticateUser(sessionId)) { throw Utils.RaiseException(Context.Request.Url.AbsoluteUri, "getParkingReleases", USER_NOT_AUTHENTICATE, "401", "getParkingReleases"); } language = getLanguage(language); List<Parking> parkingList = new List<Parking>(); Boolean demo = isDemoUser(sessionId); String conStr = ConfigurationManager.ConnectionStrings["CityParkCS"].ConnectionString; if (demo) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand()) { String sql = String.Format(@"DECLARE @UserLat float = {0} DECLARE @UserLong float = {1} SELECT * FROM [CITYPARK].[dbo].[StreetSegmentLine] a where SQRT ( POWER((a.StartLatitude - @UserLat) * COS(@UserLat/180) * 40000 / 360, 2) + POWER((a.StartLongitude -@UserLong) * 40000 / 360, 2)) < {2}", latitude, longitude, (float)distance / 1000f); cmd.Connection = con; cmd.CommandText = sql; con.Open(); using (SqlDataReader sqlDataReader = cmd.ExecuteReader()) { if (sqlDataReader.HasRows) { Random random = new Random(); int i = 1; while (sqlDataReader.Read()) { if (i % 2 == 0) { Parking p = new Parking(); p.Latitude = sqlDataReader["StartLatitude"].ToString(); p.Longitude = sqlDataReader["StartLongitude"].ToString(); parkingList.Add(p); } i++; } } } } } /* Random random = new Random(); for (int i = 0; i < 30; i++) { float lat = random.Next(-90, 90);//0.00x if (lat == 0) lat = 1; lat = lat / 10000f; lat = lat + latitude; float lng = random.Next(-90, 90);//0.00x if (lng == 0) lng = 1; lng = lng / 10000f; lng = lng + longitude; Parking p = new Parking(); p.Latitude = lat + ""; p.Longitude = lng + ""; parkingList.Add(p); } */ return parkingList; } using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand()) { String loginSql = String.Format( @"DECLARE @NOW geography --User Location Coordinates SET @NOW = geography::Point({0}, {1},4326) -- Real time user location after geocoded (address to coordinates) SELECT top 200 *, @NOW.STDistance(geography::Point(latitude,longitude,4326)) as Distance FROM [citypark].[dbo].[StreetParking] WHERE @NOW.STDistance(geography::Point(latitude,longitude,4326))<={2} and datediff(mi,Date,CURRENT_TIMESTAMP)< 2 and Released = 1 order by Distance asc", latitude, longitude, distance/*in meter*/); cmd.Connection = con; cmd.CommandText = loginSql; con.Open(); using (SqlDataReader sqlDataReader = cmd.ExecuteReader()) { if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { Parking parking = new Parking(); parking.Latitude = sqlDataReader["latitude"].ToString(); parking.Longitude = sqlDataReader["longitude"].ToString(); /*parking.City = sqlDataReader["City"].ToString(); parking.StreetName = sqlDataReader["Street"].ToString(); String houseNum = sqlDataReader["House_Number"].ToString(); if (!houseNum.Trim().Equals("")) parking.HouseNumber = Convert.ToInt32(houseNum);*/ parkingList.Add(parking); } } } return parkingList; } } }
// POST: odata/Parking public async Task<IHttpActionResult> Post(Parking parking) { if (!ModelState.IsValid) { return BadRequest(ModelState); } Parking oParking = await db.Parkings.FindAsync(parking.ParkingID); if (oParking == null) { db.Parkings.Add(parking); } else { if (parking.ParkingName != null) oParking.ParkingName = parking.ParkingName; if (parking.SlotsOccupied != null) oParking.SlotsOccupied = parking.SlotsOccupied; if (parking.SlotsUnderMaintenance != null) oParking.SlotsUnderMaintenance = parking.SlotsUnderMaintenance; if (parking.TotalSlots != null) oParking.TotalSlots = parking.TotalSlots; } try { await db.SaveChangesAsync(); } catch (DbUpdateException) { if (ParkingExists(parking.ParkingID)) { return Conflict(); } else { throw; } } return Created(parking); }
public void TestInitialize() { parkingBarcelona = new Parking("Barcelona"); parkingParis = new Parking("Paris"); newCar = new Car("NewCar"); oldCar = new Car("OldCar"); }
public List<Parking> findAllGarageParkingDataByLatitudeLongitude(String sessionId, float latitude, float longitude, int distance, String language) { //and parkingtype='חניון בחינם' or parkingtype='חניון בתשלום' if (!authenticateUser(sessionId))//sessionId.Equals(Session["userId"])) { //HttpContext.Current.Response.StatusCode = 401; throw Utils.RaiseException(Context.Request.Url.AbsoluteUri, "findAllGarageParkingDataByLatitudeLongitude", USER_NOT_AUTHENTICATE, "401", "findAllGarageParkingDataByLatitudeLongitude"); } language = getLanguage(language); Boolean demo = isDemoUser(sessionId); Random random = null; if (demo) { random = new Random(); } String conStr = ConfigurationManager.ConnectionStrings["CityParkCS"].ConnectionString; using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand()) { /*String searchSql = String.Format( @"DECLARE @NOW geography SET @NOW = geography::Point({0}, {1},4326) SELECT top 200.*, b.firstHourPrice, b.extraQuarterPrice, b.allDayPrice, @NOW.STDistance(geography::Point(latitude,longitude,4326)) as Distance FROM CITYPARK.[dbo].[Parking] as a, CITYPARK.[dbo].[parking_shortrange] b where a.parkingID=b.parkId and DATEPART(dw, GETDATE()) between Case when fromDay='א' then 1 when fromDay='ב' then 2 when fromDay='ג' then 3 when fromDay='ד' then 4 when fromDay='ה' then 5 when fromDay='ו' then 6 when fromDay='שבת' then 7 End and Case when toDay='א' then 1 when toDay='ב' then 2 when toDay='ג' then 3 when toDay='ד' then 4 when toDay='ה' then 5 when toDay='ו' then 6 when toDay='שבת' then 7 End and DATENAME(hour, GETDATE())>=CAST(b.fromHour AS int)and DATENAME(hour, GETDATE())<=CAST(b.toHour AS int) and Heniontype='חניון' and @NOW.STDistance(geography::Point(latitude,longitude,4326))<={2} order by Distance asc", latitude, longitude, distance);// and Current_Pnuyot>0 and isnumeric (b.firsthourprice)=1*/ String searchSql = String.Format( @"DECLARE @USER geography = geography::Point({0}, {1},4326) DECLARE @Date DATETIME DECLARE @CURRENTDAY as SMALLINT = DATEPART(dw, GETDATE()) DECLARE @CURRENTHOUR as SMALLINT = DATENAME(hour, GETDATE()) SET @Date = GETDATE() SELECT top 200.*, CASE WHEN @CURRENTDAY BETWEEN 1 and 5 and @CURRENTHOUR<Weekday_OneTimeHour THEN (select WeekDay_FirstHourPrice) WHEN @CURRENTDAY BETWEEN 1 and 5 and @CURRENTHOUR>=Weekday_OneTimeHour THEN (select Weekday_OneTimePrice) WHEN @CURRENTDAY=6 and @CURRENTHOUR<Friday_OneTimeHour THEN (select Friday_FirstHourPrice) WHEN @CURRENTDAY=6 and @CURRENTHOUR>=Friday_OneTimeHour THEN (select Friday_OneTimePrice) WHEN @CURRENTDAY=7 and @CURRENTHOUR<Saturday_FirstHourPrice THEN (select Saturday_FirstHourPrice) WHEN @CURRENTDAY=7 and @CURRENTHOUR>=Saturday_OneTimeHour THEN (select Saturday_OneTimePrice) ELSE WeekDay_FirstHourPrice END AS FirstHourPrice, CASE WHEN @CURRENTDAY BETWEEN 1 and 5 THEN (select WeekDay_extraQuarterPrice) WHEN @CURRENTDAY=6 THEN (select Friday_extraQuarterPrice) WHEN @CURRENTDAY=7 THEN (select Saturday_extraQuarterPrice) ELSE WeekDay_extraQuarterPrice END AS extraQuarterPrice, ROUND(@USER.STDistance(geography::Point(latitude,longitude,4326)),0) as Distance, allDayPrice FROM [CITYPARK].[dbo].[Parking] WHERE Heniontype='חניון' and @USER.STDistance(geography::Point(latitude,longitude,4326))<{2} order by Distance,vip asc", latitude, longitude, distance);// and Current_Pnuyot>0 and isnumeric (b.firsthourprice)=1 cmd.Connection = con; cmd.CommandText = searchSql; con.Open(); List<Parking> parkingList = new List<Parking>(); using (SqlDataReader sqlDataReader = cmd.ExecuteReader()) { if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { String parkingID = sqlDataReader["parkingID"].ToString(); String qHouseNumber = sqlDataReader["house_number"].ToString(); if ("NULL".Equals(qHouseNumber) || "".Equals(qHouseNumber.Trim())) qHouseNumber = "0"; int parkingIdInt = Convert.ToInt32(parkingID); int houseNumInt = Convert.ToInt32(qHouseNumber); String name; String street; String city; if (language.Equals("en")) { name = sqlDataReader["parkingNameEnglish"].ToString(); street = sqlDataReader["addressEnglish"].ToString(); city = sqlDataReader["cityEnglish"].ToString(); } else { name = sqlDataReader["name"].ToString(); street = sqlDataReader["street_name"].ToString(); city = sqlDataReader["City"].ToString(); } Parking parking = new Parking(parkingIdInt, name, city, street, houseNumInt, sqlDataReader["latitude"].ToString(), sqlDataReader["longitude"].ToString()); parking.Comment = sqlDataReader["comment"].ToString(); parking.Owner = sqlDataReader["parkId"].ToString(); parking.Coupon_text = sqlDataReader["coupon_text"].ToString(); parking.Current_Pnuyot = sqlDataReader["current_Pnuyot"].ToString(); parking.Image = sqlDataReader["image"].ToString(); parking.Image2 = sqlDataReader["image2"].ToString(); parking.Withlock = sqlDataReader["Withlock"].ToString(); parking.Underground = sqlDataReader["Underground"].ToString(); parking.Nolimit = sqlDataReader["Nolimit"].ToString(); parking.Roof = sqlDataReader["Roof"].ToString(); parking.Criple = sqlDataReader["Criple"].ToString(); parking.Toshav = sqlDataReader["toshav"].ToString(); parking.Jenion = sqlDataReader["jenion"].ToString(); parking.FirstHourPrice = sqlDataReader["firstHourPrice"].ToString(); parking.ExtraQuarterPrice = sqlDataReader["extraQuarterPrice"].ToString(); parking.AllDayPrice = sqlDataReader["allDayPrice"].ToString(); parking.Distance = Convert.ToInt32(sqlDataReader["Distance"].ToString()); if ("ahuzot".Equals(parking.Owner)) { try { String externalIdStr = sqlDataReader["externalid"].ToString(); if ("NULL".Equals(externalIdStr) || "".Equals(externalIdStr.Trim())) externalIdStr = "-1"; int externalId = Convert.ToInt32(externalIdStr); new Thread(() => AhuzotHoffApi.updateServiceProviderLog("findAllGarageParkingDataByLatitudeLongitude", sessionId, externalId)).Start(); } catch (Exception e) { log.Error(e.Message); } } if (demo) { parking.Current_Pnuyot = random.Next(-1, 10) + ""; if (parking.FirstHourPrice == "" || parking.FirstHourPrice == "NULL" || parking.FirstHourPrice == "0") { parking.FirstHourPrice = "25"; } } parkingList.Add(parking); } } else { return null; } } return parkingList; } } }
public List<Parking> findGarageParkingFilteredByParams(String sessionId, float latitude, float longitude, int distance, String payment, String nolimit, String withlock, String tatkarkait, String roof, String toshav, String criple,String language) { if (!authenticateUser(sessionId)) { throw Utils.RaiseException(Context.Request.Url.AbsoluteUri, "findGarageParkingFilteredByParams", USER_NOT_AUTHENTICATE, "401", "findGarageParkingFilteredByParams"); } language = getLanguage(language); String conStr = ConfigurationManager.ConnectionStrings["CityParkCS"].ConnectionString; using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand()) { String paramsSql = Utils.getParkingParams(payment, nolimit, withlock, tatkarkait, roof, toshav, criple); String loginSql = String.Format( @"DECLARE @USER geography = geography::Point({0}, {1},4326) DECLARE @Date DATETIME SET @Date = GETDATE() SELECT top 200.*, CASE WHEN DATEPART(dw, @Date) BETWEEN 1 and 5 and DATENAME(hour, @Date)< Weekday_OneTimeHour THEN (select WeekDay_FirstHourPrice) WHEN DATEPART(dw, @Date) BETWEEN 1 and 5 and DATENAME(hour, @Date)>=Weekday_OneTimeHour THEN (select Weekday_OneTimePrice) WHEN DATEPART(dw, @Date)=6 and DATENAME(hour, @Date)<Friday_OneTimeHour THEN (select Friday_FirstHourPrice) WHEN DATEPART(dw, @Date)=6 and DATENAME(hour, @Date)>=Friday_OneTimeHour THEN (select Friday_OneTimePrice) WHEN DATEPART(dw, @Date)=7 and DATENAME(hour, @Date)<Saturday_FirstHourPrice THEN (select Saturday_FirstHourPrice) WHEN DATEPART(dw, @Date)=7 and DATENAME(hour, @Date)>=Saturday_OneTimeHour THEN (select Saturday_OneTimePrice) END AS FirstHourPrice, CASE WHEN DATEPART(dw, @Date) BETWEEN 1 and 5 THEN (select WeekDay_extraQuarterPrice) WHEN DATEPART(dw, @Date)=6 THEN (select Friday_extraQuarterPrice) WHEN DATEPART(dw, @Date)=7 THEN (select Saturday_extraQuarterPrice) ELSE WeekDay_extraQuarterPrice END AS extraQuarterPrice, @USER.STDistance(geography::Point(latitude,longitude,4326)) as Distance, allDayPrice FROM [CITYPARK].[dbo].[Parking] WHERE Heniontype='חניון' and @USER.STDistance(geography::Point(latitude,longitude,4326))<{2}{3} order by Distance,vip asc", latitude, longitude, distance, paramsSql);//note: "and Current_Pnuyot>0" and isnumeric (b.firsthourprice)=1 was removed cmd.Connection = con; cmd.CommandText = loginSql; con.Open(); List<Parking> parkingList = new List<Parking>(); using (SqlDataReader sqlDataReader = cmd.ExecuteReader()) { if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { String parkingID = sqlDataReader["parkingID"].ToString(); String qHouseNumber = sqlDataReader["house_number"].ToString(); if ("NULL".Equals(qHouseNumber) || "".Equals(qHouseNumber.Trim())) qHouseNumber = "0"; String name; String street; String city; if (language.Equals("en")) { name = sqlDataReader["parkingNameEnglish"].ToString(); street = sqlDataReader["addressEnglish"].ToString(); city = sqlDataReader["cityEnglish"].ToString(); } else { name = sqlDataReader["name"].ToString(); street = sqlDataReader["street_name"].ToString(); city = sqlDataReader["City"].ToString(); } Parking parking = new Parking(Convert.ToInt32(parkingID), name, city, street, Convert.ToInt32(qHouseNumber), sqlDataReader["latitude"].ToString(), sqlDataReader["longitude"].ToString()); parking.Comment = sqlDataReader["comment"].ToString(); parking.Coupon_text = sqlDataReader["coupon_text"].ToString(); parking.Current_Pnuyot = sqlDataReader["current_Pnuyot"].ToString(); parking.Image = sqlDataReader["image"].ToString(); parking.Image2 = sqlDataReader["image2"].ToString(); parking.Withlock = sqlDataReader["Withlock"].ToString(); parking.Underground = sqlDataReader["Underground"].ToString(); parking.Nolimit = sqlDataReader["Nolimit"].ToString(); parking.Roof = sqlDataReader["Roof"].ToString(); parking.Criple = sqlDataReader["Criple"].ToString(); parking.Toshav = sqlDataReader["toshav"].ToString(); parking.Jenion = sqlDataReader["jenion"].ToString(); parking.FirstHourPrice = sqlDataReader["firstHourPrice"].ToString(); parking.ExtraQuarterPrice = sqlDataReader["extraQuarterPrice"].ToString(); parking.AllDayPrice = sqlDataReader["allDayPrice"].ToString(); parking.Owner = sqlDataReader["parkId"].ToString(); if ("ahuzot".Equals(parking.Owner)) { try { String externalIdStr = sqlDataReader["externalid"].ToString(); if ("NULL".Equals(externalIdStr) || "".Equals(externalIdStr.Trim())) externalIdStr = "-1"; int externalId = Convert.ToInt32(externalIdStr); new Thread(() => AhuzotHoffApi.updateServiceProviderLog("findGarageParkingFilteredByParams", sessionId, externalId)).Start(); } catch (Exception e) { log.Error(e.Message); } } parkingList.Add(parking); } } else { return null; } } return parkingList; } } }
public ExitEvent(DateTime dateTime, Car currentCar) : base(dateTime) { this.parking = new Parking(Parking.NONE); this.car = currentCar; }
public EntryEvent(DateTime dateTime, Parking currentParking, Car currentCar) : base(dateTime) { this.parking = currentParking; this.car = currentCar; }