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"));
}
