private decimal PurQty(string txType, string type)
{
decimal result = 0, totalREC = 0, totalREJ = 0;
if (type == "M")
{
type = "AND YEAR(TxDate) = " + DateTime.Now.Year.ToString() + " AND MONTH(TxDate) = " + DateTime.Now.Month.ToString();
}
else
{
type = "AND YEAR(TxDate) = " + DateTime.Now.Year.ToString();
}
string sql = "ProductId = '" + this.ProductId.ToString() + "' AND TxType IN (" + txType + ")" + type;
InvtLedgerDetailsCollection oDetails = InvtLedgerDetails.LoadCollection(sql);
for (int i = 0; i < oDetails.Count; i++)
{
switch (oDetails[i].TxType)
{
case "REJ":
totalREJ += oDetails[i].Qty;
break;
case "REC":
case "CAP":
totalREC += oDetails[i].Qty;
break;
}
}
result = totalREC - totalREJ;
return(result);
}
/// <summary>
/// Saves the TXF SubLedger.
/// </summary>
/// <param name="bConfirmed">if set to <c>true</c> [b confirmed].</param>
private void SaveTXFS(bool bConfirmed)
{
string sheaderid = string.Empty;
for (int i = 0; i < dgvConfirmationList.Rows.Count; i++)
{
DataGridViewRow oRow = dgvConfirmationList.Rows[i];
if (RT2020.DAL.Common.Utility.IsGUID(oRow.Cells[0].Value.ToString()))
{
System.Guid detailId = new Guid(oRow.Cells[0].Value.ToString());
InvtSubLedgerTXF_Details oDetail = InvtSubLedgerTXF_Details.Load(detailId);
if (oDetail != null)
{
oDetail.QtyConfirmed = Convert.ToDecimal(oRow.Cells[8].Value);
oDetail.Save();
if (bConfirmed)
{
// Update Ledger
string query = "SubLedgerHeaderId = '" + oDetail.HeaderId.ToString() + "'";
InvtLedgerHeader oLedgerHeader = InvtLedgerHeader.LoadWhere(query);
if (oLedgerHeader != null)
{
//Details
query = "HeaderId = '" + oLedgerHeader.HeaderId + "' AND ProductId = '" + oDetail.ProductId.ToString() + "'";
InvtLedgerDetails oLedgerDetail = InvtLedgerDetails.LoadWhere(query);
if (oLedgerDetail != null)
{
//oLedgerDetail.QtyConfirmed = Convert.ToDecimal(oRow.Cells[9].Value);
//oLedgerDetail.Save();
}
}
}
}
}
}
InvtSubLedgerTXF_Header oHeader = InvtSubLedgerTXF_Header.Load(this.HeaderId);
if (oHeader != null)
{
if (bConfirmed)
{
oHeader.CONFIRM_TRF = "C";
oHeader.CONFIRM_TRF_LASTUSER = Common.Utility.CurrentUserId;
oHeader.CONFIRM_TRF_LASTUPDATE = DateTime.Now;
}
oHeader.ModifiedBy = Common.Utility.CurrentUserId;
oHeader.ModifiedOn = DateTime.Now;
oHeader.Save();
// Update Ledger
string query = "SubLedgerHeaderId = '" + oHeader.HeaderId.ToString() + "'";
InvtLedgerHeader oLedgerHeader = InvtLedgerHeader.LoadWhere(query);
if (oLedgerHeader != null)
{
if (bConfirmed)
{
// oLedgerHeader.CONFIRM_TRF = "C";
// oLedgerHeader.CONFIRM_TRF_LASTUSER = Common.Utility.CurrentUserId;
// oLedgerHeader.CONFIRM_TRF_LASTUPDATE = DateTime.Now;
}
oLedgerHeader.ModifiedBy = Common.Utility.CurrentUserId;
oLedgerHeader.ModifiedOn = DateTime.Now;
oLedgerHeader.Save();
}
}
}
