public async Task <ActionResult> DeleteConfirmed(int id)
{
tblFacility tblfacility = await db.tblFacilities.FindAsync(id);
db.tblFacilities.Remove(tblfacility);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "FacilityID,FacilityName,FacilityDescription,FacilityRemarks")] tblFacility tblfacility)
{
if (ModelState.IsValid)
{
db.Entry(tblfacility).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tblfacility));
}
public async Task <ActionResult> Create(tblFacility tblfacility)
{
if (ModelState.IsValid)
{
db.tblFacilities.Add(tblfacility);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tblfacility));
}
/* Events */
/* FacilityBookings */
public object AddFacility(string FacilityName, int RatePerHour)
{
var DC = new DataClassesDataContext();
tblFacility FacilityObj = new tblFacility();
FacilityObj.FacilityName = FacilityName;
FacilityObj.RatePerHour = RatePerHour;
DC.tblFacilities.InsertOnSubmit(FacilityObj);
DC.SubmitChanges();
return(true);
}
// GET: /Facility/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblFacility tblfacility = await db.tblFacilities.FindAsync(id);
if (tblfacility == null)
{
return(HttpNotFound());
}
return(View(tblfacility));
}
public object EditFacility(int FacilityID, string FacilityName, int RatePerHour, bool IsActive)
{
var DC = new DataClassesDataContext();
tblFacility FacilityObj = (from ob in DC.tblFacilities
where ob.FacilityID == FacilityID
select ob).Single();
if (IsActive == true)
{
FacilityObj.FacilityName = FacilityName;
FacilityObj.RatePerHour = RatePerHour;
}
else
{
DC.tblFacilities.DeleteOnSubmit(FacilityObj);
}
DC.SubmitChanges();
return(true);
}
