Question

Csharp question. Need it in 2 hours please

You will complete the C# program using Windows (Not Console).

The following table contains quarterly sales figures for five (5) departments:

	Quarter 1	Quarter 2	Quarter 3	Quarter 4	Total
Department 1	750	660	910	800
Department 2	800	700	950	900
Department 3	700	600	750	600
Department 4	850	800	1000	950
Department 5	900	800	960	980
Total

Design and write a Windows program/module named SalesAnalysis that will:

a. Declare a two-dimensional integer array named sales – (Note: you have 6 rows and 5 columns) - that will hold the 4 quarterly sales for 5 departments

b. Populate the first four columns for the 5 departments using the data in the preceding table.

c. Contain a loop to compute and populate the total column. Store each department’s total in the array as it is being computed.

d. Contain a loop to compute and populate the total row. Store each quarter’s total in the array as it is being computed.

e. Using a Procedure (sub program – Private or Public) format and display the table with both the row and column totals. Pass the array as an argument – ByVal.

Make sure to document and/or provide comments as much as you can. You will lose points if you have insufficient comments in the source code. Post any questions you may have on the discussion board.

Answer 1

//Create windows form project in visual studio

//to generate form_load method double click on Form

//Now Add data grid view component to your form

//Form design

//Edit DataGridView Columns using property

//This is C# code

using System;
using System.Collections.Generic;

using System.Windows.Forms;

namespace Sales_Analysis
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
/*a two-dimensional integer array
* named sales – (Note: you have 6 rows and 5 columns) - that will hold the 4
* quarterly sales for 5 departments*/
int[,] sales = new int[6,5];//six rows and 5 columns
//populate array with values given
//First Row
sales[0, 0] = 750;
sales[0, 1] = 660;
sales[0, 2] = 910;
sales[0, 3] = 800;
//second row
sales[1, 0] = 800;
sales[1, 1] = 700;
sales[1, 2] = 950;
sales[1, 3] = 900;
//Third row
sales[2, 0] = 700;
sales[2, 1] = 600;
sales[2, 2] = 750;
sales[2, 3] = 600;
//Forth row
sales[3, 0] = 850;
sales[3, 1] = 800;
sales[3, 2] = 1000;
sales[3, 3] = 950;
//fifth row
sales[4, 0] = 900;
sales[4, 1] = 800;
sales[4, 2] = 960;
sales[4, 3] = 980;

//loops to calculate total column wise
int i, j;
//loop for rows
for(i=0;i<sales.GetLength(0)-1;i++)
{
int colTotal = 0;//to hold col total
//loop for cols
for(j=0;j<sales.GetLength(1)-1;j++)
{
//add total
colTotal = colTotal + sales[i, j];

}
//seeds total to sales array of total cols
sales[i, 4] = colTotal;
}

//loop to calculate total row wise
//loop for cols
for (i = 0; i < sales.GetLength(1) ; i++)
{
int rowTotal = 0;//to hold the total row wise
//loop for rows
for (j = 0; j < sales.GetLength(0)-1 ; j++)
{
//add total
rowTotal = rowTotal + sales[j, i];

}
//seeds total to sales array of total rows
sales[5, i] = rowTotal;
}

//call display function
display(sales);
  

}
//Parameters in C# are, by default passed by value
public void display( int[,] sales )
{
//populate data gridview with values
for (int i = 0; i < sales.GetLength(0); i++)
{
//To hold the Rows
string[] row = new string[sales.GetLength(1)];
for (int j = 0; j < sales.GetLength(1) ; j++)
{
//add the Values to rows after casting it to String
row[j] = sales[i, j].ToString();

}
//add row to DataGridView Rows
dataGridView1.Rows.Add(row);
}

}
}
}

//output

//if you need any help regarding this solution ............ please leave a comment ............ thanks