public static void WriteFileInDB(List<HttpPostedFileBase> files,int idBet) { BetsDBDataContext context = new BetsDBDataContext(); foreach (HttpPostedFileBase fileFromPost in files) { using (var stream = fileFromPost.InputStream) { using (var reader = new BinaryReader(fileFromPost.InputStream)) { byte[] file = reader.ReadBytes((int)stream.Length); BetFile betfile = new BetFile(); betfile.name = fileFromPost.FileName; betfile.file = file; context.BetFiles.InsertOnSubmit(betfile); context.SubmitChanges(); BindBetFile bindBF = new BindBetFile(); bindBF.idBet = idBet; bindBF.idBetFile = betfile.id; context.BindBetFiles.InsertOnSubmit(bindBF); context.SubmitChanges(); } } } }
public ActionResult CreateBet(MyBetModel newBet) { try { // TODO: Add insert logic here BetsDBDataContext context = new BetsDBDataContext(); Bet bet = new Bet(); bet.name = newBet.Name; bet.description = newBet.Description; context.Bets.InsertOnSubmit(bet); context.SubmitChanges(); if (Request.Files.Count > 0) { List<HttpPostedFileBase> files = TempData["appl"] as List<HttpPostedFileBase>; if (files != null && files.Count != 0) { MyBetModel.WriteFileInDB(files, bet.id); TempData.Clear(); } } return RedirectToAction("CreateOutcome", "Outcome", new { idBet = bet.id }); } catch { return View(); } }
public ActionResult Edit(MyBetModel betM) { try { BetsDBDataContext context = new BetsDBDataContext(); Bet bet = context.Bets.Where(b => b.id == betM.id).First(); if(bet!=null) { bet.name = betM.Name; bet.description = betM.Description; context.SubmitChanges(); return RedirectToAction("Index", new { id = bet.id }); } return RedirectToAction("Index","Home"); } catch { return View(); } }