public IActionResult UpdateEntry([FromBody] Feeder_watches objupd) { if (ModelState.IsValid) { var targetObject = _NewsDBcontext.Feeder_Watches.FirstOrDefault(t => t.pkWatchID == objupd.pkWatchID); if (targetObject == null) { return(NotFound()); } try { _NewsDBcontext.Entry(targetObject).CurrentValues.SetValues(objupd); _NewsDBcontext.SaveChanges(); } catch (Exception e) { var Message = ""; Message = e.Message + " - " + e.InnerException.Message; return(BadRequest(Message)); } return(Ok()); } return(NotFound()); }
public IActionResult Create([FromBody] Feeder_watches newmodel) { if (ModelState.IsValid) { var Message = ""; var RecordID = 0; try { RecordID = _NewsDBcontext.Feeder_Watches.Max(id => id.pkWatchID); newmodel.pkWatchID = RecordID + 1; _NewsDBcontext.Feeder_Watches.Add(newmodel); _NewsDBcontext.SaveChanges(); } catch (Exception e) { Message = e.Message + " - " + e.InnerException.Message; return(BadRequest(Message)); } return(CreatedAtRoute("GetFeeder_watches", new { id = newmodel.pkWatchID }, newmodel)); } else { return(BadRequest()); } }
internal void PopulateData() { using (var context = new AppDbContext(options, null)) { if (context.NewsStatus.Count() < 1) { var p1 = new NewsStatus { NewsStatusID = 1, NewsStatusValue = 1, NewsStatusDescription = "NewsStatus 1", }; var p2 = new NewsStatus { NewsStatusID = 2, NewsStatusValue = 2, NewsStatusDescription = "NewsStatus 2", }; context.NewsStatus.Add(p1); context.NewsStatus.Add(p2); } if (context.LanguageType.Count() < 1) { var p1 = new LanguageType { LanguageTypeID = 1, LanguageTypeName = "LanguageType 1" }; var p2 = new LanguageType { LanguageTypeID = 2, LanguageTypeName = "LanguageType 2" }; context.LanguageType.Add(p1); context.LanguageType.Add(p2); } context.SaveChanges(); } using (var newscontext = new NEWSDBContext(newsoptions, null)) using (var context = new AppDbContext(options, null)) { if (newscontext.Feeder_Watches.Count() < 1) { var p1 = new Feeder_watches { pkWatchID = 1, Caption = "Feeder_watches 1", fkLanguageID = 1 }; var p2 = new Feeder_watches { pkWatchID = 2, Caption = "Feeder_watches 2", fkLanguageID = 2 }; newscontext.Feeder_Watches.Add(p1); newscontext.Feeder_Watches.Add(p2); } newscontext.SaveChanges(); } }
public void Feeder_watches() { IQueryable <Feeder_watches> Feeder_watchesFeeder_watches = Enumerable.Empty <Feeder_watches>().AsQueryable(); Feeder_watches ct = new Feeder_watches { PkWatchID = 1, Description = "Test Feeder_watches" }; Mock <IFeeder_watchesRepository> Feeder_watchesService = new Mock <IFeeder_watchesRepository>(); object obj = new object(); try { Feeder_watchesService.Setup(x => x.GetAll()).Returns(Feeder_watchesFeeder_watches); Feeder_watchesService.Setup(x => x.Get(It.IsAny <int>())).Returns(ct); Feeder_watchesService.Setup(x => x.Add(It.IsAny <Feeder_watches>())).Returns(ct); Feeder_watchesService.Setup(x => x.Delete(It.IsAny <Feeder_watches>())).Verifiable(); Feeder_watchesService.Setup(x => x.Update(It.IsAny <Feeder_watches>(), It.IsAny <object>())).Returns(ct); var Feeder_watchesObject = Feeder_watchesService.Object; var p1 = Feeder_watchesObject.GetAll(); var p2 = Feeder_watchesObject.Get(1); var p3 = Feeder_watchesObject.Update(ct, obj); var p4 = Feeder_watchesObject.Add(ct); Feeder_watchesObject.Delete(ct); Assert.IsAssignableFrom <IQueryable <Feeder_watches> >(p1); Assert.IsAssignableFrom <Feeder_watches>(p2); Assert.Equal("Test Feeder_watches", p2.Description); Assert.Equal("Test Feeder_watches", p3.Description); Feeder_watchesService.VerifyAll(); Feeder_watchesObject.Dispose(); } finally { Feeder_watchesService = null; } }
public IActionResult Update([FromBody] Feeder_watches watch) { var result = _repository.UpdateWatch(watch); return(Helper.CheckResult(result)); }