public ActionResult Create(HttpPostedFileBase upload, [Bind(Include = "RdInvoiceId,RdId,RdInvoiceDate")] RdInvoice rdInvoice)
        {
            if (ModelState.IsValid)
            {
                db.RdInvoices.Add(rdInvoice);
                db.SaveChanges();

                //Insert data into RdProduct Table from CSV file.
                RdProduct product = new RdProduct();
                var       invoId  = (from cust in db.RdInvoices
                                     select cust).OrderByDescending(m => m.RdInvoiceId).First();
                StreamReader csvreader = new StreamReader(upload.InputStream);
                while (!csvreader.EndOfStream)
                {
                    var line   = csvreader.ReadLine();
                    var values = line.Split(',');
                    product.RdInvoiceId = invoId.RdInvoiceId;
                    product.ModelName   = values[0].ToString();
                    product.EmiNo       = values[1].ToString();


                    db.RdProducts.Add(product);
                    db.SaveChanges();
                }

                return(RedirectToAction("Index"));
            }

            ViewBag.RdId = new SelectList(db.Rds, "RdId", "RdId", rdInvoice.RdId);


            return(View(rdInvoice));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            RdInvoice rdInvoice = db.RdInvoices.Find(id);

            db.RdInvoices.Remove(rdInvoice);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "RdInvoiceId,RdId,RdInvoiceDate")] RdInvoice rdInvoice)
 {
     if (ModelState.IsValid)
     {
         db.Entry(rdInvoice).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.RdId = new SelectList(db.Rds, "RdId", "RdId", rdInvoice.RdId);
     return(View(rdInvoice));
 }
        // GET: RdInvoices/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            RdInvoice rdInvoice = db.RdInvoices.Find(id);

            if (rdInvoice == null)
            {
                return(HttpNotFound());
            }
            return(View(rdInvoice));
        }
        // GET: RdInvoices/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            RdInvoice rdInvoice = db.RdInvoices.Find(id);

            if (rdInvoice == null)
            {
                return(HttpNotFound());
            }
            ViewBag.RdId = new SelectList(db.Rds, "RdId", "RdId", rdInvoice.RdId);
            return(View(rdInvoice));
        }