public void DebitAccountUnAuthorizedAmountTest()
{
var connection = EntityConnectionFactory.CreateTransient("name=Entities");
using (var context = new Entities(connection))
{
CashDispenser cashDispenser = new CashDispenser(context);
context.Cards.Add(new Card {
Id = 1, UserId = 1, CardNumber = "12345", Pin = 1234, Status = (int)CardStatus.Active
});
context.Users.Add(new User {
Id = 1, UserName = "******", LoginAttempt = 0, IsLoggedIn = false
});
context.AccountTypes.Add(new AccountType {
Id = 1, Name = AccounType.Current.ToString()
});
context.Accounts.Add(new Account {
Id = 1, AccountNumber = "1234", CardId = 1, AccountTypeId = 1, AmountAvailable = 500
});
context.SaveChanges();
var account = cashDispenser.DebitCash(1, 101);
var transactionHistory = context.TransactionHistories.FirstOrDefault();
Assert.AreEqual(Message.AmountRequestedNotAuthorized, account.UserMessage);
Assert.AreEqual(101, transactionHistory.TransactionAmount);
}
}
public void ReadCardThirdAttemptWrongPinTest()
{
var connection = EntityConnectionFactory.CreateTransient("name=Entities");
using (var context = new Entities(connection))
{
CardReaderService cardReaderService = new CardReaderService(context);
context.Cards.Add(new Card {
Id = 1, UserId = 1, CardNumber = "12345", Pin = 1234, Status = (int)CardStatus.Active
});
context.Users.Add(new User {
Id = 1, UserName = "******", LoginAttempt = 2, IsLoggedIn = false
});
context.AccountTypes.Add(new AccountType {
Id = 1, Name = AccounType.Current.ToString()
});
context.Accounts.Add(new Account {
Id = 1, AccountNumber = "1234", CardId = 1, AccountTypeId = 1, AmountAvailable = 500
});
context.SaveChanges();
var getCard = cardReaderService.ReadCard("12345", 4564);
Assert.AreEqual(Message.WrongPasswordRetainCard, getCard.UserMessage);
}
}
public static cinema_dbEntities cinema_DbEntities()
{
cinema_dbEntities output = null;
var data = new ObjectData();
GetSimpleContacts().ForEach(x => data.Table <contact_info>().Add(x));
GetSimpleUserStatuses().ForEach(x => data.Table <user_status>().Add(x));
GetSimpleUsers().ForEach(x => data.Table <user>().Add(x));
GetSimpleUserTypes().ForEach(x => data.Table <user_type>().Add(x));
GetSimpleType().ForEach(x => data.Table <type_film>().Add(x));
GetSimpleFilms().ForEach(x => data.Table <film>().Add(x));
GetSimpleCinemas().ForEach(x => data.Table <cinema>().Add(x));
GetSimpleSalleStatus().ForEach(x => data.Table <salle_status>().Add(x));
GetSimpleSalles().ForEach(x => data.Table <salle>().Add(x));
GetSimpleSeances().ForEach(x => data.Table <seance>().Add(x));
try
{
var connection = EntityConnectionFactory.CreateTransient("name=cinema_dbEntities", new ObjectDataLoader(data));
output = new cinema_dbEntities(connection, false);
return(output);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(output);
}
}
public void ReadCardGoodPinTest()
{
var connection = EntityConnectionFactory.CreateTransient("name=Entities");
using (var context = new Entities(connection))
{
CardReaderService cardReaderService = new CardReaderService(context);
context.Cards.Add(new Card {
Id = 1, UserId = 1, CardNumber = "12345", Pin = 1234, Status = (int)CardStatus.Active
});
context.Users.Add(new User {
Id = 1, UserName = "******", LoginAttempt = 0, IsLoggedIn = false
});
context.AccountTypes.Add(new AccountType {
Id = 1, Name = AccounType.Current.ToString()
});
context.Accounts.Add(new Account {
Id = 1, AccountNumber = "1234", CardId = 1, AccountTypeId = 1, AmountAvailable = 500
});
context.SaveChanges();
var getCard = cardReaderService.ReadCard("12345", 1234);
var user = context.Users.FirstOrDefault(x => x.Id == 1);
Assert.AreEqual(Message.LoginSuccessful, getCard.UserMessage);
Assert.AreEqual(true, getCard.IsLoggedIn);
Assert.AreEqual(0, user.LoginAttempt);
}
}
public void GetAccountNotFoundTest()
{
var connection = EntityConnectionFactory.CreateTransient("name=Entities");
using (var context = new Entities(connection))
{
CardReaderService cardReaderService = new CardReaderService(context);
context.Cards.Add(new Card {
Id = 1, UserId = 1, CardNumber = "12345", Pin = 1234, Status = (int)CardStatus.Active
});
context.Users.Add(new User {
Id = 1, UserName = "******", LoginAttempt = 0, IsLoggedIn = false
});
context.AccountTypes.Add(new AccountType {
Id = 1, Name = AccounType.Current.ToString()
});
context.Accounts.Add(new Account {
Id = 1, AccountNumber = "1234", CardId = 1, AccountTypeId = 1, AmountAvailable = 500
});
context.SaveChanges();
var account = cardReaderService.GetAccount(100);
Assert.AreEqual(Message.AccountNotFound, account.UserMessage);
}
}
public void SetUp()
{
//EffortProviderConfiguration.RegisterProvider();
var conn = EntityConnectionFactory.CreateTransient("name=ExampleMappingEntities");
//var conn = DbConnectionFactory.CreateTransient();
context = new ExampleMappingEntities(conn);
}
public void MyTestInitialize()
{
EffortProviderFactory.ResetDb();
EntityConnection connection = EntityConnectionFactory.CreateTransient("name=ISSEntities2");
//var connection = DbConnectionFactory.CreateTransient();
_context = new ISSEntities2(connection);
_repository = new RepoUserDB(_context);
}
public void EntityConnectionFactory_CreatePersistentEntityConnection()
{
var connString = this.GetDefaultConnectionString();
var csBuilder = new EntityConnectionStringBuilder(connString);
csBuilder.ProviderConnectionString = Guid.NewGuid().ToString();
EntityConnection connection = EntityConnectionFactory.CreatePersistent(csBuilder.ConnectionString);
}
public void EntityConnectionFactory_CreateTransientEntityConnection_InitializesDataSchema()
{
EntityConnection connection = EntityConnectionFactory.CreateTransient(NorthwindObjectContext.DefaultConnectionString);
using (ObjectContext context = new ObjectContext(connection))
{
Assert.IsTrue(context.DatabaseExists());
Assert.AreEqual(0, context.CreateObjectSet <Product>().Count(), "Zero rows in the fake table");
}
}
public void EntityConnectionFactory_ImplicitMetadata()
{
var connString = this.GetDefaultConnectionString();
var csBuilder = new EntityConnectionStringBuilder(connString);
csBuilder.Metadata = "res://*/";
csBuilder.ProviderConnectionString = Guid.NewGuid().ToString();
EntityConnectionFactory.CreateTransient(csBuilder.ConnectionString);
}
protected void CreateConnection()
{
if (_connection == null)
{
// Uncomment the section below to seed Effort with entities from the actual database
/*EntityDataLoader loader = new Effort.DataLoaders.EntityDataLoader("name=Entities");
* _connection = EntityConnectionFactory.CreateTransient("name=Entities", loader);*/
_connection = EntityConnectionFactory.CreateTransient("name=Entities");
}
}
public void ReadCardFullWrongPinTest()
{
var connection = EntityConnectionFactory.CreateTransient("name=Entities");
using (var context = new Entities(connection))
{
CardReaderService cardReaderService = new CardReaderService(context);
context.Cards.Add(new Card {
Id = 1, UserId = 1, CardNumber = "12345", Pin = 1234, Status = (int)CardStatus.Active
});
context.Users.Add(new User {
Id = 1, UserName = "******", LoginAttempt = 0, IsLoggedIn = false
});
context.AccountTypes.Add(new AccountType {
Id = 1, Name = AccounType.Current.ToString()
});
context.Accounts.Add(new Account {
Id = 1, AccountNumber = "1234", CardId = 1, AccountTypeId = 1, AmountAvailable = 500
});
context.SaveChanges();
var getCard = cardReaderService.ReadCard("12345", 4564);
Assert.AreEqual(Message.WrongPasswordFirstAttempt, getCard.UserMessage);
var getCard1 = cardReaderService.ReadCard("12345", 4564);
Assert.AreEqual(Message.WrongPasswordSecondAttempt, getCard1.UserMessage);
var getCard2 = cardReaderService.ReadCard("12345", 4564);
Assert.AreEqual(Message.WrongPasswordRetainCard, getCard2.UserMessage);
//Check card status after 3rd attempt
var card = context.Cards.FirstOrDefault(x => x.CardNumber == "12345");
Assert.AreEqual((int)CardStatus.Inactive, card.Status);
var user = context.Users.FirstOrDefault(x => x.Id == 1);
Assert.AreEqual(3, user.LoginAttempt);
}
}
static async Task Main(string[] args)
{
// CODE FIRST - works using persistent connection but won't using transient (throws NullReferenceException in that case)
using (var conn = DbConnectionFactory.CreatePersistent(Guid.NewGuid().ToString()))
{
// these two steps are crucial, otherwise exceptions are thrown
using (var ctx = new CodeFirstDataContext(conn))
ctx.Database.CreateIfNotExists();
conn.Open();
await DoTest(() => new CodeFirstDataContext(conn));
}
// MODEL FIRST - won't work using either persistent or transient (throws EntityException - The underlying provider failed on DataSource)
using (var conn = EntityConnectionFactory.CreateTransient("metadata=res://*/DataContext.csdl|res://*/DataContext.ssdl|res://*/DataContext.msl"))
{
conn.Open();
await DoTest(() => new DataContextContainer(conn));
}
}
//public override IRepoStrategy<T> CreateStrategy<T>()
//{
// return new MemoryStrategy<T>();
//}
public override HccDbContext CreateHccDbContext()
{
if (UseDbConnection)
{
var connString = WebAppSettings.HccEFConnectionString;
return(new HccDbContext(connString));
}
if (Connection == null)
{
var connString = WebAppSettings.HccEFConnectionString;
var csvDataPath = Path.Combine(Environment.CurrentDirectory, "CsvData");
IDataLoader loader = null;
if (InitFromCsv)
{
loader = new CsvDataLoader(csvDataPath);
}
Connection = EntityConnectionFactory.CreateTransient(connString, loader);
}
return(new HccDbContext(Connection, false));
}
public void EntityConnectionFactory_CreateTransientEntityConnection()
{
EntityConnection connection = EntityConnectionFactory.CreateTransient(NorthwindObjectContext.DefaultConnectionString);
}
private EntityConnection CreateConnection()
=> EntityConnectionFactory.CreateTransient("name=FakeHIMSDbContext");
private static EntityConnection CreateEntityConnection(string connectionString)
{
return(EntityConnectionFactory.CreateTransient(connectionString, new NorthwindLocalDataLoader()));
}
