public async Task <List <Flat> > GetAllAsync() { using (var ctx = new FlatsDataContext()) { return(await ctx.Flats.ToListAsync()); } }
public DataTable GetDataFrame() { DbSet <Flat> data; using (var ctx = new FlatsDataContext()) { data = ctx.Flats; PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(Flat)); DataTable table = new DataTable(); foreach (PropertyDescriptor prop in properties) { table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType); } foreach (var item in data) { DataRow row = table.NewRow(); foreach (PropertyDescriptor prop in properties) { row[prop.Name] = prop.GetValue(item) ?? DBNull.Value; } table.Rows.Add(row); } return(table); } }
public List <Flat> GetAll() { using (var ctx = new FlatsDataContext()) { return(ctx.Flats.ToList()); } }
public void Add(Flat obj) { using (var ctx = new FlatsDataContext()) { ctx.Flats.Add(obj); ctx.SaveChanges(); } }
public void CleanData() { using (var ctx = new FlatsDataContext()) { ctx.Flats.RemoveRange(ctx.Flats.ToList()); ctx.SaveChanges(); } }
private void ExportToWord() { var _wordService = _ServiceLocator.GetInstance <IWordService>(); var obj = new ExportObject(); obj.Tables.Add(FlatsDataContext.GetExportedTable(ExportMode.All)); obj.Tables.Add(RoomsDataContext.GetExportedTable(ExportMode.All)); obj.Tables.Add(PlotsDataContext.GetExportedTable(ExportMode.All)); obj.Tables.Add(HousesDataContext.GetExportedTable(ExportMode.All)); obj.Tables.Add(ResidenceDataContext.GetExportedTable(ExportMode.All)); _wordService.ExportToWord(obj); }