public Gallery_Collection GetDetails(int Idx) { using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString)){ context.CommandTimeout = Settings.CommandTimeout; Gallery_Collection collection = context.Gallery_Collections.Where(p => p.CollectionId == Idx).SingleOrDefault(); return(collection); } }
public void Delete(int Idx) { using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString)) { context.CommandTimeout = Settings.CommandTimeout; context.DeferredLoadingEnabled = false; Gallery_Collection collection_obj = context.Gallery_Collections.Single(p => p.CollectionId == Idx); context.Gallery_Collections.DeleteOnSubmit(collection_obj); context.SubmitChanges(); } }
public bool InsertData(int TopicId, string Title, string IconFile, string Description, string Tags, string Url, string UserLog, string Status) { using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString)) { System.Nullable <Int32> ListOrder = (int?)context.Gallery_Collections.Max(x => (int?)x.CollectionId) ?? 0; Gallery_Collection collection = new Gallery_Collection(); collection.TopicId = TopicId; collection.Title = Title; collection.IconFile = IconFile; collection.Description = Description; collection.ListOrder = ListOrder + 1; collection.UserLog = Guid.Parse(UserLog); collection.UserLastUpdate = Guid.Parse(UserLog); collection.CreatedOnDate = System.DateTime.Now; collection.LastModifieddDate = System.DateTime.Now; collection.Status = Convert.ToChar(Status); collection.Tags = Tags; collection.Url = Url; collection.IPLog = IP; collection.IPLastUpdate = IP; context.Gallery_Collections.InsertOnSubmit(collection); context.SubmitChanges(); int newCollectionId = collection.CollectionId; if (newCollectionId > 0) { return(true); } else { return(false); } } }
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); } } }
partial void DeleteGallery_Collection(Gallery_Collection instance);
partial void UpdateGallery_Collection(Gallery_Collection instance);
partial void InsertGallery_Collection(Gallery_Collection instance);