public void Test_Inserts_WithTransactionScope()
        {
            this.helper.CreateTable();

            Command       command = this.helper.GetInsert();
            CommandEngine engine  = this.helper.GetCommandEngine(new TransactionScopeFilter());

            try
            {
                engine.Execute(command);
            }
            catch (DbException) { }

            this.helper.VerifyTransaction();
        }
        public void Test_MultiInsert_WithExplicitTransaction()
        {
            this.helper.CreateTable();

            Command[]     commands = this.GetMultiInsertCommands();
            CommandEngine engine   = this.helper.GetCommandEngine(new TransactionFilter());

            try
            {
                engine.Execute(commands);
            }
            catch (DbException) { }

            this.helper.VerifyTransaction();
        }
示例#3
0
        void ExecuteCommand(string command)
        {
            var parser       = new CommandParser();
            var parsedResult = parser.Parse(command);

            if (!string.IsNullOrEmpty(parsedResult.ErrorMessage))
            {
                TextBlockResult.Foreground = Brushes.Red;
                TextBlockResult.Text       = parsedResult.ErrorMessage;
                TextBlockResult.ToolTip    = parsedResult.ErrorMessage;
                OnPropertyChanged(TwNotificationProperty.OnCommandError);
            }
            else
            {
                var commandResult = engine.Execute(parsedResult.Command);

                if (!string.IsNullOrEmpty(commandResult.ErrorMessage))
                {
                    TextBlockResult.Foreground = Brushes.Red;
                    TextBlockResult.Text       = commandResult.ErrorMessage;
                    TextBlockResult.ToolTip    = commandResult.ErrorMessage;
                    OnPropertyChanged(TwNotificationProperty.OnCommandError);
                }
                else
                {
                    TextBlockResult.Foreground = Brushes.Black;
                    TextBlockResult.Text       = string.IsNullOrEmpty(commandResult.SuccessMessage)? parsedResult.SuccessMessage : commandResult.SuccessMessage;
                    TextBlockResult.ToolTip    = string.IsNullOrEmpty(commandResult.SuccessMessage) ? parsedResult.SuccessMessage : commandResult.SuccessMessage;
                    if (string.IsNullOrEmpty(commandResult.SuccessMessage))
                    {
                        OnPropertyChanged(TwNotificationProperty.OnCommandSuccess);
                    }
                    else
                    {
                        OnPropertyChanged(TwNotificationProperty.OnCommandError);
                    }
                }
            }
        }
示例#4
0
        public async Task Test_CommandEngine_Connection()
        {
            var connection1 = new SqliteConnection(DatabaseHelper.TestDbConnectionString);
            var connection2 = new SqliteConnection(DatabaseHelper.TestDbConnectionString);

            try
            {
                CommandOptions options1 = new CommandOptions()
                {
                    ConnectionFactory = () => connection1,
                };

                CommandOptions options2 = new CommandOptions()
                {
                    ConnectionFactory = () => connection2,
                };

                CommandEngine engine1 = new CommandEngine(options1);
                CommandEngine engine2 = new CommandEngine(options2);

                engine1.Execute(new Command()
                {
                    CommandText = "SELECT 0;"
                });
                await engine2.ExecuteAsync(new Command()
                {
                    CommandText = "SELECT 0;"
                });

                connection1.State.ShouldBe(ConnectionState.Closed);
                connection2.State.ShouldBe(ConnectionState.Closed);
            }
            finally
            {
                connection1.Dispose();
                connection2.Dispose();
            }
        }
 async public void Loaded()
 {
     var beforeAppLoadEngine = new CommandEngine<IBeforeAppLoad>();
     await beforeAppLoadEngine.Execute();
     AppWindowViewModel.SetContent<AppViewModel>();
 }
示例#6
0
        static void Main()
        {
            //var kur = new GirlAgencyMySql.Data.MySql();
            //Console.WriteLine(kur.Customers.Count());
            //var ctx = new OracleContext();

            //Console.WriteLine(ctx.Girls.Count());//

            // var mySql = new GirlAgencyMySql.Data.MySql();
            // Console.WriteLine(mySql.Customers.Count());

            while (true)
            {
                string command           = Console.ReadLine();
                var    dispatchedCommand = CommandEngine.Dispatch(command);
                CommandEngine.Execute(dispatchedCommand);
            }

            //var sqllite = new GirlsTaxesEntities();
            //Console.WriteLine(sqllite.GirlsTaxes.Count());

            //Exporters.PDFExporter.ExportGirlsReport("01.01.2015", "01.01.2016");
            //Exporters.XMLExporter.ExportCitiesReport("01.01.2015", "01.01.2016");



            // //zemi taq moma i i sloji procent
            // string firstName = "Minka";
            // string lastName = "Svirchoka";


            ////need to change database

            // var girlTaxesContext = new GirlsTaxesEntities();
            // Console.WriteLine(girlTaxesContext.GirlsTaxes.Count());


            // var mySqlGrilRepo = new GenericRepository<Girl>(new GirlsAgencyContext());


            // var girl = mySqlGrilRepo.Search(g => g.FirstName == firstName && g.LastName == lastName).FirstOrDefault();

            // //Console.WriteLine(girl.FirstName);

            // //add  tax for the bitch

            // int tax = 20;



            // girlTaxesContext.GirlsTaxes.Add(
            //     new GirlsTax()
            //     {

            //         GirlName = girl.FirstName + " " + girl.LastName,
            //         Tax = tax

            //     });

            // girlTaxesContext.SaveChanges();

            // Console.WriteLine(girlTaxesContext.GirlsTaxes.Count());



//<<<<<<< HEAD

//            //var SqlServerGirslRepo = new GenericRepository<Girl>(new GirlsAgencyContext());
//            //Console.WriteLine(SqlServerGirslRepo.GetAll().Count());
//=======

            //var context = new GirlsAgencyContext();

            //Console.WriteLine(context.Countries.Count());

            //Exporters.PDFExporter.ExportGirlsReport(new DateTime(2015, 1, 1), new DateTime(2016, 1, 1));


            //var sqlServerGirslRepo = new GenericRepository<Girl>(new GirlsAgencyContext());



            //Console.WriteLine(sqlServerGirslRepo.GetAll().Count());

            //var girl = new Girl()
            //{
            //    BreastSizeId = 1,
            //    Age = 20,
            //    CountyId = 2,
            //    FirstName = "Minka",
            //    LastName = "Svirkata",
            //    HairColorId = 4,
            //    CityId = 1,
            //    PricePerHour = 2489M
            //};

            //sqlServerGirslRepo.Add(girl);
            //sqlServerGirslRepo.SaveChanges();

            //var repo = new GenericRepository<Girl>(new GirlsAgencyContext());

            // Excel.GetRecords("E:\\fuckoff\\GirlsAgency\\Importer.xlsx", "Girls");

            //var context = new GirlsAgencyContext();
            //var girl = new Girl()
            //{
            //    FirstName = "Minka",
            //    LastName = "Svirchoka",
            //    Age = 18,
            //    BreastSizeId = (int)BreastSizeEnum.Normal,
            //    HairColorId = (int)HairColorEnum.Blonde,
            //    PricePerHour = 80.0M,
            //    Features = new HashSet<Feature>
            //    {
            //        new Feature {Name = GirlsFeaturesEnum.Felatio.ToString()},
            //        new Feature {Name = GirlsFeaturesEnum.DoggyStyle.ToString()}
            //    }
            //};

            //const string zipPath = @"C:\Users\v.indzhev\Desktop\Bunker.zip";
            //const string extractPath = @"C:\Users\v.indzhev\Desktop\Bunker\";
            ////ZipFile.ExtractToDirectory(zipPath, extractPath);


            //var test = Excel.GetRecords(@"C:\Users\v.indzhev\Desktop\Bunker\Importer.xlsx", "Girl");
            //var test = GirlsAgency.Data.FileManipulations.Excel.ExportData(@"C:\Users\v.indzhev\Desktop\Bunker\", @"Importer.xlsx");
            //foreach (var t in test)
            //{
            //    Console.WriteLine(t);
            //}

            //context.Girls.Add(girl);
            //context.SaveChanges();
            //Console.WriteLine(girlsCount);

            //var context = new GirlsAgencyContext();
            //var orders = XML.Read(@"C:\Users\v.indzhev\Desktop\kovri.xml");
            //foreach (var order in orders)
            //{
            //    context.Orders.Add(order);
            //}

            //context.SaveChanges();
            //XML.ReadXML(@"C:\Users\v.indzhev\Desktop\", @"kovri.xml");



            //var context = new GirlsAgencyContext();
            //Console.WriteLine(context.Girls.Count());

            //var context2 = new OracleContext();
            //Console.WriteLine(context2.Girls.Count());
            //context.SaveChanges();
            //var oracle = new OracleContext();
            //var sqlServer = new GirlsAgencyContext();
            //var oralcleServer = new OracleContext();

            //var GirlsAgencySqlSystem = new GenericRepository<Girl>(sqlServer);
            //var GirlAgencyOracleSystem = new GenericRepository<Girl>(oralcleServer);

            //int a =  GirlsAgencySqlSystem.GetAll().Count();
            //int b = GirlAgencyOracleSystem.GetAll().Count();
            //Console.WriteLine(b);

            //Console.WriteLine(a);

            //Console.WriteLine();


            //var controller = new RepositoryController(oracle, sqlServer);

            //var girl = new Girl
            //{
            //    FirstName = "Minka",
            //    LastName = "Svirchoka",
            //    Age = 18,
            //    BreastSizeId = (int)BreastSizeEnum.Normal,
            //    HairColorId = (int)HairColorEnum.Blonde,
            //    PricePerHour = 80.0M

            //};


            // girlRepoSqlServer.Add(girl);
            //GirlAgencyOracleSystem.Add(girl);

            //GirlAgencyOracleSystem.SaveChanges();

            //var gir = GirlAgencyOracleSystem.GetAll().First();
            //Console.WriteLine(gir.FirstName);


            // Console.WriteLine(GirlAgencyOracleSystem.GetEntityAsJson(gir));

            //var json= GirlsAgencySqlSystem.GetJson();
            //var jsonSqlServer = GirlsAgencySqlSystem.GetJson();

            //Console.WriteLine(json);

            //Console.WriteLine(json);
            //var girl2 = new Girl()
            //{
            //    FirstName = "kur",
            //    LastName = "Svirchoka",
            //    Age = 18,
            //    BreastSizeId = (int)BreastSizeEnum.Normal,
            //    HairColorId = (int)HairColorEnum.Blonde,
            //    PricePerHour = 80.0M,
            //    Features = new HashSet<Feature>
            //    {
            //        new Feature {Name = GirlsFeaturesEnum.Felatio.ToString()},
            //        new Feature {Name = GirlsFeaturesEnum.DoggyStyle.ToString()}
            //    }
            //};


            //ICollection<Girl> girls = new List<Girl>();
            //girls.Add(girl);
            //girls.Add(girl2);

            //controller.Test(girls);

            //var cont = new GirlsAgencyContext();
            //Console.WriteLine(cont.Customers.Count());


            //var aaa = new GenericRepository<Country>(new GirlsAgencyContext());
            //aaa.Add(new Country { Name = "Kur" });
            //aaa.SaveChanges();

            // var ctx = new MySQLContext();

            //ctx.Orders.ToList();

            // ctx.SaveChanges();
        }