public int count()
{
using (var db = new MainDb())
{
return db.images.Count();
}
}
public int count()
{
using (var db = new MainDb())
{
return db.propertyListingTypes.Count();
}
}
public int count()
{
using (var db = new MainDb())
{
return db.carModelTypes.Count();
}
}
public int count()
{
using (var db = new MainDb())
{
return db.businessServiceTypes.Count();
}
}
public int count()
{
using (var db = new MainDb())
{
return db.stateTypes.Count();
}
}
public int count()
{
using (var db = new MainDb())
{
return db.optionTypes.Count();
}
}
public int count()
{
using (var db = new MainDb())
{
return db.jobCategoryTypes.Count();
}
}
public int count()
{
using (var db = new MainDb())
{
return db.listingCategoryLookups.Count();
}
}
public int count()
{
using (var db = new MainDb())
{
return db.memberRoleLookups.Count();
}
}
public int count()
{
using (var db = new MainDb())
{
return db.listings.Count();
}
}
/// <summary>
/// Get First Item
/// </summary>
public StateTypeVo getFirst()
{
using (var db = new MainDb())
{
var res = db.stateTypes
.FirstOrDefault();
return res;
}
}
/// <summary>
/// Get First Item
/// </summary>
public MemberRoleLookupVo getFirst()
{
using (var db = new MainDb())
{
var res = db.memberRoleLookups
.FirstOrDefault();
return res;
}
}
/// <summary>
/// Find MemberRoleLookup matching the memberRoleLookupId (primary key)
/// </summary>
public MemberRoleLookupVo get(Guid memberRoleLookupId )
{
using (var db = new MainDb())
{
var res = db.memberRoleLookups
.FirstOrDefault(p => p.memberRoleLookupId == memberRoleLookupId);
return res;
}
}
public bool delete(Guid memberRoleLookupId)
{
using (var db = new MainDb())
{
var res = db.memberRoleLookups
.Where(e => e.memberRoleLookupId == memberRoleLookupId)
.Delete();
return true;
}
}
/// <summary>
/// Find Member matching the memberId (primary key)
/// </summary>
public MemberVo get(int memberId )
{
using (var db = new MainDb())
{
var res = db.members
.FirstOrDefault(p => p.memberId == memberId);
return res;
}
}
public bool delete(int memberId)
{
using (var db = new MainDb())
{
var res = db.members
.Where(e => e.memberId == memberId)
.Delete();
return true;
}
}
/// <summary>
/// Get First Item
/// </summary>
public CarModelTypeVo getFirst()
{
using (var db = new MainDb())
{
var res = db.carModelTypes
.FirstOrDefault();
return res;
}
}
/// <summary>
/// Find ListingCategoryLookup matching the listingCategoryLookupId (primary key)
/// </summary>
public ListingCategoryLookupVo get(Guid listingCategoryLookupId )
{
using (var db = new MainDb())
{
var res = db.listingCategoryLookups
.FirstOrDefault(p => p.listingCategoryLookupId == listingCategoryLookupId);
return res;
}
}
/// <summary>
/// Find Listing matching the listingId (primary key)
/// </summary>
public ListingVo get(Guid listingId )
{
using (var db = new MainDb())
{
var res = db.listings
.FirstOrDefault(p => p.listingId == listingId);
return res;
}
}
/// <summary>
/// Find ListingStatusType matching the listingStatusTypeId (primary key)
/// </summary>
public ListingStatusTypeVo get(int listingStatusTypeId )
{
using (var db = new MainDb())
{
var res = db.listingStatusTypes
.FirstOrDefault(p => p.listingStatusTypeId == listingStatusTypeId);
return res;
}
}
public bool delete(int listingStatusTypeId)
{
using (var db = new MainDb())
{
var res = db.listingStatusTypes
.Where(e => e.listingStatusTypeId == listingStatusTypeId)
.Delete();
return true;
}
}
/// <summary>
/// Find JobType matching the jobTypeId (primary key)
/// </summary>
public JobTypeVo get(int jobTypeId )
{
using (var db = new MainDb())
{
var res = db.jobTypes
.FirstOrDefault(p => p.jobTypeId == jobTypeId);
return res;
}
}
/// <summary>
/// Find BusinessCategoryLookup matching the businessCategoryLookupId (primary key)
/// </summary>
public BusinessCategoryLookupVo get(Guid businessCategoryLookupId )
{
using (var db = new MainDb())
{
var res = db.businessCategoryLookups
.FirstOrDefault(p => p.businessCategoryLookupId == businessCategoryLookupId);
return res;
}
}
public bool delete(Guid businessCategoryLookupId)
{
using (var db = new MainDb())
{
var res = db.businessCategoryLookups
.Where(e => e.businessCategoryLookupId == businessCategoryLookupId)
.Delete();
return true;
}
}
/// <summary>
/// Get First Item
/// </summary>
public ListingCategoryLookupVo getFirst()
{
using (var db = new MainDb())
{
var res = db.listingCategoryLookups
.FirstOrDefault();
return res;
}
}
/// <summary>
/// Find CarModelType matching the carModelTypeId (primary key)
/// </summary>
public CarModelTypeVo get(int carModelTypeId )
{
using (var db = new MainDb())
{
var res = db.carModelTypes
.FirstOrDefault(p => p.carModelTypeId == carModelTypeId);
return res;
}
}
public bool delete(Guid listingId)
{
using (var db = new MainDb())
{
var res = db.listings
.Where(e => e.listingId == listingId)
.Delete();
return true;
}
}
public bool delete(int stateTypeId)
{
using (var db = new MainDb())
{
var res = db.stateTypes
.Where(e => e.stateTypeId == stateTypeId)
.Delete();
return true;
}
}
/// <summary>
/// Get First Item
/// </summary>
public ListingVo getFirst()
{
using (var db = new MainDb())
{
var res = db.listings
.FirstOrDefault();
return res;
}
}
/// <summary>
/// Find StateType matching the stateTypeId (primary key)
/// </summary>
public StateTypeVo get(int stateTypeId )
{
using (var db = new MainDb())
{
var res = db.stateTypes
.FirstOrDefault(p => p.stateTypeId == stateTypeId);
return res;
}
}