Beispiel #1
0
        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);
        }
Beispiel #2
0
        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);
        }