public IActionResult CurriculaDetailEdit(CurriculaLineItemViewModel clivm)
{
IActionResult result = null;
// Are there errors
if (!ModelState.IsValid)
{
result = View("CurriculaDetailEdit");
}
else
{
try
{
CurriculaLineItem cli = new CurriculaLineItem()
{
CurriculaId = clivm.CurriculaId,
CurriculaTypeId = clivm.CurriculaTypeId,
Description = clivm.Description,
FileName = clivm.FileName,
Id = clivm.Id,
};
_currDAL.UpdateCurriculaLineItem(cli);
result = RedirectToAction("CurriculaDetail", "Course", "");
}
catch (Exception ex)
{
result = View();
}
}
return(result);
}
public CurriculaLineItem GetCurriculaLineItem(int curriculaLineItemId)
{
CurriculaLineItem curr = new CurriculaLineItem();
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL = "SELECT c.id, c.CurriculaId, c.CurriculaId, c.Description, c.LineItem, URL, FileName, ct.Name TypeName, ct.id CurriculaTypeId ";
SQL += "FROM curriculaLineItem c ";
SQL += "INNER JOIN CurriculaType ct on ct.id = c.CurriculaTypeId ";
SQL += "WHERE c.id = @id ";
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@id", curriculaLineItemId);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
curr.Id = Convert.ToInt32(reader["Id"]);
curr.CurriculaId = Convert.ToInt32(reader["CurriculaId"]);
curr.CurriculaTypeId = Convert.ToInt32(reader["CurriculaTypeId"]);
curr.TypeName = Convert.ToString(reader["TypeName"]);
curr.FileName = Convert.ToString(reader["FileName"]);
curr.Description = Convert.ToString(reader["Description"]);
curr.LineItem = Convert.ToInt32(reader["LineItem"]);
curr.URL = Convert.ToString(reader["URL"]);
}
}
return(curr);
}
public IActionResult CurriculaDetailEdit(int lineItemId)
{
CurriculaLineItem cli = _currDAL.GetCurriculaLineItem(lineItemId);
CurriculaLineItemViewModel clivm = new CurriculaLineItemViewModel();
clivm.CurriculaId = cli.CurriculaId;
clivm.CurriculaTypeId = cli.CurriculaTypeId;
clivm.Description = cli.Description;
clivm.FileName = cli.FileName;
clivm.Id = cli.Id;
return(View(clivm));
}
public void UpdateCurriculaLineItem(CurriculaLineItem cli)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL = "UPDATE course Set Description = @description, ";
SQL += "LineItem = @LineItem , URL = @URL, FileName = @FileName ";
SQL += "WHERE id = @id ";
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@description", cli.Description);
cmd.Parameters.AddWithValue("@LineItem", cli.LineItem);
cmd.Parameters.AddWithValue("@URL", cli.URL);
cmd.Parameters.AddWithValue("@FileName", cli.FileName);
if (cmd.ExecuteNonQuery() == 0)
{
throw new Exception("Failed to update course.");
}
}
}
public void SaveCurriculaLineItem(CurriculaLineItem newCLI)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL = "INSERT INTO CurriculaLineItems(CurriculaId, CurriculaTypeId, Description, LineItem, URL, FileName) ";
SQL += "VALUES (@CurriculaId, @CurriculaTypeId, @Description, @LineItem, @URL, @FileName);";
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@CurriculaId", newCLI.CurriculaId);
cmd.Parameters.AddWithValue("@CurriculaTypeId", newCLI.CurriculaTypeId);
cmd.Parameters.AddWithValue("@Description", newCLI.Description);
cmd.Parameters.AddWithValue("@LineItem", newCLI.LineItem);
cmd.Parameters.AddWithValue("@URL", newCLI.URL);
cmd.Parameters.AddWithValue("@FileName", newCLI.FileName);
if (cmd.ExecuteNonQuery() == 0)
{
throw new Exception("Failed to insert course.");
}
}
}
