Beispiel #1
0
 private void button3_Click(object sender, EventArgs e)
 {
     try
     {
         MySql.Data.MySqlClient.MySqlConnection mysqlconnect = new MySql.Data.MySqlClient.MySqlConnection("Server=localhost ; User Id=root; Password= ;Database=algdb(2.0)");
         string query = "SELECT * FROM stocks_print";
         mysqlconnect.Open();
         MySqlCommand     cmd = new MySqlCommand(query, dbcon.mysqlconnect);
         MySqlDataAdapter adp = new MySqlDataAdapter();
         DataSet          dt  = new DataSet();
         adp.SelectCommand = cmd;
         adp.Fill(dt, "dsStock");
         CrystalReportStock reporting = new CrystalReportStock();
         reporting.SetDataSource(dt);
         frmReports frmreports = new frmReports();
         frmreports.crystalReportViewer.ReportSource = reporting;
         frmreports.crystalReportViewer.Refresh();
         cmd.Dispose(); adp.Dispose(); dt.Dispose(); dbcon.mysqlconnect.Close();
         frmreports.ShowDialog();
     }
     catch (Exception)
     {
         throw;
     }
 }
Beispiel #2
0
        private void button2_Click(object sender, EventArgs e)
        {
            MySql.Data.MySqlClient.MySqlConnection mysqlconnect = new MySql.Data.MySqlClient.MySqlConnection("Server=localhost ; User Id=root; Password= ;Database=algdb(2.0)");
            CrystalReportReceipt reporting = new CrystalReportReceipt();

            //dbcon.mysqlconnect.Open();
            mysqlconnect.Open();
            string query = "SELECT * FROM transactions,products,prod_trans_rela,product_prices,brands,categories WHERE transactions.transac_ID = '10000001'AND prod_trans_rela.transac_ID = transactions.transac_ID AND product_prices.product_ID = prod_trans_rela.product_ID AND products.product_ID = prod_trans_rela.product_ID AND brands.brand_ID = products.brand_ID AND categories.category_ID = products.category_ID";
            //string query = "SELECT * FROM transactions,customers,products,prod_trans_rela,product_prices,brands,categories WHERE transactions.transac_ID = '10000001'AND transactions.customer_ID = customers.cust_ID AND prod_trans_rela.transac_ID = transactions.transac_ID AND product_prices.product_ID = prod_trans_rela.product_ID AND products.product_ID = prod_trans_rela.product_ID AND brands.brand_ID = products.brand_ID AND categories.category_ID = products.category_ID";
            MySqlCommand     cmd = new MySqlCommand(query, dbcon.mysqlconnect);
            MySqlDataAdapter adp = new MySqlDataAdapter();
            DataSet          dt  = new DataSet();

            adp.SelectCommand = cmd;
            adp.Fill(dt, "dsreceipt");

            string           query1 = "SELECT * FROM services";
            MySqlCommand     cmd1   = new MySqlCommand(query1, dbcon.mysqlconnect);
            MySqlDataAdapter adp1   = new MySqlDataAdapter();
            DataSet          dt1    = new DataSet();

            adp1.SelectCommand = cmd1;
            adp1.Fill(dt1, "services");

            reporting.SetDataSource(dt);
            //reporting.Database.Tables["dsreceipt"].SetDataSource(dt.Tables[0]);
            //reporting.Database.Tables["services"].SetDataSource(dt1.Tables[0]);
            frmReports frmreports = new frmReports();

            frmreports.crystalReportViewer.ReportSource = reporting;
            frmreports.crystalReportViewer.Refresh();
            cmd.Dispose(); cmd1.Dispose();  adp1.Dispose(); adp.Dispose(); dt.Dispose(); dbcon.mysqlconnect.Close();

            frmreports.ShowDialog();
        }
Beispiel #3
0
        public void printreceipt(string transacID)
        {
            try
            {
                CrystalReportReceipt reporting = new CrystalReportReceipt();
                dbcon.mysqlconnect.Open();
                string           query = $"SELECT * FROM transactions,customers,products,prod_trans_rela,product_prices,brands,categories WHERE transactions.transac_ID = '{transacID}'AND transactions.customer_ID = customers.cust_ID AND prod_trans_rela.transac_ID = transactions.transac_ID AND product_prices.product_ID = prod_trans_rela.product_ID AND products.product_ID = prod_trans_rela.product_ID AND brands.brand_ID = products.brand_ID AND categories.category_ID = products.category_ID";
                MySqlCommand     cmd   = new MySqlCommand(query, dbcon.mysqlconnect);
                MySqlDataAdapter adp   = new MySqlDataAdapter();
                DataSet          dt    = new DataSet();
                adp.SelectCommand = cmd;
                adp.Fill(dt, "dsreceipt");

                reporting.SetDataSource(dt);
                frmReports frmreports = new frmReports();
                frmreports.crystalReportViewer.ReportSource = reporting;
                frmreports.crystalReportViewer.Refresh();
                cmd.Dispose(); adp.Dispose(); dt.Dispose(); dbcon.mysqlconnect.Close();
                frmreports.ShowDialog();
            }
            catch (Exception)
            {
                throw;
            }
        }
Beispiel #4
0
        public void printproduct(string search, string searchBy)
        {
            try
            {
                MySql.Data.MySqlClient.MySqlConnection mysqlconnect = new MySql.Data.MySqlClient.MySqlConnection("Server=localhost ; User Id=root; Password= ;Database=algdb(2.0)");
                //string query = $"SELECT * FROM product_print WHERE category_name = 'Gasoline Engine Oil'";
                string query;
                if (searchBy == "Product ID")
                {
                    query = $"SELECT * FROM product_print WHERE product_ID LIKE '{search}'";
                }
                else if (searchBy == "Product Name")
                {
                    query = $"SELECT * FROM product_print WHERE product_name LIKE '{search}'";
                }
                else if (searchBy == "Brand")
                {
                    query = $"SELECT * FROM product_print WHERE brand_name LIKE '{search}'";
                }
                else if (searchBy == "Category")
                {
                    query = $"SELECT * FROM product_print WHERE category_name LIKE '{search}'";
                }
                else if (searchBy == "Description")
                {
                    query = $"SELECT * FROM product_print WHERE product_desc_value LIKE '{search}'";
                }
                else
                #region old query
                #endregion
                { query = "SELECT * FROM product_print"; }

                mysqlconnect.Open();
                MySqlCommand     cmd = new MySqlCommand(query, dbcon.mysqlconnect);
                MySqlDataAdapter adp = new MySqlDataAdapter();
                DataSet          dt  = new DataSet();
                adp.SelectCommand = cmd;
                adp.Fill(dt, "dsProduct");
                CrystalReportProduct reporting = new CrystalReportProduct();
                reporting.SetDataSource(dt);
                frmReports frmreports = new frmReports();
                frmreports.crystalReportViewer.ReportSource = reporting;
                frmreports.crystalReportViewer.Refresh();
                cmd.Dispose(); adp.Dispose(); dt.Dispose(); dbcon.mysqlconnect.Close();
                frmreports.ShowDialog();
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Beispiel #5
0
        private void button4_Click(object sender, EventArgs e)
        {
            MySql.Data.MySqlClient.MySqlConnection mysqlconnect = new MySql.Data.MySqlClient.MySqlConnection("Server=localhost ; User Id=root; Password= ;Database=algdb(2.0)");
            frmReports frmreports = new frmReports();

            mysqlconnect.Open();
            MySqlDataAdapter adp = new MySqlDataAdapter("getTransaction", mysqlconnect);

            adp.SelectCommand.CommandType = CommandType.StoredProcedure;
            adp.SelectCommand.Parameters.Add("ID", MySql.Data.MySqlClient.MySqlDbType.Int32, 20).Value = textBox1.Text;
            DataSet dt = new System.Data.DataSet();

            adp.Fill(dt, "transaction");
            mysqlconnect.Close();

            //CrystalReport1 reporting = new CrystalReport1();
            //reporting.Database.Tables["transactions"].SetDataSource(dt.Tables[0]);
            //frmreports.crystalReportViewer.ReportSource = null;
            //frmreports.crystalReportViewer.ReportSource = reporting;
        }