public CityData SelectById(object id)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet <CityData> table = context.Set <CityData>();
return(table.Find(id));
}
}
public List <UserRoleMapping> SelectAll()
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet <UserRoleMapping> table = context.Set <UserRoleMapping>();
return(table.ToList());
}
}
public List <CityData> SelectAll()
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet <CityData> table = context.Set <CityData>();
return(table.ToList());
}
}
public UserRoleMapping SelectById(object id)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet <UserRoleMapping> table = context.Set <UserRoleMapping>();
return(table.Find(id));
}
}
public OverseasTerritoriesData SelectById(object id)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet <OverseasTerritoriesData> table = context.Set <OverseasTerritoriesData>();
return(table.Find(id));
}
}
public List <OverseasTerritoriesData> SelectAll()
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet <OverseasTerritoriesData> table = context.Set <OverseasTerritoriesData>();
return(table.ToList());
}
}
public void Update(CityData entity)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet table = context.CityData;
table.Attach(entity);
context.Entry(entity).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void Delete(UserRoleMapping entity)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet table = context.UserRoleMapping;
table.Attach(entity);
context.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
public void Insert(RoleData entity)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet table = context.RoleData;
table.Attach(entity);
context.Entry(entity).State = System.Data.Entity.EntityState.Added;
context.SaveChanges();
}
}
public void Delete(OverseasTerritoriesData entity)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
DbSet table = context.OverseasTerritoriesData;
table.Attach(entity);
context.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
public List <CityData> Search(Expression <Func <CityData, bool> > filter = null)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
if (filter == null)
{
return(context.CityData.ToList());
}
return(context.CityData.Where(filter).ToList());
}
}
public List <UserRoleMapping> Search(Expression <Func <UserRoleMapping, bool> > filter = null)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
if (filter == null)
{
return(context.UserRoleMapping.ToList());
}
return(context.UserRoleMapping.Where(filter).ToList());
}
}
public List <OverseasTerritoriesData> Search(Expression <Func <OverseasTerritoriesData, bool> > filter = null)
{
using (WorldMapDBContext context = new WorldMapDBContext())
{
if (filter == null)
{
return(context.OverseasTerritoriesData.ToList());
}
return(context.OverseasTerritoriesData.Where(filter).ToList());
}
}
public DbSet GetEntites()
{
WorldMapDBContext context = new WorldMapDBContext();
return(context.CityData);
}
public DbSet GetEntites()
{
WorldMapDBContext context = new WorldMapDBContext();
return(context.UserRoleMapping);
}
public DbSet GetEntites()
{
WorldMapDBContext context = new WorldMapDBContext();
return(context.OverseasTerritoriesData);
}
