public async Task <IActionResult> TextOnly(DashItemText newItem) { if (!ModelState.IsValid) { return(View(newItem)); } DbAccessor accessor = new DbAccessor(); if (newItem.DashboardItemID == 0) // creating new item { accessor.InsertDashItem(newItem); } else // editing pre-existing item { accessor.UpdateDashItem((DashboardItem)newItem); } return(Redirect("/AdminTools/DashManager")); }
public async Task <IActionResult> TextOnly(string DashboardId) { string id = TempData["EditID"]?.ToString(); // only non null when we are editing if (DashboardId == null & id == null) // error { return(Redirect("/AdminTools/DashManager")); } if (id == null) // we are creating { int Id = Int32.Parse(DashboardId); // todo use tryparse to check if we can actually return(View(new DashItemText { DashboardID = Id })); } // we are editing DbAccessor accessor = new DbAccessor(); DashItemText ItemToEdit = (DashItemText)accessor.GetDashItem(id); // get item to fill model with return(View(ItemToEdit)); }
public void InsertDashItem(DashItemText newItem) { try { SqlCommand cmd = new SqlCommand("dbo.InsertDashItemText", _conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DashboardID", SqlDbType.Int).Value = newItem.DashboardID; cmd.Parameters.Add("@Title", SqlDbType.VarChar).Value = newItem.Title; cmd.Parameters.Add("@StartDateTime", SqlDbType.DateTime).Value = newItem.StartDateTime; cmd.Parameters.Add("@EndDateTime", SqlDbType.DateTime).Value = newItem.EndDateTime; cmd.Parameters.Add("@SortOrder", SqlDbType.Int).Value = newItem.SortOrder; cmd.Parameters.Add("@DisplayText", SqlDbType.VarChar).Value = newItem.DisplayText; _conn.Open(); cmd.ExecuteNonQuery(); _conn.Close(); } catch (Exception e) { Console.WriteLine(e.Data); } }