public ActionResult DeleteConfirmed(int id)
        {
            Tr_Details tr_Details = db.Tr_Details.Find(id);

            db.Tr_Details.Remove(tr_Details);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "Tr_DetailID,Tr_MasterID,BookGroupID,BookID,Qty,Rate,Commission")] Tr_Details tr_details)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tr_details).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.Tr_MasterID = new SelectList(db.Tr_Masters, "Tr_MasterID", "MemoNo", tr_details.Tr_MasterID);
     return(View(tr_details));
 }
        public ActionResult Create([Bind(Include = "Tr_DetailID,Tr_MasterID,BookGroupID,BookID,Qty,Rate,Commission")] Tr_Details tr_details)
        {
            if (ModelState.IsValid)
            {
                //tr_details.Tr_DetailID = Guid.NewGuid();
                db.Tr_Details.Add(tr_details);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.Tr_MasterID = new SelectList(db.Tr_Masters, "Tr_MasterID", "MemoNo", tr_details.Tr_MasterID);
            return(View(tr_details));
        }
        // GET: Tr_Details/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Tr_Details tr_Details = db.Tr_Details.Find(id);

            if (tr_Details == null)
            {
                return(HttpNotFound());
            }
            return(View(tr_Details));
        }
        // GET: /Tr_Details/Edit/5
        public ActionResult Edit(Guid?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Tr_Details tr_details = db.Tr_Details.Find(id);

            if (tr_details == null)
            {
                return(HttpNotFound());
            }
            ViewBag.Tr_MasterID = new SelectList(db.Tr_Masters, "Tr_MasterID", "MemoNo", tr_details.Tr_MasterID);
            return(View(tr_details));
        }
        //GET: Tr_Details/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Tr_Details tr_Details = db.Tr_Details.Find(id);

            if (tr_Details == null)
            {
                return(HttpNotFound());
            }
            ViewBag.BookGroupID = new SelectList(db.BookGroups, "BookGroupID", "MainBookName", tr_Details.BookGroupID);
            ViewBag.BookID      = new SelectList(db.Books, "BookID", "BookName", tr_Details.BookID);
            ViewBag.Tr_MasterID = new SelectList(db.Tr_Masters, "Tr_MasterID", "MemoNo", tr_Details.Tr_MasterID);
            return(View(tr_Details));
        }
        //.................


        //public ActionResult BookList()
        //{
        //    BookCreateVM book = new BookCreateVM();
        //    book.selectListOrganization = _select.SelectBook();
        //    return View(book);
        //}


        public ActionResult SaveOrder(int?invoiceNo, string memoNo, string salesType, int districtId, int clientID, int?packdebit, DateTime date, int?less, int commission2, decimal netAmount, Tr_Details[] Tr_Detail, Book[] book, BookGroup[] bookGroup, District[] district, Client[] client)
        {
            string result = "Error! Order Is Not Complete ";

            if (invoiceNo != null || memoNo != null || Tr_Detail != null || book != null || packdebit != null || bookGroup != null || district != null || client != null)
            {
                Tr_Masters model = new Tr_Masters();
                model.InvoiceNo  = invoiceNo;
                model.Less       = less;
                model.DistrictID = districtId;
                model.ClientID   = clientID;
                model.PackDebit  = packdebit;
                model.Type       = salesType;
                model.Commission = commission2;
                model.Tr_Date    = date;
                MoneyReceipt moneyReceipt = new MoneyReceipt();
                moneyReceipt.PartyCode = clientID;
                moneyReceipt.EntryDate = date;
                moneyReceipt.Amount    = netAmount;
                db.MoneyReceipts.Add(moneyReceipt);
                db.Tr_Masters.Add(model);
                foreach (var item in Tr_Detail)
                {
                    Tr_Details o = new Tr_Details();
                    o.BookID      = item.BookID;
                    o.BookGroupID = item.BookGroupID;
                    o.Qty         = item.Qty;
                    o.Rate        = item.Rate;
                    o.Commission  = item.Commission;
                    o.Amount      = item.Amount;
                    db.Tr_Details.Add(o);
                }

                db.SaveChanges();
                result = "Success Order Is Complete ";
            }
            return(Json(result, JsonRequestBehavior.AllowGet));
        }