public async Task <ActionResult <IEnumerable <Cart> > > GetTotalOrder(int cartId, string BuyrId) { try { var cart = _context.Cart.FirstOrDefault(s => s.CartId.Equals(cartId)); cart.Status = "U"; _context.Entry(cart).Property("Status").IsModified = true; await _context.SaveChangesAsync(); } catch (DbUpdateException /* ex */) { //Log the error (uncomment ex variable name and write a log. ModelState.AddModelError("", "Unable to save changes. " + "Try again, and if the problem persists " + "see your system administrator."); } return(await _context.Cart .Where(a => a.Status == "U" && a.BuyrID == BuyrId) .Include(vehicle => vehicle.AutosVehicle) .ThenInclude(make => make.CarMake) .Include(vehicle => vehicle.AutosVehicle) .ThenInclude(model => model.CarModel) .Include(vehicle => vehicle.AutosVehicle) .ThenInclude(carbody => carbody.CarBody) .ToListAsync()); }
public PartialViewResult Edit([Bind(Include = "Id,Description,Options,ExamId")] SingleSelectionQuestionWithOptionsViewModel model) { if (ModelState.IsValid) { SingleSelectionQuestion question = new SingleSelectionQuestion { Id = model.Id, ExamId = model.ExamId, Description = model.Description, Options = model.Options }; _db.Entry(question).State = EntityState.Modified; foreach (var option in question.Options) { _db.Entry(option).State = EntityState.Modified; } _db.SaveChanges(); question = _db.SingleSelectionQuestions.Include(q => q.Variables).Single(q => q.Id == question.Id); var evaluator = new NotationlessEvaluator(); question = evaluator.Evaluate(question) as SingleSelectionQuestion; return(PartialView("_Details", question)); } return(PartialView("_Edit", model)); }
public virtual void Delete(TEntity entityToDelete) { if (Context.Entry(entityToDelete).State == EntityState.Detached) { DbSet.Attach(entityToDelete); } DbSet.Remove(entityToDelete); }
/// <inheritdoc /> public async Task <SiteDTO> SaveAsync(SiteDTO model) { if (model == null) { throw new ArgumentException("Передана пустая объектная модель."); } EntityEntry <SiteStatus> siteStatusEntry = null; Guid id; var site = await Context.Sites.Select(x => x) .FirstOrDefaultAsync(x => x.Id == model.Id); if (site != null) { var siteEntry = Context.Entry(site); siteEntry.CurrentValues.SetValues(model); siteEntry.State = EntityState.Modified; var siteStatus = await Context.SiteStatuses.Select(x => x) .FirstOrDefaultAsync(x => x.Site.Id == model.Id); siteStatusEntry = Context.Entry(siteStatus); siteStatusEntry.Entity.CheckedInterval = model.CheckedInterval; siteStatusEntry.State = EntityState.Modified; id = site.Id; } else { var siteEntry = await Context.Sites.AddAsync(model.ToSite()); if (siteEntry != null) { var siteStatus = new SiteStatus { Site = siteEntry.Entity, CheckedInterval = model.CheckedInterval == 0 ? 5 : model.CheckedInterval }; siteStatusEntry = await Context.SiteStatuses.AddAsync(siteStatus); } id = siteEntry.Entity.Id; } if (siteStatusEntry != null) { await this.UpdateStatusFields(model, siteStatusEntry); } await Context.SaveChangesAsync(); return(await GetAsync(id)); }
public ActionResult Index(RequestSite site) { if (!String.IsNullOrEmpty(site.SiteName)) { HttpWebRequest request = (HttpWebRequest)WebRequest.Create(site.SiteName); Stopwatch sw = new Stopwatch(); sw.Start(); HttpWebResponse response = (HttpWebResponse)request.GetResponse(); response.Close(); sw.Stop(); site = new RequestSite { SiteName = site.SiteName, RequetsTime = sw.Elapsed.Milliseconds }; context.Entry(site).State = EntityState.Added; context.SaveChanges(); } return(RedirectToAction("Index")); }
public async Task <Element> PutElement([FromRoute] int id, [FromBody] Element element) { _context.Entry(element).State = EntityState.Modified; await _context.SaveChangesAsync(); return(_context.Elements.Single(e => e.ElementId == id)); }
public JsonResult AddOrUpdateLesson(int day, int lesson, string subject, int TeacherId) { int TimetableId = (int)Session["TimeTableId"]; Lesson find = db.Lessons.Where(s => s.TimetableId == TimetableId). Where(s => s.day == day).Where(s => s.number == lesson).FirstOrDefault(); if (find == null) { Lesson ls = new Lesson(); ls.day = day; ls.number = lesson; ls.name = subject; Teacher teacher = db.Teachers.Find(TeacherId); ls.TeachersName = teacher.LastName + " " + teacher.FirstName[0] + "." + teacher.FathersName[0] + "."; ls.TimetableId = (int)Session["TimeTableId"]; db.Lessons.Add(ls); } else { Teacher teacher = db.Teachers.Find(TeacherId); find.TeachersName = teacher.LastName + " " + teacher.FirstName[0] + "." + teacher.FathersName[0] + "."; find.name = subject; db.Lessons.Attach(find); db.Entry(find).State = EntityState.Modified; } db.SaveChanges(); return(Json(true)); }
public async Task <IActionResult> PutOrderMaster(int id, OrderMaster orderMaster) { if (id != orderMaster.INVNUM) { return(BadRequest()); } _context.Entry(orderMaster).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OrderMasterExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutSiteUsers(string id, SiteUsers siteUsers) { if (id != siteUsers.UserId) { return(BadRequest()); } _context.Entry(siteUsers).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SiteUsersExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutAutosVehicle(int id, AutosVehicle autosVehicle) { if (id != autosVehicle.AutoId) { return(BadRequest()); } _context.Entry(autosVehicle).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AutosVehicleExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <Character> > PutFilter([FromRoute] int id, [FromBody] Filter filter) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != filter.FilterId) { return(BadRequest()); } _context.Entry(filter).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FilterExists(id)) { return(NotFound()); } else { throw; } } return(_context.Character.Single(r => r.CharacterId == filter.CharacterId)); }
public ActionResult EditSite(Site site) { db.Entry(site).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <IActionResult> PutConference([FromRoute] int id, [FromBody] Conference conference) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != conference.ConferenceID) { return(BadRequest()); } _context.Entry(conference).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ConferenceExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutAutosBuyer(string id, AutosBuyer autosBuyer) { if (id != autosBuyer.BuyrID) { return(BadRequest()); } _context.Entry(autosBuyer).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AutosBuyerExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public string this[string key] { get { if (_cache[key] != null) { return(_cache[key] as string); } return(_db.Settings.Find(key)?.Value); } set { var setting = _db.Settings.Find(key); if (setting == null) { setting = new Setting { Id = key, Value = value }; _db.Settings.Add(setting); _db.SaveChanges(); } else { setting.Value = value; _db.Entry(setting).State = EntityState.Modified; _db.SaveChanges(); } _cache[key] = setting.Value; } }
public async Task <IActionResult> PutCarModel(string id, CarModel carModel) { if (id != carModel.ModlId) { return(BadRequest()); } _context.Entry(carModel).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CarModelExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void Update(TEntity entity, params object[] keyValues) { Expect.ArgumentNotNull(entity); var contextEntry = Context.Entry(entity); if (contextEntry != null) { var oldEntity = Context.Set <TEntity>().Find(keyValues); if (oldEntity != null) { var contextOldEntry = Context.Entry(oldEntity); contextOldEntry.CurrentValues.SetValues(entity); contextOldEntry.State = EntityState.Modified; Context.SaveChanges(); } } }
public void SaveQuestion(QuestionWithOptionsViewModel model) { MultipleSelectionQuestion question = new MultipleSelectionQuestion { Id = model.Id, ExamId = model.ExamId, Description = model.Description, Options = model.Options }; _db.Entry(question).State = EntityState.Modified; foreach (var option in question.Options) { _db.Entry(option).State = EntityState.Modified; } _db.SaveChanges(); }
public ActionResult Edit([Bind(Include = "ID,Name,Description")] DocumentType documentType) { if (ModelState.IsValid) { db.Entry(documentType).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(documentType)); }
public ActionResult Edit([Bind(Include = "UserID,LName,FName,CmtCount,SubDate")] User user) { if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Edit([Bind(Include = "ID,EventTitle,Description,Cost,Location")] Event @event) { if (ModelState.IsValid) { db.Entry(@event).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(@event)); }
public ActionResult Edit([Bind(Include = "ID,ProjectTitle,Description,Requirements,Location")] Project project) { if (ModelState.IsValid) { db.Entry(project).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(project)); }
public ActionResult Edit([Bind(Include = "ProductId,Title,Author,Price,Description,genre,Image,publisher")] Book book) { if (ModelState.IsValid) { db.Entry(book).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(book)); }
public ActionResult Edit([Bind(Include = "Id,LastName,FirstMidName,StreetAddress,Suburb,City,PostalCode")] Customer customer) { if (ModelState.IsValid) { db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Edit(Clients clients) { if (ModelState.IsValid) { db.Entry(clients).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(clients)); }
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,EnrollmentDate,Permission")] User user) { if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Edit([Bind(Include = "ID,name,short_description,description,img_url,repo_url,target_url")] Project project) { if (ModelState.IsValid) { db.Entry(project).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(project)); }
public ActionResult Edit([Bind(Include = "Id,name,begin,end")] Period period) { if (ModelState.IsValid) { db.Entry(period).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(period)); }
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,FathersName,Email")] Student student) { if (ModelState.IsValid) { db.Entry(student).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", (int)Session["GroupId"])); } return(View(student)); }
public ActionResult Edit([Bind(Include = "Email,Role,FirstName,LastName,Password,DateOfBirth,Gender,Interest,Facility,Liking")] User user) { if (ModelState.IsValid) { _db.Entry(user).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }