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; }
private void button1_Click(object sender, EventArgs e) { Anime_ArchiveDataSetTableAdapters.files_aTableAdapter da_files = new Anime_ArchiveDataSetTableAdapters.files_aTableAdapter(); da_files.Delete(5); da_files.Update(anime_ArchiveDataSet.files_a); }
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(); }
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); }
public void AddToList(string path) { Anime_ArchiveDataSetTableAdapters.files_aTableAdapter files_a = new Anime_ArchiveDataSetTableAdapters.files_aTableAdapter(); int count = 0; string[] ext = { ".mkv", ".mp4", ".avi", ".wmv", ".ogm", ".mpg" }; string all_name = ""; DirectoryInfo di = new DirectoryInfo(path); DirectoryInfo[] di_parent = di.GetDirectories("*", SearchOption.TopDirectoryOnly); for (int i = 0; i < di_parent.Length; i++) { string path_di = di_parent[i].FullName; path_di = path_di.Replace("[", "/["); path_di = path_di.Replace("]", "/]"); int col = (int)files_a.GetExistsFiles("%" + path_di + "%"); FileInfo[] finfo = di_parent[i].GetFiles("*", SearchOption.AllDirectories); for (int j = 0; j < finfo.Length; j++) { if ((finfo[j].Extension.ToLower() == ext[0]) || (finfo[j].Extension.ToLower() == ext[1]) || (finfo[j].Extension.ToLower() == ext[2]) || (finfo[j].Extension.ToLower() == ext[3]) || (finfo[j].Extension.ToLower() == ext[4]) || (finfo[j].Extension.ToLower() == ext[5])) { all_name = RemoveTags(GetNameOnly(finfo[j].Name)); string temp = ""; for (int k = j + 1; k < finfo.Length; k++) { if ((finfo[k].Extension == ext[0]) || (finfo[k].Extension == ext[1]) || (finfo[k].Extension == ext[2]) || (finfo[k].Extension == ext[3]) || (finfo[k].Extension == ext[4]) || (finfo[k].Extension == ext[5])) { string t_name = RemoveTags(GetNameOnly(finfo[k].Name)); for (int p = 0; p < all_name.Length; p++) { int ind = t_name.IndexOf(all_name[p]); if (ind != -1) { temp += all_name[p]; t_name = t_name.Remove(ind, 1); } else { temp += "?"; } } all_name = temp; temp = ""; } } break; } } string tr = TrimQuestinos(all_name); int col2 = (int)files_a.GetExistsFiles("%" + TrimQuestinos(all_name) + "%"); string podkatalog; string polu; di = new DirectoryInfo(di_parent[i].FullName); DirectoryInfo[] subcatalog = di.GetDirectories("*", SearchOption.TopDirectoryOnly); if (subcatalog.Length > 1) { podkatalog = "Да"; polu = "Получить (есть подкаталог)"; } else { podkatalog = "Нет"; polu = "Получить"; } if (col > 0) { dataGridView1.Rows.Add(di_parent[i].Name, "Да", polu, "Удалить", di_parent[i].FullName, podkatalog); dataGridView1.Rows[count].DefaultCellStyle.BackColor = Color.Green; } else { dataGridView1.Rows.Add(di_parent[i].Name, "Нет", polu, "Удалить", di_parent[i].FullName, podkatalog); if (col2 > 0) { dataGridView1.Rows[count].DefaultCellStyle.BackColor = Color.LightYellow; } } count++; } }