public ActionResult List() { RahmanDbEntities objdb = new RahmanDbEntities(); { tblOrderMst objtblOrdMst = new tblOrderMst(); { List <tblOrderMst> result = objdb.tblOrderMsts.ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); } } }
public ActionResult SaveEmpDetail(OrderMst objOrder) { RahmanDbEntities objdb = new RahmanDbEntities(); if (objOrder.CustomerName == null || objOrder.OrderDetail == null) { ViewBag.msg = "Plz Fill all the details"; return(View("EmpDetail")); } else { tblOrderMst objordmst = new tblOrderMst(); // List<tblOrderDt objordDt = new tblOrderDt(); { objordmst.OrderNo = objOrder.No; objordmst.OrdDate = objOrder.Date; objordmst.CustName = objOrder.CustomerName; } objdb.tblOrderMsts.Add(objordmst); objdb.SaveChanges(); var id = objdb.tblOrderMsts.OrderByDescending(x => x.OrderId).First().OrderId; foreach (var lstg in objOrder.OrderDetail) { tblOrderDt objdt = new tblOrderDt(); objdt.OrderId = id; objdt.Item = lstg.Item; objdt.Quantity = lstg.Quantity; objdt.Rate = lstg.Rate; objdb.tblOrderDts.Add(objdt); objdb.SaveChanges(); } } return(Json(" Data Successfuly Saved")); }