protected void DataBindStationeryRetrievalFormView()
{
stationeryRetrievalFormID = Convert.ToInt32(Request.QueryString["ID"]);
using (StationeryRetrievalManager sm = new StationeryRetrievalManager())
{
List<StationeryRetrievalForm> srfs = new List<StationeryRetrievalForm>();
StationeryRetrievalForm stationeryRetrievalForm
= sm.GetStationeryRetrievalFormByID(this.StationeryRetrievalFormID);
isRetrieved = (bool)stationeryRetrievalForm.IsRetrieved;
isCollected = (bool)stationeryRetrievalForm.IsCollected;
this.UpdateRetrievedQuantityButton.Visible = (!IsRetrieved);
this.UpdateActualQuantityButton.Visible = (IsRetrieved && !IsCollected);
srfs.Add(stationeryRetrievalForm);
this.StationeryRetrievalFormView.DataSource = srfs;
this.StationeryRetrievalFormView.DataBind();
}
}
protected void UpdateRetrievedQuantity()
{
GridView StationeryRetrievalFormItemGridView =
StationeryRetrievalFormView.FindControl("StationeryRetrievalFormItemGridView") as GridView;
if (StationeryRetrievalFormItemGridView != null)
{
try
{
int srfID = Convert.ToInt32(this.StationeryRetrievalFormView.DataKey.Value);
AdjustmentVoucherTransaction adj = new AdjustmentVoucherTransaction();
List<Stationery> stationeries = new List<Stationery>();
List<SpecialStationery> specialStationeries = new List<SpecialStationery>();
using (StationeryRetrievalManager srm = new StationeryRetrievalManager())
{
DAL.StationeryRetrievalForm srf = srm.GetStationeryRetrievalFormByID(srfID);
List<StationeryRetrievalFormItem> srfis = srf.StationeryRetrievalFormItems.ToList();
foreach (GridViewRow row in StationeryRetrievalFormItemGridView.Rows)
{
HiddenField StationeryRetrievalFormItemIDHiddenField =
row.FindControl("StationeryRetrievalFormItemIDHiddenField") as HiddenField;
int srfiID = Convert.ToInt32(StationeryRetrievalFormItemIDHiddenField.Value);
TextBox QtyRetrieved = row.FindControl("QuantityRetrievedTextBox") as TextBox;
StationeryRetrievalFormItem srfi = (from s in srfis
where s.StationeryRetrievalFormItemID == srfiID
select s).FirstOrDefault();
int quantityRetrieved = Convert.ToInt32(QtyRetrieved.Text);
srfi.QuantityRetrieved = quantityRetrieved;
StockLogTransaction stockLogTransaction = new StockLogTransaction();
stockLogTransaction.Reason = "";
stockLogTransaction.Quantity = quantityRetrieved;
if (srfi.Stationery != null)
{
Stationery stationery = srfi.Stationery;
stockLogTransaction.StationeryID = srfi.Stationery.StationeryID;
StationeryPrice price = stationery.StationeryPrices.First();
stockLogTransaction.Price = price.Price;
stationery.QuantityInHand -= quantityRetrieved;
stationeries.Add(stationery);
stockLogTransaction.Balance = stationery.QuantityInHand;
}
else
{
SpecialStationery specialStationery = srfi.SpecialStationery;
stockLogTransaction.SpecialStationeryID = srfi.SpecialStationery.SpecialStationeryID;
stockLogTransaction.Price = 0.0m;
specialStationery.Quantity -= quantityRetrieved;
stockLogTransaction.Balance = specialStationery.Quantity;
specialStationeries.Add(specialStationery);
}
stockLogTransaction.DateCreated = DateTime.Now;
stockLogTransaction.Type = (int) AdjustmentType.Consumption;
adj.StockLogTransactions.Add(stockLogTransaction);
}
StationeryRetrievalForm newSRF = srm.UpdateReceivedQuantity(srf);
newSRF = srm.SetRecommendedQuantity(newSRF.StationeryRetrievalFormID);
using(CatalogManager cm = new CatalogManager())
{
foreach (Stationery stationery in stationeries)
{
cm.UpdateStationery(stationery);
}
foreach (SpecialStationery specialStationery in specialStationeries)
{
cm.UpdateSpecialStationery(specialStationery);
}
}
}
}
catch (Exception exception)
{
this.ErrorMessage.Text = exception.Message;
}
}
}
protected void UpdateActualQuantity()
{
GridView StationeryRetrievalFormItemByDeptGridView =
StationeryRetrievalFormView.FindControl("StationeryRetrievalFormItemByDeptGridView") as GridView;
if (StationeryRetrievalFormItemByDeptGridView != null)
{
int srfID = Convert.ToInt32(this.StationeryRetrievalFormView.DataKey.Value);
using (StationeryRetrievalManager srm = new StationeryRetrievalManager())
{
StationeryRetrievalForm srf = srm.GetStationeryRetrievalFormByID(srfID);
List<StationeryRetrievalFormItem> srfis = srf.StationeryRetrievalFormItems.ToList();
List<StationeryRetrievalFormItemByDept> srfiByDepts
= new List<StationeryRetrievalFormItemByDept>();
foreach (StationeryRetrievalFormItem srfi in srfis)
{
srfiByDepts.AddRange(srfi.StationeryRetrievalFormItemByDepts);
}
foreach (GridViewRow row in StationeryRetrievalFormItemByDeptGridView.Rows)
{
HiddenField srfByDeptIDHiddenField =
row.FindControl("srfByDeptIDHiddenField") as HiddenField;
int srfiByDeptID = Convert.ToInt32(srfByDeptIDHiddenField.Value);
TextBox ActualQty = row.FindControl("QuantityActualTextBox") as TextBox;
StationeryRetrievalFormItemByDept srfiByDept
= (from s in srfiByDepts
where
s.StationeryRetrievalFormItemByDeptID ==
srfiByDeptID
select s).FirstOrDefault();
int qty = Convert.ToInt32(ActualQty.Text.Trim() == "" ? "0" : ActualQty.Text.Trim());
srfiByDept.QuantityActual = qty;
}
StationeryRetrievalForm newSRF = srm.UpdateActualQuantity(srf);
}
}
}