public void ClearSlots(EqContext context) { //var recToDel = context.Slots.ToList(); //if (recToDel == null || recToDel.Count == 0) { // return; //} //context.Slots.RemoveRange(recToDel); //context.SaveChanges(); //context.Database.ExecuteSqlCommand("TRUNCATE TABLE Slots"); //context.SaveChanges(); }
public static void Initialize(EqContext context) { context.Database.EnsureCreated(); if (!context.ScheduleTime.Any()) { context.ScheduleTime.AddRange( new ScheduleTime() { Id = 1 , ResourceId = 1 , RecordState = RecordState.N , ScheduleId = 1 , ScheduleDate = DateTime.Parse("15.02.2018 00:00:00") , WorkTimeFrom = TimeSpan.Parse("8:00") , WorkTimeTo = TimeSpan.Parse("18:00") , WorkTimeDuration = TimeSpan.Parse("8:00") }, new ScheduleTime() { Id = 2 , ResourceId = 1 , RecordState = RecordState.N , ScheduleId = 1 , ScheduleDate = DateTime.Parse("16.02.2018 00:00:00") , WorkTimeFrom = TimeSpan.Parse("8:00") , WorkTimeTo = TimeSpan.Parse("18:00") , WorkTimeDuration = TimeSpan.Parse("8:00") } //, new ScheduleTime() { // Id = 2 // , ResourceId = 2 // , RecordState = RecordState.N // , ScheduleId = 2 // , ScheduleDate = DateTime.Parse("22.10.2017 00:00:00") // , WorkTimeFrom = TimeSpan.Parse("8:00") // , WorkTimeTo = TimeSpan.Parse("16:00") // , WorkTimeDuration = TimeSpan.Parse("8:00") } ); context.SaveChanges(); } if (!context.Schedule.Any()) { context.Schedule.AddRange( new Schedule() { Day1 = true , Day2 = true , Day3 = true , Day4 = true , Day5 = true , Day6 = false , Day7 = false , IsAllDay = false , Note = "" , RecordState = RecordState.N , ResourceId = 1 , ScheduleTypeId = 1 , Duration = TimeSpan.Parse("08:00") , WorkDateFrom = DateTime.Parse("14.02.2018 00:00:00") , WorkDateTo = DateTime.Parse("28.02.2018 00:00:00") , WorkTimeFrom = DateTime.Parse("14.02.2018 08:00") , WorkTimeTo = DateTime.Parse("28.02.2018 18:00") } //, // new Schedule(){ // Day1 = true // ,Day2 = true // ,Day3 = true // ,Day4 = true // ,Day5 = false // ,Day6 = false // ,Day7 = false // , IsAllDay = false // , Note = "" // , RecordState = RecordState.N // , ResourceId = 2 // , ScheduleTypeId = 1 // , Duration = TimeSpan.Parse("09:00") // , WorkDateFrom = DateTime.Parse("23.10.2017 00:00:00") // , WorkDateTo = DateTime.Parse("01.10.2018 00:00:00") // ,WorkTimeFrom = DateTime.Parse("01.01.2017 08:00") // ,WorkTimeTo = DateTime.Parse("01.01.2107 18:00") // } //, // new Schedule(){ // Day1 = true // ,Day2 = true // ,Day3 = true // ,Day4 = true // ,Day5 = false // ,Day6 = false // ,Day7 = false // , IsAllDay = true // , Note = "All Day test" // , RecordState = RecordState.N // , ResourceId = 3 // , ScheduleTypeId = 2 // , Duration = TimeSpan.Parse("09:00") // , WorkDateFrom = DateTime.Parse("23.10.2017 00:00:00") // , WorkDateTo = DateTime.Parse("01.10.2018 00:00:00") // ,WorkTimeFrom = DateTime.Parse("01.01.2017 08:00") // ,WorkTimeTo = DateTime.Parse("01.01.2107 18:00") // } ); context.SaveChanges(); } }
public static void InitializeEq(EqContext context) { context.Database.EnsureCreated(); }