예제 #1
0
        public IActionResult AddProgram(ProgramModel programModel)
        {
            string[] pathParts = programModel.ImageFile.FileName.Split("\\");

            var fileName = pathParts.Last();

            var imagePath = _env.WebRootPath + "\\images\\" + fileName;

            //var fileInfo = new FileInfo(programModel.ImagePath);

            using (var stream = new FileStream(imagePath, FileMode.Create))
            {
                programModel.ImageFile.CopyTo(stream);
            }

            var optionsBuilder = new DbContextOptionsBuilder <PowerContext>();

            optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=PowerDB;Trusted_Connection=True;ConnectRetryCount=0");

            var trainingItemImage = new TrainingItemImage();

            trainingItemImage.FilePath = "~/images/" + fileName;

            var imageRepo = new TrainingItemImageDbo(optionsBuilder);

            programModel.Program.Image = trainingItemImage;

            var programRepo = new ProgramDbo(optionsBuilder);

            programRepo.Add(programModel.Program);

            return(RedirectToAction("Index"));
        }
예제 #2
0
        public IActionResult Index()
        {
            ProgramIndexModel model = new ProgramIndexModel();

            var optionsBuilder = new DbContextOptionsBuilder <PowerContext>();

            optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=PowerDB;Trusted_Connection=True;ConnectRetryCount=0");

            var repo = new ProgramDbo(optionsBuilder);



            model.items = repo.GetAll();

            return(View(model));
        }
예제 #3
0
        public IActionResult Details(int id)
        {
            var program = new Power.BO.Program();

            var optionsBuilder = new DbContextOptionsBuilder <PowerContext>();

            optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=PowerDB;Trusted_Connection=True;ConnectRetryCount=0");

            var programRepo = new ProgramDbo(optionsBuilder);

            program = programRepo.GetProgram(id);

            ProgramModel model = new ProgramModel()
            {
                Program   = program,
                ImagePath = program.Image.FilePath
            };

            return(View(model));
        }