/// <summary> /// This method is responsible for adding the newest record in the database /// into the GUI table. /// </summary> /// <param name="table">A Table Layout Panel you want to add a new record to.</param> /// <param name="rowIndex">The row index where you want to add the new record.</param> static public void addNewRecord(TableLayoutPanel table, int rowIndex) { // Gets latest sale record from the database SalesRecord record = SalesDatabase.GetNewestSalesRecord(); // Finds the corresponding Product Record for the SalesRecord ProductRecord pRecord = ProductDatabase.GetProductByProductID(record.ProductID); // Creates a new row in the table and updates the text in the cells table.Controls.Add(new Label() { Text = record.SaleID.ToString() }, 0, rowIndex); table.Controls.Add(new Label() { Text = pRecord.Name.ToString() }, 1, rowIndex); table.Controls.Add(new Label() { Text = record.DateSold.ToString() }, 2, rowIndex); table.Controls.Add(new Label() { Text = record.Quantity.ToString() }, 3, rowIndex); table.Controls.Add(new Label() { Text = "$" + (pRecord.Price * record.Quantity).ToString() }, 4, rowIndex); }
private void BtnSave_Click(object sender, EventArgs e) { int prodId = Int32.Parse(txtProductID.Text); int quan = Int32.Parse(txtQuantity.Text); SalesDatabase.NewSalesEntry(prodId, quan); Close(); }
private void BtnSave_Click(object sender, EventArgs e) { int saleId = saleRecord.SaleID; int prodId = Int32.Parse(txtProductID.Text); int quan = Int32.Parse(txtQuantity.Text); string dt = txtDateSold.Text; SalesDatabase.EditSalesRecord(saleId, prodId, quan, dt); Close(); }
private void Main_Load(object sender, EventArgs e) { List <SalesRecord> allSales = SalesDatabase.GetAllSales(); foreach (SalesRecord s in allSales) { GUIFunctions.addNewRecord(tlpDataRecords, rowIndex, s); rowIndex++; } foreach (Label l in tlpDataRecords.Controls) { l.MouseClick += new MouseEventHandler(selectRow); } }
public List <SalesReport> ReportList(DateTime startDate, DateTime endDate) { List <ProductRecord> products = ProductDatabase.GenerateAllProduct(); List <SalesReport> report = new List <SalesReport>(); foreach (ProductRecord record in products) { report.Add(new SalesReport() { ProductID = record.ProductID, Name = record.Name, Quantity = SalesDatabase.GenerateSalesAmount(record.ProductID, startDate, endDate), Price = record.Price, Total = Convert.ToDouble(SalesDatabase.GenerateSalesAmount(record.ProductID, startDate, endDate)) * record.Price }); } return(report); }
private void BtnEditRecord_Click(object sender, EventArgs e) { if (selectedRow == 0) { MessageBox.Show("Please select a sales record to edit first."); } else { using (EditSalesRecord editRecord = new EditSalesRecord()) { SalesRecord saleData = SalesDatabase.GetSalesRecordWithSaleID(Int32.Parse(tlpDataRecords.GetControlFromPosition(0, selectedRow).Text)); editRecord.SaleRecord = saleData; if (editRecord.ShowDialog() == DialogResult.OK) { saleData = SalesDatabase.GetSalesRecordWithSaleID(Int32.Parse(tlpDataRecords.GetControlFromPosition(0, selectedRow).Text)); ProductRecord pRecord = ProductDatabase.GetProductByProductID(saleData.ProductID); GUIFunctions.editRecord(tlpDataRecords, selectedRow, saleData, pRecord); } } } }