internal static IList <MediabankFile> GetAllFilesWithType(int clubId, string fileType) { using (MediabankEntities db = new MediabankEntities()) { return(db.MediabankFile.Where(m => m.ClubId == clubId && m.FileType == fileType).ToList()); } }
internal static MediabankFile GetFile(int clubId, int fileId) { using (MediabankEntities db = new MediabankEntities()) { return(db.MediabankFile.Where(m => m.ClubId == clubId && m.Id == fileId).FirstOrDefault()); } }
internal static IList <MediabankFile> GetAllFiles(int clubId) { using (MediabankEntities db = new MediabankEntities()) { return(db.MediabankFile.Where(m => m.ClubId == clubId).ToList()); } }
internal static bool DeleteMediabankFile(MediabankFile mediabankFile) { using (MediabankEntities db = new MediabankEntities()) { try { db.Entry(mediabankFile).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); return(true); } catch (Exception ex) { LogHelper.LogError($"", ex, mediabankFile.ClubId); } return(false); } }
internal static MediabankFile SaveFile(MediabankFile mbFile) { using (MediabankEntities db = new MediabankEntities()) { try { db.MediabankFile.Add(mbFile); db.SaveChanges(); return(mbFile); } catch (Exception ex) { LogHelper.LogError($"", ex, mbFile.ClubId); } return(null); } }