private void dashBoardClicked(object sender, EventArgs e)
{
this.groupBox3.Visible = true;
this.groupBox4.Visible = true;
this.groupBox5.Visible = true;
//get all the data
// count the total order in groupBox3
OrderRepository or = new OrderRepository();
this.totalOrderLabel.Text = "Total Order : " + Convert.ToString(or.countAllOrder());
this.totalBikeLabel.Text = "Bike : " + Convert.ToString(or.countOrder("Bike"));
this.totalCarLabel.Text = "Car : " + Convert.ToString(or.countOrder("Car"));
this.totalAutoLabel.Text = "Cng : " + Convert.ToString(or.countOrder("Cng"));
this.totalMicroLabel.Text = "Microbus : " + Convert.ToString(or.countOrder("Microbus"));
this.totalPickupLabel.Text = "Pickup : " + Convert.ToString(or.countOrder("Pickup"));
this.totalTruckLabel.Text = "Truck : " + Convert.ToString(or.countOrder("Truck"));
//count the total Inventory in groupBox4
InventoryRepository ir = new InventoryRepository();
this.totalInventoryLabel.Text = "Total Inventory : " + Convert.ToString(ir.countAllInventory());
this.totalBikeILabel.Text = "Bike :" + Convert.ToString(ir.countInventory("Bike"));
this.totalCarILabel.Text = "Car :" + Convert.ToString(ir.countInventory("Car"));
this.totalAutoILabel.Text = "Cng :" + Convert.ToString(ir.countInventory("Cng"));
this.totalMicroILabel.Text = "Microbus :" + Convert.ToString(ir.countInventory("Microbus"));
this.totalPickupILabel.Text = "Pickup :" + Convert.ToString(ir.countInventory("Pickup"));
this.totalTruckILabel.Text = "Truck :" + Convert.ToString(ir.countInventory("Truck"));
//count all shipment
ShipmentRepository sr = new ShipmentRepository();
this.totalShipmentLabel.Text = "Total Shipment : " + Convert.ToString(sr.countAllShipment());
this.atOriginLabel.Text = "At Origin : " + Convert.ToString(sr.countShipment("At Origin"));
this.onTheWayLabel.Text = "On the Way : " + Convert.ToString(sr.countShipment("On the Way"));
this.stuckedLabel.Text = "Stucked : " + Convert.ToString(sr.countShipment("Stuked"));
this.atDestinationLabel.Text = "At Destination : " + Convert.ToString(sr.countShipment("At Destination"));
this.shippedLabel.Text = "Shipped : " + Convert.ToString(sr.countShipment("Shipped"));
this.dataGrid2.Visible = false;
this.dataGrid3.Visible = false;
this.dataGrid4.Visible = false;
this.groupBox1.Visible = false;
this.groupBox2.Visible = false;
}
public Sales()
{
InitializeComponent();
this.dataGrid2.Visible = false;
this.dataGrid3.Visible = false;
this.dataGrid4.Visible = false;
this.groupBox1.Visible = false;
this.groupBox2.Visible = false;
//dashBoard text
this.groupBox3.Visible = true;
this.groupBox4.Visible = true;
this.groupBox5.Visible = true;
// init the ID from inventory table in this combobox
InventoryRepository m = new InventoryRepository();
List <string> allId = m.GetAllId();
foreach (string id in allId)
{
this.comboBox1.Items.Add(id);
}
OrderRepository or = new OrderRepository();
this.totalOrderLabel.Text = "Total Order : " + Convert.ToString(or.countAllOrder());
this.totalBikeLabel.Text = "Bike : " + Convert.ToString(or.countOrder("Bike"));
this.totalCarLabel.Text = "Car : " + Convert.ToString(or.countOrder("Car"));
this.totalAutoLabel.Text = "Cng : " + Convert.ToString(or.countOrder("Cng"));
this.totalMicroLabel.Text = "Microbus : " + Convert.ToString(or.countOrder("Microbus"));
this.totalPickupLabel.Text = "Pickup : " + Convert.ToString(or.countOrder("Pickup"));
this.totalTruckLabel.Text = "Truck : " + Convert.ToString(or.countOrder("Truck"));
//count the total Inventory in groupBox4
InventoryRepository ir = new InventoryRepository();
this.totalInventoryLabel.Text = "Total Inventory : " + Convert.ToString(ir.countAllInventory());
this.totalBikeILabel.Text = "Bike :" + Convert.ToString(ir.countInventory("Bike"));
this.totalCarILabel.Text = "Car :" + Convert.ToString(ir.countInventory("Car"));
this.totalAutoILabel.Text = "Cng :" + Convert.ToString(ir.countInventory("Cng"));
this.totalMicroILabel.Text = "Microbus :" + Convert.ToString(ir.countInventory("Microbus"));
this.totalPickupILabel.Text = "Pickup :" + Convert.ToString(ir.countInventory("Pickup"));
this.totalTruckILabel.Text = "Truck :" + Convert.ToString(ir.countInventory("Truck"));
//count all shipment
ShipmentRepository sr = new ShipmentRepository();
this.totalShipmentLabel.Text = "Total Shipment : " + Convert.ToString(sr.countAllShipment());
this.atOriginLabel.Text = "At Origin : " + Convert.ToString(sr.countShipment("At Origin"));
this.onTheWayLabel.Text = "On the Way : " + Convert.ToString(sr.countShipment("On the Way"));
this.stuckedLabel.Text = "Stucked : " + Convert.ToString(sr.countShipment("Stuked"));
this.atDestinationLabel.Text = "At Destination : " + Convert.ToString(sr.countShipment("At Destination"));
this.shippedLabel.Text = "Shipped : " + Convert.ToString(sr.countShipment("Shipped"));
}
public AdminDashboard()
{
InitializeComponent();
//marketing Info
MarketingRepository mr = new MarketingRepository();
this.totalCampaigns.Text = "Total Campaigns : " + Convert.ToString(mr.countAllCampaigns());
this.appCampaign.Text = "Approved Campaigns : " + Convert.ToString(mr.countAllApprovedCampaigns("Approved"));
//Hr Info
EmployeeRepository m = new EmployeeRepository();
this.label123.Text += Convert.ToString(m.countAllEmployee());
this.label129.Text += Convert.ToString(m.countEmployee("Admin"));
this.label125.Text += Convert.ToString(m.countEmployee("Sales"));
this.label127.Text += Convert.ToString(m.countEmployee("Marketing"));
this.label124.Text += Convert.ToString(m.countEmployee("Human Resource"));
this.label126.Text += Convert.ToString(m.countEmployee("Accounting"));
this.label128.Text += Convert.ToString(m.countEmployee("Finance"));
this.label120.Text += Convert.ToString(m.countAllStatus("Full Time"));
this.label119.Text += Convert.ToString(m.countAllStatus("Probationary"));
this.label118.Text += Convert.ToString(m.countAllStatus("Intern"));
//sales Info
//get all the data
// count the total order in groupBox3
OrderRepository or = new OrderRepository();
this.label117.Text = "Total Order : " + Convert.ToString(or.countAllOrder());
this.label114.Text = "Bike : " + Convert.ToString(or.countOrder("Bike"));
this.label108.Text = "Car : " + Convert.ToString(or.countOrder("Car"));
this.label111.Text = "Cng : " + Convert.ToString(or.countOrder("Cng"));
this.label112.Text = "Microbus : " + Convert.ToString(or.countOrder("Microbus"));
this.label92.Text = "Pickup : " + Convert.ToString(or.countOrder("Pickup"));
this.label90.Text = "Truck : " + Convert.ToString(or.countOrder("Truck"));
//count the total Inventory in groupBox4
InventoryRepository ir = new InventoryRepository();
this.label73.Text = "Total Inventory : " + Convert.ToString(ir.countAllInventory());
this.label138.Text = "Bike :" + Convert.ToString(ir.countInventory("Bike"));
this.label135.Text = "Car :" + Convert.ToString(ir.countInventory("Car"));
this.label136.Text = "Cng :" + Convert.ToString(ir.countInventory("Cng"));
this.label137.Text = "Microbus :" + Convert.ToString(ir.countInventory("Microbus"));
this.label134.Text = "Pickup :" + Convert.ToString(ir.countInventory("Pickup"));
this.label133.Text = "Truck :" + Convert.ToString(ir.countInventory("Truck"));
//count all shipment
ShipmentRepository sr = new ShipmentRepository();
this.label52.Text = "Total Shipment : " + Convert.ToString(sr.countAllShipment());
this.label72.Text = "At Origin : " + Convert.ToString(sr.countShipment("At Origin"));
this.label66.Text = "On the Way : " + Convert.ToString(sr.countShipment("On the Way"));
this.label70.Text = "Stucked : " + Convert.ToString(sr.countShipment("Stuked"));
this.label71.Text = "At Destination : " + Convert.ToString(sr.countShipment("At Destination"));
this.label68.Text = "Shipped : " + Convert.ToString(sr.countShipment("Shipped"));
//accounting
AccountingRepository ar = new AccountingRepository();
this.totalCashLabel.Text = "totalCash : " + Convert.ToString(ar.countTotalCash());
}
