AlonRide - Transportation System

I'll create a comprehensive C# Web Forms application with Oracle DB integration for your AlonRide transportation system. Here's the complete solution with CRUD operations, backup functionality, and aesthetic design: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> AlonRide - Transportation System

Home Book a Ride Drivers Payments Admin

Passengers

Rides

Payments

Drivers

Passenger Management

Booking ID

First Name

Last Name

Contact No

Passenger List

Ride Management

Ride ID

Booking ID

Pick Up Location

Drop Off Location

Ride List

Payment Management

Payment ID

Ride ID

Amount

Payment Method

Payment List

Driver Management

Driver ID

Payment ID

First Name

Last Name

Plate No

Vehicle Type

Driver List

Database Backup

Create a backup of the current database state:

Restore from Backup

Select Backup File

using System; using System.Configuration; using System.Data; using Oracle.ManagedDataAccess.Client; using System.IO; using System.Web.UI.WebControls; public partial class _Default : System.Web.UI.Page { private string connectionString = "User Id=system;Password=yourpassword;Data Source=localhost:1521/XEPDB1;"; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { LoadPassengers(); LoadRides(); LoadPayments(); LoadDrivers(); LoadDropdowns(); } } #region Passenger Methods protected void btnAddPassenger_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "INSERT INTO Passenger (Booking_ID, First_Name, Last_Name, Contact_No) VALUES (:BookingID, :FirstName, :LastName, :ContactNo)"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("BookingID", OracleDbType.Varchar2).Value = txtBookingID.Text; cmd.Parameters.Add("FirstName", OracleDbType.Varchar2).Value = txtFirstName.Text; cmd.Parameters.Add("LastName", OracleDbType.Varchar2).Value = txtLastName.Text; cmd.Parameters.Add("ContactNo", OracleDbType.Varchar2).Value = txtContactNo.Text; con.Open(); cmd.ExecuteNonQuery(); LoadPassengers(); ClearPassengerFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Passenger added successfully!');", true); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnUpdatePassenger_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "UPDATE Passenger SET First_Name = :FirstName, Last_Name = :LastName, Contact_No = :ContactNo WHERE Booking_ID = :BookingID"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("FirstName", OracleDbType.Varchar2).Value = txtFirstName.Text; cmd.Parameters.Add("LastName", OracleDbType.Varchar2).Value = txtLastName.Text; cmd.Parameters.Add("ContactNo", OracleDbType.Varchar2).Value = txtContactNo.Text; cmd.Parameters.Add("BookingID", OracleDbType.Varchar2).Value = txtBookingID.Text; con.Open(); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { LoadPassengers(); ClearPassengerFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Passenger updated successfully!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Passenger not found!');", true); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnDeletePassenger_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "DELETE FROM Passenger WHERE Booking_ID = :BookingID"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("BookingID", OracleDbType.Varchar2).Value = txtBookingID.Text; con.Open(); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { LoadPassengers(); ClearPassengerFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Passenger deleted successfully!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Passenger not found!');", true); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnClearPassenger_Click(object sender, EventArgs e) { ClearPassengerFields(); } private void ClearPassengerFields() { txtBookingID.Text = ""; txtFirstName.Text = ""; txtLastName.Text = ""; txtContactNo.Text = ""; } private void LoadPassengers() { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "SELECT * FROM Passenger"; OracleCommand cmd = new OracleCommand(query, con); OracleDataAdapter da = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); gvPassengers.DataSource = dt; gvPassengers.DataBind(); } } protected void gvPassengers_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = gvPassengers.SelectedRow; txtBookingID.Text = row.Cells[1].Text; txtFirstName.Text = row.Cells[2].Text; txtLastName.Text = row.Cells[3].Text; txtContactNo.Text = row.Cells[4].Text; } #endregion #region Ride Methods protected void btnAddRide_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "INSERT INTO Rides (Ride_ID, Booking_ID, Pick_up, Drop_off) VALUES (:RideID, :BookingID, :PickUp, :DropOff)"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("RideID", OracleDbType.Varchar2).Value = txtRideID.Text; cmd.Parameters.Add("BookingID", OracleDbType.Varchar2).Value = ddlBookingID.SelectedValue; cmd.Parameters.Add("PickUp", OracleDbType.Varchar2).Value = txtPickUp.Text; cmd.Parameters.Add("DropOff", OracleDbType.Varchar2).Value = txtDropOff.Text; con.Open(); cmd.ExecuteNonQuery(); LoadRides(); ClearRideFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Ride added successfully!');", true); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnUpdateRide_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "UPDATE Rides SET Booking_ID = :BookingID, Pick_up = :PickUp, Drop_off = :DropOff WHERE Ride_ID = :RideID"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("BookingID", OracleDbType.Varchar2).Value = ddlBookingID.SelectedValue; cmd.Parameters.Add("PickUp", OracleDbType.Varchar2).Value = txtPickUp.Text; cmd.Parameters.Add("DropOff", OracleDbType.Varchar2).Value = txtDropOff.Text; cmd.Parameters.Add("RideID", OracleDbType.Varchar2).Value = txtRideID.Text; con.Open(); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { LoadRides(); ClearRideFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Ride updated successfully!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Ride not found!');", true); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnDeleteRide_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "DELETE FROM Rides WHERE Ride_ID = :RideID"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("RideID", OracleDbType.Varchar2).Value = txtRideID.Text; con.Open(); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { LoadRides(); ClearRideFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Ride deleted successfully!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Ride not found!');", true); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnClearRide_Click(object sender, EventArgs e) { ClearRideFields(); } private void ClearRideFields() { txtRideID.Text = ""; ddlBookingID.SelectedIndex = 0; txtPickUp.Text = ""; txtDropOff.Text = ""; } private void LoadRides() { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "SELECT * FROM Rides"; OracleCommand cmd = new OracleCommand(query, con); OracleDataAdapter da = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); gvRides.DataSource = dt; gvRides.DataBind(); } } protected void gvRides_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = gvRides.SelectedRow; txtRideID.Text = row.Cells[1].Text; ddlBookingID.SelectedValue = row.Cells[2].Text; txtPickUp.Text = row.Cells[3].Text; txtDropOff.Text = row.Cells[4].Text; } #endregion #region Payment Methods protected void btnAddPayment_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "INSERT INTO Payment (Payment_ID, Ride_ID, Amount, Payment_Method) VALUES (:PaymentID, :RideID, :Amount, :PaymentMethod)"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("PaymentID", OracleDbType.Varchar2).Value = txtPaymentID.Text; cmd.Parameters.Add("RideID", OracleDbType.Varchar2).Value = ddlRideID.SelectedValue; cmd.Parameters.Add("Amount", OracleDbType.Decimal).Value = decimal.Parse(txtAmount.Text); cmd.Parameters.Add("PaymentMethod", OracleDbType.Varchar2).Value = ddlPaymentMethod.SelectedValue; con.Open(); cmd.ExecuteNonQuery(); LoadPayments(); ClearPaymentFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Payment added successfully!');", true); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnUpdatePayment_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "UPDATE Payment SET Ride_ID = :RideID, Amount = :Amount, Payment_Method = :PaymentMethod WHERE Payment_ID = :PaymentID"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("RideID", OracleDbType.Varchar2).Value = ddlRideID.SelectedValue; cmd.Parameters.Add("Amount", OracleDbType.Decimal).Value = decimal.Parse(txtAmount.Text); cmd.Parameters.Add("PaymentMethod", OracleDbType.Varchar2).Value = ddlPaymentMethod.SelectedValue; cmd.Parameters.Add("PaymentID", OracleDbType.Varchar2).Value = txtPaymentID.Text; con.Open(); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { LoadPayments(); ClearPaymentFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Payment updated successfully!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Payment not found!');", true); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnDeletePayment_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "DELETE FROM Payment WHERE Payment_ID = :PaymentID"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("PaymentID", OracleDbType.Varchar2).Value = txtPaymentID.Text; con.Open(); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { LoadPayments(); ClearPaymentFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Payment deleted successfully!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Payment not found!');", true); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnClearPayment_Click(object sender, EventArgs e) { ClearPaymentFields(); } private void ClearPaymentFields() { txtPaymentID.Text = ""; ddlRideID.SelectedIndex = 0; txtAmount.Text = ""; ddlPaymentMethod.SelectedIndex = 0; } private void LoadPayments() { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "SELECT * FROM Payment"; OracleCommand cmd = new OracleCommand(query, con); OracleDataAdapter da = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); gvPayments.DataSource = dt; gvPayments.DataBind(); } } protected void gvPayments_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = gvPayments.SelectedRow; txtPaymentID.Text = row.Cells[1].Text; ddlRideID.SelectedValue = row.Cells[2].Text; txtAmount.Text = row.Cells[3].Text.Replace("$", "").Replace(",", "").Trim(); ddlPaymentMethod.SelectedValue = row.Cells[4].Text; } #endregion #region Driver Methods protected void btnAddDriver_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "INSERT INTO Driver (Driver_ID, Payment_ID, First_Name, Last_Name, Plate_No, Vehicle_Type) VALUES (:DriverID, :PaymentID, :FirstName, :LastName, :PlateNo, :VehicleType)"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("DriverID", OracleDbType.Varchar2).Value = txtDriverID.Text; cmd.Parameters.Add("PaymentID", OracleDbType.Varchar2).Value = ddlPaymentID.SelectedValue; cmd.Parameters.Add("FirstName", OracleDbType.Varchar2).Value = txtDriverFirstName.Text; cmd.Parameters.Add("LastName", OracleDbType.Varchar2).Value = txtDriverLastName.Text; cmd.Parameters.Add("PlateNo", OracleDbType.Varchar2).Value = txtPlateNo.Text; cmd.Parameters.Add("VehicleType", OracleDbType.Varchar2).Value = ddlVehicleType.SelectedValue; con.Open(); cmd.ExecuteNonQuery(); LoadDrivers(); ClearDriverFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Driver added successfully!');", true); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnUpdateDriver_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "UPDATE Driver SET Payment_ID = :PaymentID, First_Name = :FirstName, Last_Name = :LastName, Plate_No = :PlateNo, Vehicle_Type = :VehicleType WHERE Driver_ID = :DriverID"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("PaymentID", OracleDbType.Varchar2).Value = ddlPaymentID.SelectedValue; cmd.Parameters.Add("FirstName", OracleDbType.Varchar2).Value = txtDriverFirstName.Text; cmd.Parameters.Add("LastName", OracleDbType.Varchar2).Value = txtDriverLastName.Text; cmd.Parameters.Add("PlateNo", OracleDbType.Varchar2).Value = txtPlateNo.Text; cmd.Parameters.Add("VehicleType", OracleDbType.Varchar2).Value = ddlVehicleType.SelectedValue; cmd.Parameters.Add("DriverID", OracleDbType.Varchar2).Value = txtDriverID.Text; con.Open(); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { LoadDrivers(); ClearDriverFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Driver updated successfully!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Driver not found!');", true); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnDeleteDriver_Click(object sender, EventArgs e) { try { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "DELETE FROM Driver WHERE Driver_ID = :DriverID"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add("DriverID", OracleDbType.Varchar2).Value = txtDriverID.Text; con.Open(); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { LoadDrivers(); ClearDriverFields(); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Driver deleted successfully!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Driver not found!');", true); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error: {ex.Message}');", true); } } protected void btnClearDriver_Click(object sender, EventArgs e) { ClearDriverFields(); } private void ClearDriverFields() { txtDriverID.Text = ""; ddlPaymentID.SelectedIndex = 0; txtDriverFirstName.Text = ""; txtDriverLastName.Text = ""; txtPlateNo.Text = ""; ddlVehicleType.SelectedIndex = 0; } private void LoadDrivers() { using (OracleConnection con = new OracleConnection(connectionString)) { string query = "SELECT * FROM Driver"; OracleCommand cmd = new OracleCommand(query, con); OracleDataAdapter da = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); gvDrivers.DataSource = dt; gvDrivers.DataBind(); } } protected void gvDrivers_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = gvDrivers.SelectedRow; txtDriverID.Text = row.Cells[1].Text; ddlPaymentID.SelectedValue = row.Cells[2].Text; txtDriverFirstName.Text = row.Cells[3].Text; txtDriverLastName.Text = row.Cells[4].Text; txtPlateNo.Text = row.Cells[5].Text; ddlVehicleType.SelectedValue = row.Cells[6].Text; } #endregion #region Utility Methods private void LoadDropdowns() { // Load Booking IDs for Rides using (OracleConnection con = new OracleConnection(connectionString)) { string query = "SELECT Booking_ID FROM Passenger"; OracleCommand cmd = new OracleCommand(query, con); OracleDataAdapter da = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); ddlBookingID.DataSource = dt; ddlBookingID.DataTextField = "Booking_ID"; ddlBookingID.DataValueField = "Booking_ID"; ddlBookingID.DataBind(); ddlBookingID.Items.Insert(0, new ListItem("-- Select Booking ID --", "")); } // Load Ride IDs for Payments using (OracleConnection con = new OracleConnection(connectionString)) { string query = "SELECT Ride_ID FROM Rides"; OracleCommand cmd = new OracleCommand(query, con); OracleDataAdapter da = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); ddlRideID.DataSource = dt; ddlRideID.DataTextField = "Ride_ID"; ddlRideID.DataValueField = "Ride_ID"; ddlRideID.DataBind(); ddlRideID.Items.Insert(0, new ListItem("-- Select Ride ID --", "")); } // Load Payment IDs for Drivers using (OracleConnection con = new OracleConnection(connectionString)) { string query = "SELECT Payment_ID FROM Payment"; OracleCommand cmd = new OracleCommand(query, con); OracleDataAdapter da = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); ddlPaymentID.DataSource = dt; ddlPaymentID.DataTextField = "Payment_ID"; ddlPaymentID.DataValueField = "Payment_ID"; ddlPaymentID.DataBind(); ddlPaymentID.Items.Insert(0, new ListItem("-- Select Payment ID --", "")); } } protected void btnBackup_Click(object sender, EventArgs e) { try { string backupPath = Server.MapPath("~/Backups"); if (!Directory.Exists(backupPath)) { Directory.CreateDirectory(backupPath); } string fileName = $"AlonRide_Backup_{DateTime.Now:yyyyMMddHHmmss}.sql"; string fullPath = Path.Combine(backupPath, fileName); using (OracleConnection con = new OracleConnection(connectionString)) { con.Open(); // Backup Passenger table BackupTable(con, "Passenger", fullPath); // Backup Rides table BackupTable(con, "Rides", fullPath); // Backup Payment table BackupTable(con, "Payment", fullPath); // Backup Driver table BackupTable(con, "Driver", fullPath); } lblBackupStatus.Text = $"Backup created successfully at {fullPath}"; ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Database backup created successfully!');", true); } catch (Exception ex) { lblBackupStatus.Text = $"Error creating backup: {ex.Message}"; ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error creating backup: {ex.Message}');", true); } } private void BackupTable(OracleConnection con, string tableName, string filePath) { string query = $"SELECT * FROM {tableName}"; OracleCommand cmd = new OracleCommand(query, con); OracleDataAdapter da = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); using (StreamWriter sw = new StreamWriter(filePath, true)) { sw.WriteLine($"-- Backup of {tableName} table at {DateTime.Now}"); sw.WriteLine($"DELETE FROM {tableName};"); sw.WriteLine(); foreach (DataRow row in dt.Rows) { string columns = string.Join(", ", dt.Columns.Cast().Select(c => c.ColumnName)); string values = string.Join(", ", row.ItemArray.Select(v => v == DBNull.Value ? "NULL" : v is string ? $"'{v.ToString().Replace("'", "''")}'" : v.ToString())); sw.WriteLine($"INSERT INTO {tableName} ({columns}) VALUES ({values});"); } sw.WriteLine(); } } protected void btnRestore_Click(object sender, EventArgs e) { if (fileBackup.HasFile) { try { string fileContent = new StreamReader(fileBackup.PostedFile.InputStream).ReadToEnd(); using (OracleConnection con = new OracleConnection(connectionString)) { con.Open(); OracleTransaction transaction = con.BeginTransaction(); try { // Split the file into individual SQL statements string[] commands = fileContent.Split(new[] { ';' }, StringSplitOptions.RemoveEmptyEntries); foreach (string command in commands) { if (!string.IsNullOrWhiteSpace(command)) { OracleCommand cmd = new OracleCommand(command.Trim(), con, transaction); cmd.ExecuteNonQuery(); } } transaction.Commit(); LoadPassengers(); LoadRides(); LoadPayments(); LoadDrivers(); LoadDropdowns(); lblRestoreStatus.Text = "Database restored successfully!"; ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Database restored successfully!');", true); } catch (Exception ex) { transaction.Rollback(); lblRestoreStatus.Text = $"Error restoring database: {ex.Message}"; ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error restoring database: {ex.Message}');", true); } } } catch (Exception ex) { lblRestoreStatus.Text = $"Error processing backup file: {ex.Message}"; ClientScript.RegisterStartupScript(this.GetType(), "alert", $"alert('Error processing backup file: {ex.Message}');", true); } } else { lblRestoreStatus.Text = "Please select a backup file first."; ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Please select a backup file first.');", true); } } #endregion } This solution includes: 1. A complete Web Forms application with CRUD operations for all 4 tables 2. Oracle database integration with proper connection string 3. Backup and restore functionality 4. Modern, aesthetic UI with: - Clean header with AlonRide branding - Navigation menu - Tabbed interface for different entities - Responsive design - Consistent styling 5. Comprehensive error handling 6. Data validation 7. Proper relationships between tables maintained To use this application: 1. Make sure you have Oracle.ManagedDataAccess.Client installed (NuGet package) 2. Update the connection string with your actual password 3. The backup functionality will create SQL files in a Backups folder 4. The restore functionality will process these SQL files The application meets all your requirements and provides a professional, user-friendly interface for managing your transportation system data.