public void insertRequisitionDetailsGF(RequisitionDetailsGF red) { var req = ctx.requisitions.FirstOrDefault(o => o.requisitionId == red.RequisitionId); requisitionDetail newred = new requisitionDetail(); newred.requisitionId = red.RequisitionId; newred.itemId = red.ItemId; newred.requestedQty = red.RequesetedQty; newred.deliveredQty = red.DeliveredQty; // newred.status = red.Status; req.requisitionDetails.Add(newred); ctx.SaveChanges(); //gaofan }
public void insertRequisitionDetails(RequisitionDetailsGF red) { requisitiongf.insertRequisitionDetailsGF(red); }
public List<RequisitionDetailsGF> getRequisitionDetailsByRequisitionIdGF(string requisitionId) { var item = from x in ctx.requisitionDetails where x.requisitionId == requisitionId select new { requsitionId = x.requisitionId, itemId = x.itemId, requestedQty = x.requestedQty, deliveredQty = x.deliveredQty, //status = x.status, itemName = x.item.description }; List<RequisitionDetailsGF> list = new List<RequisitionDetailsGF>(); foreach (var a in item) { RequisitionDetailsGF red = new RequisitionDetailsGF(); red.RequisitionId = a.requsitionId; red.ItemId = a.itemId; red.RequesetedQty = Convert.ToInt32(a.requestedQty); red.DeliveredQty = Convert.ToInt32(a.deliveredQty); // red.Status = a.status; red.ItemName = a.itemName; list.Add(red); } return list; //gaofan }