public void save_update_delete()
{
var playlist = new Playlist {
Name = "New Playlist"
};
_playlistRepo.Save(playlist);
Assert.IsTrue(playlist.PlaylistId > 0);
var playlistId = playlist.PlaylistId;
playlist = _playlistRepo.Get(playlistId);
Assert.IsNotNull(playlist);
Assert.AreEqual(playlistId, playlist.PlaylistId);
playlist.Name = "Updated Playlist";
_playlistRepo.Update(playlist);
playlist = _playlistRepo.Get(playlistId);
Assert.IsNotNull(playlist);
Assert.AreEqual("Updated Playlist", playlist.Name);
_playlistRepo.Delete(playlist);
playlist = _playlistRepo.Get(playlistId);
Assert.IsNull(playlist);
}
public void get()
{
var album = _albumRepo.Get(81);
Assert.IsNotNull(album);
Assert.AreEqual("One By One", album.Title);
}
static void Main(string[] args)
{
var flagRepostory= new NHibernateRepository<Flag>();
var langRepository = new NHibernateRepository<Language>();
var langInfoRepository= new NHibernateRepository<LanguageInfo>();
//var langInfo = langInfoRepository.GetAll();
var flags = flagRepostory.GetAll();
//var lang = langRepository.Get(2);
//LanguageInfo langInfo = new LanguageInfo();
//langInfo.LongPath = "test";
//langInfo.ShortPath = "test1";
//langInfo.AddLanguage(lang);
//lang.AddLanguageIcon(langInfo);
//langRepository.Save(lang);
//langInfoRepository.Save(langInfo);
Flag flag = new Flag();
flag.Name = " F*****g programe";
flag.Description = " Flag Descrption2";
var lang = langRepository.Get(2);
var languageInfo = new LanguageInfoNew { LongPath = "@C:Test1", ShortPath = "@d:tet2" };
languageInfo.AddLanguage(lang);
//lang.AddLanguageIcon(new LanguageInfo { LongPath = "Test1", ShortPath = "test1" });
flag.AddLanguage(languageInfo);
flagRepostory.Save(flag);
}
public void IntegrationTest()
{
IList<Banana> bananas = new List<Banana>();
bananas.Add(new Banana() { Color = "Brown" });
bananas.Add(new Banana() { Color = "Yellow" });
IRepository<Banana> bRepo = new NHibernateRepository<Banana>();
foreach (Banana b in bananas)
bRepo.Save(b);
Assert.IsTrue(bRepo.GetAll().Count == bananas.Count);
IList<Monkey> monkeys = new List<Monkey>();
monkeys.Add(new Monkey() { Name = "George", FlingsPoo = true, Bananas = bananas });
monkeys.Add(new Monkey() { Name = "Magilla", FlingsPoo = false });
IRepository<Monkey> mRepo = new NHibernateRepository<Monkey>();
foreach (Monkey m in monkeys)
mRepo.Save(m);
Assert.IsTrue(mRepo.GetAll().Count == monkeys.Count);
Monkey tempMonkey;
tempMonkey = mRepo.Get(monkeys[0].Id);
Assert.IsNotNull(tempMonkey);
tempMonkey = mRepo.Get(-1);
Assert.IsNull(tempMonkey);
IMonkeyRepository imRepo = new MonkeyRepository();
Assert.IsTrue(imRepo.GetPooFlingingMonkeys().Count == 1);
foreach (Banana b in bananas)
bRepo.Delete(b);
Assert.IsTrue(bRepo.GetAll().Count == 0);
foreach (Monkey m in monkeys)
mRepo.Delete(m);
Assert.IsTrue(mRepo.GetAll().Count == 0);
}
public void CanReturnSingleRecentItem()
{
// save a prod
var ciRep = new NHibernateRepository<CharityInfo>();
var ci = new CharityInfo();
ci.CharityName = "testprod";
ciRep.SaveOrUpdate(ci);
int savedId = ci.Id;
this.FlushSessionAndEvict(ci);
var ciRep2 = new NHibernateRepository<CharityInfo>();
var foundProd = ciRep2.Get(savedId);
Assert.AreEqual("testprod", foundProd.CharityName);
}
public void MappingTest()
{
var testObject = new Artist
{
Id = 123,
Name = "TestBoodschap"
};
var repository = new NHibernateRepository <Artist>();
NHibernateHelper.CreateDatabaseIfNeeded();
repository.Save(testObject);
var result = repository.Get(123);
Assert.IsTrue(testObject == result);
Assert.IsTrue(repository.GetAll().Count > 0);
}
/// <summary>
/// Método para obtener un usuario por su id.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Usuario ObtenerUsuarioPorId(int id)
{
Usuario usuario;
try
{
IRepository <Usuario> uRepo = new NHibernateRepository <Usuario>();
usuario = uRepo.Get(id);
return(usuario);
}
catch (Exception e)
{
log.Error(e.Message, e);
throw new DataAccessException(DataAccessException.EXCEPTION, e);
}
}
/// <summary>
/// Método para obtener un proveedor por su id.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Proveedor ObtenerProveedorPorId(int id)
{
Proveedor proveedor;
try
{
IRepository <Proveedor> pRepo = new NHibernateRepository <Proveedor>();
proveedor = pRepo.Get(id);
return(proveedor);
}
catch (Exception e)
{
log.Error(e.Message, e);
throw new DataAccessException(DataAccessException.EXCEPTION, e);
}
}
/// <summary>
/// Método para eliminar un usuario.
/// </summary>
/// <param name="id"></param>
public void EliminarUsuario(int id)
{
Usuario usuario;
try
{
IRepository <Usuario> uRepo = new NHibernateRepository <Usuario>();
usuario = uRepo.Get(id);
usuario.Estatus = false;
uRepo.Update(usuario);
}
catch (Exception e)
{
log.Error(e.Message, e);
throw new DataAccessException(DataAccessException.EXCEPTION, e);
}
}
/// <summary>
/// Método para eliminar un proveedor.
/// </summary>
/// <param name="id"></param>
public void EliminarProveedor(int id)
{
Proveedor proveedor;
try
{
IRepository <Proveedor> pRepo = new NHibernateRepository <Proveedor>();
proveedor = pRepo.Get(id);
proveedor.Estatus = false;
pRepo.Update(proveedor);
}
catch (Exception e)
{
log.Error(e.Message, e);
throw new DataAccessException(DataAccessException.EXCEPTION, e);
}
}
public void Saving_a_state_machine_should_work()
{
Guid transactionId;
using (var unitOfWork = UnitOfWork.Start())
using (var transaction = unitOfWork.BeginTransaction(IsolationLevel.Serializable))
{
using (var repository = new NHibernateRepository())
{
ExampleStateMachine machine = new ExampleStateMachine();
repository.Save(machine);
transactionId = machine.TransactionId;
}
transaction.Commit();
}
UnitOfWork.Finish();
using (var unitOfWork = UnitOfWork.Start())
using (var transaction = unitOfWork.BeginTransaction(IsolationLevel.Serializable))
{
using (var repository = new NHibernateRepository())
{
ExampleStateMachine machine = repository.Get <ExampleStateMachine>(transactionId);
machine.SubmitOrder();
repository.Update(machine);
}
transaction.Commit();
}
UnitOfWork.Finish();
}
public void Saving_a_state_machine_should_work()
{
Guid transactionId;
using (var unitOfWork = UnitOfWork.Start())
using (var transaction = unitOfWork.BeginTransaction(IsolationLevel.Serializable))
{
using(var repository = new NHibernateRepository() )
{
ExampleStateMachine machine = new ExampleStateMachine();
repository.Save(machine);
transactionId = machine.TransactionId;
}
transaction.Commit();
}
UnitOfWork.Finish();
using (var unitOfWork = UnitOfWork.Start())
using (var transaction = unitOfWork.BeginTransaction(IsolationLevel.Serializable))
{
using (var repository = new NHibernateRepository())
{
ExampleStateMachine machine = repository.Get<ExampleStateMachine>(transactionId);
machine.SubmitOrder();
repository.Update(machine);
}
transaction.Commit();
}
UnitOfWork.Finish();
}
public DeferredMessage Get(Guid id)
{
DeferredMessage msg = _repository.Get <DeferredMessage>(id);
return(msg);
}
