public static ViewModel.CheckoutProductViewModel getCheckoutProd(int id) { string conString = WebConfigurationManager.ConnectionStrings["FrozenCrittersDb"].ConnectionString; SqlConnection con = new SqlConnection(conString); SqlCommand getProd = new SqlCommand(); getProd.Connection = con; getProd.CommandText = "SELECT ProductsId, ProductsName, ProductsQuantity FROM Products WHERE ProductsId = " + id; con.Open(); SqlDataReader reader = getProd.ExecuteReader(); ViewModel.CheckoutProductViewModel prod = new ViewModel.CheckoutProductViewModel(); while (reader.Read()) { prod.ProductsId = (int)reader["ProductsId"]; prod.ProductsName = reader["ProductsName"].ToString(); prod.ProductsQuantity = (int)reader["ProductsQuantity"]; } con.Close(); return(prod); }
public ActionResult PostAddToCartPage(int id) { ViewModel.CheckoutProductViewModel prod = Models.FrozenCrittersDb.getCheckoutProd(id); return(View(prod)); }