private static void ReadTable()
{
if (PLExpCode.bRead)
{
return;
}
uint num = 0;
object szValue = new object();
uint createHandle = PLLink.GetLink().TableGET_CreateHandle("Explanation", 0, 0, 0U);
PLLink.GetLink().TableGET_AddFilter(createHandle, "ActivityStatus", "EQ", "0", 1);
while (PLLink.GetLink().TableGET_GetNextRecord(createHandle) == 0)
{
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "ActivityNickName", "", ref szValue);
string sNickname = szValue.ToString().ToUpper().Trim();
int recordFieldValueI32 = PLLink.GetLink().TableGET_RecordField_ValueI32(createHandle, "ActivityID");
PLExpCode.AddMapIDtoNN(recordFieldValueI32, sNickname.ToUpper());
PLExpCode.AddMapNNtoID(sNickname.ToUpper(), recordFieldValueI32);
PLExpCode.AddNicknameToList(sNickname);
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "ActivityName", "", ref szValue);
PLExpCode.AddMapIDtoExplanation(recordFieldValueI32, szValue.ToString());
PLLink.GetLink().TableGET_RecordField_ValueString(createHandle, "ActivityQuickBooksID", "", ref szValue);
string str = szValue.ToString().ToUpper().Trim();
if (!str.Equals(""))
{
PLExpCode.AddMapPLIDtoQBID(recordFieldValueI32, str);
}
}
PLLink.GetLink().TableGET_CloseHandle(createHandle);
num = 0U;
PLExpCode.bRead = true;
}
public static string GetNNFromID(int Key)
{
if (!PLExpCode.bRead)
{
PLExpCode.ReadTable();
}
return(PLExpCode.m_MapIDtoNN.ContainsKey(Key) ? PLExpCode.m_MapIDtoNN[Key].ToString() : "");
}
public static int GetIDFromNN(string Key)
{
if (!PLExpCode.bRead)
{
PLExpCode.ReadTable();
}
Key = Key.ToUpper();
return(PLExpCode.m_MapNNtoID.ContainsKey(Key) ? Convert.ToInt32(PLExpCode.m_MapNNtoID[Key]) : 0);
}
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;
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);
PLExpCode.AddMapIDtoNN(int32, szValue.ToString().ToUpper());
PLExpCode.AddMapNNtoID(szValue.ToString().ToUpper(), int32);
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_Name.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLExpCode.AddMapIDtoExplanation(int32, szValue.ToString());
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_1.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLExpCode.AddMapExtID1toPLID(szValue.ToString(), int32);
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, this.m_ExternalID_2.sLinkName, szDefault, ref szValue);
if (!szValue.ToString().Equals(""))
{
PLExpCode.AddMapExtID2toPLID(szValue.ToString(), int32);
}
this.GetLink().TablePOST_ResultDataField_String(this.m_hndPOST, "ActivityQuickBooksID", szDefault, ref szValue);
PLExpCode.AddMapPLIDtoQBID(Convert.ToInt32(vunIDCreated), szValue.ToString());
}
}
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);
PLExpCode plExpCode = this;
plExpCode.m_lSendErrorCount = plExpCode.m_lSendErrorCount + 1L;
}
this.GetLink().TablePOST_Reset(this.m_hndPOST);
this.m_lCounter = 0;
}
public override string MakeNN(bool bSetNickName)
{
if (!PLExpCode.bRead)
{
PLExpCode.ReadTable();
}
string str = this.MakeListNN(this.Name, PLExpCode.m_NNs, (short)6);
if (bSetNickName)
{
this.NickName = str;
}
return(str);
}
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 (!PLExpCode.bRead)
{
PLExpCode.ReadTable();
}
str = PLExpCode.m_MapPLIDtoQBID == null ? "" : (PLExpCode.m_MapPLIDtoQBID.ContainsKey(nID) ? Convert.ToString(PLExpCode.m_MapPLIDtoQBID[nID]) : "");
}
else
{
str = "";
}
return(str);
}
public override void AddRecord()
{
//if (!this.m_NickName.m_bIsSet)
// this.NickName = this.MakeNN(true);
//else if ((this.m_ID.m_bIsSet && this.m_ID.nValue.Equals(0) || !this.m_ID.m_bIsSet) && PLExpCode.GetIDFromNN(this.NickName) > 0)
// this.NickName = this.MakeNN(true);
//else if ((this.NickName.Length.Equals(0) ? 1 : (this.NickName.Length > 6 ? 1 : 0)) != 0)
//this.NickName = this.MakeNN(true);
PLExpCode.AddNicknameToList(this.NickName);
base.AddRecord();
this.GetLink().TablePOST_AddRecord(this.m_hndPOST);
PLExpCode plExpCode = this;
plExpCode.m_lCounter = plExpCode.m_lCounter + 1;
if (this.m_lCounter < PLXMLData.m_nMaxCounter)
{
return;
}
this.Send();
}
public static int GetPLIDFromQBID(string sQBID)
{
int num1;
if (!sQBID.Equals(""))
{
if (!PLExpCode.bRead)
{
PLExpCode.ReadTable();
}
if (PLExpCode.m_MapPLIDtoQBID == null)
{
num1 = 0;
}
else if (PLExpCode.m_MapPLIDtoQBID.ContainsValue(sQBID))
{
int num2 = 0;
Dictionary <int, string> .Enumerator enumerator = PLExpCode.m_MapPLIDtoQBID.GetEnumerator();
while (enumerator.MoveNext())
{
Dictionary <int, string> mapPliDtoQbid = PLExpCode.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 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();
}