private void ApproveSingleAdj(int AdjID) { using (AdjustmentVoucherManager avm = new AdjustmentVoucherManager()) { AdjustmentVoucherTransaction tran = avm.GetAdjustmentVoucherTransactionByID(AdjID); SA33.Team12.SSIS.DAL.AdjustmentVoucher voucher = new SA33.Team12.SSIS.DAL.AdjustmentVoucher(); voucher.CreatedBy = tran.CreatedBy; voucher.ApprovedByUser = Utilities.Membership.LoggedInuser; voucher.DateApproved = DateTime.Now; voucher.DateIssued = tran.DateIssued; voucher.VoucherNumber = tran.VoucherNumber; avm.DeleteAdjustmentVoucherTransaction(tran); foreach (StockLogTransaction logTran in tran.StockLogTransactions) { StockLog log = new StockLog(); log.AdjustmentVoucher = voucher; log.Balance = logTran.Balance; log.Quantity = logTran.Quantity; log.Reason = logTran.Reason; log.StationeryID = logTran.StationeryID; log.Type = logTran.Type; log.Price = logTran.Price; avm.CreateStockLog(log); avm.DeleteStockLogTransaction(logTran); } avm.CreateAdjustmentVoucher(voucher); // UtilityFunctions.SendEmail(voucher.AdjustmentVoucherID + " - Your adjustment voucher has been approved", "Dear " + voucher.CreatedByUser.FirstName + "<br />" + "Your request has been approved.", voucher.ApprovedByUser); } }
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"); }