public ActionResult Create([Bind(Include = "freeQuote,ConsumerName,email,Size,weight,CollectionDate,deliveryDate,contactCell,contactwork,testtext,two,Collection,Dropoff,finna")] Freequote freequote)
        {
            if (ModelState.IsValid)
            {
                var    s    = db.CalAmts.Where(x => x.id == 1);
                double f    = Convert.ToDouble(s.Sum(y => y.fuel));
                double vat  = Convert.ToDouble(db.Vats.Sum(x => x.vat)); // Convert.ToDouble(s.Sum(b => b.Vat));
                double rate = Convert.ToDouble(s.Sum(m => m.Rate));
                string neww = freequote.testtext;

                neww = neww.Replace("km", "");
                neww = neww.Replace(",", "");
                neww = neww.Trim();

                string dist = neww;
                freequote.two = Convert.ToDouble(neww, CultureInfo.InvariantCulture);
                freequote.two = Math.Round(freequote.two);

                freequote.finna = (f * freequote.two * (vat / 100) * (rate / 100));

                db.Freequotes.Add(freequote);
                db.SaveChanges();
                return(RedirectToAction("Details/" + freequote.freeQuote));
            }

            return(View(freequote));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            Freequote freequote = db.Freequotes.Find(id);

            db.Freequotes.Remove(freequote);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "freeQuote,ConsumerName,email,Size,weight,CollectionDate,deliveryDate,contactCell,contactwork,testtext,two,Collection,Dropoff,finna")] Freequote freequote)
 {
     if (ModelState.IsValid)
     {
         db.Entry(freequote).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(freequote));
 }
        // GET: Freequotes1/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Freequote freequote = db.Freequotes.Find(id);

            if (freequote == null)
            {
                return(HttpNotFound());
            }
            return(View(freequote));
        }