public ActionResult InsertId(Results_Information_viewmodel model, string classname)
{
if (classname == "5")
{
MvcDatabase1Entities2 rd5 = new MvcDatabase1Entities2();
ResultDatabaseClass5 stdresult = new ResultDatabaseClass5();
stdresult.StudentId = model.StudentId;
stdresult.Term = model.Term;
rd5.ResultDatabaseClass5.Add(stdresult);
try
{
rd5.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
// ViewData.sid = new List<int>();
return(RedirectToAction("Insertresultdb", model));
}
else if (classname == "6")
{
MvcDatabase1Entities3 rd6 = new MvcDatabase1Entities3();
ResultDatabaseClass6 std6 = new ResultDatabaseClass6();
std6.StudentId = model.StudentId;
std6.Term = model.Term;
rd6.ResultDatabaseClass6.Add(std6);
rd6.SaveChanges();
//stdresult.StudentId = model.StudentId;
//stdresult.Term = model.Term;
//rd5.ResultDatabaseClass5.Add(stdresult);
//try
//{
// rd5.SaveChanges();
//}
//catch (Exception ex)
//{
// throw ex;
//}
//// ViewData.sid = new List<int>();
return(RedirectToAction("Insertresultdb6", "ResultsDb6", model));
}
else
{
return(View());
}
}
public ActionResult Calculateresultdb6(Results_Information_viewmodel6 model)
{
double t;
t = total / 9;
MvcDatabase1Entities3 rd6 = new MvcDatabase1Entities3();
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename= C:\Users\HP\Documents\Visual Studio 2013\Projects\MvcApplication1\MvcApplication1\App_Data\MvcDatabase1.mdf;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand(" UPDATE ResultDatabaseClass6 set Gpa = '" + t + "' where (StudentId = '" + s + "')", con);
cmd.ExecuteNonQuery();
con.Close();
return(RedirectToAction("Insertresultdb6"));
}
