public int rollbackAddBalance(String connectionString)
{
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(acct.actmP.ac_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(acct.actmP.ac_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", 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;
}
private int processTransaction(String connectionString, String usr, String pwd)
{
/*
* initiate select query on CSTM, to fetch cus_no for the usr and pwd combination
* "select cus_no from CSTM where user = usr and pwd = pwd"
* Using the retrieved cus_no, fetch all account numbers from cstm, and store the retrieved acc nos.
* as "|" delimited string in result. For errors, update error with "true"
*/
/*Entity.Cstm cs = Data.CstmD.Read(connectionString, usr, pwd, dberr);
if (dberr.ifError())
{
Cp_Empm empm = new Cp_Empm(connectionString, usr, pwd, dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
}
else
{
Cp_Actm ac = new Cp_Actm();
this.resultSet = ac.fetchAccountsFromCusNo(connectionString, cs.cs_no, dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
if(this.resultSet == null)
{
dberr.setError(Mnemonics.DbErrorCodes.TXERR_NO_USER);
result = dberr.getErrorDesc(connectionString);
return -1;
}
}
return 0;*/
txnm = new Cp_Txnm(connectionString, this.TXID, dberr);
if (dberr.ifError())
{
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
cstm = new Cp_Cstm(connectionString, usr, pwd, dberr);
if (dberr.ifError())
{
dberr = new Dber();
Cp_Empm empm = new Cp_Empm(connectionString, usr, pwd, dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
if (txnm.txnmP.tran_fin_type.Equals("Y"))
{
// Write to FINHIST table
Entity.Finhist fhist = new Entity.Finhist("0", "0", this.txnm.txnmP.tran_desc,
0, 0, "0", empm.empmP.emp_no, "0", "0");
Data.FinhistD.Create(connectionString, fhist, dberr);
}
else
{
// Write to NFINHIST table
Entity.Nfinhist nFhist = new Entity.Nfinhist("0", "0",
this.txnm.txnmP.tran_desc, empm.empmP.emp_no, "0", "0");
Data.NfinhistD.Create(connectionString, nFhist, dberr);
}
String empNo = empm.empmP.emp_no;
String pvgLevel = Convert.ToString(empm.empmP.emp_pvg);
String empFname = empm.empmP.emp_fname;
String empLname = empm.empmP.emp_lname;
resultP = empNo + "|" + empFname + "|" + empLname + "|" + pvgLevel + "|" + empm.empmP.emp_email;
return 0;
}
//-----------
if (cstm.cstmP.cs_type.Equals("0"))
{
dberr.setError(Mnemonics.DbErrorCodes.TXERR_INACTIVE_CUSTOMER);
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
//--------------
if (txnm.txnmP.tran_fin_type.Equals("Y"))
{
// Write to FINHIST table
Entity.Finhist fhist = new Entity.Finhist("0", "0", this.txnm.txnmP.tran_desc,
0, 0, "0", "0", "0", this.cstm.cstmP.cs_no);
Data.FinhistD.Create(connectionString, fhist, dberr);
}
else
{
// Write to NFINHIST table
Entity.Nfinhist nFhist = new Entity.Nfinhist("0", "0", this.txnm.txnmP.tran_desc, "0", "0", this.cstm.cstmP.cs_no);
Data.NfinhistD.Create(connectionString, nFhist, dberr);
}
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
String cusNo = cstm.cstmP.cs_no;
String csPvgLevel = cstm.cstmP.cs_type;
String csFname = cstm.cstmP.cs_fname;
String csLname = cstm.cstmP.cs_lname;
resultP = cusNo + "|" + csFname + "|" + csLname + "|" + csPvgLevel + "|" + cstm.cstmP.cs_email;
return 0;
}
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
{
//Check if Customer is Active (Enabled)
if (!Validation.isActiveCustomer(connectionString, loginAc))
{
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
//Check if logged user is a Merchant
if (Validation.isMerchant(connectionString, loginAc))
{
//CHANGED 1103
/*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
{
//To account should NOT belong to the logged in customer
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;
}
}
}
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;
Cp_Actm cpActm = new Cp_Actm(connectionString, acc_no, dberr);
pvg = new Privilege(tx.txnmP.tran_pvga, tx.txnmP.tran_pvgb, cpActm.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.addBalance(connectionString, this.changeAmount, dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
if (!this.TXID.Equals(Mnemonics.TxnCodes.TX_TRANSFER_CREDIT))
{
acct.updateBalance(connectionString, dberr);
//acct.addBalance(connectionString, this.changeAmount, 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", 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
}
private int processTransaction(string connectionString, String acc_no, Data.Dber dberr)
{
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;
}
acct = new Cp_Actm(connectionString, acc_no, dberr);
// Check if ACTM fetch for account number acc_no is successful. Return if error encountered
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
// Verify if account has the privilege to execute the transaction
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 + "|" + acct.actmP.ac_no;
if (pvg.writeToPendingTxns(connectionString, acct.actmP.ac_no, "0", acct.actmP.cs_no1, tx.txnmP.tran_pvgb.ToString(),
tx.txnmP.tran_desc, "0", 0, 0, tx.txnmP.tran_id, inData, dberr) != 0)
{
resultP = dberr.getErrorDesc(connectionString);
return -1;
}
resultP = Mnemonics.DbErrorCodes.MSG_SENT_FOR_AUTH;
return 0;
}
// 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(this.acct.actmP.ac_no, "0", this.tx.txnmP.tran_desc,
0, 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(this.acct.actmP.ac_no, "0", this.tx.txnmP.tran_desc, "0", "0","0");
Data.NfinhistD.Create(connectionString, nFhist, dberr);
}
resultP = Convert.ToString(acct.actmP.ac_bal - acct.actmP.ac_hold);
return 0;
}
