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;
}
}
