public void Delete(MonthlySOIAdjustment Adjustment)
{
using (DbManager db = new DbManager())
{
Accessor.Query.Delete(db, Adjustment);
}
}
public void Save(MonthlySOIAdjustment Adjustment)
{
using (DbManager db = new DbManager())
{
if (Adjustment.RecordNumber != 0)
{
Accessor.Query.Update(db, Adjustment);
}
else
{
Accessor.Query.Insert(db, Adjustment);
}
}
}
protected void btnYes_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtMiddleDateDeliveryTotal.Text))
{
txtMiddleDateDeliveryTotal.Text = "0";
}
if (string.IsNullOrEmpty(txtMiddleDateSales.Text))
{
txtMiddleDateSales.Text = "0";
}
if (string.IsNullOrEmpty(txtSalesFrom.Text))
{
txtSalesFrom.Text = "0";
}
if (string.IsNullOrEmpty(txtSalesTo.Text))
{
txtSalesTo.Text = "0";
}
if (string.IsNullOrEmpty(txtPullOut.Text))
{
txtPullOut.Text = "0";
}
if (string.IsNullOrEmpty(txtAdjustmentAdd.Text))
{
txtAdjustmentAdd.Text = "0";
}
if (string.IsNullOrEmpty(txtAdjustmentLess.Text))
{
txtAdjustmentLess.Text = "0";
}
if (string.IsNullOrEmpty(txtPhysicalCountAsOf.Text))
{
lblErrorText.Text = "Invalid " + lblPhysicalCountAsOf.Text + "!";
hfCustomerNumber_ModalPopupExtender.Show();
return;
}
MonthlyStoreOutStandingInventory MonthlySOI = new MonthlyStoreOutStandingInventory
{
ActualPhysicalCount = long.Parse(txtActualPCountAsOf.Text),
CustomerName = txtCustomer.Text,
SOICode = CreateCode(20),
DeliveryQtyFrom = long.Parse(txtDateDeliveriesFrom.Text),
DeliveriesMiddle = long.Parse(txtMiddleDateDeliveryTotal.Text),
DeliveryQtyTo = long.Parse(txtDateDeliveriesTo.Text),
EndingInventory = long.Parse(txtEndingInventoryAsOf.Text),
InventoryDate = DateTime.Parse(txtInventoryDate.Text),
OverLacking = OverLacking(),
PeriodFrom = DateTime.Parse(txtDateFrom.Text),
PeriodTo = DateTime.Parse(txtDateTo.Text),
PhysicalCount = long.Parse(txtPhysicalCountAsOf.Text),
PullOut = long.Parse(txtPullOut.Text),
AdjustmentAdd = long.Parse(txtAdjustmentAdd.Text),
AdjustmentLess = long.Parse(txtAdjustmentLess.Text),
SalesQtyFrom = long.Parse(txtSalesFrom.Text),
SalesMiddle = long.Parse(txtMiddleDateSales.Text),
SalesQtyTo = long.Parse(txtSalesTo.Text),
CustomerNumber = int.Parse(hfCustomerNumber.Value),
DateRecorded = DateTime.UtcNow
};
MonthlySOIManager.Save(MonthlySOI);
List <MonthlySOIAdjustment> ADD_ADJUSTMENTS = new List <MonthlySOIAdjustment>();
List <MonthlySOIAdjustment> LESS_ADJUSTMENTS = new List <MonthlySOIAdjustment>();
foreach (GridViewRow row in this.gvAdjustmentAdd.Rows)
{
MonthlySOIAdjustment adj = new MonthlySOIAdjustment
{
Type = "ADD",
Quantity = long.Parse(row.Cells[1].Text),
DateRecorded = DateTime.UtcNow,
Particular = row.Cells[0].Text,
SOICode = MonthlySOI.SOICode
};
ADD_ADJUSTMENTS.Add(adj);
}
foreach (GridViewRow row in this.gvAdjustmentLess.Rows)
{
MonthlySOIAdjustment adj = new MonthlySOIAdjustment
{
Type = "LESS",
Quantity = long.Parse(row.Cells[1].Text),
DateRecorded = DateTime.UtcNow,
Particular = row.Cells[0].Text,
SOICode = MonthlySOI.SOICode
};
LESS_ADJUSTMENTS.Add(adj);
}
MonthlySOIAdjustmentManager.Save(ADD_ADJUSTMENTS);
MonthlySOIAdjustmentManager.Save(LESS_ADJUSTMENTS);
#region log
MonthlySOIManager.SaveTransactionLog(Permission.PERMITTED_USER, TransactionType.INSERT);
#endregion
Response.Redirect("~/Accounting/MonthlySOIPanel.aspx");
}
