public IActionResult ArrowAceNine(int id)
        {
            var str = db.ClosedLost.Where(x => x.Id == id).ToList();

            foreach (var val in str) // iterator the data from the list and insert them into the listSecond
            {
                string    SalesStage = "ClosedWon";
                ClosedWon ls         = new ClosedWon();
                ls.Id                  = val.Id;
                ls.Name                = val.Name;
                ls.Rep                 = val.Rep;
                ls.SalesStage          = SalesStage;
                ls.Priority            = val.Priority;
                ls.ExpectedCloseDate   = val.ExpectedCloseDate;
                ls.ForeCastValue       = val.ForeCastValue;
                ls.Probability         = val.Probability;
                ls.LastContact         = val.LastContact;
                ls.SignedContractValue = val.SignedContractValue;
                ls.Notes               = val.Notes;



                db.ClosedWon.Add(ls);
            }
            db.SaveChanges();
            db.ClosedLost.Remove(db.ClosedLost.Find(id));

            db.SaveChanges();

            return(RedirectToAction("Index"));
        }
        public IActionResult Add(ClosedWon ClosedWon, Sales Sales)
        {
            db.ClosedWon.Add(ClosedWon);
            db.Sales.Add(Sales);
            db.SaveChanges();

            return(RedirectToAction("Index"));
        }
        public IActionResult Edit(int id, ClosedWon ClosedWon, Sales Sales)
        {
            db.Entry(ClosedWon).State = Microsoft.EntityFrameworkCore.EntityState.Modified;

            db.Entry(Sales).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
            db.SaveChanges();

            return(RedirectToAction("Index"));
        }