public bool SaveChanges() { ArrayList arrayList = new ArrayList(); if (Changes.Count > 0) { if (Changes.Contains("Name")) { arrayList.Add("name='" + SQL.Prepare(iName) + "'"); } if (Changes.Contains("Type")) { arrayList.Add("type=" + iType); Changes.Remove("Type"); } CC.SQL.ExecQuery("UPDATE series SET " + string.Join(",", CC.StringList(arrayList)) + " WHERE id=" + ID); if (Settings.Default.OrganizeMethod != 0) { if (Changes.Contains("Name")) { //Rename folders string text = Settings.Default.LibraryDir + "\\" + CC.URLize(PublisherName) + "\\" + CC.URLize(GroupName) + "\\" + CC.URLize(OldName) + "\\"; string text2 = Settings.Default.LibraryDir + "\\" + CC.URLize(PublisherName) + "\\" + CC.URLize(GroupName) + "\\" + CC.URLize(Name) + "\\"; CC.SQL.ExecQuery("UPDATE issues SET filename=" + CC.SQLReplaceLeft("filename", text, text2)); CC.Rename(text, text2); } Changes.Remove("Name"); } return(true); } return(false); }
private void cboDefaultGroup_SelectedIndexChanged(object sender, EventArgs e) { ArrayList arrayList = new ArrayList(); if (cboDefaultGroup.Text != "") { int iD = ComicGroup.GetID(cboDefaultGroup.Text); arrayList.Add("group_id=" + iD); } if (cboDefaultPublisher.Text != "") { int iD2 = ComicPublisher.GetID(cboDefaultPublisher.Text); arrayList.Add("pub_id=" + iD2); } cboDefaultSeries.Items.Clear(); cboDefaultSeries.Items.Add(""); string str = ""; if (arrayList.Count > 0) { str = "WHERE " + string.Join(" AND ", CC.StringList(arrayList)); } Query query = CC.SQL.ExecQuery("SELECT name FROM series " + str); while (query.NextResult()) { cboDefaultSeries.Items.Add(query.hash["name"]); } }
public bool SaveChanges() { ArrayList arrayList = new ArrayList(); //SQL sQL = new SQL(); if (Changes.Count > 0) { if (Changes.Contains("Name")) { arrayList.Add("name='" + SQL.Prepare(iName) + "'"); } if (Changes.Contains("PublisherID")) { arrayList.Add("pub_id='" + iPublisherID + "'"); CC.SQL.ExecQuery("UPDATE series SET pub_id=" + iPublisherID + " WHERE group_id=" + ID); } CC.SQL.ExecQuery("UPDATE groups SET " + string.Join(",", CC.StringList(arrayList)) + " WHERE id=" + ID); if (Settings.Default.OrganizeMethod != 0) { Query query = CC.SQL.ExecQuery("SELECT name FROM publishers WHERE id=" + PublisherID); query.NextResult(); string name = (string)query.hash[0]; query.Close(); if (Changes.Contains("Name")) { string text = Settings.Default.LibraryDir + "\\" + CC.URLize(name) + "\\" + CC.URLize(OldName) + "\\"; string text2 = Settings.Default.LibraryDir + "\\" + CC.URLize(name) + "\\" + CC.URLize(Name) + "\\"; CC.SQL.ExecQuery("UPDATE issues SET filename=" + CC.SQLReplaceLeft("filename", text, text2)); CC.Rename(text, text2); } if (Changes.Contains("PublisherID")) { query = CC.SQL.ExecQuery("SELECT name FROM publishers WHERE id=" + OldPublisherID); query.NextResult(); string name2 = (string)query.hash[0]; query.Close(); string text = Settings.Default.LibraryDir + "\\" + CC.URLize(name2) + "\\" + CC.URLize(Name) + "\\"; string text2 = Settings.Default.LibraryDir + "\\" + CC.URLize(name) + "\\" + CC.URLize(Name) + "\\"; CC.SQL.ExecQuery("UPDATE issues SET filename=" + CC.SQLReplaceLeft("filename", text, text2)); CC.Rename(text, text2); } } Changes.Remove("Name"); Changes.Remove("PublisherID"); return(true); } return(false); }
//Unimplemented Smart Readlist feature public string SmartSQL() { if (Smart) { ArrayList arrayList = new ArrayList(); SQL sQL = new SQL(); Query query = sQL.ExecQuery("SELECT * FROM readlist_smart WHERE list_id=" + ID); while (query.NextResult()) { arrayList.Add((string)query.hash["prop"] + " " + (string)query.hash["op"] + " " + (string)query.hash["val"]); } return(string.Join(" AND ", CC.StringList(arrayList))); } return(""); }
public bool SaveChanges() { ArrayList arrayList = new ArrayList(); if (Changes.Count > 0) { if (Changes.Contains("Name")) { arrayList.Add("name='" + SQL.Prepare(iName) + "'"); Changes.Remove("Name"); } CC.SQL.ExecQuery("UPDATE publishers SET " + string.Join(",", CC.StringList(arrayList)) + " WHERE id=" + ID); return(true); } return(false); }
public new bool SaveChanges() { base.SaveChanges(); if (Changes.Count > 0) { ArrayList arrayList = new ArrayList(); if (Changes.Contains("Position")) { arrayList.Add("pos='" + iPosition + "'"); Changes.Remove("Position"); } CC.SQL.ExecQuery("UPDATE readlist_issues SET " + string.Join(",", CC.StringList(arrayList)) + " WHERE id=" + RowID); return(true); } return(false); }
//Handle the assignment of groups to publisher, including moving directories public void AdoptGroups(ArrayList Groups) { SQL sQL = new SQL(); string text = Settings.Default.LibraryDir + "\\" + Name + "\\"; string text2 = ""; if (Settings.Default.OrganizeMethod != 0) { foreach (ComicSeries Group in Groups) { text2 = Settings.Default.LibraryDir + "\\" + Group.PublisherName + "\\"; sQL.ExecQuery("UPDATE issues SET filename=" + CC.SQLReplaceLeft("filename", text2, text) + " WHERE series_id=" + Group.ID); Directory.Move(text2 + Group.Name + "\\", text + Group.Name + "\\"); } } sQL.ExecQuery("UPDATE series SET group_id=" + ID + " WHERE series_id IN (" + string.Join(",", CC.StringList(Groups)) + ")"); }
public bool SaveChanges() { SQL sQL = new SQL(); if (ID != -1) { if (Changes.Count > 0) { ArrayList arrayList = new ArrayList(); if (Changes.Contains("FileSize")) { arrayList.Add("filesize=" + iFileSize); Changes.Remove("FileSize"); } if (Changes.Contains("FileName")) { arrayList.Add("filename='" + SQL.Prepare(iFileName) + "', undo_filename='" + SQL.Prepare(UndoFilename) + "'"); Changes.Remove("FileName"); } if (Changes.Contains("Number")) { arrayList.Add("issue_no=" + iNumber); Changes.Remove("Number"); } if (Changes.Contains("Type")) { arrayList.Add("type=" + iType); Changes.Remove("Type"); } if (Changes.Contains("Name")) { arrayList.Add("name='" + SQL.Prepare(iName) + "'"); Changes.Remove("Name"); } if (Changes.Contains("Published")) { arrayList.Add("published='" + iPublished.ToString() + "'"); Changes.Remove("Published"); } if (Changes.Contains("SeriesVolume")) { arrayList.Add("series_vol=" + iSeriesVolume); Changes.Remove("Published"); } if (Changes.Contains("Missing")) { arrayList.Add("missing=" + iMissing.ToString()); Changes.Remove("Missing"); } if (Changes.Contains("Comments")) { arrayList.Add("comments='" + SQL.Prepare(iComments) + "'"); Changes.Remove("Comments"); } if (Changes.Contains("Marked")) { arrayList.Add("marked=" + iMarked.ToString()); Changes.Remove("Marked"); Status = ((!iMissing) ? (iMarked ? 1 : (-1)) : 0); } if (Changes.Contains("Pages")) { arrayList.Add("pages=" + iPages); Changes.Remove("Pages"); } if (Changes.Contains("SeriesID")) { arrayList.Add("series_id=" + iSeriesID); Changes.Remove("SeriesID"); } if (Changes.Contains("MD5")) { arrayList.Add("MD5='" + iMD5 + "'"); Changes.Remove("MD5"); } if (arrayList.Count > 0) { CC.SQL.ExecQuery("UPDATE issues SET " + string.Join(",", CC.StringList(arrayList)) + " WHERE id=" + Convert.ToString(ID)); } GetStatus(); return true; } return false; } string query = "INSERT INTO issues (issue_no, name, series_id, series_vol, filesize, filename, undo_filename, pages, type, date_added, MD5, comments) VALUES (" + Number + ", '" + SQL.Prepare(Name) + "', " + SeriesID + ", " + SeriesVolume + ", " + FileSize + ", '" + SQL.Prepare(FileName) + "', '', " + Pages + ", " + Type + ", NOW(), '" + MD5 + "', '" + SQL.Prepare(Comments) + "')"; sQL.ExecQuery(query); Query query2 = sQL.ExecQuery("SELECT id FROM issues WHERE filename='" + SQL.Prepare(FileName) + "'"); query2.NextResult(); ID = (int)query2.hash["id"]; query2.Close(); GetInfo(); return true; }
public void AdoptSeries(ArrayList Series) { SQL sQL = new SQL(); string text = Settings.Default.LibraryDir + "\\" + CC.URLize(PublisherName) + "\\" + CC.URLize(Name); string text2 = ""; ArrayList arrayList = new ArrayList(); foreach (ComicSeries item in Series) { if (Settings.Default.OrganizeMethod != 0) { text2 = Settings.Default.LibraryDir + "\\" + CC.URLize(item.PublisherName) + "\\" + CC.URLize(item.GroupName); sQL.ExecQuery("UPDATE issues SET filename=" + CC.SQLReplaceLeft("filename", text2, text) + " WHERE series_id=" + item.ID); try { Directory.Move(text2 + "\\" + CC.URLize(item.Name), text + "\\" + CC.URLize(item.Name)); } catch { } } arrayList.Add(Convert.ToString(item.ID)); item.GroupID = ID; item.GroupName = Name; } sQL.ExecQuery("UPDATE series SET group_id=" + ID + ", pub_id=" + PublisherID + " WHERE id IN (" + string.Join(",", CC.StringList(arrayList)) + ")"); }