private void PreviewSelectedTransaction()
{
long RecordNumber = long.Parse(Request.QueryString["ID"]);
string Outlet = Request.QueryString["Outlet"];
BookAdjustmentMemo adjustment_memo = BAM.GetBookAdjustmentMemoByKey(RecordNumber);
lblPeriodFrom.Text = adjustment_memo.PeriodFrom.ToString("MMMM dd, yyyy");
lblPeriodTo.Text = adjustment_memo.PeriodTo.ToString("MMMM dd, yyyy");
lblReferenceNumber.Text = adjustment_memo.ReferenceNumber.ToString();
lblDate.Text = adjustment_memo.MemoDate.ToString("MMMM dd, yyyy");
lblOutlet.Text = Outlet;
lblTransaction.Text = adjustment_memo.ParticularTransaction;
lblQuantity.Text = adjustment_memo.Quantity.ToString();
lblCurrentPrice.Text = adjustment_memo.CurrentPrice.ToString("###,###.00");
lblCostPrice.Text = adjustment_memo.CostPrice.ToString("###,###.00");
}
protected void btnSaveMemo_Click(object sender, EventArgs e)
{
try
{
var BookAdjustment = new BookAdjustment
{
AdjustmentCode = CreateCode(15),
InventoryDate = DateTime.Parse(txtInventoryDate.Text),
CutOffDate = DateTime.Parse(txtCutOffDate.Text),
OutletNumber = int.Parse(hfOutletNumber.Value),
OutletName = hfOutletName.Value,
DateRecorded = DateTime.Now
};
BookAdjustmentManager.Save(BookAdjustment);
#region log
BookAdjustmentManager.SaveTransactionLog(Permission.PERMITTED_USER, TransactionType.INSERT);
#endregion
if (gvCreditParticulars.Rows.Count > 0)
{
foreach (TableRow row in this.gvCreditParticulars.Rows)
{
var BookAdjustmentCreditMemo = new BookAdjustmentMemo
{
AdjustmentCode = BookAdjustment.AdjustmentCode,
CostPrice = decimal.Parse(row.Cells[3].Text.Replace("Php", "")),
CurrentPrice = decimal.Parse(row.Cells[2].Text.Replace("Php", "")),
MemoDate = DateTime.Parse(txtDateCredit.Text),
MemoType = "CREDIT",
ParticularTransaction = row.Cells[0].Text,
PeriodFrom = DateTime.Parse(txtDateCreditfrom.Text),
PeriodTo = DateTime.Parse(txtDateCreditTo.Text),
Quantity = long.Parse(row.Cells[1].Text),
ReferenceNumber = long.Parse(txtCreditReferenceNumber.Text),
DateRecorded = DateTime.Now
};
BookAdjustmentMemoManager.Save(BookAdjustmentCreditMemo);
}
}
if (gvParticulars.Rows.Count > 0)
{
foreach (TableRow row in this.gvParticulars.Rows)
{
var BookAdjustmentDebitMemo = new BookAdjustmentMemo
{
AdjustmentCode = BookAdjustment.AdjustmentCode,
CostPrice = decimal.Parse(row.Cells[3].Text.Replace("Php", "")),
CurrentPrice = decimal.Parse(row.Cells[2].Text.Replace("Php", "")),
MemoDate = DateTime.Parse(txtDate.Text),
MemoType = "DEBIT",
ParticularTransaction = row.Cells[0].Text,
PeriodFrom = DateTime.Parse(txtDatePeriodFrom.Text),
PeriodTo = DateTime.Parse(txtDatePeriodTo.Text),
Quantity = long.Parse(row.Cells[1].Text),
ReferenceNumber = long.Parse(txtReferenceNumber.Text),
DateRecorded = DateTime.Now
};
BookAdjustmentMemoManager.Save(BookAdjustmentDebitMemo);
}
}
lblSaved_ModalPopupExtender.Show();
}
catch (Exception)
{
//throw;
}
}
