public IActionResult Breadboard(AddBreadboardModel addBreadboard) { string connString = @"Data Source=DESKTOP-JM077BN;Initial Catalog=ArduinoStore;Integrated Security=True"; try { using (SqlConnection conn = new SqlConnection(connString)) { string query = $"INSERT INTO Product VALUES({addBreadboard.Price}, {addBreadboard.CompanyID}, '{addBreadboard.Model}', 0, '{addBreadboard.ProductImage}'); SELECT SCOPE_IDENTITY()"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); int productID = int.Parse(dr[0].ToString()); dr.Close(); query = $"INSERT INTO Breadboard VALUES({productID}, {addBreadboard.Width}, {addBreadboard.Length}, {addBreadboard.TiePoints}); SELECT SCOPE_IDENTITY()"; cmd = new SqlCommand(query, conn); dr = cmd.ExecuteReader(); if (dr.HasRows) { conn.Close(); return(RedirectToAction("index", "admin")); } } else { conn.Close(); } } } catch (Exception ex) { } return(View()); }
public IActionResult Breadboard() { ViewData["CustomerId"] = HttpContext.Session.Get <int>("_AccountId"); ViewData["AdminId"] = HttpContext.Session.Get <int>("_AdminId"); AddBreadboardModel addBreadboard = new AddBreadboardModel(); addBreadboard.Companies = new List <Company>(); string connString = @"Data Source=DESKTOP-JM077BN;Initial Catalog=ArduinoStore;Integrated Security=True"; try { using (SqlConnection conn = new SqlConnection(connString)) { string query = $"SELECT * FROM Company ORDER BY name"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { int companyID = int.Parse(dr["CompanyID"].ToString()); string name = dr["Name"].ToString(); addBreadboard.Companies.Add(new Company { CompanyID = companyID, Name = name }); } return(View(addBreadboard)); } } } catch (Exception ex) { } return(View()); }