private int processTransaction(String connectionString, String cus_no, String pwd, Data.Dber dberr)
{
Cp_Txnm tx = new Cp_Txnm(connectionString, TXID, dberr);
// Check if TXNM fetch for transaction type "010" is successful. Return if error encountered
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
if(Validation.employeeInitiatedTxn(connectionString, cus_no) == 0)
{
Cp_Empm cpEmpm = new Cp_Empm(connectionString, cus_no, dberr);
if(dberr.ifError())
{
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
if(cpEmpm.empmP.emp_pvg == 5)
{
dberr.setError(Mnemonics.DbErrorCodes.TXERR_ADMIN_PWD_NOCHANGE);
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
if(!Data.EmpmD.UpdatePassword(connectionString, cus_no, pwd, dberr))
{
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
resultP = "Password Changed successfully!";
return 0;
}
Cp_Cstm cstm = new Cp_Cstm(connectionString, cus_no, dberr);
if (cstm.cstmP != null)
cstm.updatePassword(connectionString, cus_no, pwd, dberr);
if (dberr.ifError())
{
dberr = new Data.Dber();
if(!Data.EmpmD.UpdatePassword(connectionString, cus_no, pwd, dberr))
{
dberr.setError(Mnemonics.DbErrorCodes.TXERR_PWD_NOUPDATE);
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
}
//------------------------------
//Entity.Cstm cstm = Data.CstmD.Read(connectionString, acct.actmP.cs_no1, dberr);
String mailResponse = "";
if (!Security.OTPUtility.SendMail("SBS", "*****@*****.**",
cstm.cstmP.cs_fname + cstm.cstmP.cs_mname + cstm.cstmP.cs_lname, cstm.cstmP.cs_email,
"Update from SBS", "Password updated via transaction: "+ tx.txnmP.tran_desc))
{
mailResponse = "Mail sent.";
}
//-------------------------------
resultP = "Password Changed successfully!" + mailResponse;
//resultP = "Password Updated Successfully!";
return 0;
}
public Y_022(String txid, String connectionString, String acc_no, Decimal amount, String initPvg, String refno, String loginAc)
{
this.dberr = new Data.Dber();
try
{
if (amount <= 0)
{
dberr.setError(Mnemonics.DbErrorCodes.TXERR_NEGATIVE_TRANSFER);
this.result = dberr.getErrorDesc(connectionString);
this.error = true;
}
else
{
this.initPvg = Convert.ToInt32(initPvg);
this.TXID = txid;
this.changeAmount = amount;
seq = new Sequence(TXID);
this.loginAcc = loginAc;
/*if (!acc_no.Equals(loginAc))
{
newInitiator = true;
}*/
if (processTransaction(connectionString, acc_no, this.initPvg, loginAc) != 0)
{
this.error = true;
}
//pvg = new Privilege();
// seq will generate and store transaction reference no.
}
}
catch(Exception e)
{
this.error = true;
result = e.ToString();
}
}
/*
* VALIDATIONS
* 1. From acc same as login acc, if customer initiated
* 2. amount not <= 0
* 3.
*/
private int processTransaction(string connectionString, String acc_no, Int32 initPvg, String loginAc)
{
tx = new Cp_Txnm(connectionString, TXID, dberr);
// Check if TXNM fetch for transaction type "010" is successful. Return if error encountered
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
//Check if it is a Banker initiated transaction
if (Validation.employeeInitiatedTxn(connectionString, loginAc) == 0)
{
this.newInitiator = true;
}
if (this.newInitiator)
{
//Check if Customer is Active (Enabled)
if (!Validation.isActiveCustomerUsingAcc(connectionString, acc_no))
{
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
}
else
{
dberr = new Data.Dber();
// From account should belong to logged in customer
if (Validation.isMerchant(connectionString, loginAc))
{
//From account should not belong to the Merchant
/*if (Validation.validateCustomerSelfAccount(connectionString, loginAc, acc_no) == 0)
{
dberr.setError(Mnemonics.DbErrorCodes.TXERR_INTERNAL_TFR_EMP_FROM_TO_ACC_DIFF_CUS);
resultP = dberr.getErrorDesc(connectionString);
return -1;
}*/
}
else
{
if (Validation.validateCustomerSelfAccount(connectionString, loginAc, acc_no) != 0)
{
dberr.setError(Mnemonics.DbErrorCodes.TXERR_INTERNAL_TFR_FROM_DIFF_CUS);
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
}
//Check if Customer is Active (Enabled)
if (!Validation.isActiveCustomer(connectionString, loginAc))
{
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
}
String initEmpNumber = "0";
String initCustomer = "0";
if (this.newInitiator)
{
initEmpNumber = loginAc;
Cp_Empm cpEmpm = new Cp_Empm(connectionString, loginAc, dberr);
pvg = new Privilege(tx.txnmP.tran_pvga, tx.txnmP.tran_pvgb, cpEmpm.empmP.emp_pvg);
}
else
{
//this.acct = this.acct;
initCustomer = loginAc; // this.acct_init.actmP.cs_no1;
acct = new Cp_Actm(connectionString, acc_no, dberr);
pvg = new Privilege(tx.txnmP.tran_pvga, tx.txnmP.tran_pvgb, acct.actmP.ac_pvg);
}
if (!pvg.verifyInitPrivilege(dberr))
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
if (!pvg.verifyApprovePrivilege())
{
String inData = this.TXID + "|" + acc_no + "| |" + this.changeAmount.ToString();
if (pvg.writeToPendingTxns(
connectionString, /* connection string */
acc_no, /* account 1 */
"0", /* account 2 */
initCustomer, /* customer number */
tx.txnmP.tran_pvgb.ToString(), /* transaction approve privilege */
tx.txnmP.tran_desc, /* transaction description */
initEmpNumber, /* initiating employee number */
0, /* debit amount */
this.changeAmount, /* credit amount */
tx.txnmP.tran_id, /* transaction id (not tran code) */
inData, /* incoming transaction string in XSwitch */
dberr /* error tracking object */
) != 0)
{
resultP = dberr.getErrorDesc(connectionString);
error = true;
return -1;
}
resultP = Mnemonics.DbErrorCodes.MSG_SENT_FOR_AUTH;
error = true;
return 0;
}
//}
else
{
this.pvgBypassedP = true;
}
// Update new balance in ACTM
acct = new Cp_Actm(connectionString, acc_no, dberr);
acct.subtractBalance(connectionString, this.changeAmount, dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
if (!this.TXID.Equals(Mnemonics.TxnCodes.TX_TRANSFER_DEBIT))
{
/*acct.subtractBalance(connectionString, this.changeAmount, dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}*/
acct.updateBalance(connectionString, dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
// Store transaction in hisory table. Determine which history table to store in based on tx.txnmP.tran_fin_type
if (tx.txnmP.tran_fin_type.Equals("Y"))
{
// Write to FINHIST table
Entity.Finhist fhist = new Entity.Finhist(acc_no, "0", this.tx.txnmP.tran_desc,
changeAmount, 0, Convert.ToString(this.acct.actmP.ac_bal), "0", "0", "0");
Data.FinhistD.Create(connectionString, fhist, dberr);
}
else
{
// Write to NFINHIST table
Entity.Nfinhist nFhist = new Entity.Nfinhist(acc_no, "0", this.tx.txnmP.tran_desc, "0", "0", this.acct.actmP.cs_no1);
Data.NfinhistD.Create(connectionString, nFhist, dberr);
}
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
Entity.Cstm cstm = Data.CstmD.Read(connectionString, acct.actmP.cs_no1, dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
String mailResponse = "";
if (!Security.OTPUtility.SendMail("SBS", "*****@*****.**", cstm.cs_fname + cstm.cs_mname + cstm.cs_lname,
cstm.cs_email, "Update from SBS for transaction ", tx.txnmP.tran_desc + acct.actmP.ac_bal))
{
mailResponse = "Mail sent.";
}
// -----------------------------------------
resultP = "Transaction Successful. Your new account balance is $" + acct.actmP.ac_bal + " " + mailResponse;
}
return 0; // remove later
}