/// <summary>
/// テストデータ削除
/// </summary>
public void RemoveTestData()
{
using (SampleEntities sampleEntities = new SampleEntities())
{
Console.WriteLine(Environment.NewLine);
Console.WriteLine("データの削除");
// エリア情報取得
// 子要素を取得しなくても、リレーションデータの削除を確認。
MArea area = sampleEntities.Areas.FirstOrDefault();
//.Include(a => a.Shops)
// .ThenInclude(shop => shop.SalesDailies)
//.Include(a => a.Shops)
// .ThenInclude(shop => shop.SalesMonthlies)
// .FirstOrDefault();
// 削除データの確認
this.OutputObject(area);
// 削除
sampleEntities.Remove(area);
// 削除内容の保存
sampleEntities.SaveChanges();
}
}
/// <summary>
/// テスト用データ登録
/// </summary>
public void AddTestData()
{
// エリア情報作成
MArea area1 = new MArea {
AreaName = "北海道"
};
MArea area2 = new MArea {
AreaName = "東北"
};
MArea area3 = new MArea {
AreaName = "関東"
};
MArea area4 = new MArea {
AreaName = "中部"
};
MArea area5 = new MArea {
AreaName = "近畿"
};
MArea area6 = new MArea {
AreaName = "中国"
};
MArea area7 = new MArea {
AreaName = "四国"
};
MArea area8 = new MArea {
AreaName = "九州"
};
// 店舗情報作成
MShop shopTokyo = new MShop {
Area = area3, Address = "東京都xxxxxxxxxx", ShopName = "東京店舗"
};
MShop shopHokkaido = new MShop {
Area = area1, Address = "北海道xxxxxxxxxx", ShopName = "北海道店舗"
};
// 売上情報追加：東京
shopTokyo.SalesDailies = new List <TDailySales>();
shopTokyo.SalesDailies.Add(new TDailySales {
Shop = shopTokyo, SalesDate = DateTime.Parse("2019/12/1"), AmountOfSales = 10000
});
shopTokyo.SalesDailies.Add(new TDailySales {
Shop = shopTokyo, SalesDate = DateTime.Parse("2019/12/2"), AmountOfSales = 20000
});
shopTokyo.SalesDailies.Add(new TDailySales {
Shop = shopTokyo, SalesDate = DateTime.Parse("2019/12/3"), AmountOfSales = 30000
});
shopTokyo.SalesMonthlies = new List <TMonthlySales>();
shopTokyo.SalesMonthlies.Add(new TMonthlySales {
Shop = shopTokyo, SalesMonth = "201912", AmountOfSales = 60000
});
// 売上情報追加：北海道
shopHokkaido.SalesDailies = new List <TDailySales>();
shopHokkaido.SalesDailies.Add(new TDailySales {
Shop = shopHokkaido, SalesDate = DateTime.Parse("2019/12/1"), AmountOfSales = 1000
});
shopHokkaido.SalesDailies.Add(new TDailySales {
Shop = shopHokkaido, SalesDate = DateTime.Parse("2019/12/2"), AmountOfSales = 2000
});
shopHokkaido.SalesDailies.Add(new TDailySales {
Shop = shopHokkaido, SalesDate = DateTime.Parse("2019/12/3"), AmountOfSales = 3000
});
shopHokkaido.SalesMonthlies = new List <TMonthlySales>();
shopHokkaido.SalesMonthlies.Add(new TMonthlySales {
SalesMonth = "201912", Shop = shopHokkaido, AmountOfSales = 6000
});
using (SampleEntities sampleEntities = new SampleEntities())
{
// データの追加
// この時点ではデータの保存はされておらず、AIの採番が行われておりません。
sampleEntities.Areas.AddRange(new MArea[] { area1, area2, area3, area4, area5, area6, area7, area8 });
sampleEntities.Shops.Add(shopTokyo);
sampleEntities.Shops.Add(shopHokkaido);
// 登録前：内容出力
// AIの採番が行われていないことが確認できます。
Console.WriteLine(Environment.NewLine);
this.OutputObject(shopTokyo);
this.OutputObject(shopHokkaido);
// 登録内容保存
sampleEntities.SaveChanges();
}
// 登録後：内容出力
// AIの採番が行われたことが確認できます。
this.OutputObject(shopTokyo);
this.OutputObject(shopHokkaido);
}
