public string GetData(int prodId)
{
try
{
EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect();
string query = "select * from Products where ProdID = @ID";
SqlParameter param1 = new SqlParameter("@ID", SqlDbType.Int);
param1.Value = prodId;
string res = "";
SqlDataReader dr = aEShoppingConn.GetReader(query, CommandType.Text, param1);
while (dr.Read())
{
string name = dr.GetString(dr.GetOrdinal("ItemName"));
string category = dr.GetString(dr.GetOrdinal("Category"));
double price = (double)dr.GetDecimal(dr.GetOrdinal("ItemPrice"));
int stock = (int)dr.GetInt32(dr.GetOrdinal("Stock"));
res = name + "%" + category + "%" + price + "%" + stock;
}
return(res);
}
catch (Exception ex)
{
LastError = ex.Message;
return(null);
}
}
public int[] LoadProdIDs()
{
EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect();
int[] allProdIDs = new int[50]; int i = 0;
SqlDataReader dr = aEShoppingConn.GetReader("select ProdID from Products", CommandType.Text);
while (dr.Read())
{
allProdIDs[i++] = (int)(dr["ProdID"]);
}
return(allProdIDs);
}
public Image LoadImage(int prodID)
{
EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect();
string query = String.Format("select Image from Products where ProdID = {0}", prodID);
Image image = null;
SqlDataReader dr = aEShoppingConn.GetReader(query, CommandType.Text);
while (dr.Read())
{
byte[] arr = (byte[])(dr["image"]);
image = byteArrayToImage(arr);
}
return(image);
}
public string LoadLabel(int prodID)
{
EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect();
string query = String.Format("select * from Products where ProdID = {0}", prodID);
string name = "";
double price = 0;
int stock = 0;
SqlDataReader dr = aEShoppingConn.GetReader(query, CommandType.Text);
while (dr.Read())
{
name = dr.GetString(dr.GetOrdinal("ItemName"));
price = (double)dr.GetDecimal(dr.GetOrdinal("ItemPrice"));
stock = (int)dr.GetInt32(dr.GetOrdinal("Stock"));
}
return(name.Trim() + " $" + price + " " + stock.ToString() + " Available");
}
