// Информация о конкретном продукте
public ActionResult SomeProductData()
{
string WebName = ViewBag.id = RouteData.Values["id"].ToString();
SomeProductDataModel productdata = new SomeProductDataModel();
return(Json(productdata));
}
public ActionResult SomeProductData()
{
string WebName = RouteData.Values["id"].ToString();
//string WebName = HttpUtility.UrlDecode(RouteData.Values["id"].ToString());
//return Json(new { Encode = HttpUtility.UrlEncode(RouteData.Values["id"].ToString()), Decode = HttpUtility.UrlDecode(RouteData.Values["id"].ToString()), Original = RouteData.Values["id"].ToString() }, JsonRequestBehavior.AllowGet);
SomeProductDataModel product = new SomeProductDataModel();
using (SqlConnection cn = new SqlConnection())
{
cn.ConnectionString = GetConnectionStringByName("MainProductConnection");
try
{
cn.Open();
string strSQL = "Select * From [Product] Where [WebName] = N'" + WebName + "'";
SqlCommand myCommand = new SqlCommand(strSQL, cn);
SqlDataReader dr = myCommand.ExecuteReader();
while (dr.Read())
{
product.Name = dr["Name"].ToString();
product.Description = dr["Description"].ToString();
product.Price = Int32.Parse(dr["Price"].ToString());
product.Count = Int32.Parse(dr["Count"].ToString());
product.PhotoSrc = dr["Photo"].ToString();
product.Specifications = dr["Specif"].ToString();
}
return(Json(product, JsonRequestBehavior.AllowGet));
}
catch (SqlException ex)
{
return(Json(new { Error = true, Message = ex.Message }, JsonRequestBehavior.AllowGet));
}
finally
{
cn.Close();
cn.Dispose();
}
}
}
