private static void ReadTable()
{
if (PLTBAcct.bRead)
{
return;
}
uint num = 0;
object szValue = new object();
uint createHandle = PLLink.GetLink().TableGET_CreateHandle("TrustBankAcct", 0, 0, 0U);
PLLink.GetLink().TableGET_AddFilter(createHandle, "TrustBankAcctStatus", "EQ", "0", 1);
while (PLLink.GetLink().TableGET_GetNextRecord(createHandle) == 0)
{
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "TrustBankAcctNickName", "", ref szValue);
string Key = szValue.ToString().ToUpper().Trim();
int recordFieldValueI32 = PLLink.GetLink().TableGET_RecordField_ValueI32(createHandle, "TrustBankAcctID");
PLTBAcct.AddMapNNtoID(Key, recordFieldValueI32);
PLTBAcct.AddMapIDtoNN(recordFieldValueI32, Key);
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "TrustBankAcctPostRefNickName", "", ref szValue);
string str1 = szValue.ToString().ToUpper().Trim();
PLTBAcct.AddMapIDtoGLNN(recordFieldValueI32, str1);
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "TrustBankAcctQuickBooksID", "", ref szValue);
string str2 = szValue.ToString().ToUpper().Trim();
if (!str2.Equals(""))
{
PLTBAcct.AddMapPLIDtoQBID(recordFieldValueI32, str2);
}
}
PLLink.GetLink().TableGET_CloseHandle(createHandle);
num = 0U;
PLTBAcct.bRead = true;
}
public override void Send()
{
object nProcessed = new object();
object nExceptions = new object();
object vunIDCreated = new object();
object nExceptionError = new object();
object szExceptionErrorMsg = new object();
object szExceptionSentData = new object();
object szValue = new object();
string szDefault = "";
string str1 = "";
PLGLAccts plglAccts = new PLGLAccts();
this.GetLink().TablePOST_Send(this.m_hndPOST, ref nProcessed, ref nExceptions);
while (this.GetLink().TablePOST_GetNextResult(this.m_hndPOST, ref vunIDCreated, ref nExceptionError, ref szExceptionErrorMsg, ref szExceptionSentData) == 0)
{
if (Convert.ToInt32(nExceptionError) <= 0)
{
int int32 = Convert.ToInt32(vunIDCreated);
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_NickName.sLinkName, szDefault, ref szValue);
PLTBAcct.AddMapIDtoNN(int32, szValue.ToString().ToUpper());
PLTBAcct.AddMapNNtoID(szValue.ToString().ToUpper(), int32);
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_GLNN.sLinkName, szDefault, ref szValue);
PLTBAcct.AddMapIDtoGLNN(int32, szValue.ToString());
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_1.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLTBAcct.AddMapExtID1toPLID(szValue.ToString(), int32);
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_2.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLTBAcct.AddMapExtID2toPLID(szValue.ToString(), int32);
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, "TrustBankAcctQuickBooksID", szDefault, ref szValue);
szValue = (object)szValue.ToString().ToUpper().Trim();
if (!szValue.Equals((object)""))
{
PLTBAcct.AddMapPLIDtoQBID(int32, szValue.ToString());
str1 = szValue.ToString();
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, "TrustBankAcctPostRefNickName", szDefault, ref szValue);
szValue = (object)szValue.ToString().ToUpper().Trim();
if (!szValue.Equals((object)""))
{
string str2 = szValue.ToString();
plglAccts.AddFilter(plglAccts.NickName_LinkName, PLXMLData.eFilterCompare.EQ, str2, 1);
while (plglAccts.GetNextRecord() == 0)
{
PLGLAccts.AddMapNNtoID(str2, plglAccts.ID);
PLGLAccts.AddMapIDtoNN(plglAccts.ID, str2);
plglAccts.ReadExisting((uint)plglAccts.ID);
if (str1 != "")
{
plglAccts.QuickBooksID = str1;
plglAccts.AddRecord();
plglAccts.SendLast();
}
}
}
}
}
short int16_1 = Convert.ToInt16(nProcessed);
short int16_2 = Convert.ToInt16(nExceptions);
PLXMLData.m_lErrorCount += (long)int16_2;
if (((int)int16_2 > 0 ? 1 : (this.m_lCounter != (int)int16_1 ? 1 : 0)) != 0)
{
this.GetLink().TablePOST_DumpExceptionsToLinkLog(this.m_hndPOST);
}
this.GetLink().TablePOST_Reset(this.m_hndPOST);
this.m_lCounter = 0;
}
