// POST api/championship/new
        public string[] PostNewWinner()
        {
            var c = HttpContext.Current;
            var data = c.Request.Params["data"];
            Championship getwinner = new Championship(); 
            getwinner.setNodes(data);

          
            return new string[]
                {
                    "winner : [" + '"' + getwinner._winner._name + '"' + ", " + '"' + getwinner._winner._play + '"' + "]"  
                };
            
        }
        public ActionResult Index(HttpPostedFileBase file)
        {
            if (ModelState.IsValid)
            {
                if (file == null)
                {
                    ModelState.AddModelError("File", "Please Upload Your file");
                }
                else if (file.ContentLength > 0)
                {
                    int MaxContentLength = 1024 * 1024 * 10; //10 MB
                    string[] AllowedFileExtensions = new string[] { ".txt" };

                    if (!AllowedFileExtensions.Contains(file.FileName.Substring(file.FileName.LastIndexOf('.'))))
                    {
                        ModelState.AddModelError("File", "Please file of type: " + string.Join(", ", AllowedFileExtensions));
                    }

                    else if (file.ContentLength > MaxContentLength)
                    {
                        ModelState.AddModelError("File", "Your file is too large, maximum allowed size is: " + MaxContentLength + " MB");
                    }
                    else
                    {
                        //TO:DO
                        var fileName = Path.GetFileName(file.FileName);
                        var path = Path.Combine(Server.MapPath("~/Content/Upload"), fileName);
                        file.SaveAs(path);
                        Championship chmp = new Championship(path);
                        chmp.setFinalists();
                        ModelState.Clear();
                        int[] points = chmp.getpointsperwin();


                        var first = chmp._winner._name;
                        var second = chmp._secondPlace._name;
                        
                        int[] pts = chmp.getpointsperwin();
                        Database dataB = db.Database;
                        dataB.CreateIfNotExists();
                        var sql = @"EXEC dbo.usp_updatewinners {0},{1},{2},{3}";
                        db.Database.ExecuteSqlCommand(sql, first, second, pts[0], pts[1]);

                        ModelState.AddModelError("File", "File uploaded successfully;" + chmp.getWinners(points[0], points[1]));
                    }
                }
            }
            return View();
        }
        // POST api/championship/result
        public string[] PostResultWinner()
        {
            var c = HttpContext.Current;
            var second = c.Request.Params["second"];
            var first = c.Request.Params["first"];
            var chmp = new Championship();
            int[] pts = chmp.getpointsperwin();
            Database dataB = db.Database;
            dataB.CreateIfNotExists();
            var sql = @"EXEC dbo.usp_updatewinners {0},{1},{2},{3}";
            db.Database.ExecuteSqlCommand(sql, first, second, pts[0], pts[1]);
 

            return new string[]
                {
                     "success"
                };


        }