private static void InsertPainting()
{
var painting = new Painting
{
Title = "A Walk in the Woods",
Season = 1,
Episode = 1,
Description = "The very first episode of 'The Joy of Painting' with Bob Ross.",
ThumbnailFile = "~/Images/Thumbnails/S01E01.png",
VideoURL = "https://www.youtube.com/embed/oh5p5f5_-7A",
};
using (var context = new PaintingContext())
{
Console.WriteLine(context.Database.CurrentTransaction);
context.Paintings.Add(painting);
context.SaveChanges();
}
}
public static void Initialize(PaintingContext Context)
{
Context.Database.EnsureCreated();
if (!Context.PaintTeams.Any())
{
var vipco = Context.PaintTeams
.Add(new PaintTeam {
CreateDate = DateTime.Now, Creator = "Admin", TeamName = "VIPCO"
}).Entity;;
var npt = Context.PaintTeams
.Add(new PaintTeam {
CreateDate = DateTime.Now, Creator = "Admin", TeamName = "NPT"
}).Entity;;
var bps = Context.PaintTeams
.Add(new PaintTeam {
CreateDate = DateTime.Now, Creator = "Admin", TeamName = "BPS"
}).Entity;;
Context.BlastRooms
.Add(new BlastRoom
{
BlastRoomName = "Room1",
BlastRoomNumber = 1,
CreateDate = DateTime.Now,
Creator = "Admin",
PaintTeam = vipco
});
Context.BlastRooms
.Add(new BlastRoom
{
BlastRoomName = "Room2",
BlastRoomNumber = 2,
CreateDate = DateTime.Now,
Creator = "Admin",
PaintTeam = npt
});
Context.BlastRooms
.Add(new BlastRoom
{
BlastRoomName = "Room3",
BlastRoomNumber = 3,
CreateDate = DateTime.Now,
Creator = "Admin",
PaintTeam = npt
});
Context.BlastRooms
.Add(new BlastRoom
{
BlastRoomName = "Room4",
BlastRoomNumber = 4,
CreateDate = DateTime.Now,
Creator = "Admin",
PaintTeam = bps
});
Context.BlastRooms
.Add(new BlastRoom
{
BlastRoomName = "Room5",
BlastRoomNumber = 5,
CreateDate = DateTime.Now,
Creator = "Admin",
PaintTeam = vipco
});
Context.SaveChanges();
}
if (!Context.MovementStockStatuses.Any())
{
Context.MovementStockStatuses
.Add(new MovementStockStatus
{
CreateDate = DateTime.Now,
Creator = "Admin",
StatusMovement = StatusMovement.Stock,
StatusName = "Stock",
TypeStatusMovement = TypeStatusMovement.Increased
});
Context.MovementStockStatuses
.Add(new MovementStockStatus
{
CreateDate = DateTime.Now,
Creator = "Admin",
StatusMovement = StatusMovement.Requsition,
StatusName = "Requsition",
TypeStatusMovement = TypeStatusMovement.Decreased
});
Context.MovementStockStatuses
.Add(new MovementStockStatus
{
CreateDate = DateTime.Now,
Creator = "Admin",
StatusMovement = StatusMovement.AdjustIncreased,
StatusName = "AdjustIncreased",
TypeStatusMovement = TypeStatusMovement.Increased
});
Context.MovementStockStatuses
.Add(new MovementStockStatus
{
CreateDate = DateTime.Now,
Creator = "Admin",
StatusMovement = StatusMovement.AdjustDecreased,
StatusName = "AdjustDecreased",
TypeStatusMovement = TypeStatusMovement.Decreased
});
Context.MovementStockStatuses
.Add(new MovementStockStatus
{
CreateDate = DateTime.Now,
Creator = "Admin",
StatusMovement = StatusMovement.Cancel,
StatusName = "Cancel",
TypeStatusMovement = TypeStatusMovement.Decreased
});
Context.SaveChanges();
}
if (!Context.PaymentDetails.Any())
{
var TempPayment = new string[]
{
"งาน Blasting only SA 2 or SSPC-SP6 (Raw material )",
"งาน Blasting only SA 2.5 or SSPC-SP10 (Raw material)",
"งาน Blasting only SA 3 or SSPC-SP5 (Raw material)",
"งานอะไหล่ SA 2 - Accessoies Part (พื้นที่น้อยกว่า 5 m2)",
"งานอะไหล่ SA 2.5 - Accessoies Part (พื้นที่น้อยกว่า 5 m2)",
"งานอะไหล่ SA 3 - Accessoies Part (พื้นที่น้อยกว่า 5 m2)",
"งาน Blasting only sa.2 or SSPC-SP6",
"งาน Blasting only sa.2.5 or SSPC-SP10",
"งาน Blasting only sa.3 or SSPC-SP5",
"งาน Light Blast Cleaning Sa.1 or SSPC-SP7",
"งาน Power tool Cleaning SSPC-SP3",
"งานพ่นสี (Cost)"
};
var TempCost = new double[] { 90, 100, 110, 130, 140, 140, 70, 80, 90, 50, 20, 30 };
for (int i = 0; i < TempPayment.Length; i++)
{
Context.PaymentDetails
.Add(new PaymentDetail
{
CreateDate = DateTime.Now,
Creator = "Admin",
Description = TempPayment[i],
LastCost = TempCost[i],
PaymentType = TempPayment[i].Contains("พ่นสี") ? PaymentType.Paint : PaymentType.Blast,
PaymentCostHistorys = new List <PaymentCostHistory>()
{
new PaymentCostHistory
{
CreateDate = DateTime.Now,
Creator = "Admin",
StartDate = DateTime.Now,
PaymentCost = TempCost[i]
}
}
});
}
Context.SaveChanges();
}
}
