public ViewTeacherWithCouse GetTeacherWithCouse(int teacherId) { ViewTeacherWithCouse viewTeacherWithCouse = new ViewTeacherWithCouse(); Query = "SELECT*FROM ViewTeacherWithCouse WHERE TeacherId='" + teacherId + "'"; Command.CommandText = Query; Command.Connection = Connection; Connection.Open(); Reader = Command.ExecuteReader(); if (Reader.HasRows) { while (Reader.Read()) { viewTeacherWithCouse.TeacherId = Int32.Parse(Reader["TeacherId"].ToString()); viewTeacherWithCouse.CreditTaken = float.Parse(Reader["CreditTaken"].ToString()); viewTeacherWithCouse.CreditToTake = float.Parse(Reader["CreditToTake"].ToString()); } Reader.Close(); } Connection.Close(); return(viewTeacherWithCouse); }
public ActionResult GetTeacherWithCouse(int teacherId) { ViewTeacherWithCouse viewTeacherWithCouse = teacherManager.GetTeacherWithCouse(teacherId); return(Json(viewTeacherWithCouse)); }