public override void Up()
{
CreateTable(
"dbo.Journeys",
c => new
{
JourneyID = c.Int(nullable: false, identity: true),
BusinessTripID = c.Int(nullable: false),
Date = c.DateTime(nullable: false),
ReclaimDate = c.DateTime(),
DayOff = c.Boolean(nullable: false),
})
.PrimaryKey(t => t.JourneyID)
.ForeignKey("dbo.BusinessTrips", t => t.BusinessTripID, cascadeDelete: true)
.Index(t => t.BusinessTripID);
var btsList = (from bt in ajourDbRepository.BusinessTrips
where bt.OrderStartDate != null && bt.OrderEndDate != null
select bt).ToList();
foreach (var bt in btsList)
{
ajourDbRepository.CreateJourney(bt);
}
}
public override void Up()
{
AjourDbRepository repository = new AjourDbRepository();
//CreateTable(
// "dbo.Journeys",
// c => new
// {
// JourneyID = c.Int(nullable: false, identity: true),
// BusinessTripID = c.Int(nullable: false),
// Date = c.DateTime(nullable: false),
// ReclaimDate = c.DateTime(),
// DayOff = c.Boolean(nullable: false),
// })
// .PrimaryKey(t => t.JourneyID)
// .ForeignKey("dbo.BusinessTrips", t => t.BusinessTripID, cascadeDelete: true)
// .Index(t => t.BusinessTripID);
var btList = (from bt in repository.BusinessTrips
where bt.OrderStartDate != null && bt.OrderEndDate != null
select bt).ToList();
foreach (var bt in btList)
{
repository.CreateJourney(bt);
}
}