public static string[] AC_GetVendorPN(string term)
{
try
{
clsUtil u = new clsUtil();
string[] x = u.GetJSONFromDB(DBK.SP.spAC_OTSVENDORPN, "%" + term + "%", DBK.strVENDORPARTNUMBER);
return(x);
}
catch (Exception ex)
{
string strErr = ex.Message + ex.StackTrace;
return(new string[0]);
}
}
public static string[] AC_GetProduct(string term)
{
try
{
clsUtil u = new clsUtil();
string[] x = u.GetJSONFromDB(DBK.SP.spAC_OTSPRODUCT, "%" + term + "%", DBK.strPRODUCT);
return(x);
}
catch (Exception ex)
{
string strErr = ex.Message + ex.StackTrace;
return(new string[0]);
}
}
public static string[] GetAssyNames(string term)
{
try
{
clsUtil u = new clsUtil();
List <SqlParameter> ps = new List <SqlParameter>();
string[] x = u.GetJSONFromDB(DBK.SP.spAC_ASYNAMES, "%" + term + "%", DBK.strNAME);
return(x);
} catch (Exception ex)
{
string strErr = ex.Message + ex.StackTrace;
return(new string[0]);
}
}
public static string[] GetStateProvince(string term)
{
try
{
clsUtil u = new clsUtil();
List <SqlParameter> ps = new List <SqlParameter>();
string[] x = u.GetJSONFromDB(DBK.SP.spAC_LOCSTATEPROVINCE, "%" + term + "%", DBK.strSTATEPROVINCE);
return(x);
}
catch (Exception ex)
{
string strErr = ex.Message + ex.StackTrace;
return(new string[0]);
}
}
public static string[] GetStreetAddress(string term)
{
try
{
clsUtil u = new clsUtil();
List <SqlParameter> ps = new List <SqlParameter>();
string[] x = u.GetJSONFromDB(DBK.SP.spAC_LOCADDRESS, "%" + term + "%", DBK.strADDRESS);
return(x);
}
catch (Exception ex)
{
string strErr = ex.Message + ex.StackTrace;
return(new string[0]);
}
}
public static string[] GetCountry(string term)
{
try
{
clsUtil u = new clsUtil();
List <SqlParameter> ps = new List <SqlParameter>();
string[] x = u.GetJSONFromDB(DBK.SP.spAC_LOCCOUNTRY, "%" + term + "%", DBK.strCOUNTRY);
return(x);
}
catch (Exception ex)
{
string strErr = ex.Message + ex.StackTrace;
return(new string[0]);
}
}
public static string[] GetPostalCode(string term)
{
try
{
clsUtil u = new clsUtil();
List <SqlParameter> ps = new List <SqlParameter>();
string[] x = u.GetJSONFromDB(DBK.SP.spAC_LOCPOSTALCODE, "%" + term + "%", DBK.strPOSTALCODE);
return(x);
}
catch (Exception ex)
{
string strErr = ex.Message + ex.StackTrace;
return(new string[0]);
}
}
public static string[] GetSubInventory(string term)
{
try
{
clsUtil u = new clsUtil();
List <SqlParameter> ps = new List <SqlParameter>();
string[] x = u.GetJSONFromDB(DBK.SP.spAC_INVSUBINVENTORY, "%" + term + "%", DBK.strSUBINV);
return(x);
}
catch (Exception ex)
{
string strErr = ex.Message + ex.StackTrace;
return(new string[0]);
}
}
public static string[] GetAssyBOMRevs(string term)
{
try
{
string[] strSpl = { AAAK.DELIM };
string[] arrTerms = term.Split(strSpl, StringSplitOptions.None);
List <SqlParameter> sqlPs = new List <SqlParameter>();
sqlPs.Add(new SqlParameter("@strName", arrTerms[0]));
sqlPs.Add(new SqlParameter("@strRevision", arrTerms[1]));
clsUtil u = new clsUtil();
string[] x = u.GetJSONFromDB(DBK.SP.spAC_ASYBOMREVSFORGIVENASYNAMEANDREV, "", DBK.intBOMREV, ps: sqlPs);
return(x);
}
catch (Exception ex)
{
string strErr = ex.Message + ex.StackTrace;
return(new string[0]);
}
}