public ParkingStatus Get(int id) { ParkingStatus ps = null; try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT parking_status_id, parking_status " + "FROM parking_statuses " + "WHERE parking_status_id = @parkingstatusid", conn); cmd.Parameters.AddWithValue("@parkingstatusid", id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows && reader.Read()) { ps = GetParkingStatusFromReader(reader); } } } catch (SqlException) { throw; } return(ps); }
public async Task<ParkingStatus> GetParkingStatus(int parkingID) { ParkingStatus status = null; try { //get current status from the ledger status = await AccessLedger.GetParkingStatusAsync(parkingID); //if there isn't a status in the ledger, return a new blank status if (status == null) { status = new ParkingStatus() { ParkingId = parkingID, BusySpaces = 0 }; } //get total spaces from db status.TotalAvailableSpaces = GetParking(parkingID).Spaces.Count; } catch (Exception ex) { } return status; }
public ActionResult ParkStatus(ParkingStatus parkingStatus) { try { var data = parkingBussiness.ParkStatus(parkingStatus); string message; if (data == null) { bool success = false; message = "Data not Found"; return(Ok(new { success, message })); } else { bool success = true; message = "Parking Status"; return(Ok(new { success, message, data })); } } catch (Exception) { bool success = false; string message = "Fail to Unpark"; return(BadRequest(new { success, message })); } }
public List <ParkingStatus> List() { List <ParkingStatus> parkingStatuses = new List <ParkingStatus>(); ParkingStatus ps = new ParkingStatus(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT parking_status_id, parking_status " + "FROM parking_statuses " + "ORDER BY parking_status_id", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.HasRows && reader.Read()) { ps = GetParkingStatusFromReader(reader); parkingStatuses.Add(ps); } } } catch (SqlException) { throw; } return(parkingStatuses); }
/// <summary> /// 获取停车状态的字符串描述 /// </summary> /// <param name="parkingFlag"></param> /// <returns></returns> public static string GetDescription(ParkingStatus parkingFlag) { //所有这几个设置了一下顺序,这个方法不好,但没有想到更好的方法 if ((parkingFlag & ParkingStatus.IndoorIn) == ParkingStatus.IndoorIn) { return(Resource1.ParkingStatus_IndoorIn); } if ((parkingFlag & ParkingStatus.In) == ParkingStatus.In) { return(Resource1.ParkingStatus_In); } if ((parkingFlag & ParkingStatus.Out) == ParkingStatus.Out) { return(Resource1.ParkingStatus_Out); } if ((parkingFlag & ParkingStatus.AsTempCard) == ParkingStatus.AsTempCard) { return(Resource1.ParkingStatus_AsTempCard); } if ((parkingFlag & ParkingStatus.Consume) == ParkingStatus.Consume) { return(Resource1.ParkingStatus_Consume); } if ((parkingFlag & ParkingStatus.NestedParkMarked) == ParkingStatus.NestedParkMarked) { return(Resource1.ParkingStatus_NestedParkMarked); } if ((parkingFlag & ParkingStatus.PaidBill) == ParkingStatus.PaidBill) { return(Resource1.ParkingStatus_PaidBill); } return(string.Empty); }
/// <summary> /// 获取卡片开始时间当天的计算停车费用的收费费率 /// </summary> /// <param name="cardType">卡片类型</param> /// <param name="carType">车型</param> /// <param name="parkingStatus">停车状态</param> /// <param name="beginning">开始时间</param> /// <returns></returns> private TariffBase GetCalculateTariff(Byte?cardType, Byte carType, ParkingStatus parkingStatus, DateTime beginning) { TariffType tt = TariffType.Normal; if ((parkingStatus & ParkingStatus.NestedParkMarked) == ParkingStatus.NestedParkMarked) { if (HolidaySetting.Current.IsHoliday(beginning)) { tt = TariffType.HolidayAndInnerRoom; } else { tt = TariffType.InnerRoom; } } else { if (HolidaySetting.Current.IsHoliday(beginning)) { tt = TariffType.Holiday; } } TariffBase tb = GetTariff(cardType, carType, tt);//tt为null时免费 return(tb); }
private ParkingStatus GetParkingStatusFromReader(SqlDataReader reader) { ParkingStatus ps = new ParkingStatus() { ParkingStatusId = Convert.ToInt32(reader["parking_status_id"]), ParkingStatusName = Convert.ToString(reader["parking_status"]) }; return(ps); }
public ParkingSummaryViewModel(ParkingReservedViewModel parentViewModel, ParkingStatus status, IPlatformService platformService, IApiService apiService, ICacheService cacheService) : base(apiService, cacheService) { this.mParentViewModel = parentViewModel; this.Status = status; this.mPlatformService = platformService; Reservation = mCacheService.CurrentReservation; IsShowLeaveReportButton = Reservation.LeavingStatus == null || Reservation.LeavingStatus.Equals("na"); }
public async Task <ParkingStatus> GetParkingStatusAsync(int parkingId) { if (!IsInizialized) { return(null); } ParkingStatus status = await DocumentDBRepository <ParkingStatus> .GetItemAsync("_status_" + parkingId); return(status); }
public object ParkStatus(ParkingStatus parkingStatus) { try { var result = parkingRepository.ParkStatus(parkingStatus); return(result); } catch (Exception e) { throw new Exception(e.Message); } }
public void UnParkDetails_ReturnOKResult() { //Arrange ParkingStatus details = new ParkingStatus() { ReceiptNo = 2010 }; // Act var okResult = parkingLotController.ParkStatus(details); // Assert Assert.IsType <OkObjectResult>(okResult); }
public IActionResult Get(int id) { ParkingStatus ps = parkingStatusDAO.Get(id); if (ps == null) { return(NoContent()); } else { return(Ok(ps)); } }
public void UnParkDetails_ReturnBadRequest() { ParkingStatus details = new ParkingStatus() { ReceiptNo = 10 }; // Act var badRequest = parkingLotController.ParkStatus(details); // Assert Assert.IsType <BadRequestObjectResult>(badRequest); }
public async void Init(ParkingStatus status, int timeLeft, long startTime) { Status = status; TotalParkingTime = timeLeft; Title = startTime.UnixTimeStampToDateTime().ToString("MM/dd/yyyy"); await Task.Delay(100); OverviewResumeTitle = TextSource.GetText("OverviewText"); if (View != null) { View.ChangeBarButton(); } }
public async Task <ParkingStatus> GetParkingStatusAsync(int parkingId) { using (HttpClient client = new HttpClient()) { try { client.BaseAddress = Endpoint; var result = await client.GetAsync("getparkingstatus/" + parkingId); result.EnsureSuccessStatusCode(); ParkingStatus status = JsonConvert.DeserializeObject <ParkingStatus>(await result.Content.ReadAsStringAsync()); return(status); } catch (Exception ex) { return(null); } } }
public async void Init(ParkingStatus status, bool isReadOnly) { IsReadOnly = isReadOnly; Status = status; SummaryVM = new ParkingSummaryViewModel(this, Status, mPlatformService, mApiService, mCacheService); //if (mCacheService.CurrentReservation != null) SummaryVM.Reservation = mCacheService.CurrentReservation; SummaryVM.IsReadOnly = IsReadOnly; //MapVM = new ParkingMapViewModel(this, mPlatformService, mApiService, mCacheService); SummaryVM.Init(); //MapVM.Init(); await Task.Delay(100); OverviewResumeTitle = TextSource.GetText("OverviewText"); //TotalParkingTime = (int)(long.Parse(SummaryVM.Reservation.EndTimestamp) - long.Parse(SummaryVM.Reservation.StartTimestamp)); CheckTotalParkingTime(); }
public static IActionResult GetParkingStatusAsync( [HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "getparkingstatus/{parkingId}")] HttpRequestMessage req, [CosmosDB("ParkingLedger", "VehicleAccesses", ConnectionStringSetting = "CosmosDBEndpoint", SqlQuery = "SELECT * FROM c WHERE c.ParkingID = {parkingId}", CreateIfNotExists = true, PartitionKey = "/Access/ParkingID")] IEnumerable <dynamic> docs, int parkingId, ILogger log) { if (docs == null || docs.Count() == 0) { return(new NotFoundResult()); } var doc = docs.FirstOrDefault(); ParkingStatus status = new ParkingStatus { BusySpaces = (int)doc.busySpaces, ParkingId = doc.ParkingID }; return(new OkObjectResult(status)); }
public object ParkStatus(ParkingStatus parkingStatus) { try { double total = db.parkingPortals.Where(p => p.ReceiptNo == parkingStatus.ReceiptNo) .Select(i => (DateTime.Now.Subtract(i.ParkingDate).TotalMinutes)).Sum(); parkingStatus.Date = DateTime.Now; parkingStatus.Charges = Convert.ToInt32(total * 10); var Status = db.parkingPortals.Find(parkingStatus.ReceiptNo); Status.Status = "UnPark"; db.parkingPortals.Update(Status); db.Add(parkingStatus); db.SaveChanges(); var data = (from p in db.parkingPortals where p.ReceiptNo == parkingStatus.ReceiptNo from q in db.ParkingStatuses select new { p.ReceiptNo, p.DriverName, p.Brand, p.VehicleColor, p.Slot, p.VehicleNumber, p.ParkingDate, parkingStatus.Date, parkingStatus.Charges }).FirstOrDefault(); return(data); } catch (Exception e) { throw new Exception(e.Message); } }
public async Task <IActionResult> GetStatus(int parkingId) { if (!_store.IsInitialized) { return(StatusCode(StatusCodes.Status500InternalServerError, "Not initialized")); } if (parkingId <= 0) { return(BadRequest()); } var parking = _store.GetParking(parkingId); if (parking == null) { return(NotFound()); } ParkingStatus status = await _store.GetParkingStatus(parkingId); return(Json(status)); }
private void AllocateParkingSlots(bool isCalledFromBarcodeScanner, string barcodeNo, ParkingStatus parkStatus) { WebAPICaller myWebAPICaller = new WebAPICaller(); string selParking = IsolatedStorageSettings.ApplicationSettings[_SelParking].ToString(); string urlParam = "userId=" + UserID + "&parkingId=" + selParking + "&slotNo=" + barcodeNo + "&SlotStatus=" + ((int)parkStatus).ToString(); myWebAPICaller.POST_urlParam("SlotMaster/PostParkUnPark", urlParam ); if (isCalledFromBarcodeScanner) { object slot = _SlotContainer.FindName(barcodeNo); if (slot == null) return; ((ParkingSlot)slot).ParkStatus = parkStatus; } }
public void MakeMeFree() { Background = new SolidColorBrush(Colors.White); _ParkStatus = ParkingStatus.Free; }