/// <summary>
/// Page Load Event, pulls Customer data from QuickBooks using SDK and Binds it to Grid
/// </summary>
/// <param name="sender">Sender of the event.</param>
/// <param name="e">Event Args.</param>
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session.Keys.Count > 0)
{
realmId = HttpContext.Current.Session["realm"].ToString();
accessToken = HttpContext.Current.Session["accessToken"].ToString();
accessTokenSecret = HttpContext.Current.Session["accessTokenSecret"].ToString();
consumerKey = ConfigurationManager.AppSettings["consumerKey"].ToString(CultureInfo.InvariantCulture);
consumerSecret = ConfigurationManager.AppSettings["consumerSecret"];
dataSourcetype = HttpContext.Current.Session["dataSource"].ToString().ToLower() == "qbd" ? IntuitServicesType.QBD : IntuitServicesType.QBO;
OAuthRequestValidator oauthValidator = new OAuthRequestValidator(accessToken, accessTokenSecret, consumerKey, consumerSecret);
ServiceContext context = new ServiceContext(oauthValidator, realmId, dataSourcetype);
DataServices commonService = new DataServices(context);
try
{
switch (dataSourcetype)
{
case IntuitServicesType.QBD:
var qbdCustomerQuery = new Intuit.Ipp.Data.Qbd.CustomerQuery();
qbdCustomerQuery.ItemElementName = Intuit.Ipp.Data.Qbd.ItemChoiceType4.StartPage;
qbdCustomerQuery.Item = "1";
qbdCustomerQuery.ChunkSize = "10";
var qbdCustomers = qbdCustomerQuery.ExecuteQuery <Intuit.Ipp.Data.Qbd.Customer>(context).ToList();
grdQuickBooksCustomers.DataSource = qbdCustomers;
break;
case IntuitServicesType.QBO:
var qboCustomer = new Intuit.Ipp.Data.Qbo.Customer();
var qboCustomers = commonService.FindAll(qboCustomer, 1, 10).ToList();
grdQuickBooksCustomers.DataSource = qboCustomers;
break;
}
grdQuickBooksCustomers.DataBind();
if (grdQuickBooksCustomers.Rows.Count > 0)
{
GridLocation.Visible = true;
MessageLocation.Visible = false;
}
else
{
GridLocation.Visible = false;
MessageLocation.Visible = true;
}
}
catch (Intuit.Ipp.Exception.InvalidTokenException)
{
//Remove the Oauth access token from the OauthAccessTokenStorage.xml
OauthAccessTokenStorageHelper.RemoveInvalidOauthAccessToken(Session["FriendlyEmail"].ToString(), Page);
Session["show"] = true;
Response.Redirect("~/Default.aspx");
}
}
}
/// <summary>
/// Page Load Event, pulls Customer data from QuickBooks using SDK and Binds it to Grid
/// </summary>
/// <param name="sender">Sender of the event.</param>
/// <param name="e">Event Args.</param>
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session.Keys.Count > 0)
{
realmId = HttpContext.Current.Session["realm"].ToString();
accessToken = HttpContext.Current.Session["accessToken"].ToString();
accessTokenSecret = HttpContext.Current.Session["accessTokenSecret"].ToString();
consumerKey = ConfigurationManager.AppSettings["consumerKey"].ToString(CultureInfo.InvariantCulture);
consumerSecret = ConfigurationManager.AppSettings["consumerSecret"];
dataSourcetype = HttpContext.Current.Session["dataSource"].ToString().ToLower() == "qbd" ? IntuitServicesType.QBD : IntuitServicesType.QBO;
OAuthRequestValidator oauthValidator = new OAuthRequestValidator(accessToken, accessTokenSecret, consumerKey, consumerSecret);
ServiceContext context = new ServiceContext(oauthValidator, realmId, dataSourcetype);
DataServices commonService = new DataServices(context);
try
{
switch(dataSourcetype)
{
case IntuitServicesType.QBD:
var qbdCustomerQuery = new Intuit.Ipp.Data.Qbd.CustomerQuery();
qbdCustomerQuery.ItemElementName = Intuit.Ipp.Data.Qbd.ItemChoiceType4.StartPage;
qbdCustomerQuery.Item = "1";
qbdCustomerQuery.ChunkSize = "10";
var qbdCustomers = qbdCustomerQuery.ExecuteQuery<Intuit.Ipp.Data.Qbd.Customer>(context).ToList();
grdQuickBooksCustomers.DataSource = qbdCustomers;
break;
case IntuitServicesType.QBO:
var qboCustomer = new Intuit.Ipp.Data.Qbo.Customer();
var qboCustomers = commonService.FindAll(qboCustomer, 1, 10).ToList();
grdQuickBooksCustomers.DataSource = qboCustomers;
break;
}
grdQuickBooksCustomers.DataBind();
if (grdQuickBooksCustomers.Rows.Count > 0)
{
GridLocation.Visible = true;
MessageLocation.Visible = false;
}
else
{
GridLocation.Visible = false;
MessageLocation.Visible = true;
}
}
catch (Intuit.Ipp.Exception.InvalidTokenException)
{
//Remove the Oauth access token from the OauthAccessTokenStorage.xml
OauthAccessTokenStorageHelper.RemoveInvalidOauthAccessToken(Session["FriendlyEmail"].ToString(), Page);
Session["show"] = true;
Response.Redirect("~/Default.aspx");
}
}
}
/// <summary>
/// Page Load Event, pulls Customer data from QuickBooks using SDK and Binds it to Grid
/// </summary>
/// <param name="sender">Sender of the event.</param>
/// <param name="e">Event Args.</param>
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session.Keys.Count > 0)
{
String realmId = HttpContext.Current.Session["realm"].ToString();
String accessToken = HttpContext.Current.Session["accessToken"].ToString();
String accessTokenSecret = HttpContext.Current.Session["accessTokenSecret"].ToString();
String consumerKey = ConfigurationManager.AppSettings["consumerKey"].ToString(CultureInfo.InvariantCulture);
String consumerSecret = ConfigurationManager.AppSettings["consumerSecret"].ToString(CultureInfo.InvariantCulture);
IntuitServicesType intuitServiceType = (IntuitServicesType)HttpContext.Current.Session["intuitServiceType"];
OAuthRequestValidator oauthValidator = new OAuthRequestValidator(accessToken, accessTokenSecret, consumerKey, consumerSecret);
ServiceContext context = new ServiceContext(oauthValidator, realmId, intuitServiceType);
DataServices commonService = new DataServices(context);
try
{
switch(intuitServiceType )
{
case IntuitServicesType.QBO:
Intuit.Ipp.Data.Qbo.Customer qboCustomer = new Intuit.Ipp.Data.Qbo.Customer();
IEnumerable<Intuit.Ipp.Data.Qbo.Customer> qboCustomers = commonService.FindAll(qboCustomer, 1, 10) as IEnumerable<Intuit.Ipp.Data.Qbo.Customer>;
grdQuickBooksCustomers.DataSource = qboCustomers;
break;
case IntuitServicesType.QBD:
//FindAll() is a GET operation for QBD, so we need to use the respective Query object instead to POST the start page and records per page (ChunkSize).
Intuit.Ipp.Data.Qbd.CustomerQuery qbdCustomerQuery = new Intuit.Ipp.Data.Qbd.CustomerQuery();
qbdCustomerQuery.ItemElementName = Intuit.Ipp.Data.Qbd.ItemChoiceType4.StartPage;
qbdCustomerQuery.Item = "1";
qbdCustomerQuery.ChunkSize = "10";
IEnumerable<Intuit.Ipp.Data.Qbd.Customer> qbdCustomers = qbdCustomerQuery.ExecuteQuery<Intuit.Ipp.Data.Qbd.Customer>(context) as IEnumerable<Intuit.Ipp.Data.Qbd.Customer>;
grdQuickBooksCustomers.DataSource = qbdCustomers;
break;
default:
throw new Exception("Data Source not defined.");
}
grdQuickBooksCustomers.DataBind();
if (grdQuickBooksCustomers.Rows.Count > 0)
{
GridLocation.Visible = true;
MessageLocation.Visible = false;
}
else
{
GridLocation.Visible = false;
MessageLocation.Visible = true;
}
}
catch
{
throw;
}
}
}
/// <summary>
/// Action Results for Index
/// </summary>
/// <returns>Action Result.</returns>
public ActionResult Index()
{
realmId = Session["realm"].ToString();
accessToken = Session["accessToken"].ToString();
accessTokenSecret = Session["accessTokenSecret"].ToString();
consumerKey = ConfigurationManager.AppSettings["consumerKey"].ToString();
consumerSecret = ConfigurationManager.AppSettings["consumerSecret"].ToString();
dataSourcetype = Session["dataSource"].ToString();
OAuthRequestValidator oauthValidator = Initializer.InitializeOAuthValidator(accessToken, accessTokenSecret, consumerKey, consumerSecret);
ServiceContext context = Initializer.InitializeServiceContext(oauthValidator, realmId, string.Empty, string.Empty, dataSourcetype);
DataServices commonService = new DataServices(context);
try
{
// Specify a Request validator
if (dataSourcetype.ToLower() == "qbd")
{
Intuit.Ipp.Data.Qbd.CustomerQuery qbdCustomerQuery = new Intuit.Ipp.Data.Qbd.CustomerQuery();
qbdCustomerQuery.ItemElementName = Intuit.Ipp.Data.Qbd.ItemChoiceType4.StartPage;
qbdCustomerQuery.Item = "1";
qbdCustomerQuery.ChunkSize = "10";
IEnumerable <Intuit.Ipp.Data.Qbd.Customer> customers = qbdCustomerQuery.ExecuteQuery <Intuit.Ipp.Data.Qbd.Customer>
(context) as IEnumerable <Intuit.Ipp.Data.Qbd.Customer>;
}
else
{
Intuit.Ipp.Data.Qbo.Customer qboCustomer = new Intuit.Ipp.Data.Qbo.Customer();
IEnumerable <Intuit.Ipp.Data.Qbo.Customer> customers = commonService.FindAll(qboCustomer, 1, 10) as IEnumerable <Intuit.Ipp.Data.Qbo.Customer>;
ViewBag.MyCollection = customers;
ViewBag.CustomerCount = customers.Count();
}
}
catch (Intuit.Ipp.Exception.InvalidTokenException exp)
{
//Remove the Oauth access token from the OauthAccessTokenStorage.xml
OauthAccessTokenStorageHelper.RemoveInvalidOauthAccessToken(Session["FriendlyEmail"].ToString(), this);
//show a message to the user that token is invalid
string message = "<SCRIPT LANGUAGE='JavaScript' >alert('Your authorization to this application to access your quickbook data is no longer Valid.Please provide authorization again.')</SCRIPT>";
// show user the connect to quickbook page again
Response.Write(message);
Redirect("/Home/index");
}
catch (System.Exception exp)
{
throw exp;
}
return(View());
}
/// <summary>
/// Page Load Event, pulls data from QuickBooks using SDK and Binds it to Grid
/// </summary>
/// <param name="sender">Sender of the event.</param>
/// <param name="e">Event Args.</param>
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session.Keys.Count > 0)
{
realmId = HttpContext.Current.Session["realm"].ToString();
accessToken = HttpContext.Current.Session["accessToken"].ToString();
accessTokenSecret = HttpContext.Current.Session["accessTokenSecret"].ToString();
consumerKey = ConfigurationManager.AppSettings["consumerKey"].ToString();
consumerSecret = ConfigurationManager.AppSettings["consumerSecret"].ToString();
dataSourcetype = HttpContext.Current.Session["dataSource"].ToString();
OAuthRequestValidator oauthValidator = Initializer.InitializeOAuthValidator(accessToken, accessTokenSecret, consumerKey, consumerSecret);
ServiceContext context = Initializer.InitializeServiceContext(oauthValidator, realmId, string.Empty, string.Empty, dataSourcetype);
DataServices commonService = new DataServices(context);
try
{
// Specify a Request validator
if (dataSourcetype.ToLower() == "qbd")
{
Intuit.Ipp.Data.Qbd.CustomerQuery qbdCustomerQuery = new Intuit.Ipp.Data.Qbd.CustomerQuery();
qbdCustomerQuery.ItemElementName = Intuit.Ipp.Data.Qbd.ItemChoiceType4.StartPage;
qbdCustomerQuery.Item = "1";
qbdCustomerQuery.ChunkSize = "10";
IEnumerable <Intuit.Ipp.Data.Qbd.Customer> customers = qbdCustomerQuery.ExecuteQuery <Intuit.Ipp.Data.Qbd.Customer>
(context) as IEnumerable <Intuit.Ipp.Data.Qbd.Customer>;
GridView1.DataSource = customers;
}
else
{
Intuit.Ipp.Data.Qbo.Customer qboCustomer = new Intuit.Ipp.Data.Qbo.Customer();
IEnumerable <Intuit.Ipp.Data.Qbo.Customer> customers = commonService.FindAll(qboCustomer, 1, 10) as IEnumerable <Intuit.Ipp.Data.Qbo.Customer>;
GridView1.DataSource = customers;
}
GridView1.DataBind();
if (GridView1.Rows.Count > 0)
{
GridLocation.Visible = true;
MessageLocation.Visible = false;
}
else
{
GridLocation.Visible = false;
MessageLocation.Visible = true;
}
}
catch (Intuit.Ipp.Exception.InvalidTokenException exp)
{
//Remove the Oauth access token from the OauthAccessTokenStorage.xml
OauthAccessTokenStorageHelper.RemoveInvalidOauthAccessToken(Session["FriendlyEmail"].ToString(), Page);
//show a message to the user that token is invalid
string message = "<SCRIPT LANGUAGE='JavaScript' >alert('Your authorization to this application to access your quickbook data is no longer Valid.Please provide authorization again.')</SCRIPT>";
// show user the connect to quickbook page again
Response.Write(message);
Response.Redirect("default.aspx");
}
catch (System.Exception exp)
{
throw exp;
}
}
}
