public IHttpActionResult UpdateBus(int id, BusDetail changedetail)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid Model"));
}
using (var bus = new BusReservationEntities1())
{
var existingbus = bus.BusDetails.Where(p => p.BusID == changedetail.BusID).FirstOrDefault <BusDetail>();
if (existingbus != null)
{
existingbus.BusNumber = changedetail.BusNumber;
existingbus.DriverID = changedetail.DriverID;
existingbus.DriverPhone = changedetail.DriverPhone;
existingbus.BusType = changedetail.BusType;
existingbus.NumberOfSeats = changedetail.NumberOfSeats;
existingbus.BusAvailability = changedetail.BusAvailability;
bus.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public object AddBus(BusDetail busDetail)
{
int count = db.BusDetails.ToList().Where(bus => bus.BusID == busDetail.BusID).Count();
if (count == 1)
{
return("This Bus Already Exists");
}
else
{
db.proc_AddBus(busDetail.BusNumber, busDetail.DriverID, busDetail.DriverPhone, busDetail.BusType, busDetail.NumberOfSeats, busDetail.BusAvailability);
db.SaveChanges();
return("Bus Registered Successfully");
}
}
public static void AddBusDetail(BusDetail bd)
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.Connection = conn;
try
{
cmd.CommandText = "INSERT INTO BusDetail VALUES(@id,@bid,@time,@date,@availableSeat)";
cmd.Parameters.AddWithValue("@id", bd.BusDetailID);
cmd.Parameters.AddWithValue("@bid", bd.BusID);
cmd.Parameters.AddWithValue("@time", bd.DepartureTime);
cmd.Parameters.AddWithValue("@date", bd.DepartureDate);
cmd.Parameters.AddWithValue("@availableSeat", bd.AvailableSeat);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
}
protected void AddBus(object sender, EventArgs e)
{
string name = txtBusName.Text;
string routeID = ddlRoute.SelectedItem.Text;
string f = txtFare.Text;
string date = txtDate.Value;
string seat = txtSeat.Text;
string time = txtTime.Text;
double fare;
int totalSeat;
if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(f) || string.IsNullOrEmpty(date) ||
string.IsNullOrEmpty(time) || string.IsNullOrEmpty(seat))
{
AlertMessage("All data must not be empty!", "alert alert-danger");
}
else if (!double.TryParse(txtFare.Text, out fare) || fare <= 0)
{
AlertMessage("Fare must be a possitive number!", "alert alert-danger");
}
else if (!int.TryParse(seat, out totalSeat) || totalSeat <= 0)
{
AlertMessage("Total seat must be a possitive number!", "alert alert-danger");
}
else
{
SqlConnection conn = DAO.Connection;
SqlCommand cmd = conn.CreateCommand();
conn.Open();
Bus b = new Bus();
// create random and check BusID duplicate
string bid;
do
{
cmd.Parameters.Clear();
bid = DAO.RandomID();
cmd.CommandText = "SELECT * FROM Buses WHERE BusID = @id";
cmd.Parameters.AddWithValue("@id", bid);
SqlDataReader reader = cmd.ExecuteReader();
bool exist = reader.Read();
reader.Close();
if (!exist)
{
break;
}
} while (true);
//insert bus
b.BusID = bid;
b.BusName = name;
b.RouteID = routeID;
b.Fare = fare;
b.TotalSeat = totalSeat;
BusDAO.AddBus(b);
// create random and check BusDetailID duplicate
string bdID;
do
{
cmd.Parameters.Clear();
bdID = DAO.RandomID();
cmd.CommandText = "SELECT * FROM BusDetail WHERE BusDetailID = @bdid";
cmd.Parameters.AddWithValue("@bdid", bdID);
SqlDataReader reader = cmd.ExecuteReader();
bool exist = reader.Read();
reader.Close();
if (!exist)
{
break;
}
} while (true);
BusDetail bd = new BusDetail();
bd.BusDetailID = bdID;
bd.BusID = bid;
bd.DepartureTime = time;
bd.DepartureDate = Convert.ToDateTime(date);
bd.AvailableSeat = totalSeat;
BusDetailDAO.AddBusDetail(bd);
conn.Close();
Response.Redirect("AdminBus.aspx");
}
}
