//QUERY ONE PRODUCT
public VinProduct.Response1 QueryOneProduct(string sku) //public PS_Response1 QueryOneProduct(string sku)
{
bool result;
double count;
//variables
sku = txtQuerySku.Text; //what if it is BLANK or INCORRECT?
pc = new ProductController(WS_USERNAME, WS_PASSWORD); //create controller (to run query)
//response = new PS_Response1(); //create (Response) object
//product = new PS_Product1(); //create (Product) object for results
response = new VinProduct.Response1(); //create (Response) object
product = new VinProduct.Product1(); //create (Product) object for results
//need to run query
//***************************************
response = pc.PS_SearchProductBySKU2(sku);
//***************************************
//was result successful?
result = (bool)response.IsSuccessful;
count = (double)response.RecordCount;
if (result && count > 0) //if true
{
if (count == 1) //only ONE product (make sure)
{
//create a product
//product = response.Products[0];
//show results
//txtVin65Xml.Text = XmlController.Serialize(product); //xml for product
txtVin65Xml.Text = XmlController.Serialize(response); //xml for entire response
}
}
else if (count == 0)
{
txtVin65Xml.Text = "There were no results found."; //RecordCount is zero(0)
}
return(response);
//product = pc.PS_SearchProductBySKU(sku);
//product.
//product = pc.PS_SearchProductBySKU("739242");
//need to confirm in was successful
//need to show results
//txtVin65Xml.Text = XmlController.Serialize(pc.PS_SearchProductBySKU(sku));
//XmlController.Serialize(pc2.PS_SearchAllProducts2()));
}
//EVENT (Query tab) BUTTON RUN QUERY (to VIN65 web services)
private void btnQuery_Click(object sender, RoutedEventArgs e)
{
//PS_Response1 response = new PS_Response1();
VinProduct.Response1 response = new VinProduct.Response1();
//query one product
if ((bool)radQueryProductSku.IsChecked)
{
//IsQuerySuccessDisplay(QueryOneProduct(txtQuerySku.Text));
IsQuerySuccessDisplay(QueryOneProduct(txtQuerySku.Text));
}
else if ((bool)radQueryProductAll.IsChecked)
{
IsQuerySuccessDisplay(QueryAllProducts());
}
}
//QUERY SUCCESSFUL
private void IsQuerySuccessDisplay(VinProduct.Response1 response) //private void IsQuerySuccessDisplay(PS_Response1 response)
{
bool isSuccessful = (bool)response.IsSuccessful;
double count = (double)response.RecordCount;
if (isSuccessful && count > 0)
{
//show successful
txtQuerySuccess.Text = " Query Successful ";
txtQuerySuccess.Visibility = Visibility.Visible;
txtQuerySuccess.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#00B21C")); //green
}
else
{
//show NOT successful
txtQuerySuccess.Text = " Query NOT Successful ";
txtQuerySuccess.Visibility = Visibility.Visible;
txtQuerySuccess.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#FF1D4F")); //red
}
}
//CONSTRUCTOR
public ProductController(string username, string password)
{
//INSTANTIATE OBJECTS
conn = new MyConnection(username, password); //Establish a connection when an object is created
ps = new VinProduct.ProductServiceService(); //create PRODUCT SERVICES object
//--------------
//SEARCH PRODUCT
ps_request1 = new VinProduct.Request1(); //create REQUEST object
ps_request1.Security = new VinProduct.Security(); //Security settings for connection (to VIN65 web service)
ps_response1 = new VinProduct.Response1(); //create RESPONSE object (array of Products[...])
//SET USERNAME and PASSWORD
ps_request1.Security.Username = conn.Ws_Username; //set global username
//ps_request.Security.Username = "******";
ps_request1.Security.Password = conn.Ws_Password; //set global password
//ps_request.Security.Password = "******";
//--------------
//-------------------
//GET PRODUCT DETAILS
ps_request3 = new VinProduct.Request3(); //create REQUEST object
ps_request3.Security = new VinProduct.Security(); //Security settings for connection (to VIN65 web service)
ps_response3 = new VinProduct.Response3(); //create RESPONSE object (array of Products[...])
//SET USERNAME and PASSWORD
ps_request3.Security.Username = conn.Ws_Username; //set global username
ps_request3.Security.Password = conn.Ws_Password; //set global password
//-------------------
//-----------------------------
//ADD OR UPDATE PRODUCT DETAILS
ps_request2 = new VinProduct.Request2(); //create REQUEST object
ps_request2.Security = new VinProduct.Security(); //Security settings for connection (to VIN65 web service)
ps_response2 = new VinProduct.Response2(); //create RESPONSE object (array of Products[...])
//SET USERNAME and PASSWORD
ps_request2.Security.Username = conn.Ws_Username; //set global username
ps_request2.Security.Password = conn.Ws_Password; //set global password
//-----------------------------
}
//QUERY ALL PRODUCTS
private VinProduct.Response1 QueryAllProducts() //private PS_Response1 QueryAllProducts()
{
bool result;
double count;
//variables
pc = new ProductController(WS_USERNAME, WS_PASSWORD); //create controller (to run query)
//response = new PS_Response1(); //create (Response) object
//product = new PS_Product1(); //create (Product) object for results
response = new VinProduct.Response1(); //create (Response) object
product = new VinProduct.Product1(); //create (Product) object for results
//need to run query
//***************************************
response = pc.PS_SearchAllProducts2();
//***************************************
//was result successful?
result = (bool)response.IsSuccessful;
count = (double)response.RecordCount;
if (result && count > 0) //if true
{
//create a list of products
//products = response.Products;
//show results
//txtVin65Xml.Text = XmlController.Serialize(products); //xml for products
txtVin65Xml.Text = XmlController.Serialize(response); //xml for entire response
}
else if (count == 0)
{
txtVin65Xml.Text = "There were no results found."; //RecordCount is zero(0)
}
return(response);
}
