Example #1
0
        public bool UpdateData(int Idx, int CollectionFileId, int CollectionId, string FileName, string FileUrl,
                               int ListOrder, string Description, string Tags, string Status, DateTime CreatedOnDate, string IPLog, string UserLog, string UserLastUpdate)
        {
            using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
            {
                context.DeferredLoadingEnabled = false;
                Gallery_File file = new Gallery_File();
                file.FileId            = Idx;
                file.FileName          = FileName;
                file.FileUrl           = FileUrl;
                file.Description       = Description;
                file.ListOrder         = ListOrder;
                file.UserLog           = Guid.Parse(UserLog);
                file.UserLastUpdate    = Guid.Parse(UserLastUpdate);
                file.CreatedOnDate     = CreatedOnDate;
                file.LastModifieddDate = System.DateTime.Now;
                file.Status            = Convert.ToChar(Status);
                file.Tags         = Tags;
                file.IPLog        = IPLog;
                file.IPLastUpdate = IP;

                ChangeSet changeSet   = null;
                int       changeCount = 0;
                context.Gallery_Files.Attach(file);
                context.Refresh(RefreshMode.KeepCurrentValues, file);
                changeSet   = context.GetChangeSet();
                changeCount = changeSet.Updates.Count;
                context.SubmitChanges();

                bool result = false;
                if (changeCount > 0)
                {
                    Gallery_Collection_File collection_file = new Gallery_Collection_File();
                    collection_file.CollectionFileId = CollectionFileId;
                    collection_file.CollectionId     = CollectionId;
                    collection_file.FileId           = Idx;

                    context.Gallery_Collection_Files.Attach(collection_file);
                    context.Refresh(RefreshMode.KeepCurrentValues, collection_file);
                    context.SubmitChanges();
                    result = true;
                }
                return(result);
            }
        }
Example #2
0
        public bool UpdateData(int Idx, int TopicId, string Title, string IconFile, string Description, int ListOrder, string Tags, string Url,
                               string UserLog, string UserLastUpdate, DateTime CreatedOnDate, string IPLog, string Status)
        {
            using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
            {
                context.Connection.Open();
                Gallery_Collection collection_obj = new Gallery_Collection();
                collection_obj.CollectionId      = Idx;
                collection_obj.TopicId           = TopicId;
                collection_obj.Title             = Title;
                collection_obj.IconFile          = IconFile;
                collection_obj.Description       = Description;
                collection_obj.ListOrder         = ListOrder;
                collection_obj.UserLog           = Guid.Parse(UserLog);
                collection_obj.UserLastUpdate    = Guid.Parse(UserLastUpdate);
                collection_obj.CreatedOnDate     = CreatedOnDate;
                collection_obj.LastModifieddDate = DateTime.Now;
                collection_obj.Status            = Convert.ToChar(Status);
                collection_obj.Tags         = Tags;
                collection_obj.Url          = Url;
                collection_obj.IPLog        = IPLog;
                collection_obj.IPLastUpdate = IP;

                ChangeSet     changeSet   = null;
                int           changeCount = 0;
                DbTransaction trans       = context.Connection.BeginTransaction();
                try
                {
                    context.Transaction = trans;
                    context.Gallery_Collections.Attach(collection_obj);
                    context.Refresh(RefreshMode.KeepCurrentValues, collection_obj);
                    changeSet   = context.GetChangeSet();
                    changeCount = changeSet.Updates.Count;
                    context.SubmitChanges();

                    trans.Commit();
                }
                catch (Exception ex)
                {
                    if (trans != null)
                    {
                        trans.Rollback();
                    }
                    throw ex;
                }
                finally
                {
                    if (context.Connection != null && context.Connection.State == System.Data.ConnectionState.Open)
                    {
                        context.Connection.Close();
                    }
                }

                if (changeCount > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }