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