public bool RequestAccessToken(string sRealmID, string sVerifier, string sDataSource) { IToken accessToken = getOAuthSession().ExchangeRequestTokenForAccessToken(itToken, sVerifier); QBConnection qbc = (from i in DbUtil.Db.QBConnections where i.Active == 1 select i).FirstOrDefault(); qbc.Token = accessToken.Token; qbc.Secret = accessToken.TokenSecret; qbc.RealmID = sRealmID; qbc.DataSource = sDataSource; DbUtil.Db.SubmitChanges(); return(true); }
private void btnQBAccess_Click(object sender, EventArgs e) { try { if (CheckValidation()) { lblErrorMsg.Text = ""; ClsCommon.retMessage.Clear(); Program.dispose(); ClsCommon.QBCompanyFile = ""; string OldQBPath = txtQBPath.Text; ClsCommon.retMessage = QBConnection.OpenConnection_anyMode(); if (ClsCommon.retMessage["Status"].Contains("Error:") == false) { ClsCommon.retMessage = QBConnection.GetCompanyInfo(txtVersion.Text); txtQBPath.Text = ClsCommon.retMessage["Path"].ToString(); txtVersion.Text = ClsCommon.retMessage["Version"].ToString(); DisplayMessage("QuickBooks Company File Permission set Successfully", "I"); ClsCommon.WriteErrorLogs("Function :ConfigureGetPath. Message:QuickBooks Company File Permission set Successfully"); Program.mySetting.QBFilePath = txtQBPath.Text; Program.mySetting.QBVersion = txtVersion.Text; Program.mySetting.QBYear = cmbYear.Text.ToString(); Program.mySetting.Save(); GrpItemSetting.Enabled = true; GrpInvSetting.Enabled = true; LoadData(); LoadExistingData(); } else { DisplayMessage(ClsCommon.retMessage["Status"].ToString(), "E"); ClsCommon.WriteErrorLogs("Function :ConfigureGetPathChk. Message:" + ClsCommon.retMessage["Status"].ToString()); } Program.dispose(); } } catch (Exception ex) { ClsCommon.WriteErrorLogs("Form:FrmQBConfig,Function :btnQBAccess_Click. Message:" + ex.Message); DisplayMessage("Error:" + ex.Message, "E"); } }
public Boolean StartQbSession() { Boolean isDone = false; try { if (Program.mySetting.QBFilePath != "") { ClsCommon.QBCompanyFile = Program.mySetting.QBFilePath; } if (Program.mySetting.QBVersion != "") { ClsCommon.QBVersion = Program.mySetting.QBVersion; } Program.dispose(); CommonRef.oSession = null; if (CommonRef.oSession == null) { ClsCommon.retMessage = QBConnection.OpenConnection_anyMode(); if (ClsCommon.retMessage["Status"].ToString() == "Session Created") { isDone = true; } else { ClsCommon.WriteErrorLogs("Start QBSession :" + ClsCommon.retMessage["Status"].ToString()); DisplayMessage(ClsCommon.retMessage["Status"].ToString(), "E"); DisplayMessage("Check QuickBook Session. Try to Connect", "I"); isDone = false; } } return(isDone); } catch (Exception ex) { ClsCommon.WriteErrorLogs("Form:FrmQBSync,Function :StartQbSession. Message:" + ex.Message); DisplayMessage("Error:" + ex.Message, "E"); return(isDone); } }
public string RequestOAuthToken() { itToken = getOAuthSession().GetRequestToken(); DbUtil.Db.ExecuteCommand("UPDATE dbo.QBConnections SET Active = 0"); QBConnection qbc = new QBConnection(); qbc.Creation = DateTime.Now; qbc.DataSource = ""; qbc.Token = itToken.Token; qbc.UserID = Util.UserId; qbc.Active = 1; qbc.Secret = ""; qbc.RealmID = ""; DbUtil.Db.QBConnections.InsertOnSubmit(qbc); DbUtil.Db.SubmitChanges(); // generate a user authorize url for this token (which you can use in a redirect from the current site) string authorizationLink = getOAuthSession().GetUserAuthorizationUrlForToken(itToken, getCallback()); return(authorizationLink); }
public string RequestOAuthToken() { itToken = getOAuthSession().GetRequestToken(); DbUtil.Db.ExecuteCommand("UPDATE dbo.QBConnections SET Active = 0"); QBConnection qbc = new QBConnection(); qbc.Creation = DateTime.Now; qbc.DataSource = ""; qbc.Token = itToken.Token; qbc.UserID = Util.UserId; qbc.Active = 1; qbc.Secret = ""; qbc.RealmID = ""; DbUtil.Db.QBConnections.InsertOnSubmit(qbc); DbUtil.Db.SubmitChanges(); // generate a user authorize url for this token (which you can use in a redirect from the current site) string authorizationLink = getOAuthSession().GetUserAuthorizationUrlForToken(itToken, getCallback()); return authorizationLink; }