public WorkHoursController(RoleManager <IdentityRole> roleManager,
UserManager <UserModel> userManager,
EFCContext context)
{
this.roleManager = roleManager;
this.userManager = userManager;
_context = context;
}
public CalendarController(RoleManager <IdentityRole> roleManager,
UserManager <UserModel> userManager,
IDepartmentService departmentService,
ICalendarService calendarService,
EFCContext context)
{
this.roleManager = roleManager;
this.userManager = userManager;
this.departmentService = departmentService;
this.calendarService = calendarService;
_context = context;
}
static async Task Main(string[] args)
{
//połączenie do bazy w pliku (localdb)
var contextOptions = new DbContextOptionsBuilder <EFContext>()
.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=EFC");
using (var context = new EFContext(contextOptions.Options))
{
context.Database.Migrate();
await new PeopleService(context).ReadAsync();
}
//połączenie do bazy w SqlServer
using (var context = new EFCContext())
{
//context.Database.Migrate();
var result = context.Set <DAL2.Models.Person>().ToListAsync();;
}
}
/// <summary>
/// Wypełnia bazę w pamięci przykładowymi danymi. Dodatkowo wyświetla dodane dane w konsoli.
/// </summary>
protected void DbInit()
{
using (var context = new EFCContext())
{
var bookFaker = new Faker <BookModel>();
bookFaker.RuleFor(x => x.Title, faker => faker.Lorem.Word().ToUpperFirstLetter());
bookFaker.RuleFor(x => x.Author, faker => $"{faker.Person.FirstName} {faker.Person.LastName}");
var bookModels = bookFaker.Generate(6);
foreach (var b in bookModels)
{
Console.WriteLine($"Book: {b.ID}, {b.Title}, {b.Author}");
}
var readerFaker = new Faker <ReaderModel>();
readerFaker.RuleFor(x => x.Name, faker => $"{faker.Person.FirstName} {faker.Person.LastName}");
readerFaker.RuleFor(x => x.Age, faker => faker.Random.Number(10, 100));
var readerModels = readerFaker.Generate(8);
foreach (var r in readerModels)
{
Console.WriteLine($"Reader: {r.ID}, {r.Name}, {r.Age}");
}
var bookReaderFaker = new Faker <BookReaderModel>();
bookReaderFaker.RuleFor(x => x.BookID, faker => faker.IndexFaker);
bookReaderFaker.RuleFor(x => x.ReaderID, faker => faker.IndexFaker);
// bookReaderFaker.RuleFor(x => x.LendDate, faker => faker.Date.Past());
bookReaderFaker.RuleFor(x => x.LendDate, faker => faker.Date.Past().ToLocalTime());
var bookReaderModels = bookReaderFaker.Generate(2);
//var lendDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
foreach (var br in bookReaderModels)
{
Console.WriteLine($"Book-Reader: {br.ID}, {br.BookID}, {br.ReaderID}, {br.LendDate}");
}
context.Books.AddRange(bookModels);
context.Readers.AddRange(readerModels);
context.BookReader.AddRange(bookReaderModels);
context.SaveChanges();
}
}
protected static EFCContext GetEFCContext(DBProvider dBProvider, string connectionString = null,
[CallerFilePath] string callingFile = null)
{
var optionsBuilder = new DbContextOptionsBuilder <EFCContext>();
var services = new ServiceCollection();
services.AddLogging(
loggingBuilder =>
{
loggingBuilder.SetMinimumLevel(LogLevel.Trace);
loggingBuilder.AddConsole();
});
var serviceProvider = services.BuildServiceProvider();
var loggerFactory = serviceProvider.GetService <ILoggerFactory>();
optionsBuilder.EnableDetailedErrors();
optionsBuilder.EnableSensitiveDataLogging();
optionsBuilder.UseLoggerFactory(loggerFactory);
switch (dBProvider)
{
case DBProvider.InMemory:
var fileName = System.IO.Path.GetFileNameWithoutExtension(callingFile);
var dbName = $"db_{fileName}";
optionsBuilder.UseInMemoryDatabase(dbName, inMemoryDbRoot);
break;
case DBProvider.SqlServer:
optionsBuilder.UseSqlServer(connectionString);
break;
}
var context = new EFCContext(optionsBuilder.Options);
return(context);
}
public WorkHoursService(EFCContext context)
{
_context = context;
}
public InstructorsController(EFCContext context)
{
_context = context;
}
public StudentsController(EFCContext context)
{
_context = context;
}
public CustomerData(EFCContext context) : base(context)
{
}
/// <summary>
/// Konstruktor.
/// </summary>
/// <param name="context">Obiekt Kontekstu.</param>
public LendController(EFCContext context)
{
Context = context;
}
/// <summary>
/// Konstruktor.
/// </summary>
/// <param name="context">Obiekt Kontekstu.</param>
public ReadersController(EFCContext context)
{
Context = context;
}
public SummaryController()
{
_context = new EFCContext();
}
public CustomersController(IMapper mapper)
{
_context = new EFCContext();
_mapper = mapper;
}
public DepartmentService(EFCContext context)
{
_context = context;
}
public DepartmentsController(EFCContext context)
{
_context = context;
}
public VehiclePolicyController(EFCContext context)
{
_context = context;
}
public CustomerDbService(EFCContext context)
{
_context = context;
}
//konstruktor do wstrzykiwania zależności
public CartController(EFCContext context, CartModel cartService)
{
cart = cartService;
_context = context;
}
public CreateHeroController(EFCContext context, UserManager <IdentityUser> userManager)
{
_context = context;
UserManager = userManager;
}
public IKDDSModelController()
{
_context = new EFCContext();
}
public ExcelController(IHostingEnvironment hostingEnvironment, EFCContext context, IHttpContextAccessor accessor)
{
_context = context;
_hostingEnvironment = hostingEnvironment;
_accessor = accessor;
}
public MoviesController()
{
_context = new EFCContext();
}
public HomeController(EFCContext context)
{
_context = context;
}
public AccountController(SignInManager <IdentityUser> signInManager, EFCContext context, UserManager <IdentityUser> userManager)
{
SignInManager = signInManager;
UserManager = userManager;
_context = context;
}
public CompanyController(EFCContext context)
{
_context = context;
}
/// <summary>
/// Konstruktor.
/// </summary>
/// <param name="context">Obiekt Kontekstu.</param>
public BooksController(EFCContext context)
{
Context = context;
}
private static void AddTestData(EFCContext context)
{
var clients = new[]
{
new CLIENT {
CLIENT_ID = "CL99", CLIENT_NAME = "Client 99"
},
//new CLIENT {CLIENT_ID ="CL80", CLIENT_NAME ="Client 80"}
};
var clientContacts = new[]
{
new CLIENT_CONTACT {
CLIENT_ID = "CL99", CONTACT_ID = 1, CONTACT_NAME = "Contact 1", CONTACT_EMAIL = "*****@*****.**"
},
new CLIENT_CONTACT {
CLIENT_ID = "CL99", CONTACT_ID = 2, CONTACT_NAME = "Contact 2", CONTACT_EMAIL = "*****@*****.**"
},
new CLIENT_CONTACT {
CLIENT_ID = "CL99", CONTACT_ID = 3, CONTACT_NAME = "Contact 3", CONTACT_EMAIL = "*****@*****.**"
},
new CLIENT_CONTACT {
CLIENT_ID = "CL99", CONTACT_ID = 4, CONTACT_NAME = "Contact 4", CONTACT_EMAIL = "*****@*****.**"
},
};
var orders = new[]
{
new ORDER {
ORDER_ID = 1, CLIENT_ID = "CL99", CREATION_DATE = DateTime.Now.Subtract(TimeSpan.FromDays(10))
},
new ORDER {
ORDER_ID = 2, CLIENT_ID = "CL99", CREATION_DATE = DateTime.Now.Subtract(TimeSpan.FromDays(5))
},
new ORDER {
ORDER_ID = 3, CLIENT_ID = "CL99", CREATION_DATE = DateTime.Now.Subtract(TimeSpan.FromDays(2))
},
new ORDER {
ORDER_ID = 4, CLIENT_ID = "CL99", CREATION_DATE = DateTime.Now
},
};
var orderDetails = new[]
{
new ORDER_DETAIL {
ORDER_ID = 1, CLIENT_ID = null, BILLING_TYPE = "B0"
}, //no contact information
new ORDER_DETAIL {
ORDER_ID = 2, CLIENT_ID = "CL99", BILLING_CONTACT_ID = 1, SHIPPING_CONTACT_ID = 2, BILLING_TYPE = "B0"
}, // Both contacts set
new ORDER_DETAIL {
ORDER_ID = 3, CLIENT_ID = "CL99", SHIPPING_CONTACT_ID = 3, BILLING_TYPE = "B1"
}, //only Shipping contact
new ORDER_DETAIL {
ORDER_ID = 4, CLIENT_ID = "CL99", BILLING_CONTACT_ID = 4, BILLING_TYPE = "B3"
}, //only billing contact
};
try
{
context.AddRange(clients);
context.AddRange(clientContacts);
context.AddRange(orders);
context.AddRange(orderDetails);
var result = context.SaveChanges();
Console.WriteLine($"Test data added to {context.Database.ProviderName}, result => {result}");
}
catch (Exception ex)
{
Console.WriteLine($"Failed {nameof(AddTestData)} {ex}");
}
}
public RSDController()
{
_context = new EFCContext();
}
public EnrollmentsController(EFCContext context)
{
_context = context;
}
public UserWorkHoursViewModelService(EFCContext context)
{
_context = context;
}
