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.ApprovedBy = Membership.GetCurrentLoggedInUser().UserID;
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;
log.DateCreated = DateTime.Now;
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);
}
Populate();
}
public void CreateAdjustmentVoucher(AdjustmentVoucher adjustmentVoucher)
{
try
{
adjustmentVoucherDAO.CreateAdjustmentVoucher(adjustmentVoucher);
}
catch (Exception ex)
{
throw new Exception("Adjustment Voucher Creation Failed" + ex.Message);
}
}
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");
}
public void CreateAdjustmentVoucher(AdjustmentVoucher AdjustmentVoucher)
{
try
{
//Create a transaction scope
using (TransactionScope ts = new TransactionScope())
{
this.context.AdjustmentVouchers.AddObject(AdjustmentVoucher);
this.context.SaveChanges();
ts.Complete();
}
}
catch (Exception ex)
{
//Exception thrown incase if insert fails
throw new AdjustmentVoucherException("Create Adjustment Voucher Transaction failed." + ex.Message);
}
}
public void UpdateAdjustmentVoucher(AdjustmentVoucher updateAdjustmentVoucher)
{
try
{
var tempReq = (from r in context.AdjustmentVouchers
where r.AdjustmentVoucherID == updateAdjustmentVoucher.AdjustmentVoucherID
select r).FirstOrDefault<AdjustmentVoucher>();
tempReq = updateAdjustmentVoucher;
context.SaveChanges();
}
catch (Exception ex)
{
throw new AdjustmentVoucherException("Update Adjustment Voucher failed." + ex.Message);
}
}
public decimal GetTotalCostVoucher(AdjustmentVoucher adjustmentVoucher)
{
decimal totalCost = 0;
foreach (StockLog log in adjustmentVoucher.StockLogs)
{
totalCost += log.Quantity * log.Price;
}
return totalCost;
}
/// <summary>
/// Deprecated Method for adding a new object to the AdjustmentVouchers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToAdjustmentVouchers(AdjustmentVoucher adjustmentVoucher)
{
base.AddObject("AdjustmentVouchers", adjustmentVoucher);
}
/// <summary>
/// Create a new AdjustmentVoucher object.
/// </summary>
/// <param name="adjustmentVoucherID">Initial value of the AdjustmentVoucherID property.</param>
/// <param name="voucherNumber">Initial value of the VoucherNumber property.</param>
/// <param name="createdBy">Initial value of the CreatedBy property.</param>
/// <param name="dateIssued">Initial value of the DateIssued property.</param>
public static AdjustmentVoucher CreateAdjustmentVoucher(global::System.Int32 adjustmentVoucherID, global::System.String voucherNumber, global::System.Int32 createdBy, global::System.DateTime dateIssued)
{
AdjustmentVoucher adjustmentVoucher = new AdjustmentVoucher();
adjustmentVoucher.AdjustmentVoucherID = adjustmentVoucherID;
adjustmentVoucher.VoucherNumber = voucherNumber;
adjustmentVoucher.CreatedBy = createdBy;
adjustmentVoucher.DateIssued = dateIssued;
return adjustmentVoucher;
}
