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;

///

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));
}