Beispiel #1
0
        /// <summary>
        /// Xóa mẫu tin hỏi đáp
        /// </summary>
        /// <param name="o"></param>
        public static void Delete(FAQs o)
        {
            DBHelp db = new DBHelp();

            db.AddParameter("@FAQID", o.FAQID);
            db.ExecuteNonQuery("sp_FAQ_Delete", CommandType.StoredProcedure);
        }
Beispiel #2
0
        /// <summary>
        /// Thêm mới mẫu tin hỏi đáp
        /// </summary>
        /// <param name="o"></param>
        public static void Insert(FAQs o)
        {
            DBHelp db = new DBHelp();

            db.AddParameter("@Title", o.Title);
            db.AddParameter("@Description", o.Description);
            db.AddParameter("@CreateDate", DateTime.Now.ToShortDateString());
            db.AddParameter("@CreateUser", o.CreateUser);
            db.ExecuteNonQuery("sp_FAQ_Insert", CommandType.StoredProcedure);
        }
Beispiel #3
0
        /// <summary>
        /// Cập nhật mẫu tin hỏi đáp
        /// </summary>
        /// <param name="o"></param>
        public static void Update(FAQs o)
        {
            DBHelp db = new DBHelp();

            db.AddParameter("@FAQID", o.FAQID);
            db.AddParameter("@Title", o.Title);
            db.AddParameter("@Description", o.Description);
            db.AddParameter("@EditDate", DateTime.Now.ToShortDateString());
            db.AddParameter("@EditUser", o.EditUser);
            db.ExecuteNonQuery("sp_FAQ_Update", CommandType.StoredProcedure);
        }
Beispiel #4
0
        /// <summary>
        /// Truy xuất toàn bộ bảng hỏi đáp
        /// </summary>
        /// <param name="o"></param>
        /// <returns></returns>
        public static FAQs GetByID(FAQs o)
        {
            FAQs   obj = new FAQs();
            DBHelp db  = new DBHelp();

            db.AddParameter("@FAQID", o.FAQID);
            SqlDataReader reader = db.ExecuteReader("sp_FAQ_Select", CommandType.StoredProcedure);

            if (reader.Read())
            {
                obj = new FAQs(reader);
            }
            reader.Close();
            return(obj);
        }