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