It’s Just Poison…

I’ve been playing around with Vevocart for a while and there’s something I felt was missing. To be able to show the stock level of individual options.

So if you’re selling Tshirts, in the drop down, it’ll say something like:

Small – 12
Medium (SOLD OUT)
Large – 8
X-Large – 3

This way the customer knows right away if the size they want is available or not BEFORE they try to add it to their cart. =)

Please keep in mind that I’m a VB.NET guy. This is my first time playing around with C# and with this apps code, so there may be a better way, but it’s working for me.

Hope it helps someone else out!

.: Adam

Here’s what I modded:

Made a new class file: /App_Code/GlobalFunctions.cs ::

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
using System.Data.SqlClient;

///

namespace Adam
{
public class GlobalFunctions
{

public static DataSet GetDataFromSQL(string strDBName, string strSQL)
{
string strConn = ConfigurationManager.ConnectionStrings[strDBName].ConnectionString;
SqlConnection objConn = new SqlConnection();
objConn.ConnectionString = strConn;
SqlDataAdapter objAdapter = new SqlDataAdapter();
SqlCommand objCommand = new SqlCommand();
DataSet myDataSet = new DataSet();

objCommand.Connection = objConn;
objCommand.CommandText = strSQL;
objAdapter.SelectCommand = objCommand;
objAdapter.Fill(myDataSet, strDBName);
objAdapter.Dispose();
objConn.Close();
objConn.Dispose();

return myDataSet;
}
}
}

/Components/OptionItemDetails.ascx.cs ::

Add ProductID to the variables being sent to the function

Line 174: uxOptionDropDownItem.SetUpDropDown( table, ProductID );

/Components/OptionDropDownItem.ascx.cs ::

Replace class SetUpDropDown with the following code:

public void SetUpDropDown( DataTable table, string ProductID )
{
int i = 0;
int intOptionID = 0;
string strOptionValue = “”;
string strValue = “”;

foreach (DataRow dRow in table.Rows)
{
// Get the option ID
intOptionID = Convert.ToInt32(table.Rows[i][0].ToString());

// Get the option value
strOptionValue = table.Rows[i][7].ToString();

DataSet ds = new DataSet();
string strSQL = “select ProductStock.Stock”;
strSQL += ” FROM ProductStock”;
strSQL += ” LEFT JOIN OptionCombination”;
strSQL += ” ON ProductStock.OptionCombinationID = OptionCombination.OptionCombinationID”;
strSQL += ” WHERE ProductStock.ProductID=” + ProductID + ” AND OptionCombination.ProductOptionItemID=” + intOptionID;
strSQL += ” ORDER BY OptionCombination.ProductOptionItemID”;

ds = Adam.GlobalFunctions.GetDataFromSQL(“MainConnection”, strSQL);
if (ds.Tables[0].Rows.Count > 0)
{
strValue = ds.Tables[0].Rows[0]["Stock"].ToString();
}

// Update the value and insert into table
if (strValue == “0″)
{
strValue = ” (SOLD OUT)”;
}
else
{
strValue = ” – ” + strValue;
}
table.Rows[i][7] = strOptionValue + strValue;

// Increment
i++;
}

uxOptionDrop.DataSource = table;
uxOptionDrop.DataBind();

uxOptionDrop.Items.Insert(0, new ListItem(” — Please Select — “, String.Empty));
}

So, I’m on a flight right now (yes, I’m posting this from a plane =), and I figured out an easy trick to score free wireless. If you’re on a delta flight with WiFi, they us the internet provider GoGoInflight.com. Right now, they have a “game” where you can win 25%, 50%, or 100% off the cost of the WiFi (normally $13 / flight). The trick is that the game is cookie based. So all you have to do is keep deleting your cookies and replay the game until you score the code for the 100% off =)

Cheers!

.: Adam