Esempio n. 1
0
        public ActionResult Create([Bind(Include = "cid,cname")] tbl_category tbl_category)
        {
            if (ModelState.IsValid)
            {
                db.tbl_category.Add(tbl_category);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(tbl_category));
        }
Esempio n. 2
0
        public ActionResult Create([Bind(Include = "pid,pname,pprice,pdetails,cid")] tbl_product tbl_product)
        {
            if (ModelState.IsValid)
            {
                db.tbl_product.Add(tbl_product);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.cid = new SelectList(db.tbl_category, "cid", "cname", tbl_product.cid);
            return(View(tbl_product));
        }
Esempio n. 3
0
        public ActionResult doneorder(tbl_orders tb, string total)
        {
            tbl_orders obj = new tbl_orders();

            obj.opname     = tb.opname;
            obj.opphone    = tb.opphone;
            obj.opaddress  = tb.opaddress;
            obj.opsaddress = tb.opsaddress;
            obj.ostatus    = 0;
            // obj.oamount = int.Parse(total);
            obj.oamount = total;
            db.tbl_orders.Add(obj);
            db.SaveChanges();

            var moid = db.tbl_orders.Select(a => a.oid).DefaultIfEmpty(0).Max();


            var pro = from prod in ok.c
                      join od in db.tbl_product
                      on prod.iid equals od.pid
                      select new { PID = od.pid, PPRICE = od.pprice, PQTY = prod.iqty };


            foreach (var item in pro)
            {
                tbl_order_details orderdetails = new tbl_order_details();

                orderdetails.oid     = moid;
                orderdetails.pid     = item.PID;
                orderdetails.pprice  = item.PPRICE;
                orderdetails.pqty    = item.PQTY;
                orderdetails.pamount = item.PQTY * item.PPRICE;

                db.tbl_order_details.Add(orderdetails);
                db.SaveChanges();
            }

            ok.amt = 0;
            ok.c.Clear();

            return(RedirectToAction("Index"));
        }