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(); } } }