public void editTravel(Reise reise, string country, DateTime start, DateTime end, decimal price, bool staffed, string nameofstaff = "") { Reise = M120Entities.Reises.Find(reise); SetAttributes(country, start, end, price, staffed, nameofstaff); M120Entities.SaveChanges(); }
public void addTravel(string country, DateTime start, DateTime end, decimal price, bool staffed, string nameofstaff = "") { Reise = new Reise(); SetAttributes(country, start, end, price, staffed, nameofstaff); M120Entities.SaveChanges(); }
public void TestRefresh() { m.Hinzufuegen(r); pm.MakePersistent(m); pm.Save(); pm.MakeHollow(r); pm.Refresh(r); Assert.AreEqual(NDOObjectState.Persistent, r.NDOObjectState, "Wrong state #1"); pm.Refresh(r); Assert.AreEqual(NDOObjectState.Persistent, r.NDOObjectState, "Wrong state #2"); ObjectId id = r.NDOObjectId; PersistenceManager pm2 = PmFactory.NewPersistenceManager(); Reise m2 = (Reise)pm2.FindObject(id); Assert.NotNull(m2, "Cannot load object"); m2.Zweck = "Test"; pm2.Save(); pm2.Close(); Assert.AreEqual("ADC", r.Zweck, "Wrong name #1"); Assert.AreEqual("Test", m2.Zweck, "Wrong name #2"); pm.Refresh(r); Assert.AreEqual("Test", r.Zweck, "Wrong name #3"); }
public void TestIList() { int i = 0; // Leseoperationen Reise r = (Reise)dieReisen[i]; foreach (Reise r2 in dieReisen) { Console.WriteLine(r2.Zweck); } Reise[] arr = new Reise[] {}; dieReisen.CopyTo(arr, 0); IEnumerator ie = dieReisen.GetEnumerator(); // Schreiboperationen dieReisen.Add(r); dieReisen.Clear(); dieReisen.Insert(0, r); dieReisen.Remove(r); dieReisen.RemoveAt(0); // Kann mit der bloöen Oid implementiert werden. bool b = dieReisen.Contains(r); dieReisen.IndexOf(r); }
public async Task EndreLoggetInnFeilModel() { // Arrange var reise1 = new Reise { Rid = 1, reiserFra = "Oslo", reiserTil = "Bergen", pris = 299, dag = "Mandag", tidspunkt = "13:00" }; mockRep.Setup(k => k.Endre(reise1)).ReturnsAsync(true); var bussController = new BussController(mockRep.Object, mockLog.Object); bussController.ModelState.AddModelError("Fornavn", "Feil i inputvalidering på server"); mockSession[_loggetInn] = _loggetInn; mockHttpContext.Setup(s => s.Session).Returns(mockSession); bussController.ControllerContext.HttpContext = mockHttpContext.Object; // Act var resultat = await bussController.Endre(reise1) as BadRequestObjectResult; // Assert Assert.Equal((int)HttpStatusCode.BadRequest, resultat.StatusCode); Assert.Equal("Feil i inputvalidering på server", resultat.Value); }
public ActionResult KjopBillett(FormCollection innListe) { DB db = new DB(); if (innListe["fra"] == "fra")//møl { System.Diagnostics.Debug.WriteLine("Inn i første If " + innListe["Dato"]); if (innListe["Dato"] == "2019-10-15") { System.Diagnostics.Debug.WriteLine("Inn i andre If " + innListe["Tid"]); if (innListe["Tid"] == "08:00") { System.Diagnostics.Debug.WriteLine("Inn i tredje If"); Reise enreise = db.Reise.FirstOrDefault(p => p.Avgang == "Oslo"); Billett nyBillett = new Billett { ReiseId = enreise.Id }; db.Billetter.Add(nyBillett); db.SaveChanges(); } } } var alleBilletter = db.Billetter.ToList(); return(View(alleBilletter)); }
public void PrefetchOccurs() { Reise r = new Reise() { Zweck = "NDO" }; Mitarbeiter m = new Mitarbeiter() { Vorname = "Mirko", Nachname = "Matytschak" }; pm.MakePersistent(m); m.Hinzufuegen(r); pm.Save(); NDOQuery <Mitarbeiter> q = new NDOQuery <Mitarbeiter>(pm); q.AddPrefetch(nameof(Mitarbeiter.Reisen)); var m2 = q.ExecuteSingle(); var oc = pm.GetObjectContainer(); Assert.AreEqual(2, oc.RootObjects.Count); }
public void TestAssignRelatedObjectsAbort() { for (int i = 0; i < 3; i++) { m.Hinzufuegen(CreateReise(i.ToString())); } pm.MakePersistent(m); pm.Save(); IList neueReisen = new ArrayList(); Reise nr = CreateReise("Test"); neueReisen.Add(nr); IList rr = new ArrayList(m.Reisen); m.ErsetzeReisen(neueReisen); Assert.AreEqual(1, m.Reisen.Count, "1. Wrong number of objects"); for (int i = 0; i < 3; i++) { Assert.AreEqual(NDOObjectState.Deleted, ((Reise)rr[i]).NDOObjectState, "2. Wrong state"); } Assert.AreEqual(NDOObjectState.Created, nr.NDOObjectState, "3. Wrong state"); pm.Abort(); Assert.AreEqual(3, m.Reisen.Count, "4. Wrong number of objects"); for (int i = 0; i < 3; i++) { Assert.AreEqual(NDOObjectState.Persistent, ((Reise)rr[i]).NDOObjectState, "5. Wrong state"); } Assert.AreEqual(NDOObjectState.Transient, nr.NDOObjectState, "6. Wrong state"); }
public void TestExtentRelatedObjects() { r.AddKostenpunkt(kp); pm.MakePersistent(r); pm.Save(); Assert.AreEqual(NDOObjectState.Persistent, r.NDOObjectState, "0: Reise should be persistent"); IList liste = pm.GetClassExtent(typeof(Reise)); r = (Reise)liste[0]; Assert.AreEqual(1, liste.Count, "1: Number of Reise objects is wrong"); Assert.AreEqual(NDOObjectState.Persistent, r.NDOObjectState, "1: Reise should be persistent"); Assert.NotNull(r.Kostenpunkte, "2. Relation is missing"); Assert.AreEqual(1, r.Kostenpunkte.Count, "3. Wrong number of objects"); Assert.AreEqual(NDOObjectState.Persistent, ((Kostenpunkt)r.Kostenpunkte[0]).NDOObjectState, "4.: Kostenpunkt should be hollow"); pm.UnloadCache(); liste = pm.GetClassExtent(typeof(Reise)); r = (Reise)liste[0]; Assert.AreEqual(NDOObjectState.Hollow, r.NDOObjectState, "5: Reise should be hollow"); Assert.NotNull(r.Kostenpunkte, "6. Relation is missing"); Assert.AreEqual(1, r.Kostenpunkte.Count, "7. Wrong number of objects"); Assert.AreEqual(NDOObjectState.Hollow, ((Kostenpunkt)r.Kostenpunkte[0]).NDOObjectState, "8.: Kostenpunkt should be hollow"); pm.UnloadCache(); liste = pm.GetClassExtent(typeof(Reise), false); r = (Reise)liste[0]; Assert.AreEqual(NDOObjectState.Persistent, r.NDOObjectState, "9: Reise should be persistent"); Assert.NotNull(r.Kostenpunkte, "10. Relation is missing"); Assert.AreEqual(1, r.Kostenpunkte.Count, "11. Wrong number of objects"); Assert.AreEqual(NDOObjectState.Hollow, ((Kostenpunkt)r.Kostenpunkte[0]).NDOObjectState, "12.: Kostenpunkt should be hollow"); }
public Reise ErzeugeReise() { Reise r = new Reise(); dieReisen.Add(r); return(r); }
private Reise CreateReise(string zweck) { Reise r = new Reise(); r.Zweck = zweck; return(r); }
public IHttpActionResult PutReise(int id, Reise reise) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != reise.Id) { return(BadRequest()); } db.Entry(reise).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ReiseExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public void TestLockingPolyBi() { if (t != null) { Reise reise = new Reise(); reise.Zweck = "ADC"; Kostenpunkt kp = new PKWFahrt(100); reise.AddKostenpunkt(kp); pm.MakePersistent(reise); Relation rel = pm.NDOMapping.FindClass(typeof(Reise)).FindRelation("belege"); Relation rel2 = pm.NDOMapping.FindClass(typeof(Beleg)).FindRelation("reise"); Assert.AreEqual(rel, rel2, "Relation should be considered the same"); bool b = GetLock(reise, rel, kp); Assert.AreEqual(true, b, "There shouldn't be a lock"); Assert.AreEqual(true, IsLocked(reise, rel, kp), "Objects should be locked #1"); Assert.AreEqual(true, IsLocked(kp, rel, reise), "Objects should be locked #2"); Assert.AreEqual(false, GetLock(kp, rel.ForeignRelation, reise), "Objects should be locked #3"); Assert.AreEqual(false, GetLock(reise, rel.ForeignRelation, kp), "Objects should be locked #4"); Assert.AreEqual(false, GetLock(kp, rel2, reise), "Objects should be locked #5"); Assert.AreEqual(false, GetLock(reise, rel2, kp), "Objects should be locked #6"); Assert.AreEqual(false, GetLock(kp, rel2.ForeignRelation, reise), "Objects should be locked #7"); Assert.AreEqual(false, GetLock(reise, rel2.ForeignRelation, kp), "Objects should be locked #8"); Unlock(reise, rel, kp); Assert.AreEqual(false, IsLocked(reise, rel, kp), "Objects should be locked #1"); Assert.AreEqual(false, IsLocked(kp, rel, reise), "Objects should be locked #2"); Assert.AreEqual(false, IsLocked(kp, rel.ForeignRelation, reise), "Objects should be locked #3"); Assert.AreEqual(false, IsLocked(reise, rel.ForeignRelation, kp), "Objects should be locked #4"); Assert.AreEqual(false, IsLocked(kp, rel2, reise), "Objects should be locked #5"); Assert.AreEqual(false, IsLocked(reise, rel2, kp), "Objects should be locked #6"); Assert.AreEqual(false, IsLocked(kp, rel2.ForeignRelation, reise), "Objects should be locked #7"); Assert.AreEqual(false, IsLocked(reise, rel2.ForeignRelation, kp), "Objects should be locked #8"); } }
public async Task HentEnReiseLoggetInnOK() { // Arrange var reise1 = new Reise { Rid = 3, reiserFra = "Trondheim", reiserTil = "Oslo", pris = 599, dag = "Onsdag", tidspunkt = "14:00" }; mockRep.Setup(k => k.HentEnReise(It.IsAny <int>())).ReturnsAsync(reise1); var bussController = new BussController(mockRep.Object, mockLog.Object); mockSession[_loggetInn] = _loggetInn; mockHttpContext.Setup(s => s.Session).Returns(mockSession); bussController.ControllerContext.HttpContext = mockHttpContext.Object; // Act var resultat = await bussController.HentEnReise(It.IsAny <int>()) as OkObjectResult; // Assert Assert.Equal((int)HttpStatusCode.OK, resultat.StatusCode); Assert.Equal <Reise>(reise1, (Reise)resultat.Value); }
public void ChangeRelationWithExistingObject(Type formatterType) { // Create object and serialize it IFormatter formatter = (IFormatter)Activator.CreateInstance(formatterType); var r = new Reise { Zweck = "NDO" }; pm.MakePersistent(r); var l = new Land("Germany"); pm.MakePersistent(l); pm.Save(); var oc = pm.GetObjectContainer(); oc.Formatter = formatter; string serialized = oc.MarshalingString; pm.UnloadCache(); // Merge object in to an OfflinePersistenceManager and change it OfflinePersistenceManager opm = new OfflinePersistenceManager(pm.NDOMapping.FileName); oc = new ObjectContainer(); oc.Deserialize(serialized, formatter); opm.MergeObjectContainer(oc); var newOc = oc.RootObjects.Cast <IPersistenceCapable>(); var r2 = (Reise)newOc.FirstOrDefault(pc => pc is Reise); var l2 = (Land)newOc.FirstOrDefault(pc => pc is Land);; Assert.AreEqual(NDOObjectState.Persistent, r2.NDOObjectState); Assert.AreEqual(NDOObjectState.Persistent, l2.NDOObjectState); r2.LandHinzufügen(l2); Assert.AreEqual(NDOObjectState.PersistentDirty, r2.NDOObjectState); // Create a ChangeSetContainer and serialize it var csc = opm.GetChangeSet(); csc.Formatter = formatter; string serializedChanges = csc.MarshalingString; // Merge the changes back to pm csc = new ChangeSetContainer(); csc.Deserialize(serializedChanges, formatter); r = (Reise)csc.ChangedObjects.Cast <IPersistenceCapable>().FirstOrDefault(pc => pc is Reise); pm.MergeObjectContainer(csc); r2 = (Reise)pm.FindObject(r.NDOObjectId); Assert.AreEqual(NDOObjectState.PersistentDirty, r2.NDOObjectState); Assert.AreEqual(1, r2.Länder.Count); // Save and Reload pm.Save(); pm.UnloadCache(); r = pm.Objects <Reise>().Single(); Assert.AreEqual(1, r2.Länder.Count); }
public void Setup() { pm = PmFactory.NewPersistenceManager(); m = CreateMitarbeiter("Hartmut", "Kocher"); pm.MakePersistent(m); r = CreateReise("ADC"); r2 = CreateReise("ADW"); }
public void Setup() { pm = PmFactory.NewPersistenceManager(); r = CreateReise("ADC"); m = CreateMitarbeiter(); m.Hinzufuegen(r); pm.MakePersistent(m); }
public void TestCreateObjects() { pm.MakePersistent(m); pm.MakePersistent(r); Assert.That(!m.NDOObjectId.Equals(r.NDOObjectId), "Ids should be different"); m = (Mitarbeiter)pm.FindObject(m.NDOObjectId); r = (Reise)pm.FindObject(r.NDOObjectId); }
public async Task HentReiserLoggetInnOK() { // Arrange var reise1 = new Reise { Rid = 1, reiserFra = "Oslo", reiserTil = "Bergen", pris = 299, dag = "Mandag", tidspunkt = "13:00" }; var reise2 = new Reise { Rid = 2, reiserFra = "Bergen", reiserTil = "Oslo", pris = 399, dag = "Tirsdag", tidspunkt = "12:00" }; var reise3 = new Reise { Rid = 3, reiserFra = "Trondheim", reiserTil = "Oslo", pris = 599, dag = "Onsdag", tidspunkt = "14:00" }; var reiseListe = new List <Reise>(); reiseListe.Add(reise1); reiseListe.Add(reise2); reiseListe.Add(reise3); mockRep.Setup(k => k.HentReiser()).ReturnsAsync(reiseListe); var bussController = new BussController(mockRep.Object, mockLog.Object); mockSession[_loggetInn] = _loggetInn; mockHttpContext.Setup(s => s.Session).Returns(mockSession); bussController.ControllerContext.HttpContext = mockHttpContext.Object; // Act var resultat = await bussController.HentReiser() as OkObjectResult; // Assert Assert.Equal((int)HttpStatusCode.OK, resultat.StatusCode); Assert.Equal <List <Reise> >((List <Reise>)resultat.Value, reiseListe); }
public void TestLoadRelatedObjects() { NDOQuery <Mitarbeiter> q = new NDOQuery <Mitarbeiter>(pm, null); IList dellist = q.Execute(); pm.Delete(dellist); pm.Save(); pm.UnloadCache(); for (int i = 0; i < 10; i++) { m.Hinzufuegen(CreateReise(i.ToString())); } pm.MakePersistent(m); pm.Save(); pm.MakeHollow(m, true); IList reisen = new ArrayList(m.Reisen); Assert.AreEqual(10, reisen.Count, "Array size should be 10"); for (int i = 0; i < 10; i++) { Reise rr = (Reise)reisen[i]; Assert.AreEqual(NDOObjectState.Hollow, rr.NDOObjectState, "1: Reise should be hollow"); // if (i.ToString()!= rr.Zweck) // { // for (int j = 0; j < 10; j++) // System.Diagnostics.Debug.WriteLine("Reise: " + ((Reise)reisen[j]).Zweck); // } #if !ORACLE && !MYSQL && !FIREBIRD if (rr.NDOObjectId.Id[0] is Int32) { Assert.AreEqual(i.ToString(), rr.Zweck, "2: Reise should be in right order"); } #endif } pm.MakeAllHollow(); pm.UnloadCache(); IList reisen2 = m.Reisen; for (int i = 0; i < 10; i++) { Reise r1 = (Reise)reisen[i]; Reise r2 = (Reise)reisen2[i]; #if !ORACLE && !MYSQL && !FIREBIRD if (r1.NDOObjectId.Id[0] is Int32) { Assert.AreEqual(i.ToString(), r1.Zweck, "3: Reise should be in right order"); } #endif Assert.That(r1 != r2, "Objects should be different"); } }
public IHttpActionResult GetReise(int id) { Reise reise = db.Reiser.Find(id); if (reise == null) { return(NotFound()); } return(Ok(reise)); }
public IHttpActionResult PostReise(Reise reise) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Reiser.Add(reise); db.SaveChanges(); db.Entry(reise).GetDatabaseValues(); return(CreatedAtRoute("DefaultApi", new { id = reise.Id }, reise)); }
public void TestCreateObjectsSave() { r.AddKostenpunkt(kp); pm.MakePersistent(r); pm.Save(); pm.UnloadCache(); r = (Reise)pm.FindObject(r.NDOObjectId); Assert.NotNull(r, "Reise not found"); Assert.AreEqual(1, r.Kostenpunkte.Count); Assert.NotNull(r.Kostenpunkte[0], "Beleg not found"); }
public ActionResult ReiseInfo(KundeReise info) { if (info.kunde == null) { var fra = Session["Fra"].ToString(); var til = Session["Til"].ToString(); var dato = Session["Dato"].ToString(); var tid = Request["Tid"]; double pris = Double.Parse(Request["Pris"]); var spor = Request["Spor"]; var tog = Request["Tog"]; int bytter = int.Parse(Request["Bytter"]); var avgang = Request["Avgang"]; var ankomst = Request["Ankomst"]; reise = new Reise { Fra = fra, Til = til, Dato = dato, Tid = tid, Pris = pris, Spor = spor, Tog = tog, Bytter = bytter, Avgang = avgang, Ankomst = ankomst }; KundeReise reisen = new KundeReise { kunde = null, reise = reise }; Session["Reisen"] = reisen; return(View(Session["Reisen"])); } Billett billet = new Billett(); info.reise = ((KundeReise)Session["Reisen"]).reise; billet.Reise = info.reise; billet.Kunde = info.kunde; db.Billett.Add(billet); db.Reise.Add(info.reise); db.Kunde.Add(info.kunde); db.SaveChanges(); Session["ID"] = billet.ID; return(RedirectToAction("Billett", Session["ID"])); }
//Henter ut kun en reise public async Task <Reise> HentEnReise(int id) { try { Reise hentetReise = await _db.Reiser.FindAsync(id); return(hentetReise); } catch { return(null); } }
public void TestAddObjectSave() { pm.MakePersistent(m); pm.Save(); m.Hinzufuegen(r); Assert.AreEqual(NDOObjectState.Created, r.NDOObjectState, "1. Wrong state"); pm.Save(); m = (Mitarbeiter)pm.FindObject(m.NDOObjectId); r = (Reise)pm.FindObject(r.NDOObjectId); Assert.NotNull(m, "1. Mitarbeiter not found"); Assert.NotNull(r, "1. Reise not found"); Assert.AreEqual(NDOObjectState.Persistent, r.NDOObjectState, "2. Wrong state"); }
public async Task <Avgang> HentReise(Reise reise) { try { List <Avgang> avgangList = await HentAlleAvganger(); return(reise.besteAvgang(avgangList)); } catch (Exception e) { _log.LogInformation(e.Message); return(null); } }
public void TestUnloadCache() { m.Hinzufuegen(r); pm.MakePersistent(m); Assert.AreSame(r, pm.FindObject(r.NDOObjectId), "Getting same object twice should return same object"); pm.Save(); pm.UnloadCache(); Assert.That(r != pm.FindObject(r.NDOObjectId), "Getting same object twice should return different objects"); ObjectId id = r.NDOObjectId; r = null; pm.UnloadCache(); Assert.NotNull(pm.FindObject(id), "Should find object"); }
public IHttpActionResult DeleteReise(int id) { Reise reise = db.Reiser.Find(id); if (reise == null) { return(NotFound()); } db.Reiser.Remove(reise); db.SaveChanges(); return(Ok(reise)); }
public void TestAddObjectSave() { pm.MakePersistent(r); pm.Save(); r.AddKostenpunkt(kp); Assert.AreEqual(NDOObjectState.Created, kp.NDOObjectState, "1. Wrong state"); pm.Save(); r = (Reise)pm.FindObject(r.NDOObjectId); kp = (Kostenpunkt)pm.FindObject(kp.NDOObjectId); Assert.NotNull(r, "1. Reise not found"); Assert.NotNull(kp, "2. Beleg not found"); Assert.AreEqual(NDOObjectState.Persistent, kp.NDOObjectState, "3. Wrong state"); Assert.AreEqual(DateTime.Now.Date, kp.Datum, "Wrong data"); }