private void PageDataRefresh() { BookingsTableAdapter bookingAdapter = new BookingsTableAdapter(); LvBookingList.DataSource = bookingAdapter.GetDataByUserID(User.Identity.GetUserId()); LvBookingList.DataBind(); }
private void PageDataRefresh() { string bUserName = txtSearchUsername.Text.Trim(); string bRegistrationPlate = txtSearchVehiclePlate.Text.Trim(); string bDescription = txtSearchVehicleType.Text.Trim(); string bStatus = txtSearchStatus.Text.Trim(); // Validity checks bool valid_bID = int.TryParse(txtSearchBookingID.Text.Trim(), out int bID); if (!valid_bID || bID < -1) { bID = -1; } bool valid_bDailyRateStart = Decimal.TryParse(txtSearchDailyRateChargedStart.Text.Trim(), out Decimal bDailyRateStart); bool valid_bDailyRateEnd = Decimal.TryParse(txtSearchDailyRateChargedEnd.Text.Trim(), out Decimal bDailyRateEnd); if (!valid_bDailyRateStart) { bDailyRateStart = 0; } if (!valid_bDailyRateEnd) { bDailyRateEnd = Int32.MaxValue; } bool valid_bDateTimeFromStart = DateTime.TryParse(txtSearchDateFromStart.Text.Trim(), out DateTime bDateTimeFromStart); bool valid_bDateTimeFromEnd = DateTime.TryParse(txtSetxtDateFromEnd.Text.Trim(), out DateTime bDateTimeFromEnd); bool valid_bDateTimeDueStart = DateTime.TryParse(txtSearchPickupStart.Text.Trim(), out DateTime bDateTimePickupStart); bool valid_bDateTimeDueEnd = DateTime.TryParse(txtSearchPickupEnd.Text.Trim(), out DateTime bDateTimePickupEnd); bool valid_bDateTimePickupStart = DateTime.TryParse(txtSearchDueStart.Text.Trim(), out DateTime bDateTimeDueStart); bool valid_bDateTimePickupEnd = DateTime.TryParse(txtSearchDueEnd.Text.Trim(), out DateTime bDateTimeDueEnd); bool valid_bDateTimeReturnStart = DateTime.TryParse(txtSearchReturnStart.Text.Trim(), out DateTime bDateTimeReturnStart); bool valid_bDateTimeReturnEnd = DateTime.TryParse(txtSearchReturnEnd.Text.Trim(), out DateTime bDateTimeReturnEnd); if (!valid_bDateTimeFromStart) { bDateTimeFromStart = Convert.ToDateTime("1/1/1753 12:00:00 AM"); } if (!valid_bDateTimeFromEnd) { bDateTimeFromEnd = DateTime.MaxValue; } if (!valid_bDateTimeDueStart) { bDateTimeDueStart = Convert.ToDateTime("1/1/1753 12:00:00 AM"); } if (!valid_bDateTimeDueEnd) { bDateTimeDueEnd = DateTime.MaxValue; } if (!valid_bDateTimePickupStart) { bDateTimePickupStart = Convert.ToDateTime("1/1/1753 12:00:00 AM"); } if (!valid_bDateTimePickupEnd) { bDateTimePickupEnd = DateTime.MaxValue; } if (!valid_bDateTimeReturnStart) { bDateTimeReturnStart = Convert.ToDateTime("1/1/1753 12:00:00 AM"); } if (!valid_bDateTimeReturnEnd) { bDateTimeReturnEnd = DateTime.MaxValue; } BookingsTableAdapter bookingAdapter = new BookingsTableAdapter(); LvBookingList.DataSource = bookingAdapter.GetDataByParameters(bID, "", -1, bDateTimeFromStart, bDateTimeFromEnd, bDateTimeDueStart, bDateTimeDueEnd, bDateTimePickupStart, bDateTimePickupEnd, bDateTimeReturnStart, bDateTimeReturnEnd, bStatus, bDailyRateStart, bDailyRateEnd); LvBookingList.DataBind(); }