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
}
