/// <summary>
/// Get qty for
/// </summary>
/// <param name="dtQty">Issues or receipt qty</param>
/// <param name="HeaderData">Datatable for header values</param>
/// <param name="objectEntity">Entity values</param>
/// <param name="HeaderType">header values</param>
/// <returns></returns>
public decimal GetValue(DataTable dtQty, DataTable dtHeaderData, QAObjectEntity objectEntity, string HeaderType)
{
string SchemeCode = string.Empty, TRCode = string.Empty;
decimal _qtyData = 0;
try
{
DataRow[] dr = dtHeaderData.Select("HeaderName='" + HeaderType + "'");
foreach (DataRow ndr in dr)
{
SchemeCode = Convert.ToString(ndr["SCCode"]);
TRCode = Convert.ToString(ndr["TRCode"]);
// Declare an object variable.
object objSum;
if (SchemeCode == "All")
{
objSum = dtQty.Compute("Sum(TOTAL)", "ITCode='" + objectEntity.ItemCode + "' and Trcode='" + TRCode + "' ");
}
else
{
objSum = dtQty.Compute("Sum(TOTAL)", "ITCode='" + objectEntity.ItemCode + "' and Scheme ='" + SchemeCode + "' and Trcode='" + TRCode + "'");
}
_qtyData = _qtyData + Convert.ToDecimal(manageReport.DecimalformatForWeight(objSum.ToString()));
}
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
return(_qtyData);
}
public List <QAObjectEntity> ProcessQAStatement(QuantityAccountEntity quantityAccountEntity)
{
string _itemCode = string.Empty;
string _ITDescription = string.Empty;
List <QAObjectEntity> _qaObjectEntity = new List <QAObjectEntity>();
try
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
DataSet dataSetMaster = new DataSet();
List <KeyValuePair <string, string> > sqlMasterParameters = new List <KeyValuePair <string, string> >();
sqlMasterParameters.Add(new KeyValuePair <string, string>("@GCode", quantityAccountEntity.GCode));
sqlMasterParameters.Add(new KeyValuePair <string, string>("@RCode", quantityAccountEntity.RCode));
sqlMasterParameters.Add(new KeyValuePair <string, string>("@FromDate", quantityAccountEntity.FromDate));
dataSetMaster = manageSQLConnection.GetDataSetValues("GetMasterDataForQuantityAccountCB", sqlMasterParameters);
DataSet todayIssues = new DataSet();
DataSet todayReceipt = new DataSet();
DataSet issuesUptoYesterday = new DataSet();
DataSet receiptUptoYesterday = new DataSet();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GCode", quantityAccountEntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@RCode", quantityAccountEntity.RCode));
sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", quantityAccountEntity.FromDate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", quantityAccountEntity.ToDate));
todayIssues = manageSQLConnection.GetDataSetValues("GetTodayIssuesForQuantityAccount", sqlParameters);
todayReceipt = manageSQLConnection.GetDataSetValues("GetTodayReceiptForQuantityAccount", sqlParameters);
issuesUptoYesterday = manageSQLConnection.GetDataSetValues("GetIssuesUptoYesterForQuantityAccount", sqlParameters);
receiptUptoYesterday = manageSQLConnection.GetDataSetValues("GetReceiptUptoYesterForQuantityAccount", sqlParameters);
if (dataSetMaster.Tables.Count > 0)
{
foreach (DataRow item in dataSetMaster.Tables[1].Rows) // item master details.
{
_itemCode = Convert.ToString(item["ITCode"]);
_ITDescription = Convert.ToString(item["ITDescription"]);
foreach (DataRow godown in dataSetMaster.Tables[2].Rows) // godown details.
{
QAObjectEntity objectEntity = new QAObjectEntity();
objectEntity.ItemCode = _itemCode;
objectEntity.Commodity = _ITDescription;
objectEntity.GCode = godown["TNCSCode"].ToString();
objectEntity.RCode = godown["RGCODE"].ToString();
objectEntity.GName = godown["TNCSName"].ToString();
objectEntity.RName = godown["RGNAME"].ToString();
//get opening balance for particualr item.
DataRow[] openingBalance = dataSetMaster.Tables[0].Select("CommodityCode='" + _itemCode + "'");
DataRow[] receiptuptoYesterday = receiptUptoYesterday.Tables[0].Select("ITCode='" + _itemCode + "'");
// DataRow[] receipttotay = todayReceipt.Tables[0].Select("GCode='" + objectEntity.GCode + "' and ITCode='" + _itemCode + "'");
DataRow[] issuesuptoYesterday = issuesUptoYesterday.Tables[0].Select("ITCode='" + _itemCode + "'");
// DataRow[] issuestoday = todayIssues.Tables[0].Select("GCode='" + objectEntity.GCode + "' and ITCode='" + _itemCode + "'");
ClearVariable();
if (openingBalance != null && openingBalance.Count() > 0)
{
_BookBalanceWeight = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["BookBalanceWeight"])));
//_PhysicalBalanceWeight = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["PhysicalBalanceWeight"])));
//_CumulitiveShortage = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["CumulitiveShortage"])));
//_Shortage = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["WriteOff"])));
}
if (receiptuptoYesterday != null && receiptuptoYesterday.Count() > 0)
{
_receiptuptoYesterday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(receiptuptoYesterday[0]["TOTAL"])));
}
if (issuesuptoYesterday != null && issuesuptoYesterday.Count() > 0)
{
_issuesuptoYesterday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(issuesuptoYesterday[0]["TOTAL"])));
}
_OpeningBalance = (_BookBalanceWeight + _receiptuptoYesterday) - (_issuesuptoYesterday);
_RecPDS = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.PDS.ToString());
_RecPRIORITY = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.PRIORITY.ToString());
_RecTIDEOVER = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.TIDEOVER.ToString());
_RecAAY = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.AAY.ToString());
_RecSPLPDS = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.SPLPDS.ToString());
_RecCEMENT = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.CEMENT.ToString());
_RecHOPURCHASE = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.HOPURCHASE.ToString());
_RecSEIZUR = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.SEIZUR.ToString());
_RecPTMGRNMP = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.PTMGRNMP.ToString());
_RecSGRY = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.SGRY.ToString());
_RecANNAPURNA = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.ANNAPURNA.ToString());
_RecRECEIVEDFROM = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.RECEIVEDFROM.ToString());
_RecTRANSFERWITHINREGION = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.TRANSFERWITHINREGION.ToString());
_RecTRANSFEROTHERREGION = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.TRANSFEROTHERREGION.ToString());
_RecEXCESS = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.EXCESS.ToString());
_RecCLEANINGANDPACKING = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.CLEANINGANDPACKING.ToString());
_RecVCFLOOD = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.VCFLOOD.ToString());
_RecSALESRETURN = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.SALESRETURN.ToString());
//issues details
_IsPDS = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.PDS.ToString());
_IsCOOP = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.COOP.ToString());
_IsPOLICE = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.POLICE.ToString());
_IsNMP = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.NMP.ToString());
_IsBULK = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.BULK.ToString());
_IsCREDIT = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.CREDIT.ToString());
_IsOAP = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.OAP.ToString());
_IsSRILANKA = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.SRILANKA.ToString());
_IsAAY = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.AAY.ToString());
_IsSPLPDS = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.SPLPDS.ToString());
_IsPDSCOOP = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.PDSCOOP.ToString());
_IsCEMENTFLOOD = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.CEMENTFLOOD.ToString());
_IsPTMGR = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.PTMGR.ToString());
_IsSGRY = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.SGRY.ToString());
_IsANNAPOORNA = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.ANNAPOORNA.ToString());
_IsISSUESTOPROCESSING = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.ISSUESTOPROCESSING.ToString());
_IsTRANSFERWITHINREGION = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.TRANSFERWITHINREGION.ToString());
_IsTRANSFEROTHERREGION = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.TRANSFEROTHERREGION.ToString());
_IsWRITEOFF = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.WRITEOFF.ToString());
_IsCLEANING = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.CLEANING.ToString());
_IsVCBLG = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.VCBLG.ToString());
_IsPURCHASERETURN = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.PURCHASERETURN.ToString());
_Total = _RecPDS + _RecPRIORITY + _RecTIDEOVER + _RecAAY + _RecSPLPDS
+ _RecCEMENT + _RecHOPURCHASE + _RecSEIZUR;
objectEntity.OpeningBalance = _OpeningBalance;
objectEntity.RecPDS = _RecPDS;
objectEntity.RecPRIORITY = _RecPRIORITY;
objectEntity.RecTIDEOVER = _RecTIDEOVER;
objectEntity.RecAAY = _RecAAY;
objectEntity.RecSPLPDS = _RecSPLPDS;
objectEntity.RecCEMENT = _RecCEMENT;
objectEntity.RecHOPURCHASE = _RecHOPURCHASE;
objectEntity.RecSEIZUR = _RecSEIZUR;
objectEntity.Total = _Total;
_TotalFreeRice = _RecPTMGRNMP + _RecSGRY + _RecANNAPURNA;
objectEntity.RecPTMGRNMP = _RecPTMGRNMP;
objectEntity.RecSGRY = _RecSGRY;
objectEntity.RecANNAPURNA = _RecANNAPURNA;
objectEntity.TotalFreeRice = _TotalFreeRice;
objectEntity.RecRECEIVEDFROM = _RecRECEIVEDFROM;
objectEntity.RecTRANSFERWITHINREGION = _RecTRANSFERWITHINREGION;
objectEntity.RecTRANSFEROTHERREGION = _RecTRANSFEROTHERREGION;
objectEntity.RecEXCESS = _RecEXCESS;
objectEntity.RecCLEANINGANDPACKING = _RecCLEANINGANDPACKING;
objectEntity.RecVCFLOOD = _RecVCFLOOD;
objectEntity.RecSALESRETURN = _RecSALESRETURN;
_TotalOtherReceipt = _RecRECEIVEDFROM + _RecTRANSFERWITHINREGION + _RecTRANSFEROTHERREGION
+ _RecEXCESS + _RecCLEANINGANDPACKING + _RecSALESRETURN;
objectEntity.TotalOtherReceipt = _TotalOtherReceipt;
_TotalReceipt = _Total + _TotalFreeRice + _TotalOtherReceipt;
objectEntity.TotalReceipt = _TotalReceipt;
_GrandTotalReceipt = _TotalReceipt + _OpeningBalance;
objectEntity.GrandTotalReceipt = _GrandTotalReceipt;
//Issues Details.
objectEntity.IsPDS = _IsPDS;
objectEntity.IsCOOP = _IsCOOP;
objectEntity.IsPOLICE = _IsPOLICE;
objectEntity.IsNMP = _IsNMP;
objectEntity.IsBULK = _IsBULK;
objectEntity.IsCREDIT = _IsCREDIT;
objectEntity.IsOAP = _IsOAP;
objectEntity.IsSRILANKA = _IsSRILANKA;
objectEntity.IsAAY = _IsAAY;
objectEntity.IsSPLPDS = _IsSPLPDS;
objectEntity.IsPDSCOOP = _IsPDSCOOP;
objectEntity.IsCEMENTFLOOD = _IsCEMENTFLOOD;
_IsTotalSales = _IsPDS + _IsCOOP + _IsPOLICE + _IsNMP + _IsBULK + _IsCREDIT
+ _IsOAP + _IsSRILANKA + _IsAAY + _IsSPLPDS + _IsPDSCOOP + _IsCEMENTFLOOD;
objectEntity.IsTotalSales = _IsTotalSales;
objectEntity.IsPTMGR = _IsPTMGR;
objectEntity.IsSGRY = _IsSGRY;
objectEntity.IsANNAPOORNA = _IsANNAPOORNA;
_IsTotalFreeRiceIssues = _IsPTMGR + _IsSGRY + _IsANNAPOORNA;
objectEntity.IsTotalFreeRiceIssues = _IsTotalFreeRiceIssues;
objectEntity.IsISSUESTOPROCESSING = _IsISSUESTOPROCESSING;
objectEntity.IsTRANSFERWITHINREGION = _IsTRANSFERWITHINREGION;
objectEntity.IsTRANSFEROTHERREGION = _IsTRANSFEROTHERREGION;
objectEntity.IsWRITEOFF = _IsWRITEOFF;
objectEntity.IsCLEANING = _IsCLEANING;
objectEntity.IsVCBLG = _IsVCBLG;
objectEntity.IsPURCHASERETURN = _IsPURCHASERETURN;
_IsTotalOtherIssues = _IsISSUESTOPROCESSING + _IsTRANSFERWITHINREGION + _IsTRANSFEROTHERREGION
+ _IsWRITEOFF + _IsCLEANING + _IsVCBLG + _IsPURCHASERETURN;
objectEntity.IsTotalOtherIssues = _IsTotalOtherIssues;
_IsTotalIssues = _IsTotalSales + _IsTotalFreeRiceIssues + _IsTotalOtherIssues;
objectEntity.IsTotalIssues = _IsTotalIssues;
_IsBalanceQty = _GrandTotalReceipt - _IsTotalIssues;
objectEntity.IsBalanceQty = _IsBalanceQty;
if (_IsBalanceQty > 0 || _IsTotalOtherIssues > 0 || _IsTotalFreeRiceIssues > 0 || _IsTotalSales > 0 ||
_GrandTotalReceipt > 0 || _TotalReceipt > 0 || _TotalOtherReceipt > 0 || _Total > 0 || _TotalFreeRice > 0)
{
_qaObjectEntity.Add(objectEntity);
}
//decimal CheckData = stockDetailsEntity.OpeningBalance + stockDetailsEntity.ClosingBalance +
// stockDetailsEntity.TotalReceipt + stockDetailsEntity.IssueSales
// + stockDetailsEntity.IssueOthers;
//if (CheckData > 0)
//{
// dailyStockDetailsEntities.Add(stockDetailsEntity);
//}
}
}
}
}
catch (Exception ex)
{
AuditLog.WriteError(" Process Daily Stock " + ex.Message);
}
//ManageStockStatement manageStockStatement = new ManageStockStatement();
//Task.Run(() => manageStockStatement.GenerateStockStatementReport(dailyStockDetailsEntities, stockParameter)); //Generate the Report
return(_qaObjectEntity);
}
