Example #1
0
        /// <summary>
        /// Method to calculate the sales, record transaction, print receipt, and backup files
        /// </summary>
        void GenerateEndOfDaySalesReport()
        {
            EndOfSalesType = "Z";
            _pos.GetNextCorteZNumber();
            //Calculate sales and print receipts
            if (master)
            {
                //Regular
                CalculateSales(true);
                //Record End Of Sales Transaction in db
                Transaction.RecordEndOfDaySalesTransaction(Constants.DataFolderPath + Constants.EndOfDaySalesFileName,
                                                           _pos.LastCorteZNumber, TransactionData.FirstReceiptNumber, TransactionData.LastReceiptNumber, TransactionData.TotalItemsSold,
                                                           TransactionData.PointsTotal, TransactionData.CashTotal, TransactionData.CardTotal, TransactionData.CheckTotal,
                                                           TransactionData.BankTotal, TransactionData.OtherTotal, TransactionData.TotalAmountSold, TransactionData.ReturnsCash,
                                                           TransactionData.ReturnsCard, _pos.ExchangeRate, DateTime.Now.ToString(CultureInfo.CurrentCulture));
                //Print Receipt
                PrintReceipt(ReceiptType.DailyRegular, false);

                CalculateSales(true, true);
                //Record End Of Sales Transaction in db
                Transaction.RecordEndOfDaySalesTransaction(Constants.DataFolderPath + Constants.MasterEndOfDaySalesFileName,
                                                           _pos.LastCorteZNumber, TransactionData.FirstReceiptNumber, TransactionData.LastReceiptNumber, TransactionData.TotalItemsSold,
                                                           TransactionData.PointsTotal, TransactionData.CashTotal, TransactionData.CardTotal, TransactionData.CheckTotal,
                                                           TransactionData.BankTotal, TransactionData.OtherTotal, TransactionData.TotalAmountSold, TransactionData.ReturnsCash,
                                                           TransactionData.ReturnsCard, _pos.ExchangeRate, DateTime.Now.ToString(CultureInfo.CurrentCulture));
                //Print Receipt
                PrintReceipt(ReceiptType.DailyInternal, false);
            }
            else
            {
                CalculateSales(true);
                CalculateDelta();
                CollectEndOfSalesReceiptInformation();
                //Record End Of Sales Transaction in db
                Transaction.RecordEndOfDaySalesTransaction(Constants.DataFolderPath + Constants.EndOfDaySalesFileName,
                                                           _pos.LastCorteZNumber, TransactionData.FirstReceiptNumber, TransactionData.LastReceiptNumber, TransactionData.TotalItemsSold,
                                                           TransactionData.PointsTotal, TransactionData.CashTotal, TransactionData.CardTotal, TransactionData.CheckTotal,
                                                           TransactionData.BankTotal, TransactionData.OtherTotal, TransactionData.TotalAmountSold, TransactionData.ReturnsCash,
                                                           TransactionData.ReturnsCard, _pos.ExchangeRate, DateTime.Now.ToString(CultureInfo.CurrentCulture));
                //Print Full Detailed Receipt
                PrintReceipt(ReceiptType.DailyRegular, false);
            }

            //BackUp Z Files and Clear
            Transaction.BackUpTransactionFile(Constants.DataFolderPath + Constants.TransactionsZFileName, true);
            //Transaction.BackUpTransactionMasterFile(Constants.DataFolderPath + Constants.TransactionsMasterFileName);
            Transaction.ClearTransactionFile(Constants.DataFolderPath + Constants.TransactionsZFileName);
            //Transaction.ClearTransactionMasterFile(Constants.DataFolderPath + Constants.TransactionsMasterFileName);
            FileIO.FileBackUp(Constants.DataFolderPath + Constants.InventoryFileName, Constants.DataFolderPath + Constants.InventoryBackupFolderPath);
            //Inventory.InventoryBackUp(Constants.DataFolderPath + Constants.InventoryFileName);
            //BackUp Z Expenses files
            Expense.BackUpExpensesFile(Constants.DataFolderPath + Constants.ExpenseZFileName, true);
            Expense.ClearExpensesFile(Constants.DataFolderPath + Constants.ExpenseZFileName);
            //Backup Z Paymenets Files
            Transaction.BackUpPaymentsFile(Constants.DataFolderPath + Constants.TransactionsPaymentsZFileName, true);
            Transaction.ClearPaymentsFile(Constants.DataFolderPath + Constants.TransactionsPaymentsZFileName);

            //Update POS Data
            //           _pos.LastReceiptNumber = TransactionData.LastReceiptNumber;
            //           _pos.LastTransactionNumber = TransactionData.LastTransactionNumber;
            //          _pos.LastCashierAmountMxn = RegisterNewCash;
            //        _pos.UpdateAllData();
            //      _pos.SaveDataTableToCsv();
        }
Example #2
0
        public List <Expense> Search(string searchInput)
        {
            var expenses = new List <Expense>();

            //Return empty list if invalid inputs are entered for the search
            if (string.IsNullOrWhiteSpace(searchInput) || searchInput == "x")
            {
                return(expenses);
            }

            if (searchInput == "*")
            {
                var allFields = base.DataTable.AsEnumerable();
                foreach (var row in allFields)
                {
                    var expense = new Expense(ExpensesXFilePath, ExpensesZFilePath, ExpensesHistoryFilePath)
                    {
                        Id              = Int32.Parse(row["Id"].ToString()),
                        User            = row["Usuario"].ToString(),
                        Vendor          = row["Proveedor"].ToString(),
                        TicketNumber    = row["NumeroTicket"].ToString(),
                        Description     = row["Descripcion"].ToString(),
                        Amount          = Decimal.Parse(row["Monto"].ToString()),
                        ExpenseCategory = row["CategoriaGasto"].ToString(),
                        Date            = Convert.ToDateTime(row["Fecha"].ToString())
                    };
                    if (row["Moneda"].ToString().ToUpper() == "USD")
                    {
                        expense.CurrencyType = CurrencyTypeEnum.USD;
                    }
                    else
                    {
                        expense.CurrencyType = CurrencyTypeEnum.MXN;
                    }

                    expense.PaymentType = (PaymentTypeEnum)Enum.Parse(typeof(PaymentTypeEnum), row["MetodoPago"].ToString(), true);

                    expenses.Add(expense);
                }
                return(expenses);
            }

            var searchField1 = DataTable.AsEnumerable().Where(r => r.Field <string>("CategoriaGasto").ToLower().Contains(searchInput));
            var searchField2 = DataTable.AsEnumerable().Where(r => r.Field <string>("Proveedor").ToLower().Contains(searchInput));

            foreach (var row in searchField1)
            {
                var expense = new Expense(ExpensesXFilePath, ExpensesZFilePath, ExpensesHistoryFilePath)
                {
                    Id              = Int32.Parse(row["Usuario"].ToString()),
                    User            = row["Usuario"].ToString(),
                    Vendor          = row["Proveedor"].ToString(),
                    TicketNumber    = row["NumeroTicket"].ToString(),
                    Description     = row["Descripcion"].ToString(),
                    Amount          = Decimal.Parse(row["Monto"].ToString()),
                    ExpenseCategory = row["CategoriaGasto"].ToString(),
                    Date            = Convert.ToDateTime(row["Fecha"].ToString())
                };
                if (row["Moneda"].ToString().ToUpper() == "USD")
                {
                    expense.CurrencyType = CurrencyTypeEnum.USD;
                }
                else
                {
                    expense.CurrencyType = CurrencyTypeEnum.MXN;
                }

                expense.PaymentType = (PaymentTypeEnum)Enum.Parse(typeof(PaymentTypeEnum), row["MetodoPago"].ToString(), true);

                expenses.Add(expense);
            }

            foreach (var row in searchField2)
            {
                var expense = new Expense(ExpensesXFilePath, ExpensesZFilePath, ExpensesHistoryFilePath)
                {
                    Id              = Int32.Parse(row["Usuario"].ToString()),
                    User            = row["Usuario"].ToString(),
                    Vendor          = row["Proveedor"].ToString(),
                    TicketNumber    = row["NumeroTicket"].ToString(),
                    Description     = row["Descripcion"].ToString(),
                    Amount          = Decimal.Parse(row["Monto"].ToString()),
                    ExpenseCategory = row["CategoriaGasto"].ToString(),
                    Date            = Convert.ToDateTime(row["Fecha"].ToString())
                };
                if (row["Moneda"].ToString().ToUpper() == "USD")
                {
                    expense.CurrencyType = CurrencyTypeEnum.USD;
                }
                else
                {
                    expense.CurrencyType = CurrencyTypeEnum.MXN;
                }

                expense.PaymentType = (PaymentTypeEnum)Enum.Parse(typeof(PaymentTypeEnum), row["MetodoPago"].ToString(), true);

                //Add if it does not exist already
                if (!expenses.Exists(x => x.Id == expense.Id))
                {
                    expenses.Add(expense);
                }
            }

            return(expenses);
        }