public UserWithdrawalCredit getUserWithdrawalCredit(string TO_SRVC_IND, int TO_PKP_ACCT, int TO_BNK_ACCT)
{
try
{
string usrNbr;
if (TO_SRVC_IND == "1")
{
var newAcct = new Account();
var thisAcct = newAcct.getAccountByAcctID(TO_PKP_ACCT);
if (thisAcct == null)
{
return(null);
}
usrNbr = thisAcct.USR_NBR;
}
else
{
var fiExrlAcct = new FinancialInstitutionExternalAccount();
var thisRcptBnk = fiExrlAcct.getBankRecipientByRcptID(TO_BNK_ACCT);
if (thisRcptBnk == null)
{
return(null);
}
if (thisRcptBnk.EXRL_ACCT_USR_BUS_TCD == "1")
{
usrNbr = thisRcptBnk.EXRL_ACCT_USR_NBR;
}
else
{
var busAcct = db.TACCT.Find(thisRcptBnk.EXRL_ACCT_ID);
if (busAcct == null)
{
return(null);
}
usrNbr = busAcct.USR_NBR;
}
}
var obj = db.TUSR_WHDRL_CRDT.Find(usrNbr);
if (obj == null)
{
return(null);
}
return(obj);
}
catch
{
return(null);
}
}
public string geRecipientUsrNbr(string TO_SRVC_IND, int TO_PKP_ACCT, int TO_BNK_ACCT)
{
try
{
if (TO_SRVC_IND == "1")
{
var newAcct = new Account();
var thisAcct = newAcct.getAccountByAcctID(TO_PKP_ACCT);
if (thisAcct == null)
{
return(null);
}
return(thisAcct.USR_NBR);
}
else
{
var fiExrlAcct = new FinancialInstitutionExternalAccount();
var thisRcptBnk = fiExrlAcct.getBankRecipientByRcptID(TO_BNK_ACCT);
if (thisRcptBnk == null)
{
return(null);
}
if (thisRcptBnk.EXRL_ACCT_USR_BUS_TCD == "1")
{
return(thisRcptBnk.EXRL_ACCT_USR_NBR);
}
else
{
var busAcct = db.TACCT.Find(thisRcptBnk.EXRL_ACCT_ID);
if (busAcct == null)
{
return(null);
}
return(busAcct.USR_NBR);
}
}
}
catch
{
return(null);
}
}
public bool createFinancialInstitutionExternalAccount(string AcctNm, string AcctTCD, string AcctNbr,
string part1, string part2, string part3, string part4, string part5,
int partNbr, string acctVldIND, int fiCtryID,
string ExrlAcctUsrNbr, int?ExrlAcctBusNbr, string UsrBusTCD,
string crcyCD, string usrNbr, string currentUserIND)
{
try
{
var newObj = new FinancialInstitutionExternalAccount();
//just to handle error
newObj.RCPT_EXRL_ACCT_USR_NBR = "0000000000";
newObj.EXRL_ACCT_NM = AcctNm;
newObj.EXRL_ACCT_TCD = AcctTCD;
newObj.EXRL_ACCT_NBR = AcctNbr;
newObj.EXRL_ACCT_PRT1_NBR = part1;
newObj.EXRL_ACCT_PRT2_NBR = part2;
newObj.EXRL_ACCT_PRT3_NBR = part3;
newObj.EXRL_ACCT_PRT4_NBR = part4;
newObj.EXRL_ACCT_PRT5_NBR = part5;
newObj.EXRL_ACCT_PRT_NBR = partNbr;
newObj.EXRL_ACCT_VLDT_IND = acctVldIND;
newObj.FI_CTRY_ID = fiCtryID;
newObj.CRCY_CD = crcyCD;
newObj.EXRL_ACCT_USR_NBR = ExrlAcctUsrNbr;
newObj.EXRL_ACCT_BUS_NBR = ExrlAcctBusNbr;
newObj.EXRL_ACCT_USR_BUS_TCD = UsrBusTCD;
newObj.USR_NBR = usrNbr;
newObj.EXRL_ACCT_FOR_CURT_USR_IND = currentUserIND;
db.TFI_EXRL_ACCT.Add(newObj);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//public FinancialInstitutionExternalAccount getBankRecipientByRcptID(string usrNbr, int rcptID)
//{
// try
// {
// int bn = getBNbyManagerUsrNbr(usrNbr);
// if (bn == 0)
// {
// return null;
// }
// var rcpt = db.TFI_EXRL_ACCT.Find(rcptID);
// if (rcpt == null)
// {
// return null;
// }
// var checkBusList = db.TRCPT_EXRL_ACCT_FOR_BUS.Where(x => x.BN == bn && x.EXRL_ACCT_ID == rcpt.EXRL_ACCT_ID).ToList();
// if (checkBusList.Count() == 0)
// {
// return null;
// }
// return rcpt;
// }
// catch
// {
// return null;
// }
//}
public bool createFinancialInstitutionExternalAccount(string AcctNm, string AcctTCD, string AcctNbr,
string part1, string part2, string part3, string part4, string part5,
int partNbr, string acctVldIND, int fiCtryID,
string ExrlAcctUsrNbr, int?ExrlAcctBusNbr, string UsrBusTCD,
string crcyCD, string usrNbr, string currentUserIND,
string RCPT_EXRL_ACCT_FOR_BUS_TCD)
{
int newInsertID = 0;
try
{
int bn = getBNbyManagerUsrNbr(usrNbr);
if (bn == 0)
{
return(false);
}
var newObj = new FinancialInstitutionExternalAccount();
//just to handle error
newObj.RCPT_EXRL_ACCT_USR_NBR = "0000000000";
newObj.EXRL_ACCT_NM = AcctNm;
newObj.EXRL_ACCT_TCD = AcctTCD;
newObj.EXRL_ACCT_NBR = AcctNbr;
newObj.EXRL_ACCT_PRT1_NBR = part1;
newObj.EXRL_ACCT_PRT2_NBR = part2;
newObj.EXRL_ACCT_PRT3_NBR = part3;
newObj.EXRL_ACCT_PRT4_NBR = part4;
newObj.EXRL_ACCT_PRT5_NBR = part5;
newObj.EXRL_ACCT_PRT_NBR = partNbr;
newObj.EXRL_ACCT_VLDT_IND = acctVldIND;
newObj.FI_CTRY_ID = fiCtryID;
newObj.CRCY_CD = crcyCD;
newObj.EXRL_ACCT_USR_NBR = ExrlAcctUsrNbr;
newObj.EXRL_ACCT_BUS_NBR = ExrlAcctBusNbr;
newObj.EXRL_ACCT_USR_BUS_TCD = UsrBusTCD;
newObj.USR_NBR = usrNbr;
newObj.EXRL_ACCT_FOR_CURT_USR_IND = currentUserIND;
db.TFI_EXRL_ACCT.Add(newObj);
db.SaveChanges();
newInsertID = newObj.EXRL_ACCT_ID;
var newObj1 = new RecipientExternalAccountForBusiness();
newObj1.EXRL_ACCT_ID = newInsertID;
newObj1.RCPT_USR_BUS_ID = null;
newObj1.BN = bn;
newObj1.RCPT_EXRL_ACCT_FOR_BUS_TCD = RCPT_EXRL_ACCT_FOR_BUS_TCD;
db.TRCPT_EXRL_ACCT_FOR_BUS.Add(newObj1);
db.SaveChanges();
return(true);
}
catch
{
if (newInsertID != 0)
{
var newObj = db.TRCPT_EXRL_ACCT_FOR_BUS.Find(newInsertID);
if (newObj != null)
{
db.TRCPT_EXRL_ACCT_FOR_BUS.Remove(newObj);
db.SaveChanges();
}
}
return(false);
}
}
