public ActionResult CreateBoard(AddBoardModel board)
{
if (!ModelState.IsValid)
{
return(View(board));
}
DateTime current = DateTime.Now;
string userName = User.Identity.Name;
BoardModel newBoard = new BoardModel()
{
LastChanged = current,
Created = current,
Notes = new Collection <NoteModel>(),
Name = board.Name,
Password = board.Password,
IsPrivate = board.IsPrivate
};
//if (newBoard.Password != null)
//{
// newBoard.IsPasswordProtected = true;
//}
//else
//{
// newBoard.IsPasswordProtected = false;
//}
int?newBoardId = HubQueries.AddBoard(newBoard, userName);
return(RedirectToAction("Index", "Board", new { id = newBoardId }));
}
public async Task <IActionResult> AddBoard(AddBoardModel model)
{
string id = _accessor.HttpContext.Session.GetString("id");
await _boardService.AddAsync(new Board
{
Title = model.Title,
AppUserId = Convert.ToInt32(id)
});
return(RedirectToAction("Index", "Board"));
}
public IActionResult Board(AddBoardModel addBoard)
{
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({addBoard.Price}, {addBoard.CompanyID}, '{addBoard.Model}', 0, '{addBoard.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 ArduinoBoard VALUES({productID}, {addBoard.SupplyVoltage}, {addBoard.DigitalPins}, {addBoard.AnalogPins}, {addBoard.FlashMemory}, {addBoard.Frequency}); 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 Board()
{
ViewData["CustomerId"] = HttpContext.Session.Get <int>("_AccountId");
ViewData["AdminId"] = HttpContext.Session.Get <int>("_AdminId");
AddBoardModel addBoard = new AddBoardModel();
addBoard.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();
addBoard.Companies.Add(new Company {
CompanyID = companyID, Name = name
});
}
return(View(addBoard));
}
}
}
catch (Exception ex)
{
}
return(View());
}
