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