Example #1
0
        private void printSalesReportBtn_Click(object sender, RoutedEventArgs e)
        {
            DataTable table     = ((DataView)salesDataGrid.ItemsSource).ToTable();
            string    htmlTable = toHTML_Table(table);

            System.IO.File.WriteAllText(@"e:\Folder\abc.HTML", htmlTable);

            TheWebBrowser myBrowser = new TheWebBrowser();

            myBrowser.Url = @"e:\Folder\abc.HTML";
            myBrowser.Show();
        }
Example #2
0
        private void printSalesRptBtn_Click(object sender, RoutedEventArgs e)
        {
            if (byStaffCombobox.Text != "")
            {
                string connec0 = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\MerakiBusinessDB.mdf;Integrated Security=True";

                using (SqlConnection loadSalesConnec = new SqlConnection(connec0))
                {
                    SqlCommand getSalesCmd = loadSalesConnec.CreateCommand();
                    getSalesCmd.Connection = loadSalesConnec;


                    getSalesCmd.CommandText = "SELECT * FROM  [Sales] WHERE SoldBy = @SoldBy ORDER BY dateOfSale";
                    getSalesCmd.Parameters.AddWithValue("@SoldBy", SqlDbType.NVarChar).Value = byStaffCombobox.Text;
                    loadSalesConnec.Open();
                    SqlDataAdapter tempSalesTable = new SqlDataAdapter(getSalesCmd);

                    DataSet tempUserHoldingSet = new DataSet("MerakiBusinessDB");

                    tempSalesTable.FillSchema(tempUserHoldingSet, SchemaType.Mapped, "Sales");
                    tempSalesTable.Fill(tempUserHoldingSet, "Sales");


                    DataTable salesTable = tempUserHoldingSet.Tables["Sales"];


                    using (SqlConnection loadRetailSalesConnec = new SqlConnection(connec0))
                    {
                        SqlCommand getRetailSalesCmd = loadRetailSalesConnec.CreateCommand();
                        getRetailSalesCmd.Connection = loadRetailSalesConnec;

                        getRetailSalesCmd.CommandText = "SELECT * FROM  [RetailSale] WHERE SoldBy = @SoldBy ORDER BY SaleDate ASC";
                        getRetailSalesCmd.Parameters.AddWithValue("@SoldBy", SqlDbType.NVarChar).Value = byStaffCombobox.Text;
                        loadRetailSalesConnec.Open();
                        SqlDataAdapter tempRetailSalesTable = new SqlDataAdapter(getRetailSalesCmd);

                        DataSet tempRetailSalesHoldingSet = new DataSet("MerakiBusinessDB");

                        tempRetailSalesTable.FillSchema(tempRetailSalesHoldingSet, SchemaType.Mapped, "RetailSale");
                        tempRetailSalesTable.Fill(tempRetailSalesHoldingSet, "RetailSale");


                        DataTable retailSalesTable = tempRetailSalesHoldingSet.Tables["RetailSale"];


                        DateTime today = DateTime.Today;
                        string   htmlPacketSalesTable  = toHTML_Table_PacketSales2(salesTable, " " + today.Day + "/" + today.Month + "/" + today.Year);
                        string   htmlRetailSalesTables = toHTML_Table_RetailSales2(retailSalesTable, byStaffCombobox.Text);
                        System.IO.File.WriteAllText(@"e:\Folder\ELiza Report For-" + DateTime.Now.Day.ToString() + ".HTML", htmlPacketSalesTable);
                        System.IO.File.AppendAllText(@"e:\Folder\abc.HTML", htmlRetailSalesTables);



                        TheWebBrowser myBrowser = new TheWebBrowser();
                        myBrowser.Url = @"e:\Folder\ELiza Report For-" + DateTime.Now.Day.ToString() + ".HTML";
                        myBrowser.Show();
                    }
                }
            }

            else if (startDatePicker.SelectedDate == null && endDatePicker.SelectedDate != null && byStaffCombobox.Text == "")
            {
                string connec0 = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\MerakiBusinessDB.mdf;Integrated Security=True";

                using (SqlConnection loadSalesConnec = new SqlConnection(connec0))
                {
                    SqlCommand getSalesCmd = loadSalesConnec.CreateCommand();
                    getSalesCmd.Connection = loadSalesConnec;

                    getSalesCmd.CommandText = "SELECT * FROM  [Sales] WHERE DateOfSale <= @DateOfSale2 ORDER BY DateOfSale ASC";
                    getSalesCmd.Parameters.AddWithValue("@DateOfSale2", SqlDbType.Date).Value = Convert.ToDateTime(endDatePicker.SelectedDate.Value.ToString("MM-dd-yyyy"));
                    loadSalesConnec.Open();
                    SqlDataAdapter tempSalesTable = new SqlDataAdapter(getSalesCmd);

                    DataSet tempUserHoldingSet = new DataSet("MerakiBusinessDB");

                    tempSalesTable.FillSchema(tempUserHoldingSet, SchemaType.Mapped, "Sales");
                    tempSalesTable.Fill(tempUserHoldingSet, "Sales");


                    DataTable salesTable = tempUserHoldingSet.Tables["Sales"];


                    using (SqlConnection loadRetailSalesConnec = new SqlConnection(connec0))
                    {
                        SqlCommand getRetailSalesCmd = loadRetailSalesConnec.CreateCommand();
                        getRetailSalesCmd.Connection = loadRetailSalesConnec;

                        getRetailSalesCmd.CommandText = "SELECT * FROM  [RetailSale] WHERE SaleDate <= @DateOfSale2 ORDER BY SaleDate ASC";
                        getRetailSalesCmd.Parameters.AddWithValue("@DateOfSale2", SqlDbType.Date).Value = Convert.ToDateTime(endDatePicker.SelectedDate.Value.ToString("MM-dd-yyyy"));
                        loadRetailSalesConnec.Open();
                        SqlDataAdapter tempRetailSalesTable = new SqlDataAdapter(getRetailSalesCmd);

                        DataSet tempRetailSalesHoldingSet = new DataSet("MerakiBusinessDB");

                        tempRetailSalesTable.FillSchema(tempRetailSalesHoldingSet, SchemaType.Mapped, "ReatilSales");
                        tempRetailSalesTable.Fill(tempRetailSalesHoldingSet, "ReatilSales");


                        DataTable retailSalesTable = tempRetailSalesHoldingSet.Tables["ReatilSales"];



                        string htmlPacketSalesTable1  = toHTML_Table_PacketSales1(salesTable, endDatePicker.SelectedDate.Value);
                        string htmlRetailSalesTables1 = toHTML_Table_RetailSales1(retailSalesTable, endDatePicker.SelectedDate.Value);
                        System.IO.File.WriteAllText(@"e:\Folder\" + DateTime.Now.Day.ToString() + ".HTML", htmlPacketSalesTable1);
                        System.IO.File.AppendAllText(@"e:\Folder\" + DateTime.Now.Day.ToString() + ".HTML", htmlRetailSalesTables1);



                        TheWebBrowser myBrowser = new TheWebBrowser();
                        myBrowser.Url = @"e:\Folder\" + DateTime.Now.Day.ToString() + ".HTML";
                        myBrowser.Show();
                    }
                }
            }

            else if (startDatePicker.SelectedDate != null && endDatePicker.SelectedDate == null && byStaffCombobox.Text == "")
            {
                string connec0 = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\MerakiBusinessDB.mdf;Integrated Security=True";

                using (SqlConnection loadSalesConnec = new SqlConnection(connec0))
                {
                    SqlCommand getSalesCmd = loadSalesConnec.CreateCommand();
                    getSalesCmd.Connection = loadSalesConnec;

                    getSalesCmd.CommandText = "SELECT * FROM  [Sales] WHERE DateOfSale >= @DateOfSale1 ORDER BY DateOfSale ASC";
                    getSalesCmd.Parameters.AddWithValue("@DateOfSale1", SqlDbType.Date).Value = Convert.ToDateTime(startDatePicker.SelectedDate.Value.ToString("MM-dd-yyyy"));
                    loadSalesConnec.Open();
                    SqlDataAdapter tempSalesTable = new SqlDataAdapter(getSalesCmd);

                    DataSet tempUserHoldingSet = new DataSet("MerakiBusinessDB");

                    tempSalesTable.FillSchema(tempUserHoldingSet, SchemaType.Mapped, "Sales");
                    tempSalesTable.Fill(tempUserHoldingSet, "Sales");


                    DataTable salesTable = tempUserHoldingSet.Tables["Sales"];


                    using (SqlConnection loadRetailSalesConnec = new SqlConnection(connec0))
                    {
                        SqlCommand getRetailSalesCmd = loadRetailSalesConnec.CreateCommand();
                        getRetailSalesCmd.Connection = loadRetailSalesConnec;

                        getRetailSalesCmd.CommandText = "SELECT * FROM  [RetailSale] WHERE SaleDate >= @DateOfSale1 ORDER BY SaleDate ASC";
                        getRetailSalesCmd.Parameters.AddWithValue("@DateOfSale1", SqlDbType.Date).Value = Convert.ToDateTime(startDatePicker.SelectedDate.Value.ToString("MM-dd-yyyy"));
                        loadRetailSalesConnec.Open();
                        SqlDataAdapter tempRetailSalesTable = new SqlDataAdapter(getRetailSalesCmd);

                        DataSet tempRetailSalesHoldingSet = new DataSet("MerakiBusinessDB");

                        tempRetailSalesTable.FillSchema(tempRetailSalesHoldingSet, SchemaType.Mapped, "ReatilSales");
                        tempRetailSalesTable.Fill(tempRetailSalesHoldingSet, "ReatilSales");


                        DataTable retailSalesTable = tempRetailSalesHoldingSet.Tables["ReatilSales"];



                        string htmlPacketSalesTable1  = toHTML_Table_PacketSales1(salesTable, startDatePicker.SelectedDate.Value);
                        string htmlRetailSalesTables1 = toHTML_Table_RetailSales1(retailSalesTable, startDatePicker.SelectedDate.Value);
                        System.IO.File.WriteAllText(@"e:\Folder\" + DateTime.Now.Day.ToString() + ".HTML", htmlPacketSalesTable1);
                        System.IO.File.AppendAllText(@"e:\Folder\" + DateTime.Now.Day.ToString() + ".HTML", htmlRetailSalesTables1);



                        TheWebBrowser myBrowser = new TheWebBrowser();
                        myBrowser.Url = @"e:\Folder\" + DateTime.Now.Day.ToString() + ".HTML";
                        myBrowser.Show();
                    }
                }
            }


            #region everything is null
            else if (startDatePicker.SelectedDate == null && endDatePicker.SelectedDate == null && byStaffCombobox.Text == null)
            {
                MessageBox.Show("Please First Make A selection!");
            }
            #endregion
        }