public HolidayOwnerController(HolidayContext context)
{
_context = context;
if (_context.HolidayOwners.Count() == 0)
{
_context.HolidayOwners.AddRange(
new HolidayOwner {
Name = "Anna", Id = 1
},
new HolidayOwner {
Name = "Tiffany", Id = 2
},
new HolidayOwner {
Name = "Tom", Id = 3
},
new HolidayOwner {
Name = "Richard", Id = 4
},
new HolidayOwner {
Name = "Daniel", Id = 5
},
new HolidayOwner {
Name = "Peter", Id = 6
});
_context.SaveChanges();
}
}
public HolidayHomeController(HolidayContext context)
{
_context = context;
//Since it uses InMemoryDatabase, there is no data from the start, therefore data is created
if (_context.HolidayHomes.Count() == 0)
{
_context.HolidayHomes.AddRange(
new HolidayHome {
Address = "Cortijo casas viejas, Granada", RentalPrice = 780, HomeOwnerId = 3
},
new HolidayHome {
Address = "El valle dorado, Huelva", RentalPrice = 320, HomeOwnerId = 4
},
new HolidayHome {
Address = "Caserío tradicional, Málaga", RentalPrice = 650, HomeOwnerId = 3
},
new HolidayHome {
Address = "Cortijo Quintillo, Granada", RentalPrice = 425, HomeOwnerId = 3
},
new HolidayHome {
Address = "Casa rural villa Anna, Málaga", RentalPrice = 545, HomeOwnerId = 1
});
_context.SaveChanges();
}
}
public HolidaysController(HolidayContext context)
{
_context = context;
sortOptions.Add(new SortOption {
Id = 1, optionName = "Year"
});
sortOptions.Add(new SortOption {
Id = 2, optionName = "Score"
});
}
public HolidayHomeController(HolidayContext context)
{
_context = context;
//Since it uses InMemoryDatabase, there is no data from the start, therefore data is created
if (_context.HolidayHomes.Count() == 0)
{
_context.HolidayHomes.AddRange(new HolidayHome {
Address = "Finca el Pato, 29004 Málaga, Spanien", RentalPrice = 550
}, new HolidayHome {
Address = "Sdr Almstokvej, 6623 Vorbasse", RentalPrice = 400
});
_context.SaveChanges();
}
}
public HolidayOwnerController(HolidayContext context)
{
_context = context;
//Since it uses InMemoryDatabase, there is no data from the start, therefore data is created
if (_context.HolidayOwners.Count() == 0)
{
_context.HolidayOwners.AddRange(new HolidayOwner {
Name = "Thomas"
}, new HolidayOwner {
Name = "Peter"
});
_context.SaveChanges();
}
}
public EmployeeRepository(HolidayContext holidayContext)
: base(holidayContext)
{
}
public VacantionRequestsController(HolidayContext context)
{
_context = context;
}
public VacantionRequestService(IRepositoryWrapper vacantionRequest, HolidayContext holidayContext)
{
repositoryWrapper = vacantionRequest;
_holidayContext = holidayContext;
}
public HolidayRequestRepository(HolidayContext context) => this.context = context;
public RepositoryWrapper(HolidayContext holidayContext)
{
_holidayContext = holidayContext;
}
public RepositoryBase(HolidayContext holidayContext)
{
this.HolidayContext = holidayContext;
}
public EmployeeRepository(HolidayContext context) => this.context = context;
public EmployeesController(HolidayContext context)
{
_context = context;
}
public EmployeeService(IRepositoryWrapper employee, HolidayContext holidayContext)
{
repositoryWrapper = employee;
_holidayContext = holidayContext;
}
public static async Task Seed(HolidayContext context)
{
await context.Database.EnsureCreatedAsync();
var baseDate = new DateTimeOffset(2000, 1, 1, 0, 0, 0, TimeSpan.Zero);
DateTimeOffset afterDays(double d)
=> baseDate + TimeSpan.FromDays(d);
if (context.Employees.Any())
{
return;
}
await context.Employees.AddRangeAsync(
new Employee
{
Name = "Standard Employee 1",
Role = EmployeeRole.Standard,
HolidayRequests = new Collection <HolidayRequest>
{
new HolidayRequest
{
StartDate = afterDays(3),
EndDate = afterDays(4),
Status = HolidayRequestStatus.Pending
},
new HolidayRequest
{
StartDate = afterDays(13),
EndDate = afterDays(14),
Status = HolidayRequestStatus.Approved
},
}
},
new Employee
{
Name = "Standard Employee 2",
Role = EmployeeRole.Standard,
HolidayRequests = new Collection <HolidayRequest>
{
new HolidayRequest
{
StartDate = afterDays(43),
EndDate = afterDays(45),
Status = HolidayRequestStatus.Pending
},
new HolidayRequest
{
StartDate = afterDays(16),
EndDate = afterDays(21),
Status = HolidayRequestStatus.Refused
},
}
},
new Employee
{
Name = "Standard Admin 1",
Role = EmployeeRole.Admin,
HolidayRequests = new Collection <HolidayRequest>
{
new HolidayRequest
{
StartDate = afterDays(3),
EndDate = afterDays(4),
Status = HolidayRequestStatus.Pending
},
new HolidayRequest
{
StartDate = afterDays(13),
EndDate = afterDays(14),
Status = HolidayRequestStatus.Pending
},
}
},
new Employee
{
Name = "Standard Employee 1",
Role = EmployeeRole.Standard,
HolidayRequests = new Collection <HolidayRequest>
{
new HolidayRequest
{
StartDate = afterDays(1),
EndDate = afterDays(30),
Status = HolidayRequestStatus.Refused
},
new HolidayRequest
{
StartDate = afterDays(10),
EndDate = afterDays(10.5),
Status = HolidayRequestStatus.Approved
},
}
});
await context.SaveChangesAsync();
}
public VacantionRepository(HolidayContext holidayContext)
: base(holidayContext)
{
}
static void Main(string[] args)
{
//KnowBaseContext db = new KnowBaseContext();
//ViewAuthority view1 = new ViewAuthority { Name = "Федеральные органы власти" };
//ViewAuthority view2 = new ViewAuthority { Name = "Миниципальные органы власти" };
//ViewAuthority view3 = new ViewAuthority { Name = "Региональные органы власти" };
//db.ViewAuthoritys.Add(view1);
//db.ViewAuthoritys.Add(view2);
//db.ViewAuthoritys.Add(view3);
//Territory terr1 = new Territory() { Name = "Город Магадан" };
//Territory terr2 = new Territory() { Name = "Ольский район" };
//Territory terr3 = new Territory() { Name = "Среднеканский район" };
//Territory terr4 = new Territory() { Name = "Хасынский район" };
//Territory terr5 = new Territory() { Name = "Омсукчанский район" };
//Territory terr6 = new Territory() { Name = "Сусуманский район" };
//Territory terr7 = new Territory() { Name = "Ягодный район" };
//Territory terr8 = new Territory() { Name = "Северо-Эвенский район" };
//Territory terr9 = new Territory() { Name = "Тенькинский район" };
//db.Territorys.Add(terr1);
//db.Territorys.Add(terr2);
//db.Territorys.Add(terr3);
//db.Territorys.Add(terr4);
//db.Territorys.Add(terr5);
//db.Territorys.Add(terr6);
//db.Territorys.Add(terr7);
//db.Territorys.Add(terr8);
//db.Territorys.Add(terr9);
//db.SaveChanges();
//Category cat1 = new Category() { Name = "Гражданско-правовой статус заявителя" };
//Category cat2 = new Category() { Name = "Земельно-имущественные отношения" };
//Category cat3 = new Category() { Name = "Налоги и сборы" };
//Category cat4 = new Category() { Name = "Образование" };
//Category cat5 = new Category() { Name = "Пенсионное обеспечение" };
//Category cat6 = new Category() { Name = "Предпринимательство" };
//Category cat7 = new Category() { Name = "Социальное обеспечение" };
//Category cat8 = new Category() { Name = "Социальное страхование" };
//Category cat9 = new Category() { Name = "Труд и занятость" };
//db.Category.Add(cat1);
//db.Category.Add(cat2);
//db.Category.Add(cat3);
//db.Category.Add(cat4);
//db.Category.Add(cat5);
//db.Category.Add(cat6);
//db.Category.Add(cat7);
//db.Category.Add(cat8);
//db.Category.Add(cat9);
//db.SaveChanges();
//var type = db.ViewAuthoritys.Where(c => c.Name.StartsWith("Федеральные")).FirstOrDefault();
//var area = db.Territorys.Where(c => c.Name.StartsWith("Город Магадан")).FirstOrDefault();
//Authority aut = new Authority();
//aut.Name = "Государственная инспекция труда в Магаданской области";
//aut.ViewAuth = type;
//aut.Terr = area;
//db.Authoritys.Add(aut);
//db.SaveChanges();
//var list = db.Authoritys.Join(db.Territorys, // второй набор
// p => p.TerritoryId, // свойство-селектор объекта из первого набора
// c => c.Id, // свойство-селектор объекта из второго набора
// (p, c) => new // результат
// {
// Name = p.Name,
// NameTerritory = c.Name,
// });
//foreach (var item in list)
//{
// Console.WriteLine(item.Name + "" + item.NameTerritory);
//}
//var list2 = db.Territorys.ToList();
//var aut2 = db.Authoritys.ToList();
//foreach (var item in list2)
//{
// Console.WriteLine(item.Name);
// var it = aut2.Where(c => c.TerritoryId == item.Id);
// foreach (var i in it)
// {
// Console.WriteLine(i.Name);
// }
//}
//EmployeeContext db2 = new EmployeeContext();
//Employee emp = new Employee()
//{
// LastName = "Жлобицкий",
// FirstName = "Владимир",
// MiddleName = "Александрович",
// DateOfBirth = DateTime.Parse("30.08.1990"),
// Post = "Инженер-программист"
//};
//db2.Staff.Add(emp);
//db2.SaveChanges();
//foreach (Employee item in db2.Staff)
//{
// Console.WriteLine(item.LastName);
//}
//AdContext db = new AdContext();
//Ad ad = new Ad();
//ad.Header = "Обьявления";
//ad.Text = "Текск";
//ad.TheValidity = DateTime.Parse("01.01.2018");
//db.Ads.Add(ad);
//db.SaveChanges();
//foreach (var item in db.Ads)
//{
// Console.WriteLine(item.Header);
//}
HolidayContext con = new HolidayContext();
Holiday ho = new Holiday()
{
Name = "Праздник 1", Date = DateTime.Parse("18.04.2017")
};
Holiday ho2 = new Holiday()
{
Name = "Праздник 2", Date = DateTime.Parse("18.04.2017")
};
Holiday ho3 = new Holiday()
{
Name = "Праздник 3", Date = DateTime.Parse("18.04.2017")
};
Holiday ho4 = new Holiday()
{
Name = "Праздник 4", Date = DateTime.Parse("18.04.2017")
};
Holiday ho5 = new Holiday()
{
Name = "Праздник 5", Date = DateTime.Parse("18.04.2017")
};
con.Holidays.Add(ho);
con.Holidays.Add(ho2);
con.Holidays.Add(ho3);
con.Holidays.Add(ho4);
con.Holidays.Add(ho5);
con.SaveChanges();
Console.WriteLine("Работа завершена");
Console.ReadLine();
}
public VacantionService(IRepositoryWrapper vacantion, HolidayContext holidayContext)
{
repositoryWrapper = vacantion;
_holidayContext = holidayContext;
}
