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));
}