Exemple #1
0
        private void button_EXPORT_Click(object sender, EventArgs e)
        {
            if (this.checkBox_EkspALLDB.Checked == true)
            {
                StreamWriter sw = new StreamWriter(this.textBox_Path.Text);
                String       fn_buff;
                String       FVal;
                String       CVal;
                fn_buff = "Biblioteka Filmów NET Exported data http://mkalat.pl \n\r";
                sw.WriteLine(fn_buff);
                // Eksportuj cała baz edanych
                if (this.checkBox_EkspFILM.Checked == true)
                {
                    fn_buff = "Podstawowe dane o Filmie : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    frm1.filmBindingSource.Position = 0;

                    for (Int32 y = 0; y < frm1.defaultDataSet.Film.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Film.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);

                    for (Int32 i = 0; i < frm1.filmBindingSource.Count; i++)
                    {
                        fn_buff = "";
                        frm1.filmBindingSource.Position = i;
                        defaultDataSet.FilmRow flmrow = frm1.defaultDataSet.Film[frm1.filmBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Film.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }
                if (this.checkBox_EkspOB.Checked == true)
                {
                    fn_buff = "Dane Tabeli Obsada : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    frm1.fKFilmObsadaBindingSource.Position = 0;
                    for (Int32 y = 0; y < frm1.defaultDataSet.Obsada.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Obsada.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.defaultDataSet.Obsada.Count; i++)
                    {
                        fn_buff = "";
                        defaultDataSet.ObsadaRow flmrow = frm1.defaultDataSet.Obsada[i];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Obsada.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }
                if (this.checkBox_EkspOC.Checked == true)
                {
                    fn_buff = "Dane Tabeli Ocena : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.Ocena.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Ocena.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.defaultDataSet.Ocena.Count; i++)
                    {
                        fn_buff = "";
                        defaultDataSet.OcenaRow flmrow = frm1.defaultDataSet.Ocena[i];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Ocena.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }
                if (this.checkBox_EkspLZ.Checked == true)
                {
                    fn_buff = "Dane Tabeli Lokalizacje Zdjęciowe : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.LokZdj.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.LokZdj.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.defaultDataSet.LokZdj.Count; i++)
                    {
                        fn_buff = "";
                        defaultDataSet.LokZdjRow flmrow = frm1.defaultDataSet.LokZdj[i];
                        for (Int32 y = 0; y < frm1.defaultDataSet.LokZdj.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }
                if (this.checkBox_EkspPD.Checked == true)
                {
                    fn_buff = "Dane Tabel : Producenci i Dystrybutorzy : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.Produkcja.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Produkcja.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.defaultDataSet.Produkcja.Count; i++)
                    {
                        fn_buff = "";
                        defaultDataSet.ProdukcjaRow flmrow = frm1.defaultDataSet.Produkcja[i];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Produkcja.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }


                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.Dystrybucja.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Dystrybucja.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.defaultDataSet.Dystrybucja.Count; i++)
                    {
                        fn_buff = "";
                        defaultDataSet.DystrybucjaRow flmrow = frm1.defaultDataSet.Dystrybucja[i];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Dystrybucja.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }

                if (this.checkBox_EkspWYP.Checked == true)
                {
                    fn_buff = "Dane Tabel : Wypożyczenia Innym Osobom  i Wypożyczenia od Innych Osób ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.WYPIN.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.WYPIN.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.defaultDataSet.WYPIN.Count; i++)
                    {
                        fn_buff = "";
                        defaultDataSet.WYPINRow flmrow = frm1.defaultDataSet.WYPIN[i];
                        for (Int32 y = 0; y < frm1.defaultDataSet.WYPIN.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }


                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.WYPODIN.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.WYPODIN.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.defaultDataSet.WYPODIN.Count; i++)
                    {
                        fn_buff = "";
                        defaultDataSet.WYPODINRow flmrow = frm1.defaultDataSet.WYPODIN[i];
                        for (Int32 y = 0; y < frm1.defaultDataSet.WYPODIN.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }
                sw.Close();
            }
            else
            {
                StreamWriter sw = new StreamWriter(this.textBox_Path.Text);
                String       fn_buff;
                String       FVal;
                String       CVal;
                if (this.checkBox_EkspFILM.Checked == true)
                {
                    fn_buff = "Podstawowe dane o Filmie : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    frm1.filmBindingSource.Position = 0;

                    for (Int32 y = 0; y < frm1.defaultDataSet.Film.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Film.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);

                    fn_buff = "";

                    defaultDataSet.FilmRow flmrow = frm1.defaultDataSet.Film[frm1.filmBindingSource.Position];
                    for (Int32 y = 0; y < frm1.defaultDataSet.Film.Columns.Count; y++)
                    {
                        FVal = Convert.ToString(flmrow[y]);
                        FVal.Replace("\n", " ");
                        FVal.Replace("\r", " ");
                        fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                }
                if (this.checkBox_EkspOB.Checked == true)
                {
                    fn_buff = "Dane Tabeli Obsada : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    frm1.fKFilmObsadaBindingSource.Position = 0;
                    for (Int32 y = 0; y < frm1.defaultDataSet.Obsada.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Obsada.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmObsadaBindingSource.Count; i++)
                    {
                        fn_buff = "";
                        frm1.fKFilmObsadaBindingSource.Position = i;
                        defaultDataSet.ObsadaRow flmrow = frm1.defaultDataSet.Obsada[frm1.fKFilmObsadaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Obsada.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }
                if (this.checkBox_EkspOC.Checked == true)
                {
                    fn_buff = "Dane Tabeli Ocena : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.Ocena.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Ocena.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmOcenaBindingSource.Count; i++)
                    {
                        fn_buff = "";
                        frm1.fKFilmOcenaBindingSource.Position = i;
                        defaultDataSet.OcenaRow flmrow = frm1.defaultDataSet.Ocena[frm1.fKFilmOcenaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Ocena.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }
                if (this.checkBox_EkspLZ.Checked == true)
                {
                    fn_buff = "Dane Tabeli Lokalizacje Zdjęciowe : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.LokZdj.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.LokZdj.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmLokZdjBindingSource.Count; i++)
                    {
                        fn_buff = "";
                        frm1.fKFilmLokZdjBindingSource.Position = i;
                        defaultDataSet.LokZdjRow flmrow = frm1.defaultDataSet.LokZdj[frm1.fKFilmLokZdjBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.LokZdj.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }
                if (this.checkBox_EkspPD.Checked == true)
                {
                    fn_buff = "Dane Tabel : Producenci i Dystrybutorzy : ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.Produkcja.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Produkcja.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmProdukcjaBindingSource.Count; i++)
                    {
                        fn_buff = "";
                        frm1.fKFilmProdukcjaBindingSource.Position = i;
                        defaultDataSet.ProdukcjaRow flmrow = frm1.defaultDataSet.Produkcja[frm1.fKFilmProdukcjaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Produkcja.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }


                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.Dystrybucja.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Dystrybucja.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmDystrybucjaBindingSource.Count; i++)
                    {
                        fn_buff = "";
                        frm1.fKFilmDystrybucjaBindingSource.Position = i;
                        defaultDataSet.DystrybucjaRow flmrow = frm1.defaultDataSet.Dystrybucja[frm1.fKFilmDystrybucjaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Dystrybucja.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }

                if (this.checkBox_EkspWYP.Checked == true)
                {
                    fn_buff = "Dane Tabel : Wypożyczenia Innym Osobom  i Wypożyczenia od Innych Osób ";
                    sw.WriteLine(fn_buff);
                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.WYPIN.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.WYPIN.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmWYPINBindingSource.Count; i++)
                    {
                        fn_buff = "";
                        frm1.fKFilmWYPINBindingSource.Position = i;
                        defaultDataSet.WYPINRow flmrow = frm1.defaultDataSet.WYPIN[frm1.fKFilmWYPINBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.WYPIN.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }


                    fn_buff = "";
                    for (Int32 y = 0; y < frm1.defaultDataSet.WYPODIN.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.WYPODIN.Columns[y].Caption);
                        fn_buff = fn_buff + "\"" + CVal + "\"" + ",";
                    }
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmWYPODINBindingSource.Count; i++)
                    {
                        fn_buff = "";
                        frm1.fKFilmWYPODINBindingSource.Position = i;
                        defaultDataSet.WYPODINRow flmrow = frm1.defaultDataSet.WYPODIN[frm1.fKFilmWYPODINBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.WYPODIN.Columns.Count; y++)
                        {
                            FVal = Convert.ToString(flmrow[y]);
                            FVal.Replace("\n", " ");
                            FVal.Replace("\r", " ");
                            fn_buff = fn_buff + "\"" + FVal + "\"" + ",";
                        }
                        sw.WriteLine(fn_buff);
                    }
                }
                sw.Close();
            }
            MessageBox.Show("Dane zostały wyeksportowane", "Biblioteka Filmów NET", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
Exemple #2
0
        private void button_PRINT_Click(object sender, EventArgs e)
        {
            if (this.checkBox_PrintALL.Checked == true)
            {
                StreamWriter sw = new StreamWriter(fn_path);
                String       fn_buff;
                String       FVal;
                String       CVal;
                fn_buff = "Biblioteka Filmów NET Exported data http://mkalat.pl \n\r";
                sw.WriteLine(fn_buff);
                // Eksportuj cała baz edanych
                if (this.checkBox_PrintFilm.Checked == true)
                {
                    fn_buff = "Podstawowe dane o Filmie : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.filmBindingSource.Count; i++)
                    {
                        frm1.filmBindingSource.Position = i;
                        defaultDataSet.FilmRow flmrow = frm1.defaultDataSet.Film[frm1.filmBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Film.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.Film.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintOB.Checked == true)
                {
                    fn_buff = "Dane Tabeli Obsada : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmObsadaBindingSource.Count; i++)
                    {
                        frm1.fKFilmObsadaBindingSource.Position = i;
                        defaultDataSet.ObsadaRow flmrow = frm1.defaultDataSet.Obsada[frm1.fKFilmObsadaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Obsada.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.Obsada.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintOC.Checked == true)
                {
                    fn_buff = "Dane Tabeli Ocena : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmOcenaBindingSource.Count; i++)
                    {
                        frm1.fKFilmOcenaBindingSource.Position = i;
                        defaultDataSet.OcenaRow flmrow = frm1.defaultDataSet.Ocena[frm1.fKFilmOcenaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Ocena.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.Ocena.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintP.Checked == true)
                {
                    fn_buff = "Dane Tabeli Producenci : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmProdukcjaBindingSource.Count; i++)
                    {
                        frm1.fKFilmProdukcjaBindingSource.Position = i;
                        defaultDataSet.ProdukcjaRow flmrow = frm1.defaultDataSet.Produkcja[frm1.fKFilmProdukcjaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Produkcja.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.Produkcja.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintD.Checked == true)
                {
                    fn_buff = "Dane Tabeli Dystrybutorzy : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmDystrybucjaBindingSource.Count; i++)
                    {
                        frm1.fKFilmDystrybucjaBindingSource.Position = i;
                        defaultDataSet.DystrybucjaRow flmrow = frm1.defaultDataSet.Dystrybucja[frm1.fKFilmDystrybucjaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Dystrybucja.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.Dystrybucja.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintLZ.Checked == true)
                {
                    fn_buff = "Dane Tabeli Lokalizacje Zdjęciowe : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmLokZdjBindingSource.Count; i++)
                    {
                        frm1.fKFilmLokZdjBindingSource.Position = i;
                        defaultDataSet.LokZdjRow flmrow = frm1.defaultDataSet.LokZdj[frm1.fKFilmLokZdjBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.LokZdj.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.LokZdj.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintWYP.Checked == true)
                {
                    fn_buff = "Dane Tabeli Wypożyczenia Innym Osobom : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmWYPINBindingSource.Count; i++)
                    {
                        frm1.fKFilmWYPINBindingSource.Position = i;
                        defaultDataSet.WYPINRow flmrow = frm1.defaultDataSet.WYPIN[frm1.fKFilmWYPINBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.WYPIN.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.WYPIN.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                    fn_buff = "Dane Tabeli Wypożyczenia Od Innych Osób : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmWYPODINBindingSource.Count; i++)
                    {
                        frm1.fKFilmWYPODINBindingSource.Position = i;
                        defaultDataSet.WYPODINRow flmrow = frm1.defaultDataSet.WYPODIN[frm1.fKFilmWYPODINBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.WYPODIN.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.WYPODIN.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                sw.Close();
                System.Drawing.Printing.PrintDocument docToPrint = new System.Drawing.Printing.PrintDocument();
                PrintDialog prndial = new PrintDialog();
                prndial.AllowSomePages = false;
                prndial.ShowHelp       = true;
                prndial.Document       = docToPrint;
                DialogResult res = prndial.ShowDialog();
                if (res == DialogResult.OK)
                {
                    docToPrint.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.document_PrintPage);
                    docToPrint.Print();
                }
            }
            else
            {
                StreamWriter sw = new StreamWriter(fn_path);
                String       fn_buff;
                String       FVal;
                String       CVal;
                fn_buff = "Biblioteka Filmów NET Exported data http://mkalat.pl \n\r";
                sw.WriteLine(fn_buff);
                // Eksportuj cała baz edanych
                if (this.checkBox_PrintFilm.Checked == true)
                {
                    fn_buff = "Podstawowe dane o Filmie : ";
                    sw.WriteLine(fn_buff);
                    defaultDataSet.FilmRow flmrow = frm1.defaultDataSet.Film[frm1.filmBindingSource.Position];
                    for (Int32 y = 0; y < frm1.defaultDataSet.Film.Columns.Count; y++)
                    {
                        CVal    = Convert.ToString(frm1.defaultDataSet.Film.Columns[y].Caption);
                        FVal    = Convert.ToString(flmrow[y]);
                        fn_buff = CVal + " : " + FVal;
                        sw.WriteLine(fn_buff);
                    }
                }
                if (this.checkBox_PrintOB.Checked == true)
                {
                    fn_buff = "Dane Tabeli Obsada : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmObsadaBindingSource.Count; i++)
                    {
                        frm1.fKFilmObsadaBindingSource.Position = i;
                        defaultDataSet.ObsadaRow flmrow = frm1.defaultDataSet.Obsada[frm1.fKFilmObsadaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Obsada.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.Obsada.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintOC.Checked == true)
                {
                    fn_buff = "Dane Tabeli Ocena : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmOcenaBindingSource.Count; i++)
                    {
                        frm1.fKFilmOcenaBindingSource.Position = i;
                        defaultDataSet.OcenaRow flmrow = frm1.defaultDataSet.Ocena[frm1.fKFilmOcenaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Ocena.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.Ocena.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintP.Checked == true)
                {
                    fn_buff = "Dane Tabeli Producenci : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmProdukcjaBindingSource.Count; i++)
                    {
                        frm1.fKFilmProdukcjaBindingSource.Position = i;
                        defaultDataSet.ProdukcjaRow flmrow = frm1.defaultDataSet.Produkcja[frm1.fKFilmProdukcjaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Produkcja.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.Produkcja.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintD.Checked == true)
                {
                    fn_buff = "Dane Tabeli Dystrybutorzy : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmDystrybucjaBindingSource.Count; i++)
                    {
                        frm1.fKFilmDystrybucjaBindingSource.Position = i;
                        defaultDataSet.DystrybucjaRow flmrow = frm1.defaultDataSet.Dystrybucja[frm1.fKFilmDystrybucjaBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.Dystrybucja.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.Dystrybucja.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintLZ.Checked == true)
                {
                    fn_buff = "Dane Tabeli Lokalizacje Zdjęciowe : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmLokZdjBindingSource.Count; i++)
                    {
                        frm1.fKFilmLokZdjBindingSource.Position = i;
                        defaultDataSet.LokZdjRow flmrow = frm1.defaultDataSet.LokZdj[frm1.fKFilmLokZdjBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.LokZdj.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.LokZdj.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }
                if (this.checkBox_PrintWYP.Checked == true)
                {
                    fn_buff = "Dane Tabeli Wypożyczenia Innym Osobom : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmWYPINBindingSource.Count; i++)
                    {
                        frm1.fKFilmWYPINBindingSource.Position = i;
                        defaultDataSet.WYPINRow flmrow = frm1.defaultDataSet.WYPIN[frm1.fKFilmWYPINBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.WYPIN.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.WYPIN.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                    fn_buff = "Dane Tabeli Wypożyczenia Od Innych Osób : ";
                    sw.WriteLine(fn_buff);
                    for (Int32 i = 0; i < frm1.fKFilmWYPODINBindingSource.Count; i++)
                    {
                        frm1.fKFilmWYPODINBindingSource.Position = i;
                        defaultDataSet.WYPODINRow flmrow = frm1.defaultDataSet.WYPODIN[frm1.fKFilmWYPODINBindingSource.Position];
                        for (Int32 y = 0; y < frm1.defaultDataSet.WYPODIN.Columns.Count; y++)
                        {
                            CVal    = Convert.ToString(frm1.defaultDataSet.WYPODIN.Columns[y].Caption);
                            FVal    = Convert.ToString(flmrow[y]);
                            fn_buff = CVal + " : " + FVal;
                            sw.WriteLine(fn_buff);
                        }
                    }
                }

                sw.Close();
                System.Drawing.Printing.PrintDocument docToPrint = new System.Drawing.Printing.PrintDocument();
                PrintDialog prndial = new PrintDialog();
                prndial.AllowSomePages = false;
                prndial.ShowHelp       = true;
                prndial.Document       = docToPrint;
                DialogResult res = prndial.ShowDialog();
                if (res == DialogResult.OK)
                {
                    docToPrint.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.document_PrintPage);
                    docToPrint.Print();
                }
            }
        }
        private void button_Start_Click(object sender, EventArgs e)
        {
            if (File.Exists(this.textBox_SelPath.Text))
            {
                this.wYPODINTableAdapter.Connection.ConnectionString     = "Data Source=" + this.textBox_SelPath.Text + ";Max Database Size=4091";
                this.wYPINTableAdapter.Connection.ConnectionString       = "Data Source=" + this.textBox_SelPath.Text + ";Max Database Size=4091";
                this.lokZdjTableAdapter.Connection.ConnectionString      = "Data Source=" + this.textBox_SelPath.Text + ";Max Database Size=4091";
                this.dystrybucjaTableAdapter.Connection.ConnectionString = "Data Source=" + this.textBox_SelPath.Text + ";Max Database Size=4091";
                this.produkcjaTableAdapter.Connection.ConnectionString   = "Data Source=" + this.textBox_SelPath.Text + ";Max Database Size=4091";
                this.obsadaTableAdapter.Connection.ConnectionString      = "Data Source=" + this.textBox_SelPath.Text + ";Max Database Size=4091";
                this.ocenaTableAdapter.Connection.ConnectionString       = "Data Source=" + this.textBox_SelPath.Text + ";Max Database Size=4091";
                this.filmTableAdapter.Connection.ConnectionString        = "Data Source=" + this.textBox_SelPath.Text + ";Max Database Size=4091";

                this.wYPODINTableAdapter.Connection.Open();
                this.wYPINTableAdapter.Connection.Open();
                this.lokZdjTableAdapter.Connection.Open();
                this.dystrybucjaTableAdapter.Connection.Open();
                this.produkcjaTableAdapter.Connection.Open();
                this.obsadaTableAdapter.Connection.Open();
                this.ocenaTableAdapter.Connection.Open();
                this.filmTableAdapter.Connection.Open();

                this.wYPODINTableAdapter.Fill(this.defaultDataSet.WYPODIN);
                this.wYPINTableAdapter.Fill(this.defaultDataSet.WYPIN);
                this.lokZdjTableAdapter.Fill(this.defaultDataSet.LokZdj);
                this.dystrybucjaTableAdapter.Fill(this.defaultDataSet.Dystrybucja);
                this.produkcjaTableAdapter.Fill(this.defaultDataSet.Produkcja);
                this.obsadaTableAdapter.Fill(this.defaultDataSet.Obsada);
                this.ocenaTableAdapter.Fill(this.defaultDataSet.Ocena);
                this.filmTableAdapter.Fill(this.defaultDataSet.Film);

                //FILM

                foreach (defaultDataSet.FilmRow flm_src in this.defaultDataSet.Film.Rows)
                {
                    flm_row                = frm1.defaultDataSet.Film.NewFilmRow();
                    flm_row.Tytul          = flm_src.Tytul;
                    flm_row.TytulOrig      = flm_src.TytulOrig;
                    flm_row.Gatunek        = flm_src.Gatunek;
                    flm_row.pathtofront    = flm_src.pathtofront;
                    flm_row.pathtoback     = flm_src.pathtoback;
                    flm_row.OW_SD          = flm_src.OW_SD;
                    flm_row.OW_Obs         = flm_src.OW_Obs;
                    flm_row.OW_Zdj         = flm_src.OW_Zdj;
                    flm_row.OW_Wart        = flm_src.OW_Wart;
                    flm_row.OW_ALL         = flm_src.OW_ALL;
                    flm_row.DOE_Cena       = flm_src.DOE_Cena;
                    flm_row.DOE_WartAkt    = flm_src.DOE_WartAkt;
                    flm_row.DOE_DataZak    = flm_src.DOE_DataZak;
                    flm_row.DOE_DataUtr    = flm_src.DOE_DataUtr;
                    flm_row.DOE_DataSkat   = flm_src.DOE_DataSkat;
                    flm_row.DOE_Nośnik     = flm_src.DOE_Nośnik;
                    flm_row.DOE_NrKat      = flm_src.DOE_NrKat;
                    flm_row.DOE_Imie       = flm_src.DOE_Imie;
                    flm_row.DOE_Nazw       = flm_src.DOE_Nazw;
                    flm_row.DOE_Adres      = flm_src.DOE_Adres;
                    flm_row.DOE_MN_Nazwa   = flm_src.DOE_MN_Nazwa;
                    flm_row.DOE_MN_Adres   = flm_src.DOE_MN_Adres;
                    flm_row.DOE_MN_Tel     = flm_src.DOE_MN_Tel;
                    flm_row.DOE_MN_Email   = flm_src.DOE_MN_Email;
                    flm_row.DOE_MN_WWW     = flm_src.DOE_MN_WWW;
                    flm_row.DOE_MN_Fax     = flm_src.DOE_MN_Fax;
                    flm_row.IOF_RokProd    = flm_src.IOF_RokProd;
                    flm_row.IOF_DataPrem   = flm_src.IOF_DataPrem;
                    flm_row.IOF_CzasProj   = flm_src.IOF_CzasProj;
                    flm_row.IOF_JezykLekt  = flm_src.IOF_JezykLekt;
                    flm_row.IOF_JezykNap   = flm_src.IOF_JezykNap;
                    flm_row.IOF_FormWysw   = flm_src.IOF_FormWysw;
                    flm_row.IOF_SysKodObr  = flm_src.IOF_SysKodObr;
                    flm_row.IOF_KrajProd   = flm_src.IOF_KrajProd;
                    flm_row.IOF_KW_Nazwa   = flm_src.IOF_KW_Nazwa;
                    flm_row.IOF_KW_Typ     = flm_src.IOF_KW_Typ;
                    flm_row.IOF_KW_Wersja  = flm_src.IOF_KW_Wersja;
                    flm_row.IOF_ZAB_Nazwa  = flm_src.IOF_ZAB_Nazwa;
                    flm_row.IOF_ZAB_Typ    = flm_src.IOF_ZAB_Typ;
                    flm_row.IOF_ZAB_Wersja = flm_src.IOF_ZAB_Wersja;
                    flm_row.IOF_KA_Nazwa   = flm_src.IOF_KA_Nazwa;
                    flm_row.IOF_KA_Typ     = flm_src.IOF_KA_Typ;
                    flm_row.IOF_KA_Wersja  = flm_src.IOF_KA_Wersja;
                    frm1.defaultDataSet.Film.Rows.Add(flm_row);
                    Save_DS();

                    Flm_id = frm1.FindNewFilmID() - 1;

                    foreach (defaultDataSet.OcenaRow oc_src in this.defaultDataSet.Ocena.Rows)
                    {
                        if (flm_src.ID == oc_src.IDPDB)
                        {
                            defaultDataSet.OcenaRow oc_row = frm1.defaultDataSet.Ocena.NewOcenaRow();

                            oc_row.IDPDB = Flm_id;
                            oc_row.Nazwa = oc_src.Nazwa;
                            oc_row.Tytul = oc_src.Tytul;
                            oc_row.Autor = oc_src.Autor;
                            oc_row.WWW   = oc_src.WWW;
                            oc_row.Ocena = oc_src.Ocena;
                            frm1.defaultDataSet.Ocena.Rows.Add(oc_row);
                            Save_DS();
                        }
                    }

                    foreach (defaultDataSet.ObsadaRow ob_src in this.defaultDataSet.Obsada.Rows)
                    {
                        if (flm_src.ID == ob_src.IDPDB)
                        {
                            defaultDataSet.ObsadaRow ob_row = frm1.defaultDataSet.Obsada.NewObsadaRow();

                            ob_row.IDPDB    = Flm_id;
                            ob_row.ImieNazw = ob_src.ImieNazw;
                            ob_row.Rola     = ob_src.Rola;

                            frm1.defaultDataSet.Obsada.Rows.Add(ob_row);
                            Save_DS();
                        }
                    }

                    foreach (defaultDataSet.ProdukcjaRow pp_src in this.defaultDataSet.Produkcja.Rows)
                    {
                        if (flm_src.ID == pp_src.IDPDB)
                        {
                            defaultDataSet.ProdukcjaRow pp_row = frm1.defaultDataSet.Produkcja.NewProdukcjaRow();
                            pp_row.IDPDB      = Flm_id;
                            pp_row.Nazwa      = pp_src.Nazwa;
                            pp_row.Adres      = pp_src.Adres;
                            pp_row.Tel        = pp_src.Tel;
                            pp_row.Fax        = pp_src.Fax;
                            pp_row.Email      = pp_src.Email;
                            pp_row.WWW        = pp_src.WWW;
                            pp_row.Narodowość = pp_src.Narodowość;
                            frm1.defaultDataSet.Produkcja.Rows.Add(pp_row);
                            Save_DS();
                        }
                    }

                    foreach (defaultDataSet.DystrybucjaRow pd_src in this.defaultDataSet.Dystrybucja.Rows)
                    {
                        if (flm_src.ID == pd_src.IDPDB)
                        {
                            defaultDataSet.DystrybucjaRow pd_row = frm1.defaultDataSet.Dystrybucja.NewDystrybucjaRow();
                            pd_row.IDPDB      = Flm_id;
                            pd_row.Nazwa      = pd_src.Nazwa;
                            pd_row.Adres      = pd_src.Adres;
                            pd_row.Tel        = pd_src.Tel;
                            pd_row.Fax        = pd_src.Fax;
                            pd_row.Email      = pd_src.Email;
                            pd_row.WWW        = pd_src.WWW;
                            pd_row.Narodowość = pd_src.Narodowość;
                            frm1.defaultDataSet.Dystrybucja.Rows.Add(pd_row);
                            Save_DS();
                        }
                    }

                    foreach (defaultDataSet.LokZdjRow lz_src in this.defaultDataSet.LokZdj.Rows)
                    {
                        if (flm_src.ID == lz_src.IDPDB)
                        {
                            defaultDataSet.LokZdjRow lz_row = frm1.defaultDataSet.LokZdj.NewLokZdjRow();
                            lz_row.IDPDB        = Flm_id;
                            lz_row.NazwaObiektu = lz_src.NazwaObiektu;
                            lz_row.Kraj         = lz_src.Kraj;
                            lz_row.Miejscowość  = lz_src.Miejscowość;
                            lz_row.Region       = lz_src.Region;
                            lz_row.Pora_roku    = lz_src.Pora_roku;
                            lz_row.Data         = lz_src.Data;
                            //br_lz.ReadBytes(2);
                            frm1.defaultDataSet.LokZdj.Rows.Add(lz_row);
                            Save_DS();
                        }
                    }

                    foreach (defaultDataSet.WYPINRow wi_src in this.defaultDataSet.WYPIN.Rows)
                    {
                        if (flm_src.ID == wi_src.IDPDB)
                        {
                            defaultDataSet.WYPINRow wi_row = frm1.defaultDataSet.WYPIN.NewWYPINRow();
                            wi_row.IDPDB    = Flm_id;
                            wi_row.DataWyp  = wi_src.DataWyp;
                            wi_row.DataOdd  = wi_src.DataOdd;
                            wi_row.StanPWyp = wi_src.StanPWyp;
                            wi_row.StanPOdd = wi_src.StanPOdd;
                            wi_row.Osoba    = wi_src.Osoba;

                            frm1.defaultDataSet.WYPIN.Rows.Add(wi_row);
                            Save_DS();
                        }
                    }

                    foreach (defaultDataSet.WYPODINRow wo_src in this.defaultDataSet.WYPODIN.Rows)
                    {
                        if (flm_src.ID == wo_src.IDPDB)
                        {
                            defaultDataSet.WYPODINRow wo_row = frm1.defaultDataSet.WYPODIN.NewWYPODINRow();
                            wo_row.IDPDB    = Flm_id;
                            wo_row.DataWyp  = wo_src.DataWyp;
                            wo_row.DataOdd  = wo_src.DataOdd;
                            wo_row.StanPWyp = wo_src.StanPWyp;
                            wo_row.StanPOdd = wo_src.StanPOdd;
                            wo_row.Osoba    = wo_src.Osoba;

                            frm1.defaultDataSet.WYPODIN.Rows.Add(wo_row);
                            Save_DS();
                        }
                    }
                }
                Save_DS();
                MessageBox.Show("Dane zostały zaimportowane zgodnie z ustawieniami", "Biblioteka Filmów NET", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
Exemple #4
0
        private void button_IMP_Click(object sender, EventArgs e)
        {
            if (this.textBox_SelPath.Text != "")
            {
                if (this.checkBox_Film.Checked == true)
                {
                    FileStream fn_film;
                    Byte[]     unibyte;

                    if (File.Exists(this.textBox_SelPath.Text + "\\" + "BF_PDB.bf"))
                    {
                        fn_film = File.OpenRead(this.textBox_SelPath.Text + "\\" + "BF_PDB.bf");
                        BinaryReader br = new BinaryReader(fn_film, Encoding.Unicode);
                        if (fn_film.Length > 0)
                        {
                            do
                            {
                                int flm_id = br.ReadInt32();
                                //Flm_id = frm1.FindNewFilmID();
                                flm_row = frm1.defaultDataSet.Film.NewFilmRow();
                                //flm_row.ID = Flm_id;


                                flm_row.Tytul     = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 501)));
                                flm_row.TytulOrig = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 501)));
                                flm_row.Gatunek   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));

                                String path_pic = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 241)));
                                if (this.checkBox_Okl.Checked == true)
                                {
                                    if (GetFileName(path_pic).Length > 0)
                                    {
                                        if (File.Exists(path_pic))
                                        {
                                            File.Copy(path_pic, Form1.db_path + "covers" + GetFileName(path_pic), true);
                                            flm_row.pathtofront = Form1.db_path + "covers" + GetFileName(path_pic);
                                        }
                                    }
                                }
                                path_pic = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 241)));
                                if (this.checkBox_Okl.Checked == true)
                                {
                                    if (GetFileName(path_pic).Length > 0)
                                    {
                                        if (File.Exists(path_pic))
                                        {
                                            File.Copy(path_pic, Form1.db_path + "covers" + GetFileName(path_pic), true);
                                            flm_row.pathtoback = Form1.db_path + "covers" + GetFileName(path_pic);
                                        }
                                    }
                                }
                                flm_row.OW_SD   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.OW_Obs  = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.OW_Zdj  = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.OW_Wart = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.OW_ALL  = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                br.ReadBytes((8 * 2 * 501));
                                flm_row.DOE_Cena       = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 101)));
                                flm_row.DOE_WartAkt    = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 101)));
                                flm_row.DOE_DataZak    = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 21)));
                                flm_row.DOE_DataUtr    = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 21)));
                                flm_row.DOE_DataSkat   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 21)));
                                flm_row.DOE_Nośnik     = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.DOE_NrKat      = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 501)));
                                flm_row.DOE_Imie       = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 501)));
                                flm_row.DOE_Nazw       = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 501)));
                                flm_row.DOE_Adres      = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 501)));
                                flm_row.DOE_MN_Nazwa   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 501)));
                                flm_row.DOE_MN_Adres   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 501)));
                                flm_row.DOE_MN_Tel     = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 31)));
                                flm_row.DOE_MN_Email   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.DOE_MN_WWW     = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 501)));
                                flm_row.DOE_MN_Fax     = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 31)));
                                flm_row.IOF_RokProd    = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 21)));
                                flm_row.IOF_DataPrem   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 21)));
                                flm_row.IOF_CzasProj   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 51)));
                                flm_row.IOF_JezykLekt  = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 1001)));
                                flm_row.IOF_JezykNap   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 1001)));
                                flm_row.IOF_FormWysw   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 51)));
                                flm_row.IOF_SysKodObr  = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 51)));
                                flm_row.IOF_KrajProd   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 1001)));
                                flm_row.IOF_KW_Nazwa   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.IOF_KW_Typ     = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.IOF_KW_Wersja  = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.IOF_ZAB_Nazwa  = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.IOF_ZAB_Typ    = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.IOF_ZAB_Wersja = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.IOF_KA_Nazwa   = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.IOF_KA_Typ     = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                flm_row.IOF_KA_Wersja  = Strymuj(Encoding.Unicode.GetString(br.ReadBytes(2 * 201)));
                                br.ReadBytes(2);

                                if (this.checkBox_Okl.Checked == true)
                                {
                                    if (flm_row.pathtofront != "")
                                    {
                                        String fn_pic;
                                        fn_pic = GetFileName(flm_row.pathtofront);
                                        File.Copy(this.textBox_SelPath.Text + "\\covers\\" + fn_pic, Form1.db_path + "\\covers\\" + fn_pic, true);
                                    }
                                    if (flm_row.pathtoback != "")
                                    {
                                        String fn_pic;
                                        fn_pic = GetFileName(flm_row.pathtoback);
                                        File.Copy(this.textBox_SelPath.Text + "\\covers\\" + fn_pic, Form1.db_path + "\\covers\\" + fn_pic, true);
                                    }

                                    frm1.defaultDataSet.Film.Rows.Add(flm_row);
                                    Save_DS();
                                }
                                else
                                {
                                    frm1.defaultDataSet.Film.Rows.Add(flm_row);
                                    Save_DS();
                                }

                                if (this.checkBox_OC.Checked == true)
                                {
                                    if (File.Exists(this.textBox_SelPath.Text + "\\" + "BF_OC.bf"))
                                    {
                                        Flm_id = frm1.FindNewFilmID() - 1;
                                        FileStream fn_OC;
                                        fn_OC = File.OpenRead(this.textBox_SelPath.Text + "\\" + "BF_OC.bf");
                                        BinaryReader br_oc = new BinaryReader(fn_OC, Encoding.Unicode);
                                        if (fn_OC.Length > 0)
                                        {
                                            do
                                            {
                                                br_oc.ReadInt32();
                                                int oc_idpdb = br_oc.ReadInt32();
                                                if (oc_idpdb == flm_id)
                                                {
                                                    defaultDataSet.OcenaRow oc_row = frm1.defaultDataSet.Ocena.NewOcenaRow();

                                                    oc_row.IDPDB = Flm_id;
                                                    oc_row.Nazwa = Strymuj(Encoding.Unicode.GetString(br_oc.ReadBytes(2 * 201)));
                                                    oc_row.Tytul = Strymuj(Encoding.Unicode.GetString(br_oc.ReadBytes(2 * 201)));
                                                    oc_row.Autor = Strymuj(Encoding.Unicode.GetString(br_oc.ReadBytes(2 * 201)));
                                                    oc_row.WWW   = Strymuj(Encoding.Unicode.GetString(br_oc.ReadBytes(2 * 501)));
                                                    oc_row.Ocena = Strymuj(Encoding.Unicode.GetString(br_oc.ReadBytes(2 * 201)));
                                                    frm1.defaultDataSet.Ocena.Rows.Add(oc_row);
                                                    Save_DS();
                                                    br_oc.ReadBytes(2);
                                                }
                                                else
                                                {
                                                    br_oc.ReadBytes((2 * 501) + (2 * 201) + (2 * 201) + (2 * 201) + (2 * 201) + 2);
                                                }
                                            } while (fn_OC.Position < fn_OC.Length);
                                        }
                                        fn_OC.Close();
                                    }
                                }

                                if (this.checkBox_OB.Checked == true)
                                {
                                    if (File.Exists(this.textBox_SelPath.Text + "\\" + "BF_OB.bf"))
                                    {
                                        Flm_id = frm1.FindNewFilmID() - 1;
                                        FileStream fn_OB;
                                        fn_OB = File.OpenRead(this.textBox_SelPath.Text + "\\" + "BF_OB.bf");
                                        BinaryReader br_ob = new BinaryReader(fn_OB, Encoding.Unicode);
                                        if (fn_OB.Length > 0)
                                        {
                                            do
                                            {
                                                br_ob.ReadInt32();
                                                int ob_idpdb = br_ob.ReadInt32();
                                                if (ob_idpdb == flm_id)
                                                {
                                                    defaultDataSet.ObsadaRow ob_row = frm1.defaultDataSet.Obsada.NewObsadaRow();

                                                    ob_row.IDPDB    = Flm_id;
                                                    ob_row.ImieNazw = Strymuj(Encoding.Unicode.GetString(br_ob.ReadBytes(2 * 501)));
                                                    ob_row.Rola     = Strymuj(Encoding.Unicode.GetString(br_ob.ReadBytes(2 * 201)));

                                                    frm1.defaultDataSet.Obsada.Rows.Add(ob_row);
                                                    Save_DS();
                                                }
                                                else
                                                {
                                                    br_ob.ReadBytes((2 * 501) + (2 * 201));
                                                }
                                            } while (fn_OB.Position < fn_OB.Length);
                                        }
                                        fn_OB.Close();
                                    }
                                }

                                if (this.checkBox_PP.Checked == true)
                                {
                                    if (File.Exists(this.textBox_SelPath.Text + "\\" + "BF_PRB.bf"))
                                    {
                                        Flm_id = frm1.FindNewFilmID() - 1;
                                        FileStream fn_PP;
                                        fn_PP = File.OpenRead(this.textBox_SelPath.Text + "\\" + "BF_PRB.bf");
                                        BinaryReader br_pp = new BinaryReader(fn_PP, Encoding.Unicode);
                                        if (fn_PP.Length > 0)
                                        {
                                            do
                                            {
                                                br_pp.ReadInt32();
                                                int pp_idpdb = br_pp.ReadInt32();
                                                if (pp_idpdb == flm_id)
                                                {
                                                    defaultDataSet.ProdukcjaRow pp_row = frm1.defaultDataSet.Produkcja.NewProdukcjaRow();
                                                    pp_row.IDPDB      = Flm_id;
                                                    pp_row.Nazwa      = Strymuj(Encoding.Unicode.GetString(br_pp.ReadBytes(2 * 501)));
                                                    pp_row.Adres      = Strymuj(Encoding.Unicode.GetString(br_pp.ReadBytes(2 * 501)));
                                                    pp_row.Tel        = Strymuj(Encoding.Unicode.GetString(br_pp.ReadBytes(2 * 31)));
                                                    pp_row.Fax        = Strymuj(Encoding.Unicode.GetString(br_pp.ReadBytes(2 * 31)));
                                                    pp_row.Email      = Strymuj(Encoding.Unicode.GetString(br_pp.ReadBytes(2 * 201)));
                                                    pp_row.WWW        = Strymuj(Encoding.Unicode.GetString(br_pp.ReadBytes(2 * 501)));
                                                    pp_row.Narodowość = Strymuj(Encoding.Unicode.GetString(br_pp.ReadBytes(2 * 201)));
                                                    frm1.defaultDataSet.Produkcja.Rows.Add(pp_row);
                                                    Save_DS();
                                                    br_pp.ReadBytes(2);
                                                }
                                                else
                                                {
                                                    br_pp.ReadBytes((3 * (2 * 501)) + (2 * (2 * 201)) + (2 * (2 * 31)) + 2);
                                                }
                                            } while (fn_PP.Position < fn_PP.Length);
                                        }
                                        fn_PP.Close();
                                    }
                                }

                                if (this.checkBox_PD.Checked == true)
                                {
                                    if (File.Exists(this.textBox_SelPath.Text + "\\" + "BF_PRD.bf"))
                                    {
                                        Flm_id = frm1.FindNewFilmID() - 1;
                                        FileStream fn_PD;
                                        fn_PD = File.OpenRead(this.textBox_SelPath.Text + "\\" + "BF_PRD.bf");
                                        BinaryReader br_pd = new BinaryReader(fn_PD, Encoding.Unicode);
                                        if (fn_PD.Length > 0)
                                        {
                                            do
                                            {
                                                br_pd.ReadInt32();
                                                int pd_idpdb = br_pd.ReadInt32();
                                                if (pd_idpdb == flm_id)
                                                {
                                                    defaultDataSet.DystrybucjaRow pd_row = frm1.defaultDataSet.Dystrybucja.NewDystrybucjaRow();
                                                    pd_row.IDPDB      = Flm_id;
                                                    pd_row.Nazwa      = Strymuj(Encoding.Unicode.GetString(br_pd.ReadBytes(2 * 501)));
                                                    pd_row.Adres      = Strymuj(Encoding.Unicode.GetString(br_pd.ReadBytes(2 * 501)));
                                                    pd_row.Tel        = Strymuj(Encoding.Unicode.GetString(br_pd.ReadBytes(2 * 31)));
                                                    pd_row.Fax        = Strymuj(Encoding.Unicode.GetString(br_pd.ReadBytes(2 * 31)));
                                                    pd_row.Email      = Strymuj(Encoding.Unicode.GetString(br_pd.ReadBytes(2 * 201)));
                                                    pd_row.WWW        = Strymuj(Encoding.Unicode.GetString(br_pd.ReadBytes(2 * 501)));
                                                    pd_row.Narodowość = Strymuj(Encoding.Unicode.GetString(br_pd.ReadBytes(2 * 201)));
                                                    frm1.defaultDataSet.Dystrybucja.Rows.Add(pd_row);
                                                    Save_DS();
                                                    br_pd.ReadBytes(2);
                                                }
                                                else
                                                {
                                                    br_pd.ReadBytes((3 * (2 * 501)) + (2 * (2 * 201)) + (2 * (2 * 31)) + 2);
                                                }
                                            } while (fn_PD.Position < fn_PD.Length);
                                        }
                                        fn_PD.Close();
                                    }
                                }

                                if (this.checkBox_LZ.Checked == true)
                                {
                                    if (File.Exists(this.textBox_SelPath.Text + "\\" + "BF_LZ.bf"))
                                    {
                                        Flm_id = frm1.FindNewFilmID() - 1;
                                        FileStream fn_LZ;
                                        fn_LZ = File.OpenRead(this.textBox_SelPath.Text + "\\" + "BF_LZ.bf");
                                        BinaryReader br_lz = new BinaryReader(fn_LZ, Encoding.Unicode);
                                        if (fn_LZ.Length > 0)
                                        {
                                            do
                                            {
                                                br_lz.ReadInt32();
                                                int lz_idpdb = br_lz.ReadInt32();
                                                if (lz_idpdb == flm_id)
                                                {
                                                    defaultDataSet.LokZdjRow lz_row = frm1.defaultDataSet.LokZdj.NewLokZdjRow();
                                                    lz_row.IDPDB        = Flm_id;
                                                    lz_row.NazwaObiektu = Strymuj(Encoding.Unicode.GetString(br_lz.ReadBytes(2 * 501)));
                                                    lz_row.Kraj         = Strymuj(Encoding.Unicode.GetString(br_lz.ReadBytes(2 * 501)));
                                                    lz_row.Miejscowość  = Strymuj(Encoding.Unicode.GetString(br_lz.ReadBytes(2 * 501)));
                                                    lz_row.Region       = Strymuj(Encoding.Unicode.GetString(br_lz.ReadBytes(2 * 501)));
                                                    lz_row.Pora_roku    = Strymuj(Encoding.Unicode.GetString(br_lz.ReadBytes(2 * 501)));
                                                    lz_row.Data         = Strymuj(Encoding.Unicode.GetString(br_lz.ReadBytes(2 * 21)));

                                                    frm1.defaultDataSet.LokZdj.Rows.Add(lz_row);
                                                    Save_DS();
                                                    //br_lz.ReadBytes(2);
                                                }
                                                else
                                                {
                                                    br_lz.ReadBytes((5 * (2 * 501)) + (2 * 21));
                                                }
                                            } while (fn_LZ.Position < fn_LZ.Length);
                                        }
                                        fn_LZ.Close();
                                    }
                                }

                                if (this.checkBox_WIO.Checked == true)
                                {
                                    if (File.Exists(this.textBox_SelPath.Text + "\\" + "BF_WI.bf"))
                                    {
                                        Flm_id = frm1.FindNewFilmID() - 1;
                                        FileStream fn_WI;
                                        fn_WI = File.OpenRead(this.textBox_SelPath.Text + "\\" + "BF_WI.bf");
                                        BinaryReader br_wi = new BinaryReader(fn_WI, Encoding.Unicode);
                                        if (fn_WI.Length > 0)
                                        {
                                            do
                                            {
                                                br_wi.ReadInt32();
                                                int wi_idpdb = br_wi.ReadInt32();
                                                if (wi_idpdb == flm_id)
                                                {
                                                    defaultDataSet.WYPINRow wi_row = frm1.defaultDataSet.WYPIN.NewWYPINRow();
                                                    wi_row.IDPDB    = Flm_id;
                                                    wi_row.DataWyp  = Strymuj(Encoding.Unicode.GetString(br_wi.ReadBytes(2 * 21)));
                                                    wi_row.DataOdd  = Strymuj(Encoding.Unicode.GetString(br_wi.ReadBytes(2 * 21)));
                                                    wi_row.StanPWyp = Strymuj(Encoding.Unicode.GetString(br_wi.ReadBytes(2 * 501)));
                                                    wi_row.StanPOdd = Strymuj(Encoding.Unicode.GetString(br_wi.ReadBytes(2 * 501)));
                                                    wi_row.Osoba    = Strymuj(Encoding.Unicode.GetString(br_wi.ReadBytes(2 * 501)));
                                                    Encoding.Unicode.GetString(br_wi.ReadBytes(2 * 501));

                                                    frm1.defaultDataSet.WYPIN.Rows.Add(wi_row);
                                                    Save_DS();
                                                    //br_wi.ReadBytes(2);
                                                }
                                                else
                                                {
                                                    br_wi.ReadBytes((3 * (2 * 501)) + (2 * (2 * 21)));
                                                }
                                            } while (fn_WI.Position < fn_WI.Length);
                                        }
                                        fn_WI.Close();
                                    }
                                }

                                if (this.checkBox_WOI.Checked == true)
                                {
                                    if (File.Exists(this.textBox_SelPath.Text + "\\" + "BF_WO.bf"))
                                    {
                                        Flm_id = frm1.FindNewFilmID() - 1;
                                        FileStream fn_WO;
                                        fn_WO = File.OpenRead(this.textBox_SelPath.Text + "\\" + "BF_WO.bf");
                                        BinaryReader br_wo = new BinaryReader(fn_WO, Encoding.Unicode);
                                        if (fn_WO.Length > 0)
                                        {
                                            do
                                            {
                                                br_wo.ReadInt32();
                                                int wo_idpdb = br_wo.ReadInt32();
                                                if (wo_idpdb == flm_id)
                                                {
                                                    defaultDataSet.WYPODINRow wo_row = frm1.defaultDataSet.WYPODIN.NewWYPODINRow();
                                                    wo_row.IDPDB    = Flm_id;
                                                    wo_row.DataWyp  = Strymuj(Encoding.Unicode.GetString(br_wo.ReadBytes(2 * 21)));
                                                    wo_row.DataOdd  = Strymuj(Encoding.Unicode.GetString(br_wo.ReadBytes(2 * 21)));
                                                    wo_row.StanPWyp = Strymuj(Encoding.Unicode.GetString(br_wo.ReadBytes(2 * 501)));
                                                    wo_row.StanPOdd = Strymuj(Encoding.Unicode.GetString(br_wo.ReadBytes(2 * 501)));
                                                    wo_row.Osoba    = Strymuj(Encoding.Unicode.GetString(br_wo.ReadBytes(2 * 501)));
                                                    Encoding.Unicode.GetString(br_wo.ReadBytes(2 * 501));
                                                    //br_wo.ReadBytes(2);
                                                    frm1.defaultDataSet.WYPODIN.Rows.Add(wo_row);
                                                    Save_DS();
                                                }
                                                else
                                                {
                                                    br_wo.ReadBytes((3 * (2 * 501)) + (2 * (2 * 21)));
                                                }
                                            } while (fn_WO.Position < fn_WO.Length);
                                        }
                                        fn_WO.Close();
                                    }
                                }
                            } while (fn_film.Position < fn_film.Length);
                        }

                        fn_film.Close();
                    }



                    MessageBox.Show("Dane zostały zaimportowane zgodnie z wybranymi ustawieniami", "Biblioteka Filmów NET", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }