private void btn_Purchase_History_Click(object sender, RoutedEventArgs e)
 {
     cc.OpenConnection();
     if (cc.BillPreview1("select COUNT(*) from Stock", billExistValue) > 0)
     {
         cc.CloseConnection();
         PurchaseHistory ph = new PurchaseHistory();
         this.NavigationService.Navigate(ph);
     }
     else
     {
         MessageBox.Show("No Bills to Show");
     }
 }