public static int GetHowManyPhotographerInCity(int cityId)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         return db.PhotographerCities.Where(v => v.CityId == cityId).Count();
     }
 }

 public static MemberFavorites Find(int mfid)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         return db.MemberFavorites.Find(mfid);
     }
 }

 public static Gallery Find(int id)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         return db.Gallery.Find(id);
     }
 }

 public static PhotographerGenres Find(int pgid)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         return db.PhotographerGenres.Find(pgid);
     }
 }

 public static City Find(int cityId)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         City city = db.City.Find(cityId);
         return city;
     }
 }

 public static List<Words> GetWordsList()
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         List<Words> wordslist = db.Words.Where(v => v.Status == false).OrderBy(v => v.Word).ToList();
         return wordslist;
     }
 }

 public static int GetPhotographerGenresCount(int photographerId)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         int count = db.PhotographerGenres.Where(v => v.PhotographerId == photographerId && v.Status == false).Count();
         return count;
     }
 }

 public static List<Photo> GetPhotosListByPhotographerId(int pid)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         List<Photo> Photoslist = db.Photo.Where(v => v.Status == false && v.PhotographerId == pid).ToList();
         return Photoslist;
     }
 }

 public static List<Country> GetCountryList()
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         List<Country> countrylist = db.Country.Where(v => v.Status == false).ToList();
         return countrylist;
     }
 }

 public static List<Modules> GetModuleList(int moduleId)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         List<Modules> modulelist = db.Modules.Where(v => v.DeleteStatus == false && v.UpperId == moduleId).ToList();
         return modulelist;
     }
 }

 public static Modules Find(int moduleid)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         Modules module = db.Modules.Find(moduleid);
         return module;
     }
 }

 public static List<Gallery> GetGalleryList(int photographerId)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         List<Gallery> glist = db.Gallery.Where(v => v.PhotographerId == photographerId && v.DeleteStatus == false).ToList();
         return glist;
     }
 }

 public static RoleModules Find(int rmid)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         RoleModules rm = db.RoleModules.Find(rmid);
         return rm;
     }
 }

 public static List<Genres> GetGenresList()
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         List<Genres> genreslist = db.Genres.Where(v => v.DeleteStatus == false).ToList();
         return genreslist;
     }
 }

 public static Genres Find(int genreid)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         Genres genre = db.Genres.Find(genreid);
         return genre;
     }
 }

 public static List<Modules> GetLowerModules(int upperid)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         List<Modules> moduleslist = db.Modules.Where(v => v.UpperId == upperid && v.DeleteStatus == false).ToList();
         return moduleslist;
     }
 }

 public static Country Find(int id)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         Country country = db.Country.Find(id);
         return country;
     }
 }

 public static Credits Find(int creditId)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         Credits credit = db.Credits.Find(creditId);
         return credit;
     }
 }

 public static List<Photo> GetPhotosList(int galleryId)
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         List<Photo> Photoslist = db.Photo.Where(v => v.Status == false && v.GalleryId == galleryId).ToList();
         return Photoslist;
     }
 }

 public static List<Credits> GetCredistList()
 {
     using (FotografPaketiEntities db = new FotografPaketiEntities())
     {
         List<Credits> creditslist = db.Credits.Where(v => v.Status == false).ToList();
         return creditslist;
     }
 }