Пример #1
0
 private DataTable GetInfoAnime(string name, string season)
 {
     Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter da_spisok = new Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter();
     DataTable dt = da_spisok.GetDataByNameAndSeason(name, season);
     return dt;
 }
Пример #2
0
 private int GetIdSpisok(string name, string season)
 {
     Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter da_spisok = new Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter();
     int kod = (int)da_spisok.GetIdByNameAndSeason(name, season);
     return kod;
 }
Пример #3
0
 private DataTable GetFilesList(string name, string season)
 {
     Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter da_spisok = new Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter();
     Anime_ArchiveDataSetTableAdapters.files_aTableAdapter da_files = new Anime_ArchiveDataSetTableAdapters.files_aTableAdapter();
     int kod = (int)da_spisok.GetIdByNameAndSeason(name, season);
     DataTable dt = da_files.GetFilesData(kod);
     return dt;
 }
Пример #4
0
        public void LoadDataToListView()
        {
            Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter da_spisok = new Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter();
            DataTable dt = da_spisok.GetFullDataFromSpisok();
            listView1.Items.Clear();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                bool hent = false;
                DataTable info_anime = GetInfoAnime(dt.Rows[i]["name"].ToString(), dt.Rows[i]["season"].ToString());
                if (info_anime.Rows[0]["Zhanr"].ToString().IndexOf("хентай") != -1)
                    hent = true;
                if (toolStripComboBox1.Text == "Все")
                {
                    ListViewItem lvi = new ListViewItem();
                    lvi.Text = dt.Rows[i]["name"].ToString();
                    lvi.SubItems.Add(dt.Rows[i]["season"].ToString());
                    lvi.SubItems.Add(dt.Rows[i]["series"].ToString());
                    lvi.SubItems.Add(info_anime.Rows[0]["god"].ToString());
                    listView1.Items.Add(lvi);
                }
                else if (toolStripComboBox1.Text == "Исключить хентай")
                {
                    if (hent)
                        continue;
                    else
                    {
                        ListViewItem lvi = new ListViewItem();
                        lvi.Text = dt.Rows[i]["name"].ToString();
                        lvi.SubItems.Add(dt.Rows[i]["season"].ToString());
                        lvi.SubItems.Add(dt.Rows[i]["series"].ToString());
                        lvi.SubItems.Add(info_anime.Rows[0]["god"].ToString());
                        listView1.Items.Add(lvi);
                    }
                }
                else if (toolStripComboBox1.Text == "Только хентай")
                {
                    if (!hent)
                        continue;
                    else
                    {
                        ListViewItem lvi = new ListViewItem();
                        lvi.Text = dt.Rows[i]["name"].ToString();
                        lvi.SubItems.Add(dt.Rows[i]["season"].ToString());
                        lvi.SubItems.Add(dt.Rows[i]["series"].ToString());
                        lvi.SubItems.Add(info_anime.Rows[0]["god"].ToString());
                        listView1.Items.Add(lvi);
                    }
                }

            }
        }
Пример #5
0
 public void DeleteRecord(string name, string season)
 {
     Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter da_spisok = new Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter();
     Anime_ArchiveDataSetTableAdapters.files_aTableAdapter da_files = new Anime_ArchiveDataSetTableAdapters.files_aTableAdapter();
     Anime_ArchiveDataSetTableAdapters.info_aTableAdapter da_info = new Anime_ArchiveDataSetTableAdapters.info_aTableAdapter();
     int id_spisok = (int)da_spisok.GetIdByNameAndSeason(name, season);
     int id_info = (int)da_spisok.GetInfoEntry(id_spisok);
     da_files.Delete(id_spisok);
     da_info.Delete(id_info);
     da_spisok.Delete(id_spisok);
     da_files.Update(anime_ArchiveDataSet.files_a);
     da_info.Update(anime_ArchiveDataSet.info_a);
     da_spisok.Update(anime_ArchiveDataSet.Spisok_a);
 }
Пример #6
0
        private void button5_Click(object sender, EventArgs e)
        {
            MemoryStream ms = new MemoryStream();
            Bitmap bmp;
            Anime_ArchiveDataSet anim_DataSet = new Anime_ArchiveDataSet();
            DataRow dr_spis = anim_DataSet.Spisok_a.NewRow();
            dr_spis["name"] = textBox1.Text;
            dr_spis["season"] = textBox5.Text;
            dr_spis["series"] = textBox3.Text;
            DataRow dr_info = anim_DataSet.info_a.NewRow();
            dr_info["Zhanr"] = GetZhanr();
            dr_info["Opisanie"] = textBox4.Text;
            bmp = new Bitmap(pictureBox1.Image);
            bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
            dr_info["img"] = ReadBytesFromImage(ms);
            dr_info["god"] = textBox2.Text;
               //  dr_info.ItemArray
            anim_DataSet.info_a.Rows.Add(dr_info);
            Anime_ArchiveDataSetTableAdapters.info_aTableAdapter info_ta = new Anime_ArchiveDataSetTableAdapters.info_aTableAdapter();
            Anime_ArchiveDataSetTableAdapters.files_aTableAdapter files_ta = new Anime_ArchiveDataSetTableAdapters.files_aTableAdapter();
            Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter spis_ta = new Anime_ArchiveDataSetTableAdapters.Spisok_aTableAdapter();
            info_ta.Update(anim_DataSet.info_a);
            int Id_info = Convert.ToInt32(info_ta.GetLastID());
            dr_spis["info"] = Id_info;
            anim_DataSet.Spisok_a.Rows.Add(dr_spis);
            spis_ta.Update(anim_DataSet.Spisok_a);
            int id_spisok = Convert.ToInt32(spis_ta.GetLastIdForSpisok());

            for (int i = 0; i < s_video.Length; i++)
            {
                DataRow dr_files = anim_DataSet.files_a.NewRow();
                dr_files["gruppa"] = id_spisok;
                dr_files["Nomer_s"] = s_video[i].seria;
                dr_files["name_s"] = s_video[i].filename;
                dr_files["path_s"] = s_video[i].filepath;
                anim_DataSet.files_a.Rows.Add(dr_files);
            }

               // anim_DataSet.AcceptChanges();

            //    Anime_ArchiveDataSetTableAdapters.TableAdapterManager ta = new Anime_ArchiveDataSetTableAdapters.TableAdapterManager();
            //int aaa = ta.UpdateAll(anim_DataSet);
            files_ta.Update(anim_DataSet.files_a);
            if (From_all)
            {
                Form_add_all_catalog f_add_all = (Form_add_all_catalog)this.Owner;
                f_add_all.progress = true;
            }
            else
            {
                Form1 f_owner = (Form1)this.Owner;
                f_owner.LoadDataToListView();
            }

            Close();
        }