public static void Create(MilestoneDto dto)
        {
            using (var db = new MainDBModelContainer())
            {
                var entity = MilestoneMapper.DtoToEntity(dto, db);

                db.MilestoneSet.Add(entity);
                db.SaveChanges();
            }
        }
 public static MilestoneDto Read(int id)
 {
     using (var db = new MainDBModelContainer())
     {
         var data = db.MilestoneSet.Find(id);
         if (data != null)
         {
             return(MilestoneMapper.EntityToDto(data));
         }
         throw new ElementNotFoundException();
     }
 }
        public static void Update(MilestoneDto dto)
        {
            using (var db = new MainDBModelContainer())
            {
                var newData = MilestoneMapper.DtoToEntity(dto, db);
                var oldData = db.MilestoneSet.Find(dto.Id);
                if (oldData != null)
                {
                    oldData.Name    = newData.Name;
                    oldData.EndDate = newData.EndDate;
                    oldData.Project = newData.Project;

                    db.SaveChanges();
                }
                else
                {
                    throw new ElementNotFoundException();
                }
            }
        }