/// <summary> /// Function to update the sales records data grid /// </summary> private void UpdateSalesRecordsDataGrid() { // Initializing the grid before information is fetched salesRecordsDataGridView.DataSource = new List <SalesRecord>(); salesRecordsDataGridView.Refresh(); // Requesting sales information List <SalesRecord> salesRecords = ReportInformationManager.ConsultUsersSalesRecordsInformation(oldestSalesRecordDateTimePicker.Value, newestSalesRecordDateTimePicker.Value); // Staging the requested information salesRecordsDataGridView.DataSource = salesRecords; salesRecordsDataGridView.Refresh(); // Counters int sales = 0; Decimal salesTotal = 0; int returns = 0; Decimal returnsTotal = 0; foreach (SalesRecord record in salesRecords) { sales += record.Sales; // adding the number of sales for the current record salesTotal += record.SalesTotal; // adding the total dollar amount of sales for the current record returns += record.Returns; // adding the number of returns of the current record returnsTotal += record.ReturnsTotal; // adding the total dollar amount of returns fot the current record } // Publishing the records summary numberOfSalesLabel.Text = numberOfSalesLabel.Text.Split(':')[0] + ": " + sales; salesTotalLabel.Text = salesTotalLabel.Text.Split('$')[0] + "$ " + salesTotal.ToString("0.00"); numberOfReturnsLabel.Text = numberOfReturnsLabel.Text.Split(':')[0] + ": " + returns; returnsTotalLabel.Text = returnsTotalLabel.Text.Split('$')[0] + "$ " + returnsTotal.ToString("0.00"); }
/// <summary> /// Funtion to update the timesheet data grid /// </summary> private void UpdateTimesheetDataGrid() { timeSheetDataGridView.DataSource = ReportInformationManager.ConsultTimesheetSummaryInformation(newestTimesheetDateTimePicker.Value, oldestTimesheetDateTimePicker.Value); timeSheetDataGridView.Columns["AverageMinutesPerSession"].Width = 150; timeSheetDataGridView.Columns["FullName"].Width = 150; }
/// <summary> /// Function to fetch and display the target user's session log /// </summary> private void PopulateSessionLogDataGrid() { // Requesting information sessionsDataGridView.DataSource = ReportInformationManager.ConsultUserSessionLogInformation(user.Username, oldestDateTimePicker.Value, newestDateTimePicker.Value); // Formating grid sessionsDataGridView.Columns["LogIn"].Width = 170; sessionsDataGridView.Columns["LogOut"].Width = 170; sessionsDataGridView.Columns["TotalSessionMinutes"].Width = 150; }
/// <summary> /// Function to display all activities complete during a selected session /// </summary> private void DisplaySelectedSessionActivities() { // Initializing grid before any information is requested activitiesDataGridView.DataSource = new List <Activity>(); activitiesDataGridView.Refresh(); // Formating grid activitiesDataGridView.Columns["Username"].Visible = false; activitiesDataGridView.Columns["Description"].Width = 300; activitiesDataGridView.Columns["Type"].Width = 200; activitiesDataGridView.Columns["Timestamp"].Width = 200; List <Activity> activities = new List <Activity>(); // TODO: Take into account warnings // Requesting supplementary information once at least one session information is available if (sessionsDataGridView.RowCount > 0) { activities = ReportInformationManager.ConsultUserActivitiesDuringSessionInformation(user.Username, DateTime.Parse(sessionsDataGridView.SelectedCells[0].Value.ToString()), DateTime.Parse(sessionsDataGridView.SelectedCells[1].Value.ToString())); } // Staging supplementary information after successful request activitiesDataGridView.DataSource = activities; activitiesDataGridView.Refresh(); // Counters int errorCounter = 0; int salesCounter = 0; int returnsCounter = 0; foreach (Activity activity in activities) { if (activity.Type == "ERROR") { errorCounter++; } if (activity.Type == "NEW TRANSACTION") { salesCounter++; } if (activity.Type == "RETURN TRANSACTION") { returnsCounter++; } } // Displaying summary information totalLabel.Text = totalLabel.Text.Split(':')[0] + ": " + activities.Count; errorsLabel.Text = errorsLabel.Text.Split(':')[0] + ": " + errorCounter; salesLabel.Text = salesLabel.Text.Split(':')[0] + ": " + (salesCounter - returnsCounter); // only counts sales that have not originated from returns returnsLabel.Text = returnsLabel.Text.Split(':')[0] + ": " + returnsCounter; }
private void PopulateSalesDataGrid() { // Requesting the target user's sales history for the given time frame salesDataGridView.DataSource = ReportInformationManager.ConsultSalesMadeByUserInformation(user.Username, oldestDateTimePicker.Value, newestDateTimePicker.Value); // Hiding unnecessary fields salesDataGridView.Columns["Delivery"].Visible = false; salesDataGridView.Columns["Status"].Visible = false; salesDataGridView.Columns["Child"].Visible = false; salesDataGridView.Columns["LastModified"].Visible = false; salesDataGridView.Columns["SoldBy"].Visible = false; }