//
// GET: /Home/
public ActionResult Index()
{
//using (MyContext context = new MyContext())
//{
// string name= context.Set<Student>().FirstOrDefault().Name;
// name = context.Set<Student>().FirstOrDefault().Courses.FirstOrDefault().Name;
//}
//using (MyContext context = new MyContext())
//{
// string name = context.Set<Student>().FirstOrDefault().Name;
// name = context.Set<Student>().FirstOrDefault().Courses.FirstOrDefault().Name;
//}
using (SCContext a = new SCContext())
{
a.Set <Student>().Add(new Student {
Name = "1"
});
a.SaveChanges();
}
//using (UserRoleDbContext2 a = new UserRoleDbContext2())
//{
// a.Set<User>().Add(new User { Name = "1" });
// a.SaveChanges();
//}
return(Content(""));
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
var appSettings = services.AddAppSettings(Configuration);
services.AddHostedService <QueuedHostedBackgroundServicev>();
services.AddSingleton <IBackgroundTaskQueue, BackgroundTaskQueue>();
services.AddScoped <SCContextBase, SCContext>((sp) => new SCContext(appSettings));
services.AddControllersWithViews();
// In production, the React files will be served from this directory
services.AddSpaStaticFiles(configuration =>
{
configuration.RootPath = "ClientApp/build";
});
// Configure JWT
var key = Encoding.ASCII.GetBytes(appSettings.Authentication.JwtSecretKey);
services.AddAuthentication(x =>
{
x.DefaultAuthenticateScheme = JwtBearerDefaults.AuthenticationScheme;
x.DefaultChallengeScheme = JwtBearerDefaults.AuthenticationScheme;
})
.AddJwtBearer(x =>
{
x.RequireHttpsMetadata = false;
x.SaveToken = true;
x.TokenValidationParameters = new TokenValidationParameters
{
ValidateIssuerSigningKey = true,
IssuerSigningKey = new SymmetricSecurityKey(key),
ValidateIssuer = false,
ValidateAudience = false
};
});
services.AddSingleton <IChatMessagesQueue, ChatMessagesQueue>();
services.AddScoped <IUserService, UserService>();
services.AddHostedService <LogoutExpiredBackgroundService>();
using (var dbctx = new SCContext(appSettings))
{
dbctx.Database.Migrate();
}
Action <HttpClient> secServicesConfigClient = client =>
{
client.BaseAddress = new Uri(appSettings.StockApiBaseAddress);
client.DefaultRequestHeaders.Add("Accept", "text/csv; charset=utf-8");
client.DefaultRequestHeaders.Add("User-Agent", "Mangau Stock Chat");
};
services.AddHttpClient <ISockApiClient, StockApiClient>(secServicesConfigClient);
}
public Department GetDepartmentByCode(string code)
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
DepartmentBusiness departmentBusiness = new DepartmentBusiness(uow);
var department = departmentBusiness.GetDepartmentByCode(code);
return(department);
}
}
public List <Department> GetAllDepartment()
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
DepartmentBusiness departmentBusiness = new DepartmentBusiness(uow);
var departments = departmentBusiness.GetAllDepartment();
return(departments.ToList());
}
}
public List <Student> GetAllStudent()
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
StudentBusiness studentBusiness = new StudentBusiness(uow);
var students = studentBusiness.GetAllStudent();
return(students.ToList());
}
}
public List <Course> GetAllCourse()
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
CourseBusiness courseBusiness = new CourseBusiness(uow);
var courseList = courseBusiness.GetAllCourse();
return(courseList.ToList());
}
}
public Course GetCourseByCode(string code)
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
CourseBusiness courseBusiness = new CourseBusiness(uow);
var course = courseBusiness.GetCourseByCode(code);
return(course);
}
}
public bool DeleteDepartment(long id)
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
DepartmentBusiness departmentBusiness = new DepartmentBusiness(uow);
bool success = departmentBusiness.DeleteDepartment(id);
uow.SaveChanges();
return(success);
}
}
public bool DeleteCourse(long id)
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
CourseBusiness courseBusiness = new CourseBusiness(uow);
var course = courseBusiness.DeleteCourse(id);
uow.SaveChanges();
return(true);
}
}
public bool SaveStudent(Student student)
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
StudentBusiness studentBusiness = new StudentBusiness(uow);
bool saved = studentBusiness.SaveStudent(student);
uow.SaveChanges();
return(saved);
}
}
public Student GetStudentByCode(string code)
{
SCContext context = new SCContext(_contextName);
IUnitOfWork uow = new UnitOfWork(context);
IGenericDataRepository <Student> studentRepo = uow.RepositoryFor <Student>();
var student = studentRepo.GetSingle(p => p.StudentCode.Equals(code));
uow.Dispose();
return(student);
}
public bool SaveDepartment(Department department)
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
DepartmentBusiness departmentBusiness = new DepartmentBusiness(uow);
bool saved = departmentBusiness.SaveDepartment(department);
uow.SaveChanges();
return(saved);
}
}
public bool SaveCourse(Course course)
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
CourseBusiness courseBusiness = new CourseBusiness(uow);
bool saved = courseBusiness.SaveCourse(course);
uow.SaveChanges();
return(saved);
}
}
public bool DeleteStudent(long id)
{
using (SCContext context = new SCContext(_contextName)) {
IUnitOfWork uow = new UnitOfWork(context);
StudentBusiness studentBusiness = new StudentBusiness(uow);
bool saved = studentBusiness.SaveStudent(new Student {
StudentID = id, EntityState = EntityState.Deleted
});
uow.SaveChanges();
return(saved);
}
}
private static void Main(string[] args)
{
using (var db = new SCContext())
{
Console.WriteLine("Preparing database...");
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
Console.WriteLine("Done");
}
}
public MaterialsService(SCContext _context)
{
db = _context;
}
public UserRepository(SCContext context) : base(context)
{
this.context = context;
}
public EXArticleRankList(SCContext context, IMemoryCache memoryCache)
{
db = context;
_memoryCache = memoryCache;
}
public AskService(SCContext _context)
{
db = _context;
}
public TopicStatistics(SCContext context, IMemoryCache memoryCache)
{
db = context;
_memoryCache = memoryCache;
}
public TournamentRepository(SCContext context) : base(context)
{
this.context = context;
}
public GroupRepository(SCContext context) : base(context)
{
this.context = context;
}
public BreakRepository(SCContext context) : base(context)
{
this.context = context;
}
public LeagueRepository(SCContext context) : base(context)
{
this.context = context;
}
public EXArticleTempService(SCContext _context)
{
db = _context;
}
public FrameRepository(SCContext context) : base(context)
{
this.context = context;
}
public PlayerPositionTournamentRepository(SCContext context) : base(context)
{
this.context = context;
}
public TopicRankList(SCContext context, IMemoryCache memoryCache)
{
db = context;
_memoryCache = memoryCache;
}
public StartupServiceImpl(SCContext sCContext)
{
_dbcontext = sCContext;
}
public MaterialsRankList(SCContext context, IMemoryCache memoryCache)
{
db = context;
_memoryCache = memoryCache;
}
