protected void DisbursementGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName.ToLower())
{
case "select":
int rowId = int.Parse(e.CommandArgument.ToString());
int disbursementID = (int)DisbursementGridView.DataKeys[rowId].Value;
using (DisbursementManager dm = new DisbursementManager())
{
Disbursement disbursement = dm.FindDisbursementByID(disbursementID);
List<Disbursement> disbursements = new List<Disbursement>();
disbursements.Add(disbursement);
DisbursementDetailView.DataSource = disbursements;
DisbursementDetailView.DataBind();
List<DisbursementItem> disbursementItems
=
dm.FindDisbursementItemByCriteria(new DisbursementItemSearchDTO() {DisbursementID = disbursementID});
this.DisbursementItemGridView.DataSource = disbursementItems;
DisbursementItemGridView.DataBind();
}
break;
case "submit":
int disbursementIDToSubmit = int.Parse(e.CommandArgument.ToString());
Response.Redirect("~/Test/TestMichaelDetail.aspx?ID=" + disbursementIDToSubmit);
break;;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
if(Request.QueryString["ID"] != "")
{
int disID = int.Parse(Request.QueryString["ID"]);
using(DisbursementManager disbursementManager = new DisbursementManager())
{
this.Detail.DataSource = new List<Disbursement>()
{disbursementManager.FindDisbursementByID(disID)};
this.Detail.DataBind();
}
}
}
}
protected void UpdateButton_Click(object sender, EventArgs e)
{
if (!Page.IsValid) return;
try
{
using (TransactionScope ts = new TransactionScope())
{
for (int i = 0; i < this.DistributionGridView.Rows.Count; i++)
{
GridViewRow gridViewRow = DistributionGridView.Rows[i];
HiddenField IsSpecialHiddenField = gridViewRow.FindControl("IsSpecialHiddenField") as HiddenField;
HiddenField RequisitionIDHiddenField = gridViewRow.FindControl("RequisitionIDHiddenField") as HiddenField;
HiddenField StationeryIDHiddenField = gridViewRow.FindControl("StationeryIDHiddenField") as HiddenField;
HiddenField SpecialStationeryIDHiddenField =
gridViewRow.FindControl("SpecialStationeryIDHiddenField") as HiddenField;
HiddenField QuantityDisbursedHiddenField = gridViewRow.FindControl("QuantityDisbursedHiddenField") as HiddenField;
TextBox QuantityTextBox = gridViewRow.FindControl("QuantityTextBox") as TextBox;
bool isSpecial = Convert.ToBoolean(IsSpecialHiddenField.Value);
int RequisitionID = Convert.ToInt32(RequisitionIDHiddenField.Value);
int StationeryID = Convert.ToInt32(StationeryIDHiddenField.Value);
int SpecialStationeryID = Convert.ToInt32(SpecialStationeryIDHiddenField.Value);
int QuantityDisbursed = Convert.ToInt32(QuantityDisbursedHiddenField.Value);
int QuantityDistributed = Convert.ToInt32(QuantityTextBox.Text.Trim());
using (RequisitionManager rm = new RequisitionManager())
{
Requisition rq = rm.GetRequisitionByID(RequisitionID);
if (!isSpecial)
{
List<RequisitionItem> rqItems = (from item in rq.RequisitionItems
where item.StationeryID == StationeryID
select item).ToList();
for (int j = 0; j < rqItems.Count && QuantityDisbursed > 0; j++)
{
RequisitionItem rqItem = rqItems[j];
if (QuantityDisbursed > rqItem.QuantityRequested)
{
rqItem.QuantityIssued = rqItem.QuantityRequested;
QuantityDisbursed = QuantityDisbursed - rqItem.QuantityRequested;
}
else if (QuantityDisbursed > 0)
{
rqItem.QuantityIssued = QuantityDisbursed;
QuantityDisbursed = 0;
}
}
}
else
{
List<SpecialRequisitionItem> srqItems = (from sitem in rq.SpecialRequisitionItems
where sitem.SpecialStationeryID == SpecialStationeryID
select sitem).ToList();
for (int j = 0; j < srqItems.Count && QuantityDisbursed > 0; j++)
{
SpecialRequisitionItem srqItem = srqItems[j];
if (QuantityDisbursed > srqItem.QuantityRequested)
{
srqItem.QuantityIssued = srqItem.QuantityRequested;
QuantityDisbursed = QuantityDisbursed - srqItem.QuantityRequested;
}
else if (QuantityDisbursed > 0)
{
srqItem.QuantityIssued = QuantityDisbursed;
QuantityDisbursed = 0;
}
}
}
Status status = rm.GetStatusByName(new StatusSearchDTO() { Name = "Fulfilled" });
rq.Status = status;
rm.UpdateRequisition(rq);
}
}
using (DisbursementManager dm = new DisbursementManager())
{
Disbursement disbursement = dm.FindDisbursementByID(this.DisbursementId);
disbursement.IsDistributed = true;
dm.UpdateDisbursement(disbursement);
}
ts.Complete();
}
Response.Redirect("~/Distribution/Disbursements.aspx");
}
catch (Exception exception)
{
this.ErrorMessage.Text = exception.Message;
}
}
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;
}
}