public override void InsertFile(UploadedFile entity) { if (entity == null) throw new ArgumentNullException("entity"); entity.ApplicationName = this.ApplicationName; using (var db = new SqlUploadStorageContext(this.ConnectionStringName)) { db.UploadedFiles.Add(entity); db.SaveChanges(); } }
public override void UpdateFile(UploadedFile entity) { if (entity == null) throw new ArgumentNullException("entity"); using (var db = new SqlUploadStorageContext(this.ConnectionStringName)) { db.UploadedFiles.Attach(entity); var entry = db.Entry(entity); entry.State = EntityState.Modified; db.SaveChanges(); } }
public override void DeleteFile(UploadedFile entity) { if (entity == null) throw new ArgumentNullException("entity"); using (var db = new SqlUploadStorageContext(this.ConnectionStringName)) { var item = db.UploadedFiles.Find(entity.ID); if (item == null) return; db.UploadedFiles.Remove(item); db.SaveChanges(); } }
public override List<UploadedFile> GetFiles(Guid? id, Guid? parentId, string fileName, DateTime? initialDateCreated, DateTime? finalDateCreated, DateTime? initialLastUpdated, DateTime? finalLastUpdated, string contentType, bool includeData, int pageSize, int pageIndex, out int totalCount) { List<UploadedFile> entities = new List<UploadedFile>(); using (var db = new SqlUploadStorageContext(this.ConnectionStringName)) { var query = from file in db.UploadedFiles where !id.HasValue || file.ID == id.Value where !parentId.HasValue || file.ParentID == parentId.Value where string.IsNullOrEmpty(fileName) || (!string.IsNullOrEmpty(file.FileName) && file.FileName.ToLower().Contains(fileName.ToLower())) where !initialDateCreated.HasValue || file.DateCreated >= initialDateCreated.Value where !finalDateCreated.HasValue || file.DateCreated <= initialDateCreated.Value where !initialLastUpdated.HasValue || (file.LastUpdated.HasValue && file.LastUpdated.Value >= initialLastUpdated.Value) where !finalLastUpdated.HasValue || (file.LastUpdated.HasValue && file.LastUpdated.Value >= finalLastUpdated.Value) where string.IsNullOrEmpty(contentType) || (!string.IsNullOrEmpty(file.ContentType) && file.ContentType.ToLower().Contains(contentType.ToLower())) select file; entities.AddRange(query); } totalCount = entities.Count; return entities.Skip(pageIndex * pageSize).Take(pageSize).ToList(); }