public void UpdateBehaviorInRepository() { // arrange - Insert a record so that it can be updated. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Behavior obj = new Behavior(); obj.Description = "New Behavior 2"; obj.Points = 0; db.Behaviors.Add(obj); db.SaveChanges(); // act - retrieve the saved record and update it. Behavior savedObj = (from d in db.Behaviors where d.BehaviorID == obj.BehaviorID select d).Single(); savedObj.Description = "An updated Behavior 2"; savedObj.Points = 2; db.SaveChanges(); // Assert -- see if the record retreived from the database matches the one i just updated Behavior updatedObj = (from d in db.Behaviors where d.BehaviorID == obj.BehaviorID select d).Single(); Assert.AreEqual(updatedObj.Description, savedObj.Description); Assert.AreEqual(updatedObj.Points, savedObj.Points); // cleanup db.Behaviors.Remove(updatedObj); db.SaveChanges(); }
public void UpdateFamilyInRepository() { // arrange - Insert a record so that it can be updated. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Family obj = new Family(); obj.Name = "New Family 1"; obj.Children = (from d in db.Children select d).ToList(); obj.Parents = (from d in db.Parents select d).ToList(); db.Familys.Add(obj); db.SaveChanges(); // act - retrieve the saved record and update it. Family savedObj = (from d in db.Familys where d.FamilyID == obj.FamilyID select d).Single(); savedObj.Name = "An updated Family 2"; db.SaveChanges(); // Assert -- see if the record retreived from the database matches the one i just updated Family updatedObj = (from d in db.Familys where d.FamilyID == obj.FamilyID select d).Single(); Assert.AreEqual(updatedObj.Name, savedObj.Name); Assert.AreEqual(savedObj.Children, obj.Children); Assert.AreEqual(savedObj.Parents, obj.Parents); // cleanup db.Familys.Remove(updatedObj); db.SaveChanges(); }
public void SaveNewBehaviorToRepository() { // arrange // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Behavior obj = new Behavior(); obj.Description = "New Behavior 1"; obj.Points = 1; db.Behaviors.Add(obj); // act db.SaveChanges(); // Assert -- see if the record retreived from the database matches the one i just added Behavior savedObj = (from d in db.Behaviors where d.BehaviorID == obj.BehaviorID select d).Single(); Assert.AreEqual(savedObj.Description, obj.Description); Assert.AreEqual(savedObj.Points, obj.Points); // cleanup db.Behaviors.Remove(savedObj); db.SaveChanges(); }
public void SaveNewChildToRepository() { // arrange // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Child obj = new Child(); obj.Name = "New Child 1"; obj.Password = "******"; db.Children.Add(obj); // act db.SaveChanges(); // Assert -- see if the record retreived from the database matches the one i just added Child savedObj = (from d in db.Children where d.ChildID == obj.ChildID select d).Single(); Assert.AreEqual(savedObj.Name, obj.Name); Assert.AreEqual(savedObj.Password, obj.Password); // cleanup db.Children.Remove(savedObj); db.SaveChanges(); }
public void SaveNewFamilyToRepository() { // arrange // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Family obj = new Family(); obj.Name = "New Family 1"; obj.Children = (from d in db.Children select d).ToList(); obj.Parents = (from d in db.Parents select d).ToList(); db.Familys.Add(obj); // act db.SaveChanges(); // Assert -- see if the record retreived from the database matches the one i just added Family savedObj = (from d in db.Familys where d.FamilyID == obj.FamilyID select d).Single(); Assert.AreEqual(savedObj.Name, obj.Name); Assert.AreEqual(savedObj.Children, obj.Children); Assert.AreEqual(savedObj.Parents, obj.Parents); // cleanup db.Familys.Remove(savedObj); db.SaveChanges(); }
public void UpdateChildInRepository() { // arrange - Insert a record so that it can be updated. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Child obj = new Child(); obj.Name = "New Child 2"; obj.Password = "******"; db.Children.Add(obj); db.SaveChanges(); // act - retrieve the saved record and update it. Child savedObj = (from d in db.Children where d.ChildID == obj.ChildID select d).Single(); savedObj.Name = "An updated Child 2"; savedObj.Password = "******"; db.SaveChanges(); // Assert -- see if the record retreived from the database matches the one i just updated Child updatedObj = (from d in db.Children where d.ChildID == obj.ChildID select d).Single(); Assert.AreEqual(updatedObj.Name, savedObj.Name); Assert.AreEqual(updatedObj.Password, savedObj.Password); // cleanup db.Children.Remove(updatedObj); db.SaveChanges(); }
public void DeleteTransactionFromRepository() { // arrange - Insert a record so that it can be updated. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Behavior be = (from d in db.Behaviors select d).First(); Parent pa = (from d in db.Parents select d).First(); Child ch = (from d in db.Children select d).First(); Transaction obj = new Transaction(); obj.Date = DateTime.Now; obj.ParentID = pa.ParentID; obj.ChildID = ch.ChildID; obj.PointType = "Behavior"; obj.Description = be.Description; obj.Points = be.Points; db.Transactions.Add(obj); db.SaveChanges(); // act - retrieve the saved record and then remove it. Transaction savedObj = (from d in db.Transactions where d.TransactionID == obj.TransactionID select d).Single(); db.Transactions.Remove(savedObj); db.SaveChanges(); // Assert -- see if the record deleted from the database exists Transaction removedObj = (from d in db.Transactions where d.TransactionID == savedObj.TransactionID select d).FirstOrDefault(); Assert.IsNull(removedObj); }
public ActionResult Create(Reward reward) { if (ModelState.IsValid) { db.Rewards.Add(reward); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(reward)); }
public void ListofTransactionsInRepository() { // arrange - Add a record to be listed. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Behavior be = (from d in db.Behaviors select d).First(); Parent pa = (from d in db.Parents select d).First(); Child ch = (from d in db.Children select d).First(); Transaction obj = new Transaction(); obj.Date = DateTime.Now; obj.ParentID = pa.ParentID; obj.ChildID = ch.ChildID; obj.PointType = "Behavior"; obj.Description = be.Description; obj.Points = be.Points; db.Transactions.Add(obj); db.SaveChanges(); // act - retrieve the saved records and put them in a list. List <Transaction> savedObjs = (from d in db.Transactions select d).ToList(); // Assert -- The list of saved objects should have a count greater than 0 Assert.IsTrue(savedObjs.Count > 0); }
public void UpdateTransactionInRepository() { // arrange - Insert a record so that it can be updated. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Behavior be = (from d in db.Behaviors select d).First(); Parent pa = (from d in db.Parents select d).First(); Child ch = (from d in db.Children select d).First(); Transaction obj = new Transaction(); obj.Date = DateTime.Now; obj.ParentID = pa.ParentID; obj.ChildID = ch.ChildID; obj.PointType = "Behavior"; obj.Description = be.Description; obj.Points = be.Points; db.Transactions.Add(obj); db.SaveChanges(); // act - retrieve the saved record and update it. Transaction savedObj = (from d in db.Transactions where d.TransactionID == obj.TransactionID select d).Single(); savedObj.Description = "Behvior Updated"; savedObj.Points = 2; db.SaveChanges(); // Assert -- see if the record retreived from the database matches the one i just updated Transaction updatedObj = (from d in db.Transactions where d.TransactionID == obj.TransactionID select d).Single(); Assert.AreEqual(updatedObj.Description, savedObj.Description); Assert.AreEqual(updatedObj.Points, savedObj.Points); Assert.AreEqual(updatedObj.ParentID, savedObj.ParentID); Assert.AreEqual(updatedObj.ChildID, savedObj.ChildID); Assert.AreEqual(updatedObj.PointType, savedObj.PointType); Assert.AreEqual(updatedObj.Date, savedObj.Date); // cleanup db.Transactions.Remove(updatedObj); db.SaveChanges(); }
public void DeleteBehaviorFromRepository() { // arrange - Insert a record so that it can be updated. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Behavior obj = new Behavior(); obj.Description = "Delete this Behavior"; obj.Points = 3; db.Behaviors.Add(obj); db.SaveChanges(); // act - retrieve the saved record and then remove it. Behavior savedObj = (from d in db.Behaviors where d.BehaviorID == obj.BehaviorID select d).Single(); db.Behaviors.Remove(savedObj); db.SaveChanges(); // Assert -- see if the record deleted from the database exists Behavior removedObj = (from d in db.Behaviors where d.BehaviorID == savedObj.BehaviorID select d).FirstOrDefault(); Assert.IsNull(removedObj); }
public void DeleteChildFromRepository() { // arrange - Insert a record so that it can be updated. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Child obj = new Child(); obj.Name = "Delete this Child"; obj.Password = "******"; db.Children.Add(obj); db.SaveChanges(); // act - retrieve the saved record and then remove it. Child savedObj = (from d in db.Children where d.ChildID == obj.ChildID select d).Single(); db.Children.Remove(savedObj); db.SaveChanges(); // Assert -- see if the record deleted from the database exists Child removedObj = (from d in db.Children where d.ChildID == savedObj.ChildID select d).FirstOrDefault(); Assert.IsNull(removedObj); }
public void DeleteFamilyFromRepository() { // arrange - Insert a record so that it can be updated. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Family obj = new Family(); obj.Name = "Delete this Family"; obj.Children = (from d in db.Children select d).ToList(); obj.Parents = (from d in db.Parents select d).ToList(); db.Familys.Add(obj); db.SaveChanges(); // act - retrieve the saved record and then remove it. Family savedObj = (from d in db.Familys where d.FamilyID == obj.FamilyID select d).Single(); db.Familys.Remove(savedObj); db.SaveChanges(); // Assert -- see if the record deleted from the database exists Family removedObj = (from d in db.Familys where d.FamilyID == savedObj.FamilyID select d).FirstOrDefault(); Assert.IsNull(removedObj); }
public void ListofBehaviorsInRepository() { // arrange - Add a record to be listed. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Behavior obj = new Behavior(); obj.Description = "Behavior 1"; obj.Points = 1; db.Behaviors.Add(obj); db.SaveChanges(); // act - retrieve the saved records and put them in a list. List <Behavior> savedObjs = (from d in db.Behaviors select d).ToList(); // Assert -- The list of saved objects should have a count greater than 0 Assert.IsTrue(savedObjs.Count > 0); }
public void ListofChildrenInRepository() { // arrange - Add a record to be listed. // note connection string is in app.config FamilyPointsContext db = new FamilyPointsContext(); Child obj = new Child(); obj.Name = "Child 1"; obj.Password = "******"; db.Children.Add(obj); db.SaveChanges(); // act - retrieve the saved records and put them in a list. List <Child> savedObjs = (from d in db.Children select d).ToList(); // Assert -- The list of saved objects should have a count greater than 0 Assert.IsTrue(savedObjs.Count > 0); }