public ActionResult Products()
{
List <ProductsClass> ProductData = new List <ProductsClass>();
string MainConn = ConfigurationManager.ConnectionStrings["PracticeDemo"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(MainConn);
string SQLquery = "select * from [dbo].[Products]";
SqlCommand sqlCom = new SqlCommand(SQLquery, sqlConnection);
sqlConnection.Open();
SqlDataReader rdr = sqlCom.ExecuteReader();
while (rdr.Read())
{
ProductsClass PrCl = new ProductsClass();
PrCl.ProductName = rdr["ProductName"].ToString();
PrCl.Size = rdr["Size"].ToString();
PrCl.ProductID = (int)rdr["ProductID"];
PrCl.Price = (int)rdr["Price"];
PrCl.StockRemaining = (int)rdr["StockRemaining"];
PrCl.ProductType = rdr["ProductType"].ToString();
Random r = new Random();
int random = r.Next(500);
PrCl.randoom = random;
ProductData.Add(PrCl);
}
return(View(ProductData));
}
public ActionResult Edit(ProductsClass model)
{
if (ModelState.IsValid)
{
return(RedirectToAction("Success"));
}
return(View("Index", model));
}
