/// <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, QAGunnyEntity 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 <QAGunnyEntity> ProcessQAStatement(QuantityAccountEntity quantityAccountEntity)
{
string _itemCode = string.Empty;
string _ITDescription = string.Empty;
List <QAGunnyEntity> _qaObjectEntity = new List <QAGunnyEntity>();
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("GetMasterDataForGunnyReceiptIssue", 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("GetTodayIssuesForGunnyQuantityAccount", sqlParameters);
todayReceipt = manageSQLConnection.GetDataSetValues("GetTodayReceiptForGunnyQuantityAccount", sqlParameters);
issuesUptoYesterday = manageSQLConnection.GetDataSetValues("GetIssuesUptoYesterForGunnyQuantityAccount", sqlParameters);
receiptUptoYesterday = manageSQLConnection.GetDataSetValues("GetReceiptUptoYesterForGunnyQuantityAccount", 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.
{
QAGunnyEntity objectEntity = new QAGunnyEntity();
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[] issuesuptoYesterday = issuesUptoYesterday.Tables[0].Select("ITCode='" + _itemCode + "'");
ClearVariable();
if (openingBalance != null && openingBalance.Count() > 0)
{
_BookBalanceWeight = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["BookBalanceWeight"])));
}
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);
_RecPURCHASE = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.PURCHASE.ToString());
_RecHULLING = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.HULLING.ToString());
_RecGUNNYRELEASE = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.GUNNYRELEASE.ToString());
_RecHOPURCHASE = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.HOPURCHASE.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());
//issues details
_IsSALES = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.SALES.ToString());
_IsGUNNYRELEASE = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.GU.ToString());
_IsMENDING = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.MENDING.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());
_Total = _RecPURCHASE + _RecHOPURCHASE + _RecHULLING + _RecGUNNYRELEASE + _RecEXCESS + _RecTRANSFERWITHINREGION + _RecTRANSFEROTHERREGION;
objectEntity.OpeningBalance = _OpeningBalance;
objectEntity.RecPURCHASE = _RecPURCHASE;
objectEntity.RecHULLING = _RecHULLING;
objectEntity.RecGUNNYRELEASE = _RecGUNNYRELEASE;
objectEntity.RecHOPURCHASE = _RecHOPURCHASE;
objectEntity.Total = _Total;
objectEntity.RecTRANSFERWITHINREGION = _RecTRANSFERWITHINREGION;
objectEntity.RecTRANSFEROTHERREGION = _RecTRANSFEROTHERREGION;
objectEntity.RecEXCESS = _RecEXCESS;
_TotalReceipt = _Total;
objectEntity.TotalReceipt = _TotalReceipt;
_GrandTotalReceipt = _TotalReceipt + _OpeningBalance;
objectEntity.GrandTotalReceipt = _GrandTotalReceipt;
//Issues Details.
objectEntity.IsSALES = _IsSALES;
objectEntity.IsGUNNYRELEASE = _IsGUNNYRELEASE;
objectEntity.IsMENDING = _IsMENDING;
_IsTotalSales = _IsSALES + _IsGUNNYRELEASE + _IsMENDING + _IsWRITEOFF + _IsTRANSFERWITHINREGION + _IsTRANSFEROTHERREGION;
objectEntity.IsTotalSales = _IsTotalSales;
objectEntity.IsTRANSFERWITHINREGION = _IsTRANSFERWITHINREGION;
objectEntity.IsTRANSFEROTHERREGION = _IsTRANSFEROTHERREGION;
objectEntity.IsWRITEOFF = _IsWRITEOFF;
_IsTotalIssues = _IsTotalSales;
objectEntity.IsTotalIssues = _IsTotalIssues;
_IsBalanceQty = _GrandTotalReceipt - _IsTotalIssues;
objectEntity.IsBalanceQty = _IsBalanceQty;
if (_IsBalanceQty > 0 || _IsTotalSales > 0 ||
_GrandTotalReceipt > 0 || _TotalReceipt > 0 || _Total > 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);
}
