void UpdateOverView()
{
MySqlUtil.GEN_OVERVIEW_INFO();
lblHPri.Text = MySqlUtil.max_price_med_name;
lblHPVal.Text = "\u20B9" + MySqlUtil.max_price;
lblLowPric.Text = MySqlUtil.min_price_med_name;
lblLPVa.Text = "\u20B9" + MySqlUtil.min_price;
lblHighStock.Text = MySqlUtil.max_stocked_med_name;
lblHSVa.Text = MySqlUtil.max_stocked;
lblLowStock.Text = MySqlUtil.min_stocked_med_name;
lblLSVa.Text = MySqlUtil.min_stocked;
lblHighBatch.Text = MySqlUtil.max_batch_med_name;
lblHBVa.Text = "#" + MySqlUtil.max_batch;
lblLowBatch.Text = MySqlUtil.min_batch_med_name;
lblLBVa.Text = "#" + MySqlUtil.min_batch;
MySqlUtil.TOTAL_MED_WORTH();
lblTStockPrice.Text = MySqlUtil.totalMedicineWorth;
var t1 = MySqlUtil.MediCineCount();
lblInStorage.Text = $"{t1}({(t1 * 100 / 15000)}%)";
lblTbatch.Text = MySqlUtil.BatchCount().ToString();
lblTBExp.Text = MySqlUtil.ExpBatchCount().ToString();
}
private void RefreshCounters()
{
if (ct.Ping())
//Refresh all the counter
{
txtLogedInUser.Text = mySqlConnection.globalUser;
Sicon.Fill = new SolidColorBrush(Color.FromRgb(20, 255, 30));
onlineStatus.Text = "Online";
UCMedi.text = MySqlMedicineEntry.MediCineCount().ToString();
UCStock.text = MySqlUtil.MediCineCount().ToString();
UCCompany.text = ManufacturerInfo.GetAllManufacturerName().Count.ToString();
}
else
{
MessageBox.Show("Not Connected!");
}
}