Пример #1
0
        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));
        }