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