/// <summary>
        ///     Processes the parameters.
        /// </summary>
        public override void processParentIntention()
        {
            this.transaction = (ParentParameter as PurchaseTransactionUC)?.SelectedTransaction;
            this.loadItems();


        }
        /// <summary>
        /// Gets all items by purchase transaction.
        /// </summary>
        /// <param name="transaction">The transaction.</param>
        /// <returns>
        /// The purchase transaction's items.
        /// </returns>
        public IList<PurchaseTransaction_Item> GetAllItemsByPurchaseTransaction(PurchaseTransaction transaction)
        {
            if (transaction == null)
            {
                throw new ArgumentNullException();
            }

            return this.itemRepository.GetAllItemsByPurchaseTransaction(transaction);
        }
Esempio n. 3
0
        /// <summary>
        /// Adds the purchase transaction.
        /// </summary>
        /// <param name="transaction">The transaction.</param>
        public void AddPurchaseTransaction(PurchaseTransaction transaction)
        {
            
            var id = this.purchaseRepository.AddOne(transaction);
            transaction.Id = id;

            try
            {
                foreach (var item in transaction.Items)
                {
                    item.PurchaseTransactionId = id;
                }

                this.purchaseItemRepository.AddList(transaction.Items);
            }
            catch (Exception)
            {
                this.deleteChangesFromDatabase(transaction.Items, id);

                throw;
            }
        }
        /// <summary>
        /// Adds one item to the database.
        /// </summary>
        /// <param name="item">The item.</param>
        /// <returns></returns>
        /// <exception cref="ArgumentNullException"></exception>
        public string AddOne(PurchaseTransaction item)
        {
            if (item == null)
            {
                throw new ArgumentNullException();
            }

            var id = string.Empty;

            const string statement = "INSERT INTO PurchaseTransaction (transactionTime, Customer_id, Employee_id)" +
                                     " VALUES (@TransactionTime, @CustomerId, @EmployeeId)";

            var connection = new MySqlConnection(this.CONNECTION_STRING);

            using (var command = new MySqlCommand(statement))
            {
                command.Parameters.AddWithValue("@TransactionTime", item.TransactionTime);
                command.Parameters.AddWithValue("@CustomerId", item.CustomerId);
                command.Parameters.AddWithValue("@EmployeeId", item.EmployeeId);

                command.Connection = connection;

                try
                {
                    command.Connection.Open();
                    command.ExecuteNonQuery();
                    id = command.LastInsertedId.ToString();
                }
                finally
                {
                    command.Connection.Close();
                }
            }

            return id;
        }
        /// <summary>
        /// Gets the item from the database by identifier.
        /// </summary>
        /// <param name="id">The identifier.</param>
        /// <returns></returns>
        /// <exception cref="NotImplementedException"></exception>
        public PurchaseTransaction GetById(string id)
        {
            const string query = "SELECT * " + 
                                 "FROM PurchaseTransaction " +
                                 "WHERE id = @id";

            var connection = new MySqlConnection(this.CONNECTION_STRING);

            var transaction = new PurchaseTransaction();

            using (var command = new MySqlCommand(query))
            {
                command.Connection = connection;

                command.Parameters.AddWithValue("@id", id);

                try
                {
                    command.Connection.Open();

                    var reader = command.ExecuteReader();

                    while (reader.Read())
                    {
                        
                        transaction.Id = ((int)reader["id"]).ToString();
                        transaction.TransactionTime = reader["transactionTime"] == DBNull.Value
                            ? DateTime.MinValue
                            : reader["transactionTime"] as DateTime? ?? DateTime.MinValue;
                        transaction.CustomerId = reader["Customer_id"] == DBNull.Value ? "0" : ((int) reader["Customer_id"]).ToString();
                        transaction.EmployeeId = reader["Employee_id"] == DBNull.Value ? "0" : ((int)reader["Employee_id"]).ToString();

                    }
                }
                finally
                {
                    command.Connection.Close();
                }
            }

            return transaction;
        }
        /// <summary>
        /// Gets the transactions by customer identifier.
        /// </summary>
        /// <param name="id">The identifier.</param>
        /// <returns></returns>
        public IList<PurchaseTransaction> GetTransactionsByCustomerId(string id)
        {
            if (string.IsNullOrEmpty(id))
            {
                throw new ArgumentNullException(nameof(id));
            }


            var purchaseTransactions = new List<PurchaseTransaction>();

            const string query = "SELECT * FROM PurchaseTransaction WHERE Customer_id = @id";

            var connection = new MySqlConnection(this.CONNECTION_STRING);

            using (var command = new MySqlCommand(query))
            {
                command.Connection = connection;
                command.Parameters.AddWithValue("@id", id);

                try
                {
                    command.Connection.Open();

                    var reader = command.ExecuteReader();

                    while (reader.Read())
                    {

                        var theTransaction = new PurchaseTransaction
                        {
                            Id = reader["id"].ToString(),
                            TransactionTime = reader["transactionTime"] as DateTime? ?? DateTime.MinValue,
                            CustomerId = reader["Customer_id"] == DBNull.Value ? "NULL" : reader["Customer_id"].ToString(),
                            EmployeeId = reader["Employee_id"] as string ?? string.Empty,
                        };


                        purchaseTransactions.Add(theTransaction);
                    }
                }
                finally
                {
                    command.Connection.Close();
                }
            }

            return purchaseTransactions;
        }
 /// <summary>
 /// Updates the item by identifier.
 /// </summary>
 /// <param name="item">The item.</param>
 public void UpdateById(PurchaseTransaction item)
 {
     throw new NotImplementedException();
 }
 /// <summary>
 /// Deletes the specified item from the database.
 /// </summary>
 /// <param name="item">The item.</param>
 /// <exception cref="NotImplementedException"></exception>
 public void Delete(PurchaseTransaction item)
 {
     throw new NotImplementedException();
 }
        /// <summary>
        /// Gets all items by purchase transaction.
        /// </summary>
        /// <param name="transaction">The transaction.</param>
        /// <returns></returns>
        /// <exception cref="NotImplementedException"></exception>
        public IList<PurchaseTransaction_Item> GetAllItemsByPurchaseTransaction(PurchaseTransaction transaction)
        {
            if (transaction == null)
            {
                throw new ArgumentNullException();
            }

            var items = new List<PurchaseTransaction_Item>();

            var query = "SELECT PurchaseTransaction_Item.*, Furniture.name AS FurnitureName, ReturnTransaction_Item.ReturnTransaction_id, SUM(ReturnTransaction_Item.quantity) AS ReturnedQuantity " +
                        "FROM PurchaseTransaction_Item " +
                        "INNER JOIN Furniture " +
                        "ON PurchaseTransaction_Item.Furniture_id=Furniture.id " +
                        "LEFT JOIN ReturnTransaction_Item " +
                        "ON PurchaseTransaction_Item.PurchaseTransaction_id=ReturnTransaction_Item.PurchaseTransaction_Item_PurchaseTransaction_id AND PurchaseTransaction_Item.Furniture_id = ReturnTransaction_Item.PurchaseTransaction_Item_Furniture_id " +
                        "WHERE PurchaseTransaction_id=@Id " +
                        "GROUP BY PurchaseTransaction_Item.Furniture_id, PurchaseTransaction_Item.PurchaseTransaction_id";

            var connection = new MySqlConnection(this.CONNECTION_STRING);

            using (var command = new MySqlCommand(query))
            {
                command.Parameters.AddWithValue("@Id", transaction.Id);

                command.Connection = connection;

                try
                {
                    command.Connection.Open();

                    var reader = command.ExecuteReader();

                    while (reader.Read())
                    {
                        var item = new PurchaseTransaction_Item
                        {
                            PurchaseTransactionId = transaction.Id,
                            FurnitureId =
                                reader["Furniture_id"] == DBNull.Value ? "NULL" : reader["Furniture_id"].ToString(),
                            Quantity = reader["quantity"] == DBNull.Value ? 0 : (int) reader["quantity"],
                            LeaseTime = reader["leaseTime"] == DBNull.Value ? 0 : (int) reader["leaseTime"],
                            FurnitureName = reader["FurnitureName"] == DBNull.Value ? "NULL" : reader["FurnitureName"].ToString()
                        };

                        var returnedQuantity = reader["ReturnedQuantity"] == DBNull.Value ? 0: Int32.Parse(reader["ReturnedQuantity"].ToString());


                        if (reader["ReturnTransaction_id"] != DBNull.Value)
                        {
                            item.ReturnableQuantity = item.Quantity - returnedQuantity;
                        }
                        else
                        {
                            item.ReturnableQuantity = item.Quantity;
                        }

                        items.Add(item);
                    }

                }
                finally
                {
                    command.Connection.Close();
                }
            }

            return items;
        }
Esempio n. 10
0
        private void submitTransactionButton_Click(object sender, EventArgs e)
        {
            if (this.itemsToPurchase.Count == 0)
            {
                ErrorHandler.DisplayErrorBox("Error", "Cannot submit an empty transaction.");
                return;
            }

            if (this.customerID == "null")
            {
                ErrorHandler.DisplayErrorBox("Error", "Must select a customer.");
                return;
            }

            try
            {
                var theController = new TransactionController();
                var furnitureController = new FurnitureController();

                var transaction = new PurchaseTransaction
                {
                    TransactionTime = DateTime.Now,
                    CustomerId = this.customerID,
                    EmployeeId = this.session.Id.ToString(),
                    Items = new List<PurchaseTransaction_Item>(this.itemsToPurchase)
                };


                theController.AddPurchaseTransaction(transaction);

                furnitureController.UpdateQuantitiesByIds(transaction.Items);
                MessageBox.Show(this.itemsToPurchase.Count + @" item(s) were purchased for a total of " + this.totalPriceLabel.Text + ".", @"Transaction Successful",
                    MessageBoxButtons.OK, MessageBoxIcon.None, MessageBoxDefaultButton.Button1);
                this.clearTransaction();
            }
            catch (NullReferenceException nullReference)
            {
                ErrorHandler.DisplayErrorMessageToUserAndLog("Session Error", "The login session is null.", nullReference);
            }
            catch (InvalidCastException invalidCast)
            {
                ErrorHandler.DisplayErrorMessageToUserAndLog("Session Error", "The tag cannot be cast as a login session.", invalidCast);
            }
            catch (MySqlException sqlException)
            {
                ErrorHandler.DisplayErrorMessageToUserAndLog("SQL Error",
                    "The transaction could not be added to the database.", sqlException);
            }
            catch (ArgumentOutOfRangeException rangeException)
            {
                ErrorHandler.DisplayErrorMessageToUserAndLog("Quantity Error",
                    rangeException.Message, rangeException);
            }
        }