public void AccountMakeNewPayment(Int64 AccountFacilityID, Int64 AccountID, double Amount, DateTime date, string freqcode,
out Int64 PaymentID, out Int64 TransID)
{
try
{
DbCommand DbCommand = database.GetStoredProcCommand("lmsAccountAdditionalPaymentSave");
database.AddInParameter(DbCommand, "@InstallationID", DbType.Int32, System.Web.HttpContext.Current.Application["installationid"]);
database.AddInParameter(DbCommand, "@UserID", DbType.Int64, -2);
database.AddInParameter(DbCommand, "@AccountFacilityID", DbType.Int64, AccountFacilityID);
database.AddInParameter(DbCommand, "@AccountID", DbType.Int64, AccountID);
database.AddInParameter(DbCommand, "@AdditionalPaymentAmount", DbType.Double, Amount);
database.AddInParameter(DbCommand, "@PaymentFrequency ", DbType.String, freqcode);
database.AddInParameter(DbCommand, "@StartDate", DbType.Date, date);
database.AddOutParameter(DbCommand, "@RepaymentJournalID", DbType.Int64, 20);
database.AddOutParameter(DbCommand, "@RepaymentID", DbType.Int64, 20);
InternalExecuteNonQuery(database, DbCommand, null);
TransID = LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@RepaymentJournalID"));
PaymentID = LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@RepaymentID"));
}
catch (Exception ex)
{
throw ex;
}
}
public Int64 AccountAdditionalPaymentCancel(Int64 AccountFacilityID, Int64 AccountID, Int64 PaymentID, Int64 CustomerID) //[2][110.2] #1870
{
try
{
DbCommand DbCommand = database.GetStoredProcCommand("lmsAccountAdditionalPaymentDelete");
database.AddInParameter(DbCommand, "@InstallationID", DbType.Int32, System.Web.HttpContext.Current.Application["installationid"]);
database.AddInParameter(DbCommand, "@UserID", DbType.Int64, -2);
database.AddInParameter(DbCommand, "@AccountFacilityID", DbType.Int64, AccountFacilityID);
database.AddInParameter(DbCommand, "@AccountID", DbType.Int64, AccountID);
database.AddInParameter(DbCommand, "@RepaymentID", DbType.Int64, PaymentID);
database.AddInParameter(DbCommand, "@FootPrintID", DbType.Int64, CustomerID); //[2][110.2] #1870
database.AddInParameter(DbCommand, "@FootPrintType", DbType.Int64, 1); //[2][110.2] #1870
database.AddOutParameter(DbCommand, "@RepaymentJournalID", DbType.Int64, 20);
InternalExecuteNonQuery(database, DbCommand, null);
return(LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@RepaymentJournalID")));
}
catch (Exception ex)
{
throw ex;
}
}
//[3][107.21] end
public Int64 ProcessAccountRequestTransfer(Int64 AccountFacilityID, Int64 AccountID, Int64 AccountIDTo, Decimal TransferAmount)
{
try
{
DbCommand DbCommand = database.GetStoredProcCommand("lmsCustomerPortalProcessRequestTransfer");
database.AddInParameter(DbCommand, "@InstallationID", DbType.Int32, System.Web.HttpContext.Current.Application["installationid"]);
database.AddInParameter(DbCommand, "@UserID", DbType.Int64, -2);
database.AddInParameter(DbCommand, "@AccountFacilityID", DbType.Int64, AccountFacilityID);
database.AddInParameter(DbCommand, "@AccountID", DbType.Int64, AccountID);
database.AddInParameter(DbCommand, "@AccountIDTo", DbType.Int64, AccountIDTo);
database.AddInParameter(DbCommand, "@CreditTransfer", DbType.Int64, TransferAmount);
database.AddOutParameter(DbCommand, "@TranID", DbType.Int64, 20);
InternalExecuteNonQuery(database, DbCommand, null);
return(LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@TranID")));
}
catch (Exception ex)
{
throw ex;
}
}
//return lmsAccountStatementSummary.AccountTemplateDocumentID
public Int64 GetAccountStatement(Int64 InstallationID, Int64 AccountFacilityID, Int64 AccountNo, Int64 CustomerID,
DateTime StartDate, DateTime EndDate, Int64 AccountTemplateDocumentID)
{
try
{
DbCommand DbCommand = database.GetStoredProcCommand("lmsAccountStatementGet");
database.AddInParameter(DbCommand, "@InstallationID", DbType.Int64, InstallationID);
database.AddInParameter(DbCommand, "@AccountFacilityID", DbType.Int64, AccountFacilityID);
database.AddInParameter(DbCommand, "@AccountID", DbType.Int64, AccountNo);
database.AddInParameter(DbCommand, "@CustomerID", DbType.Int64, CustomerID);
database.AddInParameter(DbCommand, "@InputAccountTemplateDocumentID", DbType.Int64, AccountTemplateDocumentID);
database.AddInParameter(DbCommand, "@StatementFrom", DbType.DateTime, StartDate);
database.AddInParameter(DbCommand, "@StatementTo", DbType.DateTime, EndDate);
database.AddOutParameter(DbCommand, "@AccountTemplateDocumentID", DbType.Int64, 20);
database.ExecuteNonQuery(DbCommand);
return(LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@AccountTemplateDocumentID")));
}
catch (Exception ex)
{
throw ex;
}
}