private static void ReadTable()
{
if (PLGBAcct.bRead)
{
return;
}
uint num = 0;
object szValue = new object();
uint createHandle = PLLink.GetLink().TableGET_CreateHandle("GeneralBankAcct", 0, 0, 0U);
PLLink.GetLink().TableGET_AddFilter(createHandle, "GeneralBankAcctStatus", "EQ", "0", 1);
while (PLLink.GetLink().TableGET_GetNextRecord(createHandle) == 0)
{
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "GeneralBankAcctNickName", "", ref szValue);
string Key = szValue.ToString().ToUpper().Trim();
int recordFieldValueI32 = PLLink.GetLink().TableGET_RecordField_ValueI32(createHandle, "GeneralBankAcctID");
PLGBAcct.AddMapNNtoID(Key, recordFieldValueI32);
PLGBAcct.AddMapIDtoNN(recordFieldValueI32, Key);
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "GeneralBankAcctPostRefNickName", "", ref szValue);
string str1 = szValue.ToString().ToUpper().Trim();
PLGBAcct.AddMapIDtoGLNN(recordFieldValueI32, str1);
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "GeneralBankAcctQuickBooksID", "", ref szValue);
string str2 = szValue.ToString().ToUpper().Trim();
if (!str2.Equals(""))
{
PLGBAcct.AddMapPLIDtoQBID(recordFieldValueI32, str2);
}
}
PLLink.GetLink().TableGET_CloseHandle(createHandle);
num = 0U;
PLGBAcct.bRead = true;
}
public static string GetNNFromID(int nID)
{
if (!PLGBAcct.bRead)
{
PLGBAcct.ReadTable();
}
return(PLGBAcct.m_MapIDtoNN.ContainsKey(nID) ? PLGBAcct.m_MapIDtoNN[nID].ToString() : "");
}
public static int GetIDFromNN(string Key)
{
if (!PLGBAcct.bRead)
{
PLGBAcct.ReadTable();
}
Key = Key.ToUpper();
return(PLGBAcct.m_MapNNtoID.ContainsKey(Key) ? Convert.ToInt32(PLGBAcct.m_MapNNtoID[Key]) : 0);
}
public override void AddRecord()
{
base.AddRecord();
this.GetLink().TablePOST_AddRecord(this.m_hndPOST);
PLGBAcct plgbAcct = this;
plgbAcct.m_lCounter = plgbAcct.m_lCounter + 1;
if (this.m_lCounter < PLXMLData.m_nMaxCounter)
{
return;
}
this.Send();
}
public PCLawConversion()
{
try
{
this.PL = new PLLink();
this.GenInf = new PLGenInfo();
this.Lawyer = new PLLawyer();
this.User = new PLUser();
this.Rate = new PLRate();
this.ContactType = new PLContactType();
this.DiaryCode = new PLDiaryCode();
this.ExpCode = new PLExpCode();
this.GLAccts = new PLGLAccts();
this.Task = new PLTask();
this.GBAcct = new PLGBAcct();
this.TBAcct = new PLTBAcct();
this.TypeOfLaw = new PLTypeOfLaw();
this.Location = new PLLocationCode();
this.Department = new PLDepartment();
this.RefSource = new PLRefSource();
this.Client = new PLClient();
this.Contact = new PLContact();
this.Matter = new PLMatter();
this.Vendor = new PLVendor();
this.Bill = new PLBilling();
this.WUD = new PLWUD();
this.TimeEntry = new PLTimeEntry();
this.Trust = new PLTBEnt();
this.General = new PLGBEnt();
this.Expense = new PLExpense();
this.Payable = new PLPayableEntry();
this.GJ = new PLGJEntry();
this.Diary = new PLDiary();
this.SCStageGroup = new PLSafeCustStageGroup();
this.SCStage = new PLSafeCustStage();
this.SCType = new PLSafeCustType();
this.SCStatus = new PLSafeCustStatus();
this.SCPacket = new PLSafeCustPacket();
this.SCSafeCustRecord = new PLSafeCustEntry();
this.SCMovements = new PLSafeCustMovement();
this.CustomTab = new PLCustomTab();
}
catch (Exception ex)
{
int num = (int)MessageBox.Show(ex.Message);
}
}
public static string GetQBIDFromPLID(int nID)
{
string str;
if (!nID.Equals(0))
{
if (!PLGBAcct.bRead)
{
PLGBAcct.ReadTable();
}
str = PLGBAcct.m_MapPLIDtoQBID == null ? "" : (PLGBAcct.m_MapPLIDtoQBID.ContainsKey(nID) ? Convert.ToString(PLGBAcct.m_MapPLIDtoQBID[nID]) : "");
}
else
{
str = "";
}
return(str);
}
public static int GetPLIDFromQBID(string sQBID)
{
int num1;
if (!sQBID.Equals(""))
{
if (!PLGBAcct.bRead)
{
PLGBAcct.ReadTable();
}
if (PLGBAcct.m_MapPLIDtoQBID == null)
{
num1 = 0;
}
else if (PLGBAcct.m_MapPLIDtoQBID.ContainsValue(sQBID))
{
int num2 = 0;
Dictionary <int, string> .Enumerator enumerator = PLGBAcct.m_MapPLIDtoQBID.GetEnumerator();
while (enumerator.MoveNext())
{
Dictionary <int, string> mapPliDtoQbid = PLGBAcct.m_MapPLIDtoQBID;
KeyValuePair <int, string> current = enumerator.Current;
if (mapPliDtoQbid[current.Key].ToUpper().CompareTo(sQBID.ToUpper()) == 0)
{
current = enumerator.Current;
num2 = current.Key;
}
}
num1 = num2;
}
else
{
num1 = 0;
}
}
else
{
num1 = 0;
}
return(num1);
}
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 = "";
this.m_lSendErrorCount = 0L;
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);
PLGBAcct.AddMapIDtoNN(int32, szValue.ToString());
PLGBAcct.AddMapNNtoID(szValue.ToString(), int32);
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_GLNN.sLinkName, szDefault, ref szValue);
PLGBAcct.AddMapIDtoGLNN(int32, szValue.ToString());
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_1.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLGBAcct.AddMapExtID1toPLID(szValue.ToString(), Convert.ToInt32(vunIDCreated));
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_2.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLGBAcct.AddMapExtID2toPLID(szValue.ToString(), Convert.ToInt32(vunIDCreated));
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, "GeneralBankAcctQuickBooksID", szDefault, ref szValue);
szValue = (object)szValue.ToString().ToUpper().Trim();
if (!szValue.Equals((object)""))
{
PLGBAcct.AddMapPLIDtoQBID(int32, szValue.ToString());
str1 = szValue.ToString();
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, "GeneralBankAcctPostRefNickName", 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);
PLGBAcct plgbAcct = this;
plgbAcct.m_lSendErrorCount = plgbAcct.m_lSendErrorCount + 1L;
}
this.GetLink().TablePOST_Reset(this.m_hndPOST);
this.m_lCounter = 0;
}