コード例 #1
0
        public void Delete(ConstructionDataContext context)
        {
            var item = context.Files.FirstOrDefault(f => f.Id == Id);

            if (item != null)
            {
                #region remove related entries
                foreach (var c in context.CellMappings.Where(w => w.FileId == item.Id))
                {
                    context.CellMappings.Remove(c);
                }
                foreach (var c in context.BusinessFeatures.Where(w => w.FileId == item.Id))
                {
                    context.BusinessFeatures.Remove(c);
                }
                foreach (var c in context.BusinessValues.Where(w => w.FileId == item.Id))
                {
                    context.BusinessValues.Remove(c);
                }
                foreach (var c in context.Constructions.Where(w => w.FileId == item.Id))
                {
                    context.Constructions.Remove(c);
                }
                foreach (var c in context.ConstructionValues.Where(w => w.FileId == item.Id))
                {
                    context.ConstructionValues.Remove(c);
                }
                foreach (var c in context.RiskLevels.Where(w => w.FileId == item.Id))
                {
                    context.RiskLevels.Remove(c);
                }
                #endregion

                context.Files.Remove(item);
                context.SaveChanges();
            }
        }
コード例 #2
0
 //todo: create a abstract class
 public void Update(ConstructionDataContext context)
 {
     context.Entry(this).State = EntityState.Modified;
     context.SaveChanges();
 }
コード例 #3
0
 public int Add(ConstructionDataContext context)
 {
     context.Files.Add(this);
     context.SaveChanges();
     return(Id);
 }
コード例 #4
0
 public bool Exists(ConstructionDataContext context)
 {
     return(context.Files.Any(a => a.FileName == FileName));
 }
コード例 #5
0
 public static File Select(ConstructionDataContext context, string name, FileType type)
 {
     return(context.Files.FirstOrDefault(f =>
                                         f.FileName.Equals(name, StringComparison.CurrentCultureIgnoreCase) &&
                                         f.Type == type));
 }