示例#1
0
        public Outputclass Update_Course(Coursereg coureg)
        {
            Outputclass outputclass = new Outputclass();

            try
            {
                SqlCommand cmd = new SqlCommand("UPDATECOURSE", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@CName", coureg.COURSENAME);
                cmd.Parameters.AddWithValue("@CNOOFD", coureg.COURSEPERID);
                cmd.Parameters.AddWithValue("@CSTDT", coureg.COURSEFROMDATE);
                cmd.Parameters.AddWithValue("@CEDT", coureg.COURSETODATE);
                cmd.Parameters.AddWithValue("@CDES", coureg.Description);
                cmd.Parameters.AddWithValue("@CAMT", coureg.COURSEAMOUNT);
                cmd.Parameters.AddWithValue("@CTRAINERNAME", coureg.TRAINERNAME);
                cmd.Parameters.AddWithValue("@STATUS", coureg.STATUS);
                cmd.Parameters.AddWithValue("@CIMPORTANCE", coureg.COURSEIMPORTANCE);
                Connection();
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    outputclass.Count = i;
                }
                return(outputclass);
            }
            catch (Exception ex)
            {
                outputclass.Msg = ex.ToString();
                return(outputclass);
            }
            finally
            {
                conn.Close();
            }
        }
示例#2
0
        public Outputclass Update_qns(Coursereg coureg)
        {
            Outputclass outputclass = new Outputclass();

            try
            {
                SqlCommand cmd = new SqlCommand("UPDATE_QNS", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@CID", coureg.Courseid);
                cmd.Parameters.AddWithValue("@NOOFQNS", coureg.NUMBEROSQUETIONS);
                Connection();
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    outputclass.Count = i;
                }
                return(outputclass);
            }
            catch (Exception ex)
            {
                outputclass.Msg = ex.ToString();
                return(outputclass);
            }
            finally
            {
                conn.Close();
            }
        }
示例#3
0
        public Outputclass AUDITTRAILS(Audittrails adt)
        {
            Outputclass outputclass = new Outputclass();

            try
            {
                SqlCommand cmd = new SqlCommand("Insert_AUDITTRAILS", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@USERID", adt.USERID);
                cmd.Parameters.AddWithValue("@USERNAME", adt.USERNAME);
                cmd.Parameters.AddWithValue("@ACTIONOFATTEMPT", adt.ACTIONOFATTEMPT);
                cmd.Parameters.AddWithValue("@TYPEOFATTEMPT", adt.TYPEOFATTEMPT);
                cmd.Parameters.AddWithValue("@DESCRIPTION", adt.DESCRIPTION);
                cmd.Parameters.AddWithValue("@FRONTENDDATE", adt.FRONTENDDATE);
                cmd.Parameters.AddWithValue("@BACKENDDATE", adt.BACKENDDATE);
                Connection();
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    outputclass.Count = i;
                }
                return(outputclass);
            }
            catch (Exception ex)
            {
                outputclass.Msg = ex.ToString();
                return(outputclass);
            }
            finally
            {
                conn.Close();
            }
        }
示例#4
0
        public Outputclass COURSE_APPROVE(string userid, string courseid, string text)
        {
            Outputclass opcls = new Outputclass();

            try
            {
                SqlCommand cmd = new SqlCommand("COURSE_APPROVE", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@USERID", userid);
                cmd.Parameters.AddWithValue("@COURSEID", courseid);
                cmd.Parameters.AddWithValue("@BTNTEXT", text);
                DataTable dt = new DataTable();
                Connection();
                opcls.Count = cmd.ExecuteNonQuery();

                return(opcls);
            }
            catch (Exception ex)
            {
                return(null);
            }
            finally
            {
                conn.Close();
            }
        }
示例#5
0
        public Outputclass Insert_transid(Usercourseassign usercouass)
        {
            Outputclass outputclass = new Outputclass();

            try
            {
                SqlCommand cmd = new SqlCommand("INSERT_TRANSACTIONID", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@COURSEID", usercouass.COURSEID);
                cmd.Parameters.AddWithValue("@USERID", usercouass.USERID);
                cmd.Parameters.AddWithValue("@DATEOFAPPROVE", usercouass.DATEOFAPPROVE);
                cmd.Parameters.AddWithValue("@EXAMSTATUS", usercouass.EXAMSTATUSASSIGN);
                cmd.Parameters.AddWithValue("@TRANSACTIONID", usercouass.TRANSACTIONID);
                Connection();
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    outputclass.Count = i;
                }
                return(outputclass);
            }
            catch (Exception ex)
            {
                outputclass.Msg = ex.ToString();
                return(outputclass);
            }
            finally
            {
                conn.Close();
            }
        }
示例#6
0
        public Outputclass Insert_Examrequest(string COURSEID, string USERID)
        {
            Outputclass outputclass = new Outputclass();

            try
            {
                SqlCommand cmd = new SqlCommand("EXAM_REQUEST", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@COURSEID", COURSEID);
                cmd.Parameters.AddWithValue("@USERID", USERID);
                Connection();
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    outputclass.Count = i;
                }
                return(outputclass);
            }
            catch (Exception ex)
            {
                outputclass.Msg = ex.ToString();
                return(outputclass);
            }
            finally
            {
                conn.Close();
            }
        }
示例#7
0
        public Outputclass Create_Exam(Examtable exam)
        {
            Outputclass outputclass = new Outputclass();

            try
            {
                SqlCommand cmd = new SqlCommand("INSERT_EXAMDATA", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@USERID", exam.USERID);
                cmd.Parameters.AddWithValue("@COURSEID", exam.COURSEID);
                cmd.Parameters.AddWithValue("@EXAMCODE", exam.EXAMCODE);
                cmd.Parameters.AddWithValue("@ATTPT", exam.ATTEMPT);
                cmd.Parameters.AddWithValue("@QNID", exam.QUESTIONID);
                cmd.Parameters.AddWithValue("@QUESTION", exam.QUESTION);
                cmd.Parameters.AddWithValue("@UANS", exam.USERANSWER);
                cmd.Parameters.AddWithValue("@MARKS", exam.MARKS);
                Connection();
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    outputclass.Count = i;
                }
                return(outputclass);
            }
            catch (Exception ex)
            {
                outputclass.Msg = ex.ToString();
                return(outputclass);
            }
            finally
            {
                conn.Close();
            }
        }
示例#8
0
        public Outputclass Update_QUESTIONs(Questioneries qns)
        {
            Outputclass outputclass = new Outputclass();

            try
            {
                SqlCommand cmd = new SqlCommand("UPDATE_QUESIONARIES", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@QID", qns.QUESTIONID);
                cmd.Parameters.AddWithValue("@QUESTION", qns.QUESTION);
                cmd.Parameters.AddWithValue("@MARKS", qns.MMarks);
                cmd.Parameters.AddWithValue("@A", qns.OP1);
                cmd.Parameters.AddWithValue("@B", qns.OP2);
                cmd.Parameters.AddWithValue("@C", qns.OP3);
                cmd.Parameters.AddWithValue("@D", qns.OP4);
                cmd.Parameters.AddWithValue("@ANSWER", qns.ANSWER);
                Connection();
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    outputclass.Count = i;
                }
                return(outputclass);
            }
            catch (Exception ex)
            {
                outputclass.Msg = ex.ToString();
                return(outputclass);
            }
            finally
            {
                conn.Close();
            }
        }
示例#9
0
        public Outputclass Create_Course(Coursereg coureg)
        {
            Outputclass outputclass = new Outputclass();

            try
            {
                SqlCommand cmd = new SqlCommand("Insert_COURSEREGISTRATION", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@COURSENAME", coureg.COURSENAME);
                cmd.Parameters.AddWithValue("@COURSEPERIOD", coureg.COURSEPERID);
                cmd.Parameters.AddWithValue("@COURSEFROMDATE", coureg.COURSEFROMDATE);
                cmd.Parameters.AddWithValue("@COURSETODATE", coureg.COURSETODATE);
                //cmd.Parameters.AddWithValue("@NUMBEROSQUETIONS", coureg.NUMBEROSQUETIONS);
                cmd.Parameters.AddWithValue("@NUMBEROFDAYS", coureg.NUMBEROFDAYS);
                cmd.Parameters.AddWithValue("@TOTALMARKS", coureg.TOTALMARKS);
                cmd.Parameters.AddWithValue("@STATUS", "ACTIVE");
                cmd.Parameters.AddWithValue("@DESCRIPTION", coureg.Description);
                cmd.Parameters.AddWithValue("@COURSEAMOUNT", coureg.COURSEAMOUNT);
                cmd.Parameters.AddWithValue("@TRAINER", coureg.TRAINERNAME);
                cmd.Parameters.AddWithValue("@COURSEIMPORTANCE", coureg.COURSEIMPORTANCE);
                cmd.Parameters.AddWithValue("@DURATIONINHOURS", coureg.COURSEDURATIONINHRS);
                Connection();
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    outputclass.Count = i;
                }
                return(outputclass);
            }
            catch (Exception ex)
            {
                outputclass.Msg = ex.ToString();
                return(outputclass);
            }
            finally
            {
                conn.Close();
            }
        }