public void DBDistrictTest_Persist_Delete() { DBDistrict db = new DBDistrict(); const string dName = "Norway"; var district = new District() { Name = dName, PrimarySalesperson = new Salesperson() { Id = 2 } }; var countOld = db.GetAll().Count(); db.Persist(district); var countNew = db.GetAll().Count(); Assert.AreNotEqual(countOld, countNew); district = db.GetAll().ToList().SingleOrDefault(x => x.Name.Equals(dName)); db.Delete(district.Id); countNew = db.GetAll().Count(); Assert.AreEqual(countOld, countNew); }
// GET api/<controller> public IEnumerable <District> Get() { var faulted = new List <District>(); try { return(db.GetAll()); } catch (DataLayerArgumentException e) { faulted.Add(new District() { IsFaulted = true, DataLayerArgumentException = e.Message }); } catch (DataLayerException e) { if (faulted.Count == 0) { faulted.Add(new District() { IsFaulted = true }); } faulted[0].DataLayerException = e.Message; } return(faulted.AsEnumerable()); }
public void GetAllTest() { DBDistrict dB = new DBDistrict(this.dBConnect); var ppl = dB.GetAll(); Assert.IsNotNull(ppl, "Null object returned"); Assert.IsTrue(ppl.Count() > 0, "There are no stores"); }
public void DBDistrictTest_GetAll() { DBDistrict db = new DBDistrict(); var d = db.GetAll(); Assert.IsNotNull(d); Assert.AreNotEqual(0, d.Count()); }
public IActionResult Get() { try { return(Ok(provider.GetAll().allToDto())); } catch (Exception e) { return(BadRequest($"ERROR: {e.Message}")); } }
public void AddRemoveEntityTest() { DBDistrict dB = new DBDistrict(this.dBConnect); var sp = new District() { Name = "Netto", PSPID = 1 }; var stores = dB.GetAll(); var oldCount = stores.Count(); dB.Create(sp); Assert.IsTrue(dB.GetAll().Count() > oldCount, "District not created"); stores = dB.GetAll(); sp = stores.Last(); dB.Delete(sp.ID); Assert.IsTrue(dB.GetAll().Count() == oldCount, "District not removed"); }