/// <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);
try
{
Intuit.Ipp.QueryFilter.QueryService <Intuit.Ipp.Data.Customer> customerQueryService = new Intuit.Ipp.QueryFilter.QueryService <Intuit.Ipp.Data.Customer>(context);
List <Intuit.Ipp.Data.Customer> customers = customerQueryService.Select(s => s).ToList();
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);
Session["show"] = true;
return(Redirect("/Home/index"));
}
catch (System.Exception exp)
{
throw exp;
}
return(View());
}
public static Customer GetCustomer(string customerDisplaysName)
{
try
{
ServiceContext context = QuickBookConnection.GetDataServiceContext();
var service = new DataService(context);
Intuit.Ipp.QueryFilter.QueryService <Customer> queryServiceForCustomer = new Intuit.Ipp.QueryFilter.QueryService <Customer>(context);
System.Collections.ObjectModel.ReadOnlyCollection <Customer> customerList = queryServiceForCustomer.ExecuteIdsQuery("select * from customer");
Customer customer = customerList.First <Customer>(cust => cust.DisplayName == customerDisplaysName);
return(customer);
}
catch (Intuit.Ipp.Exception.IdsException ex)
{
throw;
}
}
/// <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);
try
{
Intuit.Ipp.QueryFilter.QueryService <Intuit.Ipp.Data.Customer> customerQueryService =
new Intuit.Ipp.QueryFilter.QueryService <Intuit.Ipp.Data.Customer>(context);
List <Intuit.Ipp.Data.Customer> customers = customerQueryService.Select(s => s).ToList();
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;
}
}
}
/// <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);
try
{
Intuit.Ipp.QueryFilter.QueryService <Intuit.Ipp.Data.Customer> customerQueryService =
new Intuit.Ipp.QueryFilter.QueryService <Intuit.Ipp.Data.Customer>(context);
List <Intuit.Ipp.Data.Customer> customers = customerQueryService.Select(s => s).ToList();
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);
Session["show"] = true;
Response.Redirect("~/Default.aspx");
}
catch (System.Exception exp)
{
throw exp;
}
}
}
/// <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);
try
{
Intuit.Ipp.QueryFilter.QueryService <Intuit.Ipp.Data.Customer> customerQueryService = new Intuit.Ipp.QueryFilter.QueryService <Intuit.Ipp.Data.Customer>(context);
List <Intuit.Ipp.Data.Customer> customers = customerQueryService.Select(s => s).ToList();
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());
}
