public void EditTerm(mst_term mst)
        {
            try
            {
                using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
                {
                    string query = @"UPDATE mst_term 
                                    SET
                                        term_name = @term_name
                                    WHERE
                                        term_id = @term_id
                                            AND session = (SELECT
                                                session
                                            FROM
                                                mst_session
                                            WHERE
                                                session_finalize = 'Y')";

                    con.Execute(query, mst);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public void AddTerm(mst_term mst)
        {
            try
            {
                using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
                {
                    mst_sessionMain sess = new mst_sessionMain();

                    string query = "INSERT INTO mst_term (session,term_id,term_name) VALUES (@session,@term_id,@term_name)";

                    string maxid = @"SELECT 
                                        IFNULL(MAX(term_id), 0) + 1
                                    FROM
                                        mst_term
                                    WHERE
                                        session = (SELECT
                                                session
                                            FROM
                                                mst_session
                                            WHERE
                                                session_finalize = 'Y')";

                    //                var id = con.Query<mst_section>(maxid).ToString().Trim();

                    int id = con.ExecuteScalar <int>(maxid);


                    mst.term_id   = id;
                    mst.term_name = mst.term_name.Trim();
                    mst.session   = sess.findFinal_Session();
                    con.Execute(query, new
                    {
                        mst.session,
                        mst.term_id,
                        mst.term_name
                    });
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }