public static List <XrefRecord> GetXrefList(User user, FilterInfo filter)
{
List <XrefRecord> ret = new List <XrefRecord>();
try
{
var connection = ConnectionsMgr.GetOCConnection(user, Home);
{
var recCount = _GetRecordCount(user, connection, filter);
if (recCount > 0)
{
filter.ResultCount = recCount;
filter.MaxPage = (int)(Math.Ceiling(recCount / (double)resultPageSize));
}
using (var queryCurrent = connection.Select("*", CatXref, $"WHERE {filter.ToFetchQueryString(user, searchCols, resultPageSize)}"))
{
while (queryCurrent.Read())
{
XrefRecord xr = new XrefRecord(queryCurrent);
ret.Add(xr);
}
}
}
connection.Close();
}
catch (Exception e)
{
ProgramLog.LogError(user, nameof(CatalogXrefManager), nameof(GetXrefList), e.Message);
}
return(ret);
}
public static bool CreateXref(User user, XrefRecord rec)
{
string sVendName = rec.CompanyName.Truncate(60).SQLEscape();
string sVendId = rec.GXSAccount.Truncate(15).SQLEscape();
string sVendSeq = rec.SelectionCode.Truncate(3).SQLEscape();
string sBrandName = rec.BrandName.Truncate(80).SQLEscape();
string sCustomer = user.Customer.SQLEscape();
string sPartner = user.ActivePartner.SQLEscape();
string skey = DBConnect.GenerateUniqueKey();
Dictionary <string, string> insertDict = new Dictionary <string, string>()
{
{ UniqueKey, skey },
{ VendorName, sVendName },
{ VendorId, sVendId },
{ VendorSeq, sVendSeq },
{ BrandName, sBrandName },
{ Customer, sCustomer },
{ Partner, sPartner }
};
try
{
DBConnect connection = ConnectionsMgr.GetOCConnection(user, Home);
{
connection.Insert(CatXref, insertDict);
}
connection.Close();
}
catch (Exception e)
{
ProgramLog.LogError(user, nameof(CatalogXrefManager), nameof(CreateXref), e.Message);
return(false);
}
return(true);
}