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)) + ")");
}
