public static void insert(string text, string textOld, string reference, string survey) { using (SqlConnection objConnection = Nuce_Common.GetConnectionD()) { if (objConnection == null) { return; } try { //Execute select command Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(objConnection, "Nuce_KS_OutputText_insert", text, textOld, reference, survey); } catch { return; } } return; }
public static DataTable get() { using (SqlConnection objConnection = Nuce_Common.GetConnection()) { if (objConnection == null) { return(null); } try { //Execute select command string strSql = string.Format(@"SELECT * FROM [dbo].[AS_Edu_Survey_ReportTotal] where (QuestionId=41 or QuestionId=42 or QuestionId=43) and Value is not null"); return(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(objConnection, CommandType.Text, strSql).Tables[0]); } catch { return(null); } } }
public static DataSet getThongKe2018() { using (SqlConnection objConnection = Nuce_Common.GetConnectionD()) { if (objConnection == null) { return(null); } try { //Execute select command string strSql = string.Format(@"dnn_Nuce_KS_OutputText_GetThongKe_2018"); return(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(objConnection, strSql)); } catch { return(null); } } }
public static DataTable getSubject() { using (SqlConnection objConnection = Nuce_Common.GetConnection()) { if (objConnection == null) { return(null); } try { //Execute select command string strSql = string.Format(@"SELECT * FROM [dbo].[AS_Academy_Subject]"); return(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(objConnection, CommandType.Text, strSql).Tables[0]); } catch { return(null); } } }