public JsonResult GetReserveDetail(int id_reserve) { TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time"); DateTime dateTime = TimeZoneInfo.ConvertTime(DateTime.Now, zone); ReserveDetail detail = _reserveRepo.GetReserveDetail(id_reserve); Log.Information("Get reservation detail from web {id} {DateTime}.", id_reserve, dateTime); return(Json(detail)); }
/*Get reservation detail for web*/ public ReserveDetail GetReserveDetail(int id_reserve) { try { //find reservation var reserve = _dbContext.reservations.FirstOrDefault(x => x.Id_reserve == id_reserve); //BookingID,UserID,StartDate,EndDate,DateModified,Location,Size //if it is null if (reserve == null) { return(null); } int id_vacant = _dbContext.reservations.FirstOrDefault(x => x.Id_reserve == id_reserve).Id_vacancy; string mac_address = _dbContext.vacancies.FirstOrDefault(x => x.Id_vacancy == id_vacant).Mac_address; string location = _dbContext.lockerMetadatas.FirstOrDefault(x => x.Mac_address == mac_address).Location; string no_vacancy = _dbContext.vacancies.FirstOrDefault(x => x.Id_vacancy == id_vacant).No_vacancy; string size = _dbContext.vacancies.FirstOrDefault(x => x.Id_vacancy == id_vacant).Size; string name = _dbContext.accounts.FirstOrDefault(x => x.Id_account == reserve.Id_account).Name; //create form in order to return to the user ReserveDetail result = new ReserveDetail() { Id_user = reserve.Id_account, Name = name, BookingID = reserve.Id_reserve, StartDate = reserve.StartDay, EndDate = reserve.EndDay, DateModified = reserve.DateModified, Status = reserve.Status, Location = location, Size = size, NumberVacancy = no_vacancy }; return(result); } catch (Exception) { //error return(null); } }