public UnitOfWork(LascarizadorDbContext context)
 {
     _context         = context;
     Clients          = new ClientRepository(_context);
     CardBrands       = new CardBrandRepository(_context);
     CardTypes        = new CardTypeRepository(_context);
     Cards            = new CardRepository(_context);
     Transactions     = new TransactionRepository(_context);
     TransactionTypes = new TransactionTypeRepository(_context);
     TransactionLogs  = new TransactionLogRepository(_context);
     ErrorLogs        = new ErrorLogRepository(_context);
 }
        public void InsertLogs(int itemId, int quantiy)
        {
            TransactionLogRepository transactionLogRepo = new TransactionLogRepository();

            TransactionLog transactionLog = new TransactionLog
            {
                ItemId = itemId,
                Quantity = quantiy,
                TransactionMethodId = (int)ETransactionMethod.ExcessPartsFromSet,
                CompanyId = Sessions.CompanyId.Value
            };

            transactionLogRepo.Add(transactionLog);
        }
        public void InsertLogs(int itemId, int quantiy, int companyId)
        {
            TransactionLogRepository transactionLogRepo = new TransactionLogRepository();

            TransactionLog transactionLog = new TransactionLog
            {
                ItemId              = itemId,
                Quantity            = quantiy,
                TransactionMethodId = (int)ETransactionMethod.StockTransfer_Company,
                CompanyId           = companyId,
                ItemTypeId          = itemRepo.GetItemType(itemId)
            };

            transactionLogRepo.Add(transactionLog);
        }
        public int InsertLogs(int itemId, int quantiy, DateTime dateReceived, int itemType)
        {
            TransactionLogRepository transactionLogRepo = new TransactionLogRepository();

            TransactionLog transactionLog = new TransactionLog
            {
                ItemId              = itemId,
                Quantity            = quantiy,
                TransactionMethodId = (int)ETransactionMethod.Receiving,
                CompanyId           = Sessions.CompanyId.Value,
                Date       = dateReceived,
                ItemTypeId = itemType
            };

            transactionLogRepo.Add(transactionLog);

            return(transactionLog.Id);
        }
Exemple #5
0
        public StorageProcessor(string url, string connectionString, string prefix, bool postVm = false)
        {
            _web3 = url.EndsWith(".ipc") ? new Web3.Web3(new IpcClient(url)) : new Web3.Web3(url);



            var blockRepository              = new BlockRepository();
            var transactionRepository        = new TransactionRepository();
            var addressTransactionRepository = new AddressTransactionRepository();
            var contractRepository           = new ContractRepository();
            var logRepository     = new TransactionLogRepository();
            var vmStackRepository = new TransactionVMStackRepository();

            var contractTransactionProcessor = new ContractTransactionProcessor(_web3, contractRepository,
                                                                                transactionRepository
                                                                                //,addressTransactionRepository
                                                                                //,vmStackRepository,
                                                                                //logRepository
                                                                                );
            var contractCreationTransactionProcessor = new ContractCreationTransactionProcessor(_web3, contractRepository,
                                                                                                transactionRepository
                                                                                                //, addressTransactionRepository
                                                                                                );
            var valueTrasactionProcessor = new ValueTransactionProcessor(transactionRepository
                                                                         //,addressTransactionRepository
                                                                         );

            var transactionProcessor = new TransactionProcessor(_web3, contractTransactionProcessor,
                                                                valueTrasactionProcessor, contractCreationTransactionProcessor);


            if (postVm)
            {
                _procesor = new BlockVmPostProcessor(_web3, blockRepository, transactionProcessor, transactionRepository);
            }
            else
            {
                transactionProcessor.ContractTransactionProcessor.EnabledVmProcessing = false;
                _procesor = new BlockProcessor(_web3, blockRepository, transactionProcessor, transactionRepository);
            }
        }
Exemple #6
0
        public StorageProcessor(string url, string connectionString, string prefix, bool postVm = false)
        {
            _web3 = url.EndsWith(".ipc") ? new Web3.Web3(new IpcClient(url)) : new Web3.Web3(url);
            var tableSetup = new CloudTableSetup(connectionString);

            _contractTable = tableSetup.GetContractsTable(prefix);
            var transactionsTable        = tableSetup.GetTransactionsTable(prefix);
            var addressTransactionsTable = tableSetup.GetAddressTransactionsTable(prefix);
            var blocksTable  = tableSetup.GetBlocksTable(prefix);
            var logTable     = tableSetup.GetTransactionsLogTable(prefix);
            var vmStackTable = tableSetup.GetTransactionsVmStackTable(prefix);

            var blockRepository              = new BlockRepository(blocksTable);
            var transactionRepository        = new TransactionRepository(transactionsTable);
            var addressTransactionRepository = new AddressTransactionRepository(addressTransactionsTable);
            var contractRepository           = new ContractRepository(_contractTable);
            var logRepository     = new TransactionLogRepository(logTable);
            var vmStackRepository = new TransactionVMStackRepository(vmStackTable);

            var contractTransactionProcessor = new ContractTransactionProcessor(_web3, contractRepository,
                                                                                transactionRepository, addressTransactionRepository, vmStackRepository, logRepository);
            var contractCreationTransactionProcessor = new ContractCreationTransactionProcessor(_web3, contractRepository,
                                                                                                transactionRepository, addressTransactionRepository);
            var valueTrasactionProcessor = new ValueTransactionProcessor(transactionRepository,
                                                                         addressTransactionRepository);

            var transactionProcessor = new TransactionProcessor(_web3, contractTransactionProcessor,
                                                                valueTrasactionProcessor, contractCreationTransactionProcessor);


            if (postVm)
            {
                _procesor = new BlockVmPostProcessor(_web3, blockRepository, transactionProcessor);
            }
            else
            {
                transactionProcessor.ContractTransactionProcessor.EnabledVmProcessing = false;
                _procesor = new BlockProcessor(_web3, blockRepository, transactionProcessor);
            }
        }
        public void Save(Receiving receiving, int itemid, string unitcost)
        {
            if (receiving.Id == 0)
            {
                if (receiving.SerialNo == null)
                {
                    receiving.SerialNo = "N/A";
                }

                context.Receivings.Add(receiving);

                context.SaveChanges();
                int id;
                id = receiving.Id;

                InsertStockCard(id, itemid, Convert.ToDecimal(unitcost), receiving.Quantity, receiving.TransactionLogId);
            }
            else
            {
                Receiving dbEntry = context.Receivings.Find(receiving.Id);
                if (dbEntry != null)
                {
                    dbEntry.PurchaseOrderItemId = receiving.PurchaseOrderItemId;
                    dbEntry.Quantity            = receiving.Quantity;
                    dbEntry.SerialNo            = receiving.SerialNo;
                    dbEntry.DrNo             = receiving.DrNo;
                    dbEntry.DateReceived     = receiving.DateReceived;
                    dbEntry.TransactionLogId = receiving.TransactionLogId;

                    context.SaveChanges();

                    TransactionLogRepository transLogRepo = new TransactionLogRepository();
                    transLogRepo.Update(dbEntry.TransactionLogId.Value, receiving.Quantity, receiving.DateReceived.Value);
                    UpdateStockCard(receiving.Id, itemid, Convert.ToDecimal(unitcost), receiving.Quantity, receiving.TransactionLogId);
                }
            }

            context.SaveChanges();
        }
Exemple #8
0
        static void Main(string[] args)
        {
            ItemRepository           itemRepo            = new ItemRepository();
            TransactionLogRepository transLogRepo        = new TransactionLogRepository();
            ItemAssignmentRepository itemAssignementRepo = new ItemAssignmentRepository();
            CNGDBContext             context             = new CNGDBContext();

            List <ItemDTO> lstItemDTO = new List <ItemDTO>();

            const Int32 BufferSize = 128;

            using (var fileStream = File.OpenRead(@"C:\fmt_inventory.csv"))
                using (var streamReader = new StreamReader(fileStream, Encoding.UTF8, true, BufferSize))
                {
                    String line;
                    int    lineCnt = 1;
                    while ((line = streamReader.ReadLine()) != null)
                    {
                        //if (lineCnt > 3)
                        //{
                        string[] strLine = line.Split(',');

                        //string itemCode = Convert.ToString(strLine[0]);
                        string itemDesc = Convert.ToString(strLine[0]);

                        //int n;
                        //bool isNumeric = int.TryParse(itemCode, out n);


                        Item item = new Item();
                        //item.Code = itemCode.PadLeft(3, '0');
                        item.Description      = Convert.ToString(strLine[0]);
                        item.TypeId           = 2;
                        item.ClassificationId = 1;
                        item.Brand            = "n/a";
                        item.UnitCost         = Convert.ToDecimal(strLine[2]);
                        item.Active           = true;

                        ItemDTO itemDTO = new ItemDTO();

                        itemDTO.item      = item;
                        itemDTO.Quantity  = Convert.ToInt32(strLine[1]);
                        itemDTO.CompanyId = 4;
                        itemDTO.UnitCost  = item.UnitCost;

                        lstItemDTO.Add(itemDTO);
                    }


                    lineCnt++;
                    //}
                }

            //foreach (ItemDTO _itemDTO in lstItemDTO)
            //{
            //   int itemid =  itemRepo.SaveByEncoder(_itemDTO.item);
            //    TransactionLog transLog = new TransactionLog
            //    {
            //        ItemId = itemid,
            //        CompanyId = _itemDTO.CompanyId,//cng
            //        TransactionMethodId = 7, //in
            //        Date = Convert.ToDateTime("01/01/17"),
            //        Quantity = _itemDTO.Quantity,
            //        UserId = 1 //admin
            //    };
            //    transLogRepo.Add(transLog);


            //    Console.WriteLine("Added " + _itemDTO.item.Code + " - " + _itemDTO.item.Description);
            //}



            List <ItemAssignment> lstItemAssignment = new List <ItemAssignment>();

            foreach (ItemDTO item in lstItemDTO)
            {
                int x = 0;

                if (item.item.Id == 0)
                {
                    x = itemRepo.GetItemId(item.item.Description);
                }
                else
                {
                    x = item.item.Id;
                }

                ItemAssignment itemAssignment = context.ItemAssignments.FirstOrDefault(p => p.ItemId == x && p.CompanyId == 4);

                itemAssignment.UnitCost = item.UnitCost;


                context.SaveChanges();

                //ItemAssignment itemAssignment = new ItemAssignment
                //{
                //    ItemId = x,
                //    CompanyId = item.CompanyId,
                //    UnitCost  = item.UnitCost//cng
                //};
                //lstItemAssignment.Add(itemAssignment);
            }

            //itemAssignementRepo.Save(lstItemAssignment);

            Console.WriteLine("Done!");

            Console.ReadLine();
        }
Exemple #9
0
 private LogService()
 {
     _context = new TurkcellFacebookDunyasiDb();
     _webServiceLogRepository  = new WebServiceLogRepository(_context);
     _transactionLogRepository = new TransactionLogRepository(_context);
 }