protected void ButtonUpdate_Click(object sender, EventArgs e) { PurchaseOrderSearchDTO dto = new PurchaseOrderSearchDTO(); dto.SupplierID = 3; using (PurchaseOrderManager pom = new PurchaseOrderManager()) { List<PurchaseOrder> po = pom.FindPurchaseOrderByCriteria(dto); po[0].DONumber = "88888"; PurchaseOrder poUpdated = pom.UpdatePurchaseOrder(po[0]); } }
protected void btnConfirm_Click(object sender, EventArgs e) { using (PurchaseOrderManager pom = new PurchaseOrderManager()) { PurchaseOrder po = pom.FindPurchaseOrderByID(int.Parse(Request.QueryString["ID"])); po.DONumber = txtDONumber.Text.ToString(); po.IsDelivered = true; po.DateReceived = Convert.ToDateTime(txtReceivedDate.Text.ToString()); po.ReceivedBy = Membership.GetCurrentLoggedInUser().UserID; pom.UpdatePurchaseOrder(po); using (AdjustmentVoucherManager avm = new AdjustmentVoucherManager()) { SA33.Team12.SSIS.DAL.AdjustmentVoucher av = new SA33.Team12.SSIS.DAL.AdjustmentVoucher(); av.VoucherNumber = avm.GenerateVoucherNumber(); av.CreatedBy = Membership.GetCurrentLoggedInUser().UserID; av.DateIssued = po.DateOfOrder; av.DateApproved = DateTime.Now; av.ApprovedBy = Membership.GetCurrentLoggedInUser().UserID; foreach (PurchaseOrderItem item in po.PurchaseOrderItems) { // generate stocklog for each poItem StockLog log = new StockLog(); log.AdjustmentVoucher = av; log.Balance = item.Stationery.QuantityInHand; log.Quantity = item.QuantityToOrder; log.Reason = "Supplier - " + po.Supplier.CompanyName; log.StationeryID = item.StationeryID; log.Type = 3; // "replenishment" accroding to enu in DAL.AdjustmentVoucherDAO log.Price = item.Price; log.DateCreated = DateTime.Now; av.StockLogs.Add(log); // update replensih stationery stock using (CatalogManager cm = new CatalogManager()) { item.Stationery.QuantityInHand = item.Stationery.QuantityInHand + item.QuantityToOrder; cm.UpdateStationery(item.Stationery); } } avm.CreateAdjustmentVoucher(av); } } Response.Redirect("ViewPurchaseOrder.aspx"); }