private void btnPO_Click(object sender, EventArgs e) { if (InitExcel("Purchase Order") == false) return; UnitOfWork uow = new UnitOfWork(); PurchOrderLine poLine; int row = 3; uow.BeginTransaction(); while (ExcelHelper.GetCellStringValue(xlSht, row, 1) != "") { poLine = new PurchOrderLine(uow); poLine.SetPurchOrderLineNo(ExcelHelper.GetCellStringValue(xlSht, row, 1)); poLine.Item = Item.FindItem(uow, ExcelHelper.GetCellStringValue(xlSht, row, 2)); poLine.OrderType = uow.FindObject<OrderType>(new BinaryOperator("Name", ExcelHelper.GetCellStringValue(xlSht, row, 3))); poLine.Vendor = uow.FindObject<Vendor>(new BinaryOperator("No", ExcelHelper.GetCellStringValue(xlSht, row, 4))); poLine.PriceUnit = uow.FindObject<Unit>(new BinaryOperator("UnitName", ExcelHelper.GetCellStringValue(xlSht, row, 5))); poLine.NeedQty = ExcelHelper.GetCellIntValue(xlSht, row, 8); poLine.NeedDate = ExcelHelper.GetCellDateTimeValue(xlSht, row, 9); poLine.Price = ExcelHelper.GetCellFloatValue(xlSht, row, 10); poLine.Save(); poLine.ApproveOrder(); poLine.IssuePurchOrder(uow); row++; } uow.CommitTransaction(); ReleaseExcel(); }