public void DBStoreTest_Update() { DBStore db = new DBStore(); var store = db.Get(2); var addressOld = store.Address; var addressNew = "New Address 1"; var districtIdOld = store.District.Id; var districtIdNew = 3; store.Address = addressNew; store.District.Id = districtIdNew; db.Update(store); store = null; store = db.Get(2); Assert.AreEqual(addressNew, store.Address); Assert.AreEqual(districtIdNew, store.District.Id); //cleanup store.Address = addressOld; store.District.Id = districtIdOld; db.Update(store); }
public void UpdateGetEntityTest() { DBStore dB = new DBStore(this.dBConnect); var sp = dB.Get(1); Assert.IsNotNull(sp, "Store not retrieved"); var oldName = sp.Name; sp.Name = "Testttt"; dB.Update(sp); Assert.IsTrue(dB.Get(sp.ID).Name != oldName, "Name not changed"); sp.Name = oldName; dB.Update(sp); Assert.IsTrue(dB.Get(sp.ID).Name == oldName, "Name not reverted"); }
private void GetStore(int moduleId) { if (moduleId < 0) { return; } using (IDataReader reader = DBStore.Get(moduleId)) { GetStore(reader); } }
private void GetStore(Guid guid) { if (guid == Guid.Empty) { return; } using (IDataReader reader = DBStore.Get(guid)) { GetStore(reader); } }
public IActionResult Get(int id) { try { var storedto = provider.Get(id).toDto(); return(Ok(storedto)); } catch (Exception e) { return(BadRequest($"ERROR: {e.Message}")); } }
public void DBStoreTest_Get() { DBStore db = new DBStore(); var store = db.Get(2); Assert.IsNotNull(store); Assert.IsNotNull(store.District); Assert.IsNotNull(store.District.PrimarySalesperson); Assert.AreEqual("Shop 2", store.Name); Assert.AreEqual(2, store.District.Id); Assert.AreEqual("Jared", store.District.PrimarySalesperson.Name); }
// GET api/<controller>/5 public Store Get(int id) { var faulted = new Store(); faulted.IsFaulted = false; try { return(db.Get(id)); } catch (DatabaseLink.DataLayerArgumentException e) { faulted.IsFaulted = true; faulted.DataLayerArgumentException = e.Message; } catch (DatabaseLink.DataLayerException e) { faulted.IsFaulted = true; faulted.DataLayerException = e.Message; } return(faulted); }
public void DBStoreTest_Get_Fail_ID() { DBStore db = new DBStore(); var store = db.Get(-1); }