/// <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;
}
