public ActionResult ambulanceSchedulesDelete(int id = 0)
{
tbl_AmbulanceSchedule bc1 = db.tbl_AmbulanceSchedule.FirstOrDefault(s => s.AmbSchedulID == id);
db.tbl_AmbulanceSchedule.Remove(bc1);
db.SaveChanges();
return(RedirectToAction("ambulanceScheduleLists"));
}
public ActionResult ambulanceScheduleLists(string keyword, tbl_AmbulanceSchedule model)
{
var results = (from item in db.tbl_AmbulanceSchedule where item.tbl_AmbulanceInfo.AmbPlateNo.Contains(keyword) || item.GoingTime.Contains(keyword) || item.BackTime.Contains(keyword) select item).ToList();
var pageIndex = model.Page ?? 1;
model.ambulanceScheduleListsResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(model));
}
public ActionResult ambulanceScheduleLists(tbl_AmbulanceSchedule model)
{
var results = (from item in db.tbl_AmbulanceSchedule select item).ToList().OrderBy(p => p.AmbSchedulID);
var pageIdnex = model.Page ?? 1;
model.ambulanceScheduleListsResults = results.ToPagedList(pageIdnex, RecordsPerPage);
return(View(model));
}
public ActionResult addambulanceSechedule(tbl_AmbulanceSchedule ambulanceSchedule)
{
if (ModelState.IsValid)
{
db.tbl_AmbulanceSchedule.Add(ambulanceSchedule);
db.SaveChanges();
return(RedirectToAction("ambulanceScheduleLists"));
}
ViewBag.AmbID = new SelectList(db.tbl_AmbulanceInfo, "AmbID", "AmbPlateNo");
return(View(ambulanceSchedule));
}
public ActionResult ambulanceSchedulesUpdate(int id = 0)
{
ambulanceScheduleId = id;
tbl_AmbulanceSchedule bc = db.tbl_AmbulanceSchedule.FirstOrDefault(s => s.AmbSchedulID == ambulanceScheduleId);
if (bc == null)
{
return(HttpNotFound());
}
ViewBag.AmbID = new SelectList(db.tbl_AmbulanceInfo, "AmbID", "AmbPlateNo");
ViewBag.GetGoingTime = bc.GoingTime;
ViewBag.GetBackTime = bc.BackTime;
ViewBag.Date = bc.Date;
ViewBag.GetFreeOrBusy = bc.FreeOrBusy;
return(View(bc));
}
public ActionResult ambulanceSchedulesUpdate(tbl_AmbulanceSchedule bc, int id = 0)
{
tbl_AmbulanceSchedule bc1 = db.tbl_AmbulanceSchedule.FirstOrDefault(s => s.AmbSchedulID == ambulanceScheduleId);
bc1.AmbID = bc.AmbID;
bc1.GoingTime = bc.GoingTime;
bc1.BackTime = bc.BackTime;
bc1.Date = bc.Date;
bc1.FreeOrBusy = bc.FreeOrBusy;
if (bc1 == null)
{
return(HttpNotFound());
}
db.SaveChanges();
ViewBag.AmbID = new SelectList(db.tbl_AmbulanceInfo, "AmbID", "AmbPlateNo");
ViewBag.Messages = "Update Successfully";
return(View(bc1));
}
