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