public Facade.Notes.IMetainfo CreateMetainfo(Facade.Notes.IAttachment attachment)
{
using (SheetContext ctx = new SheetContext())
{
Attachment dbAttachment = ctx.Attachments.Find(attachment.ID);
Metainfo metainfo = new Metainfo();
dbAttachment.Metadata.Add(metainfo);
ctx.SaveChanges();
return metainfo;
}
}
public Facade.Notes.IAttachment CreateAttachment(Facade.Notes.INote note, Stream sourceStream, string fileName)
{
Attachment attachment = new Attachment()
{
Name = fileName
};
using (SheetContext ctx = new SheetContext())
{
Note dbNote = ctx.Notes.Find(note.ID);
dbNote.Attachments.Add(attachment);
ctx.SaveChanges();
}
FileStream targetStream = null;
string attachmentFolder = (string)AppDomain.CurrentDomain.GetData("AttachmentDirectory");
string filePath = Path.Combine(attachmentFolder, attachment.ID + ".attachment");
string mimeString = System.Web.MimeMapping.GetMimeMapping(fileName);
using (SheetContext ctx = new SheetContext())
{
attachment = ctx.Attachments.Find(attachment.ID);
attachment.MimeType = mimeString;
attachment.Path = filePath;
ctx.SaveChanges();
}
using (targetStream = new FileStream(filePath, FileMode.Create, FileAccess.Write, FileShare.None))
{
const int bufferLen = 65000;
byte[] buffer = new byte[bufferLen];
int count = 0;
while ((count = sourceStream.Read(buffer, 0, bufferLen)) > 0)
{
targetStream.Write(buffer, 0, count);
}
targetStream.Close();
sourceStream.Close();
}
return attachment;
}
public Facade.Notes.INote CreateNote()
{
using (SheetContext ctx = new SheetContext())
{
Note note = new Note()
{
DateOfCreation = DateTime.Now,
LastModified = DateTime.Now
};
ctx.Notes.Add(note);
ctx.SaveChanges();
return note;
}
}
public Facade.Notes.ILabel SetLabel(Facade.Notes.INote note, string text)
{
using (SheetContext ctx = new SheetContext())
{
Label dbLabel = ctx.Labels.SingleOrDefault(l => l.Text == text) ?? new Label() { Text = text };
Note dbNote = ctx.Notes.Include("Labels").Where(n => n.ID == note.ID).FirstOrDefault();
if (!dbNote.Labels.Any(l => l.ID == dbLabel.ID))
{
dbNote.Labels.Add(dbLabel);
ctx.SaveChanges();
}
CleanupLabels();
return dbLabel;
}
}
private void CleanupLabels()
{
using (SheetContext ctx = new SheetContext())
{
ctx.Labels.RemoveRange(ctx.Labels.Include("Notes").Where(l => l.Notes.Count == 0));
ctx.SaveChanges();
}
}
public ICollection<Facade.Notes.INote> QueryNotes(Facade.Queries.ComplexQueries.ComplexQuery query)
{
using (SheetContext ctx = new SheetContext())
{
DateTime beforeQuery = query.Before.Date.AddDays(1);
DateTime afterQuery = query.After.Date;
IQueryable<Note> noteQuery = ctx.Notes.Include("Attachments").Where(n => (n.DateOfCreation > afterQuery) && (n.DateOfCreation < beforeQuery));
foreach (string cond in query.LabelQuery)
{
noteQuery = noteQuery.Where(n => n.Labels.Any(l => l.Text.Contains(cond)));
}
if (query.HasAttachment == true)
{
noteQuery = noteQuery.Where(n => n.Attachments.Count > 0);
foreach (ContentType contentType in query.AttachmentOfType)
{
string type = contentType.ToString();
noteQuery = noteQuery.Where(n => n.Attachments.Any(a => a.MimeType.Contains(type)));
}
foreach (string attachmentName in query.AttachmentNameQuery)
{
noteQuery = noteQuery.Where(n => n.Attachments.Any(a => a.Name.Contains(attachmentName)));
}
}
noteQuery = noteQuery.Where(n => query.TitleQuery.All(toCheck => n.Title.Contains(toCheck)));
if (query.TitleAny.Count() > 0)
{
noteQuery = noteQuery.Where(n => query.TitleAny.Any(toCheck => n.Title.Contains(toCheck)));
}
noteQuery = noteQuery.Where(n => query.TextQuery.All(toCheck => n.Text.Contains(toCheck)));
if (query.TextAny.Count() > 0)
{
noteQuery = noteQuery.Where(n => query.TextAny.Any(toCheck => n.Text.Contains(toCheck)));
}
return noteQuery.ToList<Facade.Notes.INote>();
}
}
public void SaveNote(Facade.Notes.INote note)
{
using (SheetContext ctx = new SheetContext())
{
Note dbNote = ctx.Notes.Find(note.ID);
dbNote.Text = note.Text;
dbNote.Title = note.Title;
ctx.SaveChanges();
}
}
public ICollection<Facade.Notes.INote> QueryNotes(string expression)
{
using (SheetContext ctx = new SheetContext())
{
try
{
return ctx.Notes
.Include("Labels")
.Include("Attachments")
.Where(
n => n.Text.Contains(expression) ||
n.Title.Contains(expression) ||
n.Labels.Any(l => l.Text.Contains(expression)) ||
n.Attachments.Any(a => a.Name.Contains(expression)) ||
n.Attachments.Any(a => a.MimeType.Contains(expression))
).ToArray();
}
catch (ArgumentNullException)
{
return null;
}
}
}
public ICollection<Facade.Notes.INote> QueryNotes(Facade.Notes.ILabel label)
{
using (SheetContext ctx = new SheetContext())
{
try
{
return ctx.Notes.Where(n => n.Labels.Contains((Label)label)).ToArray<Facade.Notes.INote>();
}
catch (ArgumentNullException)
{
return null;
}
}
}
public Facade.Notes.INote LoadNote(Facade.Notes.INote note)
{
using (SheetContext ctx = new SheetContext())
{
try
{
return ctx.Notes.Include("Labels").Include("Attachments").ToList<Facade.Notes.INote>().Single(n => n.ID == note.ID);
}
catch (ArgumentNullException)
{
return null;
}
catch (InvalidOperationException)
{
return null;
}
}
}
public ICollection<Facade.Notes.INote> GetNotes()
{
using (SheetContext ctx = new SheetContext())
{
try
{
var result = ctx.Notes.Include("Labels").ToArray();
return result;
}
catch (ArgumentNullException)
{
return null;
}
}
}
public void DeleteNote(Facade.Notes.INote note)
{
using (SheetContext ctx = new SheetContext())
{
Note dbNote = ctx.Notes.Include("Attachments").Single(n => n.ID == note.ID);
foreach (Attachment attachment in dbNote.Attachments)
{
this.DeleteAttachment(attachment);
}
}
using (SheetContext ctx = new SheetContext())
{
Note dbNote = ctx.Notes.Find(note.ID);
ctx.Notes.Remove(dbNote);
ctx.SaveChanges();
}
CleanupLabels();
}
public void DeleteLabels(Facade.Notes.INote note)
{
using (SheetContext ctx = new SheetContext())
{
Note dbNote = ctx.Notes.Include("Labels").Single(n => n.ID == note.ID);
dbNote.Labels.Clear();
ctx.SaveChanges();
}
}
public void DeleteAttachment(Facade.Notes.IAttachment attachment)
{
string fileName = attachment.ID + ".attachment";
string attachmentFolder = (string)AppDomain.CurrentDomain.GetData("AttachmentDirectory");
string filePath = System.IO.Path.Combine(attachmentFolder, fileName);
if (File.Exists(filePath))
{
File.Delete(filePath);
}
using (SheetContext ctx = new SheetContext())
{
Attachment dbAttachment = ctx.Attachments.Find(attachment.ID);
ctx.Attachments.Remove(dbAttachment);
ctx.SaveChanges();
}
}
