public void UC_Dashboard_Load(object sender, EventArgs e)
 {
     using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
     {
         lbl_product.Text  = db.PRODUCTs.Count().ToString();
         lbl_producer.Text = db.GETPRODUCER().Count().ToString();
         lbl_invoice.Text  = db.BILLs.Count().ToString();
     }
 }
 private void radiobtn_product_CheckedChanged(object sender, EventArgs e)
 {
     dropdown_producer.Enabled = true;
     using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
     {
         dropdown_producer.Clear();
         var temp = db.GETPRODUCER().ToList();
         foreach (var i in temp)
         {
             dropdown_producer.AddItem(i.PRODUCER);
         }
     }
 }