C# (CSharp) MySqlUtil.GEN_OVERVIEW_INFO Examples

Example #1

        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();
        }