/// <summary> /// Function to populate the purchased item data grid /// </summary> private void PopulatePurchasedItemsDataGrid() { purchasedItemsDataGridView.DataSource = new List <Product>(); purchasedItemsDataGridView.Refresh(); #region Grid Formating // Hidding unnecessary fields purchasedItemsDataGridView.Columns["Key"].Visible = false; purchasedItemsDataGridView.Columns["Supplier"].Visible = false; purchasedItemsDataGridView.Columns["Category"].Visible = false; purchasedItemsDataGridView.Columns["Type"].Visible = false; purchasedItemsDataGridView.Columns["UnitCost"].Visible = false; purchasedItemsDataGridView.Columns["MinimumQuantity"].Visible = false; purchasedItemsDataGridView.Columns["MaximumQuantity"].Visible = false; purchasedItemsDataGridView.Columns["RegisteredBy"].Visible = false; purchasedItemsDataGridView.Columns["RegistrationDate"].Visible = false; purchasedItemsDataGridView.Columns["ModifiedBy"].Visible = false; purchasedItemsDataGridView.Columns["ModificationDate"].Visible = false; purchasedItemsDataGridView.Columns["Discontinued"].Visible = false; // Formating columns purchasedItemsDataGridView.Columns["Id"].Width = 60; purchasedItemsDataGridView.Columns["Name"].Width = 150; purchasedItemsDataGridView.Columns["Unit"].Width = 50; purchasedItemsDataGridView.Columns["UnitPrice"].Width = 80; purchasedItemsDataGridView.Columns["Brand"].Width = 70; purchasedItemsDataGridView.Columns["Quantity"].Width = 60; #endregion if (purchasedItems.Count == 0 && trigger) // requesting purchased items once to avoid reseting the list once changes have been made { purchasedItems = SaleInformationManager.ConsultTransactionContentInformation(sale.Id); } if (purchasedItems.Count > 0) { purchasedItemsDataGridView.DataSource = purchasedItems; purchasedItemsDataGridView.Refresh(); int quantity = 0; decimal total = 0; foreach (Product item in purchasedItems) { quantity += item.Quantity; // counting units of items total += item.Total; // calculating total of purchased items } numberOfPurchasedItemsLabel.Text = "# of Items: " + quantity.ToString(); purchasedTotalLabel.Text = "Total: $" + total.ToString("0.00"); } else { numberOfPurchasedItemsLabel.Text = "# of Items: 0"; purchasedTotalLabel.Text = "Total: $0.00"; } }
/// <summary> /// Function to populate the transaction content grid /// </summary> private void PopulateContentDataGrid() { contentDataGridView.DataSource = new List <Product>(); contentDataGridView.Refresh(); #region Grid Formating // Hidding unnecessary fields contentDataGridView.Columns["Key"].Visible = false; contentDataGridView.Columns["Supplier"].Visible = false; contentDataGridView.Columns["Category"].Visible = false; contentDataGridView.Columns["Type"].Visible = false; contentDataGridView.Columns["UnitCost"].Visible = false; contentDataGridView.Columns["MinimumQuantity"].Visible = false; contentDataGridView.Columns["MaximumQuantity"].Visible = false; contentDataGridView.Columns["RegisteredBy"].Visible = false; contentDataGridView.Columns["RegistrationDate"].Visible = false; contentDataGridView.Columns["ModifiedBy"].Visible = false; contentDataGridView.Columns["ModificationDate"].Visible = false; contentDataGridView.Columns["Discontinued"].Visible = false; // Formationg columns contentDataGridView.Columns["Id"].Width = 60; contentDataGridView.Columns["Name"].Width = 150; contentDataGridView.Columns["Unit"].Width = 50; contentDataGridView.Columns["UnitPrice"].Width = 80; contentDataGridView.Columns["Brand"].Width = 70; contentDataGridView.Columns["Quantity"].Width = 60; #endregion // Fetching purchased products associated with this transaction List <Product> content = SaleInformationManager.ConsultTransactionContentInformation(sale.Id); if (content.Count > 0) { contentDataGridView.DataSource = content; contentDataGridView.Refresh(); int quantity = 0; decimal total = 0; foreach (Product item in content) { quantity += item.Quantity; // counting how manu units of products were previously purchased in this transaction total += item.Total; // calculating total cost of transaction } numberOfItemsLabel.Text = "Number of Items: " + quantity.ToString(); totalLabel.Text = "Total: $" + total.ToString("0.00"); } else { numberOfItemsLabel.Text = "Number of Items: 0"; totalLabel.Text = "Total: $0.00"; } }
/// <summary> /// Funtion to populate the data grid /// </summary> private void PopulateSalesDataGrid() { salesList.DataSource = SaleInformationManager.ConsultSalesRecordsInformation(salesSearchBox.Text); // Formating the flieds salesList.Columns["Id"].Width = 50; salesList.Columns["TransactionDate"].Width = 180; salesList.Columns["Delivery"].Width = 50; salesList.Columns["Status"].Width = 70; salesList.Columns["Parent"].Width = 50; salesList.Columns["Child"].Width = 50; salesList.Columns["LastModified"].Width = 180; }
private void DisplaySelectedSalesContentDataGrid() { // Initializing the grid before any information has been requested salesContentDataGridView.DataSource = new List <Product>(); salesContentDataGridView.Refresh(); #region Grid Formating salesContentDataGridView.Columns["Key"].Visible = false; salesContentDataGridView.Columns["Supplier"].Visible = false; salesContentDataGridView.Columns["Category"].Visible = false; salesContentDataGridView.Columns["Type"].Visible = false; salesContentDataGridView.Columns["UnitCost"].Visible = false; salesContentDataGridView.Columns["MinimumQuantity"].Visible = false; salesContentDataGridView.Columns["MaximumQuantity"].Visible = false; salesContentDataGridView.Columns["RegisteredBy"].Visible = false; salesContentDataGridView.Columns["RegistrationDate"].Visible = false; salesContentDataGridView.Columns["ModifiedBy"].Visible = false; salesContentDataGridView.Columns["ModificationDate"].Visible = false; salesContentDataGridView.Columns["Discontinued"].Visible = false; // Formationg columns salesContentDataGridView.Columns["Id"].Width = 60; salesContentDataGridView.Columns["Name"].Width = 200; salesContentDataGridView.Columns["Unit"].Width = 50; salesContentDataGridView.Columns["UnitPrice"].Width = 80; salesContentDataGridView.Columns["Quantity"].Width = 60; salesContentDataGridView.Columns["Brand"].Width = 150; #endregion List <Product> content = new List <Product>(); // Requesting sales content information if at least one sale information is available if (salesDataGridView.Rows.Count > 0) { content = SaleInformationManager.ConsultTransactionContentInformation(salesDataGridView.SelectedCells[0].Value.ToString()); } // Staging requested information salesContentDataGridView.DataSource = content; salesContentDataGridView.Refresh(); // Counter Decimal total = 0; foreach (Product product in content) { total += product.Total; // Calculating the total dollar amount of the sale } // Displaying summary information totalLabel.Text = totalLabel.Text.Split('$')[0] + "$ " + total.ToString("0.00"); }
/// <summary> /// Function to display a transaction's information /// </summary> /// <param name="saleId">Identification number of the desired transaction</param> private void DisplayTransactionInformation(String saleId) { // Requesting transaction information sale = SaleInformationManager.ConsultTransactionInformationBySalesId(saleId); this.Text = "Sale Information: " + sale.Id; saleIdLabel.Text = sale.Id; saleDateLabel.Text = sale.TransactionDate.ToString(); soldByLabel.Text = sale.SoldBy; statusLabel.Text = sale.Status; deliveryCheckBox.Checked = sale.Delivery; parentIdLabel.Text = sale.Parent == "" ? "None" : sale.Parent; childIdLabel.Text = sale.Child == "" ? "None" : sale.Child; lastModifiedDateLabel.Text = sale.LastModified.ToString(); }
private void VoidSaleButton_Click(object sender, EventArgs e) { if (sale.Status == "Valid") // Confirming that the current transaction is valid { // Requesting to void the current transaction SaleInformationManager.UpdateTransactionStatusInformationToVoid(sale.Id); DisplayTransactionInformation(sale.Id); // Updating the sale's information FormsMenuList.salesRecordForm.RefreshSalesRecordsDataGrid(); // Notifying the parent to update its information MessageBox.Show("Transaction has been voided!"); } else { MessageBox.Show("This transaction has already been voided/returned"); } }
public ReturnItemsMiniForm(String saleId) { InitializeComponent(); sale = SaleInformationManager.ConsultTransactionInformationBySalesId(saleId); }