//int _docType = 0;
protected override string DoIt()
{
try
{
MVA027PostDatedCheck _pdc = new MVA027PostDatedCheck(GetCtx(), GetRecord_ID(), null);
int _id = _pdc.GetVA027_PostDatedCheck_ID();
_sql.Append(@"SELECT C_PAYMENT_ID FROM VA027_POSTDATEDCHECK WHERE VA027_POSTDATEDCHECK_ID=" + _id + "AND AD_Client_ID = " + GetAD_Client_ID());
int _payID = Util.GetValueOfInt(DB.ExecuteScalar(_sql.ToString()));
if (_payID > 0)
{
return(Msg.GetMsg(GetCtx(), "VA027_PaymentAlreadyGenerated"));
}
string _docStatus = _pdc.GetDocStatus();
if (_docStatus == "CO")
{
ViennaAdvantage.Process.VA027_GenPayment _genPayment = new ViennaAdvantage.Process.VA027_GenPayment();
_genPayment.GenratePayment(GetCtx(), GetRecord_ID(), Get_TrxName());
return(Msg.GetMsg(GetCtx(), "VA027_PaymentGenerated"));
}
return(Msg.GetMsg(GetCtx(), "VA027_PDCNotCompleted"));
}
catch (Exception ex)
{
log.Severe(ex.ToString());
}
return("");
}
/// <summary>
/// Create Payment
/// </summary>
/// <returns></returns>
public string Create()
{
StringBuilder sbRet = new StringBuilder();
string _systemDate = _sysDate.Value.ToShortDateString();
_Sql.Clear();
_Sql.Append(@"SELECT PDC.VA027_CheckDate, PDC.VA027_POSTDATEDCHECK_ID,PDC.DOCUMENTNO FROM VA027_PostDatedCheck PDC WHERE PDC.IsActive = 'Y' AND PDC.VA027_PAYMENTGENERATED='N' AND PDC.DOCSTATUS ='CO' AND PDC.VA027_MULTICHEQUE='N' AND PDC.AD_Client_ID = " + GetCtx().GetAD_Client_ID() + " AND PDC.AD_Org_ID=" + GetCtx().GetAD_Org_ID());
DataSet _date = new DataSet();
_date = DB.ExecuteDataset(_Sql.ToString(), null, Get_TrxName());
for (int i = 0; i < _date.Tables[0].Rows.Count; i++)
{
DateTime _checkdt = Convert.ToDateTime(_date.Tables[0].Rows[i]["VA027_CheckDate"]);
int record_ID = Util.GetValueOfInt(_date.Tables[0].Rows[i]["VA027_PostDatedCheck_ID"]);
string _checkDate = _checkdt.ToShortDateString();
if (Convert.ToDateTime(_checkDate) <= Convert.ToDateTime(_systemDate)) //changes made by arpit
{
ViennaAdvantage.Process.VA027_GenPayment _genPayment = new ViennaAdvantage.Process.VA027_GenPayment();
string result = _genPayment.GenratePaymentHdr(GetCtx(), record_ID, paymentDocumentTypeId, Get_TrxName());
if (result == "E")
{
if (sbRet.Length != 0)
{
sbRet.Append(", " + Util.GetValueOfInt(_date.Tables[0].Rows[i]["DocumentNo"]));
}
else
{
sbRet.Append(Msg.GetMsg(GetCtx(), "VA027_PaymentsNotSaved") + Util.GetValueOfInt(_date.Tables[0].Rows[i]["DocumentNo"]));
}
}
}
}
_Sql.Clear();
_date.Dispose();
_Sql.Append(@"SELECT PDC.VA027_CheckDate, PDC.VA027_POSTDATEDCHECK_ID,PDC.DOCUMENTNO FROM VA027_PostDatedCheck PDC WHERE PDC.IsActive = 'Y' AND PDC.VA027_PAYMENTGENERATED='N' AND PDC.DOCSTATUS ='CO' AND PDC.VA027_MULTICHEQUE='Y' AND PDC.AD_Client_ID = " + GetCtx().GetAD_Client_ID() + " AND PDC.AD_Org_ID=" + GetCtx().GetAD_Org_ID());
_date = DB.ExecuteDataset(_Sql.ToString(), null, Get_TrxName());
for (int i = 0; i < _date.Tables[0].Rows.Count; i++)
{
int record_ID = Util.GetValueOfInt(_date.Tables[0].Rows[i]["VA027_PostDatedCheck_ID"]);
ViennaAdvantage.Process.VA027_GenPayment _genPayment = new ViennaAdvantage.Process.VA027_GenPayment();
string result = _genPayment.GenratePaymentLine(GetCtx(), record_ID, paymentDocumentTypeId, Get_TrxName());
if (result == "E")
{
if (sbRet.Length != 0)
{
sbRet.Append(", " + Util.GetValueOfInt(_date.Tables[0].Rows[i]["DocumentNo"]));
}
else
{
sbRet.Append(Msg.GetMsg(GetCtx(), "VA027_PaymentsNotSaved") + Util.GetValueOfInt(_date.Tables[0].Rows[i]["DocumentNo"]));
}
}
}
if (sbRet.Length != 0)
{
sbRet.Append(Msg.GetMsg(GetCtx(), "VA027_PaymentGenerated"));
}
_Sql.Clear();
return(sbRet.ToString());
}