// Add Software Used
public ActionResult SoftwareUsedAdd(FormCollection software)
{
//retrieve the Id passed from the update page (Method = "GET")
int syllabusIDFK = Convert.ToInt32(Request.QueryString["syllabusId"]);
string softUsed = software["software"].ToString();
//connect to db
Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4();
//retrieve specific table data based from the detail Id (firstName, lastName, etc.)
Software_Used s = new Software_Used();
//assigning the table data through the input
s.syllabus_FK = syllabusIDFK;
s.software = softUsed.Replace(System.Environment.NewLine, "<br />");
try
{
//add data to db
syllabus.Software_Used.Add(s);
//save data to db
syllabus.SaveChanges();
ViewBag.Result = "Saved";
}
catch (Exception e)
{
ViewBag.Result = "Not Saved" + e.Message;
}
syllabus.SaveChanges();
return(RedirectToAction("SoftwareUsed", "SoftwareUsed"));
}
// Add/Edit Software Used
public ActionResult SoftwareUsed()
{
//connect to db
Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4();
//retrieve table details (firstName, lastName, etc.)
Software_Used d = new Software_Used();
//from the table friends, select all in descending order by age
var detailS = (from u in syllabus.Software_Used
select u).FirstOrDefault();
//converting all the retrieved data (friends) into a list object
ViewData["SoftwareUsed"] = detailS;
return(View());
}
