// DELETE api/values/5 public bool Delete(int ID) { try { using (Smart_ParkingEntities1 context = new Smart_ParkingEntities1()) { //ParkingSlotMaster OneSlot = (from slot in context.ParkingSlotMasters // where slot.ID == ID // select slot).FirstOrDefault(); //context.ParkingSlotMasters.Attach(OneSlot); //context.ParkingSlotMasters.Remove(OneSlot); //context.SaveChanges(); //return true; ParkingSlotMaster OneSlot = new ParkingSlotMaster { ID = ID }; context.Entry(OneSlot).State = System.Data.EntityState.Deleted; context.SaveChanges(); return true; } } catch (Exception e) { Console.WriteLine(e); return false; } //delete }
// POST api/values //public void Post([FromBody]string value) //{ // //insert //} //PUT api/values/5 public bool Post(ParkingSlotMaster ParkSlotObj) { try { using (Smart_ParkingEntities1 context = new Smart_ParkingEntities1()) { //ParkingSlotMaster ParkSlotMastr = (from slot in context.ParkingSlotMasters // where slot.ID == ParkSlotObj.ID // select slot).SingleOrDefault(); ParkingSlotMaster ParkSlotMastr = (from slot in context.ParkingSlotMasters where slot.BarcodeNo == ParkSlotObj.BarcodeNo select slot).SingleOrDefault(); //ParkSlotMastr.ID = ParkSlotObj.ID; //ParkSlotMastr.ParkSlotID = ParkSlotObj.ParkSlotID; //ParkSlotMastr.SlotName = ParkSlotObj.SlotName; //ParkSlotMastr.Address = ParkSlotObj.Address; ParkSlotMastr.BarcodeNo = ParkSlotObj.BarcodeNo; ParkSlotMastr.IsOccupied = ParkSlotObj.IsOccupied; //ParkSlotMastr.OccupiedBy = ParkSlotObj.OccupiedBy; //ParkSlotMastr.IsActive = ParkSlotObj.IsActive; //ParkSlotMastr.ParkInTime = ParkSlotObj.ParkInTime; //ParkSlotMastr.ParkOutTime = ParkSlotObj.ParkOutTime; context.SaveChanges(); return true; } } catch (Exception e) { Console.WriteLine(e); return false; } //update }