public bool IsValidImageId(Guid imageId) { using (var context = new AppCampusContext()) { return context.Images.Any(i => i.Id == imageId); } }
public Screenshot Find(Guid screenshotId) { using (var context = new AppCampusContext()) { var screenshotTable = context.Screenshots.First(x => x.Id == screenshotId); return Screenshot.From(screenshotTable.Id, screenshotTable.Base64ImageString, screenshotTable.DeviceId, screenshotTable.CreatedDate); } }
public byte[] GetFile(Guid softwareFileId) { LogFileTable logFile; using (var context = new AppCampusContext()) { logFile = context.LogFiles.Find(softwareFileId); } return logFile.Binary; }
public bool HasScreenshot(Guid screenshotId) { using (var context = new AppCampusContext()) { var screenshotTable = context.Screenshots.FirstOrDefault(x => x.Id == screenshotId); if (screenshotTable == null) { return false; } } return true; }
public string GetNameFromId(Guid imageId) { using (var context = new AppCampusContext()) { var image = context.Images.Find(imageId); if (image == null) { throw new ArgumentNullException("imageId", String.Format("No Image with Id = {0} exists.", imageId)); } return image.Name; } }
public string GetFileName(Guid softwareFileId) { using (var context = new AppCampusContext()) { var softwareFile = context.SoftwareFiles.Select(x => new { Id = x.Id, FileName = x.FileName }).SingleOrDefault(x => x.Id == softwareFileId); if (softwareFile == null) { throw new ArgumentOutOfRangeException("softwareFileId", String.Format("There is no software file with id '{0}'", softwareFileId)); } return softwareFile.FileName; } }
public void StoreScreenshot(Screenshot screenshot) { using (var context = new AppCampusContext()) { context.Screenshots.Add( new ScreenshotTable() { Id = screenshot.Id, DeviceId = screenshot.DeviceId, CreatedDate = DateTime.UtcNow, Base64ImageString = screenshot.Base64ImageString }); context.SaveChanges(); } }
public Guid AddImage(string base64Image, string imageName) { using (var context = new AppCampusContext()) { ImageTable imageTable = context.Images.Add( new ImageTable() { Id = CombIdentityFactory.GenerateIdentity(), Base64Image = base64Image, CreatedDate = DateTime.Now, Name = imageName }); context.SaveChanges(); return imageTable.Id; } }
public Guid SaveFile(byte[] file) { var logFile = new LogFileTable() { Id = CombIdentityFactory.GenerateIdentity(), Binary = file }; using (var context = new AppCampusContext()) { context.LogFiles.Add(logFile); context.SaveChanges(); } return logFile.Id; }
public Guid SaveFile(string fileName, byte[] file) { var softwareFile = new SoftwareFileTable() { Id = CombIdentityFactory.GenerateIdentity(), FileName = fileName, Binary = file }; using (var context = new AppCampusContext()) { context.SoftwareFiles.Add(softwareFile); context.SaveChanges(); } return softwareFile.Id; }