예제 #1
0
        public void materialByName()
        {
            MaterialDataAccessor daMaterial  = new MaterialDataAccessor();
            DataSet1             dataSet1    = new DataSet1();
            AbstractConnection   connection  = null;
            AbstractTransaction  transaction = null;

            try
            {
                connection = DBFactory.createConnection();
                connection.open();
                transaction = connection.beginTransaction();
                daMaterial.Read(connection, transaction, dataSet1);
                transaction.commit();
            }
            catch (Exception e)
            {
                transaction.rollback();
            }
            finally
            {
                connection.close();
            }

            List <DataRow> list = dataSet1.material.Select("name_material = 'Бревна буковые'").OfType <DataRow>().ToList();

            Assert.That(list.Count, Is.EqualTo(1));

            Assert.That((int)(list[0]["id"]), Is.EqualTo(1));
            Assert.That((string)(list[0]["name_material"]), Is.EqualTo("Бревна буковые"));
            Assert.That((string)(list[0]["code_material"]), Is.EqualTo("02.20.12.112"));
        }
예제 #2
0
        public void organizationByName()
        {
            OrganizationDataAccessor dalOrganization = new OrganizationDataAccessor();
            DataSet1            dataSet1             = new DataSet1();
            AbstractConnection  connection           = null;
            AbstractTransaction transaction          = null;

            try
            {
                connection = DBFactory.createConnection();
                connection.open();
                transaction = connection.beginTransaction();
                dalOrganization.Read(connection, transaction, dataSet1);
                transaction.commit();
            }
            catch (Exception e)
            {
                transaction.rollback();
            }
            finally
            {
                connection.close();
            }

            List <DataRow> list = dataSet1.organization.Select("organization_name = 'ОАО \"КРАСНОЯРСКЛЕСОМАТЕРИАЛЫ\"'").OfType <DataRow>().ToList();

            Assert.That(list.Count, Is.EqualTo(1));

            Assert.That((int)(list[0]["id"]), Is.EqualTo(2));
            Assert.That((string)(list[0]["organization_name"]), Is.EqualTo("ОАО \"КРАСНОЯРСКЛЕСОМАТЕРИАЛЫ\""));
            Assert.That((int)(list[0]["okpo_number"]), Is.EqualTo(47828137));
        }
예제 #3
0
        public void GetAll()
        {
            //Setup();
            MaterialDataAccessor daMaterial  = new MaterialDataAccessor();
            DataSet1             dataSet1    = new DataSet1();
            AbstractConnection   connection  = null;
            AbstractTransaction  transaction = null;

            try
            {
                connection = DBFactory.createConnection();
                connection.open();
                transaction = connection.beginTransaction();
                daMaterial.Read(connection, transaction, dataSet1);
                transaction.commit();
            }
            catch (Exception e)
            {
                transaction.rollback();
            }
            finally
            {
                connection.close();
            }

            List <DataRow> list = dataSet1.material.Select().OfType <DataRow>().ToList();

            list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"]));  //сортируем по ид

            Assert.That(1, Is.EqualTo(1));
            Assert.That(list.Count, Is.EqualTo(8));
            Assert.That((int)(list[0]["id"]), Is.EqualTo(1));
            Assert.That((string)(list[0]["name_material"]), Is.EqualTo("Бревна буковые"));
            Assert.That((string)(list[0]["code_material"]), Is.EqualTo("02.20.12.112"));
        }
예제 #4
0
        public void unit_of_measurementByName()
        {
            UnitsDataAccessor   daUnit      = new UnitsDataAccessor();
            DataSet1            dataSet1    = new DataSet1();
            AbstractConnection  connection  = null;
            AbstractTransaction transaction = null;

            try
            {
                connection = DBFactory.createConnection();
                connection.open();
                transaction = connection.beginTransaction();
                daUnit.Read(connection, transaction, dataSet1);
                transaction.commit();
            }
            catch (Exception e)
            {
                transaction.rollback();
            }
            finally
            {
                connection.close();
            }

            List <DataRow> list = dataSet1.unit_of_measurement.Select("unit_name = 'Миллиметр'").OfType <DataRow>().ToList();

            Assert.That(list.Count, Is.EqualTo(1));

            Assert.That((int)(list[0]["id"]), Is.EqualTo(4));
            Assert.That((string)(list[0]["unit_name"]), Is.EqualTo("Миллиметр"));
            Assert.That((string)(list[0]["code"]), Is.EqualTo("003"));
            Assert.That((string)(list[0]["national_symbol"]), Is.EqualTo("мм"));
        }
예제 #5
0
        public void updateMaterials(DataSet1 dataSet1)
        {
            MaterialDataAccessor DA             = new MaterialDataAccessor();
            PositionDataAccessor DApos          = new PositionDataAccessor();
            AbstractConnection   absConnection  = null;
            AbstractTransaction  absTransaction = null;

            try
            {
                absConnection = DBFactory.createConnection();
                absConnection.open();
                absTransaction = absConnection.beginTransaction();
                DA.Update(absConnection, absTransaction, dataSet1);
                DApos.Update(absConnection, absTransaction, dataSet1);
                absTransaction.commit();
            }
            catch (Exception e)
            {
                absTransaction.rollback();
            }
            finally
            {
                absConnection.close();
            }
        }
예제 #6
0
        public DataSet1 getUnits()
        {
            UnitsDataAccessor    DA             = new UnitsDataAccessor();
            PositionDataAccessor DApos          = new PositionDataAccessor();
            DataSet1             dataSet1       = new DataSet1();
            AbstractConnection   absConnection  = null;
            AbstractTransaction  absTransaction = null;

            try
            {
                absConnection = DBFactory.createConnection();
                absConnection.open();
                absTransaction = absConnection.beginTransaction();
                DA.Read(absConnection, absTransaction, dataSet1);
                DApos.Read(absConnection, absTransaction, dataSet1);
                absTransaction.commit();
            }
            catch (Exception e)
            {
                absTransaction.rollback();
            }
            finally
            {
                absConnection.close();
            }

            return(dataSet1);
        }
예제 #7
0
        public void updateOrganizations(DataSet1 dataSet1)
        {
            OrganizationDataAccessor DA             = new OrganizationDataAccessor();
            InvoiceDataAccessor      DAinvoice      = new InvoiceDataAccessor();
            AbstractConnection       absConnection  = null;
            AbstractTransaction      absTransaction = null;

            try
            {
                absConnection = DBFactory.createConnection();
                absConnection.open();
                absTransaction = absConnection.beginTransaction();
                DA.Update(absConnection, absTransaction, dataSet1);
                DAinvoice.Update(absConnection, absTransaction, dataSet1);
                absTransaction.commit();
            }
            catch (Exception e)
            {
                absTransaction.rollback();
            }
            finally
            {
                absConnection.close();
            }
        }
예제 #8
0
        public void invoiceByName()
        {
            InvoiceDataAccessor daInvoice = new InvoiceDataAccessor();
            DataSet1 dataSet1 = new DataSet1();
            AbstractConnection connection = null;
            AbstractTransaction transaction = null;
            try
            {
                connection = DBFactory.createConnection();
                connection.open();
                transaction = connection.beginTransaction();
                daInvoice.Read(connection, transaction, dataSet1);
                transaction.commit();
            }
            catch (Exception e)
            {
                transaction.rollback();
            }
            finally
            {
                connection.close();
            }

            List<DataRow> list = dataSet1.invoice.Select("invoice_number = '000001'").OfType<DataRow>().ToList();

            Assert.That(list.Count, Is.EqualTo(1));

            Assert.That((int)(list[0]["id"]), Is.EqualTo(1));
            Assert.That((string)(list[0]["invoice_number"]), Is.EqualTo("000001"));
            Assert.That((int)(list[0]["organization_id"]), Is.EqualTo(2));
        }
예제 #9
0
        public void GetAll()
        {
            //Setup();
            InvoiceDataAccessor daInvoice = new InvoiceDataAccessor();
            DataSet1 dataSet1 = new DataSet1();
            AbstractConnection connection = null;
            AbstractTransaction transaction = null;
            try
            {
                connection = DBFactory.createConnection();
                connection.open();
                transaction = connection.beginTransaction();
                daInvoice.Read(connection, transaction, dataSet1);
                transaction.commit();
            }
            catch (Exception e)
            {
                transaction.rollback();
            }
            finally
            {
                connection.close();
            }

            List<DataRow> list = dataSet1.invoice.Select().OfType<DataRow>().ToList();
            list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"]));  //сортируем по ид

            Assert.That(1, Is.EqualTo(1));
            Assert.That(list.Count, Is.EqualTo(2));
            Assert.That((int)(list[0]["id"]), Is.EqualTo(1));
            Assert.That((string)(list[0]["invoice_number"]), Is.EqualTo("000001"));
            Assert.That((int)(list[0]["organization_id"]), Is.EqualTo(2));
        }
예제 #10
0
        public void GetAll()
        {
            //Setup();
            PositionDataAccessor daInvoice   = new PositionDataAccessor();
            DataSet1             dataSet1    = new DataSet1();
            AbstractConnection   connection  = null;
            AbstractTransaction  transaction = null;

            try
            {
                connection = DBFactory.createConnection();
                connection.open();
                transaction = connection.beginTransaction();
                daInvoice.Read(connection, transaction, dataSet1);
                transaction.commit();
            }
            catch (Exception e)
            {
                transaction.rollback();
            }
            finally
            {
                connection.close();
            }

            List <DataRow> list = dataSet1.position_in_mat_delivery_note.Select().OfType <DataRow>().ToList();

            list.Sort((x, y) => ((int)x["id_"]).CompareTo((int)y["id_"]));  //сортируем по ид

            Assert.That(1, Is.EqualTo(1));
            Assert.That(list.Count, Is.EqualTo(5));
            Assert.That((int)(list[0]["id_"]), Is.EqualTo(1));
            Assert.That((double)(list[0]["amount"]), Is.EqualTo(10));
            Assert.That((int)(list[0]["invoice_id"]), Is.EqualTo(1));
        }
예제 #11
0
        public static void init()
        {
            // Дропаем все таблицы
            AbstractConnection  connection_Truncate  = null;
            AbstractTransaction transaction_Truncate = null;

            try
            {
                connection_Truncate = DBFactory.createConnection();
                connection_Truncate.open();
                transaction_Truncate = connection_Truncate.beginTransaction();
                string      path   = Path.Combine(@"C:\SQL", TruncateSql);
                String      str    = File.ReadAllText(path);
                MySqlScript script = new MySqlScript(connection_Truncate.get(), str);
                script.Execute();
                transaction_Truncate.commit();
            }
            catch (Exception e)
            {
                transaction_Truncate.rollback();
            }
            finally
            {
                connection_Truncate.close();
            }

            // Создаем базу заново
            AbstractConnection  connection_Insert  = null;
            AbstractTransaction transaction_Insert = null;

            try
            {
                connection_Insert = DBFactory.createConnection();
                connection_Insert.open();
                transaction_Insert = connection_Insert.beginTransaction();
                string      path   = Path.Combine(@"C:\SQL", InsertSql);
                String      str    = File.ReadAllText(path);
                MySqlScript script = new MySqlScript(connection_Insert.get(), str);
                script.Execute();
                transaction_Insert.commit();
            }
            catch (Exception e)
            {
                transaction_Insert.rollback();
            }
            finally
            {
                connection_Insert.close();
            }
        }
예제 #12
0
        public void materialDelete()
        {
            DataSet1             dataSetRead  = new DataSet1();
            MaterialDataAccessor daMaterial   = new MaterialDataAccessor();
            AbstractConnection   absCon_Read  = null;
            AbstractTransaction  absTran_Read = null;
            int countRowBefore = 0;

            try
            {
                absCon_Read = DBFactory.createConnection();
                absCon_Read.open();
                absTran_Read = absCon_Read.beginTransaction();
                daMaterial.Read(absCon_Read, absTran_Read, dataSetRead);

                List <DataRow> rows_list = dataSetRead.material.Select("name_material = 'Бревна буковые'").OfType <DataRow>().ToList();
                // Сортируем строки по id в порядке возрастания
                rows_list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"]));
                // Количество записей до удаления
                countRowBefore = rows_list.Count();
                absTran_Read.commit();
            }
            catch (Exception e)
            {
                absTran_Read.rollback();
            }
            finally
            {
                absCon_Read.close();
            }

            Assert.That(countRowBefore, Is.EqualTo(1));


            // НОВОЕ СОЕДИНЕНИЕ, удаляем
            AbstractConnection  absCon_Update  = null;
            AbstractTransaction absTran_Update = null;

            List <DataRow> list_1 = dataSetRead.material.Select("name_material = 'Бревна буковые'").OfType <DataRow>().ToList();

            foreach (DataRow rowForDel in list_1)
            {
                dataSetRead.material.Rows.Remove(rowForDel);
            }


            try
            {
                absCon_Update = DBFactory.createConnection();
                absCon_Update.open();
                absTran_Update = absCon_Update.beginTransaction();
                daMaterial.Update(absCon_Update, absTran_Update, dataSetRead);

                absTran_Update.commit();
            }
            catch (Exception e)
            {
                absTran_Update.rollback();
            }
            finally
            {
                absCon_Update.close();
            }


            // Новый коннекшн, проверяем что теперь записей стало на одну больше
            AbstractConnection   absCon_AfterInsert     = null;
            AbstractTransaction  absTran_AfterInsert    = null;
            DataSet1             dataSet_AfterInsert    = new DataSet1();
            MaterialDataAccessor MaterialDA_AfterInsert = new MaterialDataAccessor();

            try
            {
                absCon_AfterInsert = DBFactory.createConnection();
                absCon_AfterInsert.open();
                absTran_AfterInsert = absCon_AfterInsert.beginTransaction();
                MaterialDA_AfterInsert.Read(absCon_AfterInsert, absTran_AfterInsert, dataSet_AfterInsert);
                absTran_AfterInsert.commit();
            }
            catch (Exception e)
            {
                absTran_AfterInsert.commit();
            }
            finally
            {
                absCon_AfterInsert.close();
            }

            List <DataRow> rows_list_AfterInsert = dataSetRead.material.Select("name_material = 'Бревна буковые'").OfType <DataRow>().ToList();

            Assert.That(rows_list_AfterInsert.Count, Is.EqualTo(0));
        }
예제 #13
0
        public void materialAdd()
        {
            DataSet1             dataSetRead  = new DataSet1();
            MaterialDataAccessor daMaterial   = new MaterialDataAccessor();
            AbstractConnection   absCon_Read  = null;
            AbstractTransaction  absTran_Read = null;
            int countRowBefore = 0;

            try
            {
                absCon_Read = DBFactory.createConnection();
                absCon_Read.open();
                absTran_Read = absCon_Read.beginTransaction();
                daMaterial.Read(absCon_Read, absTran_Read, dataSetRead);

                List <DataRow> rows_list = dataSetRead.material.Select("").OfType <DataRow>().ToList();
                // Сортируем строки по id в порядке возрастания
                rows_list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"]));
                // Количество записей до внесения новой
                countRowBefore = rows_list.Count();
                absTran_Read.commit();
            }
            catch (Exception e)
            {
                absTran_Read.rollback();
            }
            finally
            {
                absCon_Read.close();
            }


            // НОВОЕ СОЕДИНЕНИЕ, Добавляем в базу новую запись
            AbstractConnection  absCon_Update  = null;
            AbstractTransaction absTran_Update = null;

            List <DataRow> list_1 = dataSetRead.material.Select("").OfType <DataRow>().ToList();

            // Сортируем строки по айдишнику в порядке возрастания
            list_1.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"]));
///
            DataRow rowForAdded = dataSetRead.material.NewRow();


            rowForAdded["name_material"] = "Бревна буковые";
            rowForAdded["code_material"] = "02.20.12.112";

            dataSetRead.material.Rows.Add(rowForAdded);

            List <DataRow> list_2 = dataSetRead.material.Select("").OfType <DataRow>().ToList();

            // Сортируем строки по айдишнику в порядке возрастания
            list_2.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"]));

            try
            {
                absCon_Update = DBFactory.createConnection();
                absCon_Update.open();
                absTran_Update = absCon_Update.beginTransaction();
                daMaterial.Update(absCon_Update, absTran_Update, dataSetRead);

                absTran_Update.commit();
            }
            catch (Exception e)
            {
                absTran_Update.rollback();
            }
            finally
            {
                absCon_Update.close();
            }


            // Новый коннекшн, проверяем что теперь записей стало на одну больше
            AbstractConnection   absCon_AfterInsert     = null;
            AbstractTransaction  absTran_AfterInsert    = null;
            DataSet1             dataSet_AfterInsert    = new DataSet1();
            MaterialDataAccessor MaterialDA_AfterInsert = new MaterialDataAccessor();
            int countRowAfter = 0;

            try
            {
                absCon_AfterInsert = DBFactory.createConnection();
                absCon_AfterInsert.open();
                absTran_AfterInsert = absCon_AfterInsert.beginTransaction();
                MaterialDA_AfterInsert.Read(absCon_AfterInsert, absTran_AfterInsert, dataSet_AfterInsert);
                absTran_AfterInsert.commit();
            }
            catch (Exception e)
            {
                absTran_AfterInsert.commit();
            }
            finally
            {
                absCon_AfterInsert.close();
            }

            List <DataRow> rows_list_AfterInsert = dataSet_AfterInsert.material.Select("").OfType <DataRow>().ToList();

            // Сортируем строки по айдишнику в порядке возрастания
            rows_list_AfterInsert.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"]));
            countRowAfter = rows_list_AfterInsert.Count();

            // Проверяем, что записей стало на одну больше
            Assert.That(countRowAfter - countRowBefore, Is.EqualTo(1));

            // Берем последнюю добавленную запись( для этого сортируем )
            DataRow rowAfterInsert = rows_list_AfterInsert[rows_list_AfterInsert.Count - 1];

            // Проверяем что запись добавилась правильно
            Assert.That(rowForAdded["name_material"], Is.EqualTo(rowAfterInsert["name_material"]));
            Assert.That(rowForAdded["code_material"], Is.EqualTo(rowAfterInsert["code_material"]));
        }
예제 #14
0
        public void materialUpdate()
        {
            MaterialDataAccessor daMaterial  = new MaterialDataAccessor();
            DataSet1             dataSet1    = new DataSet1();
            AbstractConnection   connection  = null;
            AbstractTransaction  transaction = null;

            try
            {
                connection = DBFactory.createConnection();
                connection.open();
                transaction = connection.beginTransaction();
                daMaterial.Read(connection, transaction, dataSet1);
                transaction.commit();
            }
            catch (Exception e)
            {
                transaction.rollback();
            }
            finally
            {
                connection.close();
            }

            List <DataRow> list = dataSet1.material.Select("").OfType <DataRow>().ToList();

            // Сортируем строки по айдишнику в порядке возрастания
            list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"]));
//            Assert.That(list.Count, Is.EqualTo(2)); // всего две строки


            // Обновляем первую запись
            //CarDTO oldCarDTO = null;
            DataSet1.materialRow oldM         = null;
            AbstractConnection   connectionN  = null;
            AbstractTransaction  transactionN = null;
            String oldName = "";

            try
            {
                connectionN = DBFactory.createConnection();
                connectionN.open();
                transactionN = connectionN.beginTransaction();
                oldM         = dataSet1.material[0];
                oldName      = oldM.name_material;
//                oldCarDTO = new CarDTO(dataSet1.car[0]);

                dataSet1.material[0].name_material = oldM.name_material + "_changed";
                daMaterial.Update(connectionN, transactionN, dataSet1);
                transactionN.commit();
            }
            catch (Exception e)
            {
                transactionN.rollback();
            }
            finally
            {
                connectionN.close();
            }


            // Заново читаем из базы, проверяем, что поменялось
            MaterialDataAccessor daUpdated          = new MaterialDataAccessor();
            DataSet1             dataSetUpdated     = new DataSet1();
            AbstractConnection   connectionUpdated  = null;
            AbstractTransaction  transactionUpdated = null;

            try
            {
                connectionUpdated = DBFactory.createConnection();
                connectionUpdated.open();
                transactionUpdated = connectionUpdated.beginTransaction();
                daUpdated.Read(connectionUpdated, transactionUpdated, dataSetUpdated);
                transactionUpdated.commit();
            }
            catch (Exception e)
            {
                transactionUpdated.rollback();
            }
            finally
            {
                connectionUpdated.close();
            }

            // достаем из датасета все записи таблицы
            List <DataRow> list_3 = dataSetUpdated.material.Select("").OfType <DataRow>().ToList();

            // Сортируем по id
            list_3.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"]));
            // Проверяем что записей столько же
            Assert.That(list_3.Count, Is.EqualTo(8));

            // Достае ту же запись
            List <DataRow> rows_list = dataSet1.material.Select("id = " + oldM.id).OfType <DataRow>().ToList();

            // Проверяем что по такому id одна запись
            Assert.That(rows_list.Count, Is.EqualTo(1));

            DataSet1.materialRow updatedM = dataSetUpdated.material[0];

            Assert.That(oldM.id, Is.EqualTo(updatedM.id));

            Assert.That(oldName, !Is.EqualTo(updatedM.name_material));
            Assert.That(oldName + "_changed", Is.EqualTo(updatedM.name_material));
        }