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 Index()
{
var tmp = DateTime.Now.AddYears(18) < DateTime.Now.AddYears(19);
ViewBag.Message = "Page containin all bets";
BetsDBDataContext context = new BetsDBDataContext();
ViewBag.ListOfBetLinks = context.Bets.Select(f => f.name+"|"+f.id);
return View();
}
public ActionResult TruncateAllTables()
{
BetsDBDataContext context = new BetsDBDataContext();
context.ExecuteCommand("TRUNCATE TABLE [MyBets].[dbo].[OutcomeFiles]" +
"TRUNCATE TABLE [MyBets].[dbo].[BetFiles] " +
"TRUNCATE TABLE [MyBets].[dbo].[Outcomes]" +
"TRUNCATE TABLE [MyBets].[dbo].[Bets]" +
"TRUNCATE TABLE [MyBets].[dbo].[BindBetFile]" +
"TRUNCATE TABLE [MyBets].[dbo].[BindBetOutcome]" +
"TRUNCATE TABLE [MyBets].[dbo].[BindOutcomeFile]");
return RedirectToAction("Index");
}
public static void ReadFileFromDB()
{
BetsDBDataContext context = new BetsDBDataContext();
var file = context.BetFiles.Where(f => f.name == "1").FirstOrDefault();
var t = file.file;
}
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();
}
}
