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(); }
protected void btnAdd_Click(object sender, EventArgs e) { int stationeryID = int.Parse(ddlDescription.SelectedValue); using (CatalogManager cm = new CatalogManager()) { Stationery stationery = cm.FindStationeryByID(stationeryID); List<Stationery> stationeries = new List<Stationery>(); stationeries.Add(stationery); dvStockCard.DataSource = stationeries; dvStockCard.DataBind(); } using (AdjustmentVoucherManager avm = new AdjustmentVoucherManager()) { List<StockLogTransaction> trans = avm.GetAllStockLogTransactionByCriteria(new AdjustmentVoucherTransactionSearchDTO { StationeryID = stationeryID }); this.gvTransactions.DataSource = trans; this.gvTransactions.DataBind(); } btnPrint.Enabled = true; btnPrint.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { using (AdjustmentVoucherManager adjm = new AdjustmentVoucherManager()) { List<StockLogTransaction> adj = adjm.FindAllStockLogTransaction(); this.GridView1.DataSource = adj; this.GridView1.DataBind(); } }
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"); }
//Test Search by Criteria protected void ButtonFind_Click(object sender, EventArgs e) { AdjustmentVoucherTransactionSearchDTO criteria = new AdjustmentVoucherTransactionSearchDTO(); if (rbnStockLogID.Checked) { criteria.StockLogTransactionID = Convert.ToInt32(TextBox1.Text.ToString()); } if (rbnAdjVoucherTran.Checked) { criteria.AdjustmentVoucherTransactionID = Convert.ToInt32(TextBox1.Text.ToString()); } if (rbnStationeryID.Checked) { criteria.StationeryID = Convert.ToInt32(TextBox1.Text.ToString()); } if (rbnType.Checked) { criteria.Type = Convert.ToInt32(TextBox1.Text.ToString()); } if (rbnReason.Checked) { criteria.Reason = TextBox1.Text.ToString(); } if (rbnQty.Checked) { criteria.Quantity = Convert.ToInt32(TextBox1.Text.ToString()); } if (rbnBal.Checked) { criteria.Balance = Convert.ToInt32(TextBox1.Text.ToString()); } using (AdjustmentVoucherManager adjm = new AdjustmentVoucherManager()) { List<StockLogTransaction> slt = adjm.GetAllStockLogTransactionByCriteria(criteria); this.GridView1.DataSource = slt; this.GridView1.DataBind(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { using (AdjustmentVoucherManager avm = new AdjustmentVoucherManager()) { AdjustmentVoucherTransaction tran = new AdjustmentVoucherTransaction(); tran.VoucherNumber = avm.GenerateVoucherNumber(); tran.DateIssued = DateTime.Now; tran.CreatedBy = Membership.GetCurrentLoggedInUser().UserID; foreach (StockLogTransaction adj in adjustments) { adj.AdjustmentVoucherTransaction = tran; tran.StockLogTransactions.Add(adj); } avm.CreateAdjustmentVoucherTransaction(tran); } Session["adjustments"] = null; }
protected void gvAdjustmentItems_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { int stationeryID = (int)DataBinder.Eval(e.Row.DataItem, "StationeryID"); DAL.AdjustmentType adjType = (AdjustmentType) DataBinder.Eval(e.Row.DataItem, "Type"); if (stationeryID != 0) { Literal ltl = e.Row.FindControl("ltlDescription") as Literal; Literal type = e.Row.FindControl("ltlType") as Literal; if (ltl != null) { using (CatalogManager cm = new CatalogManager()) { Stationery s = cm.FindStationeryByID(stationeryID); if (s != null) ltl.Text = s.Description; } } if (type != null) using (AdjustmentVoucherManager avm = new AdjustmentVoucherManager()) { type.Text = adjType.ToString(); } } } }
//To write the data in the table into database protected void btnSubmit_Click(object sender, EventArgs e) { if (ltMessage.Text != "") { ltMessage.Text = "Data saved already saved. No further action taken"; } if (ltMessage.Text == "") { using (AdjustmentVoucherManager adjustmentVoucherManager = new AdjustmentVoucherManager()) { AdjustmentVoucherTransaction adjustmentVoucherTransaction = new AdjustmentVoucherTransaction(); foreach (GridViewRow r in GridView1.Rows) { StockLogTransaction item = new StockLogTransaction(); item.AdjustmentVoucherTransactionID = adjustmentVoucherTransaction.AdjustmentVoucherTransactionID; item.StationeryID = Convert.ToInt32(r.Cells[1].Text); item.Type = Convert.ToInt32(r.Cells[3].Text.ToString()); item.Quantity = Convert.ToInt32(r.Cells[4].Text); item.Reason = r.Cells[5].Text; adjustmentVoucherManager.CreateStockLogTransaction(item); adjustmentVoucherTransaction.DateIssued = DateTime.Now; adjustmentVoucherTransaction.VoucherNumber = "ME001"; //Must be unique system generated number adjustmentVoucherTransaction.CreatedBy = 1; //Must be the userid of the person who creates it // AdjustmentVoucherTransaction newAdjustmentVoucherTransaction = adjustmentVoucherManager.CreateAdjustmentVoucherTransaction(adjustmentVoucherTransaction); ltMessage.Text = "Data saved"; } } } }
protected void UpdateButton_Click(object sender, EventArgs e) { try { AdjustmentVoucherTransaction adjustmentVoucher = new AdjustmentVoucherTransaction(); for (int i = 0; i < DisbursementGridView.Rows.Count; i++) { GridViewRow gridViewRow = DisbursementGridView.Rows[i]; int disbursementItemID = (int)DisbursementGridView.DataKeys[gridViewRow.RowIndex].Value; DisbursementItem item = null; using (DisbursementManager dm = new DisbursementManager()) { item = dm.FindDisbursementItemByID(disbursementItemID); } if (item != null && item.QuantityDamaged > 0) { Stationery stationery = item.Stationery; StockLogTransaction adj = new StockLogTransaction(); adj.Reason = item.Reason; adj.Quantity = item.QuantityDamaged ?? 0; if (item.StationeryID != null && item.StationeryID > 0) { adj.StationeryID = item.StationeryID; StationeryPrice price = stationery.StationeryPrices.First(); adj.Price = price.Price; adj.Balance = stationery.QuantityInHand; } else { adj.SpecialStationeryID = item.SpecialStationeryID; adj.Price = 0.0m; adj.Balance = 0; } adj.DateCreated = DateTime.Now; adj.Type = (int)AdjustmentType.Damage; adjustmentVoucher.StockLogTransactions.Add(adj); } if (adjustmentVoucher.StockLogTransactions.Count > 0) { using (TransactionScope ts = new TransactionScope()) { using (AdjustmentVoucherManager avm = new AdjustmentVoucherManager()) { adjustmentVoucher.VoucherNumber = avm.GenerateVoucherNumber(); adjustmentVoucher.DateIssued = DateTime.Now; adjustmentVoucher.CreatedBy = Utilities.Membership.LoggedInuser.UserID; avm.CreateAdjustmentVoucherTransaction(adjustmentVoucher); } using (DisbursementManager dm = new DisbursementManager()) { DAL.Disbursement disbursement = dm.FindDisbursementByID(this.DisbursementId); disbursement.IsDistributed = true; dm.UpdateDisbursement(disbursement); } ts.Complete(); } Response.Redirect("~/HandleRequest/Disbursements.aspx"); } else { using (TransactionScope ts = new TransactionScope()) { using (DisbursementManager dm = new DisbursementManager()) { DAL.Disbursement disbursement = dm.FindDisbursementByID(this.DisbursementId); disbursement.IsCompleted = true; dm.UpdateDisbursement(disbursement); } ts.Complete(); } Response.Redirect("~/HandleRequest/Disbursements.aspx"); } } } catch (Exception exception) { this.ErrorMessage.Text = exception.Message; } }
private void Populate() { using (AdjustmentVoucherManager avm = new AdjustmentVoucherManager()) { List<AdjustmentVoucherTransaction> trans = avm.GetAllAdjustmentVoucherTransaction(); gvAdjustments.DataSource = trans; gvAdjustments.DataBind(); } }
private void Populate() { if (Request.QueryString["ID"] != "") { int adjID = int.Parse(Request.QueryString["ID"]); using (AdjustmentVoucherManager avm = new AdjustmentVoucherManager()) { AdjustmentVoucher tran = avm.FindAdjustmentVoucherByID(adjID); this.gvAdjustmentItems.DataSource = tran.StockLogs.ToList<StockLog>(); this.gvAdjustmentItems.DataBind(); lblVoucherNumber.Text = tran.VoucherNumber; lblIssueDate.Text = tran.DateIssued.ToShortDateString(); using (UserManager um = new UserManager()) { User u = um.GetUserByID(tran.CreatedBy); lblCreatedBy.Text = u.UserName; } decimal totalCost = avm.GetTotalCostVoucher(tran); lblCost.Text = String.Format("{0:C}", totalCost); } } }
private void RejectSingleAdj(int AdjID) { using (AdjustmentVoucherManager avm = new AdjustmentVoucherManager()) { AdjustmentVoucherTransaction tran = avm.GetAdjustmentVoucherTransactionByID(AdjID); avm.DeleteAdjustmentVoucherTransaction(tran); foreach (StockLogTransaction logTran in tran.StockLogTransactions) { avm.DeleteStockLogTransaction(logTran); } //using (UserManager um = new UserManager()) //{ // User u = um.GetUserByID(tran.CreatedBy); // UtilityFunctions.SendEmail("Voucher Number " + tran.VoucherNumber + " has been Rejected", "Dear " // + u.UserName + "<br />" + "Your adjustment Voucher has been Rejected. Reason:" + "<br />" + txtReason.Text, u); //} } Response.Redirect("~/Stock/ApproveAdjustmentVoucher.aspx"); }