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");
}
