public string Delete_DB(int IDX, int UPDATE_USER) { string rtnValue = string.Empty; int okCnt = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq(); okCnt = dacBscFaq.Delete_DB(conn, trx, IDX, UPDATE_USER); trx.Commit(); } catch (Exception ex) { rtnValue = ex.Message; trx.Rollback(); } finally { conn.Close(); } return(rtnValue); }
public string Insert_DB(int FAQ_CATEGORY , string FAQ_QUESTION , string FAQ_ANSWER , int CREATE_USER) { string rtnValue = string.Empty; int okCnt = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq(); okCnt = dacBscFaq.InsertData_DB(conn, trx, FAQ_CATEGORY, FAQ_QUESTION, FAQ_ANSWER, CREATE_USER); trx.Commit(); } catch (Exception ex) { rtnValue = ex.Message; trx.Rollback(); } finally { conn.Close(); } return(rtnValue); }
public DataTable SelectBscFaqIdxAll(int IDX) { MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq(); return(dacBscFaq.SelectBscFaqIdxAll(IDX)); }
public DataTable SelectBscFaqCateAll(int faq_category) { MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq(); return(dacBscFaq.SelectBscFaqCateAll(faq_category)); }
public DataTable SelectBscFaqAll(string question) { MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq(); return(dacBscFaq.SelectBscFaqAll(question)); }