private void Login(object obj) { var manager = new AlertsManager(); try { Database.Instance.Connect(); var gateway = new UsersGateway(); if (gateway.IsValid(_nick, _password, Database.Instance)) { var user = new User(_nick); OnUserLogged(user); Visible = false; } else { manager.Show("Niepoprawna nazwa użytkownika lub hasło.", Alerts.Warning); } } catch (Exception) { manager.Show("Problem z połączeniem z internetem.", Alerts.Warning); } }
public DataTable InsertUserInformation(Users user) { DataTable dt = null; try { UsersGateway usersGateway = new UsersGateway(); dt = usersGateway.InsertUserInformation(user); return(dt); } catch (Exception ex) { throw ex; } }
public void IsInDBTest() { _connection.Open(); // Arrange: var mock = new Mock <IDatabase>(); mock.SetupGet(x => x.Connection).Returns(_connection); var gateway = new UsersGateway(); // Act: bool result = gateway.IsInDB("TestUser", mock.Object); // Assert: Assert.AreEqual(true, result); _connection.Close(); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> public UserEntity Find(long id, DbConnection connection, DbTransaction transaction) { var reader = default(DbDataReader); try { reader = UsersGateway.Select(new UsersCriteria() { ID = id, Enabled = true, }, connection, transaction); var found = (reader.Read() ? KandaDbDataMapper.MapToObject <UserEntity>(reader) : new UserEntity()); return(found); } finally { if (reader != null) { reader.Close(); } } }
public void Setup() { _classUnderTest = new UsersGateway(DatabaseContext); }
/// <summary> /// /// </summary> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> internal long IdentCurrent(DbConnection connection, DbTransaction transaction) { var current = UsersGateway.IdentCurrent(connection, transaction); return(decimal.ToInt64(current)); }
/// <summary> /// /// </summary> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> public bool Truncate(DbConnection connection, DbTransaction transaction) { var error = UsersGateway.Truncate(connection, transaction); return(error == 0); }
/// <summary> /// /// </summary> /// <param name="entity"></param> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> public bool Update(UserEntity entity, DbConnection connection, DbTransaction transaction) { var affected = UsersGateway.Update(entity, connection, transaction); return(affected == 1); }
/// <summary> /// /// </summary> /// <param name="entity"></param> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> public bool Create(UserEntity entity, DbConnection connection, DbTransaction transaction) { var error = UsersGateway.Insert(entity, connection, transaction); return(error == KandaTableDataGateway.NO_ERRORS); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> internal bool Delete(long id, DbConnection connection, DbTransaction transaction) { var deleted = UsersGateway.Delete(id, connection, transaction); return(deleted == 1); }
/// <summary> /// /// </summary> /// <param name="entity"></param> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> public bool Create(UserEntity entity, DbConnection connection, DbTransaction transaction) { var created = UsersGateway.Insert(entity, connection, transaction); return(created == 1); }
public void Setup() { _classUnderTest = new UserOrganisationGateway(DatabaseContext); _organisationsGateway = new OrganisationsGateway(DatabaseContext); _usersGateway = new UsersGateway(DatabaseContext); }