private static void ReadTable()
{
if (PLVendor.bRead)
{
return;
}
uint num = 0;
object szValue = new object();
string empty = string.Empty;
string szText = "VendorID|VendorNickName|VendorQuickBooksID";
uint createHandle = PLLink.GetLink().TableGET_CreateHandle("Vendor", 0, 0, 0U);
PLLink.GetLink().TableGET_AddFilter(createHandle, "VendorStatus", "EQ", "0", 1);
PLLink.GetLink().TableGET_AddDirective(createHandle, "FieldList", szText);
while (PLLink.GetLink().TableGET_GetNextRecord(createHandle) == 0)
{
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "VendorNickName", "", ref szValue);
string Key = szValue.ToString().ToUpper().Trim();
int recordFieldValueI32 = PLLink.GetLink().TableGET_RecordField_ValueI32(createHandle, "VendorID");
PLVendor.AddMapIDtoNN(recordFieldValueI32, Key);
PLVendor.AddMapNNtoID(Key, recordFieldValueI32);
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "VendorQuickBooksID", "", ref szValue);
if (!szValue.ToString().ToUpper().Trim().Equals(""))
{
PLVendor.AddMapIDtoQuickBooksID(recordFieldValueI32, szValue.ToString());
}
}
PLLink.GetLink().TableGET_CloseHandle(createHandle);
num = 0U;
PLVendor.bRead = true;
}
public static string GetNNFromID(int Key)
{
if (!PLVendor.bRead)
{
PLVendor.ReadTable();
}
return((Key.Equals(0) ? 0 : (PLVendor.m_MapIDtoNN.ContainsKey(Key) ? 1 : 0)) != 0 ? PLVendor.m_MapIDtoNN[Key].ToString() : "");
}
public static int GetIDFromNN(string Key)
{
if (!PLVendor.bRead)
{
PLVendor.ReadTable();
}
Key = Key.ToUpper();
return((Key.Equals("") ? 0 : (PLVendor.m_MapNNtoID.ContainsKey(Key) ? 1 : 0)) != 0 ? Convert.ToInt32(PLVendor.m_MapNNtoID[Key]) : 0);
}
public static int GetIDFromNameKey(string Key)
{
if (!PLVendor.bRead)
{
PLVendor.ReadTable();
}
Key = Key.ToUpper();
return((PLVendor.m_MapNameKeytoPLID.Count == 0 ? 0 : (PLVendor.m_MapNameKeytoPLID.ContainsKey(Key) ? 1 : 0)) != 0 ? Convert.ToInt32(PLVendor.m_MapNameKeytoPLID[Key]) : 0);
}
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 GetQuickBooksIDFromID(int Key)
{
string str;
if (!Key.Equals(0))
{
if (!PLVendor.bRead)
{
PLVendor.ReadTable();
}
str = PLVendor.m_MapIDtoQuickBooksID == null ? string.Empty : (PLVendor.m_MapIDtoQuickBooksID.ContainsKey(Key) ? Convert.ToString(PLVendor.m_MapIDtoQuickBooksID[Key]) : string.Empty);
}
else
{
str = string.Empty;
}
return(str);
}
public static int GetPLIDFromQBID(string sQBID)
{
int num1;
if (!sQBID.Equals(""))
{
if (!PLVendor.bRead)
{
PLVendor.ReadTable();
}
if (PLVendor.m_MapIDtoQuickBooksID == null)
{
num1 = 0;
}
else if (PLVendor.m_MapIDtoQuickBooksID.ContainsValue(sQBID))
{
int num2 = 0;
Dictionary <int, string> .Enumerator enumerator = PLVendor.m_MapIDtoQuickBooksID.GetEnumerator();
while (enumerator.MoveNext())
{
Dictionary <int, string> idtoQuickBooksId = PLVendor.m_MapIDtoQuickBooksID;
KeyValuePair <int, string> current = enumerator.Current;
if (idtoQuickBooksId[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;
try
{
this.GetLink().TablePOST_Send(this.m_hndPOST, ref nProcessed, ref nExceptions);
}
catch (Exception ex)
{
string str1 = ex.Data == null ? "" : ex.Data.ToString();
string str2 = ex.HelpLink == null ? "" : ex.HelpLink.ToString();
string str3 = ex.InnerException == null ? "" : ex.InnerException.ToString();
string message = ex.Message;
string str4 = ex.Source == null ? "" : ex.Source.ToString();
string str5 = ex.StackTrace == null ? "" : ex.StackTrace.ToString();
string str6 = ex.TargetSite == (MethodBase)null ? "" : ex.TargetSite.ToString();
this.GetLink().TablePOST_Reset(this.m_hndPOST);
this.m_lCounter = 0;
return;
}
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);
PLVendor plVendor = this;
plVendor.m_lSendErrorCount = plVendor.m_lSendErrorCount + 1L;
}
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);
PLVendor.AddMapNNtoID(szValue.ToString().ToUpper(), int32);
PLVendor.AddMapIDtoNN(int32, szValue.ToString().ToUpper());
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_1.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLVendor.AddMapExtID1toPLID(szValue.ToString(), int32);
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_2.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLVendor.AddMapExtID2toPLID(szValue.ToString(), int32);
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, "NameKey", szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLVendor.AddMapNameKeytoPLID(szValue.ToString().Trim(), int32);
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_QuickBooksID.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLVendor.AddMapIDtoQuickBooksID(int32, szValue.ToString());
}
}
}
this.GetLink().TablePOST_Reset(this.m_hndPOST);
this.m_lCounter = 0;
}
public override void AddRecord()
{
if ((int)this.m_hndPOST == 0)
{
this.m_hndPOST = this.GetLink().TablePOST_CreateHandle(this.m_sTableName, 0);
}
if (!this.m_NickName.m_bIsSet)
{
++PLVendor.m_nVendorNN;
this.NickName = "~" + PLVendor.m_nVendorNN.ToString();
}
else if ((this.m_ID.m_bIsSet && this.m_ID.nValue.Equals(0) || !this.m_ID.m_bIsSet) && PLVendor.GetIDFromNN(this.NickName) > 0)
{
++PLVendor.m_nVendorNN;
this.NickName = "~" + PLVendor.m_nVendorNN.ToString();
}
else if ((this.NickName.Length.Equals(0) ? 1 : (this.NickName.Length > 6 ? 1 : 0)) != 0)
{
++PLVendor.m_nVendorNN;
this.NickName = "~" + PLVendor.m_nVendorNN.ToString();
}
this.Name.AddFields(this.m_hndPOST);
this.Address.AddFields(this.m_hndPOST);
this.Phone.AddFields(this.m_hndPOST);
this.m_ID.AddField(this.m_hndPOST);
this.m_Status.AddField(this.m_hndPOST);
this.m_NickName.AddField(this.m_hndPOST);
if (this.DefExpCodeNN.Length > 0)
{
int idFromNn = PLExpCode.GetIDFromNN(this.DefExpCodeNN);
if (idFromNn > 0)
{
this.DefExpCodeID = idFromNn;
this.m_DefExpCode.AddField(this.m_hndPOST);
this.DefExpCodeNN = "";
}
}
if (this.DefGLAcctNN.Length > 0)
{
int idFromNn = PLGLAccts.GetIDFromNN(this.DefExpCodeNN);
if (idFromNn > 0)
{
this.DefGLAcctID = idFromNn;
this.m_DefGLAcctID.AddField(this.m_hndPOST);
this.DefGLAcctNN = "";
}
}
this.m_US1099BoxNumber.AddField(this.m_hndPOST);
this.m_US1099ID.AddField(this.m_hndPOST);
this.m_US1099Type.AddField(this.m_hndPOST);
this.m_AcctNum.AddField(this.m_hndPOST);
this.m_ActiveFlag.AddField(this.m_hndPOST);
this.m_DefGSTCat.AddField(this.m_hndPOST);
this.m_DiscDays1.AddField(this.m_hndPOST);
this.m_DiscPct1.AddField(this.m_hndPOST);
this.m_DiscDays2.AddField(this.m_hndPOST);
this.m_DiscPct2.AddField(this.m_hndPOST);
this.m_DiscDays3.AddField(this.m_hndPOST);
this.m_DiscPct3.AddField(this.m_hndPOST);
this.m_Notes.AddField(this.m_hndPOST);
this.m_Terms.AddField(this.m_hndPOST);
this.m_QuickBooksID.AddField(this.m_hndPOST);
this.m_ContactID.AddField(this.m_hndPOST);
this.m_ExternalID_1.AddField(this.m_hndPOST);
this.m_ExternalID_2.AddField(this.m_hndPOST);
this.GetLink().TablePOST_AddRecord(this.m_hndPOST);
PLVendor plVendor = this;
plVendor.m_lCounter = plVendor.m_lCounter + 1;
if (this.m_lCounter < PLXMLData.m_nMaxCounter)
{
return;
}
this.Send();
}
