public void createRequisition_PyaePyae(string requisitionId, DateTime date, string userId, string departmentId, string rejectReason, string status, DataTable requisitionDetails) { requisitionEntity = new requisition(); requisitionEntity.requisitionId = requisitionId; requisitionEntity.date = date; requisitionEntity.userId = userId; requisitionEntity.departmentId = departmentId; requisitionEntity.rejectreason = rejectReason; requisitionEntity.status = status; ctx.requisitions.Add(requisitionEntity); ctx.SaveChanges(); foreach (DataRow dr in requisitionDetails.Rows) { reqDetailEntity = new requisitionDetail(); reqDetailEntity.requisitionId = (dr["requisitionId"]).ToString(); reqDetailEntity.itemId = (dr["itemId"]).ToString(); reqDetailEntity.requestedQty = Convert.ToInt32(dr["quantity"]); reqDetailEntity.deliveredQty = 0; ctx.requisitionDetails.Add(reqDetailEntity); ctx.SaveChanges(); } }
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 }