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));
}
