public ActionResult AddTeacher(TeacherTb t)
{
ViewData["t_Cid"] = new SelectList(db.ClassTbs, "c_id", "Class_Name");
db.Database.ExecuteSqlCommand("sp_CreateTeacher @fname,@lname,@dob,@address,@phone,@cid,@id",
new object[] {
new SqlParameter("@fname", t.T_Fname),
new SqlParameter("@lname", t.T_Lname),
new SqlParameter("@dob", t.T_DOB),
new SqlParameter("@address", t.T_Address),
new SqlParameter("@phone", t.T_Phone),
new SqlParameter("@cid", t.t_Cid),
new SqlParameter("@id", t.t_id),
});
return(RedirectToAction("Index"));
}
public ActionResult UpdateTeacher(int id, TeacherTb t)
{
// SqlParameter[] par = new SqlParameter[7];
db.Database.ExecuteSqlCommand("sp_UpdateTeacherById @fname,@lname,@dob,@address,@phone,@cid,@id",
new object[] {
new SqlParameter("@fname", t.T_Fname),
new SqlParameter("@lname", t.T_Lname),
new SqlParameter("@dob", t.T_DOB),
new SqlParameter("@address", t.T_Address),
new SqlParameter("@phone", t.T_Phone),
new SqlParameter("@cid", t.t_Cid),
new SqlParameter("@id", t.t_id),
});
return(RedirectToAction("Index"));
}
