protected void Page_Load(object sender, EventArgs e)
{
if (Session["myRecent"] == null)
{
myRecent = new RecentData();
Session["myRecent"] = myRecent;
}
myRecent = (RecentData)Session["myRecent"];
if (myRecent.Items.Count == 0)
{
recent.Style.Add("display", "none");
}
else
{
imageListView.DataSource = myRecent.Items;
imageListView.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("Gallery.aspx");
}
else
{
if (Session["myCart"] == null)
{
myCart = new CartData();
Session["myCart"] = myCart;
}
myCart = (CartData)Session["myCart"];
if (Session["myRecent"] == null)
{
myRecent = new RecentData();
Session["myRecent"] = myRecent;
}
myRecent = (RecentData)Session["myRecent"];
int imageID = Convert.ToInt32(Request.QueryString["id"].ToString());
string sql = "SELECT imageID, imageName, imageDesc, imageType, imagePrice, imageDateUploaded, imageLocation, "
+ "concat(artistFName, ' ', artistLName) as artistName FROM Image, Artist WHERE Image.imageID = @imageID AND Artist.artistID = Image.artistID";
using (SqlConnection con = new SqlConnection(Helper.sqlCon))
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlParameter m = new SqlParameter("@imageID", imageID);
cmd.Parameters.Add(m);
SqlDataReader dr = cmd.ExecuteReader();
int cartQty = 0;
for (int i = 0; i < myCart.Items.Count; i++)
{
if (imageID == myCart.Items[i].imageID)
{
cartQty = myCart.Items[i].qty;
}
}
RangeValidatorQty.MaximumValue = (CheckStock(imageID, Helper.sqlCon) - cartQty).ToString();
if (RangeValidatorQty.MaximumValue == "0")
{
txtQty.Text = "0";
btnCart.Enabled = false;
}
try
{
while (dr.Read())
{
lblID.Text = dr.GetInt32(0).ToString();
lblName.Text = dr.GetString(1);
lblDesc.Text = dr.GetString(2);
lblType.Text = dr.GetString(3);
lblPrice.Text = "RM" + dr.GetSqlMoney(4).ToString();
lblDate.Text = dr.GetDateTime(5).ToShortDateString();
img.Src = "/Images/" + dr.GetString(6) + "?" + DateTime.Now.Ticks.ToString();
lblArtist.Text = dr.GetString(7);
}
}
catch (Exception ex) { }
finally
{
con.Close();
dr.Close();
}
}
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(Helper.sqlCon))
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlParameter m = new SqlParameter("@imageID", imageID);
cmd.Parameters.Add(m);
dt.Load(cmd.ExecuteReader());
con.Close();
}
DataRow row = dt.Rows[0];
myRecent.Insert(new RecentItem(imageID, row["imageName"].ToString(), row["imageLocation"].ToString(), Double.Parse(row["imagePrice"].ToString())));
}
}