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);
}
