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