예제 #1
0
        public bool create(Photo photo)
        {
            using (PhotoDBEntities pdbe = new PhotoDBEntities())
            {
                try
                {
                    PhotoEntity pe = new PhotoEntity();

                    pe.Title = photo.Title;
                    pe.Image = photo.Image;
                    pe.UserName = photo.UserName;
                    pe.AddDate=photo.AddDate;
                    pe.Model=photo.Model;
                    pe.Resolution=photo.Resolution;
                    pe.Explosure=photo.Explosure;
                    pe.CreateDate=photo.CreateDate;
                    pe.Rating = photo.Rating;
                    pe.NumderVote = photo.NumderVote;

                    pdbe.PhotoEntities.Add(pe);
                    pdbe.SaveChanges();
                    return true;
                }
                catch
                {
                    return false;
                }
            };
        }
예제 #2
0
 public bool edit(Photo photo)
 {
     using (PhotoDBEntities pdbe = new PhotoDBEntities())
     {
         try
         {
             PhotoEntity pe = pdbe.PhotoEntities.Single(p => p.Id == photo.Id);
             pe.Title = photo.Title;
             pdbe.SaveChanges();
             return true;
         }
         catch
         {
             return false;
         }
     }
 }
예제 #3
0
 public bool delete(Photo photo)
 {
     using (PhotoDBEntities pdbe = new PhotoDBEntities())
     {
         try
         {
             PhotoEntity pe = pdbe.PhotoEntities.Single(p => p.Id == photo.Id);
             pdbe.PhotoEntities.Remove(pe);
             pdbe.SaveChanges();
             return true;
         }
         catch
         {
             return false;
         }
     }
 }
예제 #4
0
 public Photo find(string id)
 {
     using (PhotoDBEntities pdbe = new PhotoDBEntities())
     {
         int nid = Convert.ToInt32(id);
         return pdbe.PhotoEntities.Where(pe => pe.Id == nid).Select(pe => new Photo
         {
             Id = pe.Id,
             Title = pe.Title,
             Image = pe.Image,
             UserName = pe.UserName,
             AddDate = pe.AddDate,
             Model = pe.Model,
             Resolution = pe.Resolution,
             Explosure = pe.Explosure,
             CreateDate = pe.CreateDate,
             Rating = pe.Rating,
             NumderVote = pe.NumderVote
         }).First();
     };
 }
예제 #5
0
 public List<Photo> finduser(string name)
 {
     using (PhotoDBEntities pdbe = new PhotoDBEntities())
     {
         return pdbe.PhotoEntities.Where(pe => pe.UserName.Equals(name)).Select(pe => new Photo
         {
             Id = pe.Id,
             Title = pe.Title,
             Image = pe.Image,
             UserName = pe.UserName,
             AddDate = pe.AddDate,
             Model = pe.Model,
             Resolution = pe.Resolution,
             Explosure = pe.Explosure,
             CreateDate = pe.CreateDate,
             Rating = pe.Rating,
             NumderVote = pe.NumderVote
         }).ToList();
     };
 }