protected void Page_Load(object sender, EventArgs e)
{
if (Session["myCart"] == null)
{
Session["myCart"] = new CartData();
}
myCart = (CartData)Session["myCart"];
if (!IsPostBack)
{
myCart = (CartData)Session["myCart"];
FillData();
}
}
protected void btnCart_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(txtQty.Text) == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('Quantity cannot be 0');", true);
}
else
{
if (Session["myCart"] == null)
{
myCart = new CartData();
Session["myCart"] = myCart;
}
myCart = (CartData)Session["myCart"];
string sql = "SELECT * FROM Image, Artist WHERE Image.imageID = @imageID AND Artist.artistID = Image.artistID";
int imageID = Convert.ToInt32(Request.QueryString["id"].ToString());
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);
try
{
cmd.Parameters.Add(m);
dt.Load(cmd.ExecuteReader());
}
catch (Exception ex) { }
finally { con.Close(); }
}
DataRow row = dt.Rows[0];
myCart.Insert(new CartItem(imageID, row["imageName"].ToString(), row["imageLocation"].ToString(), verifyQty(), Double.Parse(row["imagePrice"].ToString())));
Response.Redirect("Cart.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["myCart"] == null)
{
Session["myCart"] = new CartData();
}
myCart = (CartData)Session["myCart"];
qty.Text = myCart.Items.Count.ToString();
if (myCart.Items.Count > 0)
{
CartData.Style.Remove("display");
cartRepeater.DataSource = myCart.Items;
cartRepeater.DataBind();
lblTotalCart.Text = String.Format(Helper.my, "{0:C}", myCart.GrandTotal);
}
else
{
NoCart.Style.Remove("display");
}
}
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())));
}
}
