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 int Add(TrainingItemImage t) { using (var context = new PowerContext(options.Options)) { context.Images.Add(t); return(context.SaveChanges()); } }