public async Task <IActionResult> Edit(int id, [Bind("ActorID,ActorFullName,ActorNotes")] FacilitiesList facilities)
{
if (id != facilities.FacilityID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(facilities);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FacilitiesListExists(facilities.FacilityID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(facilities));
}
public async Task <IActionResult> Create([Bind("ActorID,ActorFullName,ActorNotes")] FacilitiesList facilities)
{
if (ModelState.IsValid)
{
_context.Add(facilities);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(facilities));
}
protected void ViewBookedFacilities()
{
SqlConnection conn = new SqlConnection
("Server=DESKTOP-41H50KG\\SQLEXPRESS; Database=clubone; Uid=20201113; password=123456");
conn.Open();
SqlCommand cmd = new
SqlCommand("select Facility.fName, BookingFacility.days, BookingFacility.timeSlot, BookingFacility.status from BookingFacility, Facility where userID=@UID and BookingFacility.facilityID = Facility.fID", conn);
cmd.Parameters.Add("@UID", System.Data.SqlDbType.Int, 100).Value = Session["user_id"];
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt_bookedFacilities = new DataTable();
adapter.Fill(dt_bookedFacilities);
FacilitiesList.DataSource = dt_bookedFacilities;
FacilitiesList.DataBind();
}
protected void DataPagerFacilities_PreRender(object sender, EventArgs e)
{
FacilitiesList.DataSource = _fa.GetFacilities();
FacilitiesList.DataBind();
}
protected void LoadFacilitiesList()
{
FacilitiesList.DataSource = _fa.GetFacilities();
FacilitiesList.DataBind();
}
