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; } }
public static PhotographerCredits Find(int pcid) { using (FotografPaketiEntities db = new FotografPaketiEntities()) { PhotographerCredits pc = db.PhotographerCredits.Find(pcid); return pc; } }
public static List<PhotographerCredits> GetPhotographerCredits() { using (FotografPaketiEntities db = new FotografPaketiEntities()) { List<PhotographerCredits> credits = db.PhotographerCredits.ToList(); return credits; } }
public static Words Find(int wordid) { using (FotografPaketiEntities db = new FotografPaketiEntities()) { Words word = db.Words.Find(wordid); return word; } }
public static List<PhotographerCredits> GetPhotographerCredits(int photographerId) { using (FotografPaketiEntities db = new FotografPaketiEntities()) { List<PhotographerCredits> credits = db.PhotographerCredits.Where(v => v.PhotographerId == photographerId).ToList(); return credits; } }
public static int FavoriteCountByPhotographerId(int pid) { using (FotografPaketiEntities db = new FotografPaketiEntities()) { int count = db.MemberFavorites.Where(v => v.PhotographerId == pid).Count(); return count; } }
public static Role Find(int roleid) { using (FotografPaketiEntities db = new FotografPaketiEntities()) { Role role = db.Role.Find(roleid); return role; } }
public static Members Find(int memberId) { using (FotografPaketiEntities db = new FotografPaketiEntities()) { Members member = db.Members.Find(memberId); return member; } }
public static List<Modules> GetLowerModules() { using (FotografPaketiEntities db = new FotografPaketiEntities()) { List<Modules> moduleslist = db.Modules.Where(v => v.UpperId != null).ToList(); return moduleslist; } }
public static List<City> GetCityList() { using (FotografPaketiEntities db = new FotografPaketiEntities()) { List<City> citylist = db.City.Where(v => v.DeleteStatus == false).ToList(); return citylist; } }
public static List<District> GetDistrictsList(int cityId) { using (FotografPaketiEntities db = new FotografPaketiEntities()) { List<District> distlist = db.District.Where(v => v.DeleteStatus == false && v.CityId == cityId).ToList(); return distlist; } }