Пример #1
0
 public static Log Add(Log log, Log parent = null)
 {
     if (log.ID > 0)
     {
         throw new Exception("log.ID should be zero");
     }
     if (String.IsNullOrEmpty(log.Application))
     {
         throw new Exception("log.Application should be defined");
     }
     if (String.IsNullOrEmpty(log.Title))
     {
         throw new Exception("log.Title should be defined");
     }
     if (parent != null)
     {
         log.Parent = parent.ID;
     }
     using (MLogDataContext db = new MLogDataContext())
     {
         db.tblLogs.InsertOnSubmit(log.Map());
         db.SubmitChanges();
     }
     using (MLogDataContext db = new MLogDataContext())
     {
         log.ID = (from pp in db.tblLogs where pp.Title == log.Title orderby pp.ID descending select pp.ID).ToList().FirstOrDefault();
     }
     return(log);
 }
Пример #2
0
 public static List <Log> GetLogs(Log log)
 {
     using (MLogDataContext db = new MLogDataContext())
     {
         if (log == null)
         {
             return(db.tblLogs.Take(500).ToList().Select((tlog) => Log.Map(tlog)).ToList());
         }
         else
         {
             bool applicationValid = !String.IsNullOrEmpty(log.Application);
             bool idValid          = log.ID > 0;
             bool parentValid      = log.Parent > 0;
             bool titleValid       = !String.IsNullOrEmpty(log.Title);
             return((from pp in db.tblLogs
                     where (idValid && pp.ID.Equals(log.ID)) || (applicationValid && pp.Application.Equals(log.Application)) ||
                     (parentValid && pp.Parent.Equals(log.Parent)) || (titleValid) && pp.Title.ToLower().Equals(log.Title)
                     select pp).ToList().Select((tlog) => Log.Map(tlog)).ToList());
         }
     }
 }