root/Baza Reklam 2 - Faktury/ZestawienieZamowienForm.cs @ 3

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace Baza_Reklam
{
    public partial class ZestawienieZamowienForm : Form
    {
        string query = "SELECT top 2000 * from VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE ";

        private static ZestawienieZamowienForm form;
        private SqlCommand command;
        private SqlDataAdapter sqlDataAdapter;

        private bool commandExecuted = false;

        public static ZestawienieZamowienForm getZestawienieZamowienForm(MDIBazaReklam parent)
        {
            if (form == null){
                form = new ZestawienieZamowienForm(parent);
            }
            return form;
        }

        private ZestawienieZamowienForm(MDIBazaReklam parent)
        {
            InitializeComponent();

            this.MdiParent = parent;

            //podmiana connstringa
            this.zestawienieZamowienTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;
            this.reklamyZestawienieTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;
            
            //obiekty wykorzytywane przy wyszukiwaniu
            SqlConnection conn = new SqlConnection(ConnString.getConnString().Value);
           
            command = new SqlCommand();
            command.CommandType = CommandType.Text;
            command.Connection = conn;
            
            this.sqlDataAdapter = new SqlDataAdapter();

            //generuje piersze wêz³y w drzewie
            generateNodes();
       }

        private void FacturesForm_Load(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Maximized;
            command.CommandText = this.query;
            sqlDataAdapter.SelectCommand = command;
        }

        private void generateNodes()
        {
            TreeNode node;

            node = new TreeNode("Biura");
            node.Nodes.Add(new TreeNode());
            node.Name = "Biura";
            treeView1.Nodes.Add(node);

            command.Connection.Close();                         
        }

        private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            if (e.Node != null)
            {
                command.CommandText = query;
                command.Parameters.Clear();

                switch (e.Node.Level)
                {
                    case 0:
                        break;
                    case 1:
                        break;
                    case 2:
                        break;
                    case 3:
                        switch (e.Node.Parent.Parent.Parent.Name)
                        {
                            case "Biura":

                                this.Cursor = Cursors.WaitCursor;
                                
                                rEKLAMADataSet.ZestawienieZamowien.Clear();
                                command.CommandText += " where username=@agent";
                                command.Parameters.AddWithValue("@agent", e.Node.Name);
                                sqlDataAdapter.Fill(this.rEKLAMADataSet.ZestawienieZamowien);
                                commandExecuted = true;
                                fakturyDataGridView.Refresh();

                                this.Cursor = Cursors.Default;

                                break;
                            default:
                                break;
                        }
                        break;
                    case 4:
                        break;
                    default:
                        break;
                }           
                }  
        }

        private void treeView1_AfterExpand(object sender, TreeViewEventArgs e)
        {
            TreeNode node;
            SqlDataReader reader;

            if (e.Node != null)
            {
               switch (e.Node.Level)
                {
                    case 0:
                        switch (e.Node.Name)
                        {
                            case "Biura":
                                DBBindings.dodajAgencjeDoWezla(e.Node);
                                break;
                        }  
                        break;
                    case 1:
                        switch (e.Node.Parent.Name)
                        {
                            case "Biura":
                                e.Node.Nodes.Clear();

                                node = new TreeNode("Agenci");
                                node.Name = "Agenci";
                                e.Node.Nodes.Add(node);
                                DBBindings.dodajAgentowDoWezla(node, e.Node.Name);
                                break;
                        }
                        break;
                    default:
                        break;
                }
            }
        }
       
        private void wyszukajToolStripButton_Click(object sender, EventArgs e)
        {
            wyszukajToolStrip.Visible = wyszukajToolStrip.Visible ? false : true;
        }

    
        private void fakturyDataGridView_Leave(object sender, EventArgs e)
        {
            fakturyDataGridView.EndEdit();
        }

        private void kryteriumWyszukiwania_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                wyszukajToolStripButton.PerformClick();
            } 
        }
        private void zestawienieFakturBindingSource_ListChanged(object sender, ListChangedEventArgs e)
        {          
          
        }

        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            PrintDGV.Print_DataGridView(fakturyDataGridView,50);
        }

        private void wyczyscPolaToolStripButton_Click(object sender, EventArgs e)
        {
        }

        /// <summary>
        /// Przechodzi do okna KLIENCI i wyœwietla dane klienta zwi¹zanego z  faktur¹.
        /// </summary>
        private void klientToolStripButton_Click(object sender, EventArgs e)
        {

            if (zestawienieZamowienBindingSource.Current != null)
            {
                DataRowView row = (DataRowView)zestawienieZamowienBindingSource.Current;

                int custID = Convert.ToInt32(row["idKlienta"]);

                ClientsForm.getClientsForm((MDIBazaReklam)this.MdiParent).pokazKlienta(custID);

                this.Hide();

                ClientsForm.getClientsForm((MDIBazaReklam)this.MdiParent).Show();

            }   
        }

        private void FacturesForm_Shown(object sender, EventArgs e)
        {
            if (User.getUser().St_kierownik)
            {
         //       agencjaToolStripComboBox.Text = User.getUser().SymbolAgencji;
            }
            else if (User.getUser().St_handlowiec | User.getUser().St_subhandlowiec)
            {
         //       kodRozliczeniowyToolStripTextBox.Text = User.getUser().Kod_agenta;
            }            
        }

        private void excelToolStripButton_Click(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;

            ExcelHandler ex = new ExcelHandler();
            ex.exportToExcel(fakturyDataGridView);

            this.Cursor = Cursors.Default;
        }

        private void zestawienieZamowienBindingSource_CurrentChanged(object sender, EventArgs e)
        {
            DataRowView row = (DataRowView)zestawienieZamowienBindingSource.Current;
            REKLAMADataSet.ZestawienieZamowienRow zam =
                (REKLAMADataSet.ZestawienieZamowienRow)row.Row;

            this.reklamyZestawienieTableAdapter.FillByIdZamowienia(
                this.rEKLAMADataSet.ReklamyZestawienie,zam.idZamowienia);

        }

        private void zamowieniaToolStripButton_Click(object sender, EventArgs e)
        {
            if (zestawienieZamowienBindingSource.Current != null)
            {
                DataRowView row = (DataRowView)zestawienieZamowienBindingSource.Current;

                REKLAMADataSet.ZestawienieZamowienRow zam =
                (REKLAMADataSet.ZestawienieZamowienRow)row.Row;

                ZamowieniaForm zf = new ZamowieniaForm(zam.idKlienta,zam.idZamowienia);
                zf.ShowDialog();
            }
        }

        private void odswiezToolStripButton_Click(object sender, EventArgs e)
        {
            if (commandExecuted)
            {
                this.Cursor = Cursors.WaitCursor;

                rEKLAMADataSet.ZestawienieZamowien.Clear();
                sqlDataAdapter.Fill(this.rEKLAMADataSet.ZestawienieZamowien);
                fakturyDataGridView.Refresh();

                this.Cursor = Cursors.Default;
            }
        }

        private void zamToolStripButton_Click(object sender, EventArgs e)
        {

            if (reklamyZestawienieBindingSource.Current != null)
            {
                DataRowView row = (DataRowView)reklamyZestawienieBindingSource.Current;

                if (row["reklamaId"] != DBNull.Value)
                {
                    int idRek = Convert.ToInt32(row["reklamaId"]);

                    OrderDetails.getOrderDetails().pokazSzczegolyZamowienia(idRek);
                    OrderDetails.getOrderDetails().ShowDialog();
                }
            }

        }

    }
}