public IList<Society> GetSocieties()
{
using (var db = new MySocietyEntities())
{
return db.Societies.ToList();
}
}
public DbSet<Society> GetPersons()
{
using (var db = new MySocietyEntities())
{
return db.Societies;
}
}
public void AddWings(Wing objWing)
{
using (var db = new MySocietyEntities())
{
db.Wings.Add(objWing);
db.SaveChanges();
}
}
public void AddBuildings(Bldg objBldg)
{
using (var db = new MySocietyEntities())
{
db.Bldgs.Add(objBldg);
db.SaveChanges();
}
}
public IList<Flat> GetFlats(int societyId)
{
//var appConfig = ConfigurationManager.OpenExeConfiguration(Assembly.GetExecutingAssembly().Location);
//string dllConfigData = appConfig.AppSettings.Settings["dllConfigData"].Value;
//var conn = GetConfig();
using (var db = new MySocietyEntities())
{
return db.Flats.ToList();
}
}