private void BtnPrint_Click(object sender, EventArgs e)
        {
            ProductsModel objP = productsModelBindingSource.Current as ProductsModel;

            if (objP != null)
            {
                using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString))
                {
                    if (connection.State == ConnectionState.Closed)
                    {
                        connection.Open();
                        string query = "Select ProductCode,ProductName,ProductUnit,RetailPrice,CostPrice,Category,Supplier,CreatedDate,Description from [ProductDetails] " +
                                       $" where ProductCode = '{objP.ProductCode}'";
                        List <ProductDetails> list1 = connection.Query <ProductDetails>(query, commandType: CommandType.Text).ToList();
                        using (frmPrint frm = new frmPrint())
                        {
                            frm.PrintProductInvoice(objP, list1);

                            frm.ShowDialog();
                        }
                    }
                }
            }
        }
Esempio n. 2
0
        private void BtnPrint_Click(object sender, EventArgs e)
        {
            SalesModel obj = salesModelBindingSource.Current as SalesModel;

            if (obj != null)
            {
                using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString))
                {
                    if (connection.State == ConnectionState.Closed)
                    {
                        connection.Open();
                        string query = "Select SalesId,Product,Quantity,Price,Discount from [SalesDetails]  " +
                                       $" where SalesId = '{obj.Id}'";
                        List <SalesDetails> list = connection.Query <SalesDetails>(query, commandType: CommandType.Text).ToList();
                        using (frmPrint frm = new frmPrint())
                        {
                            frm.PrintInvoice(obj, list);

                            frm.ShowDialog();
                        }
                    }
                }
            }
        }