string GetBasketQtyByProductId(int ProductId) { LinqToSqlDataContext db = new LinqToSqlDataContext(); string Qty = ""; var ordr = db.USP_GetBasketQtyByProductId(Convert.ToInt32(Session[enumSessions.OrderId.ToString()]), ProductId, Convert.ToInt32(Request.QueryString["CategoryId"])).SingleOrDefault(); if (ordr != null) { Qty = ordr.ProductQty.ToString(); } db.Dispose(); return(Qty); }