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")); }
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)); }
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)); }