Пример #1
0
        public DataTable CRUDFeess(FeesMaster objFees, string action)
        {
            DataTable dtResult = new DataTable();

            try
            {
                SqlParameter objSqlParameter  = new SqlParameter("FeesId", objFees.FeesId);
                SqlParameter objSqlParameter1 = new SqlParameter("CourseId", objFees.CourseId);
                SqlParameter objSqlParameter2 = new SqlParameter("Description", objFees.Description);
                SqlParameter objSqlParameter3 = new SqlParameter("Offer", objFees.Offer);
                SqlParameter objSqlParameter4 = new SqlParameter("Amount", objFees.Amount);
                SqlParameter objSqlParameter5 = new SqlParameter("SGST", objFees.SGST);
                SqlParameter objSqlParameter6 = new SqlParameter("CGST", objFees.CGST);
                SqlParameter objSqlParameter7 = new SqlParameter("LoggedInUser", objFees.LoggedInUser);
                SqlParameter objSqlParameter8 = new SqlParameter("Action", action);

                List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6, objSqlParameter7, objSqlParameter8 });
                dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDFees", lstSqlParams);
            }
            catch (Exception ex)
            {
                throw;
            }
            return(dtResult);
        }
Пример #2
0
        public DataTable CRUDAddExams(StudentsExams stdExam, string action)
        {
            DataTable dtResult = new DataTable();

            try
            {
                SqlParameter objSqlParameter   = new SqlParameter("StudentExamId", stdExam.ExamTimesId);
                SqlParameter objSqlParameter1  = new SqlParameter("StudentId", stdExam.StudentId);
                SqlParameter objSqlParameter2  = new SqlParameter("Description", stdExam.Description);
                SqlParameter objSqlParameter3  = new SqlParameter("CourseId", stdExam.CourseId);
                SqlParameter objSqlParameter4  = new SqlParameter("ExamTime", stdExam.ExamTimesId);
                SqlParameter objSqlParameter5  = new SqlParameter("ExamDate", stdExam.ExamDate);
                SqlParameter objSqlParameter6  = new SqlParameter("Fees", stdExam.Fees);
                SqlParameter objSqlParameter7  = new SqlParameter("IsExpired", stdExam.IsExpired);
                SqlParameter objSqlParameter8  = new SqlParameter("ExamResult", stdExam.ExamResult);
                SqlParameter objSqlParameter9  = new SqlParameter("IsAppeared", stdExam.IsAppeared);
                SqlParameter objSqlParameter10 = new SqlParameter("LoggedInUser", stdExam.LoggedInUser);
                SqlParameter objSqlParameter11 = new SqlParameter("Action", action);

                List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6, objSqlParameter7, objSqlParameter8, objSqlParameter9, objSqlParameter10, objSqlParameter11 });
                dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDExams", lstSqlParams);
            }
            catch (Exception ex)
            {
            }
            return(dtResult);
        }
Пример #3
0
        public DataTable CRUDUsers(User objUser, string action)
        {
            DataTable dtResult = new DataTable();

            try
            {
                SqlParameter objSqlParameter  = new SqlParameter("UserId", objUser.UserId);
                SqlParameter objSqlParameter1 = new SqlParameter("UserPassword", objUser.UserPassword);
                SqlParameter objSqlParameter2 = new SqlParameter("FirstName", objUser.FirstName);
                SqlParameter objSqlParameter3 = new SqlParameter("LastName", objUser.LastName);
                SqlParameter objSqlParameter4 = new SqlParameter("MobileNo", objUser.MobileNo);
                SqlParameter objSqlParameter5 = new SqlParameter("EmailId", objUser.EmailId);
                SqlParameter objSqlParameter6 = new SqlParameter("UserTypeId", objUser.UserTypeId);
                SqlParameter objSqlParameter7 = new SqlParameter("IsActive", objUser.IsActive);
                SqlParameter objSqlParameter8 = new SqlParameter("LoggedInUser", objUser.LoggedInUser);
                SqlParameter objSqlParameter9 = new SqlParameter("Action", action);

                List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6, objSqlParameter7, objSqlParameter8, objSqlParameter9 });
                dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDUsers", lstSqlParams);
            }
            catch (Exception ex)
            {
                throw;
            }
            return(dtResult);
        }
Пример #4
0
        public DataSet ExamPapers(int examId, long studentId)
        {
            DataSet ds = new DataSet();

            try
            {
                SqlParameter        objSqlParameter  = new SqlParameter("StudentId", studentId);
                SqlParameter        objSqlParameter1 = new SqlParameter("ExamId", examId);
                List <SqlParameter> lstSqlParams     = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1 });
                ds = DBCommon.ExecuteDataAdapterDataDataset("uspSelectQuestionPaper", lstSqlParams);
            }
            catch (Exception ex)
            {
            }
            return(ds);
        }
Пример #5
0
        public DataTable GetUserList(User objUser)
        {
            DataTable dtResult = new DataTable();

            try
            {
                SqlParameter objSqlParameter  = new SqlParameter("UserId", objUser.UserId);
                SqlParameter objSqlParameter1 = new SqlParameter("Username", objUser.LoggedInUser);
                SqlParameter objSqlParameter2 = new SqlParameter("UserTypeId", objUser.UserTypeId);

                List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2 });
                dtResult = DBCommon.ExecuteDataAdapterDataTable("uspUserList", lstSqlParams);
            }
            catch (Exception ex)
            {
            }
            return(dtResult);
        }
Пример #6
0
        public DataTable SignIn(string loginId, string password)
        {
            DataTable dtUser = new DataTable();

            try
            {
                SqlParameter objSqlParameter  = new SqlParameter("LoginId", loginId);
                SqlParameter objSqlParameter1 = new SqlParameter("UserPassword", password);

                List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1 });
                dtUser = DBCommon.ExecuteDataAdapterDataTable("UserLogin", lstSqlParams);
            }
            catch (Exception ex)
            {
                throw;
            }
            return(dtUser);
        }
Пример #7
0
        public DataTable CRUDExamTimes(ExamTimes ansType, string action)
        {
            DataTable dtResult = new DataTable();

            try
            {
                SqlParameter objSqlParameter  = new SqlParameter("ExamTimesId", ansType.ExamTimesId);
                SqlParameter objSqlParameter1 = new SqlParameter("ExamTime", ansType.ExamTime);
                SqlParameter objSqlParameter2 = new SqlParameter("Description", ansType.Description);
                SqlParameter objSqlParameter3 = new SqlParameter("LoggedInUser", ansType.LoggedInUser);
                SqlParameter objSqlParameter4 = new SqlParameter("Action", action);

                List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4 });
                dtResult = DBCommon.ExecuteDataAdapterDataTable("uspCrudExamTimes", lstSqlParams);
            }
            catch (Exception ex)
            {
                throw;
            }
            return(dtResult);
        }
Пример #8
0
        public DataTable CRUDAnswers(AnswerMaster ansType, string action)
        {
            DataTable dtResult = new DataTable();

            try
            {
                SqlParameter objSqlParameter  = new SqlParameter("AnswerId", ansType.AnswerId);
                SqlParameter objSqlParameter1 = new SqlParameter("Answer", ansType.Answer);
                SqlParameter objSqlParameter2 = new SqlParameter("QuestionId", ansType.QuestionId);
                SqlParameter objSqlParameter3 = new SqlParameter("IsRight", ansType.IsRight);
                SqlParameter objSqlParameter4 = new SqlParameter("LoggedInUser", ansType.LoggedInUser);
                SqlParameter objSqlParameter5 = new SqlParameter("Action", action);

                List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5 });
                dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDAnswers", lstSqlParams);
            }
            catch (Exception ex)
            {
                throw;
            }
            return(dtResult);
        }
Пример #9
0
        public DataTable CRUDCourses(CourseMaster objCourse, string action)
        {
            DataTable dtResult = new DataTable();

            try
            {
                SqlParameter objSqlParameter  = new SqlParameter("CourseId", objCourse.CourseId);
                SqlParameter objSqlParameter1 = new SqlParameter("CourseName", objCourse.CourseName);
                SqlParameter objSqlParameter2 = new SqlParameter("Description", objCourse.Description);
                SqlParameter objSqlParameter3 = new SqlParameter("Eligibility", objCourse.Eligibility);
                SqlParameter objSqlParameter4 = new SqlParameter("LoggedInUser", objCourse.LoggedInUser);
                SqlParameter objSqlParameter5 = new SqlParameter("Action", action);

                List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5 });
                dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDCourses", lstSqlParams);
            }
            catch (Exception ex)
            {
                throw;
            }
            return(dtResult);
        }
Пример #10
0
        public DataTable SaveExamPapers(List <QuestionMaster> questionMaster)
        {
            DataTable ds = new DataTable();

            try
            {
                foreach (QuestionMaster question in questionMaster)
                {
                    SqlParameter        objSqlParameter  = new SqlParameter("StudentId", question.StudentId);
                    SqlParameter        objSqlParameter1 = new SqlParameter("QuestionAnswerId", question.QuestionAnswerId);
                    SqlParameter        objSqlParameter2 = new SqlParameter("QuestionId", question.QuestionId);
                    SqlParameter        objSqlParameter3 = new SqlParameter("CourseId", question.CourseId);
                    SqlParameter        objSqlParameter4 = new SqlParameter("AnswerId", question.AnswerId);
                    SqlParameter        objSqlParameter5 = new SqlParameter("StudentExamId", question.StudentExamId);
                    SqlParameter        objSqlParameter6 = new SqlParameter("LoggedInUser", question.LoggedInUser);
                    List <SqlParameter> lstSqlParams     = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6 });
                    ds = DBCommon.ExecuteDataAdapterDataTable("uspAddQuestionAnswer", lstSqlParams);
                }
            }
            catch (Exception ex)
            {
            }
            return(ds);
        }
Пример #11
0
        public DataTable CRUDFeess(StudentDetails objFees, string action)
        {
            DataTable dtResult = new DataTable();

            try
            {
                SqlParameter objSqlParameter  = new SqlParameter("StudentId", objFees.StudentId);
                SqlParameter objSqlParameter1 = new SqlParameter("StudentUniqueId", objFees.StudentUniqueId);
                SqlParameter objSqlParameter2 = new SqlParameter("FirstName", objFees.FirstName);
                SqlParameter objSqlParameter3 = new SqlParameter("LastName", objFees.LastName);
                SqlParameter objSqlParameter4 = new SqlParameter("MobileNo", objFees.MobileNo);
                SqlParameter objSqlParameter5 = new SqlParameter("EmailId", objFees.EmailId);
                SqlParameter objSqlParameter6 = new SqlParameter("LoggedInUser", objFees.LoggedInUser);
                SqlParameter objSqlParameter7 = new SqlParameter("Action", action);

                List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6, objSqlParameter7 });
                dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDStudentDetails", lstSqlParams);
            }
            catch (Exception ex)
            {
                throw;
            }
            return(dtResult);
        }