private void customerChartUpdate(cSBool c, Button b, string key) { string k; chart1.Series.Clear(); chart1.Series.Add("Series1"); //Just resets all look ups for car transactions to none-existent for (int i = 1; i < 21; i++) { k = "b" + i.ToString(); if (buts[k].b && k != key) { buts[k].button.BackColor = Color.Red; cSBool bb = buts[k]; bb.b = false; buts[k] = bb; } } if (buts[key].b) { c.button.BackColor = Color.Red; c.b = false; buts[key] = c; } else { c.button.BackColor = Color.Green; c.b = true; buts[key] = c; } }
private void carChartUpdate(cSBool c, Button b, string key) { string k; for (int i = 17; i < 21; i++) { k = "b" + i.ToString(); if (buts[k].b) { buts[k].button.BackColor = Color.Red; cSBool cb = buts[k]; cb.b = false; buts[k] = cb; } } if (buts[key].b) { b.BackColor = Color.Red; c.b = false; buts[key] = c; } else { b.BackColor = Color.Green; c.b = true; buts[key] = c; } this.updateChartCars(); }
public ChartsForm() { InitializeComponent(); // Define path and DataDirectory to access the database later string executable = System.Reflection.Assembly.GetExecutingAssembly().Location; string path = (System.IO.Path.GetDirectoryName(executable)); AppDomain.CurrentDomain.SetData("DataDirectory", path); label1.Text = "Start Date"; label2.Text = "End Date"; chart1.ChartAreas[0].AxisX.Minimum = 0; chart1.ChartAreas[0].AxisY.Minimum = 0; chart1.ChartAreas[0].AxisX.Maximum = 4; chart1.ChartAreas[0].AxisY.Maximum = 50; cSBool b1 = new cSBool(false, "colors", button1), b2 = new cSBool(false, "doors", button2), b3 = new cSBool(false, "style", button3), b4 = new cSBool(false, "age", button4), b5 = new cSBool(false, "sun_roof", button5), b6 = new cSBool(false, "fuelType", button6), b7 = new cSBool(false, "daily_price", button7), b8 = new cSBool(false, "weekly_price", button8), b9 = new cSBool(false, "monthly_price", button9), b10 = new cSBool(false, "heatedSeat", button10), b11 = new cSBool(false, "stereoQual", button11), b12 = new cSBool(false, "manual", button12), b13 = new cSBool(false, "cylinders", button13), b14 = new cSBool(false, "power_seats", button14), b15 = new cSBool(false, "bluetooth", button15), b16 = new cSBool(false, "model", button16), b17 = new cSBool(false, "pickup_branch_id", button17), b18 = new cSBool(false, "customer_id", button18), b19 = new cSBool(false, "car_id", button19), b20 = new cSBool(false, "employee_id", button20); b1.button.BackColor = Color.Red; b1.button.ForeColor = Color.White; b1.button.Text = "Colors"; b1.button.TabIndex = 1; buts.Add("b1", b1); b2.button.BackColor = Color.Red; b2.button.ForeColor = Color.White; b2.button.Text = "Doors"; b2.button.TabIndex = 2; buts.Add("b2", b2); b3.button.BackColor = Color.Red; b3.button.ForeColor = Color.White; b3.button.Text = "Style"; b3.button.TabIndex = 3; buts.Add("b3", b3); b4.button.BackColor = Color.Red; b4.button.ForeColor = Color.White; b4.button.Text = "Age"; b4.button.TabIndex = 4; buts.Add("b4", b4); b5.button.BackColor = Color.Red; b5.button.ForeColor = Color.White; b5.button.Text = "Sun Roof"; b5.button.TabIndex = 5; buts.Add("b5", b5); b6.button.BackColor = Color.Red; b6.button.ForeColor = Color.White; b6.button.Text = "Fuel type"; b6.button.TabIndex = 6; buts.Add("b6", b6); b7.button.BackColor = Color.Red; b7.button.ForeColor = Color.White; b7.button.Text = "Daily Prices"; b7.button.TabIndex = 7; buts.Add("b7", b7); b8.button.BackColor = Color.Red; b8.button.ForeColor = Color.White; b8.button.Text = "Weekly Prices"; b8.button.TabIndex = 8; buts.Add("b8", b8); b9.button.BackColor = Color.Red; b9.button.ForeColor = Color.White; b9.button.Text = "Monthly Prices"; b9.button.TabIndex = 9; buts.Add("b9", b9); b10.button.BackColor = Color.Red; b10.button.ForeColor = Color.White; b10.button.Text = "Heated Seats"; b10.button.TabIndex = 10; buts.Add("b10", b10); b11.button.BackColor = Color.Red; b11.button.ForeColor = Color.White; b11.button.Text = "Stereo Quality"; b11.button.TabIndex = 11; buts.Add("b11", b11); b12.button.BackColor = Color.Red; b12.button.ForeColor = Color.White; b12.button.Text = "Manual/Automatic"; b12.button.TabIndex = 12; buts.Add("b12", b12); b13.button.BackColor = Color.Red; b13.button.ForeColor = Color.White; b13.button.Text = "Cylinders in Engine"; b13.button.TabIndex = 13; buts.Add("b13", b13); b14.button.BackColor = Color.Red; b14.button.ForeColor = Color.White; b14.button.Text = "Power Seats"; b14.button.TabIndex = 14; buts.Add("b14", b14); b15.button.BackColor = Color.Red; b15.button.ForeColor = Color.White; b15.button.Text = "Blue Tooth"; b15.button.TabIndex = 15; buts.Add("b15", b15); b16.button.BackColor = Color.Red; b16.button.ForeColor = Color.White; b16.button.Text = "Models"; b16.button.TabIndex = 16; buts.Add("b16", b16); b17.button.BackColor = Color.Red; b17.button.ForeColor = Color.White; b17.button.Text = "Sales/Branch"; b17.button.TabIndex = 17; buts.Add("b17", b17); //Here we do groupby branch_id, count (*) with a select for both b18.button.BackColor = Color.Red; b18.button.ForeColor = Color.White; b18.button.Text = "Customers/Branch"; b18.button.TabIndex = 18; buts.Add("b18", b18); //Here we do group by branch_id, customer_id and then another groupby branch_id, count(*) for the number of unique customers b19.button.BackColor = Color.Red; b19.button.ForeColor = Color.White; b19.button.Text = "Cars/Branch"; b19.button.TabIndex = 19; buts.Add("b19", b19); //Here we do a simple if branch.branch_id = car.branch_id with select branch.name, count (*) b20.button.BackColor = Color.Red; b20.button.ForeColor = Color.White; b20.button.Text = "Employees/branch"; b20.button.TabIndex = 20; buts.Add("b20", b20); //Here we do branch.branch_id = employee.branch_id, SELECT branch.name, count(*) startDate = DateTime.Now; endDate = DateTime.Now; //This is to initialize the graph as reading everything. using (SqlConnection conn = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;" + "AttachDbFilename=|DataDirectory|Database1.mdf;" + "Integrated Security=True")) { conn.Open(); SqlCommand comm = new SqlCommand("SELECT count (*) from car_type", conn); int carInv = Convert.ToInt32(comm.ExecuteScalar()); comm = new SqlCommand("SELECT count (*) from rental", conn); int carRent = Convert.ToInt32(comm.ExecuteScalar()); chart1.Titles.Add("Total Cars"); chart1.Series["Series1"].Points.AddXY("Total Cars in Inventory", carInv.ToString()); //This is how you add both X and Y values simultaneously chart1.Series["Series1"].Points.AddXY("Total Cars rented", carRent.ToString()); chart1.AlignDataPointsByAxisLabel(); conn.Close(); } // Set the ComboBox to the first option by default tablesComboBox.SelectedIndex = 0; }