示例#1
0
        public List <SelfStudyRegistration> StudentEnrollinParticularCourse(int courseId, string batch)
        {
            Query = "SELECT * FROM SelfStudyRegistration,StudentInformation WHERE courseid='" + courseId + "' AND SelfStudyBatch='" + batch +
                    "' AND SelfStudyRegistration.StudentId=StudentInformation.StudentId";

            Command = new SqlCommand(Query, Connection);

            Connection.Open();

            Reader = Command.ExecuteReader();

            List <SelfStudyRegistration> aSelfStudyRegistrations = new List <SelfStudyRegistration>();

            while (Reader.Read())
            {
                SelfStudyRegistration aSelfStudyRegistration = new SelfStudyRegistration();


                aSelfStudyRegistration.StudentId   = Reader["StudentId"].ToString();
                aSelfStudyRegistration.StudentName = Reader["StudentName"].ToString();

                aSelfStudyRegistrations.Add(aSelfStudyRegistration);
            }

            Reader.Close();
            Connection.Close();

            return(aSelfStudyRegistrations);
        }
示例#2
0
        public List <SelfStudyRegistration> ShowSelfStudyRegistrationbyStudentId(string studentId)
        {
            Query = "SELECT * FROM SelfStudyRegistration,Course WHERE SelfStudyRegistration.StudentId='" + studentId + "' AND Course.CourseId=SelfStudyRegistration.courseid";

            Command = new SqlCommand(Query, Connection);

            Connection.Open();

            Reader = Command.ExecuteReader();

            List <SelfStudyRegistration> selfStudyInformation = new List <SelfStudyRegistration>();

            while (Reader.Read())
            {
                SelfStudyRegistration aselfStudyStudentInformation = new SelfStudyRegistration();

                aselfStudyStudentInformation.SelfStudyId    = (int)Reader["SelfStudyId"];
                aselfStudyStudentInformation.StudentId      = Reader["StudentId"].ToString();
                aselfStudyStudentInformation.CourseId       = (int)Reader["courseid"];
                aselfStudyStudentInformation.SelfStudyBatch = Reader["SelfStudyBatch"].ToString();
                aselfStudyStudentInformation.CourseCode     = Reader["CourseCode"].ToString();
                aselfStudyStudentInformation.CourseName     = Reader["CourseName"].ToString();
                aselfStudyStudentInformation.CourseCredit   = Convert.ToDouble(Reader["CourseCredit"]);

                selfStudyInformation.Add(aselfStudyStudentInformation);
            }

            Reader.Close();
            Connection.Close();

            return(selfStudyInformation);
        }
示例#3
0
        public int SelfStudyCourseSave(SelfStudyRegistration aSelfStudyRegistration)
        {
            Query = "INSERT INTO SelfStudyRegistration VALUES (@sid,@cid, @batch)";

            Command = new SqlCommand(Query, Connection);

            Command.Parameters.Clear();

            Command.Parameters.Add("sid", SqlDbType.VarChar);
            Command.Parameters["sid"].Value = aSelfStudyRegistration.StudentId;

            Command.Parameters.Add("cid", SqlDbType.Int);
            Command.Parameters["cid"].Value = aSelfStudyRegistration.CourseId;

            Command.Parameters.Add("batch", SqlDbType.VarChar);
            Command.Parameters["batch"].Value = aSelfStudyRegistration.SelfStudyBatch;



            Connection.Open();

            int rowAffected = Command.ExecuteNonQuery();

            Connection.Close();

            return(rowAffected);
        }
示例#4
0
        public bool IsStudentExists(SelfStudyRegistration aSelfStudyRegistration)
        {
            Query = "SELECT * FROM EnrollCourse WHERE EnrollCourse.StudentId='" + aSelfStudyRegistration.StudentId +
                    "' AND EnrollCourse.courseid='" + aSelfStudyRegistration.CourseId + "'";


            Command = new SqlCommand(Query, Connection);

            Connection.Open();

            Reader = Command.ExecuteReader();

            bool isExist = Reader.HasRows;

            Reader.Close();
            Connection.Close();

            return(isExist);
        }
示例#5
0
        public string SelfStudyCourseSave(SelfStudyRegistration aSelfStudyRegistration)
        {
            bool isExist = aSelfStudyGateway.IsStudentExists(aSelfStudyRegistration);

            if (isExist)
            {
                int rowAffected = aSelfStudyGateway.SelfStudyCourseSave(aSelfStudyRegistration);

                if (rowAffected > 0)
                {
                    return("You have Successfully Registered with the Course");
                }
                else
                {
                    return("Sorry Your Registration have failed");
                }
            }


            else
            {
                return("Sorry Your Registration have failed.You may not be Enrolled this Course Before.So Enroll New Registration.");
            }
        }
 public ActionResult SelfStudyRegistration(SelfStudyRegistration aSelfStudyRegistration)
 {
     ViewBag.message   = aSelfStudyManager.SelfStudyCourseSave(aSelfStudyRegistration);
     ViewBag.getCourse = aCourseManager.GetAllCourses().ToList();
     return(View());
 }