public virtual void Delete(TEntity entityToDelete) { if (context.Entry(entityToDelete).State == EntityState.Detached) { dbSet.Attach(entityToDelete); } dbSet.Remove(entityToDelete); }
public ActionResult Edit(Persoon persoon) { if (ModelState.IsValid) { db.Entry(persoon).State = EntityState.Modified; db.Entry(persoon.Adres).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AdresId = new SelectList(db.adressen, "Id", "Straat", persoon.AdresId); return(View(persoon)); }
public IHttpActionResult PutCUSTOMER_COMPLAINTS(int id, CUSTOMER_COMPLAINTS cUSTOMER_COMPLAINTS) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != cUSTOMER_COMPLAINTS.COMPLAINT_ID) { return(BadRequest()); } db.Entry(cUSTOMER_COMPLAINTS).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CUSTOMER_COMPLAINTSExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutLOG(long id, LOG lOG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != lOG.LOG_ID) { return(BadRequest()); } db.Entry(lOG).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!LOGExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutCV_TABLE(long id, CV_USER cV_TABLE) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != cV_TABLE.ID) { return(BadRequest()); } db.Entry(cV_TABLE).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CV_TABLEExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutATTACHMENT(long id, CV_ITEM_LINK aTTACHMENT) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != aTTACHMENT.ID) { return(BadRequest()); } db.Entry(aTTACHMENT).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ATTACHMENTExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private void DeleteItem() { using (var context = new MyEntities()) { context.Entry(_selectedEquipment.ToModel()).State = EntityState.Deleted; context.SaveChanges(); } Equipment.Remove(_selectedEquipment); }
public ActionResult Edit([Bind(Include = "Id,Name,Location")] RESTAURANT rESTAURANT) { if (ModelState.IsValid) { db.Entry(rESTAURANT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(rESTAURANT)); }
private void saveCommand() { if (Regex.IsMatch(_selectedEquipment.EquipmentName, @"^^(?! )[A-Za-z\s]+$")) { using (var context = new MyEntities()) { context.Entry(_selectedEquipment.ToModel()).State = EntityState.Modified; context.SaveChanges(); } _listViewModel.CloseEditItem(); } }
public ActionResult Edit([Bind(Include = "Id,RestaurantId,UserId,Name,Quality,Taste,Price,Service,Comment")] DISHES_REVIEWS dISHES_REVIEWS) { if (ModelState.IsValid) { db.Entry(dISHES_REVIEWS).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RestaurantId = new SelectList(db.RESTAURANTS, "Id", "Name", dISHES_REVIEWS.RestaurantId); ViewBag.UserId = new SelectList(db.USERS, "Id", "UserName", dISHES_REVIEWS.UserId); return(View(dISHES_REVIEWS)); }
private void DeleteNinja() { using (var context = new MyEntities()) { if (_ninjaInventoryWindow != null) { _ninjaInventoryWindow.Close(); } ServiceLocator.Current.GetInstance <NinjaInventoryViewModel>().CloseShop(); context.Entry(SelectedNinja.ToModel()).State = EntityState.Deleted; context.SaveChanges(); } Ninjas.Remove(SelectedNinja); }
public IHttpActionResult UpdateCriteria(long id, CRITERIA cRITERIA) { if (HttpContext.Current.Request.Cookies.AllKeys.Contains("sid")) { try { response = identity.Auth(HttpContext.Current.Request.Cookies.Get("sid").Value); } catch { return(BadRequest("Invalid token. Login in again!")); } if (!response.Roles.Contains("ADMIN")) { return(BadRequest("You are not authorized for this action")); } } else { return(BadRequest("You are not logged in. Please login and try again.")); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != cRITERIA.ID_CRITERIA) { return(BadRequest("id doesn't match")); } cRITERIA.DATE_MODIFIED = DateTime.Now; db.Entry(cRITERIA).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CRITERIAExists(id)) { return(NotFound()); } } return(Ok(cRITERIA)); }
public virtual void Update(T entity) { dbset.Attach(entity); dataContext.Entry(entity).State = EntityState.Modified; }
public IHttpActionResult UpdateStatus(long cv_item_id, int status_id) { if (HttpContext.Current.Request.Cookies.AllKeys.Contains("sid")) { try { response = identity.Auth(HttpContext.Current.Request.Cookies.Get("sid").Value); } catch { return(BadRequest("Invalid token. Login in again!")); } if (!(response.Roles.Contains("ADMIN") || response.Roles.Contains("STUDENTSKA"))) { return(BadRequest("You are not authorized for this action")); } } else { return(BadRequest("You are not logged in. Please login and try again.")); } try { var status = db.CV_ITEM_STATUS.Where(a => a.ID == status_id).Single(); var result = db.CV_ITEM.Where(a => a.ID_ITEM == cv_item_id).Single(); result.STATUS_ID = status_id; if (status.STATUS == "confirmed" || status.STATUS == "rejected" || status_id == 3) { string statuschange = ""; if (status.STATUS == "confirmed") { statuschange = "CONFIRMED"; } else if (status.STATUS == "rejected") { statuschange = "REJECTED"; } else if (status_id == 3) { statuschange = "RESTORED"; } var log = new LOG(); log.EVENT_CREATED = DateTime.Now; log.EVENT_TYPE = statuschange; log.DESCRIPTION = cv_item_id.ToString(); log.USER_ID = response.UserId; db.LOG.Add(log); db.SaveChanges(); } //saving to database db.Entry(result).State = EntityState.Modified; db.SaveChanges(); return(Ok()); } catch (Exception) { return(NotFound()); } }