//delete one item from database, actually set isDelete = true
private void deleteBtn_Click(object sender, EventArgs e)
{
if (tabControl.SelectedTab == tabControl.TabPages[0])
{
{
DialogResult result = MessageBox.Show(this, "Are you going to delete this item from database?", "Please confirm", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
ICriterion[] expressions = new ICriterion[2];
expressions[0] = Expression.Eq("asset", itemsDataGridView.Rows[rowindex].Cells["Asset"].Value);
expressions[1] = Expression.Eq("isDelete", false);
IList <Item> items = repo.Query <Item>(expressions);
if (items.Count > 1)
{
MessageBox.Show("There exist at least two items with the same asset,please check it");
}
else
{
items[0].isDelete = true;
repo.Update(items[0]);
showAllItems(repo);
}
}
}
}
else
{
MessageBox.Show("You don't have right to delete staff!");
}
}
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 IEnumerable <string> Update <T>(T entity) where T : class
{
using (NHibernateRepository <T> repository = new NHibernateRepository <T>(ConnectionString, DomainAssemblyName))
{
IEnumerable <string> rules;
repository.Update(entity, out rules);
return(rules);
}
}
public void Update()
{
NHibernateRepository repo = new NHibernateRepository();
IList <Staff> st = repo.Query <Staff>();
st[0].groupCode = "1345655";
repo.Update(st[0]);
int id = st[0].staffID;
Assert.AreEqual("13456", repo.Query <Staff>()[0].groupCode);
}
/// <summary>
/// Método para actualizar un usuario.
/// </summary>
/// <param name="usuario"></param>
public void ActualizarUsuario(Usuario usuario)
{
try
{
IRepository <Usuario> uRepo = new NHibernateRepository <Usuario>();
uRepo.Update(usuario);
}
catch (Exception e)
{
log.Error(e.Message, e);
throw new DataAccessException(DataAccessException.EXCEPTION, e);
}
}
/// <summary>
/// Método para actualizar un proveedor.
/// </summary>
/// <param name="proveedor"></param>
public void ActualizarProveedor(Proveedor proveedor)
{
try
{
IRepository <Proveedor> pRepo = new NHibernateRepository <Proveedor>();
pRepo.Update(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 Update(IndividualEntity entity)
{
// Guard against invalid arguments.
if (entity == null)
{
throw new ArgumentNullException("entity");
}
if (entity.Id <= 0)
{
throw new InvalidOperationException("Entity is invalid, the Id must be greater than 0.");
}
try
{
repository.Update(entity);
}
catch (Exception exception)
{
// Throw an exception if the Id was not returned.
throw new InvalidOperationException("Failed to update.", exception);
}
}
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 void UpdatesAnElement()
{
//// SETUP
var testEntity = new TestEntity { Name = "Name" };
const string UpdatedName = "New Name";
using (var session = GetInMemoryDatabaseSession())
{
// Add the test entity.
using (var transaction = session.BeginTransaction())
{
session.Save(testEntity);
transaction.Commit();
}
// Change the entity name.
testEntity.Name = UpdatedName;
// Mock session factory that will provide the in-memory session.
var mockSessionFactory = new Mock<ISessionFactory>();
mockSessionFactory.Setup(mock => mock.OpenSession()).Returns(session);
// Setup target
var target = new NHibernateRepository<TestEntity>(mockSessionFactory.Object);
// EXECUTE
var result = target.Update(testEntity);
// VERIFY
session.Evict(testEntity);
var updatedEntity = session.Get<TestEntity>(testEntity.Id);
Assert.True(result);
Assert.AreEqual(UpdatedName, updatedEntity.Name);
}
}
public void ReturnsFalseOnFailure()
{
//// SETUP
const string OriginalName = "Name";
const string UpdatedName = "New Name";
var testEntity = new TestEntity { Name = OriginalName };
using (var session = GetInMemoryDatabaseSession())
{
// Add the test entity.
using (var transaction = session.BeginTransaction())
{
session.Save(testEntity);
transaction.Commit();
}
// Change the entity name and ID (to an invalid ID).
var validId = testEntity.Id;
testEntity.Id++;
testEntity.Name = UpdatedName;
// Mock session factory that will provide the in-memory session.
var mockSessionFactory = new Mock<ISessionFactory>();
mockSessionFactory.Setup(mock => mock.OpenSession()).Returns(session);
// Setup target
var target = new NHibernateRepository<TestEntity>(mockSessionFactory.Object);
// EXECUTE
var result = target.Update(testEntity);
// VERIFY
session.Evict(testEntity);
var updatedEntity = session.Get<TestEntity>(validId);
Assert.False(result);
Assert.AreEqual(OriginalName, updatedEntity.Name);
}
}