public FindAccounts FindMyAcct(string acctID, string acctTypeCd, string acctNbr, string acctName, string vndName, string dunsNbr)
{//http://localhost:57559/api/AcctFind/?acctID=154&acctTypeCd=DUNS&acctNbr=00003506090&acctName=&vndName=&dunsNbr
using (var conn = new SqlConnection(SQL_CONNECTION_STRING))
using (var command = new SqlCommand("s_FindAccounts", conn)
{
CommandType = System.Data.CommandType.StoredProcedure
})
{
FindAccounts fa = new FindAccounts();
command.Parameters.AddWithValue("@AccountID", Convert.ToInt32(acctID));
command.Parameters.AddWithValue("@AcctTypeCode", acctTypeCd);
command.Parameters.AddWithValue("@AccountNbr", acctNbr);
command.Parameters.AddWithValue("@AccountName", acctName);
command.Parameters.AddWithValue("@VndName", vndName);
command.Parameters.AddWithValue("@DunsNbr", dunsNbr);
conn.Open();
var adapter = new SqlDataAdapter(command);
var ds = new DataSet();
adapter.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
fa.VND_ACCT_ID = ds.Tables[0].Rows[0][0].ToString();
fa.ACCT_TYPE_CODE = ds.Tables[0].Rows[0][1].ToString();;
fa.ACCT_NBR = ds.Tables[0].Rows[0][2].ToString();;
fa.ACCOUNT_NAME = ds.Tables[0].Rows[0][3].ToString();
fa.ENABLED_FLAG = ds.Tables[0].Rows[0][4].ToString();
fa.VND_NAME = ds.Tables[0].Rows[0][5].ToString();
fa.DUNS_NBR = ds.Tables[0].Rows[0][6].ToString();
}
return(fa);
}
}
//MAKING AN ORACLE CALL FOR DATA
//string[] Companies - MUST HAVE AN ACTION CODE AS THE FIRST PARAMETER
//string[] Users - MUST HAVE AN ACTION CODE AS THE FIRST PARAMETER
public string ValidatedAdd(string AccountID, string AccountNbr, string[] Companies, string[] Users)
{//20162699 http://localhost:57559/api/AcctValidateAdd/?AccountID=2016269990&AccountNbr=2016269990&Companies[]=A,1,1&Companies[]=D,2,5896
//TestOra();
string sQuery = "SELECT vnd_duns_nbr, vnd_name, vnd_nbr, version_nbr, 'ACCOUNT_CONNECTION_STRING' ";
sQuery += " AS SRC FROM vendor WHERE vnd_duns_nbr =" + AccountNbr.Substring(0, (AccountNbr.Length - 2));
using (var conn = new OracleConnection(ORA_CONNECTION_STRING))
using (var command = new OracleCommand(sQuery, conn)
{
CommandType = System.Data.CommandType.Text
})
{
FindAccounts fa = new FindAccounts();
try
{
conn.Open();
var adapter = new OracleDataAdapter(command);
var ds = new DataSet();
adapter.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{//CHECK IF VENDOR EXISTS
fa.VND_ACCT_ID = ds.Tables[0].Rows[0][0].ToString();
fa.ACCT_TYPE_CODE = "DUNS";
fa.ACCT_NBR = ds.Tables[0].Rows[0][2].ToString();;
fa.ACCOUNT_NAME = ds.Tables[0].Rows[0][3].ToString();
fa.ENABLED_FLAG = ds.Tables[0].Rows[0][4].ToString();
//ADD THE ACCOUNT i.e. Add(AccountID, 'DUNS', QualAccountNbr, RS.Fields['vnd_name'].Value, True, EmptyParam, EmptyParam);
AddAccount(fa.ACCT_TYPE_CODE, fa.ACCT_NBR, fa.ACCOUNT_NAME, true);
foreach (string c in Companies)
{
UpdateLists(fa.VND_ACCT_ID, Companies);
}
foreach (string u in Users)
{
Setusers(fa.VND_ACCT_ID, Users);
}
}
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
return("Success!");
}
