public IActionResult Wireset(AddWireSetModel addWireset)
{
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({addWireset.Price}, {addWireset.CompanyID}, '{addWireset.Model}', 0, '{addWireset.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 Wireset VALUES({productID}, {addWireset.Length}, {addWireset.WiresNo}); 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 Wireset()
{
ViewData["CustomerId"] = HttpContext.Session.Get <int>("_AccountId");
ViewData["AdminId"] = HttpContext.Session.Get <int>("_AdminId");
AddWireSetModel addWireSet = new AddWireSetModel();
addWireSet.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();
addWireSet.Companies.Add(new Company {
CompanyID = companyID, Name = name
});
}
return(View(addWireSet));
}
}
}
catch (Exception ex)
{
}
return(View());
}
